exp dmp converter to text file
stic
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
Ed prochak
2) get a developer copy of ORACLE, install it, import the dump, then
either
dump the data as text files (SPOOL, SELECT *) and load PostgreSQL
OR
transfer from ORACLE to PostgreSQL using something like an ODBC based
tool or PERL DBI.
Why bother with the hassle of reading a proprietary format? Use the
right tool. To real an ORACLE dump it seems to me, the right tool is
ORACLE.
HTH,
ed
That would be easier than trying to fiddle with pulling data directly
out of the dump file. As the nxtract tool shows, it can be done
Sybrand Bakker
wrote:
Toad will export to ascii files with insert commands.
IIRC this functionality is already present in the free version at
www.toadsoft.com
--
Sybrand Bakker, Senior Oracle DBA
stic
news:4b5394b2.04070...@posting.google.com...
> "stic" <stefa...@klub.chip.pl> wrote in message
news:<cc0gbf$obp$1...@news.dialog.net.pl>...
> > Hi,
> > 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
> > 2) Or there is direct way to import Oracle file to PostgreSQL ?
> 2) get a developer copy of ORACLE, install it, import the dump, then
> either
> dump the data as text files (SPOOL, SELECT *) and load PostgreSQL
> OR
> transfer from ORACLE to PostgreSQL using something like an ODBC based
> tool or PERL DBI.
> Why bother with the hassle of reading a proprietary format? Use the
> right tool. To real an ORACLE dump it seems to me, the right tool is
> ORACLE.
>
> HTH,
> ed
>
> That would be easier than trying to fiddle with pulling data directly
> out of the dump file. As the nxtract tool shows, it can be done
Hi,
What a nice answer, that is what I'm doing right now.. ;-) Couse I don't
find any other solution...
but I can't do it at business proces, where some licences are needed to
process this data...
I thought about Oracle Lite, but the exp / imp options doesn't seems to work
(or I did something wrong, and only on my linux instance these tools aren't
working ?)
--
best regards
stic
stic
wiadomosci news:3uqde09j3b7nd4mht...@4ax.com...
> On Thu, 1 Jul 2004 10:01:27 +0200, "stic" <stefa...@klub.chip.pl>
> wrote:
> >Hi,
> >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
> Toad will export to ascii files with insert commands.
> IIRC this functionality is already present in the free version at
> www.toadsoft.com
> --
> Sybrand Bakker, Senior Oracle DBA
Yes, that is the solution - for my ca.250MB file this work all night (with
these inserts) but IT WORKS ! ;-)
Now there is a question, is TOra supportiong this operation ?
Sorry for such a simple questions, but I have no xp with this software...
--
best regards
stic
Ed prochak
My impression was this was a one-time conversion. If this is going to
be an ongoing data feed from ORACLE to PostgreSQL, maybe you should
renegotiate the interface (have them send flat files instead of an
oracle dump). What business process requires using the ORACLE dump
format to feed a non-ORACLE DBMS?
> I thought about Oracle Lite, but the exp / imp options doesn't seems to work
> (or I did something wrong, and only on my linux instance these tools aren't
> working ?)
Isn't ORACLE Lite obsolete?
What version of ORACLE did the export come from? (conflict in versions
between the ORACLE dump system and Lite?)
If there is a business need for using the dump file format, then there
may be a case made to use ORACLE instead of PostgreSQL. Until you
contact ORACLE and get a price, you won't know how little that option
might cost. Seems like you keep looking for hack solutions instead of
engineered solutions.
My company was looking into replacing ORACLE on some systems with
MySQL. After checking the upgrade costs for another project, we found
the cost was about half the expected cost. MySQL is currently just
sitting there, a development, learning, and test tool. All production
DB work is in ORACLE.
So next time, tell us the full story of what you are trying to do and
why. Then we might have a better chance of answering your question on
the first try. Tool versions would help too.
HTH,
ed
anacedent
need to do any export by reading the data directly from Oracle
and inserting it into PostgreSQL.
stic
news:BrlHc.2682$ys.2457@fed1read03...
> stic wrote:
> > Uzytkownik "Sybrand Bakker" <gooid...@nospam.demon.nl> napisal w
> > wiadomosci news:3uqde09j3b7nd4mht...@4ax.com...
> >>On Thu, 1 Jul 2004 10:01:27 +0200, "stic" <stefa...@klub.chip.pl>
> >>wrote:
> >>>Hi,
> >>>I need to convert Oracle database from exp file to PostgreSQL database,
> >>>2) import this file to PostgreSQL
> >>>2) Or there is direct way to import Oracle file to PostgreSQL ?
> >>Toad will export to ascii files with insert commands.
> >>IIRC this functionality is already present in the free version at
> >>www.toadsoft.com
> >>--
> >>Sybrand Bakker, Senior Oracle DBA
> > Yes, that is the solution - for my ca.250MB file this work all night
(with
> > these inserts) but IT WORKS ! ;-)
> > Now there is a question, is TOra supportiong this operation ?
> > Sorry for such a simple questions, but I have no xp with this
software...
> > --
> > best regards
> > stic
> Alternatively throw together some PERL code which eliminates the
> need to do any export by reading the data directly from Oracle
> and inserting it into PostgreSQL.
I don't have any instance of Oracle (that is my first assume !!), if I have
one, there will be no problem to connect them or move data between them...
--
best regards
stic
stic
If I only could :(
There are some situaltion when you just couldn't put your penny to the
solution..
If it would depend from me I would rather go for Microsoft SQL no both
platform - it's maybe little toy, but nice one ;-)
> > I thought about Oracle Lite, but the exp / imp options doesn't seems to
work
> > (or I did something wrong, and only on my linux instance these tools
aren't
> > working ?)
> Isn't ORACLE Lite obsolete?
Yes it is... I recognize this after 5 hour installation and a day of hard
work to make it working..
As a M$ developer, now I understood why Oracle folks earn x 4 more that me
;-)
> What version of ORACLE did the export come from? (conflict in versions
> between the ORACLE dump system and Lite?)
No, the Lite seems to don't have imp/exp tools just like that ...
Somebody correct me if I'm wrong
> If there is a business need for using the dump file format, then there
> may be a case made to use ORACLE instead of PostgreSQL. Until you
> contact ORACLE and get a price, you won't know how little that option
> might cost. Seems like you keep looking for hack solutions instead of
> engineered solutions.
> My company was looking into replacing ORACLE on some systems with
> MySQL. After checking the upgrade costs for another project, we found
> the cost was about half the expected cost. MySQL is currently just
> sitting there, a development, learning, and test tool. All production
> DB work is in ORACLE.
I'm only contract to this job... And this have to be done in this
configuration :(
> So next time, tell us the full story of what you are trying to do and
> why. Then we might have a better chance of answering your question on
> the first try. Tool versions would help too.
Yeap, that is a solution to all communication problems ...
But you know, when you dig something really deep and need a solution there
your world of problem isn't so readable to others...
--
best regards
stic
