1/10

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

• Installing and Getting Started with SQL Developer
• SQL Developer User Interface
  • Menus for SQL Developer
  • Restoring the Original "Look and Feel"
• Database Objects
  • Applications (Application Express 3.0.1 and Later)
  • Cache Groups (Oracle TimesTen In-Memory Database)
  • Database Links (Public and Private)
  • Directories
  • Functions
  • Indexes
  • Java Sources
  • Materialized Views
  • Materialized View Logs
  • Packages
  • Procedures
  • Queues
  • Queue Tables
  • Recycle Bin
  • Replication Schemes (Oracle TimesTen In-Memory Database)
  • Sequences
  • Synonyms (Public and Private)
  • Tables
    • Flashback Table Support
  • Triggers
  • Types
  • Users (Other Users)
  • Views
  • XML Schemas
  • Captured and Converted Database Objects (for Migration)
• Database Connections
  • Using Folders to Group Connections
  • Sharing of Connections
  • Advanced Security for JDBC Connection to the Database
  • Connections with Operating System (OS) Authentication
  • Connections with Proxy Authentication
• Entering and Modifying Data
• Running and Debugging Functions and Procedures
  • Using Bookmarks When Editing Functions and Procedures
  • Remote Debugging
  • Displaying SQL Trace (.trc) Files
  • Using the PL/SQL Hierarchical Profiler
  • Setting Expression Watches
• Using the SQL Worksheet
  • SQL*Plus Statements Supported and Not Supported in SQL Worksheet
  • Script Runner
  • Execution Plan
  • Autotrace Pane
  • DBMS Output Pane
  • OWA Output Pane
  • SQL History
  • Gauges: In the SQL Worksheet and User-Defined Reports
• Using Snippets to Insert Code Fragments
  • User-Defined Snippets
• Using Find DB Object to Find Database Objects
• Using Extended Search
• Using Versioning
  • About CVS and SQL Developer
    • Pending Changes (CVS)
  • About Subversion and SQL Developer
• SQL Developer Reports
  • About Your Database reports
  • All Objects reports
  • Application Express reports
  • ASH and AWR reports
  • Charts reports
  • Database Administration reports
  • Data Dictionary reports
  • Jobs reports
  • PL/SQL reports
  • Security reports
  • Streams reports
  • Table reports
  • XML reports
  • Migration reports
  • User Defined reports
    • User-Defined Report Example: Chart
    • User-Defined Report Example: Dynamic HTML
• SQL Developer Preferences
  • Environment
  • Accelerators (Keyboard Shortcuts)
  • Code Editor
  • Compare and Merge
  • Database
  • Debugger
  • Extensions
  • File Types
  • Global Ignore List
  • Migration
  • Versioning
  • Web Browser and Proxy
• Location of User-Related Information
• Oracle TimesTen In-Memory Database Support
• Using the Help
• For More Information

2 Migrating Third-Party Databases

• Migration Quick Start
  • Standard Migration
  • Quick Migration
• Overview of Migration
  • How Migration Works
  • Migration Implemented as SQL Developer Extensions
• Preparing a Migration Plan
  • Task 1: Determining the Requirements of the Migration Project
  • Task 2: Estimating Workload
  • Task 3: Analyzing Operational Requirements
  • Task 4: Analyzing the Application
  • Task 5: Planning the Migration Project
• Before You Start Migrating: General Information
  • Creating a Database User for the Migration Repository
  • Requirements for Creating the Destination Oracle Objects
• Before You Start Migrating: Source-Specific Information
  • Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
  • Before Migrating From Microsoft Access
    • Creating Microsoft Access XML Files
  • Before Migrating From MySQL
• Capturing the Source Database
  • Online Capture
  • Offline Capture
• Creating and Customizing the Converted Model
  • Correcting Errors in the Converted Model
• Generating the DDL for the Oracle Schema Objects
• Migrating the Data
  • Transferring the Data Offline
    • Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
    • Creating Data Files From Microsoft Access
    • Creating Data Files From MySQL
    • Populating the Destination Database Using the Data Files
• Making Queries Case Insensitive
• Testing the Oracle Database
  • Testing Methodology
  • Testing the Oracle Database
    • Guidelines for Creating Tests
    • Example of a Unit Test Case
