1.Export the contents of the table2. Recreate the table and associated index(s) with the correct INITRANS settings
user3714906 wrote:Yes, you can import using this statement. The errors you've received is explainable:
Thanks all for the reply,
And also please let me know if I take hr schema export backup using >> expdp hr/hr directory=export dumpfile=hr.dmp logfile=hr.log schemas=hr
can I simply use impdp hr/hr directory=export dumpfile=hr.dmp logfile=imp.log ?
Because on test instance I am getting some errors like object already exists and "Schema APPS is needed to import this object, but is unaccessible"
Take the export backup of hr tables (10 tables)expdp hr/hr directory=export dumpfile=table1.dmp logfile=table1.log tables=HR.table1