ORACLE 9.2.0.2

2002-12-31 Thread Yechiel Adar
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:

[no subject]

2002-12-31 Thread Sunil Arora
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)

2002-12-31 Thread Connor McDonald
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

RE: Tales Of Big Hammer #10046 (AKA event 10046)

2002-12-31 Thread Jamadagni, Rajendra
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

Different Oracle clients give different results

2002-12-31 Thread Rick_Cale
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

Re: Tales Of Big Hammer #10046 (AKA event 10046)

2002-12-31 Thread Arup Nanda
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

ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

RE: Tales Of Big Hammer #10046 (AKA event 10046)

2002-12-31 Thread Jamadagni, Rajendra
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

Re: ORA-1410 Silliness

2002-12-31 Thread Robert Eskridge
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

RE: ORA-1410 Silliness

2002-12-31 Thread Farnsworth, Dave
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

RE: Tales Of Big Hammer #10046 (AKA event 10046)

2002-12-31 Thread tim
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

RE: ORA-1410 Silliness

2002-12-31 Thread Orr, Steve
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

Re: ORA-1410 Silliness

2002-12-31 Thread KENNETH JANUSZ
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

Re: this doesn't look right

2002-12-31 Thread Rachel Carmichael
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

RE: ORA-1410 Silliness

2002-12-31 Thread Jamadagni, Rajendra
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.

RE: ORA-1410 Silliness

2002-12-31 Thread Mercadante, Thomas F
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

RE: ORA-1410 Silliness

2002-12-31 Thread John Weatherman
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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:

RE: Tales Of Big Hammer #10046 (AKA event 10046)

2002-12-31 Thread Jamadagni, Rajendra
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

RE: ORA-1410 Silliness

2002-12-31 Thread Kevin Lange
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:

RE: ORA-1410 Silliness

2002-12-31 Thread Whittle Jerome Contr NCI
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

RE: ORA-1410 Silliness

2002-12-31 Thread Jamadagni, Rajendra
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

Re: Automatic backup on Oracle 9i -- For Jared

2002-12-31 Thread OraCop
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:

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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?

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

Re: Automatic backup on Oracle 9i -- For Jared

2002-12-31 Thread Jared Still
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

RE: Different Oracle clients give different results

2002-12-31 Thread Brian McGraw
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 */

RE: Any Collaboration Suite or 9iAS listservers?

2002-12-31 Thread Brian Dunbar
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

Buffer Pool Testing

2002-12-31 Thread Jay Hostetter
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

RE: Automatic backup on Oracle 9i -- For Jared

2002-12-31 Thread DENNIS WILLIAMS
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,

RE: ORA-1410 Silliness

2002-12-31 Thread srini . chavali
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

RE: ORA-1410 Silliness

2002-12-31 Thread Kevin Lange
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)

RE: ORA-1410 Silliness

2002-12-31 Thread Rachel Carmichael
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

RE: Different Oracle clients give different results

2002-12-31 Thread Rick_Cale
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

dbms_lob pkg exception

2002-12-31 Thread manoj . gurnani
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');

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

Re: Automatic backup on Oracle 9i -- For Jared

2002-12-31 Thread Yechiel Adar
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

db_files and file descriptors on solaris7

2002-12-31 Thread Shaleen
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.

RE: ORA-1410 Silliness

2002-12-31 Thread Khedr, Waleed
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

Re: db_files and file descriptors on solaris7

2002-12-31 Thread Shaleen
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

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
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

Re: ORA-1410 Silliness

2002-12-31 Thread Vladimir Begun
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

ORA-28030: Server encountered problems accessing LDAP directory service

2002-12-31 Thread David Mitchell
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

RE: ORA-1410 Silliness

2002-12-31 Thread ora ak
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

Re: ORA-28030: Server encountered problems accessing LDAP directory service

2002-12-31 Thread ora ak
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

RE: ORA-1410 Silliness

2002-12-31 Thread Rachel Carmichael
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

RE: Any Collaboration Suite or 9iAS listservers?

2002-12-31 Thread Larry Elkins
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]

Happy New Year

2002-12-31 Thread Anand Kumar N
Which u all a very very happy new year Anand KumarDBA ITW Signode India Ltd