Hi,

Sorry, for this who actaly read comp.databases.oracle.tools, but I realy
need a help ;-)

My problem is:

I need to convert Oracle database from exp file to PostgreSQL database, so
what I do is to:
1) convert this dmp file to txt
2) import this file to PostgreSQL

1) I found a nice tool, nxtract,
(becouse I have only dmp file - a instance of Oracle was gone, and I con't
use imp), which extract data to txt files, from dmp. But this tool is
limited to 5000 rows, and I need more, for free ( not a new, doesn't it ? )

So whould somebody give me a direction to tool like nxtract, which could
read this oracle dmp files ?

2) Or there is direct way to import Oracle file to PostgreSQL ?

--
best regars
stic

Is your dmp very large (? Mb)...


"stic" <stefantura (AT) klub (DOT) chip.pl> a écrit dans le message de
news:cc0gjv$ogc$1 (AT) news (DOT) dialog.net.pl...

stic wrote:
Why not use an editor and create multiple 5000 record files
from your Oracle exp file?

If you are running on a Unix/Linux system you should be able
to use the split command.

HTH
Jerry

Uzytkownik "jerry gitomer" <jgitomer (AT) erols (DOT) com> napisal w wiadomosci
news:40e418bc$0$23312$61fed72c (AT) news (DOT) rcn.com...
Thanks for your answer, but there is a problem coused by exp file format,
all the table structures are at beginning, and there will be huge problems
with this split, for examlpe - I have no idea how to recognize where at this
exp file I'm during the nxtract tools work...

This solution is rather imposible

but as all of us know at IT the "imposible" word doesn't exist ;-)

--
best regards
stic

[..]

U¿ytkownik "Luc" <antispam (AT) sw (DOT) com> napisa³ w wiadomo¶ci
news:40e3ce6f$0$8393$a0ced6e1 (AT) news (DOT) skynet.be...
Rather yes, about 250-400MB
Why are you asking ?

--
best regards
stic

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

Why waste time on reading proprietary format files with third party
tools?

Get a developers copy of ORACLE (free), install it, import the dump
file, spool the tables to flat files. Load into PostgreSQL. Uninstall
ORACLE. Done.

HTH,
Ed

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

Uzytkownik "Ed prochak" <ed.prochak (AT) magicinterface (DOT) com> napisal w wiadomosci
news:4b5394b2.0407080732.649da9d5 (AT) posting (DOT) google.com...

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

--
best regards
stic

stic wrote:
the dump file to include a simple sql program that spools to a
flat file as part of the dump procedure.

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.

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

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

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

I'll stick to replying here, even though I've also replied to your
thread in the ORACLE group. (IOW, I'll stop replying on the ORACLE
group.) This may be of interest to others, So I'll keep this here.

If the ORACLE feed is twice a day, here are some possible solutions:

1. BUY an ORACLE license and chuck PostgreSQL. You may be surprised
that it is not as expensive as you might think. You have no need to
converting and you can read the dump file directly.

2. WHY use a ORACLE dump file? It's proprietary. It's binary (well the
ASCII representation of binary data). It's not loadable directly into
PostgreSQL. If they are sending you data twice a day, get them to send
another format. Do you have NO negotiating power in this relationship?
A flat file for each table. This should not be hard for an ORACLE DBA
to produce.

3. Get a SELECT only account from the ORACLE database and pull the
data in yourself via something else (SQL*Plus, PERL/DBI, JAVA/JDBC).

I hope this helps, if not you, then others.

have a great day.
Ed

Uzytkownik "Ed prochak" <ed.prochak (AT) magicinterface (DOT) com> napisal w wiadomosci
news:4b5394b2.0407121049.4c9cb66b (AT) posting (DOT) google.com...
That is not my firm, that is not my money, I *only* have to find solution...
Right now I'm testing this with Oracle - but as far as I know, there in no
why to put Oracle in this box forever..
Belive me, I'll happiest man on the whole world if I coudl do what you
say...

imposible - there is standard given over this data, that is is, and that it
will be.

no permisions to this db, at all.. even thought this dump have some data..

is a mess ;-)
Oracle dump and other systems seems to be impossible ...


stic