oracle数据泵导出导入:
导出:
SQL> CREATE DIRECTORY dump_dir AS '/home/oracle';
$ expdp system/password directory=dump_dir dumpfile=xx.dmp logfile=expdp.log schemas=user1
导入:
SQL> CREATE DIRECTORY dump_dir AS '/../aa';
$ impdp system/oracle directory=dump_dir dumpfile=20140304last_hxb.dmp logfile=impdp.log
导入时映射表空间
$ impdp system/password directory=dump_dir dumpfile=xx.dmp logfile=impdp.log remap_tablespace=USERS:TS1
$ impdp system/password directory=dump_dir dumpfile=xx.dmp logfile=impdp.log remap_tablespace=USERS:TS1 remap_schema=USER1:USER2
删除数据库用户
drop user hxcms610 cascade;
查看数据库字符集
SQL> select userenv('language') from dual;
select * from V$NLS_PARAMETERS;
select * from props$;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载