Go to main content
1/14
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Product Accessibility
Related Documents
Conventions
Third-Party License Information
ActiveDBSoft
Antlr 2.7.6, 3.1.3
Apache Commons Logging 1.0.4, 1.1
Apache Geronimo JMS 1.1 Specification 1.0, 1.1
Apache POI 3.10.1
ASM 5.0.4
Bouncy Castle Crypto API 1.45
Commons HttpClient 4.2.6
dom4j 1.6.1
HttpComponents
iText OEM Desktop 5.5.3
Jackson 1.9.3, 2.8.5
JGoodies Looks 1.3.1
jGraphX.jar 2.1.0.9
JLine 2.12.1
JSch 0.1.51
JXLayer 4.0
JZlib 1.1.3
Log4j 1.2.8, 1.2.13, 1.2.15, 1.2.17, 1.3
MigLayout 4.0
POI 2.5.1
Regular Expression Package 1.3
StringTemplate 3.1
SVNKit 1.0.0, 1.3.0
1
SQL Developer Concepts and Usage
1.1
About SQL Developer
1.2
Installing and Getting Started with SQL Developer
1.3
SQL Developer User Interface
1.3.1
Menus for SQL Developer
1.3.2
Restoring the Original "Look and Feel"
1.4
Database Objects
1.4.1
Applications (Application Express 3.0.1 and Later)
1.4.2
Cache Groups (Oracle TimesTen In-Memory Database)
1.4.3
Chains
1.4.4
Credentials
1.4.5
Database Destinations
1.4.6
Database Links (Public and Private)
1.4.7
Destination Groups
1.4.8
Directories
1.4.9
Editions
1.4.10
File Watchers
1.4.11
Functions
1.4.12
Indexes
1.4.13
Java Sources
1.4.14
Jobs
1.4.15
Job Classes
1.4.16
Operators
1.4.17
Materialized Views
1.4.18
Materialized View Logs
1.4.19
Multitenant Container Database (CDB)
1.4.20
Packages
1.4.21
Procedures
1.4.22
Programs
1.4.23
Queues
1.4.24
Queue Tables
1.4.25
Recycle Bin
1.4.26
Replication Schemes (Oracle TimesTen In-Memory Database)
1.4.27
Schedules
1.4.28
Sequences
1.4.29
Synonyms (Public and Private)
1.4.30
Tables
1.4.30.1
Flashback Table Support
1.4.31
Triggers
1.4.32
Types
1.4.33
Users (Other Users)
1.4.34
Views
1.4.35
Window Groups
1.4.36
Windows
1.4.37
XML DB Repository
1.4.38
XML Schemas
1.4.39
Captured and Converted Database Objects (for Migration)
1.5
Database Connections
1.5.1
Using Folders to Group Connections
1.5.2
Sharing of Connections
1.5.3
Advanced Security for JDBC Connection to the Database
1.5.4
Connections with Operating System (OS) Authentication
1.5.5
Connections with Proxy Authentication
1.5.6
Connections with SSH Authentication
1.6
Entering and Modifying Data
1.7
Running and Debugging Functions and Procedures
1.7.1
Using Bookmarks When Editing Functions and Procedures
1.7.2
Remote Debugging
1.7.3
Displaying SQL Trace (.trc) Files
1.7.4
Using the PL/SQL Hierarchical Profiler
1.7.5
Setting Expression Watches
1.8
Using the SQL Worksheet
1.8.1
SQL*Plus Statements Supported in SQL Worksheet
1.8.2
Script Runner
1.8.3
Execution Plan
1.8.4
Autotrace Pane
1.8.5
DBMS Output Pane
1.8.6
OWA Output Pane
1.8.7
SQL History
1.8.8
Query Builder
1.8.9
Command-Line Interface for SQL Formatting
1.8.10
SQL Worksheet "Hints" for Formatting Output
1.8.11
Gauges: In the SQL Worksheet and User-Defined Reports
1.8.12
Entering OLAP DML Statements in the SQL Worksheet
1.9
Using Snippets to Insert Code Fragments
1.9.1
User-Defined Snippets
1.10
Finding Database Objects
1.11
Using Recent Objects
1.12
Using Versioning
1.12.1
About Subversion and SQL Developer
1.12.2
Pending Changes
1.13
Using DBA Features in SQL Developer
1.13.1
Container Database (CDB)
1.13.2
Database Configuration
1.13.2.1
Initialization Parameters
1.13.2.2
Automatic Undo Management
1.13.2.3
Current Database Properties
1.13.2.4
Restore Points
1.13.2.5
View Database Feature Usage
1.13.3
Database Status
1.13.3.1
Status
1.13.3.2
DB Instance
1.13.3.3
Instance Viewer
1.13.4
Data Guard
1.13.5
Data Pump
1.13.5.1
Export Jobs
1.13.5.2
Import Jobs
1.13.6
Oracle Sharding
1.13.7
Performance
1.13.7.1
Snapshots
1.13.7.2
Baselines
1.13.7.3
Baseline Templates
1.13.7.4
Automatic Database Diagnostic Monitor (ADDM)
1.13.7.5
ASH (Active Session History) Report Viewer
1.13.7.6
AWR (Automatic Workload Repository)
1.13.8
RMAN Backup/Recovery
1.13.8.1
Backup Jobs
1.13.8.2
Backup Sets
1.13.8.3
Image Copies
1.13.8.4
RMAN Settings
1.13.8.5
Scheduled RMAN Actions
1.13.8.6
Using Action Jobs
1.13.9
Resource Manager
1.13.9.1
Consumer Group Mappings
1.13.9.2
Consumer Groups
1.13.9.3
Plans
1.13.9.4
Settings
1.13.9.5
Statistics
1.13.10
SQL Translator FrameWork
1.13.10.1
SQL Translator Profiles
1.13.10.2
SQL Translators
1.13.11
Scheduler
1.13.11.1
Global Attributes
1.13.11.2
Job Classes
1.13.11.3
External Destinations
1.13.12
Security
1.13.12.1
Audit Settings
1.13.12.2
Profiles
1.13.12.3
Roles
1.13.12.4
Users
1.13.13
Storage
1.13.13.1
Archive Logs
1.13.13.2
Control Files
1.13.13.3
Datafiles
1.13.13.4
Redo Log Groups
1.13.13.5
Rollback Segments
1.13.13.6
Tablespaces
1.13.13.7
Temporary Tablespace Groups
1.13.14
Tuning
1.13.14.1
Real Time SQL Monitor
1.14
Scheduling Jobs Using SQL Developer
1.14.1
Scheduler Design Editor
1.15
Using the Cart
1.15.1
Adding Data Files to the Cart
1.15.2
Cart Versus Database Export Wizard
1.16
Spatial Support in SQL Developer
1.16.1
Context Menu Operations on Spatial Data and Metadata
1.16.2
Map Visualization of Spatial Data
1.16.2.1
Visualizing Geometries by Creating and Executing a Query
1.16.2.2
Visualizing Geometries from the Table Data Grid
1.17
Change Manager Support in SQL Developer
1.17.1
Change Plan Administrators and Developers
1.17.2
Developing Change Plans with SQL Developer
1.17.2.1
Creating a Repository Connection
1.17.2.2
Creating and Deleting Change Plans
1.17.2.3
Adding and Updating Change Items
1.17.2.4
Using Change Plans to Capture Change in SQL Developer
1.17.3
Change Manager Actions to Perform with Enterprise Manager
1.17.3.1
Creating Change Plans from Change Manager Schema Comparisons
1.17.3.2
Deploying Change Plans
1.18
Apache Hadoop Connectors Support in SQL Developer
1.18.1
Copy to Hadoop: Overview and Requirements
1.18.2
Oracle Loader for Hadoop: Overview and Requirements
1.18.3
Oracle SQL Connector for HDFS: Overview and Requirements
1.19
SQL Developer Reports
1.19.1
Bind Variables for Reports
1.19.2
About Your Database reports
1.19.3
All Objects reports
1.19.4
Application Express reports
1.19.5
ASH and AWR reports
1.19.6
Charts reports
1.19.7
Database Administration reports
1.19.8
Data Dictionary reports
1.19.9
Scheduler reports
1.19.10
PL/SQL reports
1.19.11
Security reports
1.19.12
Streams reports
1.19.13
Table reports
1.19.13.1
Quality Assurance reports
1.19.14
XML reports
1.19.15
Data Modeler reports
1.19.16
User Defined reports
1.19.16.1
User-Defined Report Example: Chart
1.19.16.2
User-Defined Report Example: Dynamic HTML
1.20
SQL Developer Preferences
1.20.1
Environment
1.20.2
Change Management Parameters
1.20.3
Code Editor
1.20.4
Compare and Merge
1.20.5
Database
1.20.6
Debugger
1.20.7
External Editor
1.20.8
File Types
1.20.9
Global Ignore List
1.20.10
Migration
1.20.11
Mouse Actions
1.20.12
Shortcut Keys (Accelerator Keys)
1.20.13
SSH (Secure Shell)
1.20.14
Unit Test Parameters
1.20.15
Usage Reporting
1.20.16
Versioning
1.20.16.1
Versioning: Git
1.20.16.2
Versioning: Subversion
1.20.16.3
Versioning: CVS
1.20.16.4
Versioning: Perforce
1.20.17
Web Browser and Proxy
1.20.18
XML Schemas
1.21
Location of User-Related Information
1.22
Java Development Kit (JDK) Location
1.23
Command-Line Interface for SQL Developer
1.24
Data Modeler in SQL Developer
1.25
Oracle TimesTen In-Memory Database Support
1.26
Using the Help
1.27
SQL Developer Usage Suggestions
1.27.1
SQL History Shortcuts
1.27.2
Unshared Worksheets
1.27.3
SQL Worksheet Bookmarks
1.27.4
Oracle Data Miner
1.27.5
Formatted Display of SQL Trace (.trc) Files
1.27.6
Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
1.27.7
Folders for Organizing Connections
1.27.8
Third-Party Databases and SQL Developer
1.27.9
Debugger Ports and Firewalls
1.27.10
Viewing Multiple Tables
1.27.11
Customizing SQL Developer Appearance
1.27.12
Maximizing Tab Panes
1.27.13
Default Path for Running Scripts
1.27.14
Shutting Down and Restarting the Database
1.27.15
Feature Requests
1.27.16
Discussion Forums
1.27.17
Help Text Font Size
1.27.18
Procedure and Function Signatures
1.27.19
Type-Ahead in Navigators
1.27.20
Extended Paste
1.27.21
Closing Tabbed Windows Using the Mouse Wheel
1.27.22
Go to Last Edit Location
1.27.23
Closing Tabbed Windows Using the Context Menu
1.27.24
List of All Open Windows
1.27.25
Go to Subprogram Implementation from Package Window
1.27.26
Select Multiple Table or Column Names in Completion Insight
1.27.27
Startup Time and Automatic Check for Updates
1.28
For More Information About SQL Developer
2
SQL Developer: Migrating Third-Party Databases
2.1
Migration: Basic Options and Steps
2.1.1
Migrating Using the Migration Wizard
2.1.1.1
Repository
2.1.1.2
Project
2.1.1.3
Source Database
2.1.1.4
Capture
2.1.1.5
Convert
2.1.1.6
Translate
2.1.1.7
Target Database
2.1.1.8
Move Data
2.1.1.9
Summary
2.1.2
Copying Selected Tables to Oracle
2.2
Migration: Background Information and Guidelines
2.2.1
Overview of Migration
2.2.1.1
Migration Implemented as SQL Developer Extensions
2.2.2
Preparing a Migration Plan
2.2.2.1
Task 1: Determining the Requirements of the Migration Project
2.2.2.2
Task 2: Estimating Workload
2.2.2.3
Task 3: Analyzing Operational Requirements
2.2.2.4
Task 4: Analyzing the Application
2.2.2.5
Task 5: Planning the Migration Project
2.2.3
Before You Start Migrating: General Information
2.2.3.1
Creating a Database User for the Migration Repository
2.2.3.2
Requirements for Creating the Destination Oracle Objects
2.2.4
Before You Start Migrating: Source-Specific Information
2.2.4.1
Before Migrating From IBM DB2
2.2.4.2
Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
2.2.4.3
Before Migrating From MySQL
2.2.4.4
Before Migrating From Teradata
2.2.5
Capturing the Source Database
2.2.5.1
Offline Capture
2.2.5.1.1
IBM DB2 Offline Capture Notes
2.2.6
Creating and Customizing the Converted Model
2.2.6.1
Correcting Errors in the Converted Model
2.2.7
Generating the DDL for the Oracle Schema Objects
2.2.8
Migrating the Data
2.2.8.1
Transferring the Data Offline
2.2.8.1.1
Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
2.2.8.1.2
Creating Data Files From MySQL
2.2.8.1.3
Populating the Destination Database Using the Data Files
2.2.9
Making Queries Case Insensitive
2.2.10
Testing the Oracle Database
2.2.10.1
Testing Methodology
2.2.10.2
Testing the Oracle Database
2.2.10.2.1
Guidelines for Creating Tests
2.2.10.2.2
Example of a Unit Test Case
2.2.11
Deploying the Oracle Database
2.2.11.1
Choosing a Rollout Strategy
2.2.11.1.1
Phased Approach
2.2.11.1.2
Big Bang Approach
2.2.11.1.3
Parallel Approach
2.2.11.2
Deploying the Destination Database
2.3
SQL Developer User Interface for Migration
2.3.1
Migration Submenu
2.3.2
Other Menus: Migration Items
2.3.3
Migration Preferences
2.3.4
Migration Log Panes
2.3.5
Using the Translation Scratch Editor
2.4
Command-Line Interface for Migration
3
SQL Developer: Oracle REST Data Services Support
3.1
Installing Oracle REST Data Services
3.2
Oracle REST Data Services Administration
3.2.1
About Oracle REST Data Services
3.2.2
Oracle REST Data Services Administration Toolbar and Context Menu
3.2.3
Connecting to Oracle REST Data Services
3.2.4
REST Data Services Navigator: Global Settings and Database Settings
3.2.4.1
Connections
3.2.4.2
Default Password
3.2.4.3
ORDS Public User (Database Settings Only)
3.2.4.4
PL/SQL Gateway User (Database Settings Only)
3.2.4.5
APEX REST Users (Database Settings Only)
3.2.4.6
Security
3.2.4.7
Cache Files
3.2.4.8
Environment
3.2.4.9
Excel
3.2.5
REST Data Services Navigator: NoSQL Store Configuration
3.2.6
REST Data Services Navigator: Reports
3.3
Automatically Enabling REST Access to a Schema, Table, or View (AutoREST)
3.4
REST Development
3.4.1
About RESTful Services
3.4.2
RESTful Services Terminology
3.4.3
RESTful Services Requirements and Setup
3.4.4
REST Data Services in the Connections Navigator
3.4.5
REST Development Pane
4
SQL Developer: Unit Testing
4.1
Overview of Unit Testing
4.2
SQL Developer User Interface for Unit Testing
4.2.1
Unit Test Submenu
4.2.2
Other Menus: Unit Test Items
4.2.3
Unit Test Preferences
4.3
Unit Test Repository
4.3.1
Managing Repository Users and Administrators
4.4
Editing and Running a Unit Test
4.5
Using a Dynamic Value Query to Create a Unit Test
4.6
Using Lookups to Simplify Unit Test Creation
4.6.1
Providing Values for Input Fields
4.6.2
Automatically Creating Implementations
4.7
Using Variable Substitution in Validation Actions
4.8
Unit Test Library
4.9
Unit Test Reports
4.10
Exporting and Importing Unit Test Objects
4.11
Command-Line Interface for Unit Testing
4.12
Unit Testing Best Practices
4.12.1
Strategy
4.12.2
Test Suites
4.12.3
Test Naming
4.12.4
Avoiding Test Naming Clashes
4.12.5
Test Implementations
4.12.6
Library
4.12.7
Lookups
4.12.8
Test and Suite Execution
4.12.9
Reports
4.13
Example of Unit Testing (Tutorial)
4.13.1
Create the EMPLOYEES Table
4.13.2
Create the AWARD_BONUS Procedure
4.13.3
Create the Unit Testing Repository
4.13.4
Create a Unit Test
4.13.5
Run the Unit Test
4.13.6
Create and Run an Exception Unit Test
4.13.7
Create a Unit Test Suite
4.13.8
Run the Unit Test Suite
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
Advanced Properties (Connections)
6.3.1
Proxy tab
6.4
Application Migration
6.5
Associate Repository
6.6
Cart Error (Objects Not Available)
6.7
Change Type
6.8
Check for Updates
6.9
Choose Configuration File Option
6.10
Choose Directory
6.11
Clone PDB to Oracle Cloud
6.12
Clone Pluggable Database
6.13
Cloud Migrations Wizard
6.13.1
AWS Redshift Database
6.13.2
Autonomous Data Warehouse Cloud
6.13.3
Summary
6.14
Color Palette and Custom Colors
6.15
Configure Extension
6.16
Configure File Type Associations
6.17
Configure OSS
6.18
Copy Columns
6.19
Copy Objects
6.20
Copy to Hadoop / Append to Hadoop Table
6.21
Copy to Oracle
6.22
Component Palette
6.23
Component Palette: Configure Component Palette
6.24
Component Palette: Create Palette Page
6.25
Component Palette: New/Edit Code Snippet
6.26
Component Palette: New Section/Rename Section
6.27
Confirm Drop Application
6.28
Confirm Running SQL
6.29
Connection Has Uncommitted Changes
6.30
Create New Object
6.31
Create/Edit Chain
6.32
Create/Edit Credential
6.33
Create/Edit/Select Database Connection
6.33.1
Oracle tab
6.33.2
TimesTen tab
6.33.3
Amazon Redshift tab
6.33.4
DB2 tab
6.33.5
Hive tab
6.33.6
JDBC tab
6.33.7
MySQL tab
6.33.8
PostgreSQL tab
6.33.9
SQL Server and Sybase tab
6.33.10
Teradata tab
6.33.11
Creating and Editing Connections
6.34
New/Edit Cloud Connection
6.34.1
Advanced Connection Information
6.35
New/Edit NoSQL Connection
6.36
Rename Model (Migration)
6.37
Delete Confirmation
6.38
Delete Confirmation (Migration)
6.39
Rename Database Item (Migration)
6.40
Select Connection
6.41
Connection Information
6.42
No Connection Found
6.43
Connection Rename Error
6.44
New Folder (Connections)
6.45
Continue After Pause
6.46
Select Library
6.47
Create Library
6.48
CVS: Check Out from CVS
6.49
CVS: Create/Edit CVS Connection
6.50
CVS: Import to CVS
6.51
CVS: Log In to CVS
6.52
Data Import Wizard (Load Data from Tables or Files)
6.52.1
Data Preview
6.52.2
Import Method
6.52.3
Import Metadata Source
6.52.4
Choose Columns
6.52.5
Column Definition
6.52.6
Finish
6.53
Export/Import Connections
6.53.1
Export Connections
6.53.2
Import Connections
6.54
Create/Edit Database Destination
6.55
Create/Edit Destination Group (Database or External)
6.56
Create/Edit Database Link
6.57
Create/Edit Index
6.57.1
Definition
6.57.2
Properties
6.57.3
Storage
6.57.4
Partitions
6.57.5
DDL
6.58
Create File Watcher
6.59
Create Filter
6.60
Create Function or Procedure
6.61
Create/Edit Job
6.61.1
Job Details
6.61.2
Destination
6.61.3
Job Arguments
6.61.4
Notification
6.61.5
Properties
6.61.6
Summary/SQL
6.62
Create/Edit Job Class
6.63
Create/Edit Materialized View Log
6.64
Create PL/SQL Package
6.65
Create Pluggable Database
6.66
Create/Edit Program
6.67
Create/Edit Role
6.68
Create/Edit Schedule
6.69
Create/Edit Sequence
6.70
Create SQL File
6.71
Create/Edit Synonym
6.72
Create Table (quick creation)
6.73
Create/Edit Table (with advanced options)
6.73.1
Columns pane
6.73.2
Constraints
6.73.3
Primary Key Constraint
6.73.4
Unique Constraints
6.73.5
Foreign Keys Constraints
6.73.6
Check Constraints
6.73.7
Indexes pane
6.73.8
In-Memory pane
6.73.9
Storage pane
6.73.10
Column Sequences pane
6.73.11
Table Properties pane
6.73.12
LOB Parameters pane
6.73.13
Partitioning pane
6.73.14
Subpartition Templates pane
6.73.15
Partition Definitions pane
6.73.16
Index Organized Properties pane
6.73.17
External Table Properties pane
6.73.18
Comment pane
6.73.19
DDL pane
6.73.20
Hive Tables
6.73.20.1
Hive Tables: Partitions
6.73.20.2
Hive Tables: Buckets
6.73.20.3
Hive Tables: Skew
6.73.20.4
Hive Tables: Storage
6.73.20.5
Hive Tables: Table Properties
6.74
Storage Options
6.75
Create/Edit Tablespace
6.75.1
File Specifications tab
6.75.2
Properties tab
6.75.3
Default Parameters tab
6.75.4
DDL tab
6.76
Create Trigger
6.77
Create Type (User-Defined)
6.78
Create/Edit User
6.78.1
User tab
6.78.2
Granted Roles tab
6.78.3
System Privileges tab
6.78.4
Quotas tab
6.78.5
SQL tab
6.79
Create/Edit User Defined Report
6.80
Create/Edit User Defined Report Folder
6.81
Create/Edit View
6.81.1
SQL Query tab or pane
6.81.2
View Properties or Materialized View Properties pane
6.81.3
DDL tab or pane
6.81.4
Quick-Pick Objects pane
6.81.5
FROM Clause pane
6.81.6
SELECT Clause pane
6.81.7
WHERE Clause pane
6.81.8
GROUP BY Clause pane
6.81.9
HAVING Clause pane
6.81.10
ORDER BY Clause pane
6.82
Create Window
6.83
Create Window Group
6.84
Create XML Document from XML Schema
6.85
Create XML Schema
6.86
Custom Filters
6.87
Customize Toolbars
6.88
Data Pump Export
6.88.1
Source page
6.88.2
Tablespaces page
6.88.3
Schemas page
6.88.4
Tables page
6.88.5
Filter page
6.88.6
Table Data page
6.88.7
Options page
6.88.8
Output Files page
6.88.9
Job Schedule page
6.88.10
Summary page
6.89
Data Pump Import
6.89.1
Type page
6.89.2
Tablespaces page
6.89.3
Schemas page
6.89.4
Tables page
6.89.5
Filter page
6.89.6
Table Data page
6.89.7
Remapping page
6.89.8
Options page
6.89.9
Job Schedule page
6.89.10
Summary page
6.90
Database Copy
6.90.1
Source/Destination page
6.90.2
Object Types page
6.90.3
Select Schemas page
6.90.4
Select Tablespace page
6.90.5
Specify Objects page
6.90.6
Specify Data page
6.90.7
Summary page
6.91
Database Differences
6.91.1
Source/Destination page
6.91.2
Types to Diff page
6.91.3
Specify Objects page
6.91.4
Summary page
6.92
Database Export (Unload Database Objects and Data)
6.92.1
Source/Destination page
6.92.2
Types to Export page
6.92.3
Specify Objects page
6.92.4
Specify Data page
6.92.5
Export Summary page
6.93
DDL Panel for Creating or Editing an Object
6.94
Debugger - Attach to JPDA
6.95
Deploy or Import Application
6.96
Deploy Objects to Cloud
6.96.1
Cloud
6.96.2
Authorization
6.96.3
Transfer
6.96.4
Deploy DDL
6.96.5
Deploy Data
6.96.6
Unsupported Cart Object for Cloud Deployment
6.96.7
Other Errors (Invalid or Missing Entries)
6.97
Describe Object Window
6.98
Diff Objects
6.99
Drop Pluggable Database
6.100
Drop REST Services for Schema
6.101
Edit/View Value (Data or Table Column)
6.102
Enter Bind Values
6.103
Erase from Disk
6.104
Error Writing to Export File
6.105
Export Error
6.106
Export Data
6.107
Export Objects
6.108
Export Resource Module, Privilege, and Role
6.109
Export: Unique Names Warning
6.110
External Locator Configuration
6.111
External Tools
6.112
Create/Edit External Tool
6.112.1
Program Options
6.112.2
Display
6.112.3
Integration
6.112.4
Availability
6.113
Choose Offline Options
6.114
Edit Font Location
6.115
Edit Header or Footer (PDF Formatting)
6.116
Edit Join
6.117
Feature Missing
6.118
Feature Required
6.119
File Processing
6.120
Filter
6.121
Filter Object Types
6.122
Filter Schemas
6.123
Filter Error
6.124
Find/Highlight
6.125
Git: Add
6.126
Git: Add All
6.127
Git: Add to .gitignore File
6.128
Git: Checkout Revision
6.129
Git: Clone from Git
6.130
Git: Commit
6.131
Git: Commit All
6.132
Git: Create Branch
6.133
Git: Create Tag
6.134
Git: Export Committed Changes
6.135
Git: Export Uncommitted Changes
6.136
Git: Fetch from Git
6.137
Git: Initialize Repository
6.138
Git: Merge
6.139
Git: Pull from Git
6.140
Git: Push to Git
6.141
Git: Revert
6.142
Insert Macro
6.143
Externally Modified Files
6.144
Find/Replace Text
6.145
Find Result
6.146
Format Properties (Advanced Formatting)
6.147
Generate Patch
6.148
Go to Bookmark
6.149
Go to Line Number
6.150
Go to Line Number: Error
6.151
History
6.152
Import Using Oracle Loader for Hadoop
6.153
Import Using Oracle SQL Connector for HDFS
6.154
Install/Run Oracle REST Data Services
6.154.1
ORDS File Locations
6.154.2
Database Connection
6.154.3
Database Options
6.154.4
Select Tablespace
6.154.5
PL/SQL Gateway
6.154.6
APEX RESTful Services
6.154.7
Run Standalone Mode
6.154.8
ORDS Users
6.154.9
Summary
6.155
Install SQL Translator
6.155.1
Installing a Translator and Creating a Profile: Usage Notes
6.156
Invalid Database Version
6.157
Load Extension
6.158
Load Keyboard Scheme
6.159
LOB Descriptors
6.160
Maintain Spatial Metadata
6.161
Manage Columns
6.162
Manage Connections (REST)
6.163
Manage Features and Updates
6.164
Map Connection
6.165
Merge Migration Projects
6.166
Modify Pluggable State
6.167
Modify Value
6.168
Data Move Details
6.169
New/Edit Change Set
6.170
New Procedure (Refactoring)
6.171
New/Edit Local or Remote Port Forward
6.172
Edit SSH Connection
6.173
No Lock
6.174
No Object Found
6.175
No Object Selected
6.176
Object Preferences
6.177
Offline Generation Error - Destination Directory
6.178
Open File
6.179
Oracle-Only Report
6.180
Paste
6.181
Perforce: Add Files to Perforce
6.182
Perforce: Connection
6.183
Perforce: Create Changelist
6.184
Perforce: Delete Files
6.185
Perforce: Login
6.186
Perforce: Open Files for Edit
6.187
Perforce: Revert Files
6.188
Perforce: Sync Files
6.189
Perforce: Submit Changelist
6.190
Plug In Pluggable Database
6.191
Print Preview
6.192
Privilege Warning for Migration
6.193
Publish to REST
6.194
Recent Files
6.195
Delete or Truncate Repository
6.195.1
Error Truncating Repository
6.196
Rename Local Variable
6.197
Rename Tab
6.198
Rename Procedure
6.199
Repair (Validate) Oracle REST Data Services
6.200
REST Data Services Connection
6.201
REST Data Services Connection: Authentication Failed
6.202
REST Data Services Connection: Remove Connection
6.203
RESTful Services Wizard (Auto-Enable REST Access)
6.203.1
Specify Details
6.203.2
RESTful Summary
6.204
RESTful Services Wizard and Object Dialog Boxes
6.204.1
Resource Module
6.204.2
Resource Template
6.204.3
Resource Handler
6.204.3.1
Resource Handler Editing Pane
6.204.4
RESTful Summary
6.205
RESTful Services Connection
6.206
RESTful Services Privilege
6.207
RESTful Services Roles
6.208
Select Current Repository
6.209
Cannot Capture Table
6.210
Report Panel
6.211
Reset Expired Password (Enter New Password)
6.212
Revision Lister
6.213
Run/Debug/Profile PL/SQL
6.214
Create/Edit Breakpoint
6.214.1
Definition tab
6.214.2
Conditions tab
6.214.3
Actions tab
6.215
Save/Save As, or Select File
6.216
Save or Open Cart Tool Configuration
6.217
Save Files
6.218
Unable to Save Files
6.219
Save Style Settings
6.220
Schema Differences Source or Destination Error
6.221
Script Execution Failed
6.222
Script Generation Complete
6.223
Set Data Mapping
6.224
Add/Edit Rule
6.225
Set Encoding
6.226
Set Pause Continue
6.227
Shared Wizard Pages
6.227.1
Types
6.227.2
Specify Objects
6.227.3
Data
6.227.4
Summary
6.228
Sign In (checking for updates)
6.229
Single Record View
6.230
Save Snippet (User-Defined)
6.231
Edit Snippets (User-Defined)
6.232
Show SQL
6.233
Start Date, End Date, Repeat Interval, Comments (Scheduler)
6.234
Subversion: Add Property
6.235
Subversion: Add to Source Control
6.236
Subversion: Apply Patch
6.237
Subversion: Branch/Tag
6.238
Subversion: Check Out from Subversion
6.239
Subversion: Commit Resources
6.240
Subversion: Commit Working Copy
6.241
Subversion: Confirm Checkout
6.242
Subversion: Create Remote Directory
6.243
Subversion: Create Subversion Repository
6.244
Subversion: Create/Edit Subversion Connection
6.245
Subversion: Delete Resources
6.246
Subversion: Edit Configuration File
6.247
Subversion: Export Files
6.248
Subversion: Export Subversion Connections
6.249
Subversion: Ignore
6.250
Subversion: Import Subversion Connections
6.251
Subversion: Import to Subversion
6.251.1
Destination
6.251.2
Source
6.251.3
Filters
6.251.4
Options
6.251.5
Summary
6.252
Subversion: Lock Resources
6.253
Subversion: Merge
6.254
Subversion: Pending Changes
6.255
Subversion: Properties
6.256
Subversion: Remove from Subversion
6.257
Subversion: Repository Browser
6.258
Subversion: Revert Local Changes
6.259
Subversion: Switch
6.260
Subversion: Unlock Resources
6.261
Subversion: Update Resources
6.262
Subversion: Update Working Copy
6.263
Subversion: Versioning Properties
6.264
Third-Party Database Objects
6.265
Unable to Connect
6.266
Unable to Open File
6.267
Uninstall Oracle REST Data Services
6.268
Unit Testing: Action Required
6.269
Unit Testing: Add Category
6.270
Unit Testing: Add Data Type
6.271
Unit Testing: Add Item to Library
6.272
Unit Testing: Add Test Implementation
6.273
Unit Testing: Add Test Suite
6.274
Unit Testing: Add Tests or Suites to a Suite
6.275
Unit Testing: Copy or Rename Unit Test
6.276
Unit Testing: Create Unit Test
6.276.1
Select Operation
6.276.2
Specify Test Name
6.276.3
Specify Startup
6.276.4
Specify Parameters
6.276.5
Specify Validations
6.276.6
Specify Teardown
6.276.7
Summary
6.277
Unit Testing: Manage Users
6.278
Unit Testing: Rename Test Implementation
6.279
Unit Testing: Result of Operation
6.280
Unit Testing: Synchronize Unit Test
6.281
Unplug Pluggable Database
6.282
Unsupported Database Version
6.283
Validate Geometry
6.284
View Whole Value
6.285
Windows
6.286
XMLType Column Properties
7
SQL Developer: TimesTen Support
7.1
Create a New TimesTen Connection
7.1.1
DSN
7.1.2
Easy Client/Server
7.1.3
Advanced
7.2
Set the Cache Administrator User Name and Password
7.3
Start and Stop the Cache Agent
7.4
Create a Cache Group
7.4.1
Defining a cache group and cache table attributes
7.4.2
Defining the root table
7.4.2.1
Selecting the columns to cache
7.4.2.2
Specifying the table attributes
7.4.2.3
Specifying an aging policy
7.4.2.4
Verifying the root table definition
7.4.3
Defining the child tables
7.4.3.1
Selecting the columns to cache
7.4.3.2
Specifying the table attributes
7.4.3.3
Completing the definitions of the child tables
7.4.3.4
Verifying the cache group definition
7.5
Drop a Cache Group
7.6
Load or Refresh a Cache Group
7.7
Flush a Cache Group
7.8
Unload a Cache Group
7.9
Alter the Automatic Refresh Attributes of a Cache Group
7.10
Specify and Display LOB Data Types
7.11
Specify the INLINE Attribute for Columns
7.12
Compute Table Size
7.13
Use a REF CURSOR as an OUTPUT Parameter
7.14
Create an Index on a TimesTen Table
7.15
Create a Primary Key Constraint
7.16
Change the Attributes of Primary Key
7.17
Create a Foreign Key Constraint
7.18
Drop a Constraint
7.19
Add an Aging Policy to a Table
7.20
Drop an Aging Policy from a Table
7.21
Change the Aging State for the Aging Policy of a Table
7.22
Change the Memory Usage Thresholds and LRU Aging Cycle
7.23
Change the Lifetime and Cycle for the Time-Based Aging Policy of a Table
7.24
Grant Object Privileges to a TimesTen Database Element
7.25
Revoke Object Privileges from a TimesTen Database Element
7.26
Load Data into a Table
7.27
Start and Stop the TimesTen Replication Agent
7.28
Update the Table and Column Statistics Used By the TimesTen Query Optimizer
7.29
Export the Table Statistics Used By the TimesTen Query Optimizer
7.30
Create a TimesTen Performance Metrics Snapshot
7.31
Drop a TimesTen Performance Metrics Snapshot
7.32
Edit the TimesTen Performance Metrics Configuration
7.33
Create a TimesTen Performance Metrics Report
7.33.1
Save a report
7.34
Capture Data for the TimesTen Index Advisor at the Connection Level
7.34.1
Capture data from a SQL worksheet
7.34.1.1
Saving index recommendations from a SQL worksheet
7.34.2
Capture data from a SQL workload script
7.35
Capture Data for the TimesTen Index Advisor at the Database Level
7.36
View the TimesTen Index Advisor Capture State
7.37
Load Data from an Oracle Database into a TimesTen Database
7.38
Load Data from an Oracle Database Table into an Existing TimesTen Table
Index
Scripting on this page enhances content navigation, but does not change the content in any way.