Quick Table of Contents

  1. Dump the database
  2. Fix the dump
  3. sqlplus
  4. User Management

Migrating from PostgreSQL

[top]

1. Dump the database 

pg_dump -d -O
    
  -d, --inserts            dump data as INSERT, rather than COPY, commands
  -O, --no-owner           skip restoration of object ownership
                           in plain text format
[top]

2. Fix the dump

Remove lines

Remove lines beginning with SET.

Remove lines beginning with COMMENT.

Remove CREATE FUNCTION lines.

Remove CREATE TRUSTED lines.

Fix syntax

Fix the create sequence syntax.

Fix datatypes

date columns, with and without timezones. You may also need to change the NLS_TIMESTAMP_FORMAT by adding

        alter session set NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF';

to your script. There is also a NLS_DATE_FORMAT

Change text columns to CLOBs.

Change bytea columns to BLOBs.

Change boolean columns to Integer 0,1

Fix object name lengths

Oracle's maximum is only 30 chars.

[top]

3. sqlplus

Starting sqlplus

Use the command line and type 'sqlplus user/passs'

or click on "Run SQL Command Line"

Commands

connect

connect <user>/<password>;

where <password> is your password and <user> is your username.

[top]

4. User Management

Start the HTML administration site. Go to Home -> Administration -> Manage Database Users -> Create Database User