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] > >
