RE: Oracle .dmp to mySQL

2002-08-12 Thread Mike Townend
- 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 saves

RE: Oracle .dmp to mySQL

2002-08-12 Thread Weaver, Walt
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

RE: Oracle conversion...

2001-10-22 Thread Moshe Gurvich
select max(length(column)) from table -Original Message- From: Tony [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Oracle conversion... Is there a quick and easy way to determine the maximum used length of a varchar column? I've built

Re: Oracle conversion...

2001-10-22 Thread Tony
Many thanks. Worked fine. Sadly, almost every one of the varchar columns I checked return near the max length. Is there still a huge performance penalty, if most of the rows come close to hitting the max of the defined varchar length? I suppose it depends on your data, and how you use it.

RE: Oracle CONNECT BY

2001-09-25 Thread Remco Brood
This will get a manager of a team which contains a team which contains individual nr 5. SELECT I.Name FROM TEAMREPORT T3 TEAMREPORT T2 TEAMREPORT T, INDIVIDUAL I, WHERE T.individualId = 5 AND t.teamid = t2.indivdualID AND t3.IndividualId = t2.teamID AND T3.IndividualID = I.IndividualID AND

Re: Oracle 2 MySQL

2001-05-24 Thread Sinisa Milivojevic
technical Support writes: Hello, Does anyone know of any tool that will take an ORACLE database and port it to mySQL? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *

<    1   2