What is the significance of _ALL suffix in oracle tables?

Oracle Apps Interview QuestionsCategory: AOL-SysAdminWhat is the significance of _ALL suffix in oracle tables?
Questions Master asked 9 years ago

does only tables have _ALL or any other objects have _ALL as suffix?

1 Answers
Shailender Thallam Staff answered 9 years ago

_ALL  Table holds all the information about different operating units in a Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
Check out the article -> MOAC – Oracle Apps ORG_ID, Multi Org Concept