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 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
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 ↗