Data Dictionary Views

[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.

[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.

[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

[pointers]

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