Export Table description

[fabrice]

Hello,
i try to export one table description, with a plugin, by right click on a table, to gain time.
I use :

sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'PRETTY', true);
sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'CONSTRAINTS_AS_ALTER', true);
sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'SQLTERMINATOR', true);
sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'STORAGE', true);
sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'SEGMENT_ATTRIBUTES', TRUE);
sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'TABLESPACE', true);
sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'EMIT_SCHEMA', false);
ddl := sys.dbms_metadata.get_ddl(object_type => 'TABLE', schema => 'MY_SCHEMA', name => 'MY_TABLE');

but the result isn't the same as the result from export user objets from tools menu.

Are you using others commands or do you manipulate the result to obtain better?

Thanks

 

[Marco Kalter]

The Export User Objects tool does not use the dbms_metadata package. It uses its own custom processing for this.

 

[fabrice]

Thanks,