08-17-04, 20:00 #1Registered User
- Join Date
- Aug 2004
Unanswered: Converting indexed Oracle table to MySQL
This is my first posting so if I miss any relevant info please just ask for more detail.
I am converting an Oracle 8i db to MySQL. The problem I am having is that the oracle db used indexed tables e.g.
create table genre (
id numeric primary key,
From what I have read of Oracle this is an Index Organized Table, which I have never heard of before. I read a little on the Oracle web site but not being a db admin there was much I didn't understand.
I want to transpose this to a MySQL db but am unsure how to index the tables in the way specified in the Oracle db table.
08-17-04, 20:07 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>Index Organized Table
AFAIK, MySQL does not have any similar construct as Oracle IOT.
An IOT is an object where the "table" and the "index" are the same single object.
Another way of viewing an IOT is where all the columns in the table comprise the index. Now since nothing is gained by having the table, the IOT is just the index with no underlying table.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.