Previous Topic

Next Topic

Book Contents

Book Index

Oracle

The Database Explorer window provides the following support for Oracle objects.

Tables

Display

Actions

List Displays

  • List of objects (Tables, View, Synonyms)
  • List of of objects with Description
  • List of objects with Date Created
  • List of Tables with Table Sizing
  • List of Tables with Table Status
  • List of Dropped Tables
  • List of Invalid Objects
  • List Synonyms on remote databases

Details Display

  • Columns
  • Column Statistics
  • Columns including Hidden/Virtual columns
  • Primary key
  • Indexes
  • Unique columns
  • All Constraints
  • Table Status
  • Table Extents
  • Table Partitions
  • Table Privileges (involving you)
  • Table Privileges (by all)
  • Objects Referencing Table
  • Synonyms on Table
  • Triggers on Table
  • Referenced Tables (foreign keys)
  • Dependent Tables
  • Create / Alter / Drop / Redefine Table
  • Create View on table
  • Create Primary Key / Index on Table
  • Create Foreign Key on Table
  • Create Trigger on Table
  • Create Check Constraint on Table
  • Create Synonym on Table
  • Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases
  • Compare Tables definitions
  • Manage Table Comments
  • Manage Column Comments
  • Rename table/s
  • Analyze Table/s
  • Truncate Table/s
  • Analyze Table by Partition
  • Enable Constraints
  • Disable Constraints
  • Administer Authorities for Table

Views

Display

Actions

  • Columns
  • View Definition
  • Details of View
  • Objects Referencing View
  • Synonyms on View
  • Objects in View
  • Status of View
  • View Privileges (involving you)
  • View Privileges (by all)
  • Create / Redefine / Drop View
  • Generate DDL for View
  • Compare View definitions
  • Manage Comments for Views
  • Manage Comments for View Columns
  • Compile View
  • Administer Authorities for View

Synonyms

Display

Actions

  • Columns
  • Synonym Definition
  • Status of Synonym
  • Synonym Privileges (involving you)
  • Synonym Privileges (by all)
  • Create / Drop / Synonym
  • Create Remote Synonym
  • Generate DDL for Synonym
  • Administer Authorities for Synonym

Recycle Bin

Display

Actions

  • List of User and DBA items
  • Details of Dropped object
  • Purge Dropped Object
  • Restore Dropped Object

Indexes

Display

Actions

List Displays

  • List of Indexes
  • List of Indexes with Type and Status
  • List of Dropped Indexes

Detail Displays

  • Index Columns
  • Details of Index
  • Create / Drop Index
  • Create Primary Key
  • Generate DDL for Index
  • Analyze Index

Triggers

Display

Actions

List Displays

  • List of Triggers with Status
  • List of Triggers with Date Created
  • List of Disabled Triggers
  • List of Invalid Triggers

Detail Displays

  • Details of Trigger
  • Trigger Text
  • Trigger Columns
  • Objects Referenced by Trigger
  • Objects Referencing Trigger
  • Compilation Errors
  • Create / Redefine / Drop Trigger
  • Generate DDL for Trigger
  • Compare Trigger Definitions
  • Rename Trigger/s
  • Enable Trigger/s
  • Disable Trigger/s
  • Compile Trigger/s

Tablespaces

Display

Actions

List Displays

  • List of Tablespaces with Status
  • List of Tablespaces with Space Usage

Detail Displays

  • Details of Tablespace
  • Tables within Tablespace
  • Indexes within Tablespace
  • User Quotas
  • Tablespace File Usage
  • Segments
  • Create / Alter Tablespace
  • Generate DDL for Tablespace (including tables)
  • Compare Tablespace Definitions
  • Set offline Tablespace/s online
  • Change Tablespace State

Users

Display

Actions

  • Details of User
  • Table authorities (involving you)
  • Procedure authorities (involving you)
  • Table authorities (all)
  • Procedure authorities (all)
  • System Privileges
  • Roles
  • Tablespace Quotas
  • Create / Alter / Drop / User
  • Generate DDL for User
  • Compare User definitions
  • Manage Table/View/Synonym authorities
  • Manage Procedure authorities
  • Manage Roles for User
  • Manage System Privileges for User

Roles

Display

Actions

  • Users with Role
  • Table authorities
  • Procedure authorities
  • System Privileges
  • Create / Alter / Drop Role
  • Generate DDL for Role
  • Manage Table/View/Synonym authorities
  • Manage Procedure authorities
  • Manage Roles for Roles
  • Manage members of Role
  • Manage System Privileges for User

Functions

Display

Actions

List Displays

  • List of Functions
  • List of Functions with Date Created
  • List of Invalid Functions

Detail Displays

  • Details of Function
  • Function Text
  • Objects Referenced by Function
  • Objects Referencing Function
  • Compilation Errors
  • Create / Alter / Drop Function
  • Generate DDL for Function
  • Compare Function definitions
  • Compile Function

Procedures

Display

Actions

List Displays

  • List of Procedures
  • List of Procedures with Date Created
  • List of Invalid Procedures

Detail Displays

  • Procedures Parameters
  • Details of Procedure
  • Procedure Text
  • Objects Referenced by Procedure
  • Objects Referencing Procedure
  • Compilation Errors
  • Privileges of Procedure (involving you)
  • Privileges of Procedure (all)
  •  
  • Create / Alter / Drop Procedure
  • Generate DDL for Procedure
  • Compare Procedure definitions
  • Compile Procedure
  • Manage Authorities for Procedure

Packages

Display

Actions

List Displays

  • List of Packages
  • List of Packages with Date Created
  • List of Invalid Packages

Detail Displays

  • Procedures Parameters
  • Details of Procedure
  • Procedure Text
  • Objects Referenced by Procedure
  • Objects Referencing Procedure
  • Compilation Errors
  • Privileges of Procedure (involving you)
  • Privileges of Procedure (all)
  •  
  • Create / Alter / Drop Package
  • Create / Alter Package Body
  • Generate DDL for Package

Sequences

Display

Actions

  • Details of Sequence
  • Objects Referencing Sequence
  • Create / Alter / Drop Sequence
  • Generate DDL for Sequence

Snapshots

Display

Actions

  • Details of Snapshot
  • Snapshot text
  • Create / Alter / Drop Snapshot
  • Generate DDL for Snapshot
  • Refresh Snapshot

Types

Display

Actions

  • Details of Type
  • Columns comprising Type
  • Methods of Type
  • Text of Type
  • Compilation errors
  • Table / View column using Type
  • Objects Referenced by Type
  • Objects Referencing Type
  • Create / Alter / Drop Sequence
  • Generate DDL for Sequence

Other Objects

Object

  • DBLinks
  • Dimensions
  • XML Tables
  • Jobs
  • Scheduler Jobs