Re: Extracting SQL from DBA_SOURCE
- From: Don Seiler <don@xxxxxxxxx>
- To: TESTAJ3@xxxxxxxxxxxxxx
- Date: Mon, 11 Oct 2010 20:52:14 -0500
set linesize 256 pagesize 0 trimspool on long 999999 head off feed off;
col ddl for a256
spool ddl.sql;
select dbms_metadata(object_type, object_name, object_owner) as ddl from
dual;
spool off;
exit;
Then go into ddl.sql, clean it up as needed and add a "/" at the end.
Cheers,
Don.
On Mon, Oct 11, 2010 at 8:04 PM, <TESTAJ3@xxxxxxxxxxxxxx> wrote:
> U mean like using dbms metadata pkg?
>
> Joe
> Sent from the crackberry, so please excuse the typos and terseness.
> ------------------------------
>
> * From: *"Scott Heisey" [oraracdba@xxxxxxxxx]
> * Sent: *10/11/2010 04:22 PM MST
> * To: *"'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
> * Cc: *"'Jared Still'" <jkstill@xxxxxxxxx>
> * Subject: *Extracting SQL from DBA_SOURCE
>
> Has anyone created or know of any code that will extract the SQL from
> dba_source? My guess is probably do the complexity of extracting the SQL out
> of DBA_SOURCE but thought I would ask anyway.
>
>
>
> Scott
>
>
>
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
Other related posts: