Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Import with new table & index extent sizes
>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, PolandReceived on Fri Sep 01 2000 - 02:52:06 CDT