Home » RDBMS Server » Server Utilities » Skip empty tables while export
Skip empty tables while export [message #524318] Thu, 22 September 2011 23:35 Go to next message
manishsri0106
Messages: 6
Registered: February 2011
Location: India
Junior Member

How can we skip empty tables when we are doing export.
Re: Skip empty tables while export [message #524319 is a reply to message #524318] Thu, 22 September 2011 23:43 Go to previous messageGo to next message
BlackSwan
Messages: 26625
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>How can we skip empty tables when we are doing export.
it occurs automagically with V11

Re: Skip empty tables while export [message #524320 is a reply to message #524319] Thu, 22 September 2011 23:45 Go to previous messageGo to next message
manishsri0106
Messages: 6
Registered: February 2011
Location: India
Junior Member

But how can we do it in oracle 10g.
Re: Skip empty tables while export [message #524322 is a reply to message #524320] Thu, 22 September 2011 23:50 Go to previous messageGo to next message
BlackSwan
Messages: 26625
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>But how can we do it in oracle 10g.
V10 is no longer under full support so you could upgrade.

Why does it matter?
What is requirement to skip empty tables?

Re: Skip empty tables while export [message #524325 is a reply to message #524322] Thu, 22 September 2011 23:55 Go to previous messageGo to next message
manishsri0106
Messages: 6
Registered: February 2011
Location: India
Junior Member

I have to move only no empty tables from production to test.
Re: Skip empty tables while export [message #524326 is a reply to message #524325] Fri, 23 September 2011 00:00 Go to previous messageGo to next message
BlackSwan
Messages: 26625
Registered: January 2009
Location: SoCal
Senior Member
>I have to move only no empty tables from production to test.
why do you have empty tables in Production?
If it is OK for empty tables in Production, why should they not be moved to test?
Re: Skip empty tables while export [message #524334 is a reply to message #524320] Fri, 23 September 2011 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 66687
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use EXCLUDE with Data Pump (of course you have to know what to exclude).

Regards
Michel
Re: Skip empty tables while export [message #524401 is a reply to message #524326] Fri, 23 September 2011 08:37 Go to previous message
joy_division
Messages: 4947
Registered: February 2005
Location: East Coast USA
Senior Member
BlackSwan wrote on Fri, 23 September 2011 01:00
>I have to move only no empty tables from production to test.
why do you have empty tables in Production?
If it is OK for empty tables in Production, why should they not be moved to test?


Or you could move them then drop them later. QED.
Previous Topic: Data Pump job parameters
Next Topic: how to know dmp file contents
Goto Forum:
  


Current Time: Sun Nov 17 18:43:11 CST 2019