Table of Contents

• List of Figures
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
    • Antlr 3.1.3
    • ANTLR4 Java Runtime 4.11.1
    • Apache Commons Codec 1.15
    • Apache Commons Logging 1.2
    • Apache httpmime 4.5.12
    • Apache Mina SSHD 2.9.2
    • Apache POI 5.2.3
    • Google Guava 31.1
    • HttpComponents Http Client 5.1.3
    • HttpCore 5.1.4
    • jackson-annotations 2.13.4
    • jackson-core 2.13.4
    • jackson-jr-objects 2.13.4
    • jGraphx 4.2.0
    • Launch4j 3.14
    • Log4j 2.19.0
    • StringTemplate 3.1-1, 4.3.1, 4.3.3
• 1 Changes in Release 23.1 for Oracle SQL Developer User's Guide
• 2 SQL Developer Concepts and Usage
  • 2.1 About SQL Developer
  • 2.2 Installing and Getting Started with SQL Developer
  • 2.3 SQL Developer User Interface
    • 2.3.1 Menus for SQL Developer
    • 2.3.2 Restoring the Original "Look and Feel"
  • 2.4 Database Objects
    • 2.4.1 Applications (Application Express 3.0.1 and Later)
    • 2.4.2 Cache Groups (Oracle TimesTen In-Memory Database)
    • 2.4.3 Chains
    • 2.4.4 Credentials
    • 2.4.5 Database Destinations
    • 2.4.6 Database Links (Public and Private)
    • 2.4.7 Destination Groups
    • 2.4.8 Directories
    • 2.4.9 Editions
    • 2.4.10 File Watchers
    • 2.4.11 Functions
    • 2.4.12 Indexes
    • 2.4.13 Java Sources
    • 2.4.14 Jobs
    • 2.4.15 Job Classes
    • 2.4.16 Operators
    • 2.4.17 Materialized Views
    • 2.4.18 Materialized View Logs
    • 2.4.19 Multitenant Container Database (CDB)
    • 2.4.20 Packages
    • 2.4.21 Procedures
    • 2.4.22 Programs
    • 2.4.23 Queues
    • 2.4.24 Queue Tables
    • 2.4.25 Recycle Bin
    • 2.4.26 Replication Schemes (Oracle TimesTen In-Memory Database)
    • 2.4.27 Schedules
    • 2.4.28 Sequences
    • 2.4.29 Synonyms (Public and Private)
    • 2.4.30 Tables
      • 2.4.30.1 Flashback Table Support
    • 2.4.31 Triggers
    • 2.4.32 Types
    • 2.4.33 Users (Other Users)
    • 2.4.34 Views
    • 2.4.35 Window Groups
    • 2.4.36 Windows
    • 2.4.37 XML DB Repository
    • 2.4.38 XML Schemas
    • 2.4.39 Captured and Converted Database Objects (for Migration)
  • 2.5 Database Connections
    • 2.5.1 Using Folders to Group Connections
    • 2.5.2 Sharing of Connections
    • 2.5.3 Advanced Security for JDBC Connection to the Database
    • 2.5.4 Connections with Operating System (OS) Authentication
    • 2.5.5 Connections with Proxy Authentication
    • 2.5.6 Connections with SSH Authentication
  • 2.6 Entering and Modifying Data
  • 2.7 Running and Debugging Functions and Procedures
    • 2.7.1 Using Bookmarks When Editing Functions and Procedures
    • 2.7.2 Remote Debugging
    • 2.7.3 Displaying SQL Trace (.trc) Files
    • 2.7.4 Using the PL/SQL Hierarchical Profiler
    • 2.7.5 Setting Expression Watches
    • 2.7.6 Semantic Analysis
      • 2.7.6.1 SQL Injection Detection
  • 2.8 Using the SQL Worksheet
    • 2.8.1 SQL*Plus and SQLcl Commands Supported in SQL Worksheet
    • 2.8.2 Script Runner
    • 2.8.3 Execution Plan
    • 2.8.4 Autotrace Pane
    • 2.8.5 DBMS Output Pane
    • 2.8.6 OWA Output Pane
    • 2.8.7 SQL History
    • 2.8.8 Query Builder
    • 2.8.9 Command-Line Interface for SQL Formatting
    • 2.8.10 SQL Worksheet "Hints" for Formatting Output
    • 2.8.11 Gauges: In the SQL Worksheet and User-Defined Reports
    • 2.8.12 Entering OLAP DML Statements in the SQL Worksheet
  • 2.9 Using Snippets to Insert Code Fragments
    • 2.9.1 User-Defined Snippets
  • 2.10 Finding Database Objects
  • 2.11 Using Recent Objects
  • 2.12 Using Versioning
    • 2.12.1 About Subversion and SQL Developer
    • 2.12.2 Pending Changes
  • 2.13 Using DBA Features in SQL Developer
    • 2.13.1 Container Database (CDB)
    • 2.13.2 Database Configuration
      • 2.13.2.1 Initialization Parameters
      • 2.13.2.2 Automatic Undo Management
      • 2.13.2.3 Current Database Properties
      • 2.13.2.4 Restore Points
      • 2.13.2.5 View Database Feature Usage
    • 2.13.3 Database Status
      • 2.13.3.1 Status
      • 2.13.3.2 DB Instance
      • 2.13.3.3 Instance Viewer
    • 2.13.4 Data Guard
    • 2.13.5 Data Pump
      • 2.13.5.1 Export Jobs
      • 2.13.5.2 Import Jobs
    • 2.13.6 Oracle Sharding
    • 2.13.7 Performance
      • 2.13.7.1 Snapshots
      • 2.13.7.2 Baselines
      • 2.13.7.3 Baseline Templates
      • 2.13.7.4 Automatic Database Diagnostic Monitor (ADDM)
      • 2.13.7.5 ASH (Active Session History) Report Viewer
      • 2.13.7.6 AWR (Automatic Workload Repository)
    • 2.13.8 RMAN Backup/Recovery
      • 2.13.8.1 Backup Jobs
      • 2.13.8.2 Backup Sets
      • 2.13.8.3 Image Copies
      • 2.13.8.4 RMAN Settings
      • 2.13.8.5 Scheduled RMAN Actions
      • 2.13.8.6 Using Action Jobs
    • 2.13.9 Resource Manager
      • 2.13.9.1 Consumer Group Mappings
      • 2.13.9.2 Consumer Groups
      • 2.13.9.3 Plans
      • 2.13.9.4 Settings
      • 2.13.9.5 Statistics
    • 2.13.10 SQL Translator FrameWork
      • 2.13.10.1 SQL Translator Profiles
      • 2.13.10.2 SQL Translators
    • 2.13.11 Scheduler
      • 2.13.11.1 Global Attributes
      • 2.13.11.2 Job Classes
      • 2.13.11.3 External Destinations
    • 2.13.12 Security
      • 2.13.12.1 Audit Settings
      • 2.13.12.2 Profiles
      • 2.13.12.3 Roles
      • 2.13.12.4 Users
    • 2.13.13 Storage
      • 2.13.13.1 Archive Logs
      • 2.13.13.2 Control Files
      • 2.13.13.3 Datafiles
      • 2.13.13.4 Redo Log Groups
      • 2.13.13.5 Rollback Segments
      • 2.13.13.6 Tablespaces
      • 2.13.13.7 Temporary Tablespace Groups
    • 2.13.14 Tuning
      • 2.13.14.1 Real Time SQL Monitor
  • 2.14 Scheduling Jobs Using SQL Developer
    • 2.14.1 Scheduler Design Editor
  • 2.15 Using the Cart
    • 2.15.1 Adding Data Files to the Cart
    • 2.15.2 Cart Versus Database Export Wizard
  • 2.16 Spatial Support in SQL Developer
    • 2.16.1 Context Menu Operations on Spatial Data and Metadata
    • 2.16.2 Map Visualization of Spatial Data
      • 2.16.2.1 Visualizing Geometries by Creating and Executing a Query
      • 2.16.2.2 Visualizing Geometries from the Table Data Grid
  • 2.17 Change Manager Support in SQL Developer
    • 2.17.1 Change Plan Administrators and Developers
    • 2.17.2 Developing Change Plans with SQL Developer
      • 2.17.2.1 Creating a Repository Connection
      • 2.17.2.2 Creating and Deleting Change Plans
      • 2.17.2.3 Adding and Updating Change Items
      • 2.17.2.4 Using Change Plans to Capture Change in SQL Developer
    • 2.17.3 Change Manager Actions to Perform with Enterprise Manager
      • 2.17.3.1 Creating Change Plans from Change Manager Schema Comparisons
      • 2.17.3.2 Deploying Change Plans
  • 2.18 Support for Oracle SQL Access to Kafka
    • 2.18.1 Overview
    • 2.18.2 Prerequisites
    • 2.18.3 Installation and Configuration
    • 2.18.4 Get Started
      • 2.18.4.1 Register a Kafka Cluster
      • 2.18.4.2 Supported Kafka Record Types
      • 2.18.4.3 Create Views to Access CSV Data in a Kafka Topic
      • 2.18.4.4 Create Views to Access JSON Data in a Kafka Topic
      • 2.18.4.5 Query Kafka Data as Continuous Streams
      • 2.18.4.6 Explore Kafka Data from a Specific Offset
      • 2.18.4.7 Explore Kafka Data from a Specific Timestamp
      • 2.18.4.8 Customize Oracle SQL Access to Kafka Views
      • 2.18.4.9 Reconfigure Existing Kafka Views When New Partitions are Added to an Existing Topic
      • 2.18.4.10 Load Kafka Data into Tables Stored in Oracle Database
      • 2.18.4.11 Load Kafka Data into Temporary Tables
    • 2.18.5 Reference Information
  • 2.19 SQL Developer Reports
    • 2.19.1 Bind Variables for Reports
    • 2.19.2 About Your Database reports
    • 2.19.3 All Objects reports
    • 2.19.4 Application Express reports
    • 2.19.5 ASH and AWR reports
    • 2.19.6 Charts reports
    • 2.19.7 Database Administration reports
    • 2.19.8 Data Dictionary reports
    • 2.19.9 Scheduler reports
    • 2.19.10 PL/SQL reports
    • 2.19.11 Security reports
    • 2.19.12 Streams reports
    • 2.19.13 Table reports
      • 2.19.13.1 Quality Assurance reports
    • 2.19.14 XML reports
    • 2.19.15 Data Modeler reports
    • 2.19.16 User Defined reports
      • 2.19.16.1 User-Defined Report Example: Chart
      • 2.19.16.2 User-Defined Report Example: Dynamic HTML
  • 2.20 SQL Developer Preferences
    • 2.20.1 Environment
    • 2.20.2 Change Management Parameters
    • 2.20.3 Code Editor
    • 2.20.4 Compare and Merge
    • 2.20.5 Database
    • 2.20.6 Debugger
    • 2.20.7 External Editor
    • 2.20.8 File Types
    • 2.20.9 Migration
    • 2.20.10 Mouse Actions
    • 2.20.11 Oracle Swift Object Storage
    • 2.20.12 Shortcut Keys (Accelerator Keys)
    • 2.20.13 SSH (Secure Shell)
    • 2.20.14 Usage Reporting
    • 2.20.15 Versioning
      • 2.20.15.1 Versioning: Git
      • 2.20.15.2 Versioning: Subversion
      • 2.20.15.3 Versioning: CVS
      • 2.20.15.4 Versioning: Perforce
    • 2.20.16 Web Browser and Proxy
    • 2.20.17 XML Schemas
  • 2.21 Location of User-Related Information
  • 2.22 Java Development Kit (JDK) Location
  • 2.23 Command-Line Interface for SQL Developer
  • 2.24 Data Modeler in SQL Developer
  • 2.25 Oracle TimesTen In-Memory Database Support
  • 2.26 SQL Developer Support for RDF Data
  • 2.27 Support for Property Graph
  • 2.28 Using the Help
  • 2.29 SQL Developer Usage Suggestions
    • 2.29.1 SQL History Shortcuts
    • 2.29.2 Unshared Worksheets
    • 2.29.3 SQL Worksheet Bookmarks
    • 2.29.4 Oracle Data Miner
    • 2.29.5 Formatted Display of SQL Trace (.trc) Files
    • 2.29.6 Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
    • 2.29.7 Folders for Organizing Connections
    • 2.29.8 Third-Party Databases and SQL Developer
    • 2.29.9 Debugger Ports and Firewalls
    • 2.29.10 Viewing Multiple Tables
    • 2.29.11 Customizing SQL Developer Appearance
    • 2.29.12 Maximizing Tab Panes
    • 2.29.13 Default Path for Running Scripts
    • 2.29.14 Shutting Down and Restarting the Database
    • 2.29.15 Feature Requests
    • 2.29.16 Discussion Forums
    • 2.29.17 Help Text Font Size
    • 2.29.18 Procedure and Function Signatures
    • 2.29.19 Type-Ahead in Navigators
    • 2.29.20 Extended Paste
    • 2.29.21 Closing Tabbed Windows Using the Mouse Wheel
    • 2.29.22 Go to Last Edit Location
    • 2.29.23 Closing Tabbed Windows Using the Context Menu
    • 2.29.24 List of All Open Windows
    • 2.29.25 Go to Subprogram Implementation from Package Window
    • 2.29.26 Select Multiple Table or Column Names in Completion Insight
    • 2.29.27 Startup Time and Automatic Check for Updates
  • 2.30 For More Information About SQL Developer
