溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶(hù)服務(wù)條款》
您好，登錄后才能下訂單哦！
小編給大家分享一下expdp/impdp如何使用version參數(shù)跨版本數(shù)據(jù)遷移，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！
一、問(wèn)題描述與分析：
碰到個(gè)問(wèn)題，需求是將Oracle 11g版本的數(shù)據(jù)用expdp數(shù)據(jù)泵導(dǎo)出，再把數(shù)據(jù)導(dǎo)入至Oracle 10版本中，是否可以？一個(gè)不錯(cuò)的問(wèn)題，沒(méi)做過(guò)肯定不能亂說(shuō)啦。首先我們來(lái)猜一下，我認(rèn)為低版本導(dǎo)入高版本是可以的，高版本導(dǎo)入低版本就不一定了，但是我們想想oracle公司會(huì)讓11g的庫(kù)的內(nèi)容無(wú)法導(dǎo)入到低版本嗎？答案在實(shí)驗(yàn)中，接下來(lái)我們就立即做個(gè)這個(gè)實(shí)驗(yàn)，進(jìn)行驗(yàn)證。
二、實(shí)驗(yàn)
低版本—>高版本 環(huán)境:低版本10g(10.2.0.1.0) 高版本11g(11.2.0.1.0) 猜測(cè)：可以 結(jié)論：可以
（1）10g環(huán)境中創(chuàng)建測(cè)試用戶(hù)sam，并賦予權(quán)限
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 5 19:06:25 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SYS@OCM10G >select username from dba_users where username='SAM';
no rows selected
SYS@OCM10G >create user sam identified by sam;
User created.
SYS@OCM10G >grant connect,resource to sam;
Grant succeeded.
（2）創(chuàng)建測(cè)試表test及數(shù)據(jù)
SYS@OCM10G >conn sam/sam
Connected.
SAM@OCM10G >create table test (id int,name varchar2(10));
Table created.
SAM@OCM10G >insert into test values (1,'sam');
1 row created.
SAM@OCM10G >commit;
Commit complete.
SAM@OCM10G >select * from test;
ID NAME
---------- ----------
1 sam
（3）創(chuàng)建導(dǎo)出數(shù)據(jù)時(shí)用到的directory并賦（讀\寫(xiě)）權(quán)限
SAM@OCM10G >conn / as sysdba
Connected.
SYS@OCM10G >create directory test as '/home/oracle';
Directory created.
SYS@OCM10G >grant write,read on directory test to sam;
Grant succeeded.
（4）expdp導(dǎo)出10g數(shù)據(jù)庫(kù)中sam用戶(hù)數(shù)據(jù)
[oracle@test ~]$ ls -l test.dmp
ls: cannot access test.dmp: No such file or directory
[oracle@test ~]$ expdp sam/sam@ocm10g directory=test dumpfile=test.dmp
Export: Release 10.2.0.1.0 - 64bit Production on Friday, 08 January, 2016 10:32:37
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SAM"."SYS_EXPORT_SCHEMA_01": sam/********@ocm10g directory=test dumpfile=test.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
. . exported "SAM"."TEST" 5.234 KB 1 rows
Master table "SAM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SAM.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/test.dmp
Job "SAM"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:32:44
[oracle@test ~]$ ls -l test.dmp
-rw-r----- 1 oracle oinstall 143360 Jan 8 10:32 test.dmp
（5）創(chuàng)建11g環(huán)境，導(dǎo)入數(shù)據(jù)時(shí)用到的directory，創(chuàng)建SAM用戶(hù)
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 8 10:34:48 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@OCM11G >select username from dba_users where username='SAM';
no rows selected
SYS@OCM11G >create user sam identified by sam;
User created.
SYS@OCM11G >grant connect,resource to sam;
Grant succeeded.
（6）將test.dmp文件導(dǎo)入11g數(shù)據(jù)庫(kù)
[oracle@test ~]$ impdp system/oracle@ocm11g directory=test dumpfile=test.dmp
Import: Release 11.2.0.1.0 - Production on Fri Jan 8 11:03:37 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@ocm11g directory=test dumpfile=test.dmp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SAM"."TEST" 5.234 KB 1 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 11:03:39
（7）檢查用戶(hù)及導(dǎo)入數(shù)據(jù)
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 8 11:03:54 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@OCM11G >
SYS@OCM11G >conn sam/sam
Connected.
SAM@OCM11G >select * from test;
ID NAME
---------- ----------
1 sam
高版本—>低版本 環(huán)境:高版本11g(11.2.0.1.0) 低版本10g(10.2.0.1.0) 猜測(cè)：不成 結(jié)論：可以，要使用version參數(shù)
（1）10g庫(kù)中創(chuàng)建測(cè)試用戶(hù)suzzy，并賦予權(quán)限
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 8 11:14:37 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@OCM11G >select username from dba_users where username='SUZZY';
no rows selected
SYS@OCM11G >create user suzzy identified by suzzy;
User created.
SYS@OCM11G >grant connect,resource to suzzy;
Grant succeeded.
（2）創(chuàng)建測(cè)試表test1及數(shù)據(jù)
SYS@OCM11G >conn suzzy/suzzy
Connected.
SUZZY@OCM11G >create table test1 (id int,name varchar2(10));
Table created.
SUZZY@OCM11G >insert into test1 values (1,'suzzy');
1 row created.
SUZZY@OCM11G >commit;
Commit complete.
SUZZY@OCM11G >select * from test1;
ID NAME
---------- ----------
1 suzzy
（3）給用戶(hù)suzzy賦予對(duì)導(dǎo)出目錄test的讀寫(xiě)權(quán)限
SYS@OCM11G >grant write,read on directory test to suzzy;
Grant succeeded.
（4）導(dǎo)出11g庫(kù)中suzzy用戶(hù)及數(shù)據(jù)
[oracle@test ~]$ expdp suzzy/suzzy@ocm11g directory=test dumpfile=test1.dmp
Export: Release 11.2.0.1.0 - Production on Fri Jan 8 11:29:14 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SUZZY"."SYS_EXPORT_SCHEMA_01": suzzy/********@ocm11g directory=test dumpfile=test1.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
. . exported "SUZZY"."TEST1" 5.429 KB 1 rows
Master table "SUZZY"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SUZZY.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/test1.dmp
Job "SUZZY"."SYS_EXPORT_SCHEMA_01" successfully completed at 11:29:29
（5）創(chuàng)建10g數(shù)據(jù)庫(kù)中用戶(hù)并賦予權(quán)限，包括導(dǎo)入時(shí)用到的directory
SYS@OCM10G >select username from dba_users where username='SUZZY';
no rows selected
SYS@OCM10G >create user suzzy identified by suzzy;
User created.
SYS@OCM10G >grant connect,resource to suzzy;
Grant succeeded.
SYS@OCM10G >grant read,write on directory test to suzzy;
Grant succeeded.
（6）將test1.dmp文件導(dǎo)入10g數(shù)據(jù)庫(kù)，此時(shí)會(huì)報(bào)錯(cuò)，原因是由于版本不符合要求，此時(shí)需要使用expdp中version參數(shù)，參數(shù)介紹請(qǐng)看文章（三）
[oracle@test ~]$ impdp suzzy/suzzy@ocm10g directory=test dumpfile=test1.dmp
Import: Release 10.2.0.1.0 - 64bit Production on Friday, 08 January, 2016 11:35:06
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/home/oracle/test1.dmp"
翻譯：
ORA-39001: 參數(shù)值無(wú)效
ORA-39000: 轉(zhuǎn)儲(chǔ)文件說(shuō)明錯(cuò)誤
ORA-39142: 版本號(hào) 3.1 (在轉(zhuǎn)儲(chǔ)文件 "/home/oracle/test1.dmp" 中) 不兼容
（7）增加version參數(shù)，重新從11g庫(kù)中導(dǎo)出dump文件
[oracle@test ~]$ expdp suzzy/suzzy@ocm11g directory=test dumpfile=test2.dmp version=10.2.0.1.0
Export: Release 11.2.0.1.0 - Production on Fri Jan 8 14:01:34 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SUZZY"."SYS_EXPORT_SCHEMA_01": suzzy/********@ocm11g directory=test dumpfile=test2.dmp version=10.2.0.1.0
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
. . exported "SUZZY"."TEST1" 5.304 KB 1 rows
Master table "SUZZY"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SUZZY.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/test2.dmp
Job "SUZZY"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:01:50
（8）將加參數(shù)version導(dǎo)出后的test2.dmp文件導(dǎo)入10g數(shù)據(jù)庫(kù)
[oracle@test ~]$ impdp suzzy/suzzy@ocm10g directory=test dumpfile=test2.dmp
Import: Release 10.2.0.1.0 - 64bit Production on Friday, 08 January, 2016 14:03:47
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "SUZZY"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SUZZY"."SYS_IMPORT_FULL_01": suzzy/********@ocm10g directory=test dumpfile=test2.dmp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SUZZY"."TEST1" 5.304 KB 1 rows
Job "SUZZY"."SYS_IMPORT_FULL_01" successfully completed at 14:03:48
（9）驗(yàn)證用戶(hù)及數(shù)據(jù)
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 8 14:04:27 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SYS@OCM10G >conn suzzy/suzzy
Connected.
SUZZY@OCM10G >select * from test1;
ID NAME
---------- ----------
1 suzzy
三、version參數(shù)說(shuō)明
（1）官方文檔：
VERSION
Default: COMPATIBLE
Purpose
Specifies the version of database objects to be exported (that is, only database objects and attributes that are compatible with the specified release will be exported). This can be used to create a dump file set that is compatible with a previous release of Oracle Database. Note that this does not mean that Data Pump Export can be used with releases of Oracle Database prior to Oracle Database 10g release 1 (10.1). Data Pump Export only works with Oracle Database 10g release 1 (10.1) or later. The VERSION parameter simply allows you to identify the version of the objects being exported.
Syntax and Description
VERSION=[COMPATIBLE | LATEST | version_string]
The legal values for the VERSION parameter are as follows:
COMPATIBLE - This is the default value. The version of the metadata corresponds to the database compatibility level. Database compatibility must be set to 9.2 or higher.
LATEST - The version of the metadata corresponds to the database release.
version_string - A specific database release (for example, 11.2.0). In Oracle Database 11g, this value cannot be lower than 9.2.
Database objects or attributes that are incompatible with the specified release will not be exported. For example, tables containing new datatypes that are not supported in the specified release will not be exported.
Restrictions
Exporting a table with archived LOBs to a database release earlier than 11.2 is not allowed.
If the Data Pump Export VERSION parameter is specified along with the TRANSPORT_TABLESPACES parameter, then the value must be equal to or greater than the Oracle Database COMPATIBLE initialization parameter.
（2）說(shuō)明
根據(jù)官方文檔，我們可以看到version參數(shù)有3個(gè)選項(xiàng)可以選，分別為compatible、latest、version_string，默認(rèn)選項(xiàng)是compatible，這個(gè)選項(xiàng)是導(dǎo)出的元數(shù)據(jù)與數(shù)據(jù)庫(kù)的版本兼容性級(jí)別一致，例如我導(dǎo)出的數(shù)據(jù)庫(kù)兼容性是11.2.0.0.0 那么導(dǎo)出時(shí)就是11.2.0.0.0，這個(gè)很好理解。latest選項(xiàng)是最高版本與數(shù)據(jù)庫(kù)版本保持一致，這個(gè)基本很少用到。version_string是指定具體數(shù)據(jù)庫(kù)版本的字符串，這個(gè)很常用，在清楚自己數(shù)據(jù)庫(kù)版本時(shí)，可以直接指定導(dǎo)出兼容版本，注意在11g的版本中，該參數(shù)指定版本不能小于9.2。
再有就是數(shù)據(jù)庫(kù)對(duì)象與屬性也要對(duì)該版本支持，否則不會(huì)被導(dǎo)出，例如，包含新數(shù)據(jù)類(lèi)型的表不支持指定的版本不會(huì)被導(dǎo)出。
限制：
低于11.2版本，不允許導(dǎo)出帶有archived LOBs表（通過(guò)字面上未能太理解，在群里做了些咨詢(xún)，也沒(méi)有最終的結(jié)果，不過(guò)還是有些收獲，11g中導(dǎo)出的包含securefile lob的表，導(dǎo)入到10g中會(huì)丟失到該特性，見(jiàn) 四）
如果數(shù)據(jù)泵version參數(shù)隨著TRANSPORT_TABLESPACES指定參數(shù),那么version值必須等于或大于Oracle數(shù)據(jù)庫(kù)初始化參數(shù)兼容。
四、關(guān)于securefile lob字段導(dǎo)出導(dǎo)入測(cè)試
創(chuàng)建測(cè)試表
11g環(huán)境:
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 13 18:58:37 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@OCM11G >show parameter db_securefile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_securefile string PERMITTED
SYS@OCM11G >conn sam/sam
Connected.
SAM@OCM11G >create table t1(a clob) lob (a) store as securefile (compress low cache nologging);
Table created.
SAM@OCM11G >insert into t1 select rpad('a',4000,'*') str from dual connect by rownum<=10;
10 rows created.
SAM@OCM11G >commit;
Commit complete.
導(dǎo)出數(shù)據(jù)
[oracle@test ~]$ expdp sam/sam@ocm11g directory=test dumpfile=test_lob8.dmp version=10.2.0.1.0
Export: Release 11.2.0.1.0 - Production on Wed Jan 13 19:10:42 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SAM"."SYS_EXPORT_SCHEMA_01": sam/********@ocm11g directory=test dumpfile=test_lob8.dmp version=10.2.0.1.0
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 576 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SAM"."T1" 83.51 KB 11 rows
. . exported "SAM"."T_CLOB" 83.54 KB 10 rows
. . exported "SAM"."TEST_LOB" 5.382 KB 1 rows
. . exported "SAM"."TEST" 5.296 KB 1 rows
Master table "SAM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SAM.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/test_lob8.dmp
Job "SAM"."SYS_EXPORT_SCHEMA_01" successfully completed at 19:10:58
導(dǎo)入10g環(huán)境
[oracle@test ~]$ impdp sam/sam@ocm10g directory=test dumpfile=test_lob8.dmp
Import: Release 10.2.0.1.0 - 64bit Production on Wednesday, 13 January, 2016 19:13:15
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "SAM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SAM"."SYS_IMPORT_FULL_01": sam/********@ocm10g directory=test dumpfile=test_lob8.dmp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SAM"."T1" 83.51 KB 11 rows
. . imported "SAM"."T_CLOB" 83.54 KB 10 rows
. . imported "SAM"."TEST_LOB" 5.382 KB 1 rows
. . imported "SAM"."TEST" 5.296 KB 1 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SAM"."SYS_IMPORT_FULL_01" successfully completed at 19:13:16
對(duì)比10g，11g庫(kù)中t1表結(jié)構(gòu)
（11g）
SYS@OCM11G > select dbms_metadata.get_ddl('TABLE','T1','SAM') from dual;
DBMS_METADATA.GET_DDL('TABLE','T1','SAM')
--------------------------------------------------------------------------------
CREATE TABLE "SAM"."T1"
( "A" CLOB
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
FAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS"
LOB ("A") STORE AS SECUREFILE (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192
CACHE NOLOGGING COMPRESS LOW KEEP_DUPLICATES
STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
))
（10g）
SYS@OCM10G > select dbms_metadata.get_ddl('TABLE','T1','SAM') from dual;
DBMS_METADATA.GET_DDL('TABLE','T1','SAM')
--------------------------------------------------------------------------------
CREATE TABLE "SAM"."T1"
( "A" CLOB
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
LOB ("A") STORE AS (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 0
CACHE
STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
以上是“expdp/impdp如何使用version參數(shù)跨版本數(shù)據(jù)遷移”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對(duì)大家有所幫助，如果還想學(xué)習(xí)更多知識(shí)，歡迎關(guān)注億速云行業(yè)資訊頻道！
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號(hào)
手機(jī)網(wǎng)站二維碼
