DMP导入导出

导出版本：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