Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to export script in SQL developer with it's dependent objects in a separate file for each object

user1362938Jun 23 2014 — edited Jun 24 2014

Hi All,

I have lots of objects created in one of the schema. I want to create single file for each object with it's dependent object.

Say, I have below 2 tables with indexes and trigger created on that tables.

Table Name : TBL1

Index on TBL1 :  IND1

                        IND2

Trigger on TBL1 : TRG1

Table Name : TBL2

Index on TBL2 :  IND3

                        IND4

Trigger on TBL2 : TRG2

Now I want to create 2 script 1 for TBL1 and another for TBL2 table. Each script must contains the table structure and index and trigger created on it.

I had tried with export option but not able to get exact option I required.

Kindly help me to export the script.

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2014
Added on Jun 23 2014
1 comment
2,013 views