someone_genius
asked on
How to format output of dbms_metdata???
Dear All,
can some tell me how to format the output of dbms_metdata?
My output is as follows:
[/pre]
CREATE INDEX "FINNBANKLEA"."LEA_AGREEME NT_DTL_IDX 6" ON "FINNBANKLEA"."LEA_AGREEME NT_DTL" ("STATUS", "BRANCHID", "AGREEMENTID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "FINNINDX" ;
[/post]
Also I used following setting:
[/pre]
set verify off
set echo off
set trims on
set linesize 1000
set heading off
set pagesize 10000
set long 500000
column Output format a1000
column XXXX format a1000
exec DBMS_METADATA.SET_TRANSFOR M_PARAM (DBMS_METADATA.SESSION_TRA NSFORM, 'PRETTY', true) /
execute DBMS_METADATA.SET_TRANSFOR M_PARAM(DB MS_METADAT A.SESSION_ TRANSFORM, 'SQLTERMIN ATOR',true )
[/post]
Thanks in advance.
can some tell me how to format the output of dbms_metdata?
My output is as follows:
[/pre]
CREATE INDEX "FINNBANKLEA"."LEA_AGREEME
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "FINNINDX" ;
[/post]
Also I used following setting:
[/pre]
set verify off
set echo off
set trims on
set linesize 1000
set heading off
set pagesize 10000
set long 500000
column Output format a1000
column XXXX format a1000
exec DBMS_METADATA.SET_TRANSFOR
execute DBMS_METADATA.SET_TRANSFOR
[/post]
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
Community Support Moderator
Computer101
Community Support Moderator
ASKER