CRM On Demand - Administration (MOSC)

MOSC Banner

dbms_metadata.GET_DDL in 9.2.0.8, create script gets "new line" and needs editing before it can run

edited Jan 12, 2016 9:43AM in CRM On Demand - Administration (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center