Meaning of Oracle table name with and without "_" at its end?

Jonathan Chan gmg

Summary

What is the difference between Oracle tables named with and without "_" at the end?

Content

Hello Oracle Community,

1) What's the difference between Oracle tables that are different only by an underscore "_" written at the end of the table name? 

Ex. Table "EGP_SYSTEM_ITEMS_B" and Table "EGP_SYSTEM_ITEMS_B_"?
• Link to information about the above 2 tables:
https://docs.oracle.com/cd/E83857_01/saas/supply-chain-management/r13-update17d/oedsc/EGP_SYSTEM_ITEMS_B-tbl.html

2) Furthermore, do you know which columns and tables are the descriptions to Attribute entries usually located at?  In particular the descriptions to Attribute4 and Attribute5 in the table EGP_SYSTEM_ITEMS_B.  I understand the description entries' location could be company specific but I am wondering whether there are columns where the attribute descriptions are usually located at.

Thank you.

Jon

Robert Fighiroae-Oracle

Hi Jon,

Tables ending with _ are auditing table. If audit is enabled on the table, then table will have those records.

The only difference is the primary key (PK) between the table ending with letter and the one ending with _.

The PK for the table ending with _ consists of the same columns in PK of table ending with letter + LAST_UPDATE_DATE and LAST_UPDATED_BY.

e.g.

• PK for table EGP_SYSTEM_ITEMS_B is INVENTORY_ITEM_ID, ORGANIZATION_ID
• PK for table EGP_SYSTEM_ITEMS_B_ is LAST_UPDATE_DATE, LAST_UPDATED_BY, INVENTORY_ITEM_ID, ORGANIZATION_ID

Best regards,

Robert

Jonathan Chan gmg

Thank you for the thorough explanation Robert.

Jon