Re: Yet another Export Question!

From: Dave Marcus <dmarcus_at_notes.cc.bellcore.com>
Date: 1996/05/07
Message-ID: <4mnvbr$j2_at_athos.cc.bellcore.com>#1/1


In article <4m2h5i$4a2_at_gaia.cc.gatech.edu>, badri_at_cc.gatech.edu says...
*>
*>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

You vsn export by tables, not by full or user you won't get the create tablespace commands. Use tables=(tablelist) Received on Tue May 07 1996 - 00:00:00 CEST

Original text of this message