Database specific support for OracleDatabase specific support for Oracle

The following table show the database specific support for Database specific support for Oracle organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object Type Actions Viewers
Schemas
  Schemas
Schema
Export Schema, String Search  
Tables
Create Table, Import Table Data References, Table Comments, Tables
Table
Alter Table, Create Trigger, Export Table, Import Table Data, Analyze Table1, Comment Table, Copy Table, Create Index, Drop Table, Empty Table, Grant Privilege, Rename Table, Script: Script Table Navigator2, References, Columns, Columns Comment, Constraints, DDL with Storage4, DDL3, Data, Dependencies, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns
  Columns
Column
Comment Column Column
Constraints
  Constraints
Constraint
  Columns, DDL4, Info
Column
Comment Column Column
RefConstraints
  Constraints
RefConstraint
  Columns, DDL4, Info
Column
Comment Column Column
Indexes
  Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index Columns, DDL, DDL with Storage4, Index
Column
Comment Column Column
IndexPartitions
  Partitions
IndexPartition
  Info, Sub-Partitions
IndexSubPartition
  Info
Triggers
  Triggers
Trigger
Export Trigger, Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Partitions
  Partitions
Partition
  Info, Sub-Partitions
SubPartition
  Info
GlobalTempTables
Create Table, Import Table Data Tables
TempTable
Alter Table, Export Table, Import Table Data, Comment Table, Copy Table, Drop Table, Empty Table, Grant Privilege, Rename Table, Script: Script Table Columns, Columns Comment, Constraints, DDL with Storage4, DDL3, Data, Dependencies, Grants, Indexes, Info, Row Count
Columns
  Columns
Column
Comment Column Column
Views
Create View View Comments, Views
View
Export View, Comment View, Compile View, Create Trigger, Drop View, Rename View, Script: Script View Columns, Columns Comment, DDL, Data, Grants, Info, Row Count, Triggers
Columns
  Columns
Column
Comment Column Column
Triggers
  Triggers
Trigger
Export Trigger, Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Synonyms
Create Synonym Synonymed Objects, Synonyms
Synonym
Drop Synonym, Rename Synonym DDL3, Info
Indexes
  Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index Columns, DDL, DDL with Storage4, Index
Sequences
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence DDL3, Info
MaterializedViews
  Materialized Views
MaterializedView
Comment Materialized View, Drop Materialized View, Refresh Materialized View Columns, DDL4, Data, Grants, Indexes, Info, Row Count, Select SQL
Indexes
  Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index Columns, DDL, DDL with Storage4, Index
Column
Comment Column Column
Functions
Create Function Functions
Function
Export Function, Compile Function, Drop Function, Script: Script Function Function Editor, Grants
Procedures
Create Procedure Procedures
Procedure
Export Procedure, Compile Procedure, Drop Procedure, Script: Script Procedure Procedure Editor, Grants
Packages
Create Package Packages
Package
Export Package, Compile Package, Compile Package and Body, Create Package Body, Drop Package and Package Body Package Specification Editor, Grants
PackageBody
Export Package Body, Compile Package Body, Drop Package Body Package Body Editor, Grants
PackageBodies
Create Package Body Package Bodies
PackageBody
Export Package Body, Compile Package Body, Drop Package Body Package Body Editor, Grants
JavaSources5
  Java Sources
JavaSource
  Info, Source
JavaClasses5
  Java Classes
JavaClass
  Info
Triggers
  Triggers
Trigger
Export Trigger, Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
ObjectTypes
Create Object Type Object Types
ObjectType
Export Object Type, Compile Object Type, Compile Object Type and Body, Create Object Type Body, Drop Object Type and Type Body Object Type Editor, Attributes, Info, Methods
ObjectTypeBody
Export Object Type Body, Compile Object Type Body, Drop Object Type Body Object Type Editor, Attributes, Info, Methods
ObjectTypeBodies
Create Object Type Body Object Type Bodies
ObjectTypeBody
Export Object Type Body, Compile Object Type Body, Drop Object Type Body Object Type Editor, Attributes, Info, Methods
RecycleBin6
  Recycle Bin
RecycleBinTable
Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
Jobs
Create Job Jobs
Job
Disable Job, Enable Job, Remove Job, Run Job Info
Scheduler7
Disable Scheduler, Enable Scheduler, Set Scheduler Attribute Scheduler Global Attributes, Scheduler Jobs Running
SchedulerChains
Create Scheduler Chain Scheduler Chain Rules, Scheduler Chain Steps, Scheduler Chains, Scheduler Chains Running
SchedulerChain
Analyze Scheduler Chain, Disable Scheduler Chain, Drop Scheduler Chain, Enable Scheduler Chain, Run Scheduler Chain Scheduler Chain, Scheduler Chain Rules, Scheduler Chain Steps
SchedulerChainRules
Define Scheduler Chain Rule Scheduler Chain Rules
SchedulerChainRule
Drop Scheduler Chain Rule Scheduler Chain Rule
SchedulerChainSteps
Define Scheduler Chain Step Scheduler Chain Steps
SchedulerChainStep
Alter Scheduler Chain Step, Drop Scheduler Chain Step Scheduler Chain Step
SchedulerJobs
Create Scheduler Job Scheduler Job Arguments, Scheduler Job Logs, Scheduler Job Run Details, Scheduler Jobs, Scheduler Jobs Running
SchedulerJob
Alter Running Chain, Comment Scheduler Job, Copy Scheduler Job, Disable Scheduler Job, Drop Scheduler Job, Enable Scheduler Job, Modify Scheduler Job, Run Scheduler Job, Stop Scheduler Job Scheduler Job, Scheduler Job Logs, Scheduler Job Run Details
SchedulerJobArguments
Add Scheduler Job Argument Scheduler Job Arguments
SchedulerJobArgument
Edit Scheduler Job Argument, Remove Scheduler Job Argument Scheduler Job Argument
SchedulerPrograms
Create Scheduler Program Scheduler Program Arguments, Scheduler Programs
SchedulerProgram
Comment Scheduler Program, Disable Scheduler Program, Drop Scheduler Program, Enable Scheduler Program, Modify Scheduler Program Scheduler Program
SchedulerProgramArguments
Add Scheduler Program Argument Scheduler Program Arguments
SchedulerProgramArgument
Edit Scheduler Program Argument, Remove Scheduler Program Argument Scheduler Program Argument
SchedulerSchedules
Create Scheduler Schedule Scheduler Schedules
SchedulerSchedule
Drop Scheduler Schedule, Evaluate Scheduler Schedule Scheduler Schedule
SchedulerCredentials8
Create Scheduler Credential Scheduler Credentials
SchedulerCredential
Comment Credential, Drop Scheduler Credential, Modify Credential Scheduler Credential
DatabaseLinks
Create Database Link Database Links
DatabaseLink
Drop Database Link, Test Database Link DDL, Info
InvalidObjects
Compile All Invalid Objects
Properties
  Database Properties4, Initialization Parameters4, Session NLS Parameters4, Session Privileges, Session Roles
DBA
  DBA
Users
Create User Users
User
Change Password, Drop User, Expire Password, Grant Resource Group3, Lock User, Revoke Resource Consumer Group from User3, Set Default Resource Group for User3, Unlock User, Script: Clone User DDL9, Info, Resource Groups3, Roles, System Privileges, Table Privileges, Tablespace Quota
Roles
Create Role Roles
Role
Drop Role DDL4, Info, Roles, System Privileges, Table Privileges, Users
Sessions
  Active Sessions, Sessions, Traced Sessions7
Session
Disable Trace7, Enable Trace7, Kill Session Active SQL, Plan Data6, Session, Session Events, Session Wait
Replication4
   
DataGuard
  Archive Dest Status, Archive Destinations, Current db, DG Status, DG config6
LogicalStandby
  Archive Gap, Logical Standby Events, Unsupported objects
PhysicalStandby
  Archive Gap, Managed Standby Procs, Standby Log Files
Streams
  Archive Dest Status, Archive Destinations, Current db
StreamsCapture
  Capture Parameters, Capture Status, Capture extra Attr6, Registered Logs
StreamsApply
  Apply Latency, Apply Parameters, Apply Status, Capture-Apply Latency
Locks
  Blocking Locks, Locks 1, Locks 2
AllRecycleBin6
  Recycle Bin
AllRecycleBinTable
Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
ResourceManager3
Clear Pending Area, Create Pending Area, Generate Monitor SQL, Submit Pending Area, Validate Pending Area Resource Usage
ResourceConsumerMappings
   
ResourceConsumerMapping
Add Resource Group Mapping Resource Consumer Group Mapping
ResourceConsumerMappingValue
Remove From Resource Group Mapping  
ResourceConsumerGroups
Create Resource Consumer Group Resource Consumer Groups
ResourceConsumerGroup
Grant Resource Consumer Group to User, Group default for User, Remove Resource Consumer Group, Revoke Resource Consumer Group from User Resource Consumer Group, Resource Consumer Group Switch Privs
ResourcePlans
Create Resource Plan Resource Plans
ResourcePlan
Activate Resource Plan, Remove Resource Plan Resource Plan, Resource Plan Directives
ResourcePlanDirectives
Add Group to Plan Resource Plan Directives
ResourcePlanDirective
Modify Resource Directive, Remove Group from Plan Resource Plan Directive
Storage
  ASM Diskgroups6, Data Files, Directories, Redo Logs, Rollback Segments, Tablespaces, Temp Files
ASM6
  ASM Clients, ASM Diskgroups, Used Client
ASMDiskGroups
Add Disk Group Details, Usage
ASMDiskGroup
Add Disk to Group, Drop Disk Group, Rebalance Disk Group ASM Diskgroup, ASM Operation, Files
ASMDisk
Drop Disk ASM Disk
ASMDisks
  ASM Disk
ASMDisk
Drop Disk ASM Disk
SegmentAdvisor6
   
SegmentAdvisorTasks
Create Task Segment Advisor Findings, Segment Advisor Logs, Segment Advisor Recommendations, Segment Advisor Tasks
SegmentAdvisorTask
Cancel Task, Delete Task, Execute Task, Interrupt Task, Reset Task Segment Advisor Findings, Segment Advisor Log, Segment Advisor Recommendations, Segment Advisor Task
SegmentAdvisorObjects
Segment, Tablespace Segment Advisor Objects
SegmentAdvisorObject
Update Object Segment Advisor Object
SegmentAdvisorParameters
Set Parameter Segment Advisor Parameters
SegmentAdvisorParameter
  Segment Advisor Parameter
Tablespaces
  Datafile IO, Objects, Tablespaces, Usage By User
PermanentTablespaces
Create Tablespace Datafile IO, Objects, Tablespaces, Usage By User
PermanentTablespace
Add Datafile, Remove Tablespace, Rename Tablespace6, Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL4, Datafile IO, Datafiles, Objects, Tablespace, Usage By User, User Quota
PermanentDataFile
Remove Datafile6, Rename Datafile, Resize Datafile Data File, Objects
TemporaryTablespaces1
  Tablespaces
TemporaryTablespace
Add Datafile DDL4, Tablespace, User Quota
TemporaryTempFile
Remove Tempfile4, Resize Tempfile, Tempfile Offline4, Tempfile Online4 Temp File
UndoTablespaces4
  Datafile IO, Objects, Tablespaces, Usage By User
UndoTablespace
Add Datafile DDL4, Datafile IO, Objects, Tablespace, Usage By User
UndoDataFile
Resize Datafile Data File, Objects
TablespaceFiles
  Data Files, Temp Files
PermanentDataFile
Remove Datafile6, Rename Datafile, Resize Datafile Data File, Objects
PermanentTablespace
Add Datafile, Remove Tablespace, Rename Tablespace6, Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL4, Datafile IO, Datafiles, Objects, Tablespace, Usage By User, User Quota
TemporaryTempFile1
Remove Tempfile4, Resize Tempfile, Tempfile Offline4, Tempfile Online4 Temp File
TemporaryTablespace
Add Datafile DDL4, Tablespace, User Quota
UndoDataFile4
Resize Datafile Data File, Objects
UndoTablespace
Add Datafile DDL4, Datafile IO, Objects, Tablespace, Usage By User
RollbackSegments
Create Rollback Segment Rollback Segments
RollbackSegment
  DDL4, Rollback Segment
RedoLogs
Force Log Switch Redo Log Activity, Redo Logs
RedoLog
  Redo Logs
Directories4
Create Directory Directories
Directory
Drop Directory, Grant Privileges Directory, Directory Privileges
DirectoryPrivilege
Revoke Privileges  
dNFS8
  Channels, Files, Servers, Stats
Scheduler7
Disable Scheduler, Enable Scheduler, Set Scheduler Attribute Scheduler Global Attributes, Scheduler Jobs Running
SchedulerJobClasses
Create Scheduler Job Class Scheduler Job Classes
SchedulerJobClass
Drop Scheduler Job Class Scheduler Job Class
SchedulerWindows
Create Scheduler Window, Purge Window logs Scheduler Window Details, Scheduler Window Log, Scheduler Windows
SchedulerWindow
Close Scheduler Window, Comment Scheduler Window, Disable Scheduler Window, Drop Scheduler Window, Enable Scheduler Window, Modify Scheduler Window, Open Scheduler Window Scheduler Window, Scheduler Window Details, Scheduler Window Log
SchedulerWindowGroups
Create Scheduler Window Group Scheduler Window Groups
SchedulerWindowGroup
Add Window Group Member, Disable Scheduler Window Group, Drop Window Group, Enable Scheduler Window Group Scheduler Window Group
SchedulerWindowGroupMembers
  Scheduler Window Group Members
SchedulerWindowGroupMember
Remove Window Group Member Scheduler Window
Statistics
   
AWR6
Create Snapshot, Diff Report, Run Report AWR
InstanceInfo
  Instance Info
InstanceSummary
  Instance Summary
Latches
  Latches
ObjectCount
  Object Count
Waits
  Waits
SGA
Flush SGA Object Cache, Poorly performing SQL's, SGA
1) Version 8.1 and later
2) DbVisualizer Pro
3) Version 8 and later
4) Version 9 and later
5) If Java Support is installed in database
6) Version 10 and later
7) Version 10.1 and later
8) Version 11 and later
9) Version 7 and later