반응형

■ [2025-01-18][OL7.9]19c][DATAPUMP] 기존에 export한 dmp 파일을 기준으로 DDL 스크립트 생성하기


1. tuner.tb_ord 테이블 export

 

[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ mkdir -pv /home/oracle/tuner
mkdir: created directory ‘/home/oracle/tuner’

 

[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ ss

SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 22 22:17:55 2025

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[ol7ora12r11]<SYS@ORA12R11>$ create directory TUNER_DIR as '/home/oracle/tuner';

Directory created.

Elapsed: 00:00:00.04

 

[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ expdp tuner/oracle dumpfile=tb_ord_20250118.dmp logfile=tb_ord_20250118_exp.log directory=TUNER_DIR tables=tuner.tb_ord

Export: Release 12.2.0.1.0 - Production on Mon Sep 22 22:19:20 2025

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 "TUNER"."SYS_EXPORT_TABLE_01":  tuner/******** dumpfile=tb_ord_20250118.dmp logfile=tb_ord_20250118_exp.log directory=TUNER_DIR tables=tuner.tb_ord
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
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/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "TUNER"."TB_ORD":"P2028"                    749.4 KB   10330 rows
. . exported "TUNER"."TB_ORD":"P2024"                    744.2 KB   10260 rows
. . exported "TUNER"."TB_ORD":"P2023"                    742.6 KB   10240 rows
. . exported "TUNER"."TB_ORD":"P2027"                    734.6 KB   10130 rows
. . exported "TUNER"."TB_ORD":"P2022"                    730.1 KB   10060 rows
. . exported "TUNER"."TB_ORD":"P2026"                    733.0 KB   10110 rows
. . exported "TUNER"."TB_ORD":"P2030"                    722.4 KB    9960 rows
. . exported "TUNER"."TB_ORD":"P2021"                    699.9 KB    9650 rows
. . exported "TUNER"."TB_ORD":"P2029"                    698.8 KB    9640 rows
. . exported "TUNER"."TB_ORD":"P2025"                    697.7 KB    9620 rows
. . exported "TUNER"."TB_ORD":"P2020"                        0 KB       0 rows
. . exported "TUNER"."TB_ORD":"P_AFT_2030"                   0 KB       0 rows
. . exported "TUNER"."TB_ORD":"P_BEF_2020"                   0 KB       0 rows
Master table "TUNER"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TUNER.SYS_EXPORT_TABLE_01 is:
  /home/oracle/tuner/tb_ord_20250118.dmp
Job "TUNER"."SYS_EXPORT_TABLE_01" successfully completed at Mon Sep 22 22:19:39 2025 elapsed 0 00:00:18

 

[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ ls -l /home/oracle/tuner
total 7856
-rw-r-----. 1 oracle asmadmin 8040448 Sep 22 22:19 tb_ord_20250118.dmp
-rw-r--r--. 1 oracle asmadmin    2252 Sep 22 22:19 tb_ord_20250118_exp.log

 

2. par 파일 생성

 

[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ vi /home/oracle/tuner/impdp_sqlfile.par
[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ cat /home/oracle/tuner/impdp_sqlfile.par
dumpfile=tb_ord_20250118.dmp
logfile=tb_ord_20250118.log
directory=TUNER_DIR
tables=tuner.tb_ord
sqlfile=ddl_tb_ord.sql

 

3. impdp 실행

 

[ORA12R11:oracle@ol7ora12r11][/home/oracle]$ impdp tuner/oracle parfile=/home/oracle/tuner/impdp_sqlfile.par

Import: Release 12.2.0.1.0 - Production on Mon Sep 22 22:23:07 2025

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 "TUNER"."SYS_SQL_FILE_TABLE_01" successfully loaded/unloaded
Starting "TUNER"."SYS_SQL_FILE_TABLE_01":  tuner/******** parfile=/home/oracle/tuner/impdp_sqlfile.par
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
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 "TUNER"."SYS_SQL_FILE_TABLE_01" successfully completed at Mon Sep 22 22:23:10 2025 elapsed 0 00:00:02

 


4. 생성된 ddl 스크립트 확인

 

--현재 오라클의 캐릭터셋이 mswin949 이고 리눅스 쉘을 utf-8이므로 해당 파일을 utf-8로 변환해서 보기

[ORA12R11:oracle@ol7ora12r11][/home/oracle/tuner]$ iconv -f CP949 -t UTF-8 /home/oracle/tuner/ddl_tb_ord.sql -o /home/oracle/tuner/ddl_tb_ord_utf8.sql

[ORA12R11:oracle@ol7ora12r11][/home/oracle/tuner]$ cat /home/oracle/tuner/ddl_tb_ord_utf8.sql
-- CONNECT TUNER
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 "TUNER"."TB_ORD"
   (    "CUST_NO" VARCHAR2(10 BYTE) NOT NULL ENABLE,
        "ORD_DT" VARCHAR2(14 BYTE) NOT NULL ENABLE,
        "ORD_TOT_AMT" NUMBER(15,2) NOT NULL ENABLE,
        "ORD_STS_CD" VARCHAR2(6 BYTE) NOT NULL ENABLE,
        "DEL_YN" VARCHAR2(1 BYTE) NOT NULL ENABLE,
        "INPUT_ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
        "INPUT_DT" VARCHAR2(14 BYTE) NOT NULL ENABLE,
        "UPDT_ID" VARCHAR2(20 BYTE),
        "UPDT_DT" VARCHAR2(14 BYTE)
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"
  PARTITION BY RANGE ("ORD_DT")
 (PARTITION "P_BEF_2020"  VALUES LESS THAN ('20200101') SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2020"  VALUES LESS THAN ('20210101') SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2021"  VALUES LESS THAN ('20220101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2022"  VALUES LESS THAN ('20230101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2023"  VALUES LESS THAN ('20240101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2024"  VALUES LESS THAN ('20250101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2025"  VALUES LESS THAN ('20260101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2026"  VALUES LESS THAN ('20270101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2027"  VALUES LESS THAN ('20280101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2028"  VALUES LESS THAN ('20290101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2029"  VALUES LESS THAN ('20300101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P2030"  VALUES LESS THAN ('20310101') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ,
 PARTITION "P_AFT_2030"  VALUES LESS THAN (MAXVALUE) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_DATA1"  READ WRITE ) ;
-- new object type path: TABLE_EXPORT/TABLE/COMMENT
 COMMENT ON COLUMN "TUNER"."TB_ORD"."CUST_NO" IS '고객번호';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."ORD_DT" IS '주문일시';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."ORD_TOT_AMT" IS '주문총금액';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."ORD_STS_CD" IS '주문상태코드';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."DEL_YN" IS '삭제여부';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."INPUT_ID" IS '입력아이디';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."INPUT_DT" IS '입력일시';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."UPDT_ID" IS '수정아이디';
 COMMENT ON COLUMN "TUNER"."TB_ORD"."UPDT_DT" IS '수정일시';
 COMMENT ON TABLE "TUNER"."TB_ORD"  IS '주문';
-- new object type path: TABLE_EXPORT/TABLE/INDEX/INDEX
CREATE INDEX "TUNER"."IDX_TB_ORD_01" ON "TUNER"."TB_ORD" ("ORD_STS_CD")
  PCTFREE 10 INITRANS 2 MAXTRANS 255  LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1"  LOCAL
 (PARTITION "P_BEF_2020"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1" ,
 PARTITION "P2020"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1" ,
 PARTITION "P2021"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2022"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2023"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2024"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2025"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2026"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2027"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2028"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2029"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2030"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P_AFT_2030"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1" ) PARALLEL 1 ;

  ALTER INDEX "TUNER"."IDX_TB_ORD_01" NOPARALLEL;
CREATE UNIQUE INDEX "TUNER"."PK_TB_ORD" ON "TUNER"."TB_ORD" ("CUST_NO", "ORD_DT")
  PCTFREE 10 INITRANS 2 MAXTRANS 255  LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1"  LOCAL
 (PARTITION "P_BEF_2020"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1" ,
 PARTITION "P2020"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1" ,
 PARTITION "P2021"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2022"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2023"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2024"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2025"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2026"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2027"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2028"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2029"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P2030"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 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 "TUNER_IDX1" ,
 PARTITION "P_AFT_2030"
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TUNER_IDX1" ) PARALLEL 1 ;

  ALTER INDEX "TUNER"."PK_TB_ORD" NOPARALLEL;
-- new object type path: TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ALTER TABLE "TUNER"."TB_ORD" ADD CONSTRAINT "PK_TB_ORD" PRIMARY KEY ("CUST_NO", "ORD_DT")
  USING INDEX "TUNER"."PK_TB_ORD"  ENABLE;
-- 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

반응형

'Oracle > DataPump' 카테고리의 다른 글

[2025-01-18][OL7.9][19c][DATAPUMP] DB Link로 소스DB 테이블 읽어서 타켓DB에 저장하기  (0) 2025.09.21

+ Recent posts

티스토리툴바