Re: [8i] How to resize an export file

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 27 Mar 2002 00:41:34 -0000
Message-ID: <3ca228b9$1_2@mk-nntp-1.news.uk.worldonline.com>

"Frederic Payant" <fpayant_at_club-internet.fr> wrote in message news:3fo1au4mi1nbn6sbhkcacnprg8mpmsnoac_at_4ax.com...
> Hi,
>
> Still on Oracle 8i with Solaris 8 :
>
> Is it possible, simply, to modify an exp file in order to obtain
> modify sizes of tablespaces and files extents?
>
> I obtained from production an export file with no data (I don't need
> them as I'm only interested in data structures) but I can't use it
> because sizes of TBS and of INITIAL segments are huge and neatly
> greater than my disks. How could I alter export file to modify these
> sizes ?
>
> Thanks all.
>
>
> Regards
> Frederic PAYANT - junior DBA ;-)

Frederic,

If you don't need the data, only the structures, look at INDEXFILE. You'll need to RTFM and do some editing, but it will give you some scripts to start from.

HTH,
Paul Received on Tue Mar 26 2002 - 18:41:34 CST