• 3 SQL Developer: Migrating Third-Party Databases
  • 3.1 Migration: Basic Options and Steps
    • 3.1.1 Migrating Using the Migration Wizard
      • 3.1.1.1 Repository
      • 3.1.1.2 Project
      • 3.1.1.3 Source Database
      • 3.1.1.4 Capture
      • 3.1.1.5 Convert
      • 3.1.1.6 Translate
      • 3.1.1.7 Target Database
      • 3.1.1.8 Move Data
      • 3.1.1.9 Summary
    • 3.1.2 Copying Selected Tables to Oracle
  • 3.2 Migration: Background Information and Guidelines
    • 3.2.1 Overview of Migration
      • 3.2.1.1 Migration Implemented as SQL Developer Extensions
    • 3.2.2 Preparing a Migration Plan
      • 3.2.2.1 Task 1: Determining the Requirements of the Migration Project
      • 3.2.2.2 Task 2: Estimating Workload
      • 3.2.2.3 Task 3: Analyzing Operational Requirements
      • 3.2.2.4 Task 4: Analyzing the Application
      • 3.2.2.5 Task 5: Planning the Migration Project
    • 3.2.3 Before You Start Migrating: General Information
      • 3.2.3.1 Creating a Database User for the Migration Repository
      • 3.2.3.2 Requirements for Creating the Destination Oracle Objects
    • 3.2.4 Before You Start Migrating: Source-Specific Information
      • 3.2.4.1 Before Migrating From IBM DB2
      • 3.2.4.2 Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
      • 3.2.4.3 Before Migrating From MySQL
      • 3.2.4.4 Before Migrating From Teradata
    • 3.2.5 Capturing the Source Database
      • 3.2.5.1 Offline Capture
        • 3.2.5.1.1 IBM DB2 Offline Capture Notes
    • 3.2.6 Creating and Customizing the Converted Model
      • 3.2.6.1 Correcting Errors in the Converted Model
    • 3.2.7 Generating the DDL for the Oracle Schema Objects
    • 3.2.8 Migrating the Data
      • 3.2.8.1 Transferring the Data Offline
        • 3.2.8.1.1 Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
        • 3.2.8.1.2 Creating Data Files From MySQL
        • 3.2.8.1.3 Populating the Destination Database Using the Data Files
    • 3.2.9 Making Queries Case Insensitive
    • 3.2.10 Testing the Oracle Database
      • 3.2.10.1 Testing Methodology
      • 3.2.10.2 Testing the Oracle Database
        • 3.2.10.2.1 Guidelines for Creating Tests
        • 3.2.10.2.2 Example of a Unit Test Case
    • 3.2.11 Deploying the Oracle Database
      • 3.2.11.1 Choosing a Rollout Strategy
        • 3.2.11.1.1 Phased Approach
        • 3.2.11.1.2 Big Bang Approach
        • 3.2.11.1.3 Parallel Approach
      • 3.2.11.2 Deploying the Destination Database
  • 3.3 SQL Developer User Interface for Migration
    • 3.3.1 Migration Submenu
    • 3.3.2 Other Menus: Migration Items
    • 3.3.3 Migration Preferences
    • 3.3.4 Migration Log Panes
    • 3.3.5 Using the Translation Scratch Editor
  • 3.4 Command-Line Interface for Migration
