Re: Yet another Export Question!

badri_at_cc.gatech.edu (badri) writes:

>Hi:
 

> I had already posted this before, but could not
>get a bullte-proof answer. Excuse me for reposting:
 

> I have a production database and I just
>want the schema to be exported to another test database.
>The test db has one table space, large enough to hold
>table definitions (not data). I do not want additional
>tablespaces created.
 

> When I asked how this could be done, I was told that
>I could export with rows=n compress=n so that the schema
>would export with the initial extent and then use
>sed to alter the initial extents. How would I deal with tablespace
>creation commands in the begining of the export file? I don't
>want those.
 

>Any comments/suggestions would be greatly appreciated,
 

>-Badri

Well, you could export only the tables from the production system. In that case no table space definitions are included. Read the export manual, see 'table exports'.

Good luck,

Roeland Loggen

-- 
// ===========================================================================
// Roeland Loggen (rlogg_at_ctp.com)  After being built and asked "is there a god" 
// Cambridge Technology Partners   the supercomputer replied "well......
// Cambridge MA   (617)-374-8788   there wasn't one, but now there is"