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

In article <3fo1au4mi1nbn6sbhkcacnprg8mpmsnoac_at_4ax.com>, Frederic says...
>
>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 ;-)

imp userid/password full=yes indexfile=foobar.sql

it'll not actually import, it'll just create a script file foobar.sql. Edit that, uncomment the tables of interest (delete the objects of no interest). Run foobar.sql to precreate the objects and then:

imp userid/password full=yes IGNORE=yes

and it'll import into your pre-created objects.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp