Re: dbms_metadata.get_ddl

From: Ray Stell <stellr_at_vt.edu>
Date: Mon, 30 Sep 2013 14:16:23 -0400
Message-Id: <A49646FF-7566-44F9-8E37-54E65D3B4961_at_vt.edu>



On Sep 30, 2013, at 10:35 AM, "Adams, Matthew (GE, Appl & Light)" <MATT.ADAMS_at_ge.com> wrote:

> set pagesize 0
> set long 10000
> set trimspool on
> set linesize 1000
> set feedback off
> set longchunksize 10000
>
> exec dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SQLTERMINATOR', true);

Thanks for sharing your experience. I neglected to mention that this particular run-in is from a 11.1x db running on Solaris 10. The same object reports well from an 11.2x db using the documented settings. I read in some thread that 11.1 had a bug and it could be what I'm hitting.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 30 2013 - 20:16:23 CEST

Original text of this message