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, 'interestingly'
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
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_script.sql
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
ORA-0666Warning. 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
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
@the-test To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
as.net cc:
Sent by: Subject: Re: Due apologies for DDLs
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