Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Third-Party License Information

1 SQL Developer Concepts and Usage

• 1.1 Installing and Getting Started with SQL Developer
• 1.2 SQL Developer User Interface
  • 1.2.1 Menus for SQL Developer
  • 1.2.2 Restoring the Original "Look and Feel"
• 1.3 Database Objects
  • 1.3.1 Applications (Application Express 3.0.1 and Later)
  • 1.3.2 Cache Groups (Oracle TimesTen In-Memory Database)
  • 1.3.3 Database Links (Public and Private)
  • 1.3.4 Directories
  • 1.3.5 Functions
  • 1.3.6 Indexes
  • 1.3.7 Java Sources
  • 1.3.8 Materialized Views
  • 1.3.9 Materialized View Logs
  • 1.3.10 Packages
  • 1.3.11 Procedures
  • 1.3.12 Queues
  • 1.3.13 Queue Tables
  • 1.3.14 Recycle Bin
  • 1.3.15 Replication Schemes (Oracle TimesTen In-Memory Database)
  • 1.3.16 Sequences
  • 1.3.17 Synonyms (Public and Private)
  • 1.3.18 Tables
    • 1.3.18.1 Flashback Table Support
  • 1.3.19 Triggers
  • 1.3.20 Types
  • 1.3.21 Users (Other Users)
  • 1.3.22 Views
  • 1.3.23 XML Schemas
  • 1.3.24 Captured and Converted Database Objects (for Migration)
• 1.4 Database Connections
  • 1.4.1 Using Folders to Group Connections
  • 1.4.2 Sharing of Connections
  • 1.4.3 Advanced Security for JDBC Connection to the Database
  • 1.4.4 Connections with Operating System (OS) Authentication
  • 1.4.5 Connections with Proxy Authentication
• 1.5 Entering and Modifying Data
• 1.6 Running and Debugging Functions and Procedures
  • 1.6.1 Using Bookmarks When Editing Functions and Procedures
  • 1.6.2 Remote Debugging
  • 1.6.3 Displaying SQL Trace (.trc) Files
  • 1.6.4 Using the PL/SQL Hierarchical Profiler
  • 1.6.5 Setting Expression Watches
• 1.7 Using the SQL Worksheet
  • 1.7.1 SQL*Plus Statements Supported and Not Supported in SQL Worksheet
  • 1.7.2 Script Runner
  • 1.7.3 Execution Plan
  • 1.7.4 Autotrace Pane
  • 1.7.5 DBMS Output Pane
  • 1.7.6 OWA Output Pane
  • 1.7.7 SQL History
  • 1.7.8 Gauges: In the SQL Worksheet and User-Defined Reports
• 1.8 Using Snippets to Insert Code Fragments
  • 1.8.1 User-Defined Snippets
• 1.9 Using Find DB Object to Find Database Objects
• 1.10 Using Extended Search
• 1.11 Using Versioning
  • 1.11.1 About CVS and SQL Developer
    • 1.11.1.1 Pending Changes (CVS)
  • 1.11.2 About Subversion and SQL Developer
• 1.12 SQL Developer Reports
  • 1.12.1 About Your Database reports
  • 1.12.2 All Objects reports
  • 1.12.3 Application Express reports
  • 1.12.4 ASH and AWR reports
  • 1.12.5 Charts reports
  • 1.12.6 Database Administration reports
  • 1.12.7 Data Dictionary reports
  • 1.12.8 Jobs reports
  • 1.12.9 PL/SQL reports
  • 1.12.10 Security reports
  • 1.12.11 Streams reports
  • 1.12.12 Table reports
  • 1.12.13 XML reports
  • 1.12.14 Migration reports
  • 1.12.15 User Defined reports
    • 1.12.15.1 User-Defined Report Example: Chart
    • 1.12.15.2 User-Defined Report Example: Dynamic HTML
• 1.13 SQL Developer Preferences
  • 1.13.1 Environment
  • 1.13.2 Accelerators (Keyboard Shortcuts)
  • 1.13.3 Code Editor
  • 1.13.4 Compare and Merge
  • 1.13.5 Database
  • 1.13.6 Debugger
  • 1.13.7 Extensions
  • 1.13.8 File Types
  • 1.13.9 Global Ignore List
  • 1.13.10 Migration
  • 1.13.11 Versioning
  • 1.13.12 Web Browser and Proxy
