Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLcl project export - exporting dependent objects

Jerry SebastianJan 7 2025

Hello experts!

I am trying the new SQLcl project export feature. We already have a large number of applications in our schema, hence i would like to limit the export to the objects relevant for my new application. I could do this by listing the object names in project.filters file.

However, if i do this, i need to specify all dependent objects as well. For e.g. if i have a table TableA with indexes TableAIndex1, TableAIndex2 and triggers TableATrigger1, i need to specify the object names for table, indexes and triggers in the filter . Is there anyway, i could manage the project configuration to just list TableA and all the child objects on the table like indexes and triggers, without explicitly adding them?

Thanks in advance.

Jerry

Comments
Post Details
Added on Jan 7 2025
6 comments
92 views