Oracle Database Discussions

Hi All,

Today I read somewhere to use of indexfile which will imporve in performance of import.

I do as mentioned below:

1) exp scott/tiger full=y file=scott.dmp( take 2ndoption USER for export)
2) imp test/test file=scott.dmp full=y indexfile=index.sql
--- imp skip the table with message eg. skiping table during imp
--- once imp finish, open index.sql file and add password at connect statment and remove all comments for create and alter table...
--- run this index.sql on sql prompt ...gives msg as table created and alterd but there is not any data in table.

So what to do now if I want table's record also ?

That might be impact on performance on big database but what about data?

Can any one suggest me?

Thanks...