Oracle Database Discussions

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!

External tables using datapump import

591186Aug 6 2007 — edited Feb 28 2008

Hi,

I have created an external table from my source DB. The table is created successfully with data.
Now, i am moving the dump file to another DB(different machine).

I have tried importing the dumpfile into another database using Datapump Import and getting an error

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "/hca200/appl/oracle/scnv2/s_evt_act_ex.ext".

Can anyone tell how can i move the data from the external table into an existing table within the database. The metadata of the tables are same.

Rgds
Anantha

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2008

Added on Aug 6 2007

#general-database-discussions

12 comments

3,761 views