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 3 changed one line
||View ||Description
There are many more tables and views, but these are the ones frequently used.
Access as P2K user.
||Table/View ||Description
At line 5 changed 2 lines
|[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_TABLES] aka |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)
At line 10 changed 2 lines
|[USER_OBJECTS] aka OBJ|Objects owned by the user
|[USER_INDEXES] aka IND|Description of the user's own indexes
|[USER_OBJECTS] |Objects owned by the user (OBJis an alias)
|[USER_INDEXES] |Description of the user's own indexes (IND is an alias)
At line 13 changed one line
|[USER_SEQUENCES] |Description of the user's own sequences
|[USER_SEQUENCES] |Description of the user's own sequences (SEQ is an alias)
At line 18 added 2 lines
Access as SYSTEM or SYS