Actually if you had a clone of your SA, you might have twice as many problems.....
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
If I had a Raelian clone for a sysadmin I would have less problems than I do now.� GRRRRRRR
-----Original Message-----
From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]
Elvis? No way.� It's got to be a Raelian clone.
�
Ken Janusz
----- Original Message -----
From: Farnsworth, Dave <mailto:[EMAIL PROTECTED]>
Sounds like another Elvis sighting!!
-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Hello all,
8.1.7, Windows 2000 SP2
Here's the error:
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970
ORA-01410: invalid ROWID
ORA-06512: at line 1
Has anyone seen this error before?� I run into this error periodically during data loads.� I have done the following to search for the root of the problem:
1.� No code references ROWID.� Deletes are never applied to this table.
2.� No inline views in any of the code.
3.� Ran dbv on all datafiles while database was down.� No problems identified.
4.� Ran analyze table <table name> validate structure cascade on all recent partitions.� No rows found in INVALID_ROWS table.
5.� Was able to export the entire table without any problem.
I can't easily drop the indexes and recreate them.� This is a very large table - ~25GB, 38 million rows.� I also can't easily export/drop/recreate/import.
Usually when this happens I can re-fire the load and it will complete, no problem.� It's a big annoyance and it seems like every time I take a day off it happens.�
Any ideas, suggestions, or thoughts are appreciated.� Thanks everyone.
Lisa Koivu
Oracle Dorkbase Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA� 33063
