Issue 12: Move schema to another schema using expr and impr
Status:  Accepted
Owner:
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