Thursday 27 June 2013

FIX-EXP-00011 Easily


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