學習數(shù)據(jù)遷移之imp

查詢數(shù)據(jù)庫語言及字符集

select userenv('language') from dual;

select * from nls_database_parameters #服務(wù)器

select * from nls_instance_parameters #客戶端

select * from nls_session_parameters #會話

查看dump文件導出信息

strings bak20190315.dmp |head -10

strings bak20190315.dmp | grep "CREATE TABLE" | awk '{print $3}'| sed 's/"//g'   #表

cat exp.dmp |od -x|head -1|awk '{print $2 $3}'|cut -c 3-6 #查看字符集代碼

select nls_charset_name(to_number('0354','xxxx')) from dual; #代碼轉(zhuǎn)換成名稱

create user note identified by luoluo; #建用戶授權(quán)

grant connect,resource to note;

select name from v$datafile; #查詢數(shù)據(jù)文件路徑

create tablespace note datafile='/u01/app/oracle/oradata/orcl/note01.dbf' size 31G;  #新建表空間

alter tablespace note add datafile='/u01/app/oracle/oradata/orcl/note02.dbf' size 31G;

alter tablespace note add datafile='/u01/app/oracle/oradata/orcl/note03.dbf' size 31G;

alter tablespace note add datafile='/u01/app/oracle/oradata/orcl/note04.dbf' size 31G;

alter user note default tabspace note; #修改用戶默認表空間

imp system/ORACLE12C  file=/mnt/data/bak20190315.dmp FROMUSER=NOTE

參考鏈接

https://www.cnblogs.com/lipera/p/6201434.html

https://www.cnblogs.com/lhrbest/p/6832707.html

https://www.cnblogs.com/rootq/articles/2049324.html