ORA-39322: Cannot use transportable tablespace with timestamp with timezone...
源庫: Oracle 11.2.0.1 , EBS R12.1.3 , AIX , 雙節點, RAC
目標庫: Oracle 11.2.0.3 , EBS R12.1.3 , Linux , 15節點RAC .
目的: 將EBS系統轉換系統平臺為Linux , 使用傳輸表空間方式 。
在匯入傳輸表空間dmp檔案的時候, 發現兩邊的DST timezone版本不一樣。
impdp "'/ as sysdba'" parfile=new_impxtts.dat
引數檔案如下: new_impxtts.dat
directory=dmpdir
dumpfile=xttsmeta%U.dmp
logfile=impxtts.log
exclude=TYPE
metrics=y
transport_datafiles=
'+DATA/gerp/datafile/ahld.1299.825200785',
.....
'+DATA/gerp/datafile/aox01.3391.825258383'
報錯資訊:
[oracle@fu07db expimp]$ more impxtts.log
;;;
Import: Release 11.2.0.3.0 - Production on Sun Sep 15 21:35:47 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
ORA-39322: Cannot use transportable tablespace with timestamp with timezone columns and different timezone
version.
查詢目標端的版本:
SQL> SELECT NAME,VALUE$ FROM PROPS$ WHERE NAME='DST_PRIMARY_TT_VERSION';
NAME VALUE$
-------------------------------------------------------
DST_PRIMARY_TT_VERSION 14
查詢源端的版本:
SQL> SELECT NAME,VALUE$ FROM PROPS$ WHERE NAME='DST_PRIMARY_TT_VERSION';
NAME VALUE$
----------------------------------------------------
DST_PRIMARY_TT_VERSION 4
目標庫: Oracle 11.2.0.3 , EBS R12.1.3 , Linux , 15節點RAC .
目的: 將EBS系統轉換系統平臺為Linux , 使用傳輸表空間方式 。
在匯入傳輸表空間dmp檔案的時候, 發現兩邊的DST timezone版本不一樣。
impdp "'/ as sysdba'" parfile=new_impxtts.dat
引數檔案如下: new_impxtts.dat
directory=dmpdir
dumpfile=xttsmeta%U.dmp
logfile=impxtts.log
exclude=TYPE
metrics=y
transport_datafiles=
'+DATA/gerp/datafile/ahld.1299.825200785',
.....
'+DATA/gerp/datafile/aox01.3391.825258383'
報錯資訊:
[oracle@fu07db expimp]$ more impxtts.log
;;;
Import: Release 11.2.0.3.0 - Production on Sun Sep 15 21:35:47 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
ORA-39322: Cannot use transportable tablespace with timestamp with timezone columns and different timezone
version.
查詢目標端的版本:
SQL> SELECT NAME,VALUE$ FROM PROPS$ WHERE NAME='DST_PRIMARY_TT_VERSION';
NAME VALUE$
-------------------------------------------------------
DST_PRIMARY_TT_VERSION 14
查詢源端的版本:
SQL> SELECT NAME,VALUE$ FROM PROPS$ WHERE NAME='DST_PRIMARY_TT_VERSION';
NAME VALUE$
----------------------------------------------------
DST_PRIMARY_TT_VERSION 4
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-772742/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 11g-Reduce Transportable Tablespace Downtime using XTTS (Doc ID 1389592.1)TTS
- 故障分析 | MySQL 遷移後 timestamp 列 cannot be nullMySqlNull
- PostgreSQL DBA(110) - pgAdmin(Don't do this: Don't use timestamp without tz)SQL
- cannot use '/dev/da1': must be a block device or regular filedevBloC
- Ajax 報錯jquery-3.3.1.min.js:2 Uncaught TypeError: Cannot use 'in' operator to seajQueryJSError
- Oracle TimestampOracle
- Oracle OCP(48):UNDO TABLESPACEOracle
- MySQL 5.7 InnoDB Tablespace EncryptionMySql
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- TIMESTAMP和TIMESTAMP WITH TIME ZONE之間的總結
- partitioned by timestamp datatype
- Tablespace表空間刪除
- 【轉載】Kano Model — Ways to use it and NOT use it
- python3 tkinter報錯:_tkinter.TclError: cannot use geometry manager pack inside . which already has slaves managed by gridPythonErrorIDE
- JavaScript event.timeStampJavaScript
- MySQL: datetime vs timestampMySql
- 7.71 CURRENT_TIMESTAMP
- offline tablespace 的幾種方式 (轉)
- nginx useNginx
- [20190531]Timestamp Oddity.txt
- mysql5.7 General tablespace使用說明MySql
- alter tablespace ts_name autoextend_clause
- 【TABLESPACE】Oracle表空間最佳實踐Oracle
- 完全可傳輸的匯出/匯入(full transportable export/import)ExportImport
- Be better to use NPMNPM
- WireGuard Use Notes
- plsql use skillsSQL
- 2.6.8.2 UNDO_TABLESPACE 初始化引數
- unlimited tablespace許可權的授予和回收MIT
- 【TABLESPACE】Oracle 表空間結構說明Oracle
- ×tamp變成×tamp問題
- muduo網路庫Timestamp類
- MySQL中的CURRENT_TIMESTAMPMySql
- mysql timestamp比較查詢MySql
- ON UPDATE CURRENT_TIMESTAMP請慎用
- mysql 資料型別TIMESTAMPMySQL 資料型別
- Yii2.012 版本與 PHP7.2 不相容 (報錯 Cannot use 'Object' as class name as...) 問題的處理方法PHPObject
- [20200327]ORA-46267 Insufficient space in 'USERS' tablespace.txt
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP