CREATE TABLE My_table_XT
default directory TEMP
LOCATION ( 'My_table_xt.dmp' )
select * from all_objects;
and I can select from my_table_xt.
My question is, is it possible to take a .dmp file with several tables in it and create external tables using the single .dmp?
So, you create a dmp using exp and parameter file that defines 3 tables. You put the dmp in your directory...
is it possible to easily create 3 external tables?