Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1410 Silliness
Very straight forward..... and LONG ..... (Yea, I read to your last
message).
Could that be the issue here ?? Is the record too long or some buffer being overwritten in Oracle when there is so long of record and so much data ?? Have you tried (or do you already) commit after each insert from the RAW table ?? I know that you would not think this could help , but buffers and such might get cleared on the commit ..... just a thought anyway.
-----Original Message-----
Sent: Tuesday, December 31, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't given a chance to improve on it. It is basically a mainframe file that I have stored history of.
SQL> desc vegas_mart
Name Null? Type ----------------------------- -------- ------------------ ID NOT NULL NUMBER(38) CONTRACT_NUMBER NOT NULL NUMBER(9) LOAD_JOB_ID NOT NULL NUMBER(12) JULIAN_RUN_DATE NOT NULL NUMBER(12) FAC_CODE VARCHAR2(1) OWNER_LAST_NAME VARCHAR2(20) OWNER_FIRST_NAME VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY VARCHAR2(18) OWNER_STATE VARCHAR2(2) OWNER_ZIP VARCHAR2(9) NET_PURCHASE_PRICE NUMBER(11,2) ORIGINAL_DOWN_PAYMENT NUMBER(11,2) TOTAL_DOWN_PAYMENT NUMBER(11,2) CR_BAL NUMBER(11,2) INTEREST_RATE NUMBER(5,2) FIRST_PAYMENT_DATE DATE QUALIFICATION_CODE VARCHAR2(1) PAYMENT_AMOUNT NUMBER(9,2) PAYMENT_FREQUENCY VARCHAR2(1) AGING_10_TO_30_DAYS_DUE NUMBER(9,2) AGING_31_TO_60_DAYS_DUE NUMBER(9,2) AGING_61_TO_90_DAYS_DUE NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP VARCHAR2(2) DATE_OF_SALE DATE STATUS_OF_ACCOUNT VARCHAR2(1) CONTRACT_TYPE VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT VARCHAR2(1) DOCUMENT_STATUS_CODE VARCHAR2(1) FIXED_WEEK_SALE VARCHAR2(1) UDI_SALE VARCHAR2(1) PHASE_NUMBER VARCHAR2(6) FAIRSHARE_PLUS_MEMBER VARCHAR2(1) POINTS_OWNED NUMBER(7) DEED_DATE DATE PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1) RESERVATION_CODE VARCHAR2(4) INTERNATIONAL_CODE VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE VARCHAR2(1) AGING_0_TO_90_DAYS_DUE NUMBER(9,2) AGING_91_TO_120_DAYS_DUE NUMBER(9,2) AGING_121_TO_150_DAYS_DUE NUMBER(9,2) AGING_151_OVER NUMBER(9,2) LOT_LOCATION VARCHAR2(12) PAYMENTS_MADE NUMBER(3) SUPPRESSION_CODE VARCHAR2(1) ACCRUED_INTEREST_BAL NUMBER(9,2) PAC_FREEZE_CODE VARCHAR2(1) CREDIT_CARD_FREEZE_CODE VARCHAR2(1) ASSOCIATION_NUMBER VARCHAR2(4) RFS_ASSIGNMENT_DATE DATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDING VARCHAR2(1) CREDIT_REPORTING_CODE VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE VARCHAR2(2) EQUITY_IN NUMBER(9,2) DATE_CODED_7 DATE ADJUSTABLE_RATE_MORTGAGE VARCHAR2(1) NUMBER_OF_PAYS_LEFT NUMBER(4) DEFERRED_INTEREST NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTS NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS NUMBER(5) LAST_PAYMENT_DATE DATE NEXT_PAYMENT_DATE DATE PAC_DUE_DATE DATE EFT_ROUTING_NUMBER VARCHAR2(8) EFT_ACCOUNT_NUMBER VARCHAR2(30) EFT_MANUAL_NUMBER VARCHAR2(30) BANK VARCHAR2(35) STATUS_CHANGE_DATE DATE ASSIGNED_LOAN_REP VARCHAR2(2) CREDIT_CARD_PAC_ACCOUNT VARCHAR2(20) PRINCIPAL_BALANCE NUMBER(11,2) CR_DISCOUNT_BALANCE NUMBER(11,2) CREDIT_LIFE_PREM_BAL NUMBER(11,2) RFP_PAC_CODE VARCHAR2(1) RFP_DRAFT_CODE VARCHAR2(1) RFP_ROUTE_NUMBER VARCHAR2(8) RFP_EFT_NUMBER VARCHAR2(30) RFP_MANUAL_NUMBER VARCHAR2(30) RFP_BANK_NAME VARCHAR2(35) FPPA_PAC_CODE VARCHAR2(1) FPPA_DRAFT_CODE VARCHAR2(1) FPPA_ROUTE_NUMBER VARCHAR2(8) FPPA_EFT_NUMBER VARCHAR2(30) FPPA_MANUAL_NUMBER VARCHAR2(30) FPPA_BANK_NAME VARCHAR2(35) TS_BAL_DUE_RECOGNIZED NUMBER(9) TS_LATE_FEE_RECOGNIZED NUMBER(9,2) TS_YTD_MAINT_FEE_COLL NUMBER(9,2) TS_MAINT_FEE_AMOUNT NUMBER(9,2) PO_BIRTH_DATE DATE TS_LOCATION VARCHAR2(12) CR_DATE_REC_IN_DEEDING DATE CR_REFUND VARCHAR2(11) CR_CREDIT_LIFE_TYPE VARCHAR2(1) CR_QUALIFICATION_DATE DATE CR_EQT_IN_FROM_CONT_NO1 VARCHAR2(9) CR_EQT_IN_FROM_CONT_NO2 VARCHAR2(9) CR_HC_AMT1 NUMBER(9) CR_HC_AMT2 NUMBER(9) CR_HC_POST1 NUMBER(9) CR_HC_POST2 NUMBER(9) CR_HC_DATE1 DATE CR_HC_DATE2 DATE CR_DATE_IN_LR DATE CR_TRADE_ALLOW NUMBER(9) CR_TITLE_INS_CHARGED NUMBER(11) CR_TITLE_INS_COLLECTED NUMBER(11) CR_FILING_FEE_CHARGED NUMBER(11) CR_FILING_FEE_COLLECTED NUMBER(11) CR_ACCRUED_INT_BAL_RSV NUMBER(11) CR_LATE_FEE_BAL_RSV NUMBER(11) AREA_CODE VARCHAR2(3) PHONE_NUMBER VARCHAR2(7) PAID_OFF VARCHAR2(1) EDIT_DATE_TIME DATE BIANNUAL_FLAG VARCHAR2(10) FICO_SCORE NUMBER(3) SOCIAL_SECURITY_NUMBER NUMBER(9)
SQL> Here's the code. Line 1970 is cr_hc_amt2.
Makes no sense at all. And if you read this far, don't say I didn't warn you.
-----Original Message-----
Sent: Tuesday, December 31, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
How about posting the table structure and the lines around 1970 in the Elvis package.
-----Original Message-----
Sent: Tuesday, December 31, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
Nope... nothing named rowid.
-----Original Message-----
Sent: Tuesday, December 31, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L
Is there a column with a datatype of rowid?
-----Original Message-----
Sent: Tuesday, December 31, 2002 6:44 AM
To: Multiple recipients of list ORACLE-L
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:
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: kgel_at_ppoone.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Tue Dec 31 2002 - 12:43:51 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).