This content has been marked as final. Show 9 replies
what your r trying to do exaxtly?
going to import? then what type of import..?
going to restart the job? then job_name?
HI..1 person found this helpful
impdp user/pwd directory=impdir dumpfile=banks.dmp logfile=impdp.logYou haven't mentioned full=y or remap_schema parameter.
I'm using datapump (impdp) so I think there is no requirement of defining 'full=y' or 'remap schema'
hi,1 person found this helpful
I'm using datapump (impdp) so I think there is no requirement of defining 'full=y' or 'remap schema'why do you think? what kind of impdp your doin.. eithe table.schema or full database..
without giving anything only with the dump file how will your import proceed..
you have to specify either schemas or full or table paramters.. better see impdp help=y and check the params..
Hi,1 person found this helpful
Come on Sir, Due to think import dump package can understand implicitly what type of import we are performing, still @that stage we did not went through, where if we dream the things and it might have happened immediately still time is there, we need to provide some mandatory things.
- Pavan Kumar N
Oracle 9i/10g - OCP
I just use the command to export a schema from a source database
expdp schema_name/pass directory=<dir name> dumpfile= dumpfile.dmp logfile=logfile_name.log
To import the schema dump, I use the following command
impdp schema_name/pass directory=<dir name> dumpfile= dumpfile.dmp logfile=logfile_name.log
And, When i tried to import the schema again, the error disappeared.
And pls tell me Is this also a way to take schema backup???
Thanks for your support. And please guide me if there is something further.
Edited by: KSG on Dec 29, 2009 5:26 PM
that's the right way to do you. hope you understood ... close the thread if answered..
Pls Tell me, Am i wrong?
I hope this forum is not only for giving right answers but sharing knowledge too
Edited by: KSG on Dec 29, 2009 5:28 PM
yes the method is correct.. use the keyword schemas for schema export
for furher please read oracle document