Export Table description

Print Thread

#63600 03/10/22 03:16 PM

Joined: Nov 2016

Posts: 100

fabrice

Member

fabrice

Member

Joined: Nov 2016

Posts: 100

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

SQL Query

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

Re: Export Table description fabrice #63603 03/11/22 09:08 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	The Export User Objects tool does not use the dbms_metadata package. It uses its own custom processing for this. Marco Kalter Allround Automations

Re: Export Table description fabrice #63608 03/11/22 10:52 AM
Joined: Nov 2016 Posts: 100 F fabrice OP Member
OP fabrice Member F Joined: Nov 2016 Posts: 100	Thanks,

Moderated by support

Link Copied to Clipboard

Forums Products PL/SQL Developer Export Table description