[20200620]IMPDP TRANSFORM引數再探究.txt
[20200620]IMPDP TRANSFORM引數再探究.txt
--//前幾天同事要求做一個空的測試庫,要求建立與生產系統一模一樣的表結構.但是如果按照通常方式建立,即使是空表,由於
--//INITIAL很大,這樣消耗的磁碟空間也很大,並且建立過程並不快.我記憶裡以前也遇到類似的問題,查詢我的工作筆記,找到
--//如下連結:
--//http://blog.itpub.net/267265/viewspace-1846944/=> [20151126]IMPDP TRANSFORM引數.TXT
d:\> impdp help=y > aa.txt
TRANSFORM
Metadata transform to apply to applicable objects.
Valid keywords are: DISABLE_ARCHIVE_LOGGING, INMEMORY, INMEMORY_CLAUSE,
LOB_STORAGE, OID, PCTSPACE, SEGMENT_ATTRIBUTES, SEGMENT_CREATION,
STORAGE, and TABLE_COMPRESSION_CLAUSE.
--//注:12c支援更多型別,生產系統11.2.0.4.順便測試SEGMENT_CREATION的情況.以及重複測試時一些疑問.
.
Usage: TRANSFORM = transform_name:value[:object_type]
These are the applicable transform_names
SEGMENT_ATTRIBUTES: by default value is y which will copy the objects as it is in the export dump with all segment
attributes. If you specify the value as n the import job will omit the segment_attributes in the dump file and it
will use the tablespace/user default values.
STORAGE: by default the value for this parameter is y which will include all storage clauses during the import job.
If you specify the parameter value as n then it will omit the storage clause in the dump file and it will follow the
default values in the tablespace.
PCTSPACE: it is the percent multiplier for the extent allocations and size of the datafiles during the import.
OID: object id (OID) mainly used for the TYPE objects. Each and every type is identified by OID which will be
unique. If you create a type without specifying the OID the RDBMS itself will create and assign unique OID to the
new TYPE object. See below examples for more details.
1.測試環境:
SCOTT@test01p> @ ver1
PORT_STRING VERSION BANNER CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0 12.2.0.1.0 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
2.測試:
--//建立如下表：
CREATE TABLE SCOTT.EMPX
(
EMPNO NUMBER(4),
ENAME VARCHAR2(10 BYTE),
JOB VARCHAR2(9 BYTE),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2)
)
TABLESPACE USERS
STORAGE ( INITIAL 5M );
SCOTT@test01p> create unique index pk_empx on empx(empno);
Index created.
SCOTT@test01p> select segment_name,bytes,blocks,INITIAL_EXTENT,NEXT_EXTENT from dba_segments where owner=user and segment_name like '%EMPX';
no rows selected
--//你可以發現這樣建立的這樣建立的表以及索引如果沒有記錄插入前,沒有段的分配,這個11g段延遲建立的特性.
--//預設deferred_segment_creation引數=TRUE.
SCOTT@test01p> show parameter defer
NAME TYPE VALUE
------------------------------------ -------------------- ----------
deferred_segment_creation boolean TRUE
3.繼續:
SCOTT@test01p> insert into empx select * from emp ;
14 rows created.
SCOTT@test01p> commit ;
Commit complete.
SCOTT@test01p> select segment_name,bytes,blocks,INITIAL_EXTENT,NEXT_EXTENT from dba_segments where owner=user and segment_name like '%EMPX';
SEGMENT_NAME BYTES BLOCKS INITIAL_EXTENT NEXT_EXTENT
-------------------- ---------- ---------- -------------- -----------
EMPX 5242880 640 5242880 1048576
PK_EMPX 65536 8 65536 1048576
--//你可以發現插入後建立表以及索引段,而且empx段INITIAL_EXTENT=5242880也就是5M.
4.匯出以及匯入測試:
d:\tmp> expdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx.log tables=scott.empx CONTENT=METADATA_ONLY
Export: Release 12.2.0.1.0 - Production on Sat Jun 20 09:26:42 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/a**@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx.log tables=scott.empx CONTENT=METADATA_ONLY
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
D:\TMP\EXPDP\EMPX.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Sat Jun 20 09:27:34 2020 elapsed 0 00:00:48
--//注:我加入CONTENT=METADATA_ONLY僅僅取出後設資料.不包括記錄.
d:\tmp> impdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx1.log full=y transform=SEGMENT_ATTRIBUTES:n SQLFILE=empx.txt
Import: Release 12.2.0.1.0 - Production on Sat Jun 20 09:30:21 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SCOTT"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_SQL_FILE_FULL_01": scott/a**@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx1.log full=y transform=SEGMENT_ATTRIBUTES:n SQLFILE=empx.txt
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SCOTT"."SYS_SQL_FILE_FULL_01" successfully completed at Sat Jun 20 09:30:34 2020 elapsed 0 00:00:10
--//檢視生成的empx.txt指令碼:
-- CONNECT SCOTT
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "SCOTT"."EMPX"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10 BYTE),
"JOB" VARCHAR2(9 BYTE),
"MGR" NUMBER(4,0),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0)
) ;
-- new object type path: TABLE_EXPORT/TABLE/INDEX/INDEX
CREATE UNIQUE INDEX "SCOTT"."PK_EMPX" ON "SCOTT"."EMPX" ("EMPNO")
;
ALTER INDEX "SCOTT"."PK_EMPX" NOPARALLEL;
-- new object type path: TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/MARKER
--//你可以發現並沒有建立表或者索引SEGMENT_ATTRIBUTES的引數.可以前面的測試實際上僅僅匯出後設資料,按照我的理解實際上不加
--//transform=SEGMENT_ATTRIBUTES:n 命令列引數,應該也不會建立表以及索引段.而我的同事測試會建立對應的段.繼續.
d:\tmp> impdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx2.log full=y SQLFILE=empy.txt
Import: Release 12.2.0.1.0 - Production on Sat Jun 20 09:35:58 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SCOTT"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_SQL_FILE_FULL_01": scott/a****@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx2.log full=y SQLFILE=empy.txt
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SCOTT"."SYS_SQL_FILE_FULL_01" successfully completed at Sat Jun 20 09:36:07 2020 elapsed 0 00:00:06
--//檢視生成的empy.txt指令碼:
-- CONNECT SCOTT
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "SCOTT"."EMPX"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10 BYTE),
"JOB" VARCHAR2(9 BYTE),
"MGR" NUMBER(4,0),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0)
) SEGMENT CREATION IMMEDIATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
-- new object type path: TABLE_EXPORT/TABLE/INDEX/INDEX
CREATE UNIQUE INDEX "SCOTT"."PK_EMPX" ON "SCOTT"."EMPX" ("EMPNO")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" PARALLEL 1 ;
ALTER INDEX "SCOTT"."PK_EMPX" NOPARALLEL;
-- new object type path: TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/MARKER
--//注意看下劃線,這樣建立的表採用SEGMENT CREATION IMMEDIATE 的方式.這樣即使是空表,也會分配段.
--//另外可以發現建立索引並不支援沒有SEGMENT CREATION IMMEDIATE 引數.
5.可以透過一個例子驗證;
SCOTT@test01p> create table xxx (a int) ;
Table created.
SCOTT@test01p> @ ddl xxx
C100
------------------------------------------------------------
CREATE TABLE "SCOTT"."XXX"
( "A" NUMBER(*,0)
) SEGMENT CREATION DEFERRED
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "USERS" ;
--//SEGMENT CREATION DEFERRED
SCOTT@test01p> insert into xxx values(1);
1 row created.
SCOTT@test01p> rollback ;
Rollback complete.
SCOTT@test01p> @ ddl xxx
C100
------------------------------------------------------------------------
CREATE TABLE "SCOTT"."XXX"
( "A" NUMBER(*,0)
) 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 DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--//SEGMENT CREATION IMMEDIATE.一旦有資料插入,建立指令碼屬性發生變化.
SCOTT@test01p> drop table xxx purge ;
Table dropped.
SCOTT@test01p> create table xxx (a int) SEGMENT CREATION IMMEDIATE ;
Table created.
SCOTT@test01p> create index xxxpk on xxx(a);
Index created.
SCOTT@test01p> select segment_name,bytes,blocks,INITIAL_EXTENT,NEXT_EXTENT from dba_segments where owner=user and segment_name like 'XXX%';
SEGMENT_NAME BYTES BLOCKS INITIAL_EXTENT NEXT_EXTENT
-------------------- ---------- ---------- -------------- -----------
XXX 65536 8 65536 1048576
XXXPK 65536 8 65536 1048576
--//一旦建立表屬性SEGMENT CREATION IMMEDIATE,即使沒有記錄建立的索引也存在段的分配.
6.測試12c的SEGMENT_CREATION引數:
d:\tmp> impdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx3.log full=y transform=SEGMENT_CREATION:n SQLFILE=empz.txt
Import: Release 12.2.0.1.0 - Production on Sat Jun 20 09:55:49 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SCOTT"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_SQL_FILE_FULL_01": scott/a*@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx3.log full=y transform=SEGMENT_CREATION:n SQLFILE=empz.txt
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SCOTT"."SYS_SQL_FILE_FULL_01" successfully completed at Sat Jun 20 09:55:59 2020 elapsed 0 00:00:07
impdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx3.log full=y transform=SEGMENT_CREATION:n SQLFILE=empz.txt
--//檢視生成的empz.txt指令碼:
-- CONNECT SCOTT
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "SCOTT"."EMPX"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10 BYTE),
"JOB" VARCHAR2(9 BYTE),
"MGR" NUMBER(4,0),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
~~~~~~~~~~~~~~~~~~~~~~~
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
-- new object type path: TABLE_EXPORT/TABLE/INDEX/INDEX
CREATE UNIQUE INDEX "SCOTT"."PK_EMPX" ON "SCOTT"."EMPX" ("EMPNO")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" PARALLEL 1 ;
ALTER INDEX "SCOTT"."PK_EMPX" NOPARALLEL;
-- new object type path: TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/MARKER
--//STORAGE裡面的引數保留,不過如果這樣的表INITIAL很大,如果第1次有資料插入,那將是"災難性",開始會很慢.
7.最後補充一點:
--//我總是忘記,朋友總是講我忘記匯入時不要匯入統計資訊.主要平時很少做這樣的操作.
--//例子:
d:\tmp> impdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx4.log full=y transform=SEGMENT_CREATION:n SQLFILE=empa.txt exclude=STATISTICS
Import: Release 12.2.0.1.0 - Production on Sat Jun 20 10:05:53 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SCOTT"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_SQL_FILE_FULL_01": scott/a*@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx4.log full=y transform=SEGMENT_CREATION:n SQLFILE=empa.txt exclude=STATISTICS
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Job "SCOTT"."SYS_SQL_FILE_FULL_01" successfully completed at Sat Jun 20 10:06:06 2020 elapsed 0 00:00:09
--//這樣可以加快匯入並且可以避免統計資訊的不準確(應該匯入後馬上分析).也許在expdp時就可以排除掉更好.
d:\tmp> expdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empy.dmp logfile=empy.log tables=scott.empx CONTENT=METADATA_ONLY exclude=STATISTICS
Export: Release 12.2.0.1.0 - Production on Sat Jun 20 10:09:23 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/a**@test01p DIRECTORY=TMP_EXPDP dumpfile=empy.dmp logfile=empy.log tables=scott.empx CONTENT=METADATA_ONLY exclude=STATISTICS
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
D:\TMP\EXPDP\EMPY.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Sat Jun 20 10:09:42 2020 elapsed 0 00:00:17
d:\tmp> impdp scott/btbtms@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx5.log full=y transform=SEGMENT_CREATION:n SQLFILE=empb.txt
Import: Release 12.2.0.1.0 - Production on Sat Jun 20 10:10:39 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SCOTT"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_SQL_FILE_FULL_01": scott/a***@test01p DIRECTORY=TMP_EXPDP dumpfile=empx.dmp logfile=empx5.log full=y transform=SEGMENT_CREATION:n SQLFILE=empb.txt
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SCOTT"."SYS_SQL_FILE_FULL_01" successfully completed at Sat Jun 20 10:10:48 2020 elapsed 0 00:00:06
--//這樣的匯入實際上還是有匯入統計資訊的步驟.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2699593/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20200620]expdp impdp exclude引數.txt
- canvas transform引數解析CanvasORM
- expdp/impdp 詳細引數解釋
- IMPDP匯入沒有某個表空間的處理方法__加上引數TRANSFORM就可以了ORM
- impdp和expdp用法及引數介紹
- Remote_login_passwordfile引數探究REM
- 資料泵的TRANSFORM引數說明及使用ORM
- [20180413]bash 位置引數.txt
- 探究kubernetes 探針引數periodSeconds和timeoutSeconds
- 物件導向再探究物件
- [20231212]impdp content=metadata_only locks the stats.txt
- [20210826]核心引數kernel.sem.txt
- [20190917]oracle引數deferred屬性.txtOracle
- [20200220]windows設定keepalive引數.txtWindows
- [20210209]修改CPU_COUNT引數.txt
- [20231008]bbed探究lob段.txt
- [20220321]探究oracle sequence.txtOracle
- [20210903]探究mutex的值.txtMutex
- [20220913]hugepage相關引數含義.txt
- [20191204]hugepage相關引數含義.txt
- [20190417]隱含引數_SPIN_COUNT.txt
- [20210310]db_lost_write_protect引數.txt
- [20190409]latch get 引數where and why.txt
- [20180308]測試ARG_MAX引數.txt
- DllImport進階：引數配置與高階主題探究Import
- [20200904]12c invisible column impdp segment_column_id.txt
- 『忘了再學』Shell基礎 — 16、位置引數變數變數
- [20191125]探究等待事件的本源.txt事件
- [20191119]探究ipcs命令輸出.txt
- [20220322]探究oracle sequence 2.txtOracle
- 使用js從element的matrix推導transform的scale、rotate 和 translate引數JSORM
- [20231109]bbed p命令dba引數問題.txt
- [20211027]引數plscope_settings分析PLSQL.txtSQL
- [20210209]修改CPU_COUNT引數2.txt
- [20190409]latch get 引數where and why測試.txt
- [20190401]隱含引數_mutex_spin_count.txtMutex
- [20180529]模擬會話引數變化.txt會話
- [20240529]簡單探究FREE LISTS列表.txt