Re: Re Re: Due apologies for DDLs

2002-01-04 Thread Rachel Carmichael
Okay, I stillthink I like my own scripts to extract ddl better :) --- Cyril Thankappan <[EMAIL PROTECTED]> wrote: > > > U r right ..I still dunno 'much' about perl.. > > as for dbms_metadata > > it is a built in pl/sql package > > saying > > 'select dbms_metadata.get_ddl(object_type,obj

Re: Re Re: Due apologies for DDLs

2002-01-04 Thread Stephane Faroult
Cyril Thankappan wrote: > > U r right ..I still dunno 'much' about perl.. > > as for dbms_metadata > > it is a built in pl/sql package > > saying > > 'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual; > > gives the entire ddl creation script. > > However, 'interes

Re Re: Due apologies for DDLs

2002-01-03 Thread Cyril Thankappan
U r right ..I still dunno 'much' about perl.. as for dbms_metadata it is a built in pl/sql package saying 'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual; gives the entire ddl creation script. However, 'interestingly' execute dbms_metadata.get_d

Re: Due apologies for DDLs

2002-01-03 Thread Jared . Still
as.net> cc: Sent by: Subject: Re: Due apologies for DDLs [EMAIL PROTEC

Re: Due apologies for DDLs

2002-01-03 Thread Joe Testa
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

RE: Due apologies for DDLs

2002-01-03 Thread Mohan, Ross
ORA-0666"Warning. You have pushed the JaredPERL button." Cause: // You pushed the button. Action: // Stop it. -Original Message- Sent: Thursday, January 03, 2002 10:15 AM To: Multiple recipients of list ORACLE-L For those of us that are still 9i ignorant, you will need to expl

Re: Due apologies for DDLs

2002-01-03 Thread mohammed bhatti
And also, may I point out that most of us are still on 8x and even 7x. mkb --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > show=y gives you a very unreadable, unusable > (without major editing) > file. > > > --- Cyril Thankappan <[EMAIL PROTECTED]> > wrote: > > > > Hi > > > > With due a

Re: Due apologies for DDLs

2002-01-03 Thread Jared Still
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 scri

Re: Due apologies for DDLs

2002-01-03 Thread Rachel Carmichael
show=y gives you a very unreadable, unusable (without major editing) file. --- Cyril Thankappan <[EMAIL PROTECTED]> 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_