Oracle Sequence issue
674535Jul 13 2009 — edited Jul 13 2009I have recently built a new database in Oracle 10g and when I import the database from Oracle 8i I am having problems with one of my applications because of sequences. The sequences are identical in oracle 10g as they were in Oracle 8i. The sequences are using the noorder parm set to N.
Is there any difference in the way Oracle 10g uses sequences as it did in Oracle 8i? I am getting am error with the index due to unique constraint error, key violation.
If anyone has any suggestions or help i would really appreciate it.
Chicago