Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Exporting to specified folder using -dir

Scott WesleyMay 24 2021

I've started using SQLcl 20.2 to explore the Liquibase integration, not the most recent version because of this issue.
Now my APEX exports are exporting successfully, and the destination folder can also be parameterised.

SQL> lb genobject -type apex -applicationid 300 -dir /lb
Exporting Application 300
Action successfully completed please review created file /lb/f300.xml

However, if I try the same -dir parameter for tables, the destination is ignored.

SQL> lb genobject -type table -name my_table -dir /lb
Action successfully completed please review created file my_table_table2.xml

I've tried a few variations without success.

SQL> lb genobject -dir /lb -type table -name my_table
Action successfully completed please review created file my_table_table3.xml
SQL> lb genobject -type table -name my_table -dir ./lb
Action successfully completed please review created file my_table_table4.xml
SQL>

This is on an 11.2.0.4 database.

Comments
Post Details
Added on May 24 2021
4 comments
222 views