Replicating KLP from Oracle to Postgres

Install Oracle XE as described in OracleAccess.

Create a tablespace for the KLP data

create tablespace klp datafile '/usr/lib/oracle/xe/oradata/XE/klp_00.dbf' size 2G autoextend on next 100M maxsize 4G;

Create a user to use that tablespace

create user klp identified by <password> default tablespace klp temporary tablespace temp;

Grant privileges to that user

grant create session, create table, create view, create procedure, create sequence, create type to klp;

Give rights to the tablespaces

grant unlimited tablespace to klp;

Import the dump using imp. Prior to importing drop/ truncate existing tables.

imp file=<file> full=yes touser=klp feedback=10000

Drop a bunch of tables that are not required

sqlplus @drop.sql (note: eg_school_classification should not be dropped, remove the line from this drop.sql before you run the script)

Useful Links


Last modified 7 years ago Last modified on 06/29/11 09:28:59

Attachments (2)

Download all attachments as: .zip