Home » RDBMS Server » Server Administration » Schema Splitting (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
Schema Splitting [message #496870] Wed, 02 March 2011 16:35 Go to next message
oruorainfo
Messages: 46
Registered: May 2010
Member
Hello, would like your help/advise please. Thanks.

Presently have one instance, one Schema on my DB Server. Want to split the existing schema into 3 logical divisions. Have created the 3 Schemas. Through Oracle Export from the old Schema am able to Export (using wild cards) the tables and indices for each grouping and am able to Import into the new specific schema. The problem i'm having is that i cannot seem to Export the specific sequences due for each of the new schemas. Is there an easy way to accomplish this? Can it also be done for packages, views, etc.

Thanks.

Report message to a moderator

Re: Schema Splitting [message #496879 is a reply to message #496870] Wed, 02 March 2011 18:31 Go to previous messageGo to next message
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/

Report message to a moderator

Re: Schema Splitting [message #496885 is a reply to message #496879] Wed, 02 March 2011 20:00 Go to previous messageGo to next message
oruorainfo
Messages: 46
Registered: May 2010
Member
Dear BlackSwan, my apologies, what did i miss...? Thanks.

Report message to a moderator

Re: Schema Splitting [message #496887 is a reply to message #496885] Wed, 02 March 2011 20:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you do not specify the rules that govern which objects should reside in which schema, no assistance from here is possible.

>Want to split the existing schema into 3 logical divisions
are these "logical divisions" the object names starting with a-i, j-q, & r-z?

Just import the base schema multiple times & DROP what you do need to remain.

Report message to a moderator

Re: Schema Splitting [message #496904 is a reply to message #496870] Thu, 03 March 2011 00:45 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
You need to use INCLUDE=SEQUENCE on your Data Pump export command.

Report message to a moderator

Re: Schema Splitting [message #496994 is a reply to message #496887] Thu, 03 March 2011 09:37 Go to previous messageGo to next message
oruorainfo
Messages: 46
Registered: May 2010
Member
Thank you BlackSawn. We had tried this initially, but because the original Schema was so large (which is why we are spltting it) it was alot of work involved afterwords with the many drops, so we were looking for an easier way if possible. Thanks again..

Report message to a moderator

Re: Schema Splitting [message #496995 is a reply to message #496904] Thu, 03 March 2011 09:39 Go to previous message
oruorainfo
Messages: 46
Registered: May 2010
Member
Thank you John Watson! We will give this a try! Will advise how it works! Thanks again...

Report message to a moderator

Previous Topic: Number of PGAs
Next Topic: DEFAULT COUNT OF Oracle 11g Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 06:59:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.