This page (revision-12) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 1 KB RForbes to previous
11 26-Nov-2021 10:22 1 KB RForbes to previous | to last
10 26-Nov-2021 10:22 1 KB RForbes to previous | to last
9 26-Nov-2021 10:22 1 KB RForbes to previous | to last
8 26-Nov-2021 10:22 1 KB RForbes to previous | to last
7 26-Nov-2021 10:22 909 bytes RForbes to previous | to last
6 26-Nov-2021 10:22 832 bytes RForbes to previous | to last
5 26-Nov-2021 10:22 815 bytes RForbes to previous | to last
4 26-Nov-2021 10:22 823 bytes RForbes to previous | to last
3 26-Nov-2021 10:22 822 bytes RForbes to previous | to last
2 26-Nov-2021 10:22 822 bytes RForbes to previous | to last
1 26-Nov-2021 10:22 296 bytes RForbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed one line
The Oracle Data Dictionary contains information about data base objects, users and events. You can access this information through these views of the data dictionary. For details on how these views/tables are structured and how they are used, please refer to the Oracle Data Base Reference documentation.
The Oracle Data Dictionary contains information about data base objects, users and events. You can access this information through these views of the data dictionary.
At line 3 changed 25 lines
There are many more tables and views, but these are the ones frequently used.
Access as P2K user.
||Table/View || Description
|USER_ROLE_PRIVS | Roles granted to the user.
|USER_TABLES | Description of the user's own tables. (TABS is an alias)
|USER_TAB_COLUMNS | Columns of user's tables, views and clusters. (COLS is an alias)
|USER_TAB_PRIVS | Grants on objects for which the user is the owner, grantor or grantee
|USER_VIEWS | Test of views owned by the user.
|USER_TRIGGERS | Descriptions of the user's triggers
|USER_OBJECTS | Objects owned by the user (OBJis an alias)
|USER_INDEXES | Description of the user's own indexes (IND is an alias)
|USER_IND_COLUMNS | Columns of the user's indexes or on user's tables
|USER_SEQUENCES | Description of the user's own sequences (SEQ is an alias)
|USER_SOURCE | The text source of the stored objects
|USER_JOBS | Describes all jobs owned by the user.
|USER_ERRORS | Describes current errors on all stored objects
|USER_ENCRYPTED_COLUMNS | Mintains encryption algorithm information for all encrypted columns in all tables in the user's schema * Not currently supported
Access as SYSTEM or SYS
----
![Notes|Edit:Internal.ORACLE+INTERNAL+TABLES]
[{InsertPage page='Internal.ORACLE+INTERNAL+TABLES' default='Click to create a new notes page'}]
||View||Description
|[USER_ROL_PRIVS]|Roles granted to the user.
|[USER_TABLES] aka TABS|Description of the user's own tables.
|[USER_TAB_COLUMNS] aka COLS|Columns of user's tables, views and clusters.
|[USER_TAB_PRIVS]|Grants on objects for which the user is the owner, grantor or grantee
|[USER_VIEWS] |Test of views owned by the user.
|[USER_TRIGGERS]|Descriptions of the user's triggers
|[USER_OBJECTS] aka OBJ|Objects owned by the user
|[USER_INDEXES] aka IND|Description of the user's own indexes
|[USER_IND_COLUMNS]|Columns of the user's indexes or on user's tables
|[USER_SEQUENCES] aka SEQ|Description of the user's own sequences