Re: How do you create a small version of a large database ?

"Richard Elliott" <richard.a.elliott_at_williams.com> wrote in message news:8c132b3c.0403301134.5258b0df_at_posting.google.com...
| I want to create a much smaller version of an existing database. I was
| planning on just using export/import with import being objects only,
| no data. The data was going to be loaded with custom sql to select a
| specific subset of the existing database via a BD link. The export
| however creates DDL that has the large extent sizes and these fail
| when being created in the smaller instance since there is not enough
| space in the table spaces. I am trying to create a database that is
| 10% the size of another. I can't edit the export text ( to adjust the
| DDL) without causing it to be corrupt. How else can this be done ?
|
|
| Thanks in advance for the help.

look into dbms_metadata to generate the ddl statements, then apply the appropriate logic to the results to modify the storage parameters

or, if you don't have 9i (version number missing in OP), use a tool to generated the DDL (TOAD does this, as do tools mentioned in other posts) or roll your own routine to generate modified DDL based on the data dictionary views

;-{ mcs Received on Wed Mar 31 2004 - 05:46:50 CST