• Deploying the Oracle Database
  • Choosing a Rollout Strategy
    • Phased Approach
    • Big Bang Approach
    • Parallel Approach
  • Deploying the Destination Database
• Using Migration Reports
• SQL Developer User Interface for Migration
  • Migration Menu
  • Other Menus: Migration Items
  • Migration Preferences
  • Migration Log Panes
  • Using the Translation Scratch Editor

3 Tutorial: Creating Objects for a Small Database

• Create a Table (BOOKS)
• Create a Table (PATRONS)
• Create a Table (TRANSACTIONS)
• Create a Sequence
• Insert Data into the Tables
• Create a View
• Create a PL/SQL Procedure
• Debug a PL/SQL Procedure
• Use the SQL Worksheet for Queries
• Script for Creating and Using the Library Tutorial Objects

4 Dialog Boxes for Creating/Editing Objects

• Add Extension
• Branch/Tag
• Check for Updates
• Check Out from CVS
• Check Out from Subversion
• Choose Directory
• Confirm Drop Application
• Confirm Running SQL
• Connection Has Uncommitted Changes
• Create/Edit New Object (New Gallery)
• Create/Edit CVS Connection
• Create/Edit/Select Database Connection
• Rename Model (Migration)
• Rename Database Item (Migration)
• Select Connection
• Connection Information
• No Connection Found
• Connection Rename Error
• New Folder (Connections)
• Continue After Pause
• Select Library
• Create Library
• Import Data
• Export/Import Connection Descriptors
• Create/Edit Database Link
• Create/Edit Index
• Create Filter
• Create/Edit Materialized View Log
• Create PL/SQL Package
• Create PL/SQL Subprogram (Function or Procedure)
• Create Remote Directory
• Create/Edit Sequence
• Create SQL File
• Create/Edit Subversion Connection
• Create Subversion Repository
• Create/Edit Synonym
• Create Table (quick creation)
• Create/Edit Table (with advanced options)
• Storage Options
• Create Trigger
• Create Type (User-Defined)
• Create/Edit User
• Create/Edit User Defined Report
• Create/Edit User Defined Report Folder
• Create/Edit View
• Create XML Schema
• Configure Extension
• Configure File Type Associations
• Custom Filters
• Database Copy (Schema Objects)
• Database Schema Differences
• DDL Panel for Creating or Editing an Object
• Debugger - Attach to JPDA
• Deploy or Import Application
• Describe Object Window
• Edit Value (Table Column Data)
• Enter Bind Values
• Error Writing to Export File
• Export (Database Objects and Data)
• Export: Advanced Data Filter
• Export Error
• Export Table Data
• External Locator Configuration
• External Tools
• Create/Edit External Tool
• Choose Offline Options
• Feature Required
• Filter
• Insert Macro
• Externally Modified Files
• Filter Object Types
• Filter Schemas
• Filter Error
• Find/Replace Text
• Find Result
• Generate Oracle DDL
• Generate Offline Data Move Files
• Go to Bookmark
• Go to Line Number
• Go to Line Number: Error
• Import to CVS
• Load Preset Key Mappings
• Log In to CVS
• Modify Value
• Data Move Details
• New Procedure (Refactoring)
• No Object Found
• No Object Selected
• Open File
• Oracle-Only Report
• Oracle Proxy Authentication
• Paste
• Privilege Warning for Migration
• Query Builder
• Recent Files
• Create Repository
• Delete or Truncate Repository
• Capture Microsoft Access Exporter XML
• Rename Local Variable
• Rename Procedure
• Select Current Repository
• Cannot Capture Table
• Reset Expired Password
• Revision Lister
• Run/Debug/Profile PL/SQL
• Create/Edit Breakpoint
• Save/Save As
• Save Files
• Unable to Save Files
• Save Style Settings
• Schema Differences Source or Destination Error
• Script Execution Failed
• Script Generation Complete
• Set Data Mapping
• Add/Edit Rule
• Set Encoding
• Set Pause Continue
• Sign In (checking for updates)
• Single Record View
• Save Snippet (User-Defined)
• Edit Snippets (User-Defined)
• Unable to Open File
• Unsupported Database Version
• Windows

Index