SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Differences between SYS.ALL_OBJECTS and SYS.DBA_OBJECTS

Ening-OracleJun 12 2009 — edited Jun 12 2009

Hi All

I'm a beginner to ORACLE :)

when I login as sysdba, and issue below sql:

select count(*) from sys.dba_objects;

COUNT(*)
----
71596

select count(*) from sys.all_objects;

COUNT(*)
----
70772

Shouldn't it be equal? what is the objects that sys.all_objects can not see?

Thanks
Emily

This post has been answered by Pierre Forstmann on Jun 12 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2009

Added on Jun 12 2009

2 comments

1,486 views