By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Exporting data from postgresql to oracle

P: 1
Hi ,

Does anyone know how to Export the data from postgresql to oracle ??
Aug 7 '07 #1
Share this Question
Share on Google+
2 Replies

P: 8
load data
infile '/home/mike/pgsql/t_pr_npi.dat'
into table t_pr_npi
fields terminated by '|' optionally enclosed by '"'
trailing nullcols
dte_assign "decode(:dte_assign,null,'20990101',:dte_assig n)",
dte_end "decode(:dte_end,null,'20990101',:dte_end)",
nam_npi "decode(:nam_npi,null,'*',:nam_npi)",
ind_group "decode(:ind_group,null,'*',:ind_group)",
cde_npi_end_rsn "decode(:cde_npi_end_rsn,null,'*',:cde_npi_end_rsn )",
dte_added "decode(:dte_added,null,'20990101',:dte_added) ",
dte_last_update "decode(:dte_last_update,null,'20990101',:dte_last _update)"

Use the "Copy" comand from postgres to down load the data to a flat file and then use Oracle's "sqlldr" command to load the data. I've attached a sample of a Oracle loader control file. It may not be an all_in_one process, but it works. I'm sure someone out there has written a tool. If not put the commands in a unix/linux script and run it as one command.
Aug 9 '07 #2

P: 107
you can also use SQL server utility name DTS(data transfer service)
and using ODBC drivers u can create DSN from control panel

and then use DTS to tranfer data
Aug 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.