OraFAQ Forum: Server Utilities » stored procedure for creating a new schema from an old one

Home » RDBMS Server » Server Utilities » stored procedure for creating a new schema from an old one

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

stored procedure for creating a new schema from an old one [message #404449]

Thu, 21 May 2009 19:45

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?

Report message to a moderator

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

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?

Report message to a moderator

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

nash12
Messages: 8
Registered: May 2009

Junior Member

The version is 10.1.0.2.0

Report message to a moderator

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

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 21:44:14 CST 2025