I'm not sure how this happend but Mikel didn't write that. Could some one kindly
forward me the original for the snippet below, including the headers...?
Thanks,
Mikel
Ray Cote wrote:
> At 4:44 PM -0400 4/26/01, Mikel wrote:
> > > I'm trying to create a perl script that just produces a MySQL
At 4:44 PM -0400 4/26/01, Mikel wrote:
> > I'm trying to create a perl script that just produces a MySQL compliant
>> SQL file based on the tables from Oracle, but I can't get everything work,
>> like indexes etc..
Do you mean you cannot figure out how to find the index definitions from Oracle?
just curious but can't you do a SQL dump of oracle...and if so (since I'm not
up on it) whats' the correct syntax, especially from the command line...
Cheers,
Mikel
Johan Andersson wrote:
> Anybody tried this? and hopefully got some good ideas of how to do it
> properly?
>
> I'm trying to creat
Johan,
I'm working on something similar at the moment.
Attached at two files I downloaded from somewhere. If you import/attach
the
Oracle tables to an access database you could give them a try - I haven't
used them.
If you want a more complete solution, the Oracle views: USER_TABLES,
USER_TAB_CO