Can someone here help me with impdp syntax to import a table with a different name in the same schema or a different schema (trying to make a copy of an existing table with BLOBS).
I was trying something similar to the below, but it didn't work.
impdp myschema/pwd directory=TEST_DIR DUMPFILE=myschema.dmp logfile=impdp.log TABLES=mytable REMAP_TABLE=mytable:mytable_test
And by the way, I tried the below too but fails with temp cannot extend...
create table myschema.mytable_test as select * from myschema.mytable;
Thanks