Oracle import question

[uadmin]

Dear All,

I have created a full export of my database instance which is held under '/u01/app/oracle/prodb/export' and I want to restore to my database only a certian users tables which when I query are about 10 tables in total.

If I issue for say example 'imp scott/tiger FILE=dba.dmp FROMUSER=scott TOUSER=scott' will I have to use the parameter 'TABLES=(dept,emp)' but state all 10 table names in this were for example I have 'dept,emp'.

Thanks





Simon Peter Wickham
Email: s.wickham@zoom.co.uk

 

[Beilstwh]

You do NOT use the formuser and touser if the schema is the same. Simply run imp interactivally and when it asks for the user, specify scott and when it wants to know what table to restore, simply type in the tables to restore.

Bill
Oracle DBA/Developer
New York State, USA

 

[uadmin]

Thanks I created a parfile with all the parameters.



Simon Peter Wickham
Email: s.wickham@zoom.co.uk