Table creation script

[mooks]

Hi

There is a script generated for table creation and all related procedures or triggers related to the table under the script tab in the software product TOAD. I am encountering an invalid operation now and cannot retrieve the scripts, does anyone has the sql to extract all the script creation for a table please? Thanks!

[davey23uk]

version would help

[mooks]

Version 9.2.0.4.0. Thank you!

[davey23uk]

use dbms_metadata.get_ddl

[mooks]

Hi

I have tested it and it doesn't work :( Any help please? Thanks in advance!

select dbms_metadata.get_ddl('TABLE','EMP') from dual;

ERROR:
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLResetAllVars in routine
kuxslResetParams:
LPX-1: NULL pointer
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3320
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4148
ORA-06512: at "SYS.DBMS_METADATA", line 458
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

[kris123]

hi hun,

i do export the table witn no rows and edit the expdat.dmp all the
ddl is there or import using indexfile=file and your ddl sql is ready.

[mooks]

Thanks! But any idea why dbms_metadata.get_ddl is not working?

[kris123]

funny...it worked on my 9.2.0.1 and 10.1.0.2 believe me the output
is no good. It just returned a truncated 1 liner.

Maybe u need to exit and login again or reboot

[kris123]

funny...it worked on my 9.2.0.1 and 10.1.0.2 believe me the output
is no good. It just returned a truncated 1 liner.

Maybe u need to exit and login again or reboot

[mooks]

I think you can set long=10000 to see more lines. Could it be my Oracle version which is having problem with dbms_metadata.get_ddl? Anyone encountering the same error??