Operations on Database Objects

This topic provides an overview of operations performed on data objects.

Oracle® Database Navigator tool allows you to perform various operations on the database objects visible in the DB Browser window. The operations you can perform depends on the type of object. The following table lists the operations you can perform on common DB objects:

Object Type	Operations
Schemas	View list of schemas within the DB connection Reload the DB schema to display updated list of schema and schema content Hide specific schemas from the DB structure View schema users Apply Global filters to view specific schemas or schema objects
Tables	View list of DB tables within each schema Reload the table to get updated table structure and refresh object status within the table Hide specific tables in the DB structure Apply Global filters to view specific tables or table objects Edit table data Extract SQL statements including DDL statements for the table and copy to clipboard View table indices View object dependency tree of a table with the list of incoming and outgoing reference tables Start or Stop Notifications for Data Changes
Nested Tables	View and hide nested tables within DB tables Apply Global filters to view specific nested tables within tables Reload to fetch the updated list of nested tables and their objects in the connected database
Columns	View the columns in each DB table or view Apply Global filters to view specific columns or filter data in the columns Hide any column including pseudo columns and columns marked for audit from DB views Extract the SQL statements for the columns and copy to clipboard
Users	View list of users accessing the connected DB View the database schemas accessible to different DB users View current status of users Apply Global filters to view specific users in the DB structure View user' roles and granted privileges
Roles	View list of user roles created in the connected DB View the users granted a particular role (user grantee) View the privileges and specific permissions granted to the role Refresh list of roles in the DB structure or reload individual role to fetch updated role info
System Privileges	Apply Global filters to view specific privileges in the DB structure View the DB users that are assigned a specific privilege View the user roles that are assigned a specific privilege Reload the list of privileges and their user and role grantees within the DB structure
Charsets	Apply Global filters to view specific character sets within a DB structure Reload to fetch the updated list of charsets or individual charset definition in the connected DB
Views	Edit the View data in the editor Data tab Edit the SQL query for the View in the editor Code tab Delete the DB View View the object dependency tree for the View with the list of incoming and outgoing reference tables Extract SQL statements from the View query
Constraints	View the table level, view level and column level constraints within the DB structure Apply Global filters to view specific constraints in the table or column Reload the constraints to fetch updated list of constraints or constraint definition
Functions	Create and apply Global filters to view selected DB functions Reload to fetch the updated list of DB functions Hide the functions from object view
Triggers	Apply Global filters to view specific triggers within the database table Hide the triggers from the DB structure Reload to fetch the updated list of triggers within the database table
Indexes	View the columns and datasets of an index Drop the index from the connected database Extract SQL and DDL statements and copy to clipboard Reload to fetch the updated list of indices in the connected database Refresh the object status of the index
Packages	Edit the package code in DB editor Compile the package in regular or debug mode. You can also compile the invalid objects of the package Run and debug the package. You will be prompted to select the method to execute and debug the package View the dependency tree with list of incoming and outgoing references Extract SQL statements including DDL statement and copy to clipboard Reload packages to fetch the list of packages in the DB connection Refresh the status (Valid/Invalid) of package objects
Procedures	Create and apply Global filters to view specific DB procedures Reload to fetch the updated list of DB procedures Hide the procedures from object view
Types	Open the data types in editor to make changes to the code Compile the data type in regular or debug mode. You can also compile the invalid objects in the data type Run and debug the data type. You will be prompted to select the method to execute and debug the data type View the object dependency tree with list of incoming and outgoing references Extract SQL statements including DDL statement and copy to clipboard Reload the data types to fetch the list of updated types in the DB connection Refresh the status of the data types
Arguments	Reload arguments to fetch the updated list of arguments within DB objects Apply Global filters to view specific arguments Hide arguments within the DB structure
Java Classes	Open the source code in editor and make changes to the Java class file or Java source file Run, compile (including invalid objects) and debug the Java program Create and load new Java classes in the schema Create custom execution wrapper for executing Java programs View the object dependency tree with the list of incoming and outgoing references Download Java classes to the DB schema of your project Upload Java classes (or Java source files) in database schemas Drop Java class files (and Java methods) or Java source files from the schema
Java Resources	View and hide Java resources Edit Java resource source code in Java editor Drop Java resource files Download the Java resource from Java class or JAR files to your project Upload Java resources in database schema Apply Global filters to view specific Java resources Reload to fetch the updated resources in the class
Dimensions	View and hide dimension tables Apply Global filters to view specific dimension tables within the DB schema
Clusters	View or hide database clusters within the connected database Reload to fetch the updated list of database clusters Apply Global filters to view specific clusters within the connected database
Credentials	View or hide credentials (digital key) within each database schema Reload to fetch the updated list of DB credentials Apply Global filters to view specific credentials within the connected DB schema