I am using SQLcl 25.2 and connecting to an Oracle 19c database.
Is there a option in project export to prevent the storage clause from being included in the DDL for AQ tables?
Currently the result looks like this one
begin
sys.dbms_aqadm.create_queue_table(
queue_table => '"***"."***"',
queue_payload_type => '"***"."***"',
storage_clause => 'PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 8 NEXT 1 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE ***',
sort_list => 'PRIORITY,ENQ_TIME',
compatible => '8.1.3',
comment => '***'
);
end;
-- sqlcl_snapshot {…}
All storage/tablespace transformations set to false and my config looks like this:
SQL> project config -list
+=================================================================================+
| SETTING NAME | VALUE |
+=================================================================================+
| project | *** |
+---------------------------------------------------------------------------------+
| sqlcl.connectionName | *** |
+---------------------------------------------------------------------------------+
| sqlcl.version | 25.2.0.0 |
+---------------------------------------------------------------------------------+
| schemas | ["***","***"] |
+---------------------------------------------------------------------------------+
| lastReleaseVersion | |
+---------------------------------------------------------------------------------+
| export.format.enable | true |
+---------------------------------------------------------------------------------+
| export.setTransform.collationClause | NEVER |
+---------------------------------------------------------------------------------+
| export.setTransform.constraints | true |
+---------------------------------------------------------------------------------+
| export.setTransform.constraintsAsAlter | true |
+---------------------------------------------------------------------------------+
| export.setTransform.emitSchema | true |
+---------------------------------------------------------------------------------+
| export.setTransform.force | true |
+---------------------------------------------------------------------------------+
| export.setTransform.partitioning | false |
+---------------------------------------------------------------------------------+
| export.setTransform.segmentAttributes | false |
+---------------------------------------------------------------------------------+
| export.setTransform.sizeByteKeyword | true |
+---------------------------------------------------------------------------------+
| export.setTransform.sqlterminator | true |
+---------------------------------------------------------------------------------+
| export.setTransform.storage | false |
+---------------------------------------------------------------------------------+
| export.setTransform.tablespace | false |
+---------------------------------------------------------------------------------+
| export.apex.exptype | ["READABLE_YAML","APPLICATION_SOURCE"] |
+---------------------------------------------------------------------------------+
| export.apex.expAclAssignments | false |
+---------------------------------------------------------------------------------+
| export.apex.expComments | false |
+---------------------------------------------------------------------------------+
| export.apex.skipExportDate | true |
+---------------------------------------------------------------------------------+
| export.apex.expirNotif | false |
+---------------------------------------------------------------------------------+
| export.apex.expOriginalIds | false |
+---------------------------------------------------------------------------------+
| export.apex.expSavedReports | false |
+---------------------------------------------------------------------------------+
| export.apex.expPubReports | true |
+---------------------------------------------------------------------------------+
| export.apex.expSubscriptions | false |
+---------------------------------------------------------------------------------+
| export.apex.expSupportingObjects | N |
+---------------------------------------------------------------------------------+
| export.apex.expTranslations | false |
+---------------------------------------------------------------------------------+
| export.apex.auditType | NULL |
+---------------------------------------------------------------------------------+
| git.protectedBranches | ["main","master"] |
+---------------------------------------------------------------------------------+
| git.defaultBranch | main |
+---------------------------------------------------------------------------------+
| stage.excludeObjects | ["ALL.user"] |
+---------------------------------------------------------------------------------+
| stage.generatedFormat | liquibase |
+---------------------------------------------------------------------------------+
| stage.softObjectIsolation | change |
+---------------------------------------------------------------------------------+