Oops, I stand corrected.
-Sheeri
On 10/25/05, Jason Martin [EMAIL PROTECTED] wrote:
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The
that looks like a spool file from sqlplus. does it have the data too or just
a bunch of describes?
if this is what he gave you he is either severly clue-challenged or trying
to sabotage you (my $ on later though they're not mutually exclusive).
you could write a perl program to parse this into
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
have fun tools like AUTOINCREMENT -- you're going to want to know what
the code is for any triggers on the data, because in order to do
AUTOINCREMENT in oracle
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The oracle-supplied DBMS_METADATA package can do this for you.
-Jason Martin
--
Silence is
Hi Mike,
I am not sure, but as I remember Microsoft SQLServer has Import/Export
utility (standard installation) that can import data from different sources
(Oracle?! why not).
Best regards,
Mikhail.
- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I think it will be very difficult to do. In Oracle export files the data is
written in Oracle's own proprietary binary format. I don't know of any tools
other than Oracle's own import utility that is able to read the .dmp file.
You may need to get them to send you a .csv file instead.
--Walt
To: Mike Townend; [EMAIL PROTECTED]
Subject: Re: Oracle .dmp to mySQL
Hi Mike,
I am not sure, but as I remember Microsoft SQLServer has Import/Export
utility (standard installation) that can import data from different
sources (Oracle?! why not).
Best regards,
Mikhail.
- Original Message
-
Sent: Monday, August 12, 2002 1:06 PM
Hope this helps you out a little on your conversion.
Serge.
- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 9:29 AM
Subject: RE: Oracle .dmp to mySQL
We don't have access
-
From: Tim Johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 18:11
To: [EMAIL PROTECTED]
Subject: RE: Oracle .dmp to mySQL
There is a application out there that does this called SQLPorter made by
Real Soft Studio (http://www.realsoftstudio.com). It might be worth the
$$ if it saves
To: [EMAIL PROTECTED]
Subject: RE: Oracle .dmp to mySQL
Except I don't have any access whatsoever to the Oracle server... All I
have is a flat dmp file on a CD which has all the data embedded into
this file...
I have found a tool that will extract the table structure from this
file
10 matches
Mail list logo