data migration from postgresql to Oracle 8i

Hi,

Has anybody converted from postgresql to Oracle 8i...
I have a table thats of around 10000 rows which i want to convert from postgresql to Oracle..
can somebody tell me how?

Thanks,
Pra4444
LVL 12
Pra4444Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
earth man2Connect With a Mentor Commented:
use pg_dump to create a file containing create table ... and insert into .. statements.

0
 
rjkimbleConnect With a Mentor Commented:
Use the command like this:

pg_dump --inserts --table=tablename --file=output.sql databasename

or something similar. You can add the --host and --username options if necessary.
0
All Courses

From novice to tech pro — start learning today.