Member Avatar for pointers

Hi,

Could you pls explain me the confusing, diffterece between the views "USER_ " , "ALL_" and "DBA_".

On which table query should be executed to get all the list of views like user_constraints, user_sons_constraints, user_source,user_sequences etc.


Regards
Pointers.

  • 3 Contributors
  • 3 Replies
  • 90 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by pointers
Member Avatar for debasisdas

the USER_...........views contains info about user data but SYS_............ and ALL_...... contains data of all other users also to which notrmal users may not have priviliges.

Member Avatar for Nige Ridd

The ALL_ views, list all objects for a particular type across all schemas in the database. The USER_ views list those of just the user that is logged in.
As you can imagine - the ALL_ views ( in some databases ) will contain much larger volumes of data than the USER_ views and therefore I'd recommend selecting from the USER_ views whenever possible.
Nige

Member Avatar for pointers

Thanks a lot..........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.