PL/SQL (MOSC)

MOSC Banner

PL/SQL using dbms_metadata.open('TABLE_EXPORT') does not exclude constraints from create table DDL..

edited Jul 26, 2013 6:36AM in PL/SQL (MOSC) 2 commentsAnswered ✓
Hi folks, I'm trying to write some PL/SQL that extracts a table's DDL using the dbms_meta.open ('TABLE_EXPORT') looping structure.

However, I don't want any constraint defenitions (primary, ref) as part of the CREATE TABLE statement.  I've tried the following script, but it gives me the following error.

ORA-31600: invalid input value CONSTRAINTS for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7783
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7754
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7754
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7754
ORA-06512: at "SYS.DBMS_METADATA_INT", line 8850

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center