This content has been marked as final. Show 8 replies
If you use expdp, then your only tool is impdp.
Only Datapump Import
Can I do this?
I have a dump file. Can I load data from it using external tables?
Like I said. If you use expdp, then your ONLY tool is impdp. You can't use external tables directly. You can force external tables from data pump, but you are using impdp.
To force external tables add
To your impdp command.
which means if i have a dump from expdp it can only be imported with impdp
and if have a dump with external table it can only be loaded with external tables?
Yes for data pump, but I don't know how you could take a dump with external tables.
create table external
as select * from table-name;
The .dmp file here can only be load with external table option, and not with impdp. Is that right?
Yes. Impdp only recognizes expdp dump files. You can't mix either way.1 person found this helpful