migrating - index question

Hello,

        I am assisting in migrating a Database to Oracle7 and am having trouble with indexes. On page 4-160 of the Oracle7 Server, SQL language reference manual I noticed that the use of the qualifer 'Unique' is missing. Is this a documentation issue or must you use the the Primary Key construct to attain this? What if I have two unique keys; ie; Emp_id and SIN? The index I am trying to port is a UNIQUE DESC index. I also noted that on page 4-160 as noted above, that 'Desc' on the create index statement is allowed for syntax parsing only and does not create a descending index. What options do I have to migrate this schema to Oracle?

Tony Sukkel Received on Tue Oct 10 1995 - 00:00:00 CET