oracle中分区的DDL脚本

ASKTOM 2020-08-07

523

问题描述

嗨，汤姆，

如何在oracle中获取表分区和索引分区的DDL脚本

谢谢，
里昂。

专家解答

如果您使用的是SQLcl/SQL Developer，请使用DDL命令:

create table t (
  c1 int
) partition by range ( c1 ) 
  interval ( 10 ) (
    partition p0 values less than ( 1 )
  );
create index i 
  on t ( c1 ) 
  local;
  
ddl t

  CREATE TABLE "CHRIS"."T" 
   ( "C1" NUMBER(*,0)
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" 
  PARTITION BY RANGE ("C1") INTERVAL (10) 
 (PARTITION "P0"  VALUES LESS THAN (1) 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 "USERS" ) ;

  CREATE INDEX "CHRIS"."I" ON "CHRIS"."T" ("C1") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) LOCAL
 (PARTITION "P0" NOCOMPRESS 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ) ;复制

有关此的更多信息，请参见:

https://www.thatjeffsmith.com/archive/2016/05/configuring-your-generated-ddl-in-sql-developer-and-sqlcl/

您也可以使用dbms_metaada.get_ddl来获取脚本。