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 you use a trigger.
So I think you're stuck on the Oracle DDL -> MySQL DDL. Ask your Oracle DBA to give you a sample of the data, too (is it just a comma-separated, enclosed-by-something file? It's not likely going to be a series of INSERT statements, like mysqldump gives), AND the full code of all the triggers. -Sheeri On 10/25/05, Sid Lane <[EMAIL PROTECTED]> wrote: > 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 something intelligable (to > mysql) but it would be a fair amount of work. > > On 10/25/05, Cummings, Shawn (GNAPs) <[EMAIL PROTECTED]> wrote: > > > > > > 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 Null? Type > > ----------------------------------------- -------- > > ---------------------------- > > CCS_UNITID NOT NULL CHAR(7) > > DIS_POSI_TION NOT NULL CHAR(3) > > OPC CHAR(11) > > CIRCUIT_ID_CODE NUMBER > > > > etc.. etc.. etc.. > > > > Does mysql have a way to import these Oracle dumps easily?? > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
