oracle
Oracle Tested for version 8i - 21c
Overview JDBC Drivers Features Supported Objects Download

Oracle

Oracle object type support.

The following table shows the database specific support in DbVisualizer 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 TypeActionsViewers
Image Image Schemas
   Schemas
Image Image Schema
 Export Schema[1], String Search References, Tables
Image Image Tables
 Create Table[1], Import Table Data[1] References, Table Comments, Tables
Image Image Table
 Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Analyze Table[2], Comment Table, Copy Table, Create Index, Drop Table, Empty Table, Grant Privilege, Rename Table Navigator[1], References, Data, Columns, Columns Comment, Constraints, DDL with Storage[4], DDL[3][1], Dependencies, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Constraints
   Constraints
Image Image Constraint
   Columns, DDL[4], Info
Image Image Column
 Comment Column Column
Image Image Referenced By Constraints
   Constraints
Image Image Ref Constraint
   Columns, DDL[4], Info
Image Image Column
 Comment Column Column
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL with Storage[4], DDL[1], Index
Image Image Column
 Comment Column Column
Image Image Partitions
   Partitions
Image Image Index Partition
   Info, Sub-Partitions
Image Image Index Sub Partition
   Info
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
Image Image Partitions
   Partitions
Image Image Partition
   Info, Sub-Partitions
Image Image Sub Partition
   Info
Image Image Global Temp Tables
 Create Table[1], Import Table Data[1] Tables
Image Image Temp Table
 Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Comment Table, Copy Table, Drop Table, Empty Table, Grant Privilege, Rename Table Data, Columns, Columns Comment, Constraints, DDL with Storage[4], DDL[3][1], Dependencies, Grants, Indexes, Info, Row Count
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Views
 Create View View Comments, Views
Image Image View
 Export View[1], Script: Script View, Comment View, Compile View, Create Trigger, Drop View, Grant Privilege, Rename View Data, Columns, Columns Comment, DDL[1], Grants, Info, Row Count, Triggers
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
Image Image Synonyms
 Create Synonym Synonymed Objects, Synonyms
Image Image Synonym
 Drop Synonym, Rename Synonym DDL[3][1], Info
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL with Storage[4], DDL[1], Index
Image Image Sequences
 Create Sequence Sequences
Image Image Sequence
 Script: Script Sequence, Drop Sequence, Rename Sequence DDL[3][1], Info
Image Image Materialized Views[4]
   Materialized Views
Image Image Materialized View
 Comment Materialized View, Drop Materialized View, Grant Privilege, Refresh Materialized View Data, Columns, DDL[4], Grants, Indexes, Info, Row Count, Select SQL
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL with Storage[4], DDL[1], Index
Image Image Column
 Comment Column Column
Image Image Materialized View Logs[4]
   Materialized View Logs
Image Image Materialized View Log
 Drop Materialized View Log Data, DDL[4], Indexes, Info, Row Count
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL with Storage[4], DDL[1], Index
Image Image Column
 Comment Column Column
Image Image Functions
 Create Function Functions
Image Image Function
 Export Function[1], Script: Script Function, Compile Function, Drop Function, Grant Privilege Function Editor[1], Grants
Image Image Procedures
 Create Procedure Procedures
Image Image Procedure
 Export Procedure[1], Script: Script Procedure, Compile Procedure, Drop Procedure, Grant Privilege Procedure Editor[1], Grants
Image Image Packages
 Create Package Packages
Image Image Package
 Export Package[1], Compile Package, Compile Package and Body, Create Package Body, Drop Package and Package Body Package Specification Editor[1], Grants, Info, Procedures & Functions[5]
Image Image Package Body
 Export Package Body[1], Compile Package Body, Drop Package Body Package Body Editor[1], Grants
Image Image Package Bodies
 Create Package Body Package Bodies
Image Image Package Body
 Export Package Body[1], Compile Package Body, Drop Package Body Package Body Editor[1], Grants
Image Image Java Sources[6]
   Java Sources
Image Image Java Source
   Info, Source
Image Image Java Classes[6]
   Java Classes
Image Image Java Class
   Info
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
Image Image Object Types
 Create Object Type Object Types