• 1.14 Location of User-Related Information
• 1.15 Oracle TimesTen In-Memory Database Support
• 1.16 Using the Help
• 1.17 For More Information

2 Migrating Third-Party Databases

• 2.1 Migration Quick Start
  • 2.1.1 Standard Migration
  • 2.1.2 Quick Migration
• 2.2 Overview of Migration
  • 2.2.1 How Migration Works
  • 2.2.2 Migration Implemented as SQL Developer Extensions
• 2.3 Preparing a Migration Plan
  • 2.3.1 Task 1: Determining the Requirements of the Migration Project
  • 2.3.2 Task 2: Estimating Workload
  • 2.3.3 Task 3: Analyzing Operational Requirements
  • 2.3.4 Task 4: Analyzing the Application
  • 2.3.5 Task 5: Planning the Migration Project
• 2.4 Before You Start Migrating: General Information
  • 2.4.1 Creating a Database User for the Migration Repository
  • 2.4.2 Requirements for Creating the Destination Oracle Objects
• 2.5 Before You Start Migrating: Source-Specific Information
  • 2.5.1 Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
  • 2.5.2 Before Migrating From Microsoft Access
    • 2.5.2.1 Creating Microsoft Access XML Files
  • 2.5.3 Before Migrating From MySQL
• 2.6 Capturing the Source Database
  • 2.6.1 Online Capture
  • 2.6.2 Offline Capture
• 2.7 Creating and Customizing the Converted Model
  • 2.7.1 Correcting Errors in the Converted Model
• 2.8 Generating the DDL for the Oracle Schema Objects
• 2.9 Migrating the Data
  • 2.9.1 Transferring the Data Offline
    • 2.9.1.1 Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
    • 2.9.1.2 Creating Data Files From Microsoft Access
    • 2.9.1.3 Creating Data Files From MySQL
    • 2.9.1.4 Populating the Destination Database Using the Data Files
• 2.10 Making Queries Case Insensitive
• 2.11 Testing the Oracle Database
  • 2.11.1 Testing Methodology
  • 2.11.2 Testing the Oracle Database
    • 2.11.2.1 Guidelines for Creating Tests
    • 2.11.2.2 Example of a Unit Test Case
• 2.12 Deploying the Oracle Database
  • 2.12.1 Choosing a Rollout Strategy
    • 2.12.1.1 Phased Approach
    • 2.12.1.2 Big Bang Approach
    • 2.12.1.3 Parallel Approach
  • 2.12.2 Deploying the Destination Database
• 2.13 Using Migration Reports
• 2.14 SQL Developer User Interface for Migration
  • 2.14.1 Migration Menu
  • 2.14.2 Other Menus: Migration Items
  • 2.14.3 Migration Preferences
  • 2.14.4 Migration Log Panes
  • 2.14.5 Using the Translation Scratch Editor

3 Tutorial: Creating Objects for a Small Database

• 3.1 Create a Table (BOOKS)
• 3.2 Create a Table (PATRONS)
• 3.3 Create a Table (TRANSACTIONS)
• 3.4 Create a Sequence
• 3.5 Insert Data into the Tables
• 3.6 Create a View
• 3.7 Create a PL/SQL Procedure
• 3.8 Debug a PL/SQL Procedure
• 3.9 Use the SQL Worksheet for Queries
• 3.10 Script for Creating and Using the Library Tutorial Objects

4 Dialog Boxes for Creating/Editing Objects

