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
I have some data that has been "dumped" from Oracle into what appears to
be a proprietary text file... It is not delimited into a format that I
can just import into mysql (easily). The IT guy has provided me an
outline of the "dump"..
ie;
SQL> describe isup051024;
Name
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
nstead.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 7:10 AM
To: [EMAIL PROTECTED]
Subject: Oracle .dmp to mySQL
Hi all,
We have just recently inherited a web project from another company who's
DB
lt;[EMAIL PROTECTED]>
Sent: Monday, August 12, 2002 3:09 PM
Subject: Oracle .dmp to mySQL
> Hi all,
>
> We have just recently inherited a web project from another company who's
> DB was Oracle 8. And as such they have provided us with an exported .dmp
> file of the database th
Hi all,
We have just recently inherited a web project from another company who's
DB was Oracle 8. And as such they have provided us with an exported .dmp
file of the database they were using...
We are using mySQL as our DB backend... Does anyone know of any tools
that will allow me to import t
13 matches
Mail list logo