Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing tables and data

C PatelFeb 26 2009 — edited Feb 26 2009

Hi! I'm relatively new to XE and exporting/importing in general. I managed to create a dump from an Oracle 10.2.0.3.0 database and want to import into Ora10gXE 10.2.0.1.0. Should this be possible? I understand that import may not work when the versions are different, but I'm not sure if this is the case or not.

I executed the following, but get the error message below: C:\>impdp system/**** SCHEMAS=mldev DIRECTORY=dmpdir DUMPFILE=my_table_export.dmp REMAP_SCHEMA=bopdev:mldev TABLE_EXISTS_ACTION=replace LOGFILE=imp_rh_table_export.log

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "c:\temp\my_export.dmp" may be an original export dump file

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 26 2009

3 comments

4,012 views