• 4.1 Add Extension
• 4.2 Branch/Tag
• 4.3 Check for Updates
• 4.4 Check Out from CVS
• 4.5 Check Out from Subversion
• 4.6 Choose Directory
• 4.7 Confirm Drop Application
• 4.8 Confirm Running SQL
• 4.9 Connection Has Uncommitted Changes
• 4.10 Create/Edit New Object (New Gallery)
• 4.11 Create/Edit CVS Connection
• 4.12 Create/Edit/Select Database Connection
• 4.13 Rename Model (Migration)
• 4.14 Rename Database Item (Migration)
• 4.15 Select Connection
• 4.16 Connection Information
• 4.17 No Connection Found
• 4.18 Connection Rename Error
• 4.19 New Folder (Connections)
• 4.20 Continue After Pause
• 4.21 Select Library
• 4.22 Create Library
• 4.23 Import Data
• 4.24 Export/Import Connection Descriptors
• 4.25 Create/Edit Database Link
• 4.26 Create/Edit Index
• 4.27 Create Filter
• 4.28 Create/Edit Materialized View Log
• 4.29 Create PL/SQL Package
• 4.30 Create PL/SQL Subprogram (Function or Procedure)
• 4.31 Create Remote Directory
• 4.32 Create/Edit Sequence
• 4.33 Create SQL File
• 4.34 Create/Edit Subversion Connection
• 4.35 Create Subversion Repository
• 4.36 Create/Edit Synonym
• 4.37 Create Table (quick creation)
• 4.38 Create/Edit Table (with advanced options)
• 4.39 Storage Options
• 4.40 Create Trigger
• 4.41 Create Type (User-Defined)
• 4.42 Create/Edit User
• 4.43 Create/Edit User Defined Report
• 4.44 Create/Edit User Defined Report Folder
• 4.45 Create/Edit View
• 4.46 Create XML Schema
• 4.47 Configure Extension
• 4.48 Configure File Type Associations
• 4.49 Custom Filters
• 4.50 Database Copy (Schema Objects)
• 4.51 Database Schema Differences
• 4.52 DDL Panel for Creating or Editing an Object
• 4.53 Debugger - Attach to JPDA
• 4.54 Deploy or Import Application
• 4.55 Describe Object Window
• 4.56 Edit Value (Table Column Data)
• 4.57 Enter Bind Values
• 4.58 Error Writing to Export File
• 4.59 Export (Database Objects and Data)
• 4.60 Export: Advanced Data Filter
• 4.61 Export Error
• 4.62 Export Table Data
• 4.63 External Locator Configuration
• 4.64 External Tools
• 4.65 Create/Edit External Tool
• 4.66 Choose Offline Options
• 4.67 Feature Required
• 4.68 Filter
• 4.69 Insert Macro
• 4.70 Externally Modified Files
• 4.71 Filter Object Types
• 4.72 Filter Schemas
• 4.73 Filter Error
• 4.74 Find/Replace Text
• 4.75 Find Result
• 4.76 Generate Oracle DDL
• 4.77 Generate Offline Data Move Files
• 4.78 Go to Bookmark
• 4.79 Go to Line Number
• 4.80 Go to Line Number: Error
• 4.81 Import to CVS
• 4.82 Load Preset Key Mappings
• 4.83 Log In to CVS
• 4.84 Modify Value
• 4.85 Data Move Details
• 4.86 New Procedure (Refactoring)
• 4.87 No Object Found
• 4.88 No Object Selected
• 4.89 Open File
• 4.90 Oracle-Only Report
• 4.91 Oracle Proxy Authentication
• 4.92 Paste
• 4.93 Privilege Warning for Migration
• 4.94 Query Builder
• 4.95 Recent Files
• 4.96 Create Repository
• 4.97 Delete or Truncate Repository
• 4.98 Capture Microsoft Access Exporter XML
• 4.99 Rename Local Variable
• 4.100 Rename Procedure
• 4.101 Select Current Repository
• 4.102 Cannot Capture Table
• 4.103 Reset Expired Password
• 4.104 Revision Lister
• 4.105 Run/Debug/Profile PL/SQL
• 4.106 Create/Edit Breakpoint
• 4.107 Save/Save As
• 4.108 Save Files
• 4.109 Unable to Save Files
• 4.110 Save Style Settings
• 4.111 Schema Differences Source or Destination Error
• 4.112 Script Execution Failed
• 4.113 Script Generation Complete
• 4.114 Set Data Mapping
• 4.115 Add/Edit Rule
• 4.116 Set Encoding
• 4.117 Set Pause Continue
• 4.118 Sign In (checking for updates)
• 4.119 Single Record View
• 4.120 Save Snippet (User-Defined)
• 4.121 Edit Snippets (User-Defined)
• 4.122 Unable to Open File
• 4.123 Unsupported Database Version
• 4.124 Windows

Index