RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Yes indeed It is.. :) -Original Message- Venu Gopal Sent: Thursday, January 22, 2004 1:59 PM To: Multiple recipients of list ORACLE-L Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To: [EMAIL PROTECTED] Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/ Searchable archives - http://www.freelists.org/archives/oracle-l Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal 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: Ganesh Raja 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: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
XACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F 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: Ganesh Raja 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: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time
>From the docs... ORA-01652 unable to extend temp segment by string in tablespace string Cause: Failed to allocate an extent for temporary segment in tablespace. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. So Check your Temp TBS. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Saira Somani Sent: Sunday, July 27, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow 8AM! Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Ganesh Raja 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: imp table data, but not PK indexes?
Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace "indexes" (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: Ganesh Raja 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: OR Vs UNION
Title: Message IMHO ... Cannot be.. the Access Path Taken is Different.. "OR" is Transfered to Inlist Iterator usually ... Best Regards,Ganesh RDID : +65-6215-8413HP : +65-9067-8474===Live to learn... forget... and learn again.=== -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Tuesday, June 24, 2003 11:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OR Vs UNION I believe OR is internally transformed to UNION (or UNION ALL) ?? The answer you are looking is ... test and measure it in _your_ _environment_. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! >- --- Original Message --- - >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 23 Jun 2003 21:34:52 > > > > > >Hi All, > >Could someone explain to me which one is best in >the following two queries >w.r.t performance? > >Thanks >Sami > >Query1) > >select distinct empployee_id from employees where >department_id=10 or >department_id=20 >/ > >Query2) >=== >select employee_id from employees where >department_id=10 >union >select employee_id from employees where >department_id=20 >/ >
RE: db file sequential read [WAS:wait event puzzler]
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Senthil Kumar D 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: Ganesh Raja 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: db file sequential read [WAS:wait event puzzler]
That is a Very Good Idea... We will do away with DDL Stmts will start writing directly into the Data Dictionary ... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Senthil Kumar D Sent: Thursday, June 12, 2003 7:35 PM To: Multiple recipients of list ORACLE-L Dear Bhaskar, You can modify col$.NAME to varchar2(60) and try. If this fails, I'll give a procedure you can use that to change it to whatever size you want. Senthil Kumar Sr Oracle DBA Summitworks Technologies Pvt Ltd -Original Message- Bhaskar Viswanathan Sent: Thursday, June 12, 2003 4:00 PM To: Multiple recipients of list ORACLE-L hi, We use Oracle 8 DB. I am not a Oracle technical guy. So lemme try explaining the problem. We need to create tables with columns, whose names(column-names) are more than 30 characters long. This is being restricted because, all columns of all tables have entries in a table called 'col'. Thit table is defined as: SQL> desc col Name Null?Type - TNAME NOT NULL VARCHAR2(30) COLNO NOT NULL NUMBER CNAME NOT NULL VARCHAR2(30) COLTYPEVARCHAR2(106) WIDTH NOT NULL NUMBER SCALE NUMBER PRECISION NUMBER NULLS VARCHAR2(19) DEFAULTVAL LONG CHARACTER_SET_NAME VARCHAR2(44) SQL> since CNAME is defined as VARCHAR2(30), we are forced to retrict column names to a max of 30 characters long. For eg. create table T1(x31 varchar2(50)); The above statement will be rejected with the error: * ERROR at line 1: ORA-00972: identifier is too long However, the statement "create table T1(30 varchar2(50))" Succeeds in creating the table; I guess this table col is created by the system itself. how can we change this size So that the 30 character restriction in column names can be avoided??? baski **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhaskar Viswanathan 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: Senthil Kumar D 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: Ganesh Raja 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: db file sequential read [WAS:wait event puzzler]
d in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhaskar Viswanathan 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: Ganesh Raja 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:
Request Denied... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Joerg Jost Sent: Thursday, June 12, 2003 12:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL -- - Software Engineering Vattmannstraße 7, 33100 Paderborn Phone: (+49) 52 51 / 30 1 6333 Fax: (+49) 52 51 / 30 16 399 eMail: [EMAIL PROTECTED] http://www.unitrade.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joerg Jost 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: Ganesh Raja 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: Upgradation Question on APPS 11i
ORACLE-L (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: Babette Turner-Underwood > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Senthil Kumar D 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: Ganesh Raja 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: Isolation Level to get Phantom Read
Maybe you can read up this... http://tinyurl.com/du9v Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Hi All, How to achieve Repeatable Read isolation level in oracle? I mean the application should allow Phantom Read but NOT Dirty Read,Lost Update & Non-Repeatable Read Note:- If i choose SERIALIZABLE isolation level Phantom read is NOT allowed if i choose Read Committed isolation Non-Repeatable Read is allowed. Any clarification would be really appreciated Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja 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: Re: Snapshot too old during stress test... how to avoid
> >> time in > >> the background in order to gather statistics and timing under worst case > > > >> scenarios. > >> > >> Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB > > > >> for this test. I have 4 standard RBS with optimal size set to 1GB. > >> Why would I get a snapshot too old? I would think that 11GBs of > >> rollback > > would > >> be big enough. Would increasing the number of Rollback segments > >> avoid > > this > >> even though I have the same amount of space in the tablespace? > >> > >> In reality Im going to seriallize the process to avoid this and to > > improve > >> performance, however, I want to stress the system. > >> > >> any advice? > >> > >> -- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >> -- > >> Author: <[EMAIL PROTECTED] > >> INET: [EMAIL PROTECTED] > >> > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > > http://calendar.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > 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: <[EMAIL PROTECTED] 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: Thomas Day 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: Ganesh Raja 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: Re: Snapshot too old during stress test... how to avoid
Actually when are u getting this error.. There are a Lot Of reasons for ORA-01555 and primary one is DB Block Cleanout or Long Running quries... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:10 PM To: Multiple recipients of list ORACLE-L the thing is Im not doing any of that. Here is waht Im doing. update,inserts and deletes on tables select on data dictionary. Im also doing 'create table as' Transactions do NOT overlap. for example update,insert,and delete will not use the same tables in different transactions. and Im not updating the data dictionary. > > From: "Ganesh Raja" <[EMAIL PROTECTED]> > Date: 2003/06/05 Thu AM 10:09:52 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: Snapshot too old during stress test... how to avoid > > Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. > Now this Bock was updated an Hour ago and u are now selecting it.. It > finds that there are ITL Entries in there and oracle wants to see if > the Transaction has been commited. > > He Goes back to the Transaction Table of the RBS Pointed by this ITL > and he finds that there is No Rollback entry available.. Why is this > ??? The Optimal Parameter Shrunk the RBS Down and with it all the Undo > Information needed to do a Block Clean out. > > HTH > > Best Regards, > Ganesh R > DID : +65-6215-8413 > HP : +65-9067-8474 === > Live to learn... forget... and learn again. > === > > > -Original Message- > [EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 8:32 PM > To: Multiple recipients of list ORACLE-L > > > why would removing optimal setting help with snapshot too old? > > what I dont understand is that each of my DML transactions are > independent of each other. They query and perform DML on different > tables. None of them overlap. The only time they overlap is when they > hit the data dictionary for some brief queries. > > > > From: Tim Gorman <[EMAIL PROTECTED]> > > Date: 2003/06/05 Thu AM 03:25:36 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: Snapshot too old during stress test... how to avoid > > > > Speaking of this trick with a txn in each RBS, I've got a shell > > script > > > on my website (http://www.evdbt.com/tools.htm) that does just that. > > It is named "prevent1555.sh" which uses a stored procedure created by > > a SQL script named "prevent1555_ddl.sql"... > > > > As Jared mentioned, it is kind of a last resort, but it works... > > > > > > > > > > on 6/4/03 4:05 PM, [EMAIL PROTECTED] at > > [EMAIL PROTECTED] > > wrote: > > > > > .. and if it still doesn't work, use the trick of putting a > > > transaction in each of the rollback segments while the system is > > > otherwise quiesced, and *do not* commit or rollback the > > > transactions. > > > > > > This forces the rollbacks to extend if necessary, they will never > > > wrap back to the first extent ( actually the second) as long as > > > those transactions are not committed. > > > > > > It just uses a lot of disk space. Disk is cheap, right? :) > > > > > > Consider offlining all your production RBS and creating temporary > > > ones that you can easily drop later. > > > > > > I've used it with SAP client copies, which will not run to > > > completion without doing this, at least on our system. > > > > > > Jared > > > > > > > > > > > > > > > > > > Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: > > > [EMAIL PROTECTED] 06/04/2003 09:45 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > cc: > > > Subject:Re: Snapshot too old during stress test... how > to avoid > > > > > > > > > Try removing optimal setting, and shrinking RBS to the min extents > > > (or even below) before running your tests. > > > > > > - Kirti > > > > > > > > > --- Garry Gillies <[EMAIL PROTECTED]> wrote: > > >> F
RE: Re: Snapshot too old during stress test... how to avoid
snapshot too old? I would think that 11GBs of > >> rollback > > would > >> be big enough. Would increasing the number of Rollback segments > >> avoid > > this > >> even though I have the same amount of space in the tablespace? > >> > >> In reality Im going to seriallize the process to avoid this and to > > improve > >> performance, however, I want to stress the system. > >> > >> any advice? > >> > >> -- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >> -- > >> Author: <[EMAIL PROTECTED] > >> INET: [EMAIL PROTECTED] > >> > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > > http://calendar.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > 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: <[EMAIL PROTECTED] 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: Ganesh Raja 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: example to use bind variables with OO4O/VB
Check out http://asktom.oracle.com HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Khanna J Sent: Thursday, June 05, 2003 8:00 PM To: Multiple recipients of list ORACLE-L Guys, can someone give a simple example ( piece of code ) for: How to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? ..peeped into metalink too. can u give me any other example / URL for the same ???! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Ganesh Raja 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: Shite of the day
Set the Compatiable Parameter to the Actual Version you Upgraded and not to any patch rel that was rel later on. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Lisa Sent: Wednesday, June 04, 2003 10:40 PM To: Multiple recipients of list ORACLE-L Oh-My-Gosh. Worry free? I just upgraded another 8.1.7.4 database to 9.2. When I set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors: ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release 135294976 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0 So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I get the same type of error. It won't open at all. I tried initiating recovery. This database is in noarc mode. It starts looking for arclogs that *do not* exist. I also tried to drop the redo log groups and recreate them. Still, no dice. Again, unbreakable my FUNDAMENT. So has anyone seen this before? I opened a tar yesterday and promptly confused support. Lisa -Original Message- Sent: Wednesday, June 04, 2003 7:45 AM To: Multiple recipients of list ORACLE-L "Trade SQL Server for Oracle9i Database and get up to 100% license credit and peace of mind. Tired of applying patches? Frustrated with managing mulitple database servers? In the time it takes you to apply all Microsoft's patches to your servers, you can successfully migrate your database to Oracle9i Database and be worry-free. " >From http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462&Act=16 I don't understand PR of Oracle. The RDBMS has so much properties which are much more better implemented in Oracle than in MS SQL and they choose 'patching' which *** on both servers. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner 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: Koivu, Lisa 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: Ganesh Raja 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: RE: Schedule Analyze using DBMS_STATS ???
There are a Lot of options to DBMS_STATS .. And be Judicious in using the same. Read the docs before attempting it. BTW .. What is the session waiting for .. Just Check v$session_wait. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Keshava Murthy (Cognizant) Sent: Wednesday, June 04, 2003 8:55 PM To: Multiple recipients of list ORACLE-L Hi all, Everyone is recommending DBMS_STATS to be used for computing the statistics. But even after specifying the parallel option , DBMS_STATS is taking lots of time ! in comparison to Analyze... In case of tables with a million records the query just hangs when i use the stats package... Can anybody tell me whts happening ? Regards kesh -Original Message- Sent: Tuesday, June 03, 2003 8:55 PM To: Multiple recipients of list ORACLE-L Sorry JP, I should have clarified that DBMS_STATS is the way to go, when on a 9i or above release. One of the simple factors being that ANALYZE is being deprecated.. There seemed to be a number of bugs/quirks, whatever you want to call them, in certain 8.1.x versions, which are now fixed within 9i.. There's a number of threads about the issues, available in the list archives (you can find them at http://www.faqchest.com), which I dug around - as I remembered seeing a post by Connor McDonald, where he gave away an alternate script to gather stats, here's the mail: http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0210/ora-021011/ora0210 0802 _06150.html I think the general consensus is that DBMS_STATS is quicker. I've never personally done any comparative benchmarks to corroborate this sheep following attitude though.. ;) Regards Mark -Original Message- Sent: 03 June 2003 14:55 To: Mark Leith Cc: [EMAIL PROTECTED] Thanx a lot Mark. Sure , your code has given me a starting point. let me change accordingly to use DBMS_STATSe and give a try :-) So,can i conclude that DBMS_STATS is better than ANALYZE ?! Someone over the list mentioned that DBMS_STATS is slower. is it so ? What is your opinion regarding this ?! just curious to know ! Regards, Jp. 3-6-2003 22:01:32, "Mark Leith" <[EMAIL PROTECTED]> wrote: >Prem, > >Use DBMS_JOBS to run the analyze: > >=== > >undef username >undef password >grant analyze any to &&username >/ > >connect &&username/&&password > >CREATE or REPLACE PROCEDURE analyze_tables ( > v_stat_type IN VARCHAR2 := 'COMPUTE') AS > CURSOR c IS > SELECT DISTINCT owner > FROM all_tables > WHERE owner not in ('SYS','SYSTEM'); > BEGIN > FOR any_row IN c LOOP >dbms_utility.analyze_schema( > any_row.owner,v_stat_type); > END LOOP; > END; >/ > >=== > >variable jobno number >declare jobno number; > BEGIN > dbms_job.submit(:jobno, >'begin &&username.analyze_tables; end;', >to_date('03jun0304:00','DDMONYYHH24:MI'), >'trunc(sysdate)+(1+(4/24))'); > END; > >=== > >The above will run a COMPUTE analyze on all schemas, except SYS and SYSTEM, >at 4:00am every day. Modify it to your own needs, but it should give you a >starting point.. > >I would also recommend using DBMS_STATS to generate your statistics. > >Have fun! ;0) > >Mark --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: exp, dbms_stats, RMAN and rollback segments
A Large Load or Update Before the Exp ... Delyed Block Clean out is one Reason that really pops out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Sent: Friday, May 30, 2003 12:15 AM To: Multiple recipients of list ORACLE-L A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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: Ganesh Raja 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: PL/SQL- cursors and commits
Title: Message This is the last thng u will be writing .. a Commit inside a Loop for every n records processed. First Like Ashish Said u will get ORA-01002 and apart from this u will hit by a bigger problem.. ORA-01555 on long running quries.. HTH Best Regards,Ganesh RDID : +65-6215-8413HP : +65-9067-8474 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AshishSent: Saturday, April 05, 2003 12:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PL/SQL- cursors and commits As the book says, it fails with following error (9.2.0.1 on Win2k). declare*ERROR at line 1:ORA-01002: fetch out of sequenceORA-06512: at line 12 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Wiegand, KurtSent: Friday, April 04, 2003 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: PL/SQL- cursors and commits I've been 'experimenting' with the following code in 8.1.5 and it seems to work fine. However, my "ORACLE PL/SQL" book from O'REILLY (Steven Feuerstein Bill Pribyl 1997) leads me to believe that it should not work. They state "As soon as a cursor with a FOR UPDATE is OPENed, all rows...are locked. When [a COMMIT]..occurs, the locks...are released. As a result, you cannot execute another FETCH against a FOR UPDATE cursor after you COMMIT.." They go further to suggest an ORA-01002 would be returned. Any comments? Thanks. Kurt Wiegand [EMAIL PROTECTED] declare local_f1 ctest.f1%TYPE := 0; local_f2 ctest.f2%TYPE := 0; batch_count number(6) := 0; cursor c_select is select f1,f2 from ctest for update; begin open c_select; loop fetch c_select into local_f1, local_f2; exit when c_select%NOTFOUND; update ctest set f2 = f2 + 1 where current of c_select; batch_count := batch_count + 1; if batch_count > 99 then batch_count := 0; commit; end if; end loop; close c_select; commit; end;
RE: Anyone whom could explain this?
New maybe a Package and the Variables may be Public variables. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 -Original Message- John, Tech Dev Sent: Thursday, April 03, 2003 7:59 PM To: Multiple recipients of list ORACLE-L Is this procedure being run with a trigger Roland? If so then the :new refers to the value of each row that is being inserted from the table To explain better if an update triggger is on table roland with columns (road,town,country) and one row is in the table with values Main Rd, Leeds, England and the row is being updated to be New_Main Rd, Leeds, England then the following values will be in place old:road = Main Rd new:road = New_Main Rd old:town = Leeds new:town=Leeds old:country = England new:country=England. That is about 100% of my PL/SQL knowledge so I hope I am correct John -Original Message- Sent: 03 April 2003 11:09 To: Multiple recipients of list ORACLE-L Hallo, anone whom could explain what new. means in this pl/sql procedure. for instance: new.kundeoms := new.kundeoms + (in_diff); new.mva := new.mva + (in_diff_mva); How do I get hold of it so i can see which sql it runsor is new.kundeoms just a value from a table? PROCEDURE add_kundeoms(in_diff in number, in_diff_mva in number, in_diff_brtkr in number, in_flagg in varchar2) IS lDetaljFunnet boolean; BEGIN IF in_flagg = '0' THEN new.kundeoms := new.kundeoms + (in_diff); new.mva := new.mva + (in_diff_mva); new.kostverdi := new.kostverdi + (in_diff - in_diff_mva - in_diff_brtkr); ELSIF in_flagg = '1' THEN new.utg_pant := new.utg_pant + (in_diff); ELSIF in_flagg = '9' THEN new.shop_in_shop := new.shop_in_shop + (in_diff); ELSIF in_flagg = '5' THEN new.rest_oms := new.rest_oms + (in_diff); END IF; BEGIN db_dagoms_detalj.find(new.dagoms_id, in_flagg); lDetaljFunnet := TRUE; EXCEPTION WHEN OTHERS THEN lDetaljFunnet := FALSE; END; IF lDetaljFunnet THEN db_dagoms_detalj.edit; db_dagoms_detalj.add_kundeoms(in_diff, in_diff_mva, in_diff_brtkr); db_dagoms_detalj.modify; db_dagoms_detalj.close; END IF; END; END; Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev 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: Ganesh Raja 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
gt;__ >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] > >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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja 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
Your PGA directly Affects the Amt memory the OS has to shell out for Oracle Server Process so Increasing the Sort_Area_Size does not have immd effect but if your users are going to do a sort then your PGA can grow to a Maximum of Sort_Area_Size before being pulled down to the Temp Segments. Just make sure u size it appropriatley. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 -Original Message- Kumar Sent: Monday, March 31, 2003 6:04 PM 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja 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: Buffer busy waits are 10.96% of non-idle waits
Fro my clarity .. What does the extent size has to do with segment header contention. And about index rebuilds.. Why do u say that this will cause a Problem for the waits he is Experencing. Hope to get some clarity on this... Thanks Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 == Live to learn... forget... and learn again. == -Original Message- Muthukumaren Sent: Friday, July 12, 2002 6:13 PM To: Multiple recipients of list ORACLE-L Hi, Your major problems with buffer busy waits are in the Data blocks class: (1), undo block(2), segment header (3) For Data block Class: Solution: 1. Reduce no of rows by changing pctfree/pctused 2. check when the last time your indexes were re-built and rebuild them often (indexes causing inserts into the same block will be reduced) For undo block class : Solution: 1. Increase the size of the rollbacksegment For segment header : Solution: 1. Add more freelists and or freelist group 2. Check your extent sizes (may be it is too small) - Hope this helps, Thanks, Kavi oraora oraora wrote: > Hi Kavitha, > > querying v$waitstat gives me the o/p below. > > CLASS COUNT TIME > -- -- -- > data block 131525173 225446798 > sort block 0 0 > save undo block 0 0 > segment header 4968 16264 > save undo header0 0 > free list 0 0 > extent map 0 0 > bitmap block0 0 > bitmap index block 0 0 > unused 0 0 > system undo header 0 0 > system undo block 0 0 > undo header 1582 14 > undo block 45965 3008 > > the data block above belongs to a datafile USERS01.DAT which has all > the tables and indexes the application uses. > > the top 25 SQL statements are always SELECT statements. > they get executed repeatedly. > is it b'coz all SQLs are with literals and no bind variables ? > > it's a highly read OLTP system. > > will not > -- using bind variables instead of literals > -- seperating tables and indexes to diferent tabelspace > > solve my problem ? > > Regards, > prem. > > On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote : > > > >Hi , > > > >TOAD gives this alarm often. what does it mean ? which view will > >give me the wait statistics ? > > > >Answer : > >== > >Please run STATSPACK to if this is one of the top waitevents to check > >if the percentage of wait - can be treated as problematic one > > > > SELECT p1 "File", p2 "Block", p3 "Reason" > > FROM v$session_wait > >WHERE event='buffer busy waits' > >Repeatedly run the above statement and collect the output. After a > >period of time sort the results to see which file & blocks are > >showing > >contention: > > > > > >" it occurs when a session cannot access a block because it is in > >use by another session. The two most common causes are > >insufficient free lists for a table or insufficient rollback > >segments. " --- IS THIS THE REASON ? > > > >Answer: > >== > > Yes on top of the wait event could also occur > > could also occur if > > > >a. if the application is going against a set of same blocks (hot > >blocks) > > > >Thanks, > >Kavi > > _ > There is always a better job for you at Monsterindia.com. > Go now http://monsterindia.rediff.com/jobs > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: oraora oraora > 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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Service
RE: Re: sequential reads/scattered reads
Hi, Moving to different Tablespaces will not do u any good. To learn more there was big List of Disscussion on... Comp.databases.oracle.server [ Google Groups http://groups.google.com ] You can go and seasrch there seperating Tables and Indexes. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 == Live to learn... forget... and learn again. == -Original Message- oraora Sent: Thursday, July 11, 2002 7:29 PM To: Multiple recipients of list ORACLE-L Thanx Thomas . i am pretty new to RAID. will not moving my tables and indexes to seperate tablespace reduce my i/o ? my h/w setup is: there is a logical partition D: of size 80GB with RAID5. is it enough that i move to seperate tablespace ? os should i create another partition like D: and put my files there ? i am novice DBA . plz. guide me Thomas. On Thu, 11 Jul 2002 Thomas Day wrote : > >If you can move the indexes to a separate physical device (and >their own >tablespace/datafile) then you will reduce I/O contention. If >the >tablespace/datafile is on the same RAID device then you will be >using the >same r/w heads and you will not reduce I/O contention. > > > > oraora > oraora To: Multiple >recipients of list ORACLE-L > <[EMAIL PROTECTED]> > @rediffmail.ccc: > om> Subject: sequential >reads/scattered reads > Sent by: root > > > 07/11/2002 > 07:33 AM > Please > respond to > ORACLE-L > > > > > > >Guys, > >Querying my v$session_wait shows 10 rows each DB FILE >SEQUENTIAL >READ and DB FILE SCATTERED READ. > >manuals explain it all b'coz of I/O. > >there are 33 tables and 110 indexes in the same USERS >tablespace >with only one datafile USERS01.DAT of size 12GB. > >it's physically laid out in D:\oracle\data. >but the hard disk capacity is 100GB with 8 disk heads and >RAID5. > >will not moving the tables and indexes to seperate tablespace reduce >I/O traffic ? my manager here says that since it is configured with >RAID5 and 8 disk heads , it's not a problem. > >is it so ? is he right ? >plz. clarify me. i need to explain him. >it's urgent.he is sitting on my head. > >TIA. >_ >There is always a better job for you at Monsterindia.com. >Go now http://monsterindia.rediff.com/jobs > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: oraora oraora > 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: Thomas Day > 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). _ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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 'ListGu
RE: Unindexed foreign key
Whenever You Modify the Parent Table rows the Child Table is Entirely Locked so that no DML Takes Place. Also If there are no Indexes on the FK. Oracle Will have to do a FTS for all the Quries that you are going to Join with the Parent Table. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 == Live to learn... forget... and learn again. == -Original Message- Kumar Mishra Sent: Thursday, July 11, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Hi Gurus! How does the unindexed foreign key affect the performance ? regards Shishir Kumar Mishra Agni Software (P) Ltd. www.agnisoft.com -- Vidya Dadaati Viniyam -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Case stmt not compiling
This is due to the difference betweeen the PL/SQL Compiler and SQL Compiler. This has been rectified from 9i onwards One way to achive this is to Create a view and access this View in Pl/sql. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:03 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: INITRANS question
5/25 Sounds a Bit High. Maybe you should check your waits and see if there is a contention for Block Headers and if so then try increasing it till u get a Pretty low number. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Alavi Sent: Thursday, June 13, 2002 9:04 PM To: Multiple recipients of list ORACLE-L Hi List, I have few tables with a lot of transaction by many users, I change the Initrans from 1 to 5 and for some to 25, My question is what's the best way to findout which value is the optimum value for INITRANS for each table? Thanks for Help. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Ganesh Raja 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: Cleanup of child records...
You can Enable Parallel PML and Delete the Records on the child Table that are not there in the Parent Table. You can use the Not Exists instead of the Not In. If you are going to use the In Caluse then ry enabling Parallel Optiuon on the select also ... HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Huntley Sent: Thursday, June 13, 2002 8:59 PM To: Multiple recipients of list ORACLE-L TIA List, What is the most efficient way to remove child records from a table that have no parent records in it's parent table. I want to build a FK, to keep this from happening, but I need to do some cleanup first. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Sql loader question
You don't have a \ after I: That may be a Problem. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 11, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Hallo I am running this script but gets this errormessage: Why is it so? I get the errormessage The system cannot find the file specified.(I:dvh\tuppy.txt) but this file really exists: What is wrong. I include the textfile and also the ctl file. (See attached file: nielsen.ctl)(See attached file: Tuppy.txt) please check the files and see what is wrong. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Basic Question
Santosh, I wuould suggest you to take the Concepts Manual and read it. it is available Free of cost at otn.oracle.com which requires registration and that is also free. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 11, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Could any body tell me the different between DataFiles and TableSpaces ? Is it that Datafiles are the tables in a Database and Tablespaces are the spaces allocated for each table with Datafiles in that ??? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Type problems with PL/SQL function as a Java wrapper.
Main is a reserved function in Java you cannot use that in your programs. I just did this by changing the name to test. And it works. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Rich Sent: Tuesday, June 04, 2002 9:09 PM To: Multiple recipients of list ORACLE-L Hey all, Trying to get into this new fangled "Java" thingy in 8.1.7.2.0 on HP/UX. Simple OS exec test, mostly plagarized: // qlp.java import java.lang.Runtime; import java.lang.Process; import java.io.IOException; import java.lang.InterruptedException; public class qlp { public static int main(String args) { int retval = 0; try { String lpCommand; lpCommand = "/usr/bin/lp " + args; Process p = Runtime.getRuntime().exec(lpCommand); try { p.waitFor(); } catch (InterruptedException intexc) { System.out.println("Interrupted Exception on waitFor: " + intexc.getMessage()); } retval = p.exitValue(); } catch (IOException e) { e.printStackTrace(); } return (retval); } } // End of Java code I run javac to compile it, then loadjava the class file into the DB. I can then create a PL/SQL procedure as a wrapper: CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2) AS LANGUAGE JAVA NAME 'qlp.main (java.lang.String[])'; / And it works, but I need to test for success/fail. But if I try a FUNCTION wrapper: CREATE OR REPLACE FUNCTION qlp_func (file_and_parms IN VARCHAR2) RETURN NUMBER AS LANGUAGE JAVA NAME 'qlp.main (java.lang.String[]) return int'; / I get PLS-00311: the declaration of "qlp.main (java.lang.String[]) return int" is incomplete or malformed. Two questions: 1) Every example I've seen of the wrapper excludes the brackets from the java.lang.String parameter def, but I can't get a compile without it. Why? And 2) Anyone know what's wrong with my FUNCTION def? Desperately needing a good Java tutorial, too! TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Ganesh Raja 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: Urgent: Retrieving Disk Space
I am just going to repeat the question all the people here have asked what was the users Temp Segment when he ran the CTAS. You have Made a Mistake there. Try Resizing the system Tablespace. To a Lower Value but that may not happen. If that does not happen u will have to move the temp tablespace out of that disk and don't ever have your system Tablespace for a User Other Than Sys not even System. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Ganesh, The query didn't get completed because of the disc space. Temp01.dbf size is about 1GB System01.dbf size is nearly 4GB against last nearly 1GB Aleem -Original Message- Sent: Tuesday, June 04, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: Urgent: Retrieving Disk Space All the files you mention here are critical files. What is the Temp File Size. Did u see that. Why did the table not get created. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Urgent: Retrieving Disk Space
All the files you mention here are critical files. What is the Temp File Size. Did u see that. Why did the table not get created. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: profile
Set Resource_Limit = TRUE in the Parameter File. Then Create a Profile that uses Cpu_Per_Call and CPU_Per_Session values so that CPU Usgae is restricted. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Hello guru How can I set a performance of CPU for 1 session at 15 % in profile I hawe Oracle 8.1.7 . R 3 . Thanks Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= 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: Ganesh Raja 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: Pkg Body variables
Pkg Variables are Presistent for the session. They Get Deallocated once the session dies. So It will not be available for the next SQLLDR Run. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Hi, I am calling a packaged function in sql loader control file. I 've declared a variable in pkg body to hold old value . I am comparing this with current value obtained from sql ldr and also storing last value in the old value variable. My question is will the package variable declared above retain its value after each run of sqlldr. if yes then how to reset this value before the next run. Note : userid remains same for each sqlldr run. Thanks Manoj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Jr.DBA, Mid level DBA, Sr.DBA
Don't forget the Restart for Every Update Even if it is a security patch for IE. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Sunday, June 02, 2002 4:58 PM To: Multiple recipients of list ORACLE-L What's wrong with M$, please, the ever crashing OS, need anything else be said? And Stephane hit it perfectly. As far as I remember(feel free to brutalize me if wrong), that M$, even back in the DOS days, was never a development platform for Oracle and I used V5 on 386 under DOS. Let the flames begin. Joe Stephane Faroult wrote: >ltiu wrote: > >>What's wrong with M$FT. Most people use it : > The majority cannot be >>wrong. What's wrong with you guys. If it works, then use it. If you >>can make it work, then use it. If you can pretend that it works, then >>use it too. >> >>ltiu >> > >Hmmm, Oracle and Microsoft are not fully compatible. There is no love >lost between Ellison and Gates. Historically, Oracle was a port to >Digital (remember this brand?) machines of IBM specs, and started its >conquest of the world from minicomputers; market forces being what they >are, Oracle came to run on M$ systems, but many (and especially older >hands) Oracle DBAs consider M$ systems to be for wimps, just good for >running Access and possibly SQL Server. Whether it is founded or not is >another matter. > >Concerning your assessment that the majority cannot be wrong, I admire >your faith in democracy. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: Ganesh Raja 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: Any Equivalent of SAR command in NT/2000
No Qeuivalent Command is there but the performance Monitor App will dothe work for you to some extent. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 29, 2002 2:24 PM To: Multiple recipients of list ORACLE-L I run sar 10 3600 >> /var/sun/cpuusage.log to monitor the performance between peak hours ,,, I have 16 Windows 2000 APPLICATION servers running citrix and some seem to be giving poorer performance than others: If I can monitor CPU and Memory and pipe it to a batch file, as I do in UNIX, it will be a great help: Can this be done ? -- 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: Ganesh Raja 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: online backup and alter system switch logfile
Yes Alter System Achive Log Current is the way to go. Now regarding what are the archive logs hat I will backup. My Script at the End of Each Backup routine will Backup all the archive Logs and then delete the same from the Log Dest in this way I only backup all the Logs that have been generated since the last backup and also by doing this I free a lot of space in my Archive Location. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 29, 2002 1:03 PM To: Multiple recipients of list ORACLE-L it looks like alter system archive log current; is the way to go. Can anyone please clarify waht archived logs should be backed up when doing a online backup? I have seen various online backup scripts that seem to take different approaches. I have also seem the comment "a backup script should never just back up "all the archived redologs." If a script does not restrict itself only to those logs that it knows to be archived, it may improperly try to back up an archived redolog that is not yet completely archived. To determine which logs are archived, a backup script should query the v$archived_log view to obtain a file list for copying." What apporoach do you guys take? > -Original Message- > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > Sent: 28 May 2002 16:18 > To: Multiple recipients of list ORACLE-L > Subject: Re: online backup and alter system switch logfile > > On Tue, 28 May 2002, [EMAIL PROTECTED] wrote: > > > Add a 'sleep' command to your UNIX-side shell script before you copy > > the logs to ensure the log has finished writing. You need to have > > that last archivelog - it contains the data regarding datafile > > header record changes you'll need to apply in the event you have to > > restore to sync up your controlfile. > > Sleep doesn't seem like a very reliable approach here. As has already > been mentioned, Oracle provides a command that does not return until > the current log is archived. > > alter system archive log current; > > In fact, this is one of the Oracle misconceptions I wrote about: > > http://www.speakeasy.org/~jwilton/oracle/switch-logfile-backups.html > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > > John Dunn <[EMAIL PROTECTED]> > > > > I have a online backup script which issues the command > > > > ALTER SYSTEM SWITCH LOGFILE; > > > > immediately before copying the archived redo logs. > > > > Does this make sense? I am finding that the ARC process has not > > finished archiving the log before I copy the archive logs > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > 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 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: Ganesh Raja 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 my table analyzed with compute/estimate
There is a Column in DBA_TABLES that say what is the Sample_Size Used if this is Null then u have comnputed else u have estimated. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 29, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Hello All, Can somebody help me on this how to know whether my table was analyzed last time with COMPUTE / ESTIMATE. what I guess is , if the num_rows (dba_tables) are equivalent to count of the rows in my table, I guess it was analyzed with compute statistics. I think it is not accurate to find it. Can somebody through somelight on this how to know that. Regards, Srinivas __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa 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: Ganesh Raja 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: online backup and alter system switch logfile
You Should Be Using Alter System Archive Log Current / ALL This will wait till the archive Process has written out the archivelog unlike the Alter System Switch Log file. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, May 28, 2002 3:08 PM To: Multiple recipients of list ORACLE-L I have a online backup script which issues the command ALTER SYSTEM SWITCH LOGFILE; immediately before copying the archived redo logs. Does this make sense? I am finding that the ARC process has not finished archiving the log before I copy the archive logs 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: Ganesh Raja 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 pick the lastes file using UTL_FILE package ?
1. Run a Cron Job that every Hour Runs the Ls command with the necessary switches to sort the file listing by the date and redirect the filename to a Flat file. 2. Run a Job In Oracle that will open that particular file and read the contents of that file and open the file mentioned therein. There are always other ways to achieve this by means of a Java Stored Proc running inside Oracle without a Cron Job. You can search for Executing external Commands inside a Procedure in http://asktom.oracle.com [Which I blv is down today] HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, May 27, 2002 10:18 AM To: Multiple recipients of list ORACLE-L list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k -- 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: Ganesh Raja 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: novice learns a new thing
Ther is Nothing Strange in this. If you see the Object was owned By hlledw. You granted the Rights to Both Scott and Test but there was not Object named edw_% in these schemas. Then u Tries to describe the Object thru hlledw and that worked but when u tried to acces it thru scott it did not work because as mentioned above there was no schema object so u got an error. Now U wen into scott and created a Synonym for the hlledw object and hen there was a Object named edw% in scott and hence when u again accesed it it redirected the request to the hlledw schema and u got the result. Hope u got it. Now my $0.02 Cents I feel u should pick up a good book like Oracle 8i Complete Reference and read it from back to back. Also complement that book with the concepts manual and the books by thomas kyte -- Beginning Oracle Programming and Expert One-On-One Oracle. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, May 27, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL> conn hlledw/hlledw@orcl9i Connected. SQL> grant select on edw_week_lvl to scott; Grant succeeded. SQL> grant select on edw_week_lvl to test1; Grant succeeded. SQL> conn scott/tiger@orcl9i Connected. SQL> desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL> conn test1/test1@orcl9i Connected. SQL> desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL> desc scott.edw_week_lvl ERROR: ORA-04043: object scott.edw_week_lvl does not exist SQL> conn scott/tiger@orcl9i Connected. SQL> create synonym edw_week_lvl for hlledw.edw_week_lvl; Synonym created. SQL> desc edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL> conn test1/test1@orcl9i Connected. SQL> desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL> desc scott.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL> = This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: MTS and Dedicated Server
Yes you just need to do that. Then your server will only accept Dedicated connections. All DBA Operations should be performed on a dedicated connection to the database so if you have enabled MTS you can still connect to a dedicated server process via the listener by saying srvr = dedicated in the tns entry. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Sunday, May 19, 2002 5:18 PM To: Multiple recipients of list ORACLE-L Hi friends : I just finished to install my database with shared server option, so i have some parameters like mts_ My question : 1.) How can I do for to take out this option and put the database in Dedicated Mode ? 2.) What can I do for use two kinds of options simultaneity: Shared and Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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: Ganesh Raja 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: Alter table failes with ORA-00054:resource busy
Why don't u do this during off peak hours. Anyways what u can do is take a Lock on the table and wait till the lock is obtained and then alter tahe table. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Saturday, May 11, 2002 11:13 AM To: Multiple recipients of list ORACLE-L I want to alter a table and add a new column on our production database. I am getting the following error ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified Some user/process is holding the lock on this table.I have tried at different times and still cannot get it done.There are some processes that will comtinuously use these tables. How can I add the column. Ravi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Steps in db opening from mount stage to open stage????
The conecpts guide in the doc explains a lot about the startup mount and open stages... HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, May 06, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Dear Guru, I want to know all the internal steps happen during opening database from mount stage. For e.g. SMON cleans temp segment, block corruption check, SCN check.. etc.. etc.. Where can I find these details.. Any suggestion/input? TIA, Best Regards, Sandeep. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Kurliye 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: Ganesh Raja 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: Wierdness during script in SQLPlus
The Doc> is the Comments Written in the file Between /* */ That comes in 8i unable to checck in 80... Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 3:28 PM To: Multiple recipients of list ORACLE-L I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL> analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL> analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL> DOC>*/ DOC>spool off DOC>exit DOC> DOC> What is happening when the prompt goes from "SQL>" to "DOC>"?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? Thanks, Dave -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: stored procedure status
That means That the Procedure is invalid ... ;-D Try to Compile the procedure and see what error u'r getting that may help. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 1:43 PM To: Multiple recipients of list ORACLE-L I am doing the same but I don't know why stored procedure's( the called proc) error is not handled in my block. It is coming out of PL/sql block sayin that my procedure is invalid. STAARSHIP TECHNOLOGIES www.staarship.com Kranti Pushkarna Project Leader Tel: +91-22-6931557 __ " Failure to prepare is preparing to fail " __ -Original Message- Sent: Wednesday, May 01, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Use Exceptions... Ex. Begin StroedProc1 StoredProc2 Exception When Others Then Error Raised .. Aborting... End; HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 11:43 AM To: Multiple recipients of list ORACLE-L Hi list, I have writeen a stored procedure to execute a set of stored procedures. I want to know is there any way to stop the procedure after any of stoed procedure( from the set) returns an error. In simple words, is it possible to get a status whether the called procedure was successful or not. TIA Kranti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna 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: Ganesh Raja 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: kranti pushkarna 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: Ganesh Raja 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: Two instances with same name on the same Server
Service_Name is the Db_name + db_domain. It is used by the instance for atomatic registration to the listener ... SID is the System Identifier which uniquely identifies your Instance. This is used in unix to get a Memory Area. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 10:23 AM To: Multiple recipients of list ORACLE-L What's with the Service_name? vs. SID? On Tuesday 30 April 2002 18:03, you wrote: > ORACLE_HOME + ORACLE_SID together uniquely identify an instance. > > Anjo. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: Ganesh Raja 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 tables from sql Server to Oracle
There are two ways .. 1. Use Procedural Gateways to get at SQL Server Tables thru Oracle and do a CTAS. 2. Bring the data onto a Flat file using the export utility in SQL Serer and upload to Oracle using SQL Loader. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 1:17 AM To: Multiple recipients of list ORACLE-L Hi listers, Can someone tell me how import tables from SQLServer to Oracle. Thanks for your help, Ben __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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: Ganesh Raja 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: stored procedure status
Use Exceptions... Ex. Begin StroedProc1 StoredProc2 Exception When Others Then Error Raised .. Aborting... End; HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 11:43 AM To: Multiple recipients of list ORACLE-L Hi list, I have writeen a stored procedure to execute a set of stored procedures. I want to know is there any way to stop the procedure after any of stoed procedure( from the set) returns an error. In simple words, is it possible to get a status whether the called procedure was successful or not. TIA Kranti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna 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: Ganesh Raja 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 deinstall oracle 9i and leave 8i intact
There Should Be No Problems in this. Run the Universal Installer and Go to nstalled Products and Remove 9i. That should do the trick. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, April 30, 2002 4:26 PM To: LazyDBA.com Discussion Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Size of segment
Hey and Another Thing there is No Performance Benift By Putting them on different Tablespaces. So For Easier Management the Original Poster can Put it in Different TBS and not For any performance Reasons. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 6:23 PM To: Multiple recipients of list ORACLE-L On Mon, Apr 29, 2002 at 05:13:22AM -0800, Ganesh Raja wrote: > My Suggestion would be to give Uniform sized Extents and move the > table and Index into that tablespace. -- You are taking a preformance hit having the indexes and tables in the same tablespace, are you not? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Ganesh Raja 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: Size of segment
Sorry that I was not explicit .. If you are experiencing high Transactions You need to put the Tables and Indexes on Different Tablespaces [ again Uniformly Sized] Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 6:23 PM To: Multiple recipients of list ORACLE-L On Mon, Apr 29, 2002 at 05:13:22AM -0800, Ganesh Raja wrote: > My Suggestion would be to give Uniform sized Extents and move the > table and Index into that tablespace. -- You are taking a preformance hit having the indexes and tables in the same tablespace, are you not? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Ganesh Raja 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: bitmap indices
Hope you are using the CBO and not the RBO. If yu use a Bitmap Index then the Optimizer will use a CBO and if the stats are not proper then u may not get a Proper Result. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 4:43 PM To: Multiple recipients of list ORACLE-L hi! to speed up queries i have created a bitmap index on a column that contains 2 chars as a maximum. to my surprise the bitmap index does not make the query quicker than the 'usual' B-tree index, though there are only bout 100 different values in half a million rows. has n.e.one got experience with bitmap indices? are there any further poosibilities to adapt them when creating??? tia & bye daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser 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: Ganesh Raja 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: Size of segment
Physically No Extents, No Blocks are Contigous.. There is No Use in Bringing the Entire Table 1 or 10 Extents. If you have Used PCTIncrease in your TBS then Over Time Your Tables and Indexwes will be fragmented. My Suggestion would be to give Uniform sized Extents and move the table and Index into that tablespace. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, April 29, 2002 4:43 PM To: Multiple recipients of list ORACLE-L Hi, I have segments (Tables and indexes) which go into 500 MB -- 1 GB . I intend to do a rebuild since they are fragmented. Is it beneficial to have a single extent of 500 Mb or multiple extents are ok ? (maybe 4 --5) My contention is that so long as the extents are contiguous ( I could do a rebuild) the number do not matter so long as they are not too high. Any suggestions ? Thanks shreepad -- 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: Ganesh Raja 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: Storing formated data in oracle table
Hi, Oracle does not allow you to store Bold and Italics in the Table... What you can do is have a Field called format that will help you to identify what format the data has to be shown. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Saturday, April 27, 2002 12:23 PM To: Multiple recipients of list ORACLE-L hi all How to store formated data(bold,italic) in oracle table. bye Do You Yahoo!? Yahoo! Health - your guide to health and wellness -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: ioug-a question
Ron, Can u Also Mail me that Document if it feasible for u. Thanks. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Sunday, April 21, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Lisa, (Copy of response sent to your direct e-mail since list servers don't do well with large attachments). I will attach the white paper you are looking for. You should know that this is a quick overview of the content of Gaja's book. Here is my advise: 1) Join IOUG - There are tons of benefits including a huge repository of information. 2) If you find the paper on tuning with "Wait Events" interesting, you will love his book. "oracle 101 Performance Tuning" Oracle Press Gaja Vaidyanatha ISBN 0-07-213145-4 HTH, -Ron- > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, > Lisa > Sent: Sunday, April 21, 2002 6:43 AM > To: Multiple recipients of list ORACLE-L > Subject: ioug-a question > > > Hello all, > > Someone posted a link to a page describing what was going on at > ioug-a. This link spoke of a presentation (by Gaja?) that addressed > tuning without ever looking at a ratio. > > Are these papers available to the public or only to attendees? I > really really wanted to go to this meeting but there's no way I was > going to fly across the country 38 weeks pregnant. If anyone can > please post a link or tell me where, if anyplace, these papers are > available I would really appreciate it. It's OK if I have to join > ioug to do this - I'm sure my boss will pay for it - I'm just not sure > if that's what I'd have to do. > > Please include a reply to me directly, I don't know how much longer > I'll be subscribed. > > Thanks > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > Ft. Lauderdale, FL, USA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Koivu, Lisa > 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: Ron Yount 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: Ganesh Raja 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 link
Hi, Select * From Dba_DB_LINKS should give you the links. Drop [Public] Database Link Should Drop the Link. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Saturday, April 20, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Hi guys...can someone help me with database linkswhat is the query for seeign the databse links ..and how to drop them...I am facing lots of issues with themsorry if this query has been posted earlier...this is my first mail to the group... thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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 Base Link
Hi, What you can do is Select the table to be updated with a For Update. If The Select Fails then u can find out why it failed using Exception Handling. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Saturday, April 20, 2002 1:43 PM To: Multiple recipients of list ORACLE-L Hi , Kindly help me to solve folowing problem. I need to Update a Table in Another database using a Procedure thru Database Link. The problem is other database or may be Listner is not always running when User Runs the procedure. Can I Check whether the Database/Listner is running or Not ? TIA, Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog 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: Ganesh Raja 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: An Oracle logic error....
There is no Logical Error Here... It is perfectly Logical. The Char is Explicitly Converted into a Number if Oracle Finds that it has only Numbers and No Chars. happy Scouting for errors !!! Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Thursday, December 13, 2001 1:05 PM To: Multiple recipients of list ORACLE-L A sound not right program to ask you all. I have declare l_aayr_nm to NUMBER(4); l_aayr_nm := TO_CHAR(bsmstr_rec.ful_rls_dt,''); and I insert l_aayr_nm into a table with INSERT INTO penm (yr ) values (l_aayr_nm); the declaration of the yr is NUMBER(4) also. But oracle did't give me any error on this ??Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond 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: Ganesh Raja 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: Internal Password
Title: Internal Password Set ORACLE_SID Environment Variable to the instance u want to Connect to . HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 10:35 AMTo: Multiple recipients of list ORACLE-LSubject: Internal Password Hello Gurus I have a problem in that I was always able to login to svrmgrl on the consol and connect to internal, without having to give a password. Yesterday however we had a massive mulfunction of the UPS and all power was lost to the server room. Anyway the Win2k, compaq 8500R server recovered fine and so did the Oracle DB 817. BUT, now connecting internal demands a password, why? Also all known passwords do not work including the default one. Can anyone shed some light on what happened? and how can I fix it? TIA Denham Eva This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: After logon trigger
Hi Jared, I just now Tried it and it was working. But i have tried it in 8.1.6 and it has failed to execute for the users granted the DBA Role. Anyways when i checked at http://asktom.oracle.com/pls/ask/f?p=4950:8:329387::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:1844531724208,%7BAfter%7D%20and%20%7BLogon%7D This iw what he said. This is the correct behavior and is designed to make it so your database doesn't get into a state whereby NO ONE can log in (815 can get to that state). It is a feature. My suggestion, don't use the DBA role. Create your own ROLE (create many of them in fact) YOUR_DBA and use that instead. DBA is just a role (but a special one). If you don't use "DBA", you will be able to treat your DBA users as if they were any ordinary user. Your comments pls. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Thursday, December 13, 2001 1:56 AM To: Multiple recipients of list ORACLE-L I've done many tests and this is not right. It fires for users with DBA. The only thing I remember (may be I'm dreaming )when I first used it in 8.1.5 on NT is that the logon trigger did not run under the user who is logging on but under the pseudo process number 1. This is not the case any more. Regards Waleed -Original Message- Sent: Wednesday, December 12, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Ganesh, Are you sure about logon triggers not firing for users with the DBA role enabled? I've used them on 8.1.6 and 8.1.7, and they fire on my DBA account. Jared Ganesh Raja ulf.com> cc: Sent by: Subject: RE: After logon trigger [EMAIL PROTECTED] om 12/11/01 11:30 PM Please respond to ORACLE-L Create it Once not every time some one Logs in... The table is notsimilar to temporary tables in SQl... They are Different.. The Table is visible to all sessions if u say they are Global temporary Tables. Yes Logon triggers Fire Every time the User logon... But the second time onwards u will get a Error... The Logon triggers dont fire for Users with the DBA Role Enabled. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 11:00 AM To: Multiple recipients of list ORACLE-L Subject: After logon trigger Hi I am trying to use an after logon trigger to create a session temp table rather that create it at the time the procedure that uses it calls it. Two reasons for doing this is for performance ? the other is so that I can reference it in a cursor. 1) Do logon triggers not work if I logon with toad or similar tools 2) If 1 is wrong why when I have the following trigger in the database cant I see the table or use it after logging on TRIGGER create_temp_table AFTER LOGON ON DATABASE DECLARE v_CreateString VARCHAR2(100); BEGIN v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_stddev ( v_part NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS'; EXECUTE IMMEDIATE v_CreateString; END; TIA Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 --Facsimile: +61 (0)7 3303 3048 -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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 officia
RE: update database trigger
The Where Clause Gives the rows... create or replace trigger trg_on_T1 before update on T1 for each row begin if updating then update T2 set a=:new.a, b=:new.b, c=:new.c Where a=:old.a and b=:old.b and c=:old.c; end if; end trg_on_T1; HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Hi lists, DB:Oracle 8i I need to write a db trigger on table T1. It has to update T2 when ever T1 is updated. (Both T1 and T2 tables have identical structure.) The following query is doing wrong update. can anybody tell me what is wrong in this code: create or replace trigger trg_on_T1 before update on T1 for each row begin if updating then update T2 set a=:new.a, b=:new.b, c=:new.c; -- how to add the where clause..? end if; end trg_on_T1; I dont know how to use where clause in this. b'coz all columns can be updated by users. Can anybody give any hints. Thnx in advance 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Killed session - does it rollback?
Title: Killed session - does it rollback? Yes it does that ... The Rollback will happen and the Session will be terminated. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 12, 2001 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: Killed session - does it rollback? Hi Gurus Just wondering, as DBA if I kill a session on the server. Does the server rollback the transaction automatically? TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: After logon trigger
Create it Once not every time some one Logs in... The table is notsimilar to temporary tables in SQl... They are Different.. The Table is visible to all sessions if u say they are Global temporary Tables. Yes Logon triggers Fire Every time the User logon... But the second time onwards u will get a Error... The Logon triggers dont fire for Users with the DBA Role Enabled. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 12, 2001 11:00 AMTo: Multiple recipients of list ORACLE-LSubject: After logon triggerHi I am trying to use an after logon trigger to create a session temp table rather that create it at the time the procedure that uses it calls it. Two reasons for doing this is for performance ? the other is so that I can reference it in a cursor. 1) Do logon triggers not work if I logon with toad or similar tools 2) If 1 is wrong why when I have the following trigger in the database cant I see the table or use it after logging on TRIGGER create_temp_table AFTER LOGON ON DATABASE DECLARE v_CreateString VARCHAR2(100); BEGIN v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_stddev ( v_part NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS'; EXECUTE IMMEDIATE v_CreateString; END; TIAPeter McLarty E-mail: [EMAIL PROTECTED]Technical Consultant WWW: http://www.Mincom.comAPAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048-- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
RE: select data using trigger
The Select Trigger is not available as of 8.1.7 But i heard that from Oracle 9i they have introduced a Select Trigger. So maybe you can try in those docs. But I am not sure if u can make it fetch from the Cont2 Table. I prefer u write a ref Cursor to Achive that this will be siimpler and there will not be mmuch change in the application. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 7:50 AM To: Multiple recipients of list ORACLE-L Hi lists, Can anybody help me...? Table CONTRACTS is accessed by many applications and has many selects hit this table. This table has 15 indexes. Still It needs some more indexes. But we were instructed to stop creating indexes. We have another table CONT2 in another schema. This table is copy of CONTRACTS. Is there a way to write a trigger on CONT2 for the following issue: if a particular select / select statement issued against CONTRACTS table, that query should select data from CONT2. (There is only one particular select statement that is more resource intensive. We need to divert that query to CONT2. As the applications are already tuned, we were not permitted to modify that code.) Thnx in advance, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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/Export table
Use this. exp scott/tiger tables=(t1,t2,t3) Owner=scott Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Monday, December 10, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** 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 action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: Redo sql from archive log
Try Using the DBMS_LOGMNR Pkg . That is how u can get what is there in the redo Log files. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 5:40 AM To: Multiple recipients of list ORACLE-L HI lists, Can anybody tell me how to generate the sql s from archive log? what query do I user? Thnx in adv. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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: parallel import
Sorry no Parrellel Imports nly Parrlel Exports ... Thinking Logically this is no possible. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 08, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Hi lists, Is there a parallel import into table / schema . ? (The table/tables have primary keys as well as indexes ) (need to finish the import in less time, than traditional import ) Thnx in advance 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re:Problem with DYNAMIC SQL
Hi, Do u have the privleges granted directly to you ??? Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Thursday, December 06, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi, --- Nikunj Gupta <[EMAIL PROTECTED]> wrote: > Hi, > Assign CREATE TABLE statement to a variable and then > issue > > EXEC SQL EXECUTE IMMEDIATE > > This should work I have tried it before sending the mail, and I tried it after receiving your mail but I did not work and it had the same problem Thanx E. > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Wednesday, December 05, 2001 06:30 AM > > > > Ehsan, > > > > I don't think so. In the case you've listed > the better way would be > to do: > > > > EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4)); > > > > The use of EXECUTE IMMEDIATE is more suited to > statements that are > being > > dynamically created on the fly. This one is not. > > > > Dick Goulet > > Pro*C Evangelist > > > > Reply > Separator > > Author: ehsan sinavalda <[EMAIL PROTECTED]> > > Date: 12/5/2001 5:05 AM > > > > Hello > > > > As I found in proc docs the following statement > should > > work properly: > > > > EXEC SQL EXECUTE IMMEDIATE > > "CREATE TABLE dyn1 (col1 VARCHAR2(4))"; > > > > But when I want to compile a PROC prog. that has > the > > above stmt in a function I recevive the following > > compile error: > > > > sample1.cc: In function `void test()': > > sample1.cc:1313: break statement not within loop > or > > switch > > > > Could someone pls help me resolving this problem? > > > > Thanks > > > > E. > > > > > > __ > > Do You Yahoo!? > > Buy the perfect holiday gifts at Yahoo! Shopping. > > http://shopping.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: ehsan sinavalda > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Nikunj Gupta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ 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: ehsan sinavalda INE