Oracle Version 9.2.0.1.0
--------------------- Jump to ---------------------
Clusters ---- Dimensions ---- Functions ---- Indexes
Jobs ---- Libraries ---- Materialized View Logs ---- Materialized Views
Packages ---- Policy Groups ---- Policies ---- Procedures
Queues ---- Queue Tables ---- Refresh Groups ---- Scheduler Programs
Scheduler Jobs ---- Scheduler Schedules ---- Sequences ---- Synonyms
Tables ---- Triggers ---- Types ---- Views
Object Type | Object Count | Misc. Details |
---|---|---|
Sys Privs Granted to Roles | 155 | |
Roles Granted to Roles | 11 | |
Sys Privs Granted to User | 1 | |
Roles Granted to User | 4 | |
Functions | 1 | 11 Lines of Code |
Indexes | 3 | 3 Columns |
Materialized Views | 2 | |
Materialized View Logs | 1 | |
Object Privileges | 1 | |
Packages | 2 | 9 Lines of Code |
Package Bodies | 2 | 67 Lines of Code |
Procedures | 1 | 26 Lines of Code |
Sequences | 4 | |
Synonyms | 1 | |
Tables | 9 | 58 Columns |
5 Constraints | ||
Triggers | 1 | |
Type | 1 | |
Views | 2 | 9 Columns |
Default Tablespace | Temporary Tablespace | Profile | Account Status | External Name | Initial Resource Group | # Sys Privs | # TS Quotas | # Roles | # Obj Privs |
---|---|---|---|---|---|---|---|---|---|
USERS | TEMP | DEFAULT | OPEN | DEFAULT_CONSUMER_GROUP | 1 | 0 | 4 | 97 |
Parameter | Value |
---|---|
Profile Name | DEFAULT |
Composite Limit | UNLIMITED |
Connect Time | UNLIMITED |
CPU per Session | UNLIMITED |
Failed Login Attempts | UNLIMITED |
Idle Time | UNLIMITED |
Logical Reads per Session | UNLIMITED |
Password Grace Time | UNLIMITED |
Password Lifetime | UNLIMITED |
Password Lock Time | UNLIMITED |
Password Reuse Max | UNLIMITED |
Password Reuse Time | UNLIMITED |
Password Verify Function | NULL |
Private SGA | UNLIMITED |
Sessions per User | UNLIMITED |
Object Type | Object Owner | Object Name | Column Name | Grantable Privilege(s) | Non-Grantable Privilege(s) |
---|---|---|---|---|---|
TABLE | DISCOADM2 | EUL5_ACCESS_PRIVS | DELETE | ||
TABLE | DISCOADM2 | EUL5_ACCESS_PRIVS | INSERT | ||
TABLE | DISCOADM2 | EUL5_ACCESS_PRIVS | SELECT | ||
TABLE | DISCOADM2 | EUL5_ACCESS_PRIVS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_APP_PARAMS | SELECT | ||
TABLE | DISCOADM2 | EUL5_ASMP_CONS | SELECT | ||
TABLE | DISCOADM2 | EUL5_ASMP_LOGS | SELECT | ||
TABLE | DISCOADM2 | EUL5_ASM_POLICIES | SELECT | ||
TABLE | DISCOADM2 | EUL5_BAS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BATCH_PARAMS | DELETE | ||
TABLE | DISCOADM2 | EUL5_BATCH_PARAMS | INSERT | ||
TABLE | DISCOADM2 | EUL5_BATCH_PARAMS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BATCH_PARAMS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_BATCH_QUERIES | DELETE | ||
TABLE | DISCOADM2 | EUL5_BATCH_QUERIES | INSERT | ||
TABLE | DISCOADM2 | EUL5_BATCH_QUERIES | SELECT | ||
TABLE | DISCOADM2 | EUL5_BATCH_QUERIES | UPDATE | ||
TABLE | DISCOADM2 | EUL5_BATCH_REPORTS | DELETE | ||
TABLE | DISCOADM2 | EUL5_BATCH_REPORTS | INSERT | ||
TABLE | DISCOADM2 | EUL5_BATCH_REPORTS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BATCH_REPORTS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_BATCH_SHEETS | DELETE | ||
TABLE | DISCOADM2 | EUL5_BATCH_SHEETS | INSERT | ||
TABLE | DISCOADM2 | EUL5_BATCH_SHEETS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BATCH_SHEETS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_BA_OBJ_LINKS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BQ_DEPS | DELETE | ||
TABLE | DISCOADM2 | EUL5_BQ_DEPS | INSERT | ||
TABLE | DISCOADM2 | EUL5_BQ_DEPS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BQ_DEPS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_BQ_TABLES | DELETE | ||
TABLE | DISCOADM2 | EUL5_BQ_TABLES | INSERT | ||
TABLE | DISCOADM2 | EUL5_BQ_TABLES | SELECT | ||
TABLE | DISCOADM2 | EUL5_BQ_TABLES | UPDATE | ||
TABLE | DISCOADM2 | EUL5_BR_RUNS | DELETE | ||
TABLE | DISCOADM2 | EUL5_BR_RUNS | INSERT | ||
TABLE | DISCOADM2 | EUL5_BR_RUNS | SELECT | ||
TABLE | DISCOADM2 | EUL5_BR_RUNS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_DBH_NODES | SELECT | ||
TABLE | DISCOADM2 | EUL5_DOCUMENTS | DELETE | ||
TABLE | DISCOADM2 | EUL5_DOCUMENTS | INSERT | ||
TABLE | DISCOADM2 | EUL5_DOCUMENTS | SELECT | ||
TABLE | DISCOADM2 | EUL5_DOCUMENTS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_DOC_FOLDERS | DELETE | ||
TABLE | DISCOADM2 | EUL5_DOC_FOLDERS | INSERT | ||
TABLE | DISCOADM2 | EUL5_DOC_FOLDERS | SELECT | ||
TABLE | DISCOADM2 | EUL5_DOC_FOLDERS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_DOMAINS | DELETE | ||
TABLE | DISCOADM2 | EUL5_DOMAINS | INSERT | ||
TABLE | DISCOADM2 | EUL5_DOMAINS | SELECT | ||
TABLE | DISCOADM2 | EUL5_DOMAINS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_ELEM_XREFS | DELETE | ||
TABLE | DISCOADM2 | EUL5_ELEM_XREFS | INSERT | ||
TABLE | DISCOADM2 | EUL5_ELEM_XREFS | SELECT | ||
TABLE | DISCOADM2 | EUL5_ELEM_XREFS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_EUL_USERS | DELETE | ||
TABLE | DISCOADM2 | EUL5_EUL_USERS | INSERT | ||
TABLE | DISCOADM2 | EUL5_EUL_USERS | SELECT | ||
TABLE | DISCOADM2 | EUL5_EUL_USERS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_EXPRESSIONS | SELECT | ||
TABLE | DISCOADM2 | EUL5_EXP_DEPS | SELECT | ||
TABLE | DISCOADM2 | EUL5_FREQ_UNITS | SELECT | ||
TABLE | DISCOADM2 | EUL5_FUNCTIONS | SELECT | ||
TABLE | DISCOADM2 | EUL5_FUN_ARGUMENTS | SELECT | ||
TABLE | DISCOADM2 | EUL5_FUN_CTGS | SELECT | ||
TABLE | DISCOADM2 | EUL5_FUN_FC_LINKS | SELECT | ||
TABLE | DISCOADM2 | EUL5_GATEWAYS | SELECT | ||
TABLE | DISCOADM2 | EUL5_HIERARCHIES | SELECT | ||
TABLE | DISCOADM2 | EUL5_HI_NODES | SELECT | ||
TABLE | DISCOADM2 | EUL5_HI_SEGMENTS | SELECT | ||
SEQUENCE | DISCOADM2 | EUL5_ID_SEQ | SELECT | ||
TABLE | DISCOADM2 | EUL5_IG_EXP_LINKS | SELECT | ||
TABLE | DISCOADM2 | EUL5_IHS_FK_LINKS | SELECT | ||
TABLE | DISCOADM2 | EUL5_KEY_CONS | SELECT | ||
TABLE | DISCOADM2 | EUL5_OBJS | SELECT | ||
TABLE | DISCOADM2 | EUL5_OBJ_DEPS | SELECT | ||
TABLE | DISCOADM2 | EUL5_OBJ_JOIN_USGS | SELECT | ||
TABLE | DISCOADM2 | EUL5_PLAN_TABLE | DELETE | ||
TABLE | DISCOADM2 | EUL5_PLAN_TABLE | INSERT | ||
TABLE | DISCOADM2 | EUL5_PLAN_TABLE | SELECT | ||
TABLE | DISCOADM2 | EUL5_PLAN_TABLE | UPDATE | ||
TABLE | DISCOADM2 | EUL5_QPP_STATS | DELETE | ||
TABLE | DISCOADM2 | EUL5_QPP_STATS | INSERT | ||
TABLE | DISCOADM2 | EUL5_QPP_STATS | SELECT | ||
TABLE | DISCOADM2 | EUL5_QPP_STATS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_SEGMENTS | DELETE | ||
TABLE | DISCOADM2 | EUL5_SEGMENTS | INSERT | ||
TABLE | DISCOADM2 | EUL5_SEGMENTS | SELECT | ||
TABLE | DISCOADM2 | EUL5_SEGMENTS | UPDATE | ||
TABLE | DISCOADM2 | EUL5_SEQUENCES | SELECT | ||
TABLE | DISCOADM2 | EUL5_SQ_CRRLTNS | SELECT | ||
TABLE | DISCOADM2 | EUL5_SUB_QUERIES | SELECT | ||
TABLE | DISCOADM2 | EUL5_SUMMARY_OBJS | SELECT | ||
TABLE | DISCOADM2 | EUL5_SUMO_EXP_USGS | SELECT | ||
TABLE | DISCOADM2 | EUL5_SUM_BITMAPS | SELECT | ||
TABLE | DISCOADM2 | EUL5_SUM_RFSH_SETS | SELECT | ||
TABLE | DISCOADM2 | EUL5_VERSIONS | SELECT |
Privilege | Admin Option? |
---|---|
UNLIMITED TABLESPACE | No |
Role Name | Default Role? | Admin Option? |
---|---|---|
DBA | Yes | No |
CONNECT | Yes | No |
RESOURCE | Yes | No |
QUEST_SL_SQLAB_ROLE | Yes | No |
Type Name | Status | Type Code | Attributes | Methods | Dependencies |
---|---|---|---|---|---|
NEWUSERDEFINEDTYPE | INVALID | OBJECT | 0 | 0 | 0 |
Table Name | # of Cols | # of Indexes | Size | Tablespace | # of Extents | Initial Ext | Next Ext | Pct Inc. | Min Exts | Max Exts | Freelists | Freelist Groups | Buffer Pool | Comment |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BONUS | 4 | 0 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | ||||
DEPT | 3 | 1 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | ||||
DEPT_MV | 1 | 1 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | snapshot table for snapshot SCOTT.DEPT_MV | |||
EMP | 8 | 1 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | ||||
"MATERIALIZED VIEW1" | 1 | 0 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | snapshot table for snapshot SCOTT.MATERIALIZED VIEW1 | |||
MLOG$_DEPT_MV | 5 | 0 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | snapshot log for master table SCOTT.DEPT_MV | |||
PLAN_TABLE | 29 | 0 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | ||||
RUPD$_DEPT_MV | 4 | 0 | <temporary> | 0 | 1 | 1 | DEFAULT | temporary updatable snapshot log | ||||||
SALGRADE | 3 | 0 | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT |
View Name | Status | # of Columns | Text Length | # of Dependencies | Comment |
---|---|---|---|---|---|
SALES | INVALID | 6 | 290 | 1 | |
USER0_EMP10 | VALID | 3 | 52 | 1 |
Materialized View Name | Table Name | # of Cols | # of Indexes | Size | Tablespace | # of Extents | Initial Ext | Next Ext | Pct Inc. | Min Exts | Max Exts | Updatable | Refresh Mode | Next Refresh | Query |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEPT_MV | DEPT_MV | 1 | 1 | USERS | 64K | 0 | 1 | 2147483645 | NO | DEMAND | select deptno from dept | ||||
"MATERIALIZED VIEW1" | "MATERIALIZED VIEW1" | 0 | 0 | 0 | NO | DEMAND | SELECT count(*) FROM emp |
Materialized View Log Name | Log Table | Log Trigger | Row ID | Filter Columns | Primary Key | Sequence | Object ID | New Values |
---|---|---|---|---|---|---|---|---|
DEPT_MV | MLOG$_DEPT_MV | No | DEPTNO | Yes | No | No | Exclude |
Sequence Name | Min Value | Max Value | Increment By | Cycle Flag | Order Flag | Cache Size | Last Number |
---|---|---|---|---|---|---|---|
CUSTID | 1 | 999999999999999999999999999 | 1 | No | No | 1 | 109 |
ORDID | 1 | 999999999999999999999999999 | 1 | No | No | 1 | 622 |
PRODID | 1 | 999999999999999999999999999 | 1 | No | No | 1 | 200381 |
TOAD_SEQ | 1 | 999999999999999999999999999 | 1 | No | No | 1 | 1 |
Trigger Name | Type | Event | Base Obj. Type | Base Object |
---|---|---|---|---|
TRIGGER1 | BEFORE STATEMENT | INSERT | Table | SCOTT.EMP |
Index Name | Index Type | Unique? | Table Owner | Table Name | Columns | Size (Mb) | Tablespace | # of Extents | Initial Ext | Next Ext | Pct Inc. | Min Exts | Max Exts | Freelists | Freelist Groups | Buffer Pool |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEPT_PRIMARY_KEY | NORMAL | UNIQUE | SCOTT | DEPT | DEPTNO | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | |||
DEPT_PRIMARY_KEY1 | NORMAL | UNIQUE | SCOTT | DEPT_MV | DEPTNO | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT | |||
EMP_PRIMARY_KEY | NORMAL | UNIQUE | SCOTT | EMP | EMPNO | 64K | USERS | 1 | 64K | 0 | 1 | 2147483645 | DEFAULT |
Obj Type | Name | Status | Lines of Code | # of Objects |
---|---|---|---|---|
PACKAGE | EMP_PKG | VALID | 7 | 2 |
PACKAGE | MY_PACKAGE | VALID | 2 | 0 |
PACKAGE BODY | EMP_PKG | VALID | 64 | |
PACKAGE BODY | MY_PACKAGE | INVALID | 3 |
Name | Status | Lines of Code | Arguments |
---|---|---|---|
EMP_LOOPING | VALID | 26 | 0 |
Name | Status | Lines of Code | Arguments |
---|---|---|---|
OBJECTNAME | VALID | 11 | 2 |
Synonym Name | Object Owner | Object Name | DB Link |
---|---|---|---|
SCOTT_EMPLOYEE | SCOTT | EMP |
Roles
![]() |
![]() |
![]() |
![]() |
Privilege | Admin Option? |
---|---|
ALTER SESSION | No |
CREATE CLUSTER | No |
CREATE DATABASE LINK | No |
CREATE SEQUENCE | No |
CREATE SESSION | No |
CREATE SYNONYM | No |
CREATE TABLE | No |
CREATE VIEW | No |
Roles
![]() |
![]() |
![]() |
![]() |
Privilege | Admin Option? |
---|---|
ADMINISTER DATABASE TRIGGER | Yes |
ADMINISTER RESOURCE MANAGER | Yes |
ALTER ANY CLUSTER | Yes |
ALTER ANY DIMENSION | Yes |
ALTER ANY EVALUATION CONTEXT | Yes |
ALTER ANY INDEX | Yes |
ALTER ANY INDEXTYPE | Yes |
ALTER ANY LIBRARY | Yes |
ALTER ANY OUTLINE | Yes |
ALTER ANY PROCEDURE | Yes |
ALTER ANY ROLE | Yes |
ALTER ANY RULE | Yes |
ALTER ANY RULE SET | Yes |
ALTER ANY SEQUENCE | Yes |
ALTER ANY SNAPSHOT | Yes |
ALTER ANY TABLE | Yes |
ALTER ANY TRIGGER | Yes |
ALTER ANY TYPE | Yes |
ALTER DATABASE | Yes |
ALTER PROFILE | Yes |
ALTER RESOURCE COST | Yes |
ALTER ROLLBACK SEGMENT | Yes |
ALTER SESSION | Yes |
ALTER SYSTEM | Yes |
ALTER TABLESPACE | Yes |
ALTER USER | Yes |
ANALYZE ANY | Yes |
AUDIT ANY | Yes |
AUDIT SYSTEM | Yes |
BACKUP ANY TABLE | Yes |
BECOME USER | Yes |
COMMENT ANY TABLE | Yes |
CREATE ANY CLUSTER | Yes |
CREATE ANY CONTEXT | Yes |
CREATE ANY DIMENSION | Yes |
CREATE ANY DIRECTORY | Yes |
CREATE ANY EVALUATION CONTEXT | Yes |
CREATE ANY INDEX | Yes |
CREATE ANY INDEXTYPE | Yes |
CREATE ANY LIBRARY | Yes |
CREATE ANY OPERATOR | Yes |
CREATE ANY OUTLINE | Yes |
CREATE ANY PROCEDURE | Yes |
CREATE ANY RULE | Yes |
CREATE ANY RULE SET | Yes |
CREATE ANY SEQUENCE | Yes |
CREATE ANY SNAPSHOT | Yes |
CREATE ANY SYNONYM | Yes |
CREATE ANY TABLE | Yes |
CREATE ANY TRIGGER | Yes |
CREATE ANY TYPE | Yes |
CREATE ANY VIEW | Yes |
CREATE CLUSTER | Yes |
CREATE DATABASE LINK | Yes |
CREATE DIMENSION | Yes |
CREATE EVALUATION CONTEXT | Yes |
CREATE INDEXTYPE | Yes |
CREATE LIBRARY | Yes |
CREATE OPERATOR | Yes |
CREATE PROCEDURE | Yes |
CREATE PROFILE | Yes |
CREATE PUBLIC DATABASE LINK | Yes |
CREATE PUBLIC SYNONYM | Yes |
CREATE ROLE | Yes |
CREATE ROLLBACK SEGMENT | Yes |
CREATE RULE | Yes |
CREATE RULE SET | Yes |
CREATE SEQUENCE | Yes |
CREATE SESSION | Yes |
CREATE SNAPSHOT | Yes |
CREATE SYNONYM | Yes |
CREATE TABLE | Yes |
CREATE TABLESPACE | Yes |
CREATE TRIGGER | Yes |
CREATE TYPE | Yes |
CREATE USER | Yes |
CREATE VIEW | Yes |
DEBUG ANY PROCEDURE | Yes |
DEBUG CONNECT SESSION | Yes |
DELETE ANY TABLE | Yes |
DEQUEUE ANY QUEUE | Yes |
DROP ANY CLUSTER | Yes |
DROP ANY CONTEXT | Yes |
DROP ANY DIMENSION | Yes |
DROP ANY DIRECTORY | Yes |
DROP ANY EVALUATION CONTEXT | Yes |
DROP ANY INDEX | Yes |
DROP ANY INDEXTYPE | Yes |
DROP ANY LIBRARY | Yes |
DROP ANY OPERATOR | Yes |
DROP ANY OUTLINE | Yes |
DROP ANY PROCEDURE | Yes |
DROP ANY ROLE | Yes |
DROP ANY RULE | Yes |
DROP ANY RULE SET | Yes |
DROP ANY SEQUENCE | Yes |
DROP ANY SNAPSHOT | Yes |
DROP ANY SYNONYM | Yes |
DROP ANY TABLE | Yes |
DROP ANY TRIGGER | Yes |
DROP ANY TYPE | Yes |
DROP ANY VIEW | Yes |
DROP PROFILE | Yes |
DROP PUBLIC DATABASE LINK | Yes |
DROP PUBLIC SYNONYM | Yes |
DROP ROLLBACK SEGMENT | Yes |
DROP TABLESPACE | Yes |
DROP USER | Yes |
ENQUEUE ANY QUEUE | Yes |
EXECUTE ANY EVALUATION CONTEXT | Yes |
EXECUTE ANY INDEXTYPE | Yes |
EXECUTE ANY LIBRARY | Yes |
EXECUTE ANY OPERATOR | Yes |
EXECUTE ANY PROCEDURE | Yes |
EXECUTE ANY RULE | Yes |
EXECUTE ANY RULE SET | Yes |
EXECUTE ANY TYPE | Yes |
FLASHBACK ANY TABLE | Yes |
FORCE ANY TRANSACTION | Yes |
FORCE TRANSACTION | Yes |
GLOBAL QUERY REWRITE | Yes |
GRANT ANY OBJECT PRIVILEGE | Yes |
GRANT ANY PRIVILEGE | Yes |
GRANT ANY ROLE | Yes |
INSERT ANY TABLE | Yes |
LOCK ANY TABLE | Yes |
MANAGE ANY QUEUE | Yes |
MANAGE TABLESPACE | Yes |
ON COMMIT REFRESH | Yes |
QUERY REWRITE | Yes |
RESTRICTED SESSION | Yes |
RESUMABLE | Yes |
SELECT ANY DICTIONARY | Yes |
SELECT ANY SEQUENCE | Yes |
SELECT ANY TABLE | Yes |
UNDER ANY TABLE | Yes |
UNDER ANY TYPE | Yes |
UNDER ANY VIEW | Yes |
UPDATE ANY TABLE | Yes |
Role Name | Default Role? | Admin Option? |
---|---|---|
DELETE_CATALOG_ROLE | Yes | Yes |
EXECUTE_CATALOG_ROLE | Yes | Yes |
EXP_FULL_DATABASE | Yes | No |
GATHER_SYSTEM_STATISTICS | Yes | No |
IMP_FULL_DATABASE | Yes | No |
JAVA_ADMIN | Yes | No |
JAVA_DEPLOY | Yes | No |
OLAP_DBA | Yes | No |
SELECT_CATALOG_ROLE | Yes | Yes |
WM_ADMIN_ROLE | Yes | No |
XDBADMIN | Yes | No |
Roles
![]() |
![]() |
![]() |
![]() |
Roles
![]() |
![]() |
![]() |
![]() |
Privilege | Admin Option? |
---|---|
CREATE CLUSTER | No |
CREATE INDEXTYPE | No |
CREATE OPERATOR | No |
CREATE PROCEDURE | No |
CREATE SEQUENCE | No |
CREATE TABLE | No |
CREATE TRIGGER | No |
CREATE TYPE | No |
Types
![]() |
![]() |
![]() |
![]() |
Status | Type Code | Attributes | Methods | Dependencies |
---|---|---|---|---|
INVALID | OBJECT | 0 | 0 | 0 |
Type NEWUSERDEFINEDTYPE Source |
---|
TYPE NEWUSERDEFINEDTYPE AS OBJECT ( a null ); |
--------- No privileges granted on NEWUSERDEFINEDTYPE ---------
--------- NEWUSERDEFINEDTYPE does not reference any objects ---------
--------- No objects reference NEWUSERDEFINEDTYPE ---------
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | ENAME | CHAR(10 BYTE) | |||
2 | JOB | CHAR(9 BYTE) | |||
3 | SAL | NUMBER | |||
4 | COMM | NUMBER |
--------- BONUS is not partitioned. ---------
--------- No Indexes on BONUS ---------
--------- No Triggers on BONUS ---------
--------- No Constraints on BONUS ---------
--------- No Policies on BONUS ---------
--------- No privileges granted on BONUS ---------
--------- BONUS does not reference any objects ---------
--------- No objects reference BONUS ---------
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | DEPTNO | NUMBER(2) | Y | ||
2 | DNAME | CHAR(14 BYTE) | |||
3 | LOC | CHAR(13 BYTE) |
--------- DEPT is not partitioned. ---------
Uniqueness | Index Name | Columns | Partition Count | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|
UNIQUE | DEPT_PRIMARY_KEY | DEPTNO |
--------- No Triggers on DEPT ---------
Name | Type | Condition | Status | Columns |
---|---|---|---|---|
DEPT_PRIMARY_KEY | Primary Key | ENABLED | DEPTNO |
--------- No Policies on DEPT ---------
--------- No privileges granted on DEPT ---------
--------- DEPT does not reference any objects ---------
Object Owner | Object Name | Object Type |
---|---|---|
SCOTT | EMP | Table (FK) |
SCOTT | EMP_PKG | Package Body |
SCOTT | DEPT_MV | Materialized View |
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | DEPTNO | NUMBER(2) | Y |
--------- DEPT_MV is not partitioned. ---------
Uniqueness | Index Name | Columns | Partition Count | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|
UNIQUE | DEPT_PRIMARY_KEY1 | DEPTNO |
--------- No Triggers on DEPT_MV ---------
Name | Type | Condition | Status | Columns |
---|---|---|---|---|
DEPT_PRIMARY_KEY1 | Primary Key | ENABLED | DEPTNO |
--------- No Policies on DEPT_MV ---------
--------- No privileges granted on DEPT_MV ---------
--------- DEPT_MV does not reference any objects ---------
Object Owner | Object Name | Object Type |
---|---|---|
SCOTT | DEPT_MV | Materialized View Log |
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | EMPNO | NUMBER(4) | Y | ||
2 | ENAME | CHAR(10 BYTE) | |||
3 | JOB | CHAR(9 BYTE) | |||
4 | MGR | NUMBER(4) | |||
5 | HIREDATE | DATE | |||
6 | SAL | NUMBER(7,2) | |||
7 | COMM | NUMBER(7,2) | |||
8 | DEPTNO | NUMBER(2) | Y |
--------- EMP is not partitioned. ---------
Uniqueness | Index Name | Columns | Partition Count | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|
UNIQUE | EMP_PRIMARY_KEY | EMPNO |
Trigger Name | Status | Triggering Event | When Clause | Trigger Type | Body | |
---|---|---|---|---|---|---|
TRIGGER1 | ENABLED | INSERT | BEFORE STATEMENT |
|
Name | Columns | Ref Table Owner | Ref Table Name | Ref Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
EMP_FOREIGN_KEY | DEPTNO | SCOTT | DEPT | DEPTNO | NO ACTION | ENABLED | No | No |
EMP_SELF_KEY | MGR | SCOTT | EMP | EMPNO | NO ACTION | ENABLED | No | No |
Name | Type | Condition | Status | Columns |
---|---|---|---|---|
EMP_PRIMARY_KEY | Primary Key | ENABLED | EMPNO |
--------- No Policies on EMP ---------
--------- No privileges granted on EMP ---------
Object Owner | Object Name | Object Type |
---|---|---|
SCOTT | DEPT | Table |
SCOTT | EMP | Table |
Object Owner | Object Name | Object Type |
---|---|---|
SCOTT | EMP | Table (FK) |
SCOTT | EMP_PKG | Package Body |
SCOTT | EMP_LOOPING | Procedure |
SCOTT | "MATERIALIZED VIEW1" | Materialized View |
SCOTT | USER0_EMP10 | View |
SCOTT | TRIGGER1 | Trigger |
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | "COUNT(*)" | NUMBER |
--------- "MATERIALIZED VIEW1" is not partitioned. ---------
--------- No Indexes on "MATERIALIZED VIEW1" ---------
--------- No Triggers on "MATERIALIZED VIEW1" ---------
--------- No Constraints on "MATERIALIZED VIEW1" ---------
--------- No Policies on "MATERIALIZED VIEW1" ---------
--------- No privileges granted on "MATERIALIZED VIEW1" ---------
--------- "MATERIALIZED VIEW1" does not reference any objects ---------
--------- No objects reference "MATERIALIZED VIEW1" ---------
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | DEPTNO | NUMBER(2) | |||
2 | SNAPTIME$$ | DATE | |||
3 | DMLTYPE$$ | VARCHAR2(1 BYTE) | |||
4 | OLD_NEW$$ | VARCHAR2(1 BYTE) | |||
5 | CHANGE_VECTOR$$ | RAW(255) |
--------- MLOG$_DEPT_MV is not partitioned. ---------
--------- No Indexes on MLOG$_DEPT_MV ---------
--------- No Triggers on MLOG$_DEPT_MV ---------
--------- No Constraints on MLOG$_DEPT_MV ---------
--------- No Policies on MLOG$_DEPT_MV ---------
--------- No privileges granted on MLOG$_DEPT_MV ---------
--------- MLOG$_DEPT_MV does not reference any objects ---------
--------- No objects reference MLOG$_DEPT_MV ---------
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | STATEMENT_ID | VARCHAR2(30 BYTE) | |||
2 | TIMESTAMP | DATE | |||
3 | REMARKS | VARCHAR2(80 BYTE) | |||
4 | OPERATION | VARCHAR2(30 BYTE) | |||
5 | OPTIONS | VARCHAR2(255 BYTE) | |||
6 | OBJECT_NODE | VARCHAR2(128 BYTE) | |||
7 | OBJECT_OWNER | VARCHAR2(30 BYTE) | |||
8 | OBJECT_NAME | VARCHAR2(30 BYTE) | |||
9 | OBJECT_INSTANCE | INTEGER | |||
10 | OBJECT_TYPE | VARCHAR2(30 BYTE) | |||
11 | OPTIMIZER | VARCHAR2(255 BYTE) | |||
12 | SEARCH_COLUMNS | NUMBER | |||
13 | ID | INTEGER | |||
14 | PARENT_ID | INTEGER | |||
15 | POSITION | INTEGER | |||
16 | COST | INTEGER | |||
17 | CARDINALITY | INTEGER | |||
18 | BYTES | INTEGER | |||
19 | OTHER_TAG | VARCHAR2(255 BYTE) | |||
20 | PARTITION_START | VARCHAR2(255 BYTE) | |||
21 | PARTITION_STOP | VARCHAR2(255 BYTE) | |||
22 | PARTITION_ID | INTEGER | |||
23 | OTHER | LONG | |||
24 | DISTRIBUTION | VARCHAR2(30 BYTE) | |||
25 | CPU_COST | INTEGER | |||
26 | IO_COST | INTEGER | |||
27 | TEMP_SPACE | INTEGER | |||
28 | ACCESS_PREDICATES | VARCHAR2(4000 BYTE) | |||
29 | FILTER_PREDICATES | VARCHAR2(4000 BYTE) |
--------- PLAN_TABLE is not partitioned. ---------
--------- No Indexes on PLAN_TABLE ---------
--------- No Triggers on PLAN_TABLE ---------
--------- No Constraints on PLAN_TABLE ---------
--------- No Policies on PLAN_TABLE ---------
--------- No privileges granted on PLAN_TABLE ---------
--------- PLAN_TABLE does not reference any objects ---------
--------- No objects reference PLAN_TABLE ---------
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | DEPTNO | NUMBER(2) | |||
2 | DMLTYPE$$ | VARCHAR2(1 BYTE) | |||
3 | SNAPID | INTEGER | |||
4 | CHANGE_VECTOR$$ | RAW(255) |
--------- RUPD$_DEPT_MV is not partitioned. ---------
--------- No Indexes on RUPD$_DEPT_MV ---------
--------- No Triggers on RUPD$_DEPT_MV ---------
--------- No Constraints on RUPD$_DEPT_MV ---------
--------- No Policies on RUPD$_DEPT_MV ---------
--------- No privileges granted on RUPD$_DEPT_MV ---------
--------- RUPD$_DEPT_MV does not reference any objects ---------
--------- No objects reference RUPD$_DEPT_MV ---------
Tables
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | GRADE | NUMBER | |||
2 | LOSAL | NUMBER | |||
3 | HISAL | NUMBER |
--------- SALGRADE is not partitioned. ---------
--------- No Indexes on SALGRADE ---------
--------- No Triggers on SALGRADE ---------
--------- No Constraints on SALGRADE ---------
--------- No Policies on SALGRADE ---------
--------- No privileges granted on SALGRADE ---------
--------- SALGRADE does not reference any objects ---------
--------- No objects reference SALGRADE ---------
Views
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Comments |
---|---|---|---|---|
1 | REPID | |||
2 | CUSTID | |||
3 | CUSTNAME | |||
4 | PRODID | |||
5 | PRODNAME | |||
6 | AMOUNT |
View SALES Source |
---|
SELECT REPID, ORD.CUSTID, CUSTOMER.NAME CUSTNAME, PRODUCT.PRODID, DESCRIP PRODNAME, SUM(ITEMTOT) AMOUNT FROM ORD, ITEM, CUSTOMER, PRODUCT WHERE ORD.ORDID = ITEM.ORDID AND ORD.CUSTID = CUSTOMER.CUSTID AND ITEM.PRODID = PRODUCT.PRODID GROUP BY REPID, ORD.CUSTID, NAME, PRODUCT.PRODID, DESCRIP |
--------- No Triggers on SALES ---------
--------- No privileges granted on SALES ---------
Object Owner | Object Name | Object Type |
---|---|---|
"PUBLIC" | PRODUCT |
--------- No objects reference SALES ---------
Views
![]() |
![]() |
![]() |
![]() |
Col # | Column Name | Data Type | Not Null? | Comments |
---|---|---|---|---|
1 | DEPTNO | NUMBER(2) | Y | |
2 | ENAME | CHAR(10) | ||
3 | SAL | NUMBER(7,2) |
View USER0_EMP10 Source |
---|
select deptno, ename, sal from emp where deptno = 10 |
--------- No Triggers on USER0_EMP10 ---------
--------- No privileges granted on USER0_EMP10 ---------
Object Owner | Object Name | Object Type |
---|---|---|
SCOTT | EMP | Table |
--------- No objects reference USER0_EMP10 ---------
Sequences
![]() |
![]() |
![]() |
![]() |
Min Value | Max Value | Increment By | Cycle Flag | Order Flag | Cache Size | Last Number |
---|---|---|---|---|---|---|
1 | 999999999999999999999999999 | 1 | No | No | 0 | 109 |
--------- No privileges granted on CUSTID ---------
--------- CUSTID does not reference any objects ---------
--------- No objects reference CUSTID ---------
Sequences
![]() |
![]() |
![]() |
![]() |
Min Value | Max Value | Increment By | Cycle Flag | Order Flag | Cache Size | Last Number |
---|---|---|---|---|---|---|
1 | 999999999999999999999999999 | 1 | No | No | 0 | 622 |
--------- No privileges granted on ORDID ---------
--------- ORDID does not reference any objects ---------
--------- No objects reference ORDID ---------
Sequences
![]() |
![]() |
![]() |
![]() |
Min Value | Max Value | Increment By | Cycle Flag | Order Flag | Cache Size | Last Number |
---|---|---|---|---|---|---|
1 | 999999999999999999999999999 | 1 | No | No | 0 | 200381 |
--------- No privileges granted on PRODID ---------
--------- PRODID does not reference any objects ---------
--------- No objects reference PRODID ---------
Sequences
![]() |
![]() |
![]() |
![]() |
Min Value | Max Value | Increment By | Cycle Flag | Order Flag | Cache Size | Last Number |
---|---|---|---|---|---|---|
1 | 999999999999999999999999999 | 1 | No | No | 20 | 1 |
--------- No privileges granted on TOAD_SEQ ---------
--------- TOAD_SEQ does not reference any objects ---------
--------- No objects reference TOAD_SEQ ---------
Packages
![]() |
![]() |
![]() |
![]() |
Object Name | Overload | Argument Name | Sequence | Data Type | Direction |
---|---|---|---|---|---|
EMP_FUNC |
0 | 1 | VARCHAR2 | OUT | |
EMP_FUNC |
0 | V_DEPTNO | 2 | NUMBER | IN |
EMP_PROC |
0 | V_ENAME | 1 | VARCHAR2 | IN |
Package EMP_PKG Source |
---|
PACKAGE EMP_PKG IS PROCEDURE EMP_proc (v_ename IN varchar2); FUNCTION EMP_func (v_DEPTNO NUMBER) return varchar2; END EMP_PKG; |
Package Body EMP_PKG Source |
---|
PACKAGE BODY EMP_PKG IS PROCEDURE EMP_proc (v_ename IN varchar2) is cursor emp_cur is select ename, deptno from emp; v_dname dept.dname%TYPE; v_oraerr number(10); v_oramsg varchar2(1200); BEGIN select EMP_pkg.EMP_func(deptno) into v_dname from emp where ename = v_ename; dbms_output.put_line('Employee ' || v_ename || ' works in dept ' || v_dname); EXCEPTION when NO_DATA_FOUND then dbms_output.put_line('No Data Found'); raise; when OTHERS then v_oraerr := SQLCODE; v_oramsg := SQLERRM; dbms_output.put_line('Oracle Error: ' || v_oraerr || ' ' || v_oramsg); END EMP_proc; FUNCTION EMP_func (v_DEPTNO NUMBER) return varchar2 is v_dname dept.dname%TYPE; v_oraerr number(10); v_oramsg varchar2(1200); begin select dname into v_dname from dept where v_deptno = deptno; return(v_dname); EXCEPTION when NO_DATA_FOUND then return('No Data Found'); raise; when OTHERS then v_oraerr := SQLCODE; v_oramsg := SQLERRM; dbms_output.put_line('Oracle Error: ' || v_oraerr || ' ' || v_oramsg); end EMP_func; END EMP_pkg; |
--------- No privileges granted on EMP_PKG ---------
Object Owner | Object Name | Object Type |
---|---|---|
"PUBLIC" | DBMS_OUTPUT | Synonym |
SCOTT | EMP | Table |
SCOTT | DEPT | Table |
SCOTT | DBMS_OUTPUT |
--------- No objects reference EMP_PKG ---------
Packages
![]() |
![]() |
![]() |
![]() |
--------- Package MY_PACKAGE does not have any arguments ---------
Package MY_PACKAGE Source |
---|
PACKAGE "MY_PACKAGE" AS END; |
Package Body MY_PACKAGE Source |
---|
PACKAGE BODY "MY_PACKAGE" AS dbms_output.PUT_LINE("hello world"); END; |
--------- No privileges granted on MY_PACKAGE ---------
--------- MY_PACKAGE does not reference any objects ---------
--------- No objects reference MY_PACKAGE ---------
Procedures
![]() |
![]() |
![]() |
![]() |
--------- Procedure EMP_LOOPING does not have any arguments ---------
Procedure EMP_LOOPING Source |
---|
PROCEDURE emp_looping IS loop_cntr NUMBER := 0; CURSOR emp_cur IS SELECT ename, sal FROM emp; emp_rec emp_cur % rowtype; BEGIN OPEN emp_cur; FETCH emp_cur INTO emp_rec; WHILE emp_cur % FOUND LOOP loop_cntr := loop_cntr + 1; DBMS_OUTPUT.PUT_LINE('Employee ' || emp_rec.ename || ' makes ' || emp_rec.sal); FETCH emp_cur INTO emp_rec; END LOOP; CLOSE emp_cur; END; |
--------- No privileges granted on EMP_LOOPING ---------
Object Owner | Object Name | Object Type |
---|---|---|
"PUBLIC" | DBMS_OUTPUT | Synonym |
SCOTT | EMP | Table |
SCOTT | DBMS_OUTPUT |
--------- No objects reference EMP_LOOPING ---------
Functions
![]() |
![]() |
![]() |
![]() |
Argument Name | Data Type | Direction |
---|---|---|
VARCHAR2 | OUT | |
IN_OBJECT_ID | NUMBER | IN |
Function OBJECTNAME Source |
---|
function ObjectName(in_object_id in number) return varchar is return_string varchar2(100); begin select OWNER||'.'||OBJECT_NAME into return_string from all_objects where object_id = in_object_id; return return_string; end ObjectName; |
Column | Grantee | Grantable Privilege(s) | Non-Grantable Privilege(s) |
---|---|---|---|
PUBLIC | EXECUTE |
Object Owner | Object Name | Object Type |
---|---|---|
"PUBLIC" | ALL_OBJECTS | Synonym |
SCOTT | ALL_OBJECTS |
Object Owner | Object Name | Object Type |
---|---|---|
SCOTT | OBJECTNAME TO PUBLIC | Grant |