idea Re: Compose for DW RUNNO_UPDATE and RUNNO_INSERT - Status changed to: Open - Not Planned in Suggest an Idea

Compose for DW RUNNO_UPDATE and RUNNO_INSERT

Larry_Aaron — Tue, 19 Jul 2022 21:54:13 GMT

It would be helpful if we could edit and shorten the system generated RUNNO_UPDATE and RUNNO_INSERT column names added to each table name to create system generated columns. Ideally they could be in the Settings > Naming along with the prefix and suffix naming. When running in an Oracle DW, which limits object names to 30 characters, we are frequently needing to shorten the native table names to mitigate ORA-00904 invalid identifier errors.

Re: Compose for DW RUNNO_UPDATE and RUNNO_INSERT

jtompkins — Thu, 21 Jul 2022 21:49:39 GMT

Seconded as an Oracle source/target user. We have to make sure our entity names are a max of 17 characters so we don't run into this issue.... and if they ever introduce other system columns with prefixes or suffixes that are longer than the 13 characters of the _RUNNO_INSERT and _RUNNO_UPDATE, we will not be in a good situation. This is honestly less of an "idea" and more of a bug fix.

Re: Compose for DW RUNNO_UPDATE and RUNNO_INSERT - Status changed to: Open - Not Planned

TimGarrod — Mon, 01 Aug 2022 18:03:23 GMT

Hi, the Oracle limit for 30 characters for column names was removed quite some time ago by Oracle. (12.2 release of Oracle database ).

Prior releases of Oracle database are already out of support (1.2 end of support is also this November) and the only way to continue limiting to 30 characters is to have the COMPATIBLE setting for the database to less than 12.2 - which also limits functionality to the prior versions of the database.

Since this constraint should no longer exist in supported versions of the Oracle database, this feature is not planned.

Re: Compose for DW RUNNO_UPDATE and RUNNO_INSERT

jtompkins — Mon, 01 Aug 2022 18:57:03 GMT

Is there a planned end of support date for version 12.1 of Oracle?

Re: Compose for DW RUNNO_UPDATE and RUNNO_INSERT

TimGarrod — Mon, 01 Aug 2022 19:10:13 GMT

@jtompkins - Just so I'm clear - when I say out of support, I'm talking Oracles support policy.

https://www.oracle.com/us/assets/lifetime-support-technology-069183.pdf

Re: Compose for DW RUNNO_UPDATE and RUNNO_INSERT - Status changed to: Closed - Archived

Meghann_MacDonald — Tue, 28 May 2024 15:29:29 GMT

Hi, this idea has been in "Not Planned" status for over a year and is still not in consideration. If you'd like to open a new request, please visit the Browse and Suggest page and click "Suggest features" and open a new request.

Meghann