|
-
Oracle 10g mpdb,expdb
I am trying to do an import and export from Oracle 10g instatnce to the same instance.
I created a directory at the OS level c:\test_dir
sql>connect sys/passwd@orcl10g as sysdba
sql>alter user scott identified by tiger account unlock;
sql>Grant create any directory to scott;
sql>create or replace director example_dir as 'c:\test_dir\';
sql>Grant read,write on directory example_dir to scott;
oracle>expdb scott\tiger@orcl10g schemas=scott directory=test_dir dumpfile=expdbscott.log logfile=expdbemp_dept.log
and this created a dump file in c:\test_dir
now can you help me to import this to HR Schema with the impdb commands.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|