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