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

Oracle Cloud

Oracle Cloud object type support.

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