Re: ERROR 1005 <errno: 150>
Posted by:
Mike Both
Date: April 16, 2005 02:59PM
For both Hugh and Angel - if you can't suss the problem from looking at your CREATE command one approach worth trying is a 'dumb' one that involves simplifying the statement as much as possible, even to the extent of trying a one-field CREATE firstly. Then, add one field / index / index relation at a time, each time trying the CREATE, and building up towards your 'full' CREATE statement. This often kicks loose the problem, and at the very least gives you confidence in what *is* correct while narrowing down where the problem might be.
Good luck .... let us know what you find!
Mike
Subject
Written By
Posted
Re: ERROR 1005 <errno: 150>
April 16, 2005 02:59PM
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.