This discussion is archived
1 Reply Latest reply: Nov 11, 2012 4:20 AM by Srini Chavali-Oracle RSS

Exclude Tables

Jairam Explorer
Currently Being Moderated
Hi everyone,

I am using Oracle 10g in windows 7 platform.I have tried to do an export by using the following command,

expdp "'sys/password as sysdba'" directory=dpump dumpfile=expfulltest.dmp logfile=exptestlog.log full=y exclude=table:\"in (\'USER.TABLE\')\"

But the above command do not exclude the specified table in Exclude Parameter. Anybody clarify about what could be the problem in the above command?



  • Correct Answers - 10 points
  • Helpful Answers - 5 points