Table of Contents 1 Introduction 1.1 What’s New 1.2 Typographical Conventions Used in this Guide 1.3 Certified and Supported Product Versions 2 Migration Methodology 2.1 The Migration Process 2.2 Connecting an Application to Postgres 3 Functionality Overview 4 Installing Migration Toolkit 4.1 Using an RPM Package to Install Migration Toolkit 4.2 Using Stack Builder to Install Migration Toolkit 4.3 Installing Source-Specific Drivers 5 Building the toolkit.properties File 5.1 Defining an Advanced Server URL 5.2 Defining a PostgreSQL URL 5.3 Defining an Oracle URL 5.4 Defining a MySQL URL 5.5 Defining a Sybase URL 5.6 Defining a SQL Server URL 6 Executing Migration Toolkit 6.1 Migrating a Schema from Oracle 6.2 Migrating from a Non-Oracle Source Database 7 Migration Toolkit Command Options 7.1 Offline Migration 7.1.1 Executing Offline Migration Scripts 7.2 Import Options 7.3 Schema Creation Options 7.4 Schema Object Selection Options 7.5 Migration Options 7.6 Oracle Specific Options 7.7 Miscellaneous Options 7.8 Example 8 Migration Issues 8.1 Migration Toolkit Connection Errors 8.1.1 Invalid username/password 8.1.2 Connection rejected: FATAL: password 8.1.3 Exception: ORA-28000: the account is locked 8.1.4 Exception: oracle.jdbc.driver.OracleDriver 8.1.5 I/O exception: The Network Adapter could not establish the connection 8.1.6 Exception: The URL specified for the “target” database is invalid 8.2 Migration Toolkit Migration Errors 8.2.1 ERROR: Extra Data after last expected column 8.2.2 Error Loading Data into Table: TABLE_NAME 8.2.3 Error Creating Constraint CONS_NAME_FK 8.2.4 Error Loading Data into Table 8.2.5 ERROR: value too long for type 8.2.6 ERROR: Exception in thread:OutOfMemoryError 8.3 Unsupported Oracle Features 8.4 Unsupported Postgres Features 8.5 Frequently Asked Questions 9 Error Codes 9.1 Overview 9.2 Error Code Summary 9.2.1 Class 02 - Warning 9.2.2 Class 10 - Invalid User Input 9.2.3 Class 11 - Configuration Issues 9.2.4 Class 12 - Insufficient Privileges 9.2.5 Class 13 - Unsupported Features 9.2.6 Class 14 - Missing Objects 9.2.7 Class 15 - Schema Migration 9.2.8 Class 16 - Procedural Language Migration 9.2.9 Class 17 - Data Loading