Merge table not usable
I have been trying to create this merge table since yesterday. It gets created but if I try to run some select statements on it, I always get this error:
Error Code : 1168
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
I am trying to merge 25 tables which follow this schema:
CREATE TABLE `fa_atlga` (
`DeedRecordID` int(11) NOT NULL,
`TaxRecordID` int(11) default NULL,
`CurrentDeedRecordID` int(11) default NULL,
`DateLoaded` datetime NOT NULL,
`RLVendorJobDate` date NOT NULL,
(tons more rows here)
`FIPS` int(9) default NULL,
PRIMARY KEY (`DeedRecordID`),
KEY `FIPS` (`FIPS`),
KEY `UNFORMATTEDAPN` (`UNFORMATTEDAPN`),
KEY `PROPERTYADDRESSZIPCODE` (`PROPERTYADDRESSZIPCODE`),
KEY `TransactionDate` (`TransactionDate`),
KEY `RECORDINGDATE` (`RECORDINGDATE`),
KEY `BATCH` (`BATCHID`,`BATCHSEQ`),
KEY `EXCLUDE` (`Exclude`),
KEY `LockedForPublication` (`LockedForPublication`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
The schema for the merge table is same as above except that Primary Key (DeedRecordID) became just Key(DeedRecordID) and ENGINE=MyISAM DEFAULT CHARSET=latin1 became ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(table_name, tablename).
I have triple checked and all the definitions are same across all tables as well as for the merge table.
Pleasd HELP!
Subject
Views
Written By
Posted
Merge table not usable
12646
May 03, 2007 01:45PM
7196
May 04, 2007 01:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.