Re: Creating a development database

Aaron,

You should use the show=y and indexfile=<file> options of imp. This creates a file with all ddl statements in an export. You can edit the storage parameters in this file.

hth,

Patrick Diks

Aaron wrote:
>
> That will probably work. The only problem I had with imp was that it
> kept the table and index storage values from the source database, and I
> was trying to create a smaller database for development. (I forgot to
> mention that.) How do others go about creating a smaller development
> database from a larger production one when you don't have the DDL?
>
> In article <A9k96.10670$vW4.67400_at_skycache.prestige.net>,
> "Scott Mattes" <ScottMattes_at_yahoo.com> wrote:
> > imp can recreate all the tables without loading the data, won't that
 work
> > for you?
> >
> > "Aaron" <asentell_at_my-deja.com> wrote in message
> > news:944j3p$50v$1_at_nnrp1.deja.com...
> > > I'm looking for a way to extract the sql code to create all objects
 in a
> > > database for multiple schemas. I would like to do this so that I
 can
> > > execute this script once as system, using sqlplus, and create a copy
 of
> > > the original database minus the data. This would require that the
> > > schema names be explicity specified for each object. Here's what
 I've
> > > tried so far:
> > >
> > > * TOAD: Extracts SQL, but it does not specify the schema owner in
 front
> > > of table names nor is there an option to tell it to do so.
> > >
> > > * An awk shell script that extracts the sql from exported files.
 Again,
> > > this does not specify the schema name. Even if this wasn't the
 case, it
> > > errors out under certain circumstances.
> > >
> > > * OEM Change Management Pack: Creates a script, but it is not
 executable
> > > sql. I don't know how to produce the executable sql script from
 this.
> > >
> > > Does anybody have any ideas?
> > >
> > > Thanks!
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 18 2001 - 10:35:35 CST