Home » RDBMS Server » Server Utilities » datapump
datapump [message #272533] Fri, 05 October 2007 07:50 Go to next message
sofiasimon
Messages: 5
Registered: June 2007
Junior Member
Hi,

Can i have a table level export of tables along with only the unique indexes.I dont want to specify the index names in the INCLUDE clause.Is there any other option for doing the same.

Thanks
Re: datapump [message #272747 is a reply to message #272533] Sat, 06 October 2007 23:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
HUH?
>Can i have a table level export of tables along with only the unique indexes.I dont want to specify the index names in the INCLUDE clause.Is there any other option for doing the same.

What business problem are you trying to solve & how would an independent observer know when it has been solved?
Re: datapump [message #272833 is a reply to message #272747] Sun, 07 October 2007 23:52 Go to previous messageGo to next message
sofiasimon
Messages: 5
Registered: June 2007
Junior Member
I am trying to replicate part of a schema into the DRA.so I am using table level export using datapump.But by default all indexes are also getting exported.I only want the unique indexes to get exported.so how can i avoid the non-unique indexes without specifying the names of the unique index in the INCLUDE clause or by specifying the non-unique index in the EXCLUDE clause?
Re: datapump [message #272835 is a reply to message #272533] Mon, 08 October 2007 00:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is not possible by include / exclude. When you specify include/ exclude their dependent objects also automatically exported/declined.

[Updated on: Mon, 08 October 2007 00:05]

Report message to a moderator

Re: datapump [message #272983 is a reply to message #272833] Mon, 08 October 2007 08:18 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Replicate the entire schema then drop all non-unique indexes. QED.
Previous Topic: Export Not completed
Next Topic: About Sql*Loader
Goto Forum:
  


Current Time: Thu Dec 05 20:22:06 CST 2024