Wednesday, November 18, 2015

Data Dictionary Views in Oracle

Data Dictionary Views in Oracle

Oracle data dictionary views will start with any one of 3 character strings i.e. starts with DBA_ or ALL_ or USER_

 DBA: What is in all the schemas
ALL: What the user can access
USER: What is in the user’s schema


DBA_ views --> All information and objects in the Oracle data dictionary. These will be accessible by users having DBA privileges.

ALL_ views --> All information and objects accessible by a user.

USER_ views --> All information and objects owned by a user.




at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...

  • Lock Script
    Hii All  Today i'm posting  lock script. sometime some session block to other session. This situation is very critical because our wh...
  • IMPOTED Excel/Text File Data USING TOAD
    IMPOTED Excel/Text File Data Into Oracle Table Using TOAD Step 1 :  Open TOAD. Step 2 :  Write the following query to create a test tabl...
  • Audit - Enabling or Disabling Audit Trail
    Auditing in Oracle Database The Oracle Server provides several auditing options. The following three types of audits are provi...