ORACLE 9.2.0.2
We are thinking about switching to this version on windows OS. We use: Rman Advance replication OID Partitioning Bit map indexes Any pro / cons about this version? The other option is 9.2.0.1. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
[no subject]
Hi Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on whichversion. Sunil AroraSunil AroraVichara TechnologiesDo you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: Tales Of Big Hammer #10046 (AKA event 10046)
Brings to mind some of the great hammer quotes: When all you have is a hammer, everything tends to look like a nail When all you have is a hammer, maybe brain surgery is not for you :-) Connor --- Tim Gorman [EMAIL PROTECTED] wrote: Tales Of Big Hammer #10046 (AKA event 10046)Generally you won't find err=1403 text in the raw .trc file. Instead, if you carefully examine the FETCH lines, you'll see r=0 (i.e. zero rows returned) in amongst all the other statistics. Very very difficult to catch and often requires a Vulcan mind-meld to the application over several hours of careful perusal (something best left to Vulcans)... Great job! - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 30, 2002 10:43 AM Subject: Tales Of Big Hammer #10046 (AKA event 10046) On Friday our application support person called me and said User is getting a ORA-1403 error in one form. I should mention that this is complex. And I need a solution immediately. So, I gave them the hammer (with the sql string to put in pre-form trigger in the form for the 546th time, they never save their emails, especially from a DBA). They set the event and ran the form. Now the entire support group recently had to face me for an hour-long discussion on TKPROF (AKA the Hammer) and debugging techniques, so they read the tracefile and obediently tried to find a line with 'ERR=1043' but couldn't find any. So I looked at the trace file, and sure it was, it didn't show the error, but after one SQL it showed a 'SQL*Net break/reset to client' event followed by a ROLLBACK. I directed them to that statement. This person was happy that they found the culprit statement, but couldn't find what was going wrong. So they went through the presentation notes and used dbms_support.start_trace(true,true); statement and ran the form again. This time, as the trace dumped the bind values, they found the set of values on which the query returned 1403, and got back to the developer with a solid case. So, once again ... if you have 10046 hammer, most problems are like nails. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Tales Of Big Hammer #10046 (AKA event 10046)
Title: Tales Of Big Hammer #10046 (AKA event 10046) Tim, I don't see that ... I know this sql caused the problem ... === PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44 tim=1016624815165467 hv=2089161539 ad='24ba3ad8'SELECT b.pr_mobility_code FROM prp_requests b, prp_sr_cal_pps a WHERE b.pr_req_unit_id = :b3 AND b.pr_gr_id = a.pscp_id AND a.pscp_prp_id = :b2 AND a.pscp_prp_version = :b1END OF STMTPARSE #54:c=0,e=1192,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1016624815165463BINDS #54:bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=72 offset=0 bfp=11054edb0 bln=22 avl=05 flg=05 value=9044628bind 1: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=24 bfp=11054edc8 bln=22 avl=04 flg=01 value=586823bind 2: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=48 bfp=11054ede0 bln=22 avl=02 flg=01 value=2EXEC #54:c=0,e=1681,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1016624815167288WAIT #54: nam='global cache cr request' ela= 417 p1=32 p2=500383 p3=504403158449678016WAIT #54: nam='db file sequential read' ela= 2816 p1=32 p2=500383 p3=1WAIT #54: nam='global cache cr request' ela= 445 p1=33 p2=517103 p3=504403158399168096WAIT #54: nam='db file sequential read' ela= 1858 p1=33 p2=517103 p3=1WAIT #54: nam='db file sequential read' ela= 781221 p1=31 p2=1251231 p3=1FETCH #54:c=0,e=787456,p=3,cr=17,cu=0,mis=0,r=1,dep=1,og=4,tim=1016624815954763WAIT #0: nam='SQL*Net break/reset to client' ela= 57 p1=675562835 p2=1 p3=0WAIT #0: nam='SQL*Net break/reset to client' ela= 630 p1=675562835 p2=0 p3=0WAIT #0: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0*** 2002-12-27 16:17:21.846WAIT #0: nam='SQL*Net message from client' ela= 29596938 p1=675562835 p2=1 p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845553757 hv=1226881397 ad='24f0b6b8'ROLLBACKEND OF STMTPARSE #45:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1016624845553752XCTEND rlbk=1, rd_only=1EXEC #45:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845553883WAIT #45: nam='SQL*Net message to client' ela= 3 p1=675562835 p2=1 p3=0WAIT #45: nam='SQL*Net message from client' ela= 13212 p1=675562835 p2=1 p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845567343 hv=1226881397 ad='24f0b6b8'ROLLBACKEND OF STMTPARSE #45:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567339XCTEND rlbk=1, rd_only=1EXEC #45:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567450WAIT #45: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0WAIT #45: nam='SQL*Net message from client' ela= 6733 p1=675562835 p2=1 p3=0STAT #43 id=1 cnt=1 pid=0 pos=1 obj=29433 op='TABLE ACCESS BY INDEX ROWID SELLING_ROTATIONS (cr=3 r=1 w=0 time=14786 us)'STAT #43 id=2 cnt=1 pid=1 pos=1 obj=422698 op='INDEX UNIQUE SCAN SR_PK_PRIM (cr=2 r=0 w=0 time=27 us)' Thanks for the explanation ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Monday, December 30, 2002 7:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Tales Of Big Hammer #10046 (AKA event 10046) Generally you won't find "err=1403" text in the raw ".trc" file. Instead, if you carefully examine the FETCH lines, you'll see "r=0" (i.e. zero rows returned) in amongst all the other statistics. Very very difficult to catch and often requires a Vulcan mind-meld to the application over several hours of careful perusal(something best left to Vulcans)... Great job! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Different Oracle clients give different results
Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Tales Of Big Hammer #10046 (AKA event 10046)
Title: Tales Of Big Hammer #10046 (AKA event 10046) Raj, Thanks for sharing this with us. In your original post you mentioned that you saw a "rollback" right after the "SQL*Net break/reset to client" and that was how you figured out the 1403 error. I don't see that in this excerpt from the raw trace file, though. How did you determine it was this particulat SQL? Also the FETCH#54 line you have highlighted has r=1, not r=0; what's special about that line? Thanks in advance. Arup - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 7:58 AM Subject: RE: Tales Of Big Hammer #10046 (AKA event 10046) Tim, I don't see that ... I know this sql caused the problem ... === PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44 tim=1016624815165467 hv=2089161539 ad='24ba3ad8'SELECT b.pr_mobility_code FROM prp_requests b, prp_sr_cal_pps a WHERE b.pr_req_unit_id = :b3 AND b.pr_gr_id = a.pscp_id AND a.pscp_prp_id = :b2 AND a.pscp_prp_version = :b1END OF STMTPARSE #54:c=0,e=1192,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1016624815165463BINDS #54:bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=72 offset=0 bfp=11054edb0 bln=22 avl=05 flg=05 value=9044628bind 1: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=24 bfp=11054edc8 bln=22 avl=04 flg=01 value=586823bind 2: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=48 bfp=11054ede0 bln=22 avl=02 flg=01 value=2EXEC #54:c=0,e=1681,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1016624815167288WAIT #54: nam='global cache cr request' ela= 417 p1=32 p2=500383 p3=504403158449678016WAIT #54: nam='db file sequential read' ela= 2816 p1=32 p2=500383 p3=1WAIT #54: nam='global cache cr request' ela= 445 p1=33 p2=517103 p3=504403158399168096WAIT #54: nam='db file sequential read' ela= 1858 p1=33 p2=517103 p3=1WAIT #54: nam='db file sequential read' ela= 781221 p1=31 p2=1251231 p3=1FETCH #54:c=0,e=787456,p=3,cr=17,cu=0,mis=0,r=1,dep=1,og=4,tim=1016624815954763WAIT #0: nam='SQL*Net break/reset to client' ela= 57 p1=675562835 p2=1 p3=0WAIT #0: nam='SQL*Net break/reset to client' ela= 630 p1=675562835 p2=0 p3=0WAIT #0: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0*** 2002-12-27 16:17:21.846WAIT #0: nam='SQL*Net message from client' ela= 29596938 p1=675562835 p2=1 p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845553757 hv=1226881397 ad='24f0b6b8'ROLLBACKEND OF STMTPARSE #45:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1016624845553752XCTEND rlbk=1, rd_only=1EXEC #45:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845553883WAIT #45: nam='SQL*Net message to client' ela= 3 p1=675562835 p2=1 p3=0WAIT #45: nam='SQL*Net message from client' ela= 13212 p1=675562835 p2=1 p3=0=PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845567343 hv=1226881397 ad='24f0b6b8'ROLLBACKEND OF STMTPARSE #45:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567339XCTEND rlbk=1, rd_only=1EXEC #45:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1016624845567450WAIT #45: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0WAIT #45: nam='SQL*Net message from client' ela= 6733 p1=675562835 p2=1 p3=0STAT #43 id=1 cnt=1 pid=0 pos=1 obj=29433 op='TABLE ACCESS BY INDEX ROWID SELLING_ROTATIONS (cr=3 r=1 w=0 time=14786 us)'STAT #43 id=2 cnt=1 pid=1 pos=1 obj=422698 op='INDEX UNIQUE SCAN SR_PK_PRIM (cr=2 r=0 w=0 time=27 us)' Thanks for the explanation ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Monday, December 30, 2002 7:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Tales Of Big Hammer #10046 (AKA event 10046) Generally you won't find "err=1403" text in the raw ".trc" file. Instead, if you carefully examine the FETCH lines, you'll see "r=0" (i.e. zero rows returned) in amongst all the other statistics. Very very difficult to catch and often requires a Vulcan mind-meld to the application over several hours of careful perusal(something best left to Vulcans)... Great job!
ORA-1410 Silliness
Title: ORA-1410 Silliness 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
RE: Tales Of Big Hammer #10046 (AKA event 10046)
Title: Tales Of Big Hammer #10046 (AKA event 10046) Arup, Since I didn't see a line reporting error 1403, I was puzzled for a bit. But here is the application knowledge came handy. I should have see a commit for a successful operation. I didn't and instead saw a ROLLBACK. Immediately before the rollback I also saw a 'SQLNet Break' event so I put 2 and 2 togather and concluded that this caused the problem. when I looked up the code, this was a implicit cursor, so it basically confirmed that this was the culprit. Also we took the bind values and the statement from sqlplus, and it *did* return two rows. I highlighted the row with r=1 because according to Tim's explanation, I should have seen r=0. So I got confused and replied with excerpt from the tracefile. I know he will have some explanation about it. For rollback look at Cursor# 45 ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Tales Of Big Hammer #10046 (AKA event 10046) Raj, Thanks for sharing this with us. In your original post you mentioned that you saw a "rollback" right after the "SQL*Net break/reset to client" and that was how you figured out the 1403 error. I don't see that in this excerpt from the raw trace file, though. How did you determine it was this particulat SQL? Also the FETCH#54 line you have highlighted has r=1, not r=0; what's special about that line? Thanks in advance. Arup *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: ORA-1410 Silliness
Lisa, Tuesday, December 31, 2002, 7:43:54 AM, you wrote: KL Usually when this happens I can re-fire the load and it will KL complete, no problem. It's a big annoyance and it seems like every KL time I take a day off it happens. How does it know you are taking a day off? Maybe you shouldn't set your mailers auto-reply :-) -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness Sounds like another Elvis sighting!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: Tales Of Big Hammer #10046 (AKA event 10046)
Raj, The application may have interpreted this as ORA-01403, but I've no clue as to why the SQL*Net break/reset to client occurred. You can see about 7 seconds of wait for response from the client, after which a rollback occurs... The FETCH shows r=1 indicating that at least one row was returned. Was the application doing array fetches for that statement? Was a row returned? Is this PL/SQL or ??? It is interesting how these traces feel very much like archaeology; just have to use a delicate hammer to knock the bits loose... -Tim Tim, I don't see that ... I know this sql caused the problem .. == == === PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44 tim=1016624815165467 hv=2089161539 ad='24ba3ad8' SELECT b.pr_mobility_code FROM prp_requests b, prp_sr_cal_pps a WHERE b.pr_req_unit_id = :b3 AND b.pr_gr_id = a.pscp_id AND a.pscp_prp_id = :b2 AND a.pscp_prp_version = :b1 END OF STMT PARSE #54:c=0,e=1192,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1016 624815165463 BINDS #54: bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=72 offset=0 bfp=11054edb0 bln=22 avl=05 flg=05 value=9044628 bind 1: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=24 bfp=11054edc8 bln=22 avl=04 flg=01 value=586823 bind 2: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=48 bfp=11054ede0 bln=22 avl=02 flg=01 value=2 EXEC #54:c=0,e=1681,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1016 624815167288 WAIT #54: nam='global cache cr request' ela= 417 p1=32 p2=500383 p3=504403158449678016 WAIT #54: nam='db file sequential read' ela= 2816 p1=32 p2=500383 p3=1 WAIT #54: nam='global cache cr request' ela= 445 p1=33 p2=517103 p3=504403158399168096 WAIT #54: nam='db file sequential read' ela= 1858 p1=33 p2=517103 p3=1 WAIT #54: nam='db file sequential read' ela= 781221 p1=31 p2=1251231 p3=1 FETCH #54:c=0,e=787456,p=3,cr=17,cu=0,mis=0,r=1,dep=1,og=4,tim=1 016624815954763 WAIT #0: nam='SQL*Net break/reset to client' ela= 57 p1=675562835 p2=1 p3=0 WAIT #0: nam='SQL*Net break/reset to client' ela= 630 p1=675562835 p2=0 p3=0 WAIT #0: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0 *** 2002-12-27 16:17:21.846 WAIT #0: nam='SQL*Net message from client' ela= 29596938 p1=675562835 p2=1 p3=0 = PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845553757 hv=1226881397 ad='24f0b6b8' ROLLBACK END OF STMT PARSE #45:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=10166 24845553752 XCTEND rlbk=1, rd_only=1 EXEC #45:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=101662 4845553883 WAIT #45: nam='SQL*Net message to client' ela= 3 p1=675562835 p2=1 p3=0 WAIT #45: nam='SQL*Net message from client' ela= 13212 p1=675562835 p2=1 p3=0 = PARSING IN CURSOR #45 len=8 dep=0 uid=3318 oct=45 lid=3318 tim=1016624845567343 hv=1226881397 ad='24f0b6b8' ROLLBACK END OF STMT PARSE #45:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=101662 4845567339 XCTEND rlbk=1, rd_only=1 EXEC #45:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=101662 4845567450 WAIT #45: nam='SQL*Net message to client' ela= 1 p1=675562835 p2=1 p3=0 WAIT #45: nam='SQL*Net message from client' ela= 6733 p1=675562835 p2=1 p3=0 STAT #43 id=1 cnt=1 pid=0 pos=1 obj=29433 op='TABLE ACCESS BY INDEX ROWID SELLING_ROTATIONS (cr=3 r=1 w=0 time=14786 us)' STAT #43 id=2 cnt=1 pid=1 pos=1 obj=422698 op='INDEX UNIQUE SCAN SR_PK_PRIM (cr=2 r=0 w=0 time=27 us)' Thanks for the explanation ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, December 30, 2002 7:49 PM To: Multiple recipients of list ORACLE-L Generally you won't find err=1403 text in the raw .trc file. Instead, if you carefully examine the FETCH lines, you'll see r=0 (i.e. zero rows returned) in amongst all the other statistics. Very very difficult to catch and often requires a Vulcan mind-meld to the application over several hours of careful perusal (something best left to Vulcans)... Great job! [Attachment: ESPN_Disclaimer.txt] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness Is there a column with a datatype of rowid? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
Re: ORA-1410 Silliness
Title: ORA-1410 Silliness Elvis? No way. It's got to be a Raelian clone. Ken Janusz - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 8:34 AM Subject: RE: ORA-1410 Silliness Sounds like another Elvis sighting!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness Nope... nothing named rowid. -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Is there a column with a datatype of rowid? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
Re: this doesn't look right
see, now that answers my question! I haven't done any work at all with object tables so I haven't seen any of this thanks Arup! --- Arup Nanda [EMAIL PROTECTED] wrote: In case of object tables, the constraints are defined on the most primitive of the objects. For instance, you have a table MYTAB defined on an object type MYTYPE1 which references in MYTYPE2. An attribute of MYTYPE2, ATTR1 has the constraint defined as not null. In this case the column_name in dba_cons_columns will say MYTAB.MYTYPE1.MYTYPE2 to show the hierarchy. Since each of these values could be 30 chars long, with the dots and double quotes, the column_name could easily be very long. Therefore, VARCHAR2(4000). HTH Arup From: Rodd Holman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: this doesn't look right Date: Mon, 30 Dec 2002 14:53:56 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f34.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 30 Dec 2002 15:34:11 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id PAA46221;Mon, 30 Dec 2002 15:33:50 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052468B; Mon, 30 Dec 2002 14:53:56 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Rodd Holman [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 30 Dec 2002 23:34:11.0258 (UTC) FILETIME=[F4A239A0:01C2B05B] This still begs the question why varchar(4000) in the underlying table if column names are only allowed to be 30? Is this table used for other objects that can have a longer name? If so what? Rodd On Mon, 2002-12-30 at 16:08, Shaleen wrote: Varchar2(4000) is coming from sys.attrcol$ table. dba_tab_columns does not have a join this table. I am sure there are people on this list who'll enlighten me about contents of sys.attrcol$ table. select u.name, c.name, o.name, decode(ac.name, null, col.name, ac.name), cc.pos# from sys.user$ u, sys.con$ c, sys.col$ col, sys.ccol$ cc, sys.cdef$ cd,sys.obj$ o, sys.attrcol$ ac where c.owner# = u.user# and c.con# = cd.con# and cd.type# != 12 /* don't include log groups */ and cd.con# = cc.con# and cc.obj# = col.obj# and cc.intcol# = col.intcol# and cc.obj# = o.obj# and col.obj# = ac.obj#(+) and col.intcol# = ac.intcol#(+) -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 30, 2002 12:23 PM As part of the process of making sure that null/not null constraints are consistent across development/staging/production, I'm looking at the dba_cons_columns table. Now, as far as I know, column_names are limited to 30 characters, correct? If so, why is the column_name column in dba_cons_columns (9.2.0.1) a varchar2(4000)? I realize that the extra space isn't used and is never allocated so it's not like this is wasteful. But it's inconsistent with everything else, since dba_tab_columns has a column_name column of varchar2(30). anyone know why this is like this? Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Rodd Holman [EMAIL PROTECTED] Romans 1:16-17 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to:
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness Yea, yea, well... my environment here leaves a lot to be desired :) Heck my database isn't even being BACKED UP aside from the backups I scream for. Don't even ask. As an aside that I forgot to mention: I am not using FOR UPDATE OF in any of my procedures either. -Original Message- From: Robert Eskridge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-1410 Silliness Lisa, Tuesday, December 31, 2002, 7:43:54 AM, you wrote: KL Usually when this happens I can re-fire the load and it will KL complete, no problem. It's a big annoyance and it seems like every KL time I take a day off it happens. How does it know you are taking a day off? Maybe you shouldn't set your mailers auto-reply :-) -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness But "cloned" rows ought to have different rowids ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-1410 Silliness Elvis? No way. It's got to be a Raelian clone. Ken Janusz This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness Lisa, What is your cursor doing? Perhapsrow-migration is occuring thus causing the rowid to become invalid? Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: ORA-1410 Silliness
Title: Message So they figured out the memory/personality transfer too? John P WeathermanOracle Database AdministratorReplacements, Ltd. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-1410 Silliness Elvis? No way. It's got to be a Raelian clone. Ken Janusz - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 8:34 AM Subject: RE: ORA-1410 Silliness Sounds like another Elvis sighting!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness If I had a Raelian clone for a sysadmin I would have less problems than I do now. GRRR -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-1410 Silliness Elvis? No way. It's got to be a Raelian clone. Ken Janusz - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 8:34 AM Subject: RE: ORA-1410 Silliness Sounds like another Elvis sighting!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: Tales Of Big Hammer #10046 (AKA event 10046)
Title: RE: Tales Of Big Hammer #10046 (AKA event 10046) Hmmm Tim, you really got me thinking ... 1. Support person ran the form. 2. Hit the error 3. Exited the form. Now point 3, will issue a rollback (Oracle Forms) so is that why we see two rollbacks in the trace file? The SQL is part of a DB package used by the form. I seem to remember that Oracle Forms had a bug, that returned ORA-1403 when either there actually was ORA-1403 or there wasn't any error but DBMS_ERROR_CODE() returned 1403 error. The probably have fixed the bug by now. But in this case, developer isn't checking the value of DBMS_ERROR_CODE(), for that matter developer is checking for no errors at all, and completely relying on Oracle to report these errors in the most obsecure way (sorry IMHO that's how Forms return server errors). They don't want to do too much coding (especially when it comes to exception handling). That being said, this SQL is executed as implicit cursor, so that might explain more than one row fetch and thus 1403. The worst part is I don't see the second fetch in the trace file. Slightly off topic: I'd also like to take this opportunity to say that today we have for the 2nd time (two separate issues) logged a bug report to fix the patch that OWS provided to fix a bug that we reported earlier. So we are requesting a patch to fix a patch to fix a bug ... to quote Yogi Berra ... It's Deja vu all over again !! I get to go home 1/2 day today conditions permitting ... but my boss is on vacation, so conditions are perfect. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tales Of Big Hammer #10046 (AKA event 10046) Raj, The application may have interpreted this as ORA-01403, but I've no clue as to why the SQL*Net break/reset to client occurred. You can see about 7 seconds of wait for response from the client, after which a rollback occurs... The FETCH shows r=1 indicating that at least one row was returned. Was the application doing array fetches for that statement? Was a row returned? Is this PL/SQL or ??? It is interesting how these traces feel very much like archaeology; just have to use a delicate hammer to knock the bits loose... -Tim *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness Hi Tom, Row movement is disabled on this table. Cursor is only selecting from a raw data table, formatting/cleaning up data and loading it into a temp table (which also passed analyze table cascade) and then the temp table is swapped into the proper partition in the final table. If any of that makes sense. At this point nothing makes sense. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:24 AMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: ORA-1410 Silliness Lisa, What is your cursor doing? Perhapsrow-migration is occuring thus causing the rowid to become invalid? Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness How about posting the table structure and the lines around 1970 in the Elvis package. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Nope... nothing named rowid. -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Is there a column with a datatype of rowid? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness 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. GRRR -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
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness Anything with a Materialized View?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Yea, yea, well... my environment here leaves a lot to be desired :) Heck my database isn't even being BACKED UP aside from the backups I scream for. Don't even ask. As an aside that I forgot to mention: I am not using FOR UPDATE OF in any of my procedures either. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Automatic backup on Oracle 9i -- For Jared
Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop Jared --- Jared Still [EMAIL PROTECTED] wrote: MetaLink is Oracle's support site. metalink.oracle.com No, I don't think your explanation is complicated, I just don't use OEM. I fired it up to take a look, but the backup portion requires the OEM repository to be setup, so I didn't learn anything. Yes, I *do* make backups, but use RMAN directly with Veritas NetBackup. Jared On Friday 27 December 2002 19:44, Sony kristanto wrote: Jared, Thanks Jared for your opinion, perhaps my explaination ain't quite right so it looks like complicated but I will try to give detail explaination. By the way what is MetaLink ? Rgrds, Sony -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 9:40 AM To: Sony kristanto; [EMAIL PROTECTED] Subject: Re: Automatic backup on Oracle 9i Hmm A lot of folks on this liststudiously avoid OEM. I know I do, and I'm not going to be much help on this. Have you tried MetaLink? Jared On Friday 27 December 2002 17:11, Sony kristanto wrote: Yes, that's right Jared, by doing this we can make schedule when we want to backup our data onto hard disk or tape periodicaly (weekly or daily even hour), thanks for your response and wishing you can help me to solve it. -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 10:06 AM To: [EMAIL PROTECTED]; Sony kristanto Subject: Re: Automatic backup on Oracle 9i Sony, What is an 'automatic' backup? Is this something supplied by that 'Oracle Enterprise Manager' thingy? Jared On Thursday 26 December 2002 17:23, Sony kristanto wrote: Hi Listers, I'm new on Oracle Database 9i after I migrated from Oracle 8i. I try to use backup facility from Oracle 9i and I already follow the instructions how to activate the automatic backup but when I see the status on history I get an error comment 'Failed'. I've try again and again but the results are the same. Could someone out there tell me why it can't runs. For your note I use 'SYS' as my user. I will really appreciate your help. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness 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_martName 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 DATEQUALIFICATION_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 DATESTATUS_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 DATEPRE_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 DATEOVERRIDE_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 DATEADJUSTABLE_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 DATENEXT_PAYMENT_DATE DATEPAC_DUE_DATE DATEEFT_ROUTING_NUMBER VARCHAR2(8)EFT_ACCOUNT_NUMBER VARCHAR2(30)EFT_MANUAL_NUMBER VARCHAR2(30)BANK VARCHAR2(35)STATUS_CHANGE_DATE DATEASSIGNED_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 DATETS_LOCATION VARCHAR2(12)CR_DATE_REC_IN_DEEDING DATECR_REFUND VARCHAR2(11)CR_CREDIT_LIFE_TYPE VARCHAR2(1)CR_QUALIFICATION_DATE DATECR_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 DATECR_HC_DATE2 DATECR_DATE_IN_LR DATECR_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 DATEBIANNUAL_FLAG VARCHAR2(10)FICO_SCORE NUMBER(3)SOCIAL_SECURITY_NUMBER NUMBER(9) SQL Here's the code. Line 1970 is cr_hc_amt2. -- Insert the record into the reject table.INSERT INTO
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness Hi Raj, No materialized view. That would be too high-tech for this company. And it might kill Elvis more than once. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Anything with a Materialized View?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Yea, yea, well... my environment here leaves a lot to be desired :) Heck my database isn't even being BACKED UP aside from the backups I scream for. Don't even ask. As an aside that I forgot to mention: I am not using FOR UPDATE OF in any of my procedures either.
Re: Automatic backup on Oracle 9i -- For Jared
You must purchase the NBU for Oracle option to use RMAN with NBU. Nothing special from the RMAN side. The SBT_TAPE device is now routed to NBU. Not quite that simple in reality, as the backups now become part of the NBU environment, and you must setup NBU policies, schedules, etc. Jared On Tuesday 31 December 2002 09:33, OraCop wrote: Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop Jared --- Jared Still [EMAIL PROTECTED] wrote: MetaLink is Oracle's support site. metalink.oracle.com No, I don't think your explanation is complicated, I just don't use OEM. I fired it up to take a look, but the backup portion requires the OEM repository to be setup, so I didn't learn anything. Yes, I *do* make backups, but use RMAN directly with Veritas NetBackup. Jared On Friday 27 December 2002 19:44, Sony kristanto wrote: Jared, Thanks Jared for your opinion, perhaps my explaination ain't quite right so it looks like complicated but I will try to give detail explaination. By the way what is MetaLink ? Rgrds, Sony -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 9:40 AM To: Sony kristanto; [EMAIL PROTECTED] Subject:Re: Automatic backup on Oracle 9i Hmm A lot of folks on this liststudiously avoid OEM. I know I do, and I'm not going to be much help on this. Have you tried MetaLink? Jared On Friday 27 December 2002 17:11, Sony kristanto wrote: Yes, that's right Jared, by doing this we can make schedule when we want to backup our data onto hard disk or tape periodicaly (weekly or daily even hour), thanks for your response and wishing you can help me to solve it. -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 10:06 AM To: [EMAIL PROTECTED]; Sony kristanto Subject:Re: Automatic backup on Oracle 9i Sony, What is an 'automatic' backup? Is this something supplied by that 'Oracle Enterprise Manager' thingy? Jared On Thursday 26 December 2002 17:23, Sony kristanto wrote: Hi Listers, I'm new on Oracle Database 9i after I migrated from Oracle 8i. I try to use backup facility from Oracle 9i and I already follow the instructions how to activate the automatic backup but when I see the status on history I get an error comment 'Failed'. I've try again and again but the results are the same. Could someone out there tell me why it can't runs. For your note I use 'SYS' as my user. I will really appreciate your help. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Different Oracle clients give different results
Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Any Collaboration Suite or 9iAS listservers?
Question for the group; If there are no listservers/mail lists specific to 9iAS/'managing Oracle from a System Admin POV' ... would there be an interest in subscribing to such a list? I've learned a LOT from this list, but I'd estimate 60% - 70% of the content is of no interest to me at all, as I'm not a DBA or a developer... thanks, ~brian -Original Message- Sent: Monday, December 30, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Does anyone know of any Collaboration Suite or 9iAS specific listservers? I tried subscribing to the webcys_l listserver but it appears to be inactive. TIA... Michael D. Gilly Sr. email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Buffer Pool Testing
I'm spending some time today experimenting with buffer pools in 8.1.7. I have two tables that I have assigned to the RECYCLE pool. I have been running various queries that perform full table scans, then checking the buffers to see what gets aged out. During my testing, it seems like the first blocks to get into the RECYCLE buffer pool will stay there. The following two tables are assigned to the RECYCLE pool. No other segments are assigned to it: WORK_ORDER_STEP - 428 blocks of data ALRA_TRANSACTION_HISTORY - 14152 blocks of data The RECYCLE pool has 1000 blocks. I startup the database, query the WORK_ORDER_STEP table (1 time), then run multiple queries against the ALRA_TRANSACTION_HISTORY table (6 times), I see the following in the buffers (the source for this query is at the end of my email): BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- -- - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 569 14 0 .02 RECYCLE WRKORD WORK_ORDER_STEP 431 1 0 .00 If I startup the database, query the ALRA_TRANSACTION_HISTORY table (1 time), then run multiple queries against the WORK_ORDER_STEP table (6 queries), I get these results: First query - 1000 blocks are used as expected BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- -- - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 1000 2 0 .00 After querying the second table multiple times, I expected more than just 9 blocks to be given up. I expected more like 431 blocks. BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- -- - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 991 2 0 .00 RECYCLE WRKORD WORK_ORDER_STEP 9 4 0 .44 I expected the blocks (from the table that was queried first) to be aged out as I queried the second table (over and over). This does not occur. Am I hitting a bug or just misunderstanding the buffer management algorithms? ALRA_TRANSACTION_HISTORY blocks should be LRU as I hit the WORK_ORDER_STEP table over and over. Thanks, Jay Here is the query that I use to check what is in the buffer pools: select bpd.bp_name, u.name obj_owner, o.name, count(*) BLOCKS, max(tch) max_touch, min(tch) min_touch, avg(tch) avg_touch from x$kcbwds wds, /* working data sets */ x$kcbwbpd bpd, /* buffer pools */ x$bh bh, /* buffer headers */ obj$ o,/* objects */ user$ u where wds.set_id = bpd.bp_lo_sid and wds.set_id = bpd.bp_hi_sid and bpd.bp_size != 0 and bh.indx between wds.start_buf# and wds.end_buf# and o.dataobj# = bh.obj and bh.state !=0 and o.owner# !=0 /* exclude sys */ and o.owner# = u.user# group by bpd.bp_name, u.name, o.name order by bpd.bp_name, u.name, o.name ; **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Automatic backup on Oracle 9i -- For Jared
OraCop If you invest in the option, you might consider purchasing the book Oracle9i RMAN Backup Recovery by Robert Freeman It has a chapter on configuring VERITAS NetBackup. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 31, 2002 12:24 PM To: Multiple recipients of list ORACLE-L You must purchase the NBU for Oracle option to use RMAN with NBU. Nothing special from the RMAN side. The SBT_TAPE device is now routed to NBU. Not quite that simple in reality, as the backups now become part of the NBU environment, and you must setup NBU policies, schedules, etc. Jared On Tuesday 31 December 2002 09:33, OraCop wrote: Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop Jared --- Jared Still [EMAIL PROTECTED] wrote: MetaLink is Oracle's support site. metalink.oracle.com No, I don't think your explanation is complicated, I just don't use OEM. I fired it up to take a look, but the backup portion requires the OEM repository to be setup, so I didn't learn anything. Yes, I *do* make backups, but use RMAN directly with Veritas NetBackup. Jared On Friday 27 December 2002 19:44, Sony kristanto wrote: Jared, Thanks Jared for your opinion, perhaps my explaination ain't quite right so it looks like complicated but I will try to give detail explaination. By the way what is MetaLink ? Rgrds, Sony -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 9:40 AM To: Sony kristanto; [EMAIL PROTECTED] Subject:Re: Automatic backup on Oracle 9i Hmm A lot of folks on this liststudiously avoid OEM. I know I do, and I'm not going to be much help on this. Have you tried MetaLink? Jared On Friday 27 December 2002 17:11, Sony kristanto wrote: Yes, that's right Jared, by doing this we can make schedule when we want to backup our data onto hard disk or tape periodicaly (weekly or daily even hour), thanks for your response and wishing you can help me to solve it. -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 10:06 AM To: [EMAIL PROTECTED]; Sony kristanto Subject:Re: Automatic backup on Oracle 9i Sony, What is an 'automatic' backup? Is this something supplied by that 'Oracle Enterprise Manager' thingy? Jared On Thursday 26 December 2002 17:23, Sony kristanto wrote: Hi Listers, I'm new on Oracle Database 9i after I migrated from Oracle 8i. I try to use backup facility from Oracle 9i and I already follow the instructions how to activate the automatic backup but when I see the status on history I get an error comment 'Failed'. I've try again and again but the results are the same. Could someone out there tell me why it can't runs. For your note I use 'SYS' as my user. I will really appreciate your help. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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
RE: ORA-1410 Silliness
Lisa, I am joining this thread late - so apologies if my suggestion has already been looked into ! The first error message is ORA-01001 (Invalid Cursor). There is an article on MetaLink (1007395.6) about the various causes for this error. Have you read this article and verified that the common causes in this note have been eliminated as a possible source of this error ? HTH Srini Chavali Oracle DBA Cummins Inc Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 12/31/2002 12:48:42 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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
RE: ORA-1410 Silliness
Title: 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-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness 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_martName 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 DATEQUALIFICATION_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 DATESTATUS_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 DATEPRE_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 DATEOVERRIDE_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 DATEADJUSTABLE_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 DATENEXT_PAYMENT_DATE DATEPAC_DUE_DATE DATEEFT_ROUTING_NUMBER VARCHAR2(8)EFT_ACCOUNT_NUMBER VARCHAR2(30)EFT_MANUAL_NUMBER VARCHAR2(30)BANK VARCHAR2(35)STATUS_CHANGE_DATE DATEASSIGNED_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 DATETS_LOCATION VARCHAR2(12)CR_DATE_REC_IN_DEEDING DATECR_REFUND VARCHAR2(11)CR_CREDIT_LIFE_TYPE VARCHAR2(1)CR_QUALIFICATION_DATE DATECR_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 DATECR_HC_DATE2 DATECR_DATE_IN_LR DATECR_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 DATEBIANNUAL_FLAG VARCHAR2(10)FICO_SCORE NUMBER(3)SOCIAL_SECURITY_NUMBER NUMBER(9) SQL Here's the code. Line 1970 is cr_hc_amt2. -- Insert the record into the reject table.INSERT INTO
RE: ORA-1410 Silliness
dumb question -- did you extract the insert statement and run it in sqlplus? Does it run there or does it go boom as well? --- Koivu, Lisa [EMAIL PROTECTED] wrote: 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 - -- IDNOT 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_NAMEVARCHAR2(20) OWNER_FIRST_NAME VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY VARCHAR2(18) OWNER_STATEVARCHAR2(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_DUENUMBER(9,2) AGING_31_TO_60_DAYS_DUENUMBER(9,2) AGING_61_TO_90_DAYS_DUENUMBER(9,2) ASSIGNED_LOAN_ADMIN_REPVARCHAR2(2) DATE_OF_SALE DATE STATUS_OF_ACCOUNT VARCHAR2(1) CONTRACT_TYPE VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACTVARCHAR2(1) DOCUMENT_STATUS_CODE VARCHAR2(1) FIXED_WEEK_SALEVARCHAR2(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_CODEVARCHAR2(1) CREDIT_CARD_FREEZE_CODEVARCHAR2(1) ASSOCIATION_NUMBER VARCHAR2(4) RFS_ASSIGNMENT_DATEDATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDINGVARCHAR2(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_LEFTNUMBER(4) DEFERRED_INTEREST NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTSNUMBER(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_ACCOUNTVARCHAR2(20) PRINCIPAL_BALANCE NUMBER(11,2) CR_DISCOUNT_BALANCENUMBER(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
RE: Different Oracle clients give different results
Brian, Yes I have checked all of this. Three other co-workers are having same problem except they just have the one Oracle client 8.1.7. It appears to be client related. Thanks Rick Brian McGraw brian.mcgraw@infinity-insu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rance.comcc: Sent by: [EMAIL PROTECTED] Subject: RE: Different Oracle clients give different results 12/31/2002 01:28 PM Please respond to ORACLE-L Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
dbms_lob pkg exception
Hi All,
the following function gives invalid lob locator specified.
b has been initialized to empty_clob()
begin
dbms_lob.copy(a,b,DBMS_LOB.GETLENGTH(b),1,1)
exception
when others then
dbms_output.put_line('error');
end;
Is the error occuring because b is empty_clob() ?
if yes then how to check b for empty_blob in if condition
so that I can also initialize variable a to empty_clob()
Thanks
Manoj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness Well, I don't think that's the issue. I'm issuing bulk inserts and using pl/sql tables in this procedure. That functionality has been in place since February and these errors only started surfacing in the last couple of months. I could decrease the commit interval and try that. I just hope it doesn't (big) hammer my runtime, it's bad enough already, evenwith the screamingfast bulk insert. Thanks Kevin for your input. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: 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-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness 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_martName 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 DATEQUALIFICATION_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 DATESTATUS_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 DATEPRE_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 DATEOVERRIDE_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 DATEADJUSTABLE_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 DATENEXT_PAYMENT_DATE DATEPAC_DUE_DATE DATEEFT_ROUTING_NUMBER VARCHAR2(8)EFT_ACCOUNT_NUMBER VARCHAR2(30)EFT_MANUAL_NUMBER VARCHAR2(30)BANK VARCHAR2(35)STATUS_CHANGE_DATE DATEASSIGNED_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 DATETS_LOCATION VARCHAR2(12)CR_DATE_REC_IN_DEEDING DATECR_REFUND VARCHAR2(11)CR_CREDIT_LIFE_TYPE
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness Yes, I do exchange partition but the error happens long before I hit the procedure that does that. It blows up on the load. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 1:44 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: ORA-1410 Silliness Do you perform an exchange partition in the code? An exchange partition does change row ids. One attachment (47k) Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: ORA-1410 Silliness [EMAIL PROTECTED] December 31, 2002 12:48 PM Please respond to 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. -- Insert the record into the reject table. INSERT INTO vegas_mart_reject SELECT id, load_date, load_job_id_v, contract_number, fac_code, owner_last_name, owner_first_name, owner_address1, owner_address2, owner_city, owner_state, owner_zip, net_purchase_price, original_down_payment, total_down_payment, cr_bal, interest_rate, first_payment_date,
Re: Automatic backup on Oracle 9i -- For Jared
Veritas has a central tape system for open systems. You use the product to backup all your data into this tape system, not to disk or local tape. Veritas NetBackup has an agent that allows RMAN to open channels to this tape system and backup the database to it. We backup all our systems to it and then take the tapes out and move then to another location. Using this product save us the need to go to 100's of servers and remove the tape from each one. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:33 PM Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop Jared --- Jared Still [EMAIL PROTECTED] wrote: MetaLink is Oracle's support site. metalink.oracle.com No, I don't think your explanation is complicated, I just don't use OEM. I fired it up to take a look, but the backup portion requires the OEM repository to be setup, so I didn't learn anything. Yes, I *do* make backups, but use RMAN directly with Veritas NetBackup. Jared On Friday 27 December 2002 19:44, Sony kristanto wrote: Jared, Thanks Jared for your opinion, perhaps my explaination ain't quite right so it looks like complicated but I will try to give detail explaination. By the way what is MetaLink ? Rgrds, Sony -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 9:40 AM To: Sony kristanto; [EMAIL PROTECTED] Subject: Re: Automatic backup on Oracle 9i Hmm A lot of folks on this liststudiously avoid OEM. I know I do, and I'm not going to be much help on this. Have you tried MetaLink? Jared On Friday 27 December 2002 17:11, Sony kristanto wrote: Yes, that's right Jared, by doing this we can make schedule when we want to backup our data onto hard disk or tape periodicaly (weekly or daily even hour), thanks for your response and wishing you can help me to solve it. -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 10:06 AM To: [EMAIL PROTECTED]; Sony kristanto Subject: Re: Automatic backup on Oracle 9i Sony, What is an 'automatic' backup? Is this something supplied by that 'Oracle Enterprise Manager' thingy? Jared On Thursday 26 December 2002 17:23, Sony kristanto wrote: Hi Listers, I'm new on Oracle Database 9i after I migrated from Oracle 8i. I try to use backup facility from Oracle 9i and I already follow the instructions how to activate the automatic backup but when I see the status on history I get an error comment 'Failed'. I've try again and again but the results are the same. Could someone out there tell me why it can't runs. For your note I use 'SYS' as my user. I will really appreciate your help. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness I just read it and most of these scenarios are specific to OCI. This is straight pl/sql. However I did check max open cursors (I believe that's a different error, I've seen that one before) and that's not the problem. I may be wrong, but when an error happens I jump at the new one. 6512 and 1001 aren't new and exciting ones. Thanks for your reply. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-1410 Silliness Lisa, I am joining this thread late - so apologies if my suggestion has already been looked into ! The first error message is ORA-01001 (Invalid Cursor). There is an article on MetaLink (1007395.6) about the various causes for this error. Have you read this article and verified that the common causes in this note have been eliminated as a possible source of this error ? HTH Srini Chavali Oracle DBA Cummins Inc Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 12/31/2002 12:48:42 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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
db_files and file descriptors on solaris7
All, Yesterday we increased db_files from 200 to 500 and recieved following message in alert log. Oracle instance running on a system with low open filedescriptor limit. Tune your system to increase thislimit to avoid severe performance degradation. Our file descriptors is set to 1024. Reducing db_files to 400 did not give this message. Interesting thing is that we increased file descriptors very recently from 64 to 1024. Does anyone have more information on this? Thanks Shaleen
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness I see "ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary key index for a table? If yes, then it may need to be rebuilt. Regards, waleed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness 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
Re: db_files and file descriptors on solaris7
Found following on metalink but this does not explain why we never saw the message when we were running on 64 descriptors and 200 files From: Oracle, Giridhar Tatavarty 02-Jan-02 08:29 Subject: Re : Get msg 'Oracle instance running on a system with low open file descriptor limit. Tune your system to increase this limit to avoid severe performance' The OS file-opening limit should not be greater than number of files Oracle opens. That is determined by the following db_files*2 ( twice for equal number of temp files to be opened) + 2* maximum_no_of_log_files_simultaneously_opened + maximum_number_of_controlfiles + safety_margin_for_misc_files (like trace . etc. minimum 32 ) If this is greater than OS Limit , message is flagged and file descriptors are recycled. In your case the calculated limit would be 4000*2 + 2*8 (assuming) + 8(assuming) + 32 = 8056 Since 8056 4096 the message is shown. Try a value for db_files, which is little below than ½ the OS limit . Thank you Giridhar - Original Message - From: Shaleen To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 11:40 AM Subject: db_files and file descriptors on solaris7 All, Yesterday we increased db_files from 200 to 500 and recieved following message in alert log. Oracle instance running on a system with low open filedescriptor limit. Tune your system to increase thislimit to avoid severe performance degradation. Our file descriptors is set to 1024. Reducing db_files to 400 did not give this message. Interesting thing is that we increased file descriptors very recently from 64 to 1024. Does anyone have more information on this? Thanks Shaleen
RE: ORA-1410 Silliness
Title: RE: ORA-1410 Silliness Hi Rachel, Just tried it and it works. Thanks for your suggestion. Lisa -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-1410 Silliness dumb question -- did you extract the insert statement and run it in sqlplus? Does it run there or does it go boom as well? --- Koivu, Lisa [EMAIL PROTECTED] wrote: 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. -- Insert the record into the reject table. INSERT INTO vegas_mart_reject SELECT id, load_date, load_job_id_v, contract_number, fac_code, owner_last_name, owner_first_name, owner_address1, owner_address2, owner_city, owner_state, owner_zip, net_purchase_price, original_down_payment, total_down_payment, cr_bal, interest_rate, first_payment_date, qualification_code, payment_amount, payment_frequency, aging_10_to_30_days_due, aging_31_to_60_days_due,
Re: ORA-1410 Silliness
Lisa . Enable SQL tracing . Launch your code . Identify (exactly) the cursor which fails with ORA-01410 and what bind vars are. . Pull out the statement from your code . Run it in 'standalone' mode . If it fails identify rowids which look broken. Check the phys. entities those rowids point out. Are those phys. entities Ok? . Any access BY ROWID in your statement is a potential problem. . You might want to dump error stack too but I suggest to contact oracle support first. Try to make a test case as simple as possible, it definitely would help. There is a simple scenario, may be it can give you some ideas (index_s is a simplified index simulator): DROP TABLE index_s; DROP TABLE tbl; CREATE TABLE index_s ( rid ROWID ); CREATE TABLE tbl ( pNUMBER ); INSERT INTO tbl VALUES(1); INSERT INTO index_s SELECT ROWID FROM tbl; SELECT * FROM tbl WHERE rowid = ( SELECT rid FROM index_s ); DROP TABLE tbl; CREATE TABLE tbl ( pNUMBER ); INSERT INTO tbl VALUES(1); COMMIT; SELECT * FROM tbl WHERE rowid = ( SELECT rid FROM index_s ); -- However this works well: SELECT * FROM tbl , index_s WHERE tbl.rowid = index_s.rid / -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Koivu, Lisa wrote: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
ORA-28030: Server encountered problems accessing LDAP directory service
I've recently inherited an Oracle 8.1.6 system and was just trying to setup a database link between two instances. I've granted the create database link priv to the user account and can successfully create the link but when I try to do a select from table_name@linked_db; I get the following error: ERROR at line 1: ORA-28030: Server encountered problems accessing LDAP directory service Earlier I had a TNS error and found that my tnsnames.ora file was missing one of my instances. I fixed that problem and tnsping now responds correctly but I'm still getting the error listed on the subject line. My sqlnet.ora file contains NAMES.DIRECTORY_PATH= (TNSNAMES) so everything should be set to use my local tnsnames.ora file. I've been going through Oracle Net 8 documentation but still haven't found anything. Does anyone have any suggestions? Thanks... David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: ORA-1410 Silliness
Did u do any migration recently . "Koivu, Lisa" [EMAIL PROTECTED] wrote: Well, I don't think that's the issue. I'm issuing bulk inserts and using pl/sql tables in this procedure. That functionality has been in place since February and these errors only started surfacing in the last couple of months. I could decrease the commit interval and try that. I just hope it doesn't (big) hammer my runtime, it's bad enough already, evenwith the screamingfast bulk insert. Thanks Kevin for your input. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: 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-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness 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_martName 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! bsp; 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! p; NUMBER(11,2)INTEREST_RATE NUMBER(5,2)FIRST_PAYMENT_DATE DATEQUALIFICATION_CODE VARCHAR2(1)PAYMENT_AMOUNT NUMBER(9,2)PAYMENT_FREQUENCY&! nbsp; 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 DATESTATUS_OF_ACCOUNT VARCHAR2(1)CONTRACT_TYPE! sp; VARCHAR2(1)WAS_PENDER VARCHAR2(1)CREDIT_LIFE_ON_CONTRACT VARCHAR2(1)DOCUMENT_STATUS_CODE VARCHAR2(1)FIXED_WEEK_SALE VARCHAR2(1)UDI_SALE! p; VARCHAR2(1)PHASE_NUMBER VARCHAR2(6)FAIRSHARE_PLUS_MEMBER VARCHAR2(1)POINTS_OWNED NUMBER(7)DEED_DATE DATEPRE_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 DATEOVERRIDE_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_CO! DED_7 DATEADJUSTABLE_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! sp; NUMBER(5)LAST_PAYMENT_DATE DATENEXT_PAYMENT_DATE DATEPAC_DUE_DATE DATEEFT_ROUTING_NUMBER VARCHAR2(8)EFT_ACCOUNT_NUMBER VARCHAR2(30)EFT_MANUAL_NUMBER! ; VARCHAR2(30)BANK VARCHAR2(35)STATUS_CHANGE_DATE DATEASSIGNED_LOAN_REP VARCHAR2(2)CREDIT_CARD_PAC_ACCOUNT VARCHAR2(20)PRINCIPAL_BALANCE NUMBER(11,2)CR_DISCOUNT_BALANCE&! nbsp; 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! bsp; 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_NUMBE! R 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! p; DATETS_LOCATION VARCHAR2(12)CR_DATE_REC_IN_DEEDING DATECR_REFUND VARCHAR2(11)CR_CREDIT_LIFE_TYPE VARCHAR2(1)CR_QUALIFICATION_DATE DATECR_EQT_IN_FROM_CONT_NO1! sp; 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_D! ATE1 DATECR_HC_DATE2 DATECR_DATE_IN_LR DATECR_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)PAI! D_OFF
Re: ORA-28030: Server encountered problems accessing LDAP directory service
Looks like are trying to resolve service name using LDAP naming . David Mitchell [EMAIL PROTECTED] wrote: I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of my instances. I fixed that problem and tnsping nowresponds correctly but I'm still getting the error listed on the subjectline. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" soeverything should be set to use my local tnsnames.ora file. I've beengoing through Oracle Net 8 documentation but still haven't foundanything. Does anyone have any suggestions? Thanks..! .David-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: David MitchellINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
RE: ORA-1410 Silliness
Okay this means that the statement itself, which is being pointed to by the error line, is not the real culprit. Unfortunately, I don't know of a good debugger for PL/SQL that lets you step through line by line. let me rephrase that, I know of no freeware one :) since you say this has only recently started happening, and since the sql runs on its own, what else has changed since the problem started? Amount of data? Other apps on the box taking away memory? Rachel --- Koivu, Lisa [EMAIL PROTECTED] wrote: Hi Rachel, Just tried it and it works. Thanks for your suggestion. Lisa -Original Message- Sent: Tuesday, December 31, 2002 2:19 PM To: Multiple recipients of list ORACLE-L dumb question -- did you extract the insert statement and run it in sqlplus? Does it run there or does it go boom as well? --- Koivu, Lisa [EMAIL PROTECTED] wrote: 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 - -- IDNOT 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_NAMEVARCHAR2(20) OWNER_FIRST_NAME VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY VARCHAR2(18) OWNER_STATEVARCHAR2(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_DUENUMBER(9,2) AGING_31_TO_60_DAYS_DUENUMBER(9,2) AGING_61_TO_90_DAYS_DUENUMBER(9,2) ASSIGNED_LOAN_ADMIN_REPVARCHAR2(2) DATE_OF_SALE DATE STATUS_OF_ACCOUNT VARCHAR2(1) CONTRACT_TYPE VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACTVARCHAR2(1) DOCUMENT_STATUS_CODE VARCHAR2(1) FIXED_WEEK_SALEVARCHAR2(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_CODEVARCHAR2(1) CREDIT_CARD_FREEZE_CODEVARCHAR2(1) ASSOCIATION_NUMBER VARCHAR2(4) RFS_ASSIGNMENT_DATEDATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDINGVARCHAR2(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_LEFTNUMBER(4) DEFERRED_INTEREST NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTSNUMBER(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
RE: Any Collaboration Suite or 9iAS listservers?
Brian and Michael, Try some of the ODTUG list-servers at ODTUG (http://www.odtug.com/subscrib.htm). 9iAS is discussed quite frequently (and not always fondly ;)) on the DEV2K list as well as some of the others such as the WEB and JAVA lists. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian Dunbar Sent: Tuesday, December 31, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Any Collaboration Suite or 9iAS listservers? Question for the group; If there are no listservers/mail lists specific to 9iAS/'managing Oracle from a System Admin POV' ... would there be an interest in subscribing to such a list? I've learned a LOT from this list, but I'd estimate 60% - 70% of the content is of no interest to me at all, as I'm not a DBA or a developer... thanks, ~brian -Original Message- Sent: Monday, December 30, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Does anyone know of any Collaboration Suite or 9iAS specific listservers? I tried subscribing to the webcys_l listserver but it appears to be inactive. TIA... Michael D. Gilly Sr. email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Happy New Year
Which u all a very very happy new year Anand KumarDBA ITW Signode India Ltd
