Using Database | Export | Export DDL and want to be able to produce a series of ddl files per object. In the Object Search window, I thought I would be able to group by the 'OBJECT PARENT' for types such as Indexes, Constraints, Triggers. From there I would be able to easily pick the required related objects to subsequently create the ddl into individual object files. However, the Object Parent column is not populated for most object types.
e.g. I want to see objects associated with table ACCOUNTS.
I would like to see the following format
Object Name | Object Type | Object Parent | Object Owner |
ACCOUNTS | TABLE | SCHEMA1 | |
ACCOUNTS_PK | INDEX | ACCOUNTS | SCHEMA1 |
ACCOUNTS_01 | CONTSRAINT | ACCOUNTS | SCHEMA1 |
ACCOUNTS_02 | CONSTRAINT | ACCOUNTS | SCHEMA1 |
WORKAROUND:
none
STATUS:
Enhancement Request ST59221 has been submitted to Development for consideration in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center