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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- partition timestamp(0) not use partition
- using dbms_file_transfer transportable tablespace between asmASM
- ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'錯誤解決
- 聊聊Oracle可傳輸表空間(Transportable Tablespace)(上)Oracle
- 聊聊Oracle可傳輸表空間(Transportable Tablespace)(中)Oracle
- 聊聊Oracle可傳輸表空間(Transportable Tablespace)(下)Oracle
- MySQL Transportable Tablespace(傳輸表空間) 使用詳解MySql
- Oracle OCP IZ0-053 Q694(Transportable Tablespace)Oracle
- How To Recreate A Database Using TTS (Transportable TableSpace) [ID 733824.1]DatabaseTTS
- Oracle OCP 1Z0 053 Q427(Transportable Tablespace)Oracle
- Oracle OCP IZ0-053 Q425( transportable tablespace set)Oracle
- Oracle OCP 1Z0 053 Q426(transportable tablespace)Oracle
- Oracle OCP 1Z0 053 Q633(Transportable Tablespace)Oracle
- you cannot use this control in design mode。
- 利用oracle10g_rman_convert_transportable tablespace遷移表空間Oracle
- 故障分析 | MySQL 遷移後 timestamp 列 cannot be nullMySqlNull
- Golang Cannot use ss(type AAA) as type AAA in map indexGolangIndex
- ORA-01931: cannot grant UNLIMITED TABLESPACE to a roleMIT
- cannot use '/dev/da1': must be a block device or regular filedevBloC
- PHP Fatal error: Cannot use PhpParser\Node\Scalar\String as StringPHPError
- Msg 3702:Cannot drop the database 'gcard' because it is currently in use.DatabaseGC
- ORA-19550: cannot use backup/restore functions while using dispatcherRESTFunctionWhile
- Workspace in use or cannot be created, choose a different one.--錯誤解決辦法
- ORA-22992 cannot use LOB locators selected from remote tablesREM
- ORA-01552: cannot use system rollback錯誤解決方法
- PostgreSQL DBA(110) - pgAdmin(Don't do this: Don't use timestamp without tz)SQL
- Ajax 報錯jquery-3.3.1.min.js:2 Uncaught TypeError: Cannot use 'in' operator to seajQueryJSError
- V$TRANSPORTABLE_PLATFORM;Platform
- ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DESTHive
- Oracle TTS ORA-39322: 表空間傳輸OracleTTS
- Oracle timestamp_to_scn and scn_to_timestampOracle
- tablespace 大檔案,undo,temp tablespace
- v$transportable_platform.endian_formatPlatform
- Oracle TimestampOracle
- 【轉載】Kano Model — Ways to use it and NOT use it
- mysql CURRENT_TIMESTAMP 和ON UPDATE CURRENT_TIMESTAMPMySql
- [Warning] TIMESTAMP with implicit DEFAULT --explicit_defaults_for_timestamp
- db2 sms tablespace 不支援large tablespaceDB2