Database Administration (MOSC)

MOSC Banner

Possible to get ddl for a LOBSEGMENT?

edited Feb 9, 2010 6:44AM in Database Administration (MOSC) 5 commentsAnswered
 Hi!

Is there any way to get the ddl for a lobsegment?

select dbms_metadata.get_ddl('LOBSEGMENT','SYS_LOB0000012595C00002$$','schemaX') from dual;

RROR:
ORA-31600: invalid input value LOBSEGMENT for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2681
ORA-06512: at "SYS.DBMS_METADATA", line 2732
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1


Any ideas? Is it possible?

Regards
U

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