| 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 |
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
Sep 30, 2014
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
Export expdp htqlcv2/admin directory=EXP_DUMP dumpfile=export.dmp logfile=export.log schemas=htqlcv2;
Sep 30, 2014
Grant the import permission grant imp_full_database to htqlcv2;
Sep 30, 2014
Import the exported file to new schema impdp htqlcv2/admin@XE file=export.dmp directory=EXP_DUMP fromuser=htqlcv2 touser=htqlcv3 |