Image Image Object Type
 Export Object Type[1], Compile Object Type, Compile Object Type and Body, Create Object Type Body, Drop Object Type and Type Body Object Type Editor[1], Attributes, Info, Methods
Image Image Object Type Body
 Export Object Type Body[1], Compile Object Type Body, Drop Object Type Body Object Type Editor[1], Attributes, Info, Methods
Image Image Object Type Bodies
 Create Object Type Body Object Type Bodies
Image Image Object Type Body
 Export Object Type Body[1], Compile Object Type Body, Drop Object Type Body Object Type Editor[1], Attributes, Info, Methods
Image Image Recycle Bin[7]
   Recycle Bin
Image Image Recycle Bin Table
 Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
Image Image Jobs
 Create Job Jobs
Image Image Job
 Disable Job, Enable Job, Remove Job, Run Job Info
Image Image Scheduler[8]
 Disable Scheduler, Enable Scheduler, Set Scheduler Attribute Scheduler Global Attributes, Scheduler Jobs Running
Image Image Chains
 Create Scheduler Chain Scheduler Chain Rules, Scheduler Chain Steps, Scheduler Chains, Scheduler Chains Running
Image Image Scheduler Chain
 Analyze Scheduler Chain, Disable Scheduler Chain, Drop Scheduler Chain, Enable Scheduler Chain, Run Scheduler Chain Scheduler Chain, Scheduler Chain Rules, Scheduler Chain Steps
Image Image Rules
 Define Scheduler Chain Rule Scheduler Chain Rules
Image Image Scheduler Chain Rule
 Drop Scheduler Chain Rule Scheduler Chain Rule
Image Image Steps
 Define Scheduler Chain Step Scheduler Chain Steps
Image Image Scheduler Chain Step
 Alter Scheduler Chain Step, Drop Scheduler Chain Step Scheduler Chain Step
Image Image Jobs
 Create Scheduler Job Scheduler Job Arguments, Scheduler Job Logs, Scheduler Job Run Details, Scheduler Jobs, Scheduler Jobs Running
Image Image Scheduler Job
 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
Image Image Job Arguments
 Add Scheduler Job Argument Scheduler Job Arguments
Image Image Scheduler Job Argument
 Edit Scheduler Job Argument, Remove Scheduler Job Argument Scheduler Job Argument
Image Image Programs
 Create Scheduler Program Scheduler Program Arguments, Scheduler Programs
Image Image Scheduler Program
 Comment Scheduler Program, Disable Scheduler Program, Drop Scheduler Program, Enable Scheduler Program, Modify Scheduler Program Scheduler Program
Image Image Program Arguments
 Add Scheduler Program Argument Scheduler Program Arguments
Image Image Scheduler Program Argument
 Edit Scheduler Program Argument, Remove Scheduler Program Argument Scheduler Program Argument
Image Image Schedules
 Create Scheduler Schedule Scheduler Schedules
Image Image Scheduler Schedule
 Drop Scheduler Schedule, Evaluate Scheduler Schedule Scheduler Schedule
Image Image Credentials[9]
 Create Scheduler Credential Scheduler Credentials
Image Image Scheduler Credential
 Comment Credential, Drop Scheduler Credential, Modify Credential Scheduler Credential
Image Image Database Links
 Create Database Link Database Links
Image Image Database Link
 Drop Database Link, Test Database Link DDL, Info
Image Image Invalid Objects
 Compile All Invalid Objects
Image Image Session Properties
   Database Properties[4], Initialization Parameters[4], Session NLS Parameters[4], Session Privileges, Session Roles
Image Image DBA Views
   DBA
Image Image Users
 Create User Users
Image Image User
 Change Password, Drop User, Expire Password, Grant Resource Group[3], Lock User, Revoke Resource Consumer Group from User[3], Set Default Resource Group for User[3], Unlock User, Script: Clone User DDL[10], Info, Resource Groups[3], Roles, System Privileges, Table Privileges, Tablespace Quota
Image Image Roles
 Create Role Roles
Image Image Role
 Drop Role DDL[4], Info, Roles, System Privileges, Table Privileges, Users
