Home » RDBMS Server » Server Utilities » stored procedure for creating a new schema from an old one
stored procedure for creating a new schema from an old one [message #404449] Thu, 21 May 2009 19:45 Go to next message
nash12
Messages: 8
Registered: May 2009
Junior Member
I need to have a stored procedure for creating a new schema from an old one. I am aware of the conventional method that we follow of creating a new schema and importing the dump of the old schema,but this is a special requirement wherein i need to create a stored procedure for that. Can somebody help?
Re: stored procedure for creating a new schema from an old one [message #404454 is a reply to message #404449] Thu, 21 May 2009 20:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> Can somebody help?
Reinventing exp/imp will be a LOT of work to properly handle all possible DB object types.

What version of Oracle to 4 decimal places is involved?
Re: stored procedure for creating a new schema from an old one [message #404458 is a reply to message #404454] Thu, 21 May 2009 20:18 Go to previous messageGo to next message
nash12
Messages: 8
Registered: May 2009
Junior Member
The version is 10.1.0.2.0
Re: stored procedure for creating a new schema from an old one [message #404463 is a reply to message #404449] Thu, 21 May 2009 20:27 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
DBMS_METADATA.GET_DDL is one place to start.
V10.1.0.2 is/was a buggy, buggy version.

It is your hole & if you want to keep digging, nobody can stop you!

IMO, an OS scipt using exp/imp will be easier to write & much less error prone than 1 off code you cobble together.

Previous Topic: Error of Import [Full=Y]
Next Topic: Import Views and Functions from dump file
Goto Forum:
  


Current Time: Thu Mar 28 19:48:25 CDT 2024