dbms_metadata.GET_DDL in 9.2.0.8, create script gets "new line" and needs editing before it can run
Hi,
Im trying to get the ddl for triggers in an old 9.2.0.8:
set pagesize 0
set long 90000
set feedback off
set echo off
set heading off
set lines 300
SET longchunksize 90000
select
dbms_metadata.GET_DDL(u.object_type,u.object_name,'RX')
from
dba_objects u
where
owner = 'RX'
and OBJECT_TYPE='TRIGGER';
But the output gets like this:
DATE;
cg$RXDANGEROUSGOODSBOX.cg$tableind(idx).CREATIONDATE := TRUE;
cg$rec.TIMESTAMP := cg$RXDANGEROUSGOODSBOX.cg$table(idx).TIMESTAMP;
cg$RXDANGEROUSGOODSBOX.cg$tableind(idx).TIMESTAMP := TRUE;
cg$rec.USERSTAMP := cg$RXDANGEROUSGOODSBOX.cg$table(idx).USERSTAMP;
cg$RXDANGEROUSGOODSBOX.cg$tableind(idx).USERSTAMP := TRUE;
cg$rec.FUNCTIONSTAMP := cg$RXDANGEROUSGOODSBOX.cg$table(idx).FUNCTIO