RE: building a reporting database
Hi All,I have been working with client, where the refresh of the reporting instance is happening every 12 hrs due to business needs. This process is very well defined and the users are very happy. Even the concurrent requests are xfr to new reporting instance. I would take it offline and the process in fully driven by scripts and one good point is that we can continue from the point where it failed. - Original Message - DATE: Tue, 18 Nov 2003 04:59:25 From: "Nelson, Allan" <[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Cc: We are working a SharePlex project from Quest. For our purposes (Financials) with heavy adhoc (Cognos) we need to stay as close as possible to the production instance. The advantage to SharePlex is that it is a log miner and hence does not do a lot of sql against the source database. It is near real time. Since this is not an Oracle product perhaps offline would be a better place to discuss it. One disclaimer, we are still in implementation and are not currently in production. Allan -Original Message-From: Sai Selvaganesan [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: building a reporting database hi i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good. - using aq and dq message processing - using snapshot replication - using ro standby databases. the last one will lag in data since standby database caanot have any archival log applied when opened in read only. is there any other good method to do this . my database is on 8.1.7.4 thanks sai __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail
Re: procedure/function error
declarea varchar2(20); b:=varchar2(20):='gali'; begin a:=EMP_SEL(b); dbms_output.put_line(a); end;
You cannot call the functions like this, only procedures can be.Venkat
- Original Message -
DATE: Fri, 06 Jun 2003 03:35:11
From: purushottam krishna hegde <[EMAIL PROTECTED]>
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Cc:
hi all,
this is purushottam hegde from Bangalore(IND)
i am relatively new to oracle and so to this group.
iam having a problem with function...
it goes like this.
SQL> CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2) return varchar2 is 2 resex varchar2(3); 3 Begin 4 SELECT sex into resex from emp where name=ename; 5 return(resex); 6 END; 7 /
Function created.
SQL> EXECUTE EMP_SEL('gali');BEGIN EMP_SEL('gali'); END;
*ERROR at line 1:ORA-06550: line 1, column 7:PLS-00221: 'EMP_SEL' is not a procedure or is undefinedORA-06550: line 1, column 7:PL/SQL: Statement ignored
pl help me in this regard
thanking all of u
purushottam hegde
Do you Yahoo!?Free online calendar with sync to Outlook(TM).Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail
Re: Whose function is executing.
chk in V$access table -- On Tue, 01 Apr 2003 06:43:36 Chaim.Katz wrote: > >Hi, >Is there a way to see whose function a user is executing? > >Development and production schemas exist on the same database and both >accounts have granted object privileges to the user roles. (I think public >synonyms are being used). I'm wondering if there is a way to check that a >user is executing x's procedure. Is this available in a trace? > >Thanks for any help. >chaim > > > >-- >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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: PGA
where can one find the other myths about oracle? Venkat -- On Mon, 31 Mar 2003 06:18:35 Connor McDonald wrote: >Oracle Myth #1745 > >"When u set the sort_area_size for a database, it will >allocate that much memory PER USER for any sort >operation being performed on the database" > > > > --- "SARKAR, Samir" ><[EMAIL PROTECTED]> wrote: > >Arvind, >> >> When u set the sort_area_size for a database, it >> will allocate that much >> memory PER USER >> for any sort operation being performed on the >> database. In practice, it >> means that if u allocate >> too high a value for the sort_area_size and multiple >> users are performing >> multiple sorts, the Unix >> system may run out of memory and Oracle will return >> u a process memory >> error. >> >> For eg. if u have ur sort_area_size as 100MB and u >> have 10 users performing >> sort operations >> on the database, Oracle will take up 100*10 MB >> memory. This might degrade ur >> system performance. >> >> Samir >> >> Samir Sarkar >> Oracle DBA >> SchlumbergerSema >> Email : [EMAIL PROTECTED] >> Phone : +44 (0) 115 - 957 6028 >> EPABX : +44 (0) 115 - 957 6418 Ext. 76028 >> Fax : +44 (0) 115 - 957 6018 >> >> >> -Original Message- >> Sent: 31 March 2003 11:04 >> To: Multiple recipients of list ORACLE-L >> >> >> hello all, >> >> how does increasing the value of SORT_AREA_SIZE >> affect the unix system >> perfomance. >> >> >> Thanks >> Arvind >> -- >> Please see the official ORACLE-L FAQ: >> http://www.orafaq.net >> -- >> Author: Arvind Kumar >> 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). >> >> >> >_ >> This email is confidential and intended solely for >> the use of the >> individual to whom it is addressed. Any views or >> opinions presented are >> solely those of the author and do not necessarily >> represent those of >> SchlumbergerSema. >> If you are not the intended recipient, be advised >> that you have received >> this email in error and that any use, dissemination, >> forwarding, printing, >> or copying of this email is strictly prohibited. >> >> If you have received this email in error please >> notify the >> SchlumbergerSema Helpdesk by telephone on +44 (0) >> 121 627 5600. >> >_ >> >> -- >> Please see the official ORACLE-L FAQ: >> http://www.orafaq.net >> -- >> Author: SARKAR, Samir >> 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). >> > >= >Connor McDonald >web: http://www.oracledba.co.uk >web: http://www.oaktable.net >email: [EMAIL PROTECTED] > >"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" > >__ >Yahoo! Plus >For a better Internet experience >http://www.yahoo.co.uk/btoffer >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED]
Re: MetaLink on the blink
Jared, SQL-Slammer Virus may be. DBA's don't Panic -- On Thu, 27 Feb 2003 16:04:07 Jared.Still wrote: >It appears that MetaLink has just taken a dive. > >Anyone else notice, or is it just me? > >Maybe I'll try another site. > >Jared > >-- >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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: MetaLink on the blink
Jared, SQL-Slammer Virus may be. DBA's don't Panic -- On Thu, 27 Feb 2003 16:04:07 Jared.Still wrote: >It appears that MetaLink has just taken a dive. > >Anyone else notice, or is it just me? > >Maybe I'll try another site. > >Jared > >-- >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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: Jinitiator/proxy servers
Hi, I also faced the similar type of problem. So we changed the settings in Browser from automatic setting to manual proxy settings. some times Jinitiator will not read the PAC file used for proxy settings. That's the reason. HTH Venkat -- On Mon, 03 Feb 2003 21:48:40 Seley, Linda wrote: >This question is Discoverer/Jinitiator/Internet related but I'm hoping >someone has a suggestion > >We have Discoverer Plus 4i available to our clients through the >Internet. Most of them can download Jinitiator (1.1.8.11) and run >Discoverer without a problem (once their firewall is open). One of our >clients uses proxy automatic configuration (PAC) files, their PCs are >locked down and are not able to access the Internet directly. They can >download and install Jinitiator off our web site. In the Java Console >the proxies tab is set to 'Use browser settings'. When they try to run >Discoverer it attempts to connect to our server instead of going through >their proxy servers. This direct connection causes Discoverer to fail. > > >Any idea how we can fix the problem on our end? I assume we can't hard >code a proxy server (i.e. http_proxy) since it's not our's. We can't >make any changes that would affect other clients (different web pages, >Jinitiator versions, etc. may be possible). Would an upgrade of >Jinitiator help? Unfortunately I haven't been able to find anything >useful on Metalink or on the Internet. > >TIA > >Linda >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Seley, Linda > 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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: Trace File Full
Pls refer to note 105112.1 in metalink. -- On Thu, 30 Jan 2003 23:38:42 Hussain Ahmed Qadri wrote: >Hi all, > >We run an automated script for taking database backups. A third party tool >is used to call the script which runs the export commands. The problem that >we are facing is that when ever the script runs, it fails with the following >error >ORA-00600: internal error code, arguments: [17182], [1126948216], [], [], >[], [], [], [] > >When i checked the alert logfile, it pointed out an error in a trace file, >S000 and S001, along with the same Internal error code message. When I >checked the Trace files they both bore the message several times, > >* TRACE FILE FULL * > >I truncated the trace files, but I am not sure if thats the right way. And >still that command doesn't run. >Are these two things related? and what is the way out of this > >Regards, > >Hussain > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: Error Stack
Hi, Restore the corrupted datafile from Backup and start the DB. Pls check the Alert.log for more info. Venkat -- On Thu, 30 Jan 2003 19:38:46 shuan.tay(PCI¾G¸R³Ô) wrote: >Dear DBAs, > >My DB was down just now. >after checking the trace file, it was an CKPT error 1242, >using oerr will show: >"Cause: The database is in NOARCHIVELOG mode and a database file was >detected as inaccessible due to media failure." > Action: Restore accessibility to the file mentioned in the error stack > and restart the instance." > >What's the error stack means in the "Action"? >where can i find it? > >Thanks in advance. _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: OEM 4
Hi All, This new OEM is going to be named as Mozart. fully web complaint. As mentioned earlier, this tool is ideal for DBA's and IT Manager's for setting SLA's and other Stuff. This is under Q&A. Will be released shortly. Thanks, Venkat -- On Fri, 24 Jan 2003 10:43:54 Gogala, Mladen wrote: >And they have an "Instant PHB" feature, too. > >> -Original Message- >> From: Jesse, Rich [mailto:[EMAIL PROTECTED]] >> Sent: Friday, January 24, 2003 11:34 AM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: OEM 4 >> >> >> Why isn't this press release on Oracle's sites? I also >> wonder why there's >> no info (even a lame "Contact your salespersons") on how to >> actually obtain >> the product. >> >> The "Manager-2-Go" feature sounds useful. I wonder... >> >> Rich >> >> >> Rich Jesse System/Database Administrator >> [EMAIL PROTECTED] Quad/Tech International, >> Sussex, WI USA >> >> -Original Message- >> Sent: Friday, January 24, 2003 7:12 AM >> To: Multiple recipients of list ORACLE-L >> >> >> Oracle just posted an item, they announced the next version >> of the OEM. >> http://196.30.226.221/sections/enterprise/2003/0301240730.asp? >A=TES&S=Softwa >re%20Testing&T=Section&O=FPSH > >I checked on OTN, nothing is available for download there. > >Patrice Boivin >Systems Analyst (Oracle Certified DBA) >Systems Admin & Operations | Admin. et Exploit. des systèmes >Technology Services| Services technologiques >Informatics Branch | Direction de l'informatique >Maritimes Region, DFO | Région des Maritimes, MPO >E-Mail: [EMAIL PROTECTED] >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jesse, Rich > 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: Gogala, Mladen > 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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: Help on DBMS_PROFILER required
Satya, pls grant the privileges from sys to the user running the DBMS_PROFILER package Venkat -- On Thu, 23 Jan 2003 03:59:00 Satya V Prakash wrote: >Hi, >I need to use the DBMS_PROFILER package for PL/SQL >in between the procedures. I used the corresponding script located >in >Oracle_home\rdbms\admin\PROFLOAD.sql . >I ran this script, it ran without any problems. >But I am still unable to invoke the DBMS_PROFILER package, > >The error is > >Identifier DBMS_PROFILER.START_PROFILER must be declared >ORA-06550 >PLS-00201 > >Any help in this regard would be highly appreciated. > >Thanks and Regards, >Satya Prakash > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Satya V Prakash > 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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: Need an Oracle Check List
There is a checklist available in http://www.oradb.net/book/dbachecklist.pdf HTH Venkat -- On Mon, 20 Jan 2003 07:39:34 KENNETH JANUSZ wrote: >Dennis: > >Thanks very much for the suggestions. They will help me a lot. I have been >working on the position for about two months now. It has everything I >want - Oracle DBA, manufacturing, large company, and only 14 miles from my >home. > >I will be working for a small IT company but be on-site at their client. I >should be signing my contract later this week and go to the client site next >Monday to start learning from the departing DBA who is going on to another >project. The position will be contract-for-hire. > >I'll be able to say who it is after I sign my contract. > >Ken >Hugo, MN > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Monday, January 20, 2003 8:49 AM > > >> Ken - Be sure to ask for the system password ;-) >> Congratulations on the position. If I'm recalling correctly from your >> previous posts, this is VERY welcome. The best suggestion is one I used >> myself. At some point you'll sit down and go over the systems. That will >> take about 30-minutes to 1 hour. You probably won't understand but a small >> portion of the statements because it will all be new to you. Take a small >> cassette recorder and record (with permission) the discussions of the >> systems you will be taking over. Then that night play the tape back and >type >> up the conversation word-for-word. Then go over the transcript and make a >> list of questions for the departing DBA. Then the next day ask about any >> points that weren't clear when you reviewed the tape. In previous >positions, >> everything would seem clear at the time but the next day I would be pretty >> hazy on the details. I used a tape recorder on my last job changeover and >> didn't miss a thing. >> >> Some other questions >> 1. Which people are most critical to my success in this position? >> 2. What issues are the most important? >> 3. What issues regularly arise which impact the quality of the systems? >> 4. What areas do I need to learn more? >> >> >> >> Dennis Williams >> DBA, 40%OCP >> Lifetouch, Inc. >> [EMAIL PROTECTED] >> >> -Original Message- >> Sent: Sunday, January 19, 2003 9:04 PM >> To: Multiple recipients of list ORACLE-L >> >> >> It appears that I will be taking over an Oracle production DBA position in >> about a week from another DBA. I would like suggestions as to >specifically >> I should be looking for from this person. Something like a check list. >> Items that I need to specifically look at. >> >> Thanks, >> Ken Janusz, CPIM >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: DENNIS WILLIAMS >> 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: KENNETH JANUSZ > 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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: AW: Info about running procs
Thanks for the pointer, it was a good script. Venkat -- On Wed, 15 Jan 2003 02:09:15 v.schoen wrote: >Thanks, > >this is what I'm looking for. > >regards > >Volker Schoen >E-Mail: mailto:[EMAIL PROTECTED] >http://www.inplan.de > > > >-Ursprüngliche Nachricht- >Von: Reardon, Bruce (CALBBAY) [mailto:[EMAIL PROTECTED]] > >Gesendet: Mittwoch, 15. Januar 2003 02:54 >An: Multiple recipients of list ORACLE-L >Betreff: RE: Info about running procs > > >Take a look at Steve Adam's >http://www.ixora.com.au/scripts/sql/executing_packages.sql > >"This script lists the packages (and other stored code objects) that are >currently being executed, and the SIDs of the executing sessions. " It is >listed as for 8.0 / 8.1 > >Remember to check out the prerequisites at >http://www.ixora.com.au/scripts/prereq.htm > >HTH, >Bruce Reardon > >-Original Message- >Sent: Wednesday, 15 January 2003 7:29 AM > >> [EMAIL PROTECTED] wrote: >> >> Hi list, >> >> I'm looking for a Oracle system view or table where I can see all >> actual running procedures. Where can I find this info. >> >> TIA >> >> Volker Schoen >> E-Mail: [EMAIL PROTECTED] >> http://www.inplan.de > >I think that a join between v$session (where status = 'ACTIVE') and x$kglrd >should do it (join SQL_ADDRESS + SQL_HASH_VALUE to kglrdhdl + kglnadhv). You >need to be SYS of course, so perhaps you'll want to create a view. >Author: Stephane Faroult >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Reardon, Bruce (CALBBAY) > 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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: moving from unix to NT
Hi John, We did the reverse way ie from NT to unix we migrated. Basically, take care of the path ie '/' to '\' in UTL_FILE. Re-compile and create the DLL in NT. Then recreate the library associated with the DLL. Jobs will run fine. But make sure you re-submit them, HTH Venkat -- On Mon, 25 Feb 2002 08:43:21 John Dunn wrote: >We are contemplating moving our application from Unix to NT. The main things >that concerm me are where our application interfaces with the OS, via a C >external procedure, and also via UTL_FILE. Also, can I expect DBMS_JOB to >work OK? > >Anyone got experience of porting this sort of functionality to NT? > >John > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: John Dunn > 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: C.S.Venkata Subramanian 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: my boss wants a report !!!
It is also one of the management lessons that other fellow listers must learn -- On Thu, 14 Feb 2002 21:43:16 Khedr, Waleed wrote: > Any plans for layoff?! > >-Original Message- >To: Multiple recipients of list ORACLE-L >Sent: 2/14/02 11:13 PM > >list, >the management has asked me to report the activities i do to make sure >that all the DB's are in perfect health.!! Without being technical the >report >should somehow show the status of the DB's . > >I have decided to devide the report into the following sections > >- performance > how to show the performance of the DB ??? without using any >stats . > >- storage > occupied / available > >- security > unauthorized access > >- backup and recovery > > status of the hot standby database. > > >could anyone point out some more information to include showing the >"performance" of the DB ? > >Regards > >Rahul > > >-- >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: Khedr, Waleed > 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). > Check out Cupid School where you will learn from Matchmaker's best and brightest. Good Luck! http://ecard.matchmaker.com/cupid0202/cupid0202.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Import error from 8.1.7.2.0 to 8.0.5
Pls read the Oracle utilities manual,One cannot import the higher version of dump into a lower version of Oracle. You need to run the catexp7.sql in $ORACLE_HOME/rdbms/admin dir in the server to create the export views compatible with lower version of Oracle. Moreover when you post any message in future,pls tell the operating system in which you are trying the same. HTH Regards Venkat -- On Wed, 13 Feb 2002 00:38:21 Pradyut_Mitra wrote: >Hi All, > >I am trying to export a table from one Oracle db (Version 8.1.7.2.0) and >import into another Oracle db (Version 8.0.5) and I have got the following >error during import- > >IMP-00069: Could not convert to environment national character set's >handle >IMP-00021: operating system error - error code (dec 2, hex 0x2) >IMP-0: Import terminated unsuccessfully > >Request your help/suggestion on the above. > >Thanks in advance. > >PM Go Get It! Send FREE Valentine eCards with Lycos Greetings http://greetings.lycos.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Tkprof.
Ayyappan -->RTFM -- On Mon, 04 Feb 2002 22:15:19 Rajesh Dayal wrote: >Just type tkprof on command line (DOS) or on shell prompt (UNIX), > >You would find the help and all your doubts would be cleared. > >HTH, >Rajesh >-Original Message- >Sent: Tuesday, February 05, 2002 9:15 AM >To: Multiple recipients of list ORACLE-L > >Hi all > >I am having a doubt in how to use Tkprof. > > >This communication contains information, which is confidential and may also >be privileged. It is for the exclusive use of the intended recipient(s). If >you are not the intended recipient(s), please note that any distribution, >printing, copying or use of this communication or the information in it is >strictly prohibited. If you have received this communication in error, >please notify the sender immediately and then destroy any copies of it. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ayyappan S > 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: Rajesh Dayal > 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: C.S.Venkata Subramanian 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: webdba from BMC
hi, I used it, good tool for starters, venkat -- On Thu, 24 Jan 2002 06:05:20 Jeffrey Beckstrom wrote: >I was looking at their site today and came across a free product called WEBDBA. Any >opinions on it. > > > >Jeffrey Beckstrom >Database Administrator >Greater Cleveland Regional Transit Authority >1240 W. 6th Street >Cleveland, Ohio 44113 >(216) 781-4204 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Backup Strategy
051 >> > > > 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). >> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >> > > > This e-mail was scanned by the eSafe Mail Gateway >> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >> > > >> > > -- >> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com >> > > -- >> > > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= >> > > 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: grace >> > 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: Joan Hsieh >> 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: Bunyamin K. Karadeniz > 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: C.S.Venkata Subramanian 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: DBA Vs Apps DBA
ed to know what's allowed and what's not - a wrong step can >mess up the whole thing and take you out-of-support. Depending on the >organization and the role, you may also be performing critical work during >period closes (monthend/quarter or year end) as well as SysAdmin stuff. >Going into an Apps situation with both guns blazing can have dire >consequences, maybe not immediately, but certainly at period-closes or >upgrades when it falls apart. There is a lot more to it, such as Printer >configuration, Self-Service Web apps setup, etc. that I have't touched upon >- it would take a separate book to get it all out (Hint : Someday, maybe!). >Tuning, in many cases, is simply a search for Apps patches on Metalink, >followed by escalation to Oracle Support via iTARs if required, as you >cannot change the Application directly. > >My advice : Typically, the number of users connected, the data size and the >complexities brought on by the Concurrent Manager, patching, etc., coupled >with Global access and the dependency of the Business on this single >instance can be overwhelming, esp. if you are new to the Apps DBA world. Do >NOT attempt to be the ONLY Apps DBA in the organization, or jump into it >without understanding the whole process. Bring in an *experienced* outside >consultant that knows Apps to help you over the initial curve, or be a >junior part of the Apps DBA team in case it is already there (even if you >have more 'normal' DBA experience than the rest combined!). Resist >management pressure to act as the Functional person (this happens when the >organization takes on Apps for the first time) - this is an entirely >separate role. And READ - tons of additional reading. Creating a 'play' Apps >system is not an option as a lot of functional setup is required. If you are >well read and can appreciate the points noted above, and are able to >convince someone that you have the qualities required to start up, then go >for it! > >This is from more than a year's worth of 'Apps DBA' experience after having >been a 'normal' DBA for more years than I can remember. Sorry if this sounds >very complex - it IS! > >Hope this helps. >John Kanagaraj >Oracle Applications DBA >DBSoft Inc >(W): 408-970-7002 > >Fear is the darkroom where Evil develops your negatives. >Wanna break free of fear? Click on 'http://www.needhim.org' > >** The opinions and statements above are entirely my own and not those of my >employer or clients ** > > >> -Original Message- >> From: C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]] >> Sent: Monday, January 21, 2002 12:15 AM >> To: Multiple recipients of list ORACLE-L >> Subject: OT:DBA Vs Apps DBA >> >> >> Hello Listers, >> Can any one tell me, what is the basic difference between a >> "DBA" and an "Apps DBA", what additional tasks an Apps dba >> has to do than compared to a normal dba. >> >> Secondly what will be career prospective of a Support DBA in >> the long run. >> >> Pl enlighten me. >> >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: C.S.Venkata Subramanian >> 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: John Kanagaraj > 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: C.S.Venkata Subramanian 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: Export 7.3.4 / Import 8.1.7?
Hi Ron, It is possible, you will not face any problem. Regards venkat -- On Mon, 21 Jan 2002 00:50:17 Arslan Dar wrote: >Hi smith ! > >I haven't done it but in my opinion, there should be no problem, but >anyways, the best way to find out is to try it!! > > > >Arslan Zaheer Dar >[EMAIL PROTECTED] >Database Administrator >Shaukat Khanum Memorial Cancer Hosptial & Research Centre >www.shaukatkhanum.org.pk > > >-Original Message- >Sent: Saturday, January 19, 2002 12:57 AM >To: Multiple recipients of list ORACLE-L > >Can I do a full export from 7.3.4 and then do a full import into 8.1.7? > >Ron Smith >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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: C.S.Venkata Subramanian 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).
OT:DBA Vs Apps DBA
Hello Listers, Can any one tell me, what is the basic difference between a "DBA" and an "Apps DBA", what additional tasks an Apps dba has to do than compared to a normal dba. Secondly what will be career prospective of a Support DBA in the long run. Pl enlighten me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Codde's Rules and Oracle
Hi, V7 confirmed to 11 rules,except for the view updation rule, i feel this was solved in v8. Other comments from other listers are welcome. Venkat -- On Fri, 18 Jan 2002 02:30:29 Vikas S wrote: > >Dear All, > > Does Oracle confirm to all 12 Codde's Rules. Can anyone >point out the Rules violated by each version (6/7/8/9) of Oracle. > >Thanks, >Vikas > > > >_ >Chat with friends online, try MSN Messenger: http://messenger.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Vikas S > 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: C.S.Venkata Subramanian 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: SAME, WAFL and RAID
May I please have a copy of this paper? Thanks >-Original Message- >Sent: Wednesday, January 16, 2002 00:38 >To: Multiple recipients of list ORACLE-L > > >Hi, > >WAFL is Write Anywhere File Layout... > >Its the file lay out used by snapshot supported storege Devices(NetApp >Storege Etc), This is completely different from a RAID. A RAID is a system >which may or maynot be h/w controlled. But WAFL is the Low level file layout > >of the Storege system. In any one wants i hv the paper or Hutchinston with >me on WAFL which i can give u > >Regards > >OraEtM!! > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Database Comparison
Hi Boivin and Fellow Listers, I have been using Oracle change manager to compare the two diff databases and 2 diff schemas for quite some time. Basically I use it compare prodcution and development and test databases/schema.The initial setup is little bit tedious. First a repository has to be created in a seperate machine, and then using the discovery wizard we have to discover the nodes. We must make sure that Oracle agent is up and running in the target m/c. After that we have to launch the console and to be frank with you I have not got into the small details of display, but I feel this tool is quite easier. The major hurdle I faced is when applying the changes of one schema to another. Change manager will generate the change scripts, this is generated in TCL/TK. So one must be familiar with these also. Also if any errors are encountered this scripts halts and also this script deletes any data and referential integrity constraints. So I generate the required reports and do the changes manually either in SQL*Plus. I also keep a log while doing the changes. Best Regards Venkat -- On Thu, 10 Jan 2002 05:25:21 Boivin, Patrice J wrote: >I've had some problems with the Change Manager. > >For some databases it doesn't "see" any of the objects that would fall in >the last few item categories in the navigator pane on the left - including >tablespaces. > >There is a bug with the JVM, sometimes the Oracle Java tool colours go >beserk (fluorescent) and in one occation the window positioning was >completely off. I use 1024x768 desktops on some NT servers. Sometimes the >whole graphic column that shows checkmarks or crosses in comparison reports >appears in the upper left corner of the screen instead of where it should >be. These are probably all related to the same "known bug" for the JVM >display functions. > >The reports also are extensive, I don't know if it is possible to tell >Change Manager to only put in reports just the information you want. >Internet browsers are not happy with HTML files that are megabytes in size, >they take a long time to load. > >The Change Manager is faster if run on the console holding the repository >than from a remote client. I recommend running it from the OEM repository >console if at all possible, to avoid network trips as the Change Manager >stores information into the repository. There will be enough networking >going on with it comparing two remote systems. > >Would anyone care to share tips on how to use Change Manager appropriately? >Did you find any problems with Change Manager, are there any differences it >did not catch? > >Regards, >Patrice Boivin >Systems Analyst (Oracle Certified DBA) > >Systems Admin & Operations | Admin. et Exploit. des systèmes >Technology Services| Services technologiques >Informatics Branch | Direction de l'informatique >Maritimes Region, DFO | Région des Maritimes, MPO > >E-Mail: [EMAIL PROTECTED] > > > -Original Message- >Sent: Thursday, January 10, 2002 1:20 AM >To:Multiple recipients of list ORACLE-L >Subject: Re: Database Comparison > > Srini, >Use the change manager that comes with Oracle Enterprise manager. The >initial set-up is little bit difficult. But once u r through, then it is an >handy tool. >Venkat >-- >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Boivin, Patrice J > 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: C.S.Venkata Subramanian 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: Database Comparison
Srini, Use the change manager that comes with Oracle Enterprise manager. The initial set-up is little bit difficult. But once u r through, then it is an handy tool. Venkat -- On Wed, 09 Jan 2002 11:00:36 Paul Baumgartel wrote: >There's a very good script available at http://www.dbspecialists.com. > >--- [EMAIL PROTECTED] wrote: >> Hi: >> >> I need to compare my Production database with QA database. I would >> like to >> generate a report that shows differences in schemas across these two >> databases(tables, indexes, views, object definition, etc..). I >> would >> appreciate it if you could forward me a script that would accomplish >> this or >> any websites where I can find one. >> >> Thanks >> >> Srini Rajendran. >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >__ >Do You Yahoo!? >Send FREE video emails in Yahoo! Mail! >http://promo.yahoo.com/videomail/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paul Baumgartel > 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: C.S.Venkata Subramanian 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: Management Server
Chk for the username and password. Or else try creating the repository after dropping the same. Venkat -- On Wed, 09 Jan 2002 15:56:26 shuan wrote: >good day, DBA... > >i'm now self-learning Oracle 8.1.6 Enterprise Edition. >using Oracle8.1.6 on Win2000 Advance Server, >and the Oracle Management Server also in the same machine. >after i faced the problem of ORA-12638 when attempt to login, >the Management Server failed to run.(even the Service). >now the error ORA-12638 is fixed by changing a line in sqlnet.ora. >yet i still cant start the Management Server Service. >when i check the "Event Viewer", it say, > >The service has terminated abnormally. See the file >D:\Oracle\PODB\sysman\log\OMS.log for details. > >and this: > >No login credentials were provided. The service cannot start. > >so, what's wrong with this? >pls help. > >thanks and hav a nice day. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Kernel parameters (Sun Solaris)
Ref to installation guide supplied with Oracle software. All the required and necessary parameters are given with good explanations. HTH Venkat -- On Tue, 08 Jan 2002 22:35:21 ALEMU Abiy wrote: >Hi guys, > >Is there any guide line or documentation which gives values of OS kernel >parameters for Oracle ? What are the recommended values for n instances on >which we have p processes and u users each ? > >Thanks a lot >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: ALEMU Abiy > 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: C.S.Venkata Subramanian 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: Unix - script
Use unix utility ftp to copy file between 2 mc's or use rcopy. For more details refer to man pages. -- On Tue, 08 Jan 2002 23:15:35 Roland.Skoldblom wrote: >Hallo, > >I would like to have an example of a unix script, which does the following: > >copy some files from directory /prod/sas/data located at "hardy".(which is a >computer) >to the other database hakon. Is it possible to do this. Please help me quick. > > >Thanks in advance > >Roland S > >-- >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: C.S.Venkata Subramanian 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: Oracle 9i Real Application Cluster Concepts manual.
use this url, it contains all the manual of 9i http://download-eu.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm HTH Venkat -- On Tue, 08 Jan 2002 22:25:19 Sathish Tatikonda wrote: >hi all, > >if any of you has Oracle 9i Real Application Cluster Concepts manual >softcopy could you please pass it on to me. Alternately if any of you >could provide pointers from where i can download this manual will also >be of great help. > >thanks in advance, >Sathish. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sathish Tatikonda > 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: C.S.Venkata Subramanian 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: Oracle Future???
If this is true, then there will be a massive unemployment in the whole world.
Venkat
--
On Tue, 08 Jan 2002 07:30:39
April Wells wrote:
>YOU too? Although, I guess it is the Evil DB2 voices who have been talking
>to me, not the Mysql ones...
>
>-Original Message-
>Sent: Tuesday, January 08, 2002 8:50 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Uh Oh ... I thought I was the only person to whom the little voices talk to
>... Damn ... there is one more ...
>
>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: Tuesday, January 08, 2002 9:25 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi Folks,
>Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of
>emails from a MSSQL mailing list, they were discussing the future of MSSQL.
>Some of the comments included comments about our DB - Oracle.
>I've added two here...
>...With Hyperion been seriously challenged and overrun by Analysis Services,
>oracle will completely die out as they integrate their current offering into
>Oracle9i.
>...Oracle will become another Apple: 5% market share. ...
>Do you guys agree? Is Oracle doing anything about the very serious threat
>that MSSQL is placing on their market share?
>No, plans of changing personally, but wondering if cross education won't be
>beneficial:)
>Regards
>Denham
>
>begin 666 InterScan_Disclaimer.txt
>M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!IM=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9OM(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%LM>2!PM:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1IM;W!Y:6YG(&]F('1H92!I;F9O2!A;GEO;F4@;W1H97(@=&AA
>M;B!T:&4@:6YT96YD960@M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@M86=E(&EN(&5RM871E;'D@8GD@7-T96US+"!)
>M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
>M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AIM(&)E96X@M:71Y(&9OM;V9T=V%R92!V:7)U6]U(&-AM(&]W;B!V:7)U%;G0N#0H
>end
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: April Wells
> 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: C.S.Venkata Subramanian
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: Import Characterset problem
- >> > 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). << >> File: ATT19805.ATT >> >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ahmed Gholam Hussain > 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: C.S.Venkata Subramanian 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: Becoming a DBA questions
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: Randy Kirkpatrick >> > 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: Dan Whatley >> 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). >> >> >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Randy Kirkpatrick >> 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: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: not using indexes
I have analysed the schema using dbms_utility -- On Thu, 03 Jan 2002 23:25:18 nlzanen1 wrote: > > >Hi, > >Tables Analyzed recently? >Indexes analyzed recently? >Histograms possibly? > > >If all else fails hints are there to force a certain execution anyway >(Oracle must have known that the CBO wasn't/isn't perfect) so just use >them. > > >Jack > > > > >"C.S.Venkata Subramanian" <[EMAIL PROTECTED]>@fatcity.com on 04-01-2002 >06:40:21 > >Please respond to [EMAIL PROTECTED] > >Sent by: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > >Dear All, >I have been entrusted to tune a web based application. This product is at >development stage. I generated the trace file and found out the indexes on >the table. So I specified hints in all the queries and tested the >application. There was a remarkable increase in performance. Can any one >tell me why we have to specify the hints in the queries, when the tables >are having index already. > >Platform: WinNT Oracle 8.1.6. Application is developed in JSP and Web >server is iPlanet Enterprise Edition. > >TIA > >Regards >Venkat > > >-- >Click here for your very own create-a-date adventure from MatchMaker >Go to http://ecard.matchmaker.com/dating.html >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: C.S.Venkata Subramanian > 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). > > > > >=== >De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor >de geadresseerde. Gebruik van deze informatie door anderen dan de >geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding >en/of verstrekking van deze informatie aan derden is niet toegestaan. >Ernst & Young staat niet in voor de juiste en volledige overbrenging van de >inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. >=== >The information contained in this communication is confidential and may be >legally privileged. It is intended solely for the use of the individual or >entity to whom it is addressed and others authorised to receive it. If you >are not the intended recipient you are hereby notified that any disclosure, >copying, distribution or taking any action in reliance on the contents of >this information is strictly prohibited and may be unlawful. Ernst & >Young is neither liable for the proper and complete transmission of the >information contained in this communication nor for any delay in its >receipt. >=== > > > > > >-- >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). > -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
not using indexes
Dear All, I have been entrusted to tune a web based application. This product is at development stage. I generated the trace file and found out the indexes on the table. So I specified hints in all the queries and tested the application. There was a remarkable increase in performance. Can any one tell me why we have to specify the hints in the queries, when the tables are having index already. Platform: WinNT Oracle 8.1.6. Application is developed in JSP and Web server is iPlanet Enterprise Edition. TIA Regards Venkat -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: A DBA's career development
Dear Andrey and other Fellow DBA's, For quite some time I have been wondering about the same fact that Andrey has thought. I started my career Oracle 7 DBA and moved on. When 8 was released, we quickly did not upgrade the db. Now when 9i is released, with so many things in it, I asked myself what will happen to the future of DBA's who are associated with Oracle as DBA's. May now it is the time that we have to shift our gears and think of something innovative and do things which are beneficial to our children. If I'm wrong in any ways, then please excuse me. Regards Venkat -- On Wed, 02 Jan 2002 07:15:23 Andrey Bronfin wrote: >Dear list ! >Having been an Oracle DBA on UNIX & win platforms for past several years, i >feel like i'd like to change something. >Don't get me wrong , i like what i'm doing , but i think it's time to expand >my horizons. >I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like >to add something to it. >I also know some system UNIX (mainly Solaris) and some development (java , >perl , pl/sql etc.) >Where would i go next ? >I'm thinking of several possible paths : > Oracle DBA + UNIX sysadmin ; > Ora DBA + developer ; > DBA of Oracle + some other DB , that i'll need to learn >Or may be it's time to move to some sort of system analysis , >datawarehousing ,ERP or ... ??? >I'm thinking about the future of the market , demand for employees in >various fields , salaries etc.. > >What would U , dear gurus , say ? What do U think about your careers / >future ? > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Andrey Bronfin > 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). > -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: database administration questions
aller paychecks as you >> pay >> your dues. >> >> BTW: A database restore usually takes a lot longer >> than >> fixing a network >> outage, >> to boot. >> >> Dick Goulet >> >=== message truncated === > > >__ >Do You Yahoo!? >Send your FREE holiday greetings online! >http://greetings.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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: Boivin, Patrice J > 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). > -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Data Archiving
Nirmal After moving the data are u planning to delete the same from the original server. In 7.3 direct=y will work. I suggest you write some pl/sql procedure or Pro*C utility that will move the data to new server whenever required based on the criteria you pass. Venkat -- On Thu, 27 Dec 2001 02:15:18 Arul kumar wrote: >Hi Nirmal, > >Export/Import sounds good for this. > >I think u can give a try with DIRECT=Y option in exp utility (for faster >export !). > >I am not sure abt this option in 7.3.. do give it a try. > >Arul. > >I am not sure abt this > >Nirmal Kumar Muthu Kumaran wrote: > >> >> >> Hi all, >> >> New year Greetings. >> >> We need to archive some history tables from the production database to >> new server. Totally around 50 history >> tables we need to move and each table having around 10 million of >> records. Some of history tables having records, which are required for >> another a year the production database, approximatedly i can say >> around 2 million of records in each table >> >> like this. >> >> So what is the best way to move these tables?. >> >> I suggested them to export/import tables and delete invalid records. >> >> But another team are planned to do it by a simple pl/sql script by >> making cursor, check validity of record, if yes insert into new server >> and then delete from production, repeat. >> >> I want to know the best way to do this job without any major >> implications. >> >> Both servers are oracle7.3.1. running on VAX/VMS. >> >> Thanks. >> >> Nirmal. > >* >Disclaimer > >This message (including any attachments) contains >confidential information intended for a specific >individual and purpose, and is protected by law. >If you are not the intended recipient, you should >delete this message and are hereby notified that >any disclosure, copying, or distribution of this >message, or the taking of any action based on it, >is strictly prohibited. > >********* >Visit us at http://www.mahindrabt.com -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Merry Christmas
Wish u the same and everyone & their family in the list a happy xmas and new year. Venkat -- On Fri, 21 Dec 2001 01:55:22 SARKAR, Samir wrote: >Hi everybody on the list !! > >Am going on my holidays today evening and shall b back in the New Year. > >Wish you all a merry and drunk (for some) Christmas and a very happy and >database problem-free New Year !! > >Samir > >Samir Sarkar >Oracle DBA - Lennon Team >SchlumbergerSema >Email : [EMAIL PROTECTED] >[EMAIL PROTECTED] >Phone : +44 (0) 115 - 95 76217 >EPABX : +44 (0) 115 - 957 6418 Ext. 76217 >Fax : +44 (0) 115 - 957 6018 > > > >___ >This email is confidential and intended solely for the use of the >individual to whom it is addressed. Any views or opinions presented are >solely those of the author and do not necessarily represent those of >SchlumbergerSema. >If you are not the intended recipient, be advised that you have received this >email in error and that any use, dissemination, forwarding, printing, or >copying of this email is strictly prohibited. > >If you have received this email in error please notify the SchlumbergerSema Helpdesk >by telephone on +44 (0) 121 627 5600. >___ > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: SARKAR, Samir > 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). > -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: PRO * COBOL
You can find the documentation in technet site http://technet.oracle.com/doc/server734.htm http://download-eu.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm HTH -- On Fri, 14 Dec 2001 01:50:18 banarasi wrote: >Hi gurus... > >My organization wants to use PRO* COBOL. > >I need to configure and guide the application programmers in compilation of >the software... > >please refer me where I can get relevent documentation... I was unable to >find it in oracle doumentation. > >expecting early replies... > >Banarasi Babu >CMC LTD > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: banarasi > 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: C.S.Venkata Subramanian 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).
ORA-06509
Dear All, In one of our development server we are encountering ora-06590 error. Oracle documentation says ICD vector error, cause says that there is a version mismatch between an Oracle product and Oracle executable. This error is occuring in a procedure that reads data from a file using UTL_FILE Package. This procedure used to work w/o any problem. Oracle ver 8.1.6 OS WinNT 4.0 with SP6. There were no major h/w or s/w upgradation in the recent past. We have not loaded any Oracle patch also. TIA Regards Venkat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
ORA-06509
Dear All, In one of our development server we are encountering ora-06590 error. Oracle documentation says ICD vector error, cause says that there is a version mismatch between an Oracle product and Oracle executable. This error is occuring in a procedure that reads data from a file using UTL_FILE Package. This procedure used to work w/o any problem. Oracle ver 8.1.6 OS WinNT 4.0 with SP6. There were no major h/w or s/w upgradation in the recent past. We have not loaded any Oracle patch also. TIA Regards Venkat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: OT: X Win client
Try xwin32 from starnet -- On Wed, 21 Nov 2001 10:15:25 Jared Still wrote: > >Yes, Xfree86. > >Just do a search on google. I use it to run Oracle >installs, so it works well enough. > >Jared > >On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote: >> Hi all! >> >> Is there any free (important: free) X client software for NT? >> >> Regards, >> Vladimir Barac > > >Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" >Content-Transfer-Encoding: quoted-printable >Content-Description: > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > 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: C.S.Venkata Subramanian 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: Fwd: Extproc problem...
Hi,
The exact command to read the contents of .so file in Unix is "nm".
The Syntax is nm
In your case it will be
nm /data1/dev/uexit/test/extproc.so > extproc.txt
This command will read the .so file and dump the contents in a text file. If you open
the text file in a standard unix editor and search for the function u are calling in
the pl/sql block.
HTH
For more clarifications pl email me.
Venkat
--
On Mon, 19 Nov 2001 08:55:18
Khedr, Waleed wrote:
>Try: ld -m /data1/dev/uexit/test/extproc.so
>
>-Original Message-
>Sent: Sunday, November 18, 2001 10:45 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>Pl use the equivalent of DLL walker of NT in Unix to find the exact name of
>the shared object that you have created. The shared object created by you
>will have some name appended during the compilation of the program. Pl use
>this name and ref the same in Oracle.
>
>HTH
>--
>
>On Sun, 18 Nov 2001 16:25:17
> Jared Still wrote:
>>
>>
>>-- Forwarded Message --
>>Date: Sun, 18 Nov 2001 22:47:09 -
>>To: "'Jared Still'" <[EMAIL PROTECTED]>
>>
>>
>>Hi Jared,
>>I am sure you can help me on this.
>>I am encountering problems to run an O/S command from a stored
>>procedure/procedure.
>>The error log is as follows...
>>SQL>create library shell_lib as '/data1/dev/uexit/test/extproc.so';
>>SQL> create or replace function sysrun (syscomm in varchar2)
>> 2 return binary_integer
>> 3 as external
>> 4 name "sysrun"
>> 5 library shell_lib
>> 6 parameters(syscomm string);
>> 7 /
>>
>>Function created.
>>
>>SQL> declare rc number;
>> 2 begin rc := sysrun('/bin/ls -l');
>> 3 dbms_output.put_line('Return Code='||rc);
>> 4 end;
>> 5 /
>>declare rc number;
>>*
>>ERROR at line 1:
>>ORA-06521: PL/SQL: Error mapping function
>>ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
>>ORA-06512: at "UEXIT.SYSRUN", line 0
>>ORA-06512: at line 2
>>
>>Could you please help on this.
>>Thanks a lot.
>>Baral
>>
>>
>>***
>**
>>This message is confidential and for use by the addressee only. If you
>>are not the intended recipient, you must not use, disclose, distribute,
>>copy, print, or rely on this message. Please notify the sender by
>>return email and then delete the message from your computer. Royal Skandia
>>accepts no responsibility for changes made to this message after it was
>>sent nor for any loss or damage from receipt or use.
>>
>>Royal Skandia Life Assurance Limited - a member of the Skandia Group of
>>Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia
>>House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated
>>by the Personal Investment Authority for UK Investment Business -
>>Member of the Association of International Life Offices.
>>
>>Internet: http://www.royalskandia.com
>>
>>***
>**
>>
>>---
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Jared Still
>> 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: C.S.Venkata Subramanian
> 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 r
Oracle 7.1 Listener question
Dear List, Pl excuse me for asking a very old question. In one of our client Site are running Oracle 7.1 in SCO Unix. The Appln is unix based and they connect to Oracle via Dumb terminals using I/O card and not network card. We have to migrate the application to Client Server Mode. So we have to install a network card and make listner up and running to accept the connections. The person who installed Oracle 7.1 says that in 7.1 there is no listener and from 7.3 only Oracle came out with the concept of listner. So Gurus some of you might worked in 7.1 in any platform. Could you recollect and tell me whether listener was there in 7.1. I had browsed technet documentation, but there are only 7.3 and upwards documentation and no 7.1 documentation. Thanks in Advance venkat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Fwd: Extproc problem...
Hi,
Pl use the equivalent of DLL walker of NT in Unix to find the exact name of the shared
object that you have created. The shared object created by you will have some name
appended during the compilation of the program. Pl use this name and ref the same in
Oracle.
HTH
--
On Sun, 18 Nov 2001 16:25:17
Jared Still wrote:
>
>
>-- Forwarded Message --
>Date: Sun, 18 Nov 2001 22:47:09 -
>To: "'Jared Still'" <[EMAIL PROTECTED]>
>
>
>Hi Jared,
>I am sure you can help me on this.
>I am encountering problems to run an O/S command from a stored
>procedure/procedure.
>The error log is as follows...
>SQL>create library shell_lib as '/data1/dev/uexit/test/extproc.so';
>SQL> create or replace function sysrun (syscomm in varchar2)
> 2 return binary_integer
> 3 as external
> 4 name "sysrun"
> 5 library shell_lib
> 6 parameters(syscomm string);
> 7 /
>
>Function created.
>
>SQL> declare rc number;
> 2 begin rc := sysrun('/bin/ls -l');
> 3 dbms_output.put_line('Return Code='||rc);
> 4 end;
> 5 /
>declare rc number;
>*
>ERROR at line 1:
>ORA-06521: PL/SQL: Error mapping function
>ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
>ORA-06512: at "UEXIT.SYSRUN", line 0
>ORA-06512: at line 2
>
>Could you please help on this.
>Thanks a lot.
>Baral
>
>
>*
>This message is confidential and for use by the addressee only. If you
>are not the intended recipient, you must not use, disclose, distribute,
>copy, print, or rely on this message. Please notify the sender by
>return email and then delete the message from your computer. Royal Skandia
>accepts no responsibility for changes made to this message after it was
>sent nor for any loss or damage from receipt or use.
>
>Royal Skandia Life Assurance Limited - a member of the Skandia Group of
>Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia
>House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated
>by the Personal Investment Authority for UK Investment Business -
>Member of the Association of International Life Offices.
>
>Internet: http://www.royalskandia.com
>
>*
>
>---
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> 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: C.S.Venkata Subramanian
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: is there an archive for this mailing list...
Goto the following link and sign in and select Oracle-L list and you have an option called Archives. http://www.fatcity.com/ HTH Venkat -- On Thu, 15 Nov 2001 00:25:19 grace wrote: >hi gurus >is there an archive for this mailing list? if yes , how can i access them > >Best regards, > >Grace Lim >Suy Sing Comm'l Corp. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: grace > 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: C.S.Venkata Subramanian 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: DBA CHECKLIST
Hi List, Check this out, http://www.geocities.com/tbcox23/dba_checklist15.doc It is really gd. Venkat -- On Wed, 14 Nov 2001 23:40:19 nlzanen1 wrote: > >Hi, > > >O'Reilly has a pocket size reference book about it, I believe > > >Jack > > > > >"grace" <[EMAIL PROTECTED]>@fatcity.com on 15-11-2001 05:30:17 > >Please respond to [EMAIL PROTECTED] > >Sent by: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > >hi, > >is there a dba checklist to know a dba does? > >Best regards, > >Grace Lim >Suy Sing Comm'l Corp. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: grace > 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). > > > > >= >De informatie verzonden in dit e-mailbericht is vertrouwelijk en is >uitsluitend bestemd voor de geadresseerde. Openbaarmaking, >vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan >derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & >Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en >volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch >voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een >verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten >worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. > >Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u >vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender >en het origineel en eventuele kopieën te verwijderen en te vernietigen. > >Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene >voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De >algemene voorwaarden worden u op verzoek kosteloos toegezonden. >= >The information contained in this communication is confidential and is >intended solely for the use of the individual or entity to whom it is >addressed. You should not copy, disclose or distribute this communication >without the authority of Ernst & Young. Ernst & Young is neither liable for >the proper and complete transmission of the information contained in this >communication nor for any delay in its receipt. Ernst & Young does not >guarantee that the integrity of this communication has been maintained nor >that the communication is free of viruses, interceptions or interference. > >If you are not the intended recipient of this communication please return >the communication to the sender and delete and destroy all copies. > >In carrying out its engagements, Ernst & Young applies general terms and >conditions, which contain a clause that limits its liability. A copy of >these terms and conditions is available on request free of charge. >= > > > > > >-- >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: C.S.Venkata Subramanian 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: IP address for a session without audit enable
You can use the following sql*function user_env or sys_context to get the IP address. HTH -- On Tue, 30 Oct 2001 09:40:23 Mark Leith wrote: >How about checking the listener.log file? > >HTH > >Mark > >-Original Message- >Sent: Tuesday, October 30, 2001 16:35 >To: Multiple recipients of list ORACLE-L > > > >Hi, > >Does any one know a way of finding the IP address for a session? > >The Terminal or the Machine columns in v$session are not guaranteed to have >ip addresses. > >Regards, > >Waleed >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Khedr, Waleed > 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: Mark Leith > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Oracle 7 documentation - Good One
Dear All, I hit upon this site. I thought its worth sharing http://docs.oracle.com/ Venkat -- On Fri, 19 Oct 2001 06:25:21 Deshpande, Kirti wrote: >It is hiding at http://technet.oracle.com/doc/server734.htm > >Regards, > >- Kirti Deshpande > Verizon Information Services > http://www.superpages.com > >> -Original Message- >> From:Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] >> Sent:Thursday, October 18, 2001 3:20 PM >> To: Multiple recipients of list ORACLE-L >> Subject: Oracle 7 documentation >> >> > -Original Message- >> > From: Scott Shafer [ <mailto:[EMAIL PROTECTED]>] >> > >> > Does anyone know if technet is still hiding v7 docs somewhere? >> >> As far as I can tell, technet removed all Oracle 7 documentation a few >> weeks ago. You can find the Oracle 7.3 documentation on Metalink. >> >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Deshpande, 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: export database with Query option
Try this exp scott/tiger tables=emp query=\"where sal>=2000 \" Venkat -- On Mon, 29 Oct 2001 22:15:18 nshah wrote: >Hi, > >Can you help me, regarding oracle export database utility with Query option. > >Our OS is the WinNT 4.0. >Database 8i >Server compaq raid 5 > >I am trying to export the employee table which has sal > 2000. > >exp scott/tiger tables=emp query= ? > >Neel >-- >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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Instance Name in Sql Prompt
Try this one. set serveroutput on size 100 set trimspool on set long 5000 set linesize 100 set pagesize column plan_plus_exp format a80 column global_name new_value gname set termout off select lower(user) || '@' || decode(global_name, 'ORACLE8.WORLD', '8.0', 'ORA8I.WORLD', '8i', global_name ) global_name from global_name; set sqlprompt '&gname> ' set termout on -- On Thu, 25 Oct 2001 06:35:21 Ramon Estevez wrote: >Hi Friends, > >Excuse me for this dumb question, how do I display the instance name in the >sql prompt. Have 3 DB and would like to know to which one I am connected. > >I mean something like that. > >DBA1 > >DBA2 > >DB01 > > >Regards, > >Ramon E. Estevez >[EMAIL PROTECTED] >Dominican Republic >809-565-3121 > > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Oracle 9i CD
Hi, Try this link http://download-eu.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm Venkat -- On Thu, 25 Oct 2001 03:35:19 Sinard Xing wrote: >Hi, > >Where can I get Oracle 9i "Document" CD or Download URL (I prefer HTML >format, but if pdf em... ok just have to print) >I can't find Oracle 9i Concept in Technet, nobody raise this question before >in Metalink. > > > >Sinardy > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinard Xing > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Errormessage
Roland, Your qry is making a HASH join and eating up the temp tablespace. The solution is to increase the parameter HASH_MULTIBLOCK_IO_COUNT in init.ora and bounce the db once. By default this parameter is '0'. So increase the next extent parameter for the temp tablespace. alter tablespace temp default storage(next 3M); this sql stmt will alter the temp tablespace's next extent from default value to 3Megs. HTH Venkat -- On Tue, 23 Oct 2001 00:10:19 Roland.Skoldblom wrote: >Hallo > > > > > >I run this select statement and get this errormessage. What should I do to solve it? >I have a databaselink from the actual schema to another schema. > > > > > > SELECT RIK2.VARE.EAN_NR, >> RIK2.VARE.LEVNR, >> RIK2.ART_HIERARKI_CALC.VGR, >> RIK2.VARE.SORTIMENT, >> RIK2.VARE.VARENAVN >> FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC >> WHERE RIK2.VARE.SELSKAP='11' AND >>RIK2.VARE.VARE_SNR=10 >>AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR >> ORDER BY VGR >> >> >> ORA-03232: unable to allocate an extent of 62 blocks from tablespace 3 > > >Thanks in advance > > > > > >Roland > >-- >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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Find out export from remote locations
Query the V$session table in Server2. -- On Mon, 22 Oct 2001 00:50:18 Tatireddy, Shrinivas (MED, Keane) wrote: >Hi lists, > >Is there any way to find out if any session is doing export from a >remote shell. > >eg: >I am performing this from SERVER1 > >exp userid=sys/pwd@connect_str_ON_SERVER2 file=/tmp/file.dmp >log=/tmp/file.log tables=scott.emp > >this I am doing from my local database to a remote server. > >I am able to do perform export. > >Is there any table to find the above information(IN EITHER SERVER1 OR >SERVER2), means a user is performing export on the database. > >Thnx and regards >srinivas >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Tatireddy, Shrinivas (MED, Keane) > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Need Suggestion for RMAN
Dear List, I need some suggestions for RMAN. For a quite sometime I have seen numerous mails regarding RMAN. We have 2 Production Databases located at different sites. We use RMAN to backup the databases. Daily incremental backups(Archivelogs, ControlFiles,parameter files, password file) Weekly Full backup(Datafiles,Archivelogs, ControlFiles,parameter files, password file). the backup are successfully tested in a development m/c and till date we didn't face any probs till date. But we are not using "Catalog Database" for storing the information. Instead we are using the target database's control file. We have also stimulated the recoveries based on the above. I want to know whether it is "mandatory" or "advisble" to use RMAN with or without a catalog database. Any views, suggestions are welcome. TIA Venkat Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Export/Import Problem
Chk the target database characterset. -- On Wed, 17 Oct 2001 23:55:18 Sundar wrote: >Hi All, > >I am trying to import an user from ORacle Ver 8.1.6 Running under Solaris and Oracle >8.1.7 running under Windows NT. I want to export a user from Win Oracle to Solaris >oracle and I am getting the following error. > >Please help how to go about doing this. > >***ERROR >Export file created by EXPORT:V08.01.07 via conventional path >import done in US7ASCII character set and US7ASCII NCHAR character set >IMP-00069: Could not convert to environment national character set's handle >IMP-0: Import terminated unsuccessfully >* > >bye >Sundar > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sundar > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: ORA-24323 & ORA-03113 & ORA-01034 & ORA-27101 errors
ORA-24323: value not allowed For this Chk ur init.ora file. there may be some values that are not supported by the version of Oracle u r using. U r connected as internal user. Rectify the first error, then all the errors will go away. HTH Regards Venkat -- On Fri, 05 Oct 2001 04:35:19 Okan CIMEN wrote: >Hello, > >I get strange errors from my DB server. Here are the outputs; > >$ sqlplus >SQL*Plus: Release 8.1.7.0.0 - Production on Thu Oct 5 14:24:07 2000 >(c) Copyright 2000 Oracle Corporation. All rights reserved. >Enter user-name: internal >Connected to an idle instance. >SQL> startup force >ORA-24323: value not allowed >ORA-03113: end-of-file on communication channel > >When I try to log on as any user I get these messages; >SQL> connect anyuser >Enter password: >ERROR: >ORA-01034: ORACLE not available >ORA-27101: shared memory realm does not exist >SVR4 Error: 2: No such file or directory > >I am still connected to the server as a user but when I do ps -ef | grep >ora_ , I get nothing. Can someone please tell me what path I shall take? > >Regards > >Okan > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Okan CIMEN > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Tracing a sql statement also to include bind variables
rts & NEW webcam video instant messaging with Yahoo! Messenger. >http://im.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Christian Trassens > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Reading dbf files
Dear List, I would like to add what Rachel had written, it is true, once they came to one of my client site and performed the same it is called "DUL" data unloader. But it will work only when system tablespace is intact. If it is lost then u loose all ur data. Some where in one of the website I read about a Pro*C program to read and dump data in a flat file(I could not remember the website) Pl excuse. DUL utility Oracle says "Life is DUL without it". Venkat -- On Tue, 25 Sep 2001 15:15:58 Rachel Carmichael wrote: >n logminer can't do this... it can read the archived logs > >the product is Data Unloader, it's not one Oracle likes to allow people >to use, they DO charge a fortune for it and it really should only be >used under extreme circumstances (no backups, cannot open database -- >which is why I ended up using it) > >they come, they install it, they run it, the take it off your machine. >They charged when I used it (3 years ago), $5000 for every 8 hour >period onsite with a minimum of $1. > > >--- "Wong, Bing" <[EMAIL PROTECTED]> wrote: >> I believe logminer utility can do the job. >> >> -Original Message- >> Sent: Tuesday, September 25, 2001 3:00 PM >> To: Multiple recipients of list ORACLE-L >> >> >> >> Anyone have something that can read the oracle dbf files? A client >> got my name from a friend and is asking if I can recover some of his >> data from a corrupt file in a database that has no backup. I have >> heard >> Oracle has something to do this but charges alot to perform this for >> them. I would like to help them with this and get my foot in the door >> for more projects like setting up backups:) >> >> I believe it is all of the clients documentation for the last 3 >> years. >> Oops:) >> >> Thanks, Dave >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: David Turner >> 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: Wong, Bing >> 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). > > >__ >Do You Yahoo!? >Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. >http://im.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: SO UPSET FOR ALL AMERICANS
We Indians also pray for the families who have lost their kin and kith in the terrorist attack and I personally believe, those who are responsible must be traced and punished by law. Venkat -- On Tue, 11 Sep 2001 16:12:03 Jared Still wrote: > >Thank you Bunyamin. > >This is a tragedy for everyone. > >Jared > >On Tuesday 11 September 2001 10:15, Bunyamin K. Karadeniz wrote: >> I HOPE BEST WISHES FOR ALL PEOPLE IN AMERICA . >> >> WE TURKISH PEOPLE ARE ALL SORRY AND HOPE YOU HEALTH. >> BUNYAMIN > > >Content-Type: text/html; charset="iso-8859-9"; name="Attachment: 1" >Content-Transfer-Encoding: quoted-printable >Content-Description: > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: OOW presentations
Rachel Carmichael wrote: Oracle's got the list of presenters and presentations up on the site What is the url? can u pl mail me. Venkat -- On Fri, 07 Sep 2001 06:25:50 Thater, William wrote: >Rachel Carmichael wrote: > >> Oracle's got the list of presenters and presentations up on the site >> >> of 287 presentations, 85 are by non-Oracle employees. >> >> Of the 202 presentations by Oracle, I wonder how many are just >> marketing hype? > >201. > >bill [who's too damn cynical ALL the time.] > > > >-- >-- >Bill "Shrek" Thater ORACLE DBA >Telergy,Inc. [EMAIL PROTECTED] > >You gotta program like you don't need the money, >You gotta compile like you'll never get hurt, >You gotta run like there's nobody watching, >It's gotta come from the heart if you want it to work. > >All the simple programs have been written, and all the good names taken. > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Thater, William > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Create Database ORA-907 need help
Chk the spelling of maxlogfiles. You have used 0(zero) instead of 'O'. -- On Tue, 04 Sep 2001 23:55:42 Sinardy wrote: >Hi all, > >Can someone tell me whats wrong with my script ? > > >CREATE DATABASE TEST > LOGFILE ( > '/test/redo01.log' SIZE 10K, > '/test/redo02.log' SIZE 10K, > '/test/redo03.log' SIZE 10K > ) > MAXL0GFILES 6 > MAXINSTANCES 4 > NOARCHIVELOG > CHARACTER SET US7ASCII > DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON >; > > >When I try this script, I recieve this > > >SVRMGRL> @CreateDB > '/test/redo01.rdo' SIZE 10K, > >ORA-00907: missing right paranthesis > > > > > > >Thank You > >Sinardy >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: How to interpret Alert.Log & Trace files...
r cache hit percent >=0.900.71 Increase the >DB_BLOCK_BUFFERS in INIT.ORA >-- Current value: db_block_buffers = 1000 >Sort area hit percent >=0.901.00 OK >Redo Log space requests=0 17 Increase the LOG_BUFFER in >INIT.ORA >" Examine Redo Log size >" Examine number of Redo Log >groups >-- Current value: log_buffer = 32768 >-- Current value: redo log size = 1048576 >-- Current value: # of redo log groups = 2 >Enqueue waits =0 2 Increase the >ENQUEUE_RESOURCES in INIT.ORA >-- Current value: enqueue_resources = 265 >Checkpoints not completed <=1 0 OK >Rollback contention ratio <=0.010.00 OK >Redo allocation latch miss (W) <=0.010.00 OK >Redo allocation latch miss (I) <=0.010.00 OK >Redo copy latch miss (WTW) <=0.010.00 OK >Redo copy latch miss (Immed) <=0.010.00 OK >Freelist contention ratio <=0.010.00 OK > >I would appreciate advice on changing initialization parameters. >Are there some parameters that can be modified on the fly without cycling >the engine? >How can I find out which ones? The DB_BLOCK_BUFFERS parameter needs some >attention urgently, right? > >I am being cautious because changing some parameters can impact others. > >I know this is a lot to chew on, but feel free to send me to sites that >might provide technical resources. Unfortunately, I don't have access to >Metalink. > >Thanks in advance, > >Denmark Weatherburne > >"Knowledge is power, but it is only useful if it is shared!" > > > > > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Denmark Weatherburne > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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:
yes. If u have 2 instances then 2 Oracle.exe will be running. HTH -- On Thu, 23 Aug 2001 08:40:55 Denmark Weatherburne wrote: >Hi Again DBA's > >We are running Oracle 8.0.5 on NT 4. >I read that Oracle is implemented as one multi-threaded process on NT. >I observe two ORACLE80.EXE proceses running in the Task Manager. >There are also two STRTDB80.EXE processes running as well. >Does the number of ORACLE.EXE processes represent the number of databases >that are open? > >Thanks in advance for your input! > >Denmark Weatherburne > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Denmark Weatherburne > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: linux for oracle
8.1.6 on Redhat linux 6.2. Oracle 9i is available for mandrake linux with 2.2.4 Kernal HTH -- On Fri, 17 Aug 2001 04:23:36 Rao, UmaSankara S (CAP) wrote: >Hi Gurus, > >Can u please tell me the most stable version of Linux on which I can install >Oracle 8i? > >Thanks in advance >Uma >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rao, UmaSankara S (CAP) > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Deep Doo-Doo
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: Farnsworth, Dave >> 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). >> > > >Get 250 color business cards for FREE! >http://businesscards.lycos.com/vp/fastpath/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Farnsworth, Dave > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Urgent Pls Help
Dear DBA's, Can Any one of you tell me how to populate a table with Simplified Chinese Language. My database character set is also Simplified Chinese. Do I have change any parameters in OS level. My OS is WinNT4.0 with Oracle 8.1.6. Pls help TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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:Query Tuning - Need Some Clarifiations
Hi,As per your statement and the volume of transaction u have mentioned, I feel the db which I tuned is peanuts when compared to yours. But it was the requirement of the customer, I did what the customer wanted, that's it buddy. Regards venkat -- On Mon, 13 Aug 2001 07:15:37 dgoulet wrote: >The frequency at which you rebuild indexes and/or analyze the database is >somewhat of a black art. My first question is what do you mean by "there are >huge inserts,updates and deletes"? Our operational data store for our testers >goes through something line 6 million inserts/updates/deletes per day and the >maintenance is being done every 6 months without any performance degradation in >between. > >Dick Goulet > >Reply Separator____ >Author: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> >Date: 8/10/2001 11:45 PM > >Dear Listers, >My manager called me asked to look into the database problems in an IVR appln. >The size of the database is around 1 gigs. The db stores information about >customers, their phone nos and the relevant details. The mail problem was delay >in playing a welcome prompt when the call connects to IVR, 6 queries are >executed before playing the welcome message and there was a major delay when the >customer needed some info. Basically it has to query the database and pass on >the info the person who had called. > >First I got all the queries and checked the plan,time taken for each query. I >found all the queries did a full table scan and after creating necessary indexes >and analyzing the tables, I hit the right thing. Now the welcome message is >played moment the call is connected to IVR and there is no time lag susequent >queries. > >Using tkprof I checked the usage of indexes,CPU usage, time taken for >parse,execution. All showing 0. The customer is happy now and also the manager. > >I have few doubts. It is an OLTP kind of scenario, there are huge >inserts,updates and deletes, in what frequency I have to rebuild indexes and >analyze the tables after rebuilding indexes. > >Since the db is in noarchivelog mode, it is advisible to put the same in >archivelog mode. > >Any advices/suggestions are welcome. > >Regards >C.S.Venkata Subramanian > > >Get 250 color business cards for FREE! >http://businesscards.lycos.com/vp/fastpath/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: C.S.Venkata Subramanian > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Time taken
Dear List, I have a table deviceinfo,which has 200 records. There is a primary key deviceid. When I do the foll query select * from deviceinfo where deviceid='XX'; sometimes it is taking less than 1 sec and sometimes it takes more than 30 sec. I firing this query from a VB6 Appln over ODBC(Microsoft ODBC driver). I have rebuild the index. But still the problem continues. Any hints or suggestions TIA Venkata subramanian Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Open Cursors Help
Dear All, Is there any method to close the open cursors forcibly that are shown in v$open_cursor table. I do not want to bounce the DB? Venkata Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: ip restriction help
We can also use a database trigger for the above purpose. -- On Fri, 03 Aug 2001 07:06:15 Charlie Mengler wrote: >within protocol.ora > >tcp.excluded_nodes=(a.b.c.d, w.x.y.z, clientA.mydomain.com) > >HTH & YMMV! > >Xiaohong Yang wrote: >> >> Hi Gurus, >> >> I would like to get your recommendation for connection restriction to the >> databases via tcp/ip based on ip addresses. The restriction is required >> for only the databases that is served by one listener, not the other. >> >> Any suggestions are welcome: OS, Oracle, network... >> >> Sun Solaris 2.7 >> Oracle EE 8.1.6.3.0 >> two listeners on the same server: >> listener1 serves a set of databases that has MTS setup, listener2 listens >> for a set of databases that is configured for dedicated connections. >> >> Thanks, >> Sharon >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Xiaohong Yang >> 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: Charlie Mengler > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Language Clarification
Dear All, I have some queries. How can we store non-English characters in Oracle database? e.g.) Simplified Chinese. I created a Oracle database with character set JA16SJIS. But it is allowing me to enter only english and european languages. Pl clarify. Thanks in Advance Regards Venkata subramanian Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: RULE vs. CHOOSE
1)I feel each plan depends on init parameters of Oracle. 2) You can statspack of Oracle. It will give u reports of the performance of the DB. HTH -- On Thu, 2 Aug 2001 13:01:56 VIVEK_SHARMA wrote: > >Qs. Is there any Way to Generate the IDEAL OUTLINE Plans Plans in 1 >Database >& Send it for Import to ALL the Various Sites World-wide ? > >Qs. Is there any PACKAGE etc. which Automatically Causes Statistics to >be ANALYZED in some SMALL proportions (Bit by Bit) while Live Operations > >are in progress ? What would be the Overhead of Such a Package (if >Exists) ? > >Thanks so much for the Help > >> -Original Message- >> From:Gillies, Garry [SMTP:[EMAIL PROTECTED]] >> Sent:Wednesday, August 01, 2001 8:01 PM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: RULE vs. CHOOSE >> >> >> > From: VIVEK_SHARMA [<mailto:[EMAIL PROTECTED]>] >> > Sent: 01 August 2001 08:05 >> > Subject: RULE vs. CHOOSE >> > >> > Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be >> >> > used for the PARTITIONED Table in the Following Query ? >> > >> > NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run the >> > Following SQL :- >> > >> > SELECT >> > FROM , >> > where .Column = .Column >> > >> > Assuming .Column is the PARTITION KEY >> > & BOTH & are ANALYZED . >> > >> >> Development stopped on RBO at version 7. Partitioning is a version 8 >> feature. Since RBO has no knowledge of dealing with partitions, CBO >> must be used. >> >> > Qs. Will Only the Respective partition be SCANNED in the Above Query >> ? >> >> No. There is nothing in that query that tells the optimiser that only >> a particular partition will be required. >> >> > Qs. Would there be Any Disadvantage in SETTING OPTIMIZER_MODE=RULE >> for >> > the Above Query ? >> >> It would be ignored. The CBO would be used, defaulting to ALL_ROWS. >> >> > Qs. How is it Best Possible to KEEP the SAME (BEST) Execution Plan >> at >> > Various Sites where the SAME PRODUCT Exists >> >> Yes, but you must be using CBO - see CREATE OUTLINE in SQL reference >> manual. >> >> > Qs. Is there any PACKAGE etc. which Automatically Causes Statistics >> to >> > be ANALYZED in some SMALL proportions (Bit by Bit) while Live >> > Operations >> > are in progress ? What would be the Overhead of Such a Package (if >> > Exists) ? >> >> I do not know. >> > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
View Help
Dear All, Is it possible to create a view where I will pass the condition to the where clause dynamically. eg) Create view v1 as select ename,empno,sal from emp where deptno=:a The value of 'a' I will pass the value dynamically when I do the select. eg) select * from v1. Now I'll pass the value say 20. Is this possible Any suggestions or workaround for this. TIA Regards Venkata Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: RULE vs. CHOOSE
Ya I got the name correctly. Thanks for pointing it out. Venkat -- On Wed, 01 Aug 2001 03:01:19 Christian Trassens wrote: >Sorry, but maybe you refer to the outlines and the >parameter use_stored_outlines. Read the notes >1071358.6 and 92202.1 > >Regards. >--- "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> >wrote: >> Use the plan stability of Oracle 8i. In this u have >> to capture plans for the sqls. A init parameter has >> to be added use_plan_stability=true(pls chk with >> manuals for more info). >> >> Ref to Oracle performance tuning manual. It is >> explained well there. >> >> HTH >> Regards >> Venkat >> -- >> >> On Tue, 31 Jul 2001 23:05:27 >> VIVEK_SHARMA wrote: >> > >> >Qs. Will COST Based Optimizer (CBO) or Rule Based >> Optimizer (RBO) be >> >used for the PARTITIONED Table in the Following >> Query ? >> > >> >NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run >> the Following SQL :- >> > >> >SELECT >> >FROM , >> >where .Column = > Table>.Column >> > >> >Assuming .Column is the PARTITION >> KEY >> >& BOTH & >> are ANALYZED . >> > >> >Qs. Will Only the Respective partition be SCANNED >> in the Above Query ? >> >Qs. Would there be Any Disadvantage in SETTING >> OPTIMIZER_MODE=RULE for >> >the Above Query ? >> > >> >Most of the Tables in the Application may be >> NON-partitioned & Most of >> >the Queries RUN Well in RULE . >> > >> > >> > >> > >> >Qs. How is it Best Possible to KEEP the SAME (BEST) >> Execution Plan at >> >Various Sites where the SAME PRODUCT Exists >> > >> >NOTE - These Sites Belong to DIFFERENT Customers & >> Have Different Total >> >Data Size & Distributions . >> > >> >Current Data Size ranges from 50 to 150 GB but the >> Data is Growing Very >> >Rapidly & may touch 200 GB within the Year . >> > >> >Being a Banking Application Product , it is a MIX >> of OLTP & DSS Types >> >of Transactions . >> > >> >With OPTIMIZER_MODE set to RULE the Queries work >> Quite Well . >> > >> > >> >Qs. Is there any PACKAGE etc. which Automatically >> Causes Statistics to >> >be ANALYZED in some SMALL proportions (Bit by Bit) >> while Live Operations >> >are in progress ? What would be the Overhead of >> Such a Package (if >> >Exists) ? >> > >> > >> >-- >> >Please see the official ORACLE-L FAQ: >> http://www.orafaq.com >> >-- >> >Author: VIVEK_SHARMA >> > 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). >> > >> >> >> Get 250 color business cards for FREE! >> http://businesscards.lycos.com/vp/fastpath/ >> -- >> Please see the official ORACLE-L FAQ: >> http://www.orafaq.com >> -- >> Author: C.S.Venkata Subramanian >> 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). > > >= >Eng. Christian Trassens >Senior DBA >Systems Engineer >[EMAIL PROTECTED] >[EMAIL PROTECTED] >Phone : 541149816062 > >__
Suggestions Needed
Dear All, We are in process of migrating some appln from WindowsNT to Unix. Our prgs are written in Pro*c. We need some suggestions reg the same. TIA Regards Venkata Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: RULE vs. CHOOSE
Use the plan stability of Oracle 8i. In this u have to capture plans for the sqls. A init parameter has to be added use_plan_stability=true(pls chk with manuals for more info). Ref to Oracle performance tuning manual. It is explained well there. HTH Regards Venkat -- On Tue, 31 Jul 2001 23:05:27 VIVEK_SHARMA wrote: > >Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be >used for the PARTITIONED Table in the Following Query ? > >NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run the Following SQL :- > >SELECT >FROM , >where .Column = .Column > >Assuming .Column is the PARTITION KEY >& BOTH & are ANALYZED . > >Qs. Will Only the Respective partition be SCANNED in the Above Query ? >Qs. Would there be Any Disadvantage in SETTING OPTIMIZER_MODE=RULE for >the Above Query ? > >Most of the Tables in the Application may be NON-partitioned & Most of >the Queries RUN Well in RULE . > > > > >Qs. How is it Best Possible to KEEP the SAME (BEST) Execution Plan at >Various Sites where the SAME PRODUCT Exists > >NOTE - These Sites Belong to DIFFERENT Customers & Have Different Total >Data Size & Distributions . > >Current Data Size ranges from 50 to 150 GB but the Data is Growing Very >Rapidly & may touch 200 GB within the Year . > >Being a Banking Application Product , it is a MIX of OLTP & DSS Types >of Transactions . > >With OPTIMIZER_MODE set to RULE the Queries work Quite Well . > > >Qs. Is there any PACKAGE etc. which Automatically Causes Statistics to >be ANALYZED in some SMALL proportions (Bit by Bit) while Live Operations >are in progress ? What would be the Overhead of Such a Package (if >Exists) ? > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: VIVEK_SHARMA > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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 ora & dbf as datafile extensions..
Till Oracle 8.0 the default extension was .ora. But from Oracle 8i the extension was changed to .dbf=>databasefile. .ctl=>extension for controlfiles. When u create datafile for OEM_repository from the OEM config assistant, by default it gives an extension as .ora. But as a good practise keep the extension of datafiles as .dbf. If u want to change the same. Backup the control file to trace. Change the extension of the file in the backup control file and also of the original file. Bounce the db once and u get the file extension changed. HTH Venkat -- On Tue, 31 Jul 2001 00:06:09 Saurabh Sharma wrote: >hi all, > >is there any problems using different filetypes for various datafiles in the same >database. >i mean using some files as .dbf extension while some as .ora > >i'm using system, rbs, temp, oemrep as .dbf, while the one i creted later are using >.ora extension. >does it cause any problem in conversion or upgradation. > >any views. > >Saurabh Sharma > >[EMAIL PROTECTED] >http://www.geocities.com/saurabh00pc/stride.html > > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: ORACLE8i & cc compiler on SOLARIS
Hi, If u are compiling any Pro*C programs then u need 'cc' compiler. For normal installation 'gcc' compiler is good enough. HTH Venkat -- On Fri, 27 Jul 2001 03:00:27 okhalid wrote: > >hello GURU DBAs > >i would like to know if cc compiler is required for installing ORACLE 8i >on Solaris 2.6 >or is the gcc compiler required? > >regards > >'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' >Omar Khalid >Software Engineer >LMK Resources >Voice: 111-101-101*780 >Mobile: 0333-510-4465 >Web: www.lmkr.com >'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' > >-- >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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
2 queries
Dear Fellow DBA's, I have 2 queries. Query 1 I have a development database Oracle 816 under winNT. I tried to connect as sysdba. But it is giving insuffient privileges. When I queried the v$pwfile_users table, there are no rows selected. how can I add users to it. I tried recreating passwordfile. But the same problem. Query 2 I had a test database 8.1.7 under WinNT. Due to some reasons I had to reload NT and also Oracle. But I loaded Oracle 8.1.6. I had my database intact. I shutdown the database before reloading NT. To my surprise I created the service and started the db and found working. Can anyone tell me how this can happen. TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Sorry
Dear List, I didn't intentionally send my resume to the list. There was a posting on this list saying anyone interested in getting a job in and around London can fwd their resume. I just replied to the message and after hitting the send button then I realised that the mail was sent to list and not to the person addressed to. Accept my apologies for the inconvenience caused to one and all in the list. Sorry once again. Regards Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Jobs
Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: >Hello Oracle professionals, > > >Are there any Oracle DBA's currently looking for work in and around London, England. > >If so, send me a copy of your cv and I will do my best to find you the right job. > >We are an Oracle specialist recruitment consultancy. > >Regards > >Culum Slater >Managing Director >CMS Global Ltd > >D/L: 01923 233196 > >M/N: 07960 113 738 > >[EMAIL PROTECTED] > >CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ msword1.rtf
Re: (No Subject)
Thanks Chao
--
On Thu, 28 Jun 2001 23:47:32
chao_ping wrote:
>hi,
> just do:
>'' represent '
>
>SQL> create table testtb(a varchar(90));
>Table created.
>SQL> insert into testtb values('i love oracle''s money');
>1 row created.
>SQL> select * from testtb;
>A
>
>i love oracle's money
>
>SQL> drop table testtb;
>Table dropped.
>
>- Original Message -
>From: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]>
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Friday, June 29, 2001 1:30 PM
>Subject: (No Subject)
>
>
>> HI Gurus,
>> I want to insert single quotes with my data from my application.
>> Some data will contain quotes and some may not.
>>
>> How can this be achieved?
>>
>> Kindly help
>>
>> TIA
>> Regards
>> C.S.Venkat
>>
>>
>>
>> Get 250 color business cards for FREE!
>> http://businesscards.lycos.com/vp/fastpath/
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: C.S.Venkata Subramanian
>> 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).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: C.S.Venkata Subramanian
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).
(No Subject)
HI Gurus, I want to insert single quotes with my data from my application. Some data will contain quotes and some may not. How can this be achieved? Kindly help TIA Regards C.S.Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Data dictionary for function
user_source,dba_source -- On Thu, 28 Jun 2001 20:20:23 Sinardy Xing wrote: > >Hi all, > >Do you know what data dictionary store information about all user function, >store procedure ? > > > > > > >Best Regards > >Sinardy > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
This is Test
List this is only test mail. I had posted several queries, but my mail is not in the list. but I get all mails from the list. Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Quotes in Oracle
Hi All, In my appln I want to insert quotes along with the data ie like abc's from the application. Quotes may be there in some data but not there in some data. Any idea how to Achieve this from any frontend. TIA Regards Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: 24 x 7 on NT?
Hi Smith, As everyone in the list has rightly pointed out that NT is stable and may also lead to problems. I myself installed a 50gigs DB in aIBM Netfinity server with RAID 1+0 combination in MSCS. Even tough the client lost a datafile and was unable to restore the whole db. Instead they created DB and imported. IBM said HDD's are sound. Oracle support said HDD problem, after analysing the trace file and dump. So make sure u have good backup's and ensure min down time for the system. Make sure u have a good sysadmin who know in and out of NT. HTH Venkat -- On Mon, 25 Jun 2001 12:06:59 Smith, Ron L. wrote: >I have a treasury application that needs to be up 24 x 7 except for >scheduled downtime. Is there any way to guarantee an app will be available >24 x 7 on NT? Is anyone faced with this? > >Ron Smith >Database Administration >[EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
MetaLink Error
Dear List, I tried to upload a file to Metalink, I got the following error. Wed Jun 20 05:46:36 2001 ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROCESS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored VARIABLES IN FORM NOT IN PROCEDURE: NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: P_NAME,P_EMAIL,P_PHONE,P_TAR,P_COUNTRYCODE,P_FILENAME,P_REALNAME,SUBMIT OWA SERVICE: gtcr PROCEDURE : upload.process URL: http://ess8.us.oracle.com:8112/gtcr/cgi_script/upload.process? PARAMETERS : === ENVIRONMENT: TZ=US/Pacific HTTP_ACCEPT=application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */* HTTP_ACCEPT_LANGUAGE=en-us HTTP_ACCEPT_ENCODING=gzip, deflate HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.0; Windows NT) HTTP_COOKIE=ORA_UCM_AGID=%2fMP%2f8Mw7tNrF0%40QW%3f%3fAk3ARC HTTP_VIA=1.1 delss06:7070 (Squid/2.3.STABLE4), 1.0 proxy10.siemens.de:81 (Squid/2.3.STABLE4) HTTP_X_FORWARDED_FOR=132.186.199.168, unknown HTTP_HOST=ess8.oracle.com HTTP_CACHE_CONTROL=max-age=259200 HTTP_CONNECTION=keep-alive PATH=/bin:/usr/bin:/usr/ccs/bin:/usr/ucb: SERVER_SOFTWARE=Apache/1.2.4 SERVER_NAME=ess8.us.oracle.com SERVER_PORT=8112 REMOTE_HOST=proxy10.netz.sbs.de REMOTE_ADDR=192.35.17.15 DOCUMENT_ROOT=/oracle/product/httpd/htdocs [EMAIL PROTECTED] SCRIPT_FILENAME=/mlprod/www/gtcr/cgi_script REMOTE_PORT=2746 GATEWAY_INTERFACE=CGI/1.1 SERVER_PROTOCOL=HTTP/1.0 REQUEST_METHOD=GET QUERY_STRING= REQUEST_URI=/gtcr/cgi_script/upload.process SCRIPT_NAME=/gtcr/cgi_script PATH_INFO=/upload.process PATH_TRANSLATED=/oracle/product/httpd/htdocs/upload.process PWD=/mlprod/www/gtcr USER=oracle ORACLE_SID=ETCR ORACLE_HOME=/oracle/product/8.0.4 OWA_CGI_APPFILE=/mlprod/www/gtcr/gtcr.app LD_LIBRARY_PATH=/oracle/product/8.0.4/ows/3.0/lib:/oracle/product/8.0.4/bin:/oracle/product/8.0.4/lib Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
RMAN Suggestion
I need some suggesations regarding RMAN. I want to spread the backup in two drives. one drive has 27GB free space and other has 9 GB free space. How do I divide thru channel ? I want maximum will go to 27gb and minimum will be in 9 gb . I have used channel limit facility but it is not solving the problem, if you know any parameter please specify. TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Child to Parent
Dear List, I need some info, I have a table where I store the details of dealers in the table. structure is SF_DEALER_CODENOT NULL VARCHAR2(10) SF_DEALER_NAME VARCHAR2(40) SF_CIRCLE_CODENOT NULL VARCHAR2(10) SF_AREA_OF_OPERATION NOT NULL VARCHAR2(10) SF_DEALER_TYPENOT NULL VARCHAR2(1) SF_PARENT_DEALER NOT NULL VARCHAR2(10) In the same table itself i store both parent and child recs. Is there any way to trace the parent from child. If want to trace the child from parent I use the prior,connect and level in my query and get the correct results. I want the reverse. Is there any way out. Pl help. Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: RMAN - Incomplete recovery
Hi, When u do an incomplete recovery, the db shud be opened with resetlogs. That's why they say to backup db after an incomplete recovery. HTH -- On Thu, 14 Jun 2001 07:52:20 Nirmal Kumar Muthu Kumaran wrote: >Helo guru's > >i found one ? in self test as follows: > >q)why is it not bebeficial to use RMAN when performing incomplete recovery? > >a) A full offline backup is required after the recovery operations are >complete. > >Now my question is, In general, in case of incomplete recovery we should do >the backup. > >But here what is the specific reason form doing offline backup? i cann't do >online backup itself . > >I get confused. Pls help me. > >Regards, >Nirmal. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Nirmal Kumar Muthu Kumaran > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: OT SPAM : Become an Oracle Certified DBA in 5 Weeks
me too -- On Wed, 13 Jun 2001 23:06:12 Nguyen, Long (ITS, Limestone Ave) wrote: >Yep. > >Long > >-Original Message- >Sent: Wednesday, 13 June 2001 11:16 PM >To: Multiple recipients of list ORACLE-L > > > Did anyone else on the list get this stupid spam besides me? > >thanks, joe > > >-Original Message- >To: [EMAIL PROTECTED] >Sent: 6/12/01 5:48 PM > >OraKnowledge eBoot Camp for the Oracle8i DBA Track > >OraKnowledge has created a blended e-learning program that GUARANTEES >Oracle DBAs will become certified. The 5-week program combines the best >of self-paced and instructor-led e-learning utilizing: > >* Syllabus for Success >* Certification Exam Guides >* Pre-assessment tests >* Live, virtual classroom instruction from an OCP >* 24 x 7 OCP Mentoring >* eFlash Cards >* Hundreds of Practice Questions >* Guarantee > >Seats are available for our July 16th (EST) and July 18th (PST) start >dates!! > >Visit http://www.oraknowledge.com for more information. > > >To UNSUBSCRIBE from our list, reply to this email and replace the >subject line with UNSUBSCRIBE. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Joe S. Testa > 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: Nguyen, Long (ITS, Limestone Ave) > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Oracle 9i
Can u send the doc to my mail id. TIA -- On Thu, 07 Jun 2001 06:49:08 Robertson Lee - lerobe wrote: >I know this has been sort of 'done to death' in the past but I have been >reading through the Oracle9i New Features document I received this morning >and far from being able to do away with DBAs, a common thread throughout the >doc. is > >The administrator will be able to .. > >This will enable the administrator to > >etc. etc. etc. > >Any of the UK based listees attending the Oracle/Compaq launch of Oracle9i >in the UK&I on July 12th. Sounds like a decent event and will take place in >a circus tent on the riverbank at Thames Valley park followed by a >barbecue/champagne reception etc. > >I may well be attending although it is not definite as yet. > >Cheers > >Lee Robertson > > >Tel: +44 0191 525 7344 >Fax: +44 0191 525 7007 >Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] (Please >note new email address) > > > > >The information contained in this communication is >confidential, is intended only for the use of the recipient >named above, and may be legally privileged. If the reader >of this message is not the intended recipient, you are >hereby notified that any dissemination, distribution or >copying 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 computer >system. > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: help for rollback segments..
Drop them and create them in RBS tablespace. After creating them use alter rollback segment online; If they are private rollback segs then specify them in init.ora file. HTH -- On Thu, 07 Jun 2001 23:15:22 Saurabh Sharma wrote: >HI ALL, > >i've some confusion regarding rollback segments. could anyone explain this >information from my database. > >select * from dba_rollback_segs revealed following stats.. > >SEGMENT_NAME OWNER TABLESPACE INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT >PCT_INCREA STATUS >- -- -- -- -- -- -- >-- --- >SYSTEMSYSSYSTEM 57344 57344 2505 >0 ONLINE >SYSROLSYSSYSTEM 106496 106496 2505 >0 OFFLINE >RB0 PUBLIC RBS106496 262144 2121 >0 ONLINE >RB1 PUBLIC RBS106496 262144 2121 >0 ONLINE >RB_TEMP SYSSYSTEM 106496 106496 2121 >0 OFFLINE >RB2 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB3 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB4 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB5 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB6 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB7 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB8 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB9 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB10 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB11 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB12 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB13 PUBLIC SYSTEM 57344 262144 2121 >0 ONLINE >RB14 PUBLIC SYSTEM 57344 262144 2121 >0 OFFLINE >RB15 PUBLIC SYSTEM 57344 262144 2121 >0 OFFLINE >RB16 PUBLIC SYSTEM 57344 262144 2121 >0 > >can anybody explain, why i get some status as offline. will this extent allocation >and other parameters ok. i 've oracle 8.1.5 on NT, these stats are from my test >database. >why are they in system tablespace. i've two rollback tablespace of size 15 and 20 mb >resp. >should they be in system or in rollback. >if yes, how to change their default tablespace. > >pls help me in deciding that. > >thanks in advance. > >saurabh > > > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: async I/O on NT
pl refer to Oracle8i Reference Manual of 8.1.6 Release for Windows NT - Appendix B. for detailed info on async I/O on NT. -- On Thu, 07 Jun 2001 18:20:48 Suhen Pather wrote: >List, > >I need some clarification. > >To enable Oracle to use async I/O on NT is there any changes to be made >to the parameter file. > >From what I have read on NT async I/O is automatically enabled. > >Is this true? > >Thanks in Advance >Suhen >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Suhen Pather > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: What next ?
t many of the best DBAs I've ever seen >were, at one time, outstanding developers. > >Contrary to official propaganda, OCP certification is not the holy grail. >It isn't a Nobel prize. By itself, it is a learner's permit. It may also >be useful to get over the threshold for that first DBA job interview. As >soon as you feel comfortable with SQL and PL/SQL, take that exam. Take the >others in what seems to you to be their nature order, as you progress. > >Just my very opinionated opinion, > >-Don Granaman >[Certifiable OraSaurus] > >PS: What does "X" DBA years @ 45-90 hrs/week translate to in human years? > > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Wednesday, June 06, 2001 9:55 PM > > >> >> Hello friend , Gurus >> >> I just start my Oracle developer job in April 2001, I feel interesting >in >> Oracle Dba jobs but my current job is stuck with only application >> development .How can I build up my DBA skill if I did't have chance on >doing >> the related jobs ? >> >> But I manage to build up a small system running testing in my home with >> Duron 750 + 128 Ram and 10 gig normal IDE , After I install my win2kpro >> ,oracle OEM and the database with pre-configuration option. everthing go >> smooth on that. >> >> I have manage to get a TOAD trial version to install in my win2k too , >but >> what now ? Is there any pratical or tutorial on this ? Or taking the OCP >> exam and exam cram to study will help ? >> >> >> >> Raymond fall asleep in waiting for the Q. >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Raymond Lee Meng Hong >> 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: Don Granaman > 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). > > >The information contained in this communication is >confidential, is intended only for the use of the recipient >named above, and may be legally privileged. If the reader >of this message is not the intended recipient, you are >hereby notified that any dissemination, distribution or >copying 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 computer >system. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Robertson Lee - lerobe > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: OT RE: Database writer
ity 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: Mohan, Ross >|| > 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). >|| >|| >|| _ >|| Do You Yahoo!? >|| Get your free @yahoo.com address at http://mail.yahoo.com >|| >|| -- >|| Please see the official ORACLE-L FAQ: http://www.orafaq.com >|| -- >|| Author: Jerry C >|| 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: Mohan, Ross > 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: Mark Leith > 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: Mark Leith > 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: Kevin Kostyszyn > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: query using OR operator
Try using the primary key value like if PRD_LVL_CHILD is the primary key then just add a where cond using and operator like PRD_LVL_CHILD>0. This will make the usage of index in the table PRCMSTEE. May be this is not the actual way, but we have tuned several queries like this and they all are working fine and doing well in our applns. -- On Tue, 05 Jun 2001 21:30:26 Suhen Pather wrote: >List, > >I require help with tuning a query. > >SELECT PRC_TYPE FROM PRCMSTEE >WHERE PRD_LVL_CHILD = 505 >OR PRD_LVL_CHILD IN (SELECT PRD_LVL_PARENT >FROM PRDMSTEE >WHERE PRD_LVL_CHILD = 505 ) >/ > > >Query Plan >-- >SELECT STATEMENT[CHOOSE] Cost=84 Rows=5026 Bytes=30156 > FILTER >TABLE ACCESS FULL PRCMSTEE [ANALYZED] >TABLE ACCESS BY INDEX ROWID PRDMSTEE [ANALYZED] > INDEX UNIQUE SCAN PRDMSTEEP1 [ANALYZED] > >Execution Plan >-- > 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=84 Card=5026 Bytes=3 > 0156) > > 10 FILTER > 21 TABLE ACCESS (FULL) OF 'PRCMSTEE' (Cost=84 Card=5026 Byt > es=30156) > > 31 TABLE ACCESS (BY INDEX ROWID) OF 'PRDMSTEE' (Cost=2 Card > =1 Bytes=7) > > 43 INDEX (UNIQUE SCAN) OF 'PRDMSTEEP1' (UNIQUE) (Cost=1 C > ard=1) > >Statistics >-- > 0 recursive calls > 4 db block gets > 237373 consistent gets > 0 physical reads > 0 redo size >541 bytes sent via SQL*Net to client >424 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 6 rows processed > >I am trying to reduce the logical IO for this query. >The query performs a full table scan on PRCMSTEE, which accounts for the >total cost of the query and high >LIO. > >I have run individual parts of the query and the LIO stays lows except when >the OR operator is used. >I know that the OR operator would supress the use of an index, but I also >tried using a index HINT, to force the use of the index, but >Oracle favours doing a full table scan on PRCMSTEE. >There is an INDEX on PRD_LVL_CHILD of PRCMSTEE. > >Is there a way to rewrite the query to reduce the LIO? > >Thanks and Regards >Suhen > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Suhen Pather > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
