Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: November 23, 2016 - 3:39 am UTC

Last updated: November 25, 2016 - 7:57 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,

I would like to know about Difference between Oracle Apps(r12) Database and Oracle Database(11g)?

and Connor said...

These are different things.

We have the Oracle Database - the *storage* for your data.

We also have Oracle Applications - an suite of products to allow enterprises to perform all the standard business functions (payroll, accounts, HR, etc etc etc).

The Oracle Applications stack uses the Oracle Database to store information required for the application to run, and of course, the customer's data.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, November 23, 2016 - 1:21 pm UTC

But the Objects like tables,views are created by oracle apps not there in DBA_objects Meta Data Why?.According to info about DBA_objects in Oracle docs,the DBA_objects View Contain All the Objects created in data base.
Connor McDonald
November 24, 2016 - 4:13 am UTC

"But the Objects like tables,views are created by oracle apps not there in DBA_objects "

What gives you that idea ?

Santhosh Reddy Podduturi, November 24, 2016 - 11:37 am UTC

For Example server a is there,so obviously it contains metadata.If we install Oracle apps in that server a,it creates some objects to store business data.So my question is
Can i see those objects created by Oracle apps In Dba_objects view with a required privilage?
Connor McDonald
November 25, 2016 - 7:57 am UTC

select * from dba_objects

will return all the objects whether they are created by an App install, or anything else.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.