I had to export only tables from a schema
My export script:
exp sys/oracle file=home/oracle/PT_ow1.dmp log=/home/oracle/PT_ow1.log tables=manju1,manju2 rows=yes indexes=yes
Error
EXP-00011
Tried Datapump :But some different error
Solution:Point your schema name to that particular tablename
example
tables=schemaname.tablename ,schemaname.tablename
My modified export script:
exp sys/oracle file=home/oracle/PT_ow1.dmp log=/home/oracle/PT_ow1.log tables=pt_ow.manju1,pt_ow.manju2 rows=yes indexes=yes
It worked"
No comments:
Post a Comment