Hi all,
I want to commit my database in a svn repository.
So, I would like for each object to make the OBJECT_NAME.sql file with
contents the creation_ddl of the object.
Is there any way to do something like this ?
Something like :
select dbms_metadata.get_ddl('TABLE', TABLE_NAME)
from user_tables;
For example, I have a table age
"CREATE TABLE "USER1"."AGE"
( "DWHKEY" NUMBER(38,0) NOT NULL ENABLE,
"AGE_CODE" NUMBER(*,0),
"GROUP1_DESCR" VARCHAR2(20 BYTE),
"GROUP2_CODE" NUMBER(*,0),
"GROUP2_DESCR" VARCHAR2(20 BYTE),
CONSTRAINT "PK_AGE_DIM" PRIMARY KEY ("DWHKEY")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TBL" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TBL" ;
"
I would like to make a file with name AGE.sql and contents (without all info such as PCTFREE etc.):
CREATE TABLE "USER1"."AGE"
( "DWHKEY" NUMBER(38,0) NOT NULL ENABLE,
"AGE_CODE" NUMBER(*,0),
"GROUP1_DESCR" VARCHAR2(20 BYTE),
"GROUP2_CODE" NUMBER(*,0),
"GROUP2_DESCR" VARCHAR2(20 BYTE),
CONSTRAINT "PK_AGE_DIM" PRIMARY KEY ("DWHKEY") );
I am using 11g oracle database
Thanks in advance