• 4 SQL Developer: Oracle REST Data Services Support
  • 4.1 Installing Oracle REST Data Services
  • 4.2 Automatically Enabling REST Access to a Schema, Table, or View (AutoREST)
  • 4.3 REST Development
    • 4.3.1 About RESTful Web Services
    • 4.3.2 RESTful Services Terminology
    • 4.3.3 RESTful Services Requirements and Setup
    • 4.3.4 REST Data Services in the Connections Navigator
    • 4.3.5 REST Development Pane
• 5 SQL Developer Tutorial: Creating Objects for a Small Database
  • 5.1 Create a Table (BOOKS)
  • 5.2 Create a Table (PATRONS)
  • 5.3 Create a Table (TRANSACTIONS)
  • 5.4 Create a Sequence
  • 5.5 Insert Data into the Tables
  • 5.6 Create a View
  • 5.7 Create a PL/SQL Procedure
  • 5.8 Debug a PL/SQL Procedure
  • 5.9 Use the SQL Worksheet for Queries
  • 5.10 Script for Creating and Using the Library Tutorial Objects
• 6 SQL Developer Dialog Boxes and Wizards
  • 6.1 Add Extension
  • 6.2 Add Schema Error
  • 6.3 Application Migration
  • 6.4 Associate Repository
  • 6.5 Cart Error (Objects Not Available)
  • 6.6 Change Type
  • 6.7 Check for Updates
  • 6.8 Choose Configuration File Option
  • 6.9 Choose Directory
  • 6.10 Clone PDB to Oracle Cloud
  • 6.11 Clone Pluggable Database
  • 6.12 Cloud Migrations Wizard
    • 6.12.1 AWS Redshift Database
    • 6.12.2 Autonomous Data Warehouse Cloud
    • 6.12.3 Summary
  • 6.13 Color Palette and Custom Colors
  • 6.14 Configure Extension
  • 6.15 Configure File Type Associations
  • 6.16 Configure OSS for Oracle Call Infrastructure Classic
  • 6.17 Copy Columns
  • 6.18 Copy Objects
  • 6.19 Copy to Oracle
  • 6.20 Component Palette
  • 6.21 Component Palette: Configure Component Palette
  • 6.22 Component Palette: Create Palette Page
  • 6.23 Component Palette: New/Edit Code Snippet
  • 6.24 Component Palette: New Section/Rename Section
  • 6.25 Confirm Drop Application
  • 6.26 Confirm Running SQL
  • 6.27 Connection Has Uncommitted Changes
  • 6.28 Create New Object
  • 6.29 Create/Edit Chain
  • 6.30 Create/Edit Credential
  • 6.31 Create/Edit/Select Database Connection
    • 6.31.1 Oracle
    • 6.31.2 TimesTen
    • 6.31.3 Amazon Redshift
    • 6.31.4 DB2
    • 6.31.5 Hive
    • 6.31.6 JDBC
    • 6.31.7 MySQL
    • 6.31.8 PostgreSQL
    • 6.31.9 SQL Server and Sybase
    • 6.31.10 Teradata
    • 6.31.11 Creating and Editing Connections
  • 6.32 New/Edit Cloud Connection
    • 6.32.1 Advanced Connection Information
  • 6.33 New/Edit NoSQL Connection
  • 6.34 Rename Model (Migration)
  • 6.35 Delete Confirmation
  • 6.36 Delete Confirmation (Migration)
  • 6.37 Rename Database Item (Migration)
  • 6.38 Select Connection
  • 6.39 Connection Information
  • 6.40 No Connection Found
  • 6.41 Connection Rename Error
  • 6.42 New Folder (Connections)
  • 6.43 Continue After Pause
  • 6.44 Select Library
  • 6.45 Create Library
  • 6.46 CVS: Check Out from CVS
  • 6.47 CVS: Create/Edit CVS Connection
  • 6.48 CVS: Import to CVS
  • 6.49 CVS: Log In to CVS
  • 6.50 Data Import Wizard
    • 6.50.1 Data Preview
    • 6.50.2 Import Method
    • 6.50.3 Import Metadata Source
    • 6.50.4 Choose Columns
    • 6.50.5 Column Definition
    • 6.50.6 Options
    • 6.50.7 Test
    • 6.50.8 Finish
  • 6.51 Export/Import Connections
    • 6.51.1 Export Connections
    • 6.51.2 Import Connections
  • 6.52 Create/Edit Database Destination
  • 6.53 Create/Edit Destination Group (Database or External)
  • 6.54 Create/Edit Database Link
  • 6.55 Create/Edit Index
    • 6.55.1 Definition
    • 6.55.2 Properties
    • 6.55.3 Storage
    • 6.55.4 Partitions
    • 6.55.5 DDL
  • 6.56 Create File Watcher
  • 6.57 Create Filter
  • 6.58 Create Function or Procedure
  • 6.59 Create/Edit Job
    • 6.59.1 Job Details
    • 6.59.2 Destination
    • 6.59.3 Job Arguments
    • 6.59.4 Notification
    • 6.59.5 Properties
    • 6.59.6 Summary/SQL
  • 6.60 Create/Edit Job Class
  • 6.61 Create/Edit Materialized View Log
  • 6.62 Create PL/SQL Package
  • 6.63 Create Pluggable Database
  • 6.64 Create/Edit Program
  • 6.65 Create/Edit Role
  • 6.66 Create/Edit Schedule
  • 6.67 Create/Edit Sequence
  • 6.68 Create SQL File
  • 6.69 Create/Edit Synonym
  • 6.70 Create Table (quick creation)
  • 6.71 Create/Edit Table (with advanced options)
    • 6.71.1 Columns pane
    • 6.71.2 Constraints
    • 6.71.3 Primary Key Constraint
    • 6.71.4 Unique Constraints
    • 6.71.5 Foreign Keys Constraints
    • 6.71.6 Check Constraints
    • 6.71.7 Indexes pane
    • 6.71.8 In-Memory pane
    • 6.71.9 Storage pane
    • 6.71.10 Column Sequences pane
    • 6.71.11 Table Properties pane
    • 6.71.12 LOB Parameters pane
    • 6.71.13 Partitioning pane
    • 6.71.14 Subpartition Templates pane
    • 6.71.15 Partition Definitions pane
    • 6.71.16 Partition Sets pane
    • 6.71.17 Index Organized Properties pane
    • 6.71.18 External Table Properties pane
    • 6.71.19 Comment pane
    • 6.71.20 DDL pane
    • 6.71.21 Hive Tables
      • 6.71.21.1 Hive Tables: Partitions
      • 6.71.21.2 Hive Tables: Buckets
      • 6.71.21.3 Hive Tables: Skew
      • 6.71.21.4 Hive Tables: Storage
      • 6.71.21.5 Hive Tables: Table Properties
  • 6.72 Storage Options
  • 6.73 Create/Edit Tablespace
    • 6.73.1 File Specifications tab
    • 6.73.2 Properties tab
    • 6.73.3 Default Parameters tab
    • 6.73.4 DDL tab
  • 6.74 Create Trigger
  • 6.75 Create Type (User-Defined)
  • 6.76 Create/Edit User
    • 6.76.1 User tab
    • 6.76.2 Granted Roles tab
    • 6.76.3 System Privileges tab
    • 6.76.4 Quotas tab
    • 6.76.5 SQL tab
  • 6.77 Create/Edit User Defined Report
  • 6.78 Create/Edit User Defined Report Folder
  • 6.79 Create/Edit View
    • 6.79.1 SQL Query tab or pane
    • 6.79.2 View Properties or Materialized View Properties pane
    • 6.79.3 DDL tab or pane
    • 6.79.4 Quick-Pick Objects pane
    • 6.79.5 FROM Clause pane
    • 6.79.6 SELECT Clause pane
    • 6.79.7 WHERE Clause pane
    • 6.79.8 GROUP BY Clause pane
    • 6.79.9 HAVING Clause pane
    • 6.79.10 ORDER BY Clause pane
  • 6.80 Create Window
  • 6.81 Create Window Group
  • 6.82 Create XML Document from XML Schema
  • 6.83 Create XML Schema
  • 6.84 Custom Filters
  • 6.85 Customize Toolbars
  • 6.86 Data Pump Export
    • 6.86.1 Source page
    • 6.86.2 Tablespaces page
    • 6.86.3 Schemas page
    • 6.86.4 Tables page
    • 6.86.5 Filter page
    • 6.86.6 Table Data page
    • 6.86.7 Options page
    • 6.86.8 Output Files page
    • 6.86.9 OSS Transfer page
    • 6.86.10 Job Schedule page
    • 6.86.11 Summary page
  • 6.87 Data Pump Import
    • 6.87.1 Type page
    • 6.87.2 Tablespaces page
    • 6.87.3 Schemas page
    • 6.87.4 Tables page
    • 6.87.5 Filter page
    • 6.87.6 Table Data page
    • 6.87.7 Remapping page
    • 6.87.8 Options page
    • 6.87.9 Job Schedule page
    • 6.87.10 Summary page
  • 6.88 Database Copy
    • 6.88.1 Source/Destination page
    • 6.88.2 Object Types page
    • 6.88.3 Select Schemas page
    • 6.88.4 Select Tablespace page
    • 6.88.5 Specify Objects page
    • 6.88.6 Specify Data page
    • 6.88.7 Summary page
  • 6.89 Database Differences
    • 6.89.1 Source/Destination page
    • 6.89.2 Types to Diff page
    • 6.89.3 Specify Objects page
    • 6.89.4 Summary page
  • 6.90 Database Export (Unload Database Objects and Data)
    • 6.90.1 Source/Destination page
    • 6.90.2 Types to Export page
    • 6.90.3 Specify Objects page
    • 6.90.4 Specify Data page
    • 6.90.5 Export Summary page
  • 6.91 DDL Panel for Creating or Editing an Object
  • 6.92 Debugger - Attach to JPDA
  • 6.93 Deploy or Import Application
  • 6.94 Deploy Objects to Cloud
    • 6.94.1 Deploy Objects to Cloud using Oracle Swift Object Storage
    • 6.94.2 Cloud
    • 6.94.3 Authorization
    • 6.94.4 Deploy File
    • 6.94.5 Deploy DDL
    • 6.94.6 Deploy Data
    • 6.94.7 Deployment Console
    • 6.94.8 Unsupported Cart Object for Cloud Deployment
    • 6.94.9 Other Errors (Invalid or Missing Entries)
  • 6.95 Describe Object Window
  • 6.96 Diff Objects
  • 6.97 Drop Pluggable Database
  • 6.98 Drop REST Services for Schema
  • 6.99 Edit/View Value (Data or Table Column)
  • 6.100 Enter Bind Values
  • 6.101 Erase from Disk
  • 6.102 Error Writing to Export File
  • 6.103 Export Error
  • 6.104 Export Data
  • 6.105 Export Objects
  • 6.106 Export Resource Module, Privilege, and Role
  • 6.107 Export: Unique Names Warning
  • 6.108 External Locator Configuration
  • 6.109 External Tools
  • 6.110 Create/Edit External Tool
    • 6.110.1 Program Options
    • 6.110.2 Display
    • 6.110.3 Integration
    • 6.110.4 Availability
  • 6.111 Choose Offline Options
  • 6.112 Edit Font Location
  • 6.113 Edit Header or Footer (PDF Formatting)
  • 6.114 Edit Join
  • 6.115 Extract Variable/Function/CTE for Refactoring
  • 6.116 Feature Missing
  • 6.117 Feature Required
  • 6.118 File Processing
  • 6.119 Filter
  • 6.120 Filter Object Types
  • 6.121 Filter Schemas
  • 6.122 Filter Error
  • 6.123 Find/Highlight
  • 6.124 Git: Add
  • 6.125 Git: Add All
  • 6.126 Git: Add to .gitignore File
  • 6.127 Git: Checkout Revision
  • 6.128 Git: Clone from Git
  • 6.129 Git: Commit
  • 6.130 Git: Commit All
  • 6.131 Git: Create Branch
  • 6.132 Git: Create Tag
  • 6.133 Git: Export Committed Changes
  • 6.134 Git: Export Uncommitted Changes
  • 6.135 Git: Fetch from Git
  • 6.136 Git: Initialize Repository
  • 6.137 Git: Merge
  • 6.138 Git: Pull from Git
  • 6.139 Git: Push to Git
  • 6.140 Git: Revert
  • 6.141 Insert Macro
  • 6.142 Externally Modified Files
  • 6.143 Find/Replace Text
  • 6.144 Find Result
  • 6.145 Format Properties (Advanced Formatting)
  • 6.146 Generate Patch
  • 6.147 Go to Bookmark
  • 6.148 Go to Line Number
  • 6.149 Go to Line Number: Error
  • 6.150 History
  • 6.151 Install/Run Oracle REST Data Services
    • 6.151.1 ORDS File Locations
    • 6.151.2 Database Connection
      • 6.151.2.1 Verify Oracle REST Data Services
    • 6.151.3 Database Options
    • 6.151.4 Select Tablespace
    • 6.151.5 PL/SQL Gateway
    • 6.151.6 Features
    • 6.151.7 APEX RESTful Services
    • 6.151.8 Run Standalone Mode
    • 6.151.9 ORDS Users
    • 6.151.10 Summary
  • 6.152 Install SQL Translator
    • 6.152.1 Installing a Translator and Creating a Profile: Usage Notes
  • 6.153 Invalid Database Version
  • 6.154 Load Extension
  • 6.155 Load Keyboard Scheme
  • 6.156 LOB Descriptors
  • 6.157 Maintain Spatial Metadata
  • 6.158 Manage Columns
  • 6.159 Manage Connections (REST)
  • 6.160 Manage Features and Updates
  • 6.161 Map Connection
  • 6.162 Merge Migration Projects
  • 6.163 Modify Pluggable State
  • 6.164 Modify Value
  • 6.165 Data Move Details
  • 6.166 New/Edit Change Set
  • 6.167 New Procedure (Refactoring)
  • 6.168 New/Edit Local or Remote Port Forward
  • 6.169 Edit SSH Connection
  • 6.170 No Lock
  • 6.171 No Object Found
  • 6.172 No Object Selected
  • 6.173 Object Preferences
  • 6.174 Offline Generation Error - Destination Directory
  • 6.175 Open File
  • 6.176 Oracle-Only Report
  • 6.177 Paste
  • 6.178 Perforce: Add Files to Perforce
  • 6.179 Perforce: Connection
  • 6.180 Perforce: Create Changelist
  • 6.181 Perforce: Delete Files
  • 6.182 Perforce: Login
  • 6.183 Perforce: Open Files for Edit
  • 6.184 Perforce: Revert Files
  • 6.185 Perforce: Sync Files
  • 6.186 Perforce: Submit Changelist
  • 6.187 Plug In Pluggable Database
  • 6.188 Print Preview
  • 6.189 Privilege Warning for Migration
  • 6.190 Publish to REST
  • 6.191 Recent Files
  • 6.192 Delete or Truncate Repository
    • 6.192.1 Error Truncating Repository
  • 6.193 Rename Local Variable
  • 6.194 Rename Tab
  • 6.195 Rename Procedure
  • 6.196 Repair (Validate) Oracle REST Data Services
  • 6.197 RESTful Services Wizard (Auto-Enable REST Access)
    • 6.197.1 Specify Details
    • 6.197.2 RESTful Summary
  • 6.198 RESTful Services Wizard and Object Dialog Boxes
    • 6.198.1 Resource Module
    • 6.198.2 Resource Template
    • 6.198.3 Resource Handler
      • 6.198.3.1 Resource Handler Editing Pane
    • 6.198.4 RESTful Summary
  • 6.199 RESTful Services Connection
  • 6.200 RESTful Services Privilege
  • 6.201 RESTful Services Roles
  • 6.202 Select Current Repository
  • 6.203 Cannot Capture Table
  • 6.204 Report Panel
  • 6.205 Reset Expired Password (Enter New Password)
  • 6.206 Revision Lister
  • 6.207 Run/Debug/Profile PL/SQL
  • 6.208 Create/Edit Breakpoint
    • 6.208.1 Definition tab
    • 6.208.2 Conditions tab
    • 6.208.3 Actions tab
  • 6.209 Save/Save As, or Select File
  • 6.210 Save or Open Cart Tool Configuration
  • 6.211 Save Files
  • 6.212 Unable to Save Files
  • 6.213 Save Style Settings
  • 6.214 Schema Differences Source or Destination Error
  • 6.215 Script Execution Failed
  • 6.216 Script Generation Complete
  • 6.217 Set Data Mapping
  • 6.218 Add/Edit Rule
  • 6.219 Set Encoding
  • 6.220 Set Pause Continue
  • 6.221 Shared Wizard Pages
    • 6.221.1 Types
    • 6.221.2 Specify Objects
    • 6.221.3 Data
    • 6.221.4 Summary
  • 6.222 Sign In (checking for updates)
  • 6.223 Single Record View
  • 6.224 Save Snippet (User-Defined)
  • 6.225 Edit Snippets (User-Defined)
  • 6.226 Show SQL
  • 6.227 Start Date, End Date, Repeat Interval, Comments (Scheduler)
  • 6.228 Subversion: Add Property
  • 6.229 Subversion: Add to Source Control
  • 6.230 Subversion: Apply Patch
  • 6.231 Subversion: Branch/Tag
  • 6.232 Subversion: Check Out from Subversion
  • 6.233 Subversion: Commit Resources
  • 6.234 Subversion: Commit Working Copy
  • 6.235 Subversion: Confirm Checkout
  • 6.236 Subversion: Create Remote Directory
  • 6.237 Subversion: Create Subversion Repository
  • 6.238 Subversion: Create/Edit Subversion Connection
  • 6.239 Subversion: Delete Resources
  • 6.240 Subversion: Edit Configuration File
  • 6.241 Subversion: Export Files
  • 6.242 Subversion: Export Subversion Connections
  • 6.243 Subversion: Ignore
  • 6.244 Subversion: Import Subversion Connections
  • 6.245 Subversion: Import to Subversion
    • 6.245.1 Destination
    • 6.245.2 Source
    • 6.245.3 Filters
    • 6.245.4 Options
    • 6.245.5 Summary
  • 6.246 Subversion: Lock Resources
  • 6.247 Subversion: Merge
  • 6.248 Subversion: Pending Changes
  • 6.249 Subversion: Properties
  • 6.250 Subversion: Remove from Subversion
  • 6.251 Subversion: Repository Browser
  • 6.252 Subversion: Revert Local Changes
  • 6.253 Subversion: Switch
  • 6.254 Subversion: Unlock Resources
  • 6.255 Subversion: Update Resources
  • 6.256 Subversion: Update Working Copy
  • 6.257 Subversion: Versioning Properties
  • 6.258 Third-Party Database Objects
  • 6.259 Unable to Connect
  • 6.260 Unable to Open File
  • 6.261 Uninstall Oracle REST Data Services
  • 6.262 Unplug Pluggable Database
  • 6.263 Unsupported Database Version
  • 6.264 Validate Geometry
  • 6.265 View Whole Value
  • 6.266 Windows
  • 6.267 XMLType Column Properties