Re: Desupport of RBO
Yes Jared, That is true.. I also saw note .. but never heard of 10i. The rule-based optimizer (RBO) will no longer be supported when Oracle9i is de-supported. The release after Oracle9i (referred to in this article as Oracle10i) will only support the cost-based optimizer (CBO). - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, October 06, 2003 04:34 PM Subject: Desupport of RBO First time I've seen this note: 189702.1 Jared
Re: Data Transfer or Views from SQL Server to Oracle
Hello Stephane, Thanks for the reply.. yes the volume is not too big.. but even then it will be substantial amount of data transferred only from SQL Server to Oracle. I was not willing to write an application, but seems from the reply there is no other way.. at present.. (I tried from Oracle to Access just to test).. and was able to create views using ODBC.. If it was Windows (SQL Server) to Windows (Oracle) ODBC would have been the best way communicate... I believe.. Anyway.. will put VB / Java to work. Nikunj - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, March 15, 2003 01:23 AM > Nikunj Gupta wrote: > > > > Hello, > > > > SQL Server in on Windows 2000 Box. > > Oracle 8.1.7 is on Unix. > > > > Is there any process by which data can be transferred from SQL SERVER to > > ORACLE directly.. something like views / snapshots. (Requirement is almost > > realtime data from SQL Server to Oracle) > > > > I am initially not planning to dump the data from SQL Server (if possible) > > and then run loader etc.. > > > > I am still not on 9i... else maybe would could have tried to read external > > file directly after dump. > > > > Thanks for any help or hint in this. > > > > Nikunj > > Nikunj, > >You have various options, coming at different prices. I *think* that > Oracle provides a gateway to Sybase/SQL Server; the reverse is also > true. Some 3rd party products offer (so to speak) various replication > capabilities between Oracle and SQL Server. Sybase's own Replication > Server is a good product, which may help you achieve snapshot-like > replication. If you feel like doing it yourself, perhaps you can combine > the new Net8 APIs and Open Server and build your own bridge. Otherwise > the object option, through views mapping PL/SQL tables, can provide an > interesting solution if you handle volumes which can hold in memory > (fully or incrementally). I have used this to do about the same you want > to do with data from an iPlanet LDAP server (I have written a paper with > Robert Goral to explain the basics of the technique, it has been > published on the Online Edition of Oracle Magazine, search their > archives). > Lots of solutions indeed,which depend on how much you are ready to > fork, volumes, and what you are ready to code. > > -- > HTH, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroult > 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: Nikunj Gupta 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).
Data Transfer or Views from SQL Server to Oracle
Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc.. I am still not on 9i... else maybe would could have tried to read external file directly after dump. Thanks for any help or hint in this. Nikunj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikunj Gupta 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: Rman and controlfile backups.
If you are testing.. and want to try it again.. Backup CONTROL FILE at the end.. i.e. even after the archive logs are backed up. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 09:35 AM > 1) RMAN on Oracle 8.1.7 > > 2) Create a latest backupset using: > > rman nocatalog > > run > { > allocate channel ch1 type disk; > backup database; > backup current controlfile; > backup archivelog all; > } > > 3) Delete all *.dbf, control and archive log files (simulate a > catastrophic database loss). > > 4) Restore controlfile from the lastest rman backupset using the > pl/sql script available in the Oracle 8i Recovery Manager User Guide > and Reference. > > 5) Now controlfile is restored and I startup the database nomount. > > 6) Attempting to restore database using rman results in rman saying > that the latest backup set in unavailable. > > 7) This is because I used the controlfile as the rman repository. And > when I back-uped the controlfile, the controlfile did not yet have the > updated backupset information. > > 8) How do you solve this problem? > > Thanks. > > -- > Lyndon Tiu > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Lyndon Tiu > 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: Nikunj Gupta 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: Basic RMAN question
Try RMAN and at rman prompt RMAN> connect backup_admin/[EMAIL PROTECTED] Does that work ? Check for LD_LIBRARY_PATH, ORACLE_HOME environments and which RMAN Executable your session is using. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 05:28 AM > Hi All, > > I am starting to play with rman in a test environment, however I seem > to be hitting a really basic problem starting rman. > > I have oracle 9.2.0.1.0 installed on Redhat AS 2.1 > > When i issue the command: > > rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log="test.log" > rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] > > So i tested the connect string i had used as shown below: > > Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog > > SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > SQL> connect backup_admin/backup as sysdba > Connected. > > So I thought id start simple: > >rman nocatalog > rman: can't open nocatalog > >rman > this just hangs > > So what have i missed? > > Thanks > > Ceri > -- > Ceri Townsend Database Admin > mailto:[EMAIL PROTECTED] ICQ:153010767 > > "I love deadlines. I like the whooshing sound they make as they fly by." > Douglas Adams > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ceri Townsend > 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: Nikunj Gupta 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: 100% CPU utilization, urgent
Title: 100% CPU utilization, urgent Check for fragmented tablespaces... There are chances that SMON is active and coalescing tablespaces. - Original Message - From: Naveen Nahata To: Multiple recipients of list ORACLE-L Sent: Sunday, January 19, 2003 10:48 PM Subject: RE: 100% CPU utilization, urgent Hussain, We have a similar environment and we also hit 100%CPU utilization at times. But we never face problem because of tht. the DB keeps working fine during 100% CPU utilization also. Are you having a problem of logging into the DB during tht time? Regards Naveen -Original Message-From: Hussain Ahmed Qadri [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: 100% CPU utilization, urgent HI all We have a consistent problem of CPU utilization 100%. We have had this problem since Saturday, but it automatically subsided, I mean went back to normal after a few hours, and remained normal on Sunday as well. But its back to 100% since morning, that is when the load on the server has gone up again to 100% and over all work is non-existent. Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor, Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7. I have checked the temporary tablespaces, they are normal. We have a 24x7 environment, a hospital, so please can you suggest the areas to look in to, its really very urgent. Regards, Hussain DISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
Re: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
Were you analyzing while rebuilding Indexes ? If that is the case.. there are chances of possible corruption. Try to give select count(*) from table_name; and select * from table_name; Hope this may provide you with some answer. HTH - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 06:43 AM > > Sorry, I forgot this additional infromation... > > Oracle created invalid objects when we ran rebuild. The odd thing was that > the trace file showed an invalid object but the all_objects table showed a > valid object. > > > > -Original Message- > Sent: Monday, January 13, 2003 9:39 AM > To: [EMAIL PROTECTED] > > > > Team, > > I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode. > While the users were on the system, we Re-Indexed our tables. > Situation: The users complained, that they were unable to process their > orders. > Although, the log file showed that the re-indexing was successful, the users > were still unable to process their orders. > > > QUESTION: Are they any known issues/pit-falls when re-indexing real-time in > version 7.x? > > Should you have the database in exclusive mode when re-indexing? > > Please assist. > > Thanks > > Conrad Meertins > > [EMAIL PROTECTED] > > DBA Masters > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Conrad Meertins > 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: Nikunj Gupta 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).
Forms 4.5 : DB 8.1.7.4 and Client 7.3.*
Hello, Unable to connect to FRM-10247 with DB Version 8.1.7.4 and client version 7.3.* Same Forms and Menu work with Oracle 8i client. Another interesting issue.. Same Forms and Menu when connect to Oracle 8.1.7.2 DB with 7.3.* client or 8i client works like a champ. Any help or hint in this regard will be highly appreciated. Nikunj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta 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: Group By - Without using aggregate functions
Check if ROLLUP or CUBE helps. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 01:28 AM Hi Gurus, I would like to group by the result of a select statement based on a particular column. But I am not using any aggregate function in the select list. For eg. select deptno, empno from emp group by deptno, empno; I tried to do it in sqlplus by setting BREAK ON and it works. But I want use this query in a java program. Is there any solution for this? TIA regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S 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.com -- Author: Nikunj Gupta 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: couple of questions ???
Check for Remote DB Link and connection to that DB if any. Check for the LOCKS. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 02:58 PM > Hi all, > > I have couple of questions, 817 on NT. > > 1. There is an invalid SP, my collegue did a Show > Errors in SQL Plus, it shows the error; but I did the > same thing in my Sql Plus, I got "No errors". Is > there any settings I need to change? > > 2. There is a valid SP, when I did a Alter procedure > p_Name compile. It just hangs. It was compiling > fine, now I added two lines (dbms_output stuff), and > it just compiling forever. The code now has 7969 > lines. Does that hit the limit? (I really doubt) Or > are there any other reasons? > > Thanks, > > Janet > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Janet Linsy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: rbs oracle data block corrupted
In Init.ora there is some setting to ignore using ROLLBACK Segments. Talk to Oracle support and try that. Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Danisment Gazi Unal (ubTools) To: Multiple recipients of list ORACLE-L Sent: Saturday, June 29, 2002 11:43 AM Subject: Re: rbs oracle data block corrupted Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
SAN Implementation
Hello Group / Guru's Anyone has White Paper on SAN, it Implementation especially with ORACLE ?? Any thought, personal experience with pros and cons will be highly appreciated. TIA Enlighten Me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: REPLICATION/FAIL OVER
Seema Singh > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >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.com > >-- > >Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >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). > > > > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Indexes on Table..
Hello List, Is there any bench mark.. about creating indexes on table ?Is there any document.. which has any guidelines on that ?? How many indexes are acceptable on a particular on a single table. Thanks in Advance.
Re: What is Oracle made from ?
gt; > > also send the HELP command for other information (like subscribing). > > > > -- > > Bjørn Engsig, Miracle A/S > > http://MiracleAS.dk > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > > -- > > Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > > -- > > Author: Abdul Aleem > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Anjo Kolk > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: KENNETH JANUSZ > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Names server
Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Solaris Kernel Memory Parameters Recommendations?
Hello David, I hope you have received some replies on this.. can you please forward it to me.. I lost the email in reply to this while reading Thanks in Advance. Nikunj Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 12:04 PM Subject: Solaris Kernel Memory Parameters Recommendations? Ive read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation. The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself. Would some of you more experienced UNIX/Oracle DBAs please provide a plain English explanation describing your strategy in setting the following 7 parameters in the /etc/system file: SEMMNI SEMMNS SEMMSL SHMMAX SHMMIN SHMMNI SHMSEG To use a simple example, lets say the server has 1 GB of RAM to work with. Thanks in advance for sharing, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail message from your computer. Thank you.
Re: Disable certain users from login to database while applying Human
stop the listener. Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 18, 2002 01:23 PM Human > Pick One.. > > 1. Change the password.. and then reset to original. > 2. Revoke CREATE SESSION from user. > 3. Startup database in Restrict mode. > > Hope this helps.. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, February 17, 2002 11:28 PM > > > > Hi Gurus, > > > > I need to disable certain users from login to database while I apply the > > Human Resources Patches for our Oracle HR 11i Applications. > > Which is the best way to do it ? Should I write on-logon trigger to > disable > > or should I take away their privileges to logon to report/forms/sqlplus ? > > What about the rest of the DBA Applications administrator ? What do U guys > > do to solve the dead-lock problem (If my users access the HR tables while > I > > apply the patches, I will encounter dead-lock problem) ? > > > > Please advise. Thanks. > > > > Regds, > > New Bee > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: CHAN Chor Ling Catherine (CSC) > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Nikunj Gupta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Disable certain users from login to database while applying Human
Pick One.. 1. Change the password.. and then reset to original. 2. Revoke CREATE SESSION from user. 3. Startup database in Restrict mode. Hope this helps.. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 11:28 PM > Hi Gurus, > > I need to disable certain users from login to database while I apply the > Human Resources Patches for our Oracle HR 11i Applications. > Which is the best way to do it ? Should I write on-logon trigger to disable > or should I take away their privileges to logon to report/forms/sqlplus ? > What about the rest of the DBA Applications administrator ? What do U guys > do to solve the dead-lock problem (If my users access the HR tables while I > apply the patches, I will encounter dead-lock problem) ? > > Please advise. Thanks. > > Regds, > New Bee > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: CHAN Chor Ling Catherine (CSC) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Sending email from Unix
did you try ?? :r while typing the message text.. NOTE : ' :r ' Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 12:25 PM > I tried mailx but it doesn't have the facility to send attachments.How do I > send attachments? > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 11:30 AM > > > > > Sona wrote: > > > > > > Hi > > > I want to send an email from Unix with an attachment .does anyone know > > > how to do this? > > > > > > TIA > > > > man mailx > > > > -- > > Regards, > > > > Stephane Faroult > > Oriole Ltd > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephane Faroult > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Sona > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Yet again more Recovery Manager questions
send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Using RMAN
Hi, I am not sure... what your exactly plan to do... But, You can configure RMAN to backup on DISK and use some TAPE MANAGEMENT UTILITY or SYSTEM UTILITY (If it is there) to backup from your DISK. Also that utility can delete after successful backup from DISK to TAPE depending on configuration and requirement. Now, in case of RESTORE... RMAN will try and restore from DISK, but if that is not there then you can restore back from TAPE to DISK and use RMAN to recover. Sounds logical ?? With all this in place.. also plan for backup of RMAN Repository. Can you please update me on the methodology you adopt. Have fun.. Nikunj PS: This is just to give an idea... you may have to workout some extra steps... and perform a test before implementing in REAL WORLD. Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Sona To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 16, 2002 03:20 PM Subject: Using RMAN Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA
Re: SqlLoader
Title: SqlLoader Hope you have checked the SID.. and also check whether LD_LIBRARY_PATH is set or not.. Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Burton, Laura L. To: Multiple recipients of list ORACLE-L Sent: Thursday, December 13, 2001 06:35 AM Subject: RE: SqlLoader Hey, at this point nothing is stupid. The problem is probably something 'stupid' that I am or are not doing. Yes, I did try setting the Oracle_sid parameter when I started trying to figure out what was wrong. Now for my stupid question. What is Two_Task? Thanks, Laura -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 4:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: SqlLoader Stupid question I know but is the correct SID set ?? and watch out for TWO_TASK !! Regards Lee -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 6:10 AMTo: Multiple recipients of list ORACLE-LSubject: RE: SqlLoader Thank you for your reply. The user does have DBA rights and also owns the table that is being referenced. If it was a table rights issue I would think I would have gotten 'table or view does not exist' message. I don't think it is even getting connected to the database. Laura -Original Message-From: Jeff Cox [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 12, 2001 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SqlLoader Laura, The username that you are trying to use, does this username own the table that is to be loaded, or does this username have DBA privileges? Even though you can connect via sqlplus and/or svrmgr to a session, this does not mean that you will be able to load data into any table that you desire. HTH Regards, Jeff Tempe, AZ - Original Message - From: Burton, Laura L. To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 12, 2001 3:35 PM Subject: SqlLoader I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems. Any ideas? Thanks, Laura The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
Re: Install of two client versions on same box
Title: Install of two client versions on same box I would go ahead one step and suggest keep ORACLE BASE also separate for each Oracle Version And also take care of INVENTORY FILE... Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursday, December 13, 2001 08:20 AM Subject: RE: Install of two client versions on same box This is very easy if you follow OFA standards for software installation. The different versions are installed as sub-directories of the $ORACLE_BASE directories (i.e... /oracle/app/oracle/product/8160, /oracle/app/oracle/product/8172). You then switch versions by changing your ORACLE_HOME, LD_LIBRARY_PATH, etc. Tony Aponte -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 10:10 AMTo: Multiple recipients of list ORACLE-LSubject: Install of two client versions on same box Hi! Is it possible to install two client versions (8.1.6 and 8.1.7) on the same Sun Solaris box? The reason for that is that we are using BEA Weblogic, which requires a specific Oracle client version and our application needs another one. Don't ask me about the sense behind it... This is 8.1.6/8.1.7 on Sun Solaris. Thanks, Helmut
Re: Database link
Check for DB_DOMAIN.. in INIT.ORA else Set GLOBAL_NAMES to FALSE ALTER SYSTEM SET GLOBAL_NAMES=FALSE; HTH Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Witold Iwaniec To: Multiple recipients of list ORACLE-L Sent: Monday, December 10, 2001 11:00 AM Subject: Database link Hi DBAs I have a problem with database links in one of the databases - the name of the link gets us.oracle.com appended to it. create database link test connect to test_user identified by test_pwd using 'test_db' When I execute: select * from my_table@test I get the ORA-02085 error message the the link test.us.oracle.com connects to test. When I execute: select * from global_name; in the target database the result is: TEST but in the database where I created the link the database name has the suffix: NOVALIS.US.ORACLE.COM I have no problem with database links in the TEST database but would like to know which parameter causes the suffix to be appended in the NOVALIS database. In both init.ora files the global_names is set to true and db_domain is commented out. In both databases the command show parameters; returns the db_domain as blank. Actually both databases are on the same server - Oracle 8.1.6. What should I change to remove the US.ORACLE.COM suffix. I don't care too much about the database, it's my test only, but don't want it appended in the links and maybe other objects... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: exp/imp unable to create unix index
Were the tables (Where you imported / PROD ) EMPTY ??? What is the version of ORACLE that you are using ?? Is this constraint ENABLED in TEST (From where you exported).. ?? Check.. chances are that it is disabled there.. HTH Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 09:40 AM > Hi gurus > > I had oracle1452 when imp/exp database from test to prod databases. > > I have no idea why but found out from both imp and exp log that record > exp/imp is the same while unique index still exist in test database > >exporting tablePA_PROJECTS_ALL 3160 rows exported >importing table "PA_PROJECTS_ALL" 3160 rows imported > > exporting tablePO_VENDORS 57688 rows exported > importing table "PO_VENDORS" 57688 rows imported > > Why, any idea? > > Mitchell > > This is the log from imp. > > > IMP-00017: following statement failed with ORACLE error 1452: > "CREATE UNIQUE INDEX "PA_PROJECTS_U3" ON "PA_PROJECTS_ALL" ("NAME" ) > PCTFRE" > "E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS > " > "1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL > D" > "EFAULT) TABLESPACE "PAX" NOLOGGING" > IMP-3: ORACLE error 1452 encountered > ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found > > > IMP-00017: following statement failed with ORACLE error 1452: > "CREATE UNIQUE INDEX "PO_VENDORS_U2" ON "PO_VENDORS" ("VENDOR_NAME" ) > PCTFR" > "EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144 > MINEXTENT" > "S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 > BUFFER_POOL" > " DEFAULT) TABLESPACE "POX" NOLOGGING" > IMP-3: ORACLE error 1452 encountered > ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mitchell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Init.ora Compabible Setting
Well, if you are using any functionality related to 8.1.0 then leave it as it is.. or atleast boost it up to 8.1.5 or 8.1.6 .. This will enable your DROP COLUMN too.. As might have been suggested.. Higher the better. if you are not using anything related to previous version. Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 06:30 AM > My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? > > Thanks, > Ken Janusz, CPIM > Database Conversion Lead > Sufficient System, Inc. > Minneapolis, MN > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cannot Drop Column
-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Re:Problem with DYNAMIC SQL
Hi, Assign CREATE TABLE statement to a variable and then issue EXEC SQL EXECUTE IMMEDIATE This should work HTH Bye Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 06:30 AM > Ehsan, > > I don't think so. In the case you've listed the better way would be to do: > > EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4)); > > The use of EXECUTE IMMEDIATE is more suited to statements that are being > dynamically created on the fly. This one is not. > > Dick Goulet > Pro*C Evangelist > > Reply Separator > Author: ehsan sinavalda <[EMAIL PROTECTED]> > Date: 12/5/2001 5:05 AM > > Hello > > As I found in proc docs the following statement should > work properly: > > EXEC SQL EXECUTE IMMEDIATE > "CREATE TABLE dyn1 (col1 VARCHAR2(4))"; > > But when I want to compile a PROC prog. that has the > above stmt in a function I recevive the following > compile error: > > sample1.cc: In function `void test()': > sample1.cc:1313: break statement not within loop or > switch > > Could someone pls help me resolving this problem? > > Thanks > > E. > > > __ > Do You Yahoo!? > Buy the perfect holiday gifts at Yahoo! Shopping. > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ehsan sinavalda > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: PATCH confirmation
How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 12:10 PM > yes > > Seema Singh wrote: > > > > Hi > > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0 right? > > thanks > > seema > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dennis M. Heisler > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Pull NEXTVAL thru a DB_LINK
Grant select on SEQ. to the user that you have used to create DB_LINK.. and then it should work.. GRANT SELECT ON some_seq to ; Have fun.. HTH Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 11:20 AM > Is there any way to get the next value of a sequence via a db_link. > > I tried > > select some_seq.nextval from dual@db_link > > but it told me the sequence didn't exist. I went to the database where the > sequence exists and, using the userid that is in the db_link, I was able to > get the next value, so it isn't a permissions problem. Do I have the wrong > syntax or is it just not possible? > > TIA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Constraint Enable/Disable
with import you can give CONSTRAINTS=N Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 08:50 PM > I am trying to import data into a database, but it keeps skipping rows > because of constraints. So I want to disable the constraints, import the > data and then enable the constraints again. > > Can I do this? or is there another way to go about it? > > Thanks > > -Original Message- > Sent: Friday, 2 November 2001 3:30 PM > To: Multiple recipients of list ORACLE-L > > > Namaskar !! > > alter table table_name disable constraint cons_name; > you could generate sql's to generate these .. > > select 'alter table '||table_name||' disable constraint > '||constraint_name||';' > from all_constraints > where constraint_type in ('C','R') > / > > later you could replace the DISABLE with ENABLE and .. > > regards > > > > > -- > > From: Sujatha Madan[SMTP:[EMAIL PROTECTED] ] > > Reply To: [EMAIL PROTECTED] > > Sent: Friday, November 02, 2001 11:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Constraint Enable/Disable > > > > Hi, > > Is there a way to disable all constraints, and then enable them all again? > > Thanx > > Sujatha > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Sujatha Madan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Constraint Enable/Disable
Hi, Hope these script will help you.. Disable Constraints.. select 'alter table &tab disable constraint '||constraint_name||' cascade;' from dba_constraints where owner = upper('&owner') and table_name = upper('&tab') / Enable Constraints select 'alter table &tab enable constraint '||constraint_name||';' from dba_constraints where owner = upper('&owner') and table_name = upper('&tab') / Try these in your test environment.. and have fun Nikunj Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Sujatha Madan To: Multiple recipients of list ORACLE-L Sent: Thursday, November 01, 2001 08:15 PM Subject: Constraint Enable/Disable Hi, Is there a way to disable all constraints, and then enable them all again? Thanx Sujatha
Re: ORA-04031
Are you using MTS ? If yes, try and increase LARGE_POOL_SIZE Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 03:25 PM > Hi, > > we are running batch job executing following statement in a loop about 1 > million iterations: > select sysdate from dual... > we are getting error ora-04031 unable to allocate 2400 bytes in shared > pool.. > and when we check the sys tables it is showing same number of pare call as > executions. > why oracle is trying to parse this statement every time.. > this is the only job running and user connected at this time... > > Thanks > -Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: CURSOR_SHARING = FORCE ques. - OCP Certification
Title: CURSOR_SHARING = FORCE ques. 9i has come up with cursor_sharing = similar, which was missing till 8i. We had FORCE and EXACT. FORCE was not what most of the DBA's were willing to use. and hence used EXACT. But similar will do most of the job (Assumed) that we were looking with CURSOR_SHARING. - Original Message - From: Fowler, Kenneth R To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 03, 2001 08:50 AM Subject: OT: RE: CURSOR_SHARING = FORCE ques. - OCP Certification Why is it that people seem to have the need to apologize after admitting that they are OCP certified (or are working toward the goal etc). I know that there are a lot of differing opinions regarding OCP and what it may or may not tell you about a particular individual, but, if your company is willing to pay for you to pursue this then it is always (IMO) a good idea! After all, it hopefully will provide you with some incentive to pick up some manuals and perhaps mess with a test database and learn some new stuff. Just how could this be a bad thing? Ken. PS. I would rather be caught with an OCP certification than be caught driving a tan minivan any day! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 6:33 PMTo: Multiple recipients of list ORACLE-LSubject: CURSOR_SHARING = FORCE ques. Gurus Well the boss is now getting on my back for me to upgrade my OCP to 8i. I know, I know, I wasn't going to, please don't flame me, but work is insisting that I do. So now I'm studying the upgrade book and it's sparked up a couple of questions regarding cursor_sharing = force. 1) I've heard a bunch of negative things (like bugs) regarding using this feature, was this just with 8.1.6 or is it still buggy? 2) Anyone out there using it? Does it give that much better performance gains? It seems to me like it's not worth implementing. 3)Can the guys playing with 9i out there verify if this is buggy in 9i? Thanks to all. Ivan Rivera LEGAL NOTICEUnless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.