Reverse Engineer Schema [message #409811] |
Wed, 24 June 2009 03:04 |
kheat
Messages: 4 Registered: November 2008
|
Junior Member |
|
|
Hi All,
We require a script to extract all the objects in a schema and store it in a folder wise sequence.
ie.
On running the procedure/package the output would be like
<SchemaName>
<Tables>
<SchemaName>.<TableName1>
<SchemaName>.<TableName2>
<Views>
<Indexes>
and so on.
Basically every file would be the create script for that object.
|
|
|
Re: Reverse Engineer Schema [message #409813 is a reply to message #409811] |
Wed, 24 June 2009 03:11 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Look at the DBMS_METADATA package. You are unlikely to get someone to just give you the full answer here. At OraFAQ we tend to look to you to do some/most of your own work, and offer support and advice when you get stuck. Much of the support and advice constitutes pointing you towards the appropriate documentation or towards useful keywords to search for.
Good luck. And remember, do ask questions when you run across problems but bear in mind you might not always get the exact answer back.
|
|
|
|
Re: Reverse Engineer Schema [message #409993 is a reply to message #409811] |
Wed, 24 June 2009 14:52 |
kheat
Messages: 4 Registered: November 2008
|
Junior Member |
|
|
How will we be able to extract this folderwise? We understand that using the dbms_metadata.get_ddl would allow us to get the objects source code but how do we create a single script which would run through the schema and store them in a directory listing mode?
|
|
|
|
|
Re: Reverse Engineer Schema [message #410372 is a reply to message #409993] |
Fri, 26 June 2009 10:44 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Or you could just output objects into names that made it clear what soert of object they were, and move them by hand.
Is it me, or does doing actual work seem to be getting unfashionable these days?
|
|
|