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.
Printable View
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
[QUOTE=murugan_learn;26080]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.[/QUOTE]
Importing dump file u specify log file to find error
i.e., imp scott/tiger file=dummy.dmp log=c:\dummy.log full=y ignore=y
To import a particular table from .dmp file then use
imp scott/tiger file=dummy.dmp tables=TABLENAME ignore=y fromuser=scott
touser=scott