Re: Due apologies for DDLs

Ha!

Too little too late.

Jared

                                                                                       
                         
                    Joe Testa                                                          
                         
                    <teci_at_the-test       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>    
                    as.net>              cc:                                           
                         
                    Sent by:             Subject:     Re: Due apologies for DDLs       
                         
                    root_at_fatcity.c                                                     
                         
                    om                                                                 
                         
                                                                                       
                         
                                                                                       
                         
                    01/03/02 02:10                                                     
                         
                    PM                                                                 
                         
                    Please respond                                                     
                         
                    to ORACLE-L                                                        
                         
                                                                                       
                         
                                                                                       
                         

dbms_metadata, a package that will let you pull ddl for objects out of the database in a readable format.

joe

Jared Still wrote:

> For those of us that are still 9i ignorant, you will need to
> explain your comment about 'dbms_metadata'.
>
> As for 'Perl expertise', you obviously don't know much
> about it.
>
> Jared
>
> On Wednesday 02 January 2002 23:55, Cyril Thankappan wrote:
>
>>Hi
>>
>>With due apologies to Perl fans and shell script
>>fans,
>>I have failed to understand why
>>to obtain these DDLs
>>the import option of "show=Y indexfile=ddl_script.sql"
>>is NOT used after a export with "rows=N"
>>
>>Of course, 9i OCPs will swear by dbms_metadata!
>>
>>where will that leave our 'perl expertise'?
>>

--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).