Dear friends,
I am facing a problem while importing my data.That is particular one table was not import.
Can we import the particular missing table,It is possible.If it is possible,Please
give the syntax.
Thanks.
Dear friends,
I am facing a problem while importing my data.That is particular one table was not import.
Can we import the particular missing table,It is possible.If it is possible,Please
give the syntax.
Thanks.
Dear Murugan,
We Can import the missing table seperately in the following way.
First drop that particular table from user to which you want to import the data.
Export the table using following syntax
Ex:- Exp scott/tiger file=emp.dmp tables=(emp,dept)
In brackets you specify the table names that you want to export.
Then import the dump file as usual.
imp scott/tiger file=emp.dmp full=yes
or
imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=emp
Last edited by krishnaindia2007; 02-16-2008 at 11:24 PM.