import to postgresql from oracle dmp

#11

Uzytkownik "jerry gitomer" <jgitomer (AT) erols (DOT) com> napisal w wiadomosci
news:40f298fa$0$1166$61fed72c (AT) news (DOT) rcn.com...

Quote:

stic wrote:
[..]* cutted all this crap about installing Oracle, or some tools to pull

dump data...
where solutions go in direction of INSTALL ORACLE...

Quote:

And do it every time I need to do this (for example twice a day ?) ;-)

No, at least not with human intervention. Get whoever creates
the dump file to include a simple sql program that spools to a
flat file as part of the dump procedure.

I would like to, trust me.. I wolud, but this is impossible

Quote:

If they won't/can't do that for you write a script to import the
dump file into an Oracle database you control and then spool it
out to a flat file.

Ok, that is any idea, (and now I do it in this way).
btw. do you know case in which data to import are moved over network URI /
URL / UNC ??

Quote:

Then set up your script to load the flat file into your
PostgreSQL database.

;-)

Quote:

You can either trigger the script manually or, if the dump file
is created on a regular basis, set up a operating system chron
or at job to trigger your scripts.
HTH
Jerry

Thanks for your answer !
for everybody this is a great example, for me it is a hard dba life

--
best regards
stic

#12

"stic" <stefantura (AT) klub (DOT) chip.pl> wrote

Quote:

(Why do we human beings sometimes insist on doing things the hard way?
It's that hammer syndrom again)

And do it every time I need to do this (for example twice a day ?) ;-)

--
best regards
stic

Jerry Gitomer has already suggested you get your data feeder to provide
something more useable than an Oracle dmp format, especially if you don't
use Oracle at your shop.

It's very, very easy to create a script that will generate easily used
formats from Oracle tables. There used to be some public domain scripts
that would even generate the script automatically. They may still be around
FAIK.

The point is that a small amount of work at the source end, where the Oracle
database is, replaces a large amount of work at the destination end, where
you don't currently have any tools that can read the feed. This is often
the case.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import to postgresql from oracle dmp

comp.databases comp.databases

Re: import to postgresql from oracle dmp - 07-13-2004 , 01:25 AM

Re: import to postgresql from oracle dmp - 07-13-2004 , 12:39 PM