|
(9i Neuerungen) -> ermittelt die Metadaten der Tabelle scott.dept...
select dbms_metadata.get_ddl('TABLE', 'DEPT', 'SCOTT') from dual;
Ergebnis:
SQL> set pagesize 0
SQL> set long 10000
SQL> select dbms_metadata.get_ddl('TABLE', 'DEPT', 'SCOTT') from dual;
CREATE TABLE "SCOTT"."DEPT"
( "DEPTNO" NUMBER(2,0),
"DNAME" VARCHAR2(14),
"LOC" VARCHAR2(13),
CONSTRAINT "PK_DEPT" PRIMARY KEY ("DEPTNO")
USING INDEX 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)
TABLESPACE "SYSTEM" ENABLE
) 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 "SYSTEM"
oder im XML-Format:
select dbms_metadata.get_xml('TABLE', 'EMP', 'SCOTT') from dual;
|
|
