Return
-
Title
Export DDL (Object Search) does not display Object Parent for selected tables -
Description
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 formatObject 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
With the UI displayed in the above format, this would make it much easier to select dependent objects for subsequent DDL creation.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.