Difference between ALL_OBJECTS and DBA_OBJECTS

Published: 14 Oct 2003

Can you tell me what is the difference between ALL_OBJECTS and DBA_OBJECTS?

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

One needs to understand how the data dictionary is structured. There are USER_* views, ALL_* views, and DBA_* views. USER_* views are views on those things that the current user owns. ALL_* views are views on those things that the current user owns, and has privileges to access. DBA_* views are views on all things in the database. So USER_OBJECTS lists just the objects owned by the current user. ALL_OBJECTS lists all the objects owned by the current user and those objects the current user has access to. DBA_OBJECTS lists every single object in the database.

Dig Deeper on Oracle database design and architecture

How to create Oracle Multitenant database user accounts Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary.

Difference between RECYCLEBIN and 'DROPPED' column What is the difference between the RECYCLEBIN and the 'DROPPED' column in Oracle 10g?

Determining size of table in Oracle database What is the query to determine the table size of a database in Oracle?

Data dictionary cache I have a doubt about the data dictionary cache. I have to know where the information is stored within the data dictionary and what the table name is.

Where to view log of exported objects? Where can I view the log of an exported object? I exported a table and found that it is not recorded by Oracle for display in the DD view dba_exp_objects. I need to audit the export of objects by users.

How to view a list of stored procedures through SQL*Plus? How can I get a list of stored procedure objects from SQL*Plus? How can I view the source of the stored procedures?

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Please create a username to comment.

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.