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
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
RefConstraints
   Constraints
RefConstraint
   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
IndexPartitions
   Partitions
IndexPartition
   Info, Sub-Partitions
IndexSubPartition
   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
SubPartition
   Info
GlobalTempTables
 Create Table[1], Import Table Data[1] Tables
TempTable
 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
MaterializedViews
   Materialized Views
MaterializedView
 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]
PackageBody
 Export Package Body[1], Compile Package Body, Drop Package Body Package Body Editor[1], Grants
PackageBodies
 Create Package Body Package Bodies
PackageBody
 Export Package Body[1], Compile Package Body, Drop Package Body Package Body Editor[1], Grants
JavaSources[6]
   Java Sources
JavaSource
   Info, Source
JavaClasses[6]
   Java Classes
JavaClass
   Info
Triggers
   Triggers
Trigger
 Export Trigger[1], Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
ObjectTypes
 Create Object Type Object Types
ObjectType
 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
ObjectTypeBody
 Export Object Type Body[1], Compile Object Type Body, Drop Object Type Body Object Type Editor[1], Attributes, Info, Methods
ObjectTypeBodies
 Create Object Type Body Object Type Bodies
ObjectTypeBody
 Export Object Type Body[1], Compile Object Type Body, Drop Object Type Body Object Type Editor[1], Attributes, Info, Methods
RecycleBin[7]
   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
Scheduler[8]
 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
SchedulerCredentials[9]
 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 Properties[4], Initialization Parameters[4], Session NLS Parameters[4], Session Privileges, Session Roles
DBA
   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]
SessionsLocal
   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
SessionsNonLocal
   Active Sessions, Sessions, Traced Sessions[8]
SessionNonLocal
 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]
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 Attr[7], Registered Logs
StreamsApply
   Apply Latency, Apply Parameters, Apply Status, Capture-Apply Latency
Locks
   Blocking Locks, Locks 1, Locks 2
AllRecycleBin[7]
   Recycle Bin
AllRecycleBinTable
 Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
ResourceManager[3]
 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 Diskgroups[7], All Redo Log Files, Data Files, Directories, Rollback Segments, Tablespaces, Temp Files
ASM[7]
   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
SegmentAdvisor[7]
    
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 Tablespace[7], Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL[4], Datafile IO, Datafiles, Objects, Tablespace, Usage By User, User Quota
PermanentDataFile
 Remove Datafile[7], Rename Datafile, Resize Datafile Data File, Objects
TemporaryTablespaces[2]
   Tablespaces
TemporaryTablespace
 Add Datafile DDL[4], Tablespace, User Quota
TemporaryTempFile
 Remove Tempfile[4], Resize Tempfile, Tempfile Offline[4], Tempfile Online[4] Temp File
UndoTablespaces[4]
   Datafile IO, Objects, Tablespaces, Usage By User
UndoTablespace
 Add Datafile DDL[4], Datafile IO, Objects, Tablespace, Usage By User
UndoDataFile
 Resize Datafile Data File, Objects
TablespaceFiles
   Data Files, Temp Files
PermanentDataFile
 Remove Datafile[7], Rename Datafile, Resize Datafile Data File, Objects
PermanentTablespace
 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
TemporaryTempFile[2]
 Remove Tempfile[4], Resize Tempfile, Tempfile Offline[4], Tempfile Online[4] Temp File
TemporaryTablespace
 Add Datafile DDL[4], Tablespace, User Quota
UndoDataFile[4]
 Resize Datafile Data File, Objects
UndoTablespace
 Add Datafile DDL[4], Datafile IO, Objects, Tablespace, Usage By User
RollbackSegments
 Create Rollback Segment Rollback Segments
RollbackSegment
   DDL[4], Rollback Segment
RedoLogs
 Create Redo Log Group, Force Log Switch All Redo Log Files, Redo Log Activity
RedoLog
 Add Log File Member Redo Log
RedoLogMember
 Drop Log File Member Redo Log Member
Directories[4]
 Create Directory Directories
Directory
 Drop Directory, Grant Privilege Directory, Directory Privileges
DirectoryPrivilege
 Revoke Privileges  
dNFS[9]
   Channels, Files, Servers, Stats
Scheduler[8]
 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
    
AWR[7]
 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] 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
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