Skip to main content
1-Visitor
June 20, 2016
Question

Export and Import dump from oracle - Issue

  • June 20, 2016
  • 3 replies
  • 1949 views

Hello,

I have exported oracle dump and when I try to import I get the below issue..

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

IMP-00000: Import terminated unsuccessfully

Any thoughts how to resolve this issue...

3 replies

2-Explorer
June 20, 2016

Could you paste the import command which you used? It looks like multi modes were specified in the command

1-Visitor
June 21, 2016

Here is the command...

imp test/test@XE file=C:/ptc/BACKUP/install/oracleDb.dmp full=yes fromuser=test touser=system