Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export Big / Import Smaller

Export Big / Import Smaller

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Mon, 2 Aug 1999 16:30:47 +0100
Message-ID: <933607972.9973.0.nnrp-06.c2de6f3d@news.demon.co.uk>


Hi all,

I've had this problem before, but not the gumption to sort it to my satisfaction so I thought I'd ask you fine people :

I'm creating a test database to be a 'copy' of my production ... only I only have about a third of the disk space. So, I export with ROWS=N and I'd like to import, but before doing so I'd like to change the initial extent of each of the segments because they are far too large for my test db :-/

Is there any way (save changing the initial extent of all segments prior to export and changing them back after) to do an export and change the initial extent allocation 'on the fly' so to speak ?

Any suggestions would be warmly received.

Thanks,
Neil Cudd. Received on Mon Aug 02 1999 - 10:30:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US