Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [8i] How to resize an export file
You can't. Read my paper "Can I edit my export dump file to change storage
parameters or tablespaces?" on the Tips/Backup and Recovery page at my
website.
Regards
HJR
-- ------------------------------------------ Resources for Oracle : www.hjrdba.com ============================ "Frederic Payant" <fpayant_at_club-internet.fr> wrote in message news:3fo1au4mi1nbn6sbhkcacnprg8mpmsnoac_at_4ax.com...Received on Tue Mar 26 2002 - 15:58:28 CST
> 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 ;-)