Oracle Cloud
The following table shows the database specific support in DbVisualizer for Oracle Cloud organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
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[4] | 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 |
Materialized View Logs[4] | Materialized View Logs | |
Materialized View Log | Drop Materialized View Log | Data, DDL[4], Indexes, Info, Row Count |
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 | ||