cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Export and Import dump from oracle - Issue

skuppamohanram
10-Marble

Export and Import dump from oracle - Issue

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 3

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

Here is the command...

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

Infact it was working with Windchill 10.2 M030, but not with Windchill 11.0

Top Tags