Image Image Sessions[11]
   Active Sessions, Sessions, Traced Sessions[8]
Image Image Session
 Disable Trace[8], Enable Trace[8], Kill Session, Kill Session[12] Active SQL, Plan Data[7], Session, Session Events, Session Wait
Image Image Sessions
   Active Sessions, Sessions, Traced Sessions[8]
Image Image Local Sessions
   Active Sessions, Sessions, Traced Sessions[8]
Image Image Session
 Disable Trace[8], Enable Trace[8], Kill Session, Kill Session[12] Active SQL, Plan Data[7], Session, Session Events, Session Wait
Image Image Remote Sessions
   Active Sessions, Sessions, Traced Sessions[8]
Image Image Session Non Local
 Kill Session[9] Active SQL, Plan Data[7], Session, Session Events, Session Wait
Image Image Replication[4]
    
Image Image DataGuard
   Archive Dest Status, Archive Destinations, Current db, DG Status, DG config[7]
Image Image Logical Standby
   Archive Gap, Logical Standby Events, Unsupported objects
Image Image Physical Standby
   Archive Gap, Managed Standby Procs, Standby Log Files
Image Image Streams
   Archive Dest Status, Archive Destinations, Current db
Image Image Capture
   Capture Parameters, Capture Status, Capture extra Attr[7], Registered Logs
Image Image Apply
   Apply Latency, Apply Parameters, Apply Status, Capture-Apply Latency
Image Image Locks
   Blocking Locks, Locks 1, Locks 2
Image Image Recycle Bin[7]
   Recycle Bin
Image Image All Recycle Bin Table
 Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
Image Image Resource Manager[3]
 Clear Pending Area, Create Pending Area, Generate Monitor SQL, Submit Pending Area, Validate Pending Area Resource Usage
Image Image Resource Consumer Group Mapping
    
Image Image Resource Consumer Mapping
 Add Resource Group Mapping Resource Consumer Group Mapping
Image Image Resource Consumer Mapping Value
 Remove From Resource Group Mapping  
Image Image Resource Consumer Groups
 Create Resource Consumer Group Resource Consumer Groups
Image Image Resource Consumer Group
 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
Image Image Resource Plans
 Create Resource Plan Resource Plans
Image Image Resource Plan
 Activate Resource Plan, Remove Resource Plan Resource Plan, Resource Plan Directives
Image Image Resource Plan Directives
 Add Group to Plan Resource Plan Directives
Image Image Resource Plan Directive
 Modify Resource Directive, Remove Group from Plan Resource Plan Directive
Image Image Storage
   ASM Diskgroups[7], All Redo Log Files, Data Files, Directories, Rollback Segments, Tablespaces, Temp Files
Image Image ASM[7]
   ASM Clients, ASM Diskgroups, Used Client
Image Image ASM Diskgroups
 Add Disk Group Details, Usage
Image Image ASMDisk Group
 Add Disk to Group, Drop Disk Group, Rebalance Disk Group ASM Diskgroup, ASM Operation, Files
Image Image ASMDisk
 Drop Disk ASM Disk
Image Image Available Disks
   ASM Disk
Image Image ASMDisk
 Drop Disk ASM Disk
Image Image Segment Advisor[7]
    
Image Image Tasks
 Create Task Segment Advisor Findings, Segment Advisor Logs, Segment Advisor Recommendations, Segment Advisor Tasks
Image Image Segment Advisor Task
 Cancel Task, Delete Task, Execute Task, Interrupt Task, Reset Task Segment Advisor Findings, Segment Advisor Log, Segment Advisor Recommendations, Segment Advisor Task
Image Image Objects
 Segment, Tablespace Segment Advisor Objects
Image Image Segment Advisor Object
 Update Object Segment Advisor Object
Image Image Parameters
 Set Parameter Segment Advisor Parameters
Image Image Segment Advisor Parameter
   Segment Advisor Parameter
Image Image Tablespaces
   Datafile IO, Objects, Tablespaces, Usage By User
Image Image Permanent
 Create Tablespace Datafile IO, Objects, Tablespaces, Usage By User
