Re: Export Big / Import Smaller

Hi Neil,
Try Precreating those Big Tables with Smaller Size Extents(Dont worry about Objects running into Multiple extents) in the Test Database before Importing.That would solve the Problem.

To get the Scripts for Precreating the Tables , Do a Import indexfile=precreate.sql rows=n
and edit this File to modify the Storage Characterstcs of the Big Objects and Run it against the Test DB before actually importing the DATa..

-Thiru

Neil Cudd wrote:

> 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:45:44 CDT