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