OraFAQ Forum: Server Utilities » Skip empty tables while export

Home » RDBMS Server » Server Utilities » Skip empty tables while export

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Skip empty tables while export [message #524318]

Thu, 22 September 2011 23:35

manishsri0106
Messages: 6
Registered: February 2011
Location: India

Junior Member

How can we skip empty tables when we are doing export.

Report message to a moderator

Re: Skip empty tables while export [message #524319 is a reply to message #524318]

Thu, 22 September 2011 23:43

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Skip empty tables while export [message #524320 is a reply to message #524319]

Thu, 22 September 2011 23:45

manishsri0106
Messages: 6
Registered: February 2011
Location: India

Junior Member

But how can we do it in oracle 10g.

Report message to a moderator

Re: Skip empty tables while export [message #524322 is a reply to message #524320]

Thu, 22 September 2011 23:50

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Skip empty tables while export [message #524325 is a reply to message #524322]

Thu, 22 September 2011 23:55

manishsri0106
Messages: 6
Registered: February 2011
Location: India

Junior Member

I have to move only no empty tables from production to test.

Report message to a moderator

Re: Skip empty tables while export [message #524326 is a reply to message #524325]

Fri, 23 September 2011 00:00

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Skip empty tables while export [message #524334 is a reply to message #524320]

Fri, 23 September 2011 01:03

Michel Cadot
Messages: 68501
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

Report message to a moderator

Re: Skip empty tables while export [message #524401 is a reply to message #524326]

Fri, 23 September 2011 08:37

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Data Pump job parameters
Next Topic:	how to know dmp file contents

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 06:32:54 CDT 2023