My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 12: Move schema to another schema using expr and impr
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  ntanh...@gmail.com


 
Project Member Reported by ntanh...@gmail.com, Sep 30, 2014
What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Sep 30, 2014
Project Member #1 ntanh...@gmail.com
Create a folder to store dump file when export. grant full privilege for the folder
Sep 30, 2014
Project Member #2 ntanh...@gmail.com
create directory for user
create directory exp_dump as '/home/eicweb/dump';
select directory_name, directory_path from dba_directories where directory_name='EXP_DUMP';
GRANT READ,write ON DIRECTORY EXP_DUMP TO htqlcv2;
select grantee, privilege, table_name from dba_tab_privs where table_name='EXP_DUMP';
Sep 30, 2014
Project Member #3 ntanh...@gmail.com
Export

expdp htqlcv2/admin directory=EXP_DUMP dumpfile=export.dmp logfile=export.log schemas=htqlcv2;
Sep 30, 2014
Project Member #4 ntanh...@gmail.com
Grant the import permission

grant imp_full_database to htqlcv2;
Sep 30, 2014
Project Member #5 ntanh...@gmail.com
Import the exported file to new schema

impdp htqlcv2/admin@XE file=export.dmp directory=EXP_DUMP fromuser=htqlcv2 touser=htqlcv3

Powered by Google Project Hosting