Schema SCOTT in Database ORAXP9I

Oracle Version 9.2.0.1.0

As Of 9/24/2007 10:41:13 PM

 

--------------------- 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 Counts

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

 

User Info

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

 

Profile Info

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 Privileges

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

 

System Privileges

Privilege Admin Option?
UNLIMITED TABLESPACE No

 

User SCOTT does not have any specific tablespace quotas.

 

 

Granted Roles

Role Name Default Role? Admin Option?
DBA Yes No
CONNECT Yes No
RESOURCE Yes No
QUEST_SL_SQLAB_ROLE Yes No

 

Types

Top
Type Name Status Type Code Attributes Methods Dependencies
NEWUSERDEFINEDTYPE INVALID OBJECT 0 0 0

 

Tables

Top
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  

 

Views

Top
View Name Status # of Columns Text Length # of Dependencies Comment
SALES INVALID 6 290 1  
USER0_EMP10 VALID 3 52 1  

 

Materialized Views

Top
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

Schema SCOTT does not contain any refresh group.

 

 

Materialized View Logs

Top
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

 

 

Sequences

Top
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

 

 

Triggers

Top
Trigger Name Type Event Base Obj. Type Base Object
TRIGGER1 BEFORE STATEMENT INSERT Table SCOTT.EMP

 

 

Indexes

Top
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

 

 

Packages

Top
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  

 

Procedures

Top
Name Status Lines of Code Arguments
EMP_LOOPING VALID 26 0

 

Functions

Top
Name Status Lines of Code Arguments
OBJECTNAME VALID 11 2

 

Synonyms

Top
Synonym Name Object Owner Object Name DB Link
SCOTT_EMPLOYEE SCOTT EMP  

 

Schema SCOTT does not contain any dimensions.

 

Schema SCOTT does not contain any jobs.

 

Schema SCOTT does not contain any scheduler jobs.

 

Schema SCOTT does not contain any scheduler programs.

 

Schema SCOTT does not contain any scheduler schedules.

 

Schema SCOTT does not contain any Libraries.

 

Schema SCOTT does not contain any Policy Groups.

 

Schema SCOTT does not contain any Policies.

 

 

Schema SCOTT does not contain any queue tables.

 

 

Schema SCOTT does not contain any queues.

 

Schema SCOTT does not contain any Clusters.

 

 

Roles

---------- Role CONNECT ----------

Role CONNECT has not been granted any object privileges.

System Privileges

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

Role CONNECT has not been granted any roles.

 

Roles

---------- Role DBA ----------

Role DBA has not been granted any object privileges.

System Privileges

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

Granted Roles

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

---------- Role QUEST_SL_SQLAB_ROLE ----------

Role QUEST_SL_SQLAB_ROLE has not been granted any object privileges.

Role QUEST_SL_SQLAB_ROLE has not been granted any system privileges.

Role QUEST_SL_SQLAB_ROLE has not been granted any roles.

 

Roles

---------- Role RESOURCE ----------

Role RESOURCE has not been granted any object privileges.

System Privileges

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

Role RESOURCE has not been granted any roles.

 

Types

---------- TYPE NEWUSERDEFINEDTYPE ----------

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

Top

 

 

Tables

---------- Table BONUS ----------

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

---------- Table DEPT ----------

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

 

Indexes on DEPT
Uniqueness Index Name Columns Partition Count Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE DEPT_PRIMARY_KEY DEPTNO          

--------- No Triggers on DEPT ---------

PK, UK, & Check Constraints 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 ---------

 

Objects which reference table DEPT
Object Owner Object Name Object Type
SCOTT EMP Table (FK)
SCOTT EMP_PKG Package Body
SCOTT DEPT_MV Materialized View

 

 

Tables

---------- Table DEPT_MV ----------

snapshot table for snapshot SCOTT.DEPT_MV
Col # Column Name Data Type Not Null? Data Def. Comments
1 DEPTNO NUMBER(2) Y    

--------- DEPT_MV is not partitioned. ---------

 

Indexes on DEPT_MV
Uniqueness Index Name Columns Partition Count Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE DEPT_PRIMARY_KEY1 DEPTNO          

--------- No Triggers on DEPT_MV ---------

PK, UK, & Check Constraints 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 ---------

 

Objects which reference table DEPT_MV
Object Owner Object Name Object Type
SCOTT DEPT_MV Materialized View Log

 

 

Tables

---------- Table EMP ----------

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

 

Indexes on EMP
Uniqueness Index Name Columns Partition Count Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE EMP_PRIMARY_KEY EMPNO          

 

Triggers on EMP
Trigger Name Status Triggering Event When Clause Trigger Type Body
TRIGGER1 ENABLED INSERT   BEFORE STATEMENT
BEGIN
  NULL;
END;

 

Foreign Key Constraints on EMP
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

 

PK, UK, & Check Constraints on EMP
Name Type Condition Status Columns
EMP_PRIMARY_KEY Primary Key   ENABLED EMPNO

 

--------- No Policies on EMP ---------

--------- No privileges granted on EMP ---------

 

Objects referenced by table EMP
Object Owner Object Name Object Type
SCOTT DEPT Table
SCOTT EMP Table

 

Objects which reference table EMP
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

---------- Table "MATERIALIZED VIEW1" ----------

snapshot table for snapshot SCOTT.MATERIALIZED VIEW1
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

---------- Table MLOG$_DEPT_MV ----------

snapshot log for master table SCOTT.DEPT_MV
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

---------- Table PLAN_TABLE ----------

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

---------- Table RUPD$_DEPT_MV ----------

temporary updatable snapshot log
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

---------- Table SALGRADE ----------

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

---------- View SALES ----------

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

 

Objects referenced by view SALES
Object Owner Object Name Object Type
"PUBLIC" PRODUCT  

--------- No objects reference SALES ---------

 

Views

---------- View USER0_EMP10 ----------

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

 

Objects referenced by view USER0_EMP10
Object Owner Object Name Object Type
SCOTT EMP Table

--------- No objects reference USER0_EMP10 ---------

 

Sequences

---------- Sequence CUSTID ----------

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

---------- Sequence ORDID ----------

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

---------- Sequence PRODID ----------

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

---------- Sequence TOAD_SEQ ----------

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

---------- Package EMP_PKG ----------

Objects and Arguments for EMP_PKG
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 ---------

 

Objects referenced by package 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 ----------

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

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

 

Objects referenced by procedure EMP_LOOPING
Object Owner Object Name Object Type
"PUBLIC" DBMS_OUTPUT Synonym
SCOTT EMP Table
SCOTT DBMS_OUTPUT  

--------- No objects reference EMP_LOOPING ---------

 

Functions

---------- Function OBJECTNAME ----------

Arguments for OBJECTNAME
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;

 

 

Granted Privileges on OBJECTNAME
Column Grantee Grantable Privilege(s) Non-Grantable Privilege(s)
  PUBLIC   EXECUTE

 

 

Objects referenced by function OBJECTNAME
Object Owner Object Name Object Type
"PUBLIC" ALL_OBJECTS Synonym
SCOTT ALL_OBJECTS  

 

Objects which reference function OBJECTNAME
Object Owner Object Name Object Type
SCOTT OBJECTNAME TO PUBLIC Grant