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, Poland