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