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
1.1
Installing and Getting Started with SQL Developer
1.2
SQL Developer User Interface
1.2.1
Menus for SQL Developer
1.3
Database Objects
1.3.1
Applications (Application Express 3.0.1 and Later)
1.3.2
Database Links (Public and Private)
1.3.3
Directories
1.3.4
Functions
1.3.5
Indexes
1.3.6
Materialized Views
1.3.7
Materialized View Logs
1.3.8
Packages
1.3.9
Procedures
1.3.10
Recycle Bin
1.3.11
Sequences
1.3.12
Synonyms (Public and Private)
1.3.13
Tables
1.3.14
Triggers
1.3.15
Types
1.3.16
Users (Other Users)
1.3.17
Views
1.3.18
XML Schemas
1.3.19
Captured and Converted Database Objects (for Migration)
1.4
Database Connections
1.5
Entering and Modifying Data
1.6
Running and Debugging Functions and Procedures
1.6.1
Remote Debugging
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.8
Using SQL*Plus
1.9
Using Snippets to Insert Code Fragments
1.9.1
User-Defined Snippets
1.10
Using DB Object Search to Find Database Objects
1.11
SQL Developer Reports
1.11.1
About Your Database reports
1.11.2
All Objects reports
1.11.3
Application Express reports
1.11.4
Database Administration reports
1.11.5
Data Dictionary reports
1.11.6
Jobs reports
1.11.7
PL/SQL reports
1.11.8
Security reports
1.11.9
Streams reports
1.11.10
Table reports
1.11.11
XML reports
1.11.12
Shared reports
1.11.13
User Defined reports
1.11.13.1
User-Defined Report Example: Chart
1.11.13.2
User-Defined Report Example: Dynamic HTML
1.12
SQL Developer Preferences
1.12.1
Environment
1.12.2
Accelerators (Keyboard Shortcuts)
1.12.3
Code Editor
1.12.4
Database
1.12.5
Debugger
1.12.6
Documentation
1.12.7
Extensions
1.12.8
File Types
1.12.9
Migration
1.12.10
PL/SQL Compiler
1.12.11
PL/SQL Debugger
1.12.12
SQL*Plus
1.12.13
SQL Formatter
1.12.14
Web Browser and Proxy
1.13
Location of User-Related Information
1.14
Using the Help
1.15
For More Information
2
Migrating Third-Party Databases
2.1
Migration Quick Start
2.1.1
Performing the Remaining Migration Actions Manually
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
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
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
Testing the Oracle Database
2.10.1
Testing Methodology
2.10.2
Testing the Oracle Database
2.10.2.1
Guidelines for Creating Tests
2.10.2.2
Example of a Unit Test Case
2.11
Deploying the Oracle Database
2.11.1
Choosing a Rollout Strategy
2.11.1.1
Phased Approach
2.11.1.2
Big Bang Approach
2.11.1.3
Parallel Approach
2.11.2
Deploying the Destination Database
2.12
Using Migration Reports
2.13
SQL Developer User Interface for Migration
2.13.1
Migration Menu
2.13.2
Other Menus: Migration Items
2.13.3
Migration Preferences
2.13.4
Migration Log Panes
2.13.5
Using the Translation Scratch Editor
3
Tutorial: Creating Objects for a Small Database
3.1
Creating a Table (BOOKS)
3.2
Creating a Table (PATRONS)
3.3
Creating a Table (TRANSACTIONS)
3.4
Creating a Sequence
3.5
Creating a View
3.6
Creating a PL/SQL Procedure
3.7
Debugging a PL/SQL Procedure
3.8
Using the SQL Worksheet for Queries
3.9
Script for Creating and Using the Library Tutorial Objects
4
Dialog Boxes for Creating/Editing Objects
4.1
Add Extension
4.2
Check for Updates
4.3
Choose Directory
4.4
Create/Edit New Object
4.5
Create/Edit/Select Database Connection
4.6
Rename Connection (Migration)
4.7
Select Connection
4.8
Connection Information
4.9
No Connection Found
4.10
Connection Rename Error
4.11
Continue After Pause
4.12
Copy Oracle Schema
4.13
Select Library
4.14
Create Library
4.15
Excel Import Data
4.16
Export/Import Connection Descriptors
4.17
Create/Edit Database Link
4.18
Create/Edit Index
4.19
Create/Edit Materialized View Log
4.20
Create PL/SQL Package
4.21
Create PL/SQL Subprogram (Function or Procedure)
4.22
Create/Edit Sequence
4.23
Create SQL File
4.24
Create/Edit Synonym
4.25
Create Table (quick creation)
4.26
Create/Edit Table (with advanced options)
4.27
Create Trigger
4.28
Create Type (User-Defined)
4.29
Create/Edit User
4.30
Create/Edit User Defined Report
4.31
Create/Edit User Defined Report Folder
4.32
Create/Edit View
4.33
Create XML Schema
4.34
Configure File Type Associations
4.35
DDL Panel for Creating or Editing an Object
4.36
Debugger - Attach to JPDA
4.37
Describe Object Window
4.38
Edit Value (Table Column Data)
4.39
Enter Bind Values
4.40
Export (Database Objects and Data)
4.41
Export: Advanced Data Filter
4.42
Export Error
4.43
Export Table Data
4.44
External Tools
4.45
Create/Edit External Tool
4.46
Choose Offline Options
4.47
Filter
4.48
Insert Macro
4.49
Externally Modified Files
4.50
Filter Object Types
4.51
Filter Schemas
4.52
Filter Error
4.53
Find/Replace Text
4.54
Generate Oracle DDL
4.55
Generate Offline Data Move Files
4.56
Go to Line Number
4.57
Go to Line Number: Error
4.58
Load Preset Key Mappings
4.59
Modify Access Database
4.60
Modify Value
4.61
Data Move Details
4.62
No Object Found
4.63
Open File
4.64
Oracle-Only Report
4.65
Paste
4.66
Privilege Warning for Migration
4.67
Query Builder
4.68
Recent Files
4.69
Create Repository
4.70
Delete or Truncate Repository
4.71
Capture Microsoft Access Exporter XML
4.72
Rename Procedure
4.73
Select Current Repository
4.74
Cannot Capture Table
4.75
Run/Debug PL/SQL
4.76
Create/Edit Breakpoint
4.77
Save/Save As
4.78
Save Files
4.79
Unable to Save Files
4.80
Save Style Settings
4.81
Schema Differences
4.82
Schema Differences Source or Destination Error
4.83
Script Generation Complete
4.84
Set Data Mapping
4.85
Add/Edit Rule
4.86
Set Pause Continue
4.87
Sign In (checking for updates)
4.88
Single Record View
4.89
Save Snippet (User-Defined)
4.90
Edit Snippets (User-Defined)
4.91
SQL History List
4.92
SQL*Plus Location
4.93
Unable to Open File
4.94
Unsupported Database Version
Index
Scripting on this page enhances content navigation, but does not change the content in any way.