get the LOB definition

 

Hello,

Please help me to get the definition of a lob segment can I use dbms_metadata.get_ddl for this?

SQL> select segment_type,segment_name,bytes/1024/1024/1024 sg from dba_segments where owner='COG84LOG' order by bytes/1024/1024/1024 desc

  2  ;

SEGMENT_TYPE       SEGMENT_NAME                                                                              SG

------------------ --------------------------------------------------------------------------------- ----------

LOBSEGMENT         SYS_LOB0000039453C00014$$                                                         76.4541016

Best regards,

Vishal