Gurus/Members
I have a full db export dump file 'fullexp.dmp', and want to import only the scott schema objects from this dump into the database from the full dump file. Can someone please give me the syntax to do this? Thanks a lot!!
Printable View
Gurus/Members
I have a full db export dump file 'fullexp.dmp', and want to import only the scott schema objects from this dump into the database from the full dump file. Can someone please give me the syntax to do this? Thanks a lot!!
HELLO,
1. Create the user SCOTT and grant him the right privileges.
2. Use the option FROMUSER when invoking IMP command :
IMP login/passwd FROMUSER=SCOTT others_options...
Hope this helps...
Regards
NOOR