Export Big / Import Smaller

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