Re: Import with new table & index extent sizes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 01 Sep 2000 21:46:48 +0800
Message-ID: <39AFB348.338_at_yahoo.com>


wegorz wrote:
>
> >imp <user/pass> file=... full=y indexfile=myschema.sql
>
> This way is a good way, but I could not find this in imp/exp manual.
>
> There is another way: you can grep dump file just like that:
>
> cat file.dmp | grep 'CREATE TABLE' > create_table.sql;
> cat file.dmp | grep 'CREATE INDEX' > create_index.sql;
>
> All you have to do is to add semicolons at the end of each line - now you
> can modify INITIAL parameter in STORAGE clause. Of course constraints
> definitions left, but during import rest of table definitions is done.
>
> --
> Andrew Rajczakowski
> DBA, Winuel SA, Poland

I've used this many times, but be careful of tables with lots of columns or partitioned objects, since some grep's can't handle the length of the line in the file...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Fri Sep 01 2000 - 15:46:48 CEST

Original text of this message