Creating a development database

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 Wed Jan 17 2001 - 15:43:26 CST