Thanks for the question.
Asked: May 04, 2017 - 1:09 pm UTC
Last updated: April 11, 2022 - 5:13 am UTC
Version: 11.2
Viewed 10K+ times! This question is
SQL> set linesize 1000 SQL> set pages 1000 SQL> set pages 1000 SQL> set lines 1000 SQL> select DBMS_METADATA.GET_DDL('TABLE','TB_TEST') from dual; DBMS_METADATA.GET_DDL('TABLE','TB_TEST') -------------------------------------------------------------------------------- CREATE TABLE "FOO"."TB_TEST" ( "CARD_NO" VARCH SQL>
SQL> create table t ( x int, y date, z varchar2(100) ); Table created. SQL> sho long long 80 SQL> select DBMS_METADATA.GET_DDL('TABLE','T') from dual; DBMS_METADATA.GET_DDL('TABLE','T') -------------------------------------------------------------------------------- CREATE TABLE "CHRIS"."T" ( "X" NUMBER(*,0), "Y" DATE, "Z" VARCHAR2(10 SQL> set long 100000 SQL> select DBMS_METADATA.GET_DDL('TABLE','T') from dual; DBMS_METADATA.GET_DDL('TABLE','T') -------------------------------------------------------------------------------- CREATE TABLE "CHRIS"."T" ( "X" NUMBER(*,0), "Y" DATE, "Z" VARCHAR2(100) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "SYSTEM"
A reader, September 11, 2020 - 10:34 am UTC
A reader, September 12, 2020 - 8:09 am UTC
David, September 12, 2020 - 10:32 am UTC
A reader, September 14, 2020 - 11:36 am UTC
A reader, April 09, 2022 - 1:18 am UTC
Complete documentation on Securefiles and Large Objects here