Image Image Permanent Tablespace
 Add Datafile, Remove Tablespace, Rename Tablespace[7], Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL[4], Datafile IO, Datafiles, Objects, Tablespace, Usage By User, User Quota
Image Image Permanent Data File
 Remove Datafile[7], Rename Datafile, Resize Datafile Data File, Objects
Image Image Temporary[2]
   Tablespaces
Image Image Temporary Tablespace
 Add Datafile DDL[4], Tablespace, User Quota
Image Image Temporary Temp File
 Remove Tempfile[4], Resize Tempfile, Tempfile Offline[4], Tempfile Online[4] Temp File
Image Image Undo[4]
   Datafile IO, Objects, Tablespaces, Usage By User
Image Image Undo Tablespace
 Add Datafile DDL[4], Datafile IO, Objects, Tablespace, Usage By User
Image Image Undo Data File
 Resize Datafile Data File, Objects
Image Image Tablespace Files
   Data Files, Temp Files
Image Image Permanent Data File
 Remove Datafile[7], Rename Datafile, Resize Datafile Data File, Objects
Image Image Permanent Tablespace
 Add Datafile, Remove Tablespace, Rename Tablespace[7], Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL[4], Datafile IO, Datafiles, Objects, Tablespace, Usage By User, User Quota
Image Image Temporary Temp File[2]
 Remove Tempfile[4], Resize Tempfile, Tempfile Offline[4], Tempfile Online[4] Temp File
Image Image Temporary Tablespace
 Add Datafile DDL[4], Tablespace, User Quota
Image Image Undo Data File[4]
 Resize Datafile Data File, Objects
Image Image Undo Tablespace
 Add Datafile DDL[4], Datafile IO, Objects, Tablespace, Usage By User
Image Image Rollback Segments
 Create Rollback Segment Rollback Segments
Image Image Rollback Segment
   DDL[4], Rollback Segment
Image Image Redo Logs
 Create Redo Log Group, Force Log Switch All Redo Log Files, Redo Log Activity
Image Image Redo Log
 Add Log File Member Redo Log
Image Image Redo Log Member
 Drop Log File Member Redo Log Member
Image Image Directories[4]
 Create Directory Directories
Image Image Directory
 Drop Directory, Grant Privilege Directory, Directory Privileges
Image Image Directory Privilege
 Revoke Privileges  
Image Image dNFS[9]
   Channels, Files, Servers, Stats
Image Image Scheduler[8]
 Disable Scheduler, Enable Scheduler, Set Scheduler Attribute Scheduler Global Attributes, Scheduler Jobs Running
Image Image Job Classes
 Create Scheduler Job Class Scheduler Job Classes
Image Image Scheduler Job Class
 Drop Scheduler Job Class Scheduler Job Class
Image Image Windows
 Create Scheduler Window, Purge Window logs Scheduler Window Details, Scheduler Window Log, Scheduler Windows
Image Image Scheduler Window
 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
Image Image Window Groups
 Create Scheduler Window Group Scheduler Window Groups
Image Image Scheduler Window Group
 Add Window Group Member, Disable Scheduler Window Group, Drop Window Group, Enable Scheduler Window Group Scheduler Window Group
Image Image Window Group Members
   Scheduler Window Group Members
Image Image Scheduler Window Group Member
 Remove Window Group Member Scheduler Window
Image Image Statistics
    
Image Image AWR[7]
 Create Snapshot, Diff Report, Run Report AWR
Image Image Instance Info
   Instance Info
Image Image Instance Summary
   Instance Summary
Image Image Latches
   Latches
Image Image Object Count
   Object Count
Image Image Waits
   Waits
Image Image SGA
 Flush SGA Object Cache, Poorly Performing SQL's, SGA
[1] DbVisualizer Pro
[2] Version 8.1 and later
[3] Version 8 and later
[4] Version 9 and later
[5] Version 11.2 and later
[6] If Java Support is installed in database
[7] Version 10 and later
[8] Version 10.1 and later
[9] Version 11 and later
[10] Version 7 and later
[11] Version 9 and earlier
[12] Version 11 and earlier