DMP导入导出

来源：互联网发布：最热门的网络电玩城编辑：程序博客网时间：2024/06/18 18:32

导出版本：11g
oracle版本：10.1.0.2.0

expdp yaojianju/yaojianju@orcl dumpfile=expdp11g_123101.dmp logfile=expdp11g_151130.log version=10.2.0.1.0 schemas=yaojianju

/oracle/app/oracle/admin/orcl/dpdump/expdp11g_151130.dmp

create tablespace EPSSITE logging datafile '/easysite/app/oracle/oradata/orcl/EPSSITE.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create user yaojianju identified by yaojianju default tablespace EPSSITE;

grant connect,imp_full_database,resource to yaojianju;

create directory dir_dp as '/easysite/app/oracle/oradata';

grant read,write on directory dir_dp to yaojianju;

select * from dba_directories where DIRECTORY_NAME = 'dir_dp';

impdp yaojianju/yaojianju@orcl directory=dir_dp dumpfile=yaojianju_151130.dmp logfile=yaojianju_151130.log schemas=yaojianju

drop directory dir_dp;
sqlplus显示问号问题：
show parameter nls_la
　　NAME TYPE VALUE
　　------------------------------------ ----------- ------------------------------
　　nls_language string SIMPLIFIED CHINESE
　　解决方法:
　　退出sqlplus
　　在oracle用户下执行
　　export NLS_LANG=american_america.zhs16gbk
　　可以编辑 bash_profile 文件进行永久设置
　　vi .bash_profile
　　NLS_LANG=american_america.zhs16gbk export NLS_LANG

0 0