we all find different objects with lots of suffixes…her i am putting the meaning of some those suffixes..i read this thing in one of the blogs i find it good…so i am posting it as it will useful to understand these things..<\/p>\n
<\/p>\n
<\/p>\n
_ALL : Table holds all
\nthe information about different operating units. Multi-Org
\nenvironment. You can also set the client_info to specific
\noperating unit to see the data specific to that operating
\nunit only.<\/p>\n
_TL are
\ntables corresponding to another table with the same name
\nminus the _TL. These tables provide multiple language
\nsupport. For each item in the table without _TL there can be
\nmany rows in the _TL table, but all with different values in
\nthe LANGUAGE column.<\/p>\n
_B theseare the BASE tables. They are very important and the data is stored in the table with all
\nvalidations.<\/p>\n
It is
\nsupposed that these table will always contain the perfect
\nformat data.<\/p>\n
If anything happens to the BASE table data, then it is a
\ndata corruption issue.<\/p>\n
_F
\nthese are date tracked tables, which occur in HR and
\nPayroll. For these there are two date columns
\nEFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together
\nwith the PK identifies a row uniquely. The date intervals
\ncannot overlap. Many think they are Secured data. Guess
\nsomeone from Oracle confirms.<\/p>\n
_V tables
\nare the views created on base tables<\/p>\n
_VL are
\nviews for multi language tables which combines the row of
\nthe base table with the corresponding row of the _TL table
\nwhere the LANGUAGE = USERENV(\u2019LANG\u2019).<\/p>\n
_S are
\nsequences, used for finding new values for the primary key
\nof a table.<\/p>\n
_A
\nare Audit Shadow Tables<\/p>\n
_AVN and
\n_ACN are Audit
\nShadow Views (when data was changed, and with what values<\/p>\n","protected":false},"excerpt":{"rendered":"
we all find different objects with lots of suffixes…her i am putting the meaning of some those suffixes..i read this thing in one of the blogs i find it good…so i am posting it as it will useful to understand … Czytaj dalej