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'
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
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
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 so
42 AM
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..
ssage-
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
-
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
pe 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 to the Oracle se
2 14:17
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.
- Origin
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 Wea
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]>
Se
11 matches
Mail list logo
