Re: How to find oracle is 32/64 bit
Hi, Query the v$version view. From outside issue a file $ORACLE_HOME/bin/oracle, usually when it is a 64 bits release it doesn't appear the number 64. However in a 32 bits, it does: $ file oracle oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, n ot stripped Regards. --- Ajay Singh Rathore [EMAIL PROTECTED] wrote: Hi, I want to known whether my oracle database is 32/64bits. Can anybody help me how to find it ? Thanks, Ajay Singh Rathore HCL Infosystems Ltd --- visit us at www.hclinsystems.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ajay Singh Rathore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup Oracle on Sun Cluster 2.2 ???
Hi, If I shutdown my database, sun cluster will automatically startup it within a second. Regrads, Sinardy -Original Message- [EMAIL PROTECTED] Sent: Monday, 23 July 2001 2:05 PM To: Multiple recipients of list ORACLE-L I don't see any problem in stopping Oracle Database and keep the cluster running. Stop the database from svrmgr prompt on all nodes using just shutdown normal/immediate and don't execute anything related to cluster. This way u will have access to all shared storage (raw / filesystems) and your database is down for cold backup. Now, if u are using raw shared device, then the backup cab be taken through 'dd' and if u are using filesystems, then u can use anything u want. DESHMUKH SAMBHAJI S Let's Document it and Call it a Future ! Sinardy sinardyxing@To: Multiple recipients of list ORACLE-L bcsis.com [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: backup Oracle on Sun Cluster 2.2 ??? com 07/22/01 09:10 PM Please respond to ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Supert market desgn
Hi friends, I would like to know thename of site where i could find any document related to designing of database for a supermarket chain speard across the country. Please help me regarding the document. Thank's in advance. Regards Saravana.
Re: parameters at session level
When you run an alter session to change session parameter as optimizer_goal or sql_trace and then you issue a show parameters, it shows you the values at session level. Regards. --- prasad maganti [EMAIL PROTECTED] wrote: hi dba's can anybody clarify me the flwng: at database level the parameter optimizer_mode=choose. and i connected to scott and i set the optimizer_goal= rule. when i see from scott using sqlshow parameters optimizer the value is shown as RULE where as from connect internal SVRMGRSHOW PARAMETERS OPTIMIZER showing CHOOSE. But in the case of SQL_TRACE the system is showing the only value that is set at database level. even if i set sql_trace=false in scott user and i issued show parameters sql_trace it is showing only TRUE that is set at database level. why oracle behaves different ways for different parameters. prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Instance down
I know it maybe a little latebut: are you trying to put tablespace read only ?. Regards. --- Seema Singh [EMAIL PROTECTED] wrote: Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup Oracle on Sun Cluster 2.2 ???
This should be the case with DLM. Usually DLM goes down and comes up along with the cluster. To make this happen u have to execute following command scadmin clustername ?U filename i.e. clustername.ora_cdb Once u execute above command, they say DLM is registered with the cluster and the DLM goes down and comes up with the cluster automatically. But I don't know what happens when u stop DLM using some DLM command, whether cluster automatically senses it and brings it up within a second or so. I think something similar is configured for db_startup scripts on your cluster. I don't know how it is done for db_startup. Please check in /etc/opt/SUNWconf/conf/cluster_name.ora_cdb and /etc/opt/SUNWconf/conf/cluster_name.cdb U may find something related to this in these configuration files. Read the commented part also. DESHMUKH SAMBHAJI S Let's Document it and Call it a Future ! Sinardy sinardyxing@To: Multiple recipients of list ORACLE-L bcsis.com [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: backup Oracle on Sun Cluster 2.2 com ??? 07/23/01 03:00 AM Please respond to ORACLE-L Hi, If I shutdown my database, sun cluster will automatically startup it within a second. Regrads, Sinardy -Original Message- [EMAIL PROTECTED] Sent: Monday, 23 July 2001 2:05 PM To: Multiple recipients of list ORACLE-L I don't see any problem in stopping Oracle Database and keep the cluster running. Stop the database from svrmgr prompt on all nodes using just shutdown normal/immediate and don't execute anything related to cluster. This way u will have access to all shared storage (raw / filesystems) and your database is down for cold backup. Now, if u are using raw shared device, then the backup cab be taken through 'dd' and if u are using filesystems, then u can use anything u want. DESHMUKH SAMBHAJI S Let's Document it and Call it a Future ! Sinardy sinardyxing@To: Multiple recipients of list ORACLE-L bcsis.com [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: backup Oracle on Sun Cluster 2.2 ??? com 07/22/01 09:10 PM Please respond to ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: Extent allocation
Thanks to all for your help, appreciated. Ade -Original Message- Sent: 21 July 2001 18:01 To: [EMAIL PROTECTED] I mean just that--that Oracle will look in its free extent cache for the first free extent the tablespace that is the same size as that which it needs. There is no particular ordering first. And that would make it appear to be distributing extents equally among the files, but not always. Sometimes it will also look, as another lister has pointed out, as if Oracle is always going to the biggest datafile in the tablespace. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 21, 2001 11:45 AM What do you mean by the first one on the list? The list ordered how? The order in which dynamic extent allocation is reading fet$ appears to favor distributing extents equally among files. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 21 Jul 2001, Jon Walthour wrote: Kirti and others: Actually, Oracle only uses a round-robin extent allocation method for direct loads and parallel CTAS operations. For dynamic extent allocation, Oracle doesn't fill up one file and then the next. Actually, Oracle doesn't distinguish between datafiles, but rather looks at the total free space extents for the tablespace as listed in SYS.FET$ (Oracle's free extent cache). Basically, Oracle will look for a free extent equal to the size of the one it needs to allocate(see Doc ID #69343.1 on MetaLink of details on Oracle's extent algorithm). The first one on the list, regardless of the datafile, gets picked first. If one of exact size doesn't exist, Oracle will then split an existing larger extent. This larger extent, again, will be the first one found in SYS.FET$ which can provide the necessary space. So, it can at times appear to be round-robin allocation or one-file-at-a-time when, in point of fact, it is much more complex. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 6:30 PM Jeremiah is right. Depending on the version of the database this is an imaginary problem. I have been using this 'auto round robin' feature since 8.0.6 (HP-UX 32-bit). Just did quite a bit of re-organization involving partitioning a large table and used this auto round robin extent allocation feature to spread out I/O... Anyone seen this in any lower versions ?? Cheers! - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Extent allocation On Fri, 20 Jul 2001, Adrian Roe wrote: Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. It appears we may be discussing an imaginary problem. At least on the version I am using (8.1.6.2 HP-UX 64 bit), Oracle round robins among files with available space automatically. It does not just fill up one datafile and move on to the next. I did a little experiment: SQL create tablespace jeremiah_temp1 1 datafile '/tmp/jeremiah_temp-01.dbf' size 10m, 2 '/tmp/jeremiah_temp-02.dbf' size 10m, 3 '/tmp/jeremiah_temp-03.dbf' size 10m, 4 '/tmp/jeremiah_temp-04.dbf' size 10m; Tablespace created. SQL create table foobar 1 (baz varchar2(10)) 2 storage (initial 32k next 32k pctincrease 0 maxextents 4) 3 tablespace jeremiah_temp1; Table created. SQL insert into foobar (baz) 1 select substr(trash,1,10) from garbage where rownum = 6000; 6000 rows created. SQL commit; Commit complete. SQL select segment_name, e.bytes/1024 kb, file_name 1 from dba_extents e, dba_data_files d 2 where e.file_id = d.file_id 3 and e.segment_name = 'FOOBAR'; SEGMENT_NAME KB FILE_NAME -- -- -- FOOBAR 32 /tmp/jeremiah_temp-01.dbf FOOBAR 32 /tmp/jeremiah_temp-02.dbf FOOBAR 32 /tmp/jeremiah_temp-03.dbf FOOBAR 32 /tmp/jeremiah_temp-04.dbf So, it looks like it round robins automatically, and there is no need to do so manually. I don't know which version of Oracle was the first to do this. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton also
select on v$ tables
hi dba's i need to give select permission to scott user on all v$ tables. is there any role for that. or should i grant the selection using dynamic sql thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: parameters at session level
yes what you said was correct for OPTIMIZER PARAMETER. But in the case of sql_trace parameter it is behaving in different manner. trace at db level is false. so in v$param it is false. i logged into scott/tiger and set the sql_trace to true. the strange thing i found was when i issue show parameters sql_trace from scott it is showing sql_trace=false why? --- Christian Trassens [EMAIL PROTECTED] wrote: When you run an alter session to change session parameter as optimizer_goal or sql_trace and then you issue a show parameters, it shows you the values at session level. Regards. --- prasad maganti [EMAIL PROTECTED] wrote: hi dba's can anybody clarify me the flwng: at database level the parameter optimizer_mode=choose. and i connected to scott and i set the optimizer_goal= rule. when i see from scott using sqlshow parameters optimizer the value is shown as RULE where as from connect internal SVRMGRSHOW PARAMETERS OPTIMIZER showing CHOOSE. But in the case of SQL_TRACE the system is showing the only value that is set at database level. even if i set sql_trace=false in scott user and i issued show parameters sql_trace it is showing only TRUE that is set at database level. why oracle behaves different ways for different parameters. prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
init.ora
hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
full table scans
How can I find out what queries and/or tables are being used in full table scans? 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).
OUTPUT WIDTH..
hi all, how do i increase the width of output of a querry concatenated with some strings through '||'. the output is truncated in the end. output is ok in sql prompt with set line option. but whatabput svrmgrl.. any idea.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: full table scans
John Dunn wrote: How can I find out what queries and/or tables are being used in full table scans? John Select query text from V$SQLAREA (or, better, V$SQLTEXT since V$SQLAREA only contains the first 999 characters) and run EXPLAIN on it. Querying PLAN_TABLE afterwards will give you the info (do not forget to assign statement identifiers when running EXPLAIN). This is not too difficult to code in SQL or PL/SQL. This said, full table scans are not necessarily bad. Most reference tables are usually accessed faster through FTS, and sometimes big tables too. Only Big Bad Full Table Scans are to be feared; it really depends. You should concentrate on queries which do a high number of logical reads. There is a free script (peep.sql) on the Oriole site to find them. PLUGThere is also a product, ORISNOOP, to give you a fuller picture and generate a usually awesome HTML report/PLUG. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: init.ora
do a select select name from v$database; you will get a name , and your init file will be initthe_selected_name.ora hope this will help you regards Digs --- prasad maganti [EMAIL PROTECTED] wrote: hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? For regular News updates go to http://in.news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?D=20B?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: select on v$ tables
Hi, Just grant privilege 'select any table' to scott user OR grant DBA role to scott.\ Regards, Anand. -Original Message- maganti Sent: Monday, July 23, 2001 2:56 PM To: Multiple recipients of list ORACLE-L hi dba's i need to give select permission to scott user on all v$ tables. is there any role for that. or should i grant the selection using dynamic sql thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: init.ora
Title: RE: init.ora Hi Prasad, When your issue STARTUP command in svrmgrl or sqlplus, Oracle will check the file called initSID.ora in the $ORACLE_HOME/dbs directory. You could specify a initSID.ora file with this command : STARTUP PFILE=/PATH/initSID.ora Luc -Message d'origine- De: prasad maganti [mailto:[EMAIL PROTECTED]] Date: Monday, July 23, 2001 11:21 AM À: Multiple recipients of list ORACLE-L Objet: init.ora hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: select on v$ tables
Prasad: Grant the user the SELECT_CATALOG_ROLE role. That will give the user access to the v$ views, the DBA_ views and several other views and tables. To see a full listing of what they would be granted select on, run: select table_name from dba_tab_privs where grantee='SELECT_CATALOG_ROLE' order by table_name; Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:25 AM hi dba's i need to give select permission to scott user on all v$ tables. is there any role for that. or should i grant the selection using dynamic sql thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OUTPUT WIDTH..
SVRMGRL is more primitive than SQL*Plus and doesn't have all the formatting capabilities that SQL*Plus does. So, there are no SET commands in SVRMGRL. Why can't you do the query in SQL*Plus just as well? Jon Walthour - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Monday, July 23, 2001 6:00 AM Subject: OUTPUT WIDTH.. hi all, how do i increase the width of output of a querry concatenated with some strings through '||'. the output is truncated in the end. output is ok in sql prompt with set line option. but whatabput svrmgrl.. any idea.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: init.ora
Prasad: There is no way to tell from inside Oracle exactly what init.ora you used to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between the two init.ora files and querying sys.v_$parameter to check those differences. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:20 AM hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 yesterdays date
Anyone know how to get yesterdays date in PL/SQL? 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).
RE: oracle dba and tuning books
thanks all for giving lists of books.. thanks and regards ! Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -Original Message- Behalf Of Steve Sapovits Sent: Sunday, July 22, 2001 10:55 AM To: Multiple recipients of list ORACLE-L For SQL and PL/SQL, I've been reading Guy Harrison's Oracle SQL High-Performance Tuning (second edition). Pretty good so far. I also got O'Reilly's Oracle Performance Tuning (also second edition) but haven't read enough of it yet to really rate it. I generally like the O'Reilly books though. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 10:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: oracle dba and tuning books Jon, don't be sorry -- just go read it. Tuning: Oracle 8i Performance Tuning 101 by Gaja Krishna Vaidyanatha and Kirti Deshpande. Both of this list. DBA: Oracle 8i DBA Handbook by Kevin Loney and Marlene Theriault. BUT ... what level are you looking for? Beginner? Advanced? Intermediate? This will help determine what books we recommend. Rachel From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: oracle dba and tuning books Date: Sat, 21 Jul 2001 09:05:56 -0800 Personally, for tuning, I would suggest Oracle Performance Tuning Tips and Techniques by Richard Niemac, et. al. In the DBA arena, I've never really found a good book that I could wholeheartedly recommend (sorry, Rachael, I've not gotten around to reading your book yet). Jon Walthour - Original Message - From: shirish To: Multiple recipients of list ORACLE-L Sent: Saturday, July 21, 2001 9:40 AM Subject: oracle dba and tuning books hi all can u plz give me good books for dba and tuning thanks in advance thanks and regards ! Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 visit me at:- www.geocities.com/shirishkhapre Minds are like parachutes. They only function when they are open __ ___ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shirish INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: parameters at session level
It's the expected behaviour. And I'm sorry it was my mistake. Oracle doesn't consider sql_trace as dynamic even the fact you can change it and it works. You can confirm this yourself in the 8.1.7 documentation of the parameter. Regards. --- prasad maganti [EMAIL PROTECTED] wrote: yes what you said was correct for OPTIMIZER PARAMETER. But in the case of sql_trace parameter it is behaving in different manner. trace at db level is false. so in v$param it is false. i logged into scott/tiger and set the sql_trace to true. the strange thing i found was when i issue show parameters sql_trace from scott it is showing sql_trace=false why? --- Christian Trassens [EMAIL PROTECTED] wrote: When you run an alter session to change session parameter as optimizer_goal or sql_trace and then you issue a show parameters, it shows you the values at session level. Regards. --- prasad maganti [EMAIL PROTECTED] wrote: hi dba's can anybody clarify me the flwng: at database level the parameter optimizer_mode=choose. and i connected to scott and i set the optimizer_goal= rule. when i see from scott using sqlshow parameters optimizer the value is shown as RULE where as from connect internal SVRMGRSHOW PARAMETERS OPTIMIZER showing CHOOSE. But in the case of SQL_TRACE the system is showing the only value that is set at database level. even if i set sql_trace=false in scott user and i issued show parameters sql_trace it is showing only TRUE that is set at database level. why oracle behaves different ways for different parameters. prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Re: Jobs
Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum Slater Managing Director CMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ msword1.rtf
Re: get yesterdays date
I'll save you the trouble John; it was Sunday June 22nd. Sossy, couldn't resist. Alternatively you can select SYSDATE -1 from DUAL. Cheers, Mike Hately |+--- || John Dunn| || john.dunn@se| || fas.co.uk | || | || 07/23/01 | || 12:35 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: get yesterdays date | | Anyone know how to get yesterdays date in PL/SQL? 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
public roles urgent
Hi everyone I have the following situation : oracle 7.3.4. on windows NT 4.0 sp5 I have a public role with several grants in it. Then i revoked the role from public today , after that i granted the role to public. Several users are complaining about the follwing : ORA-00942: table or view does not exist The user still has the public role (via user_role_privs) but doesn't see the granted tables. When i drop and create the user everything is ok. Does anyone has a clue why this happens and how i can eliminate this without dropping the users. tia g.g. kor rdw ict the netherlands -- 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).
Re: get yesterdays date
select trunc(sysdate) - 1 from dual; John Dunn wrote: Anyone know how to get yesterdays date in PL/SQL? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: get yesterdays date
select sysdate-1 from dual; [EMAIL PROTECTED] 07/23/01 07:35AM Anyone know how to get yesterdays date in PL/SQL? 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). This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jobs
Listers: Is it appropriate to be sending one's resume to the mailing list (especially as an attachment)? I don't think so, but have not heard much to that effect thus far. So, maybe it is. Can someone please enlighten me? Jon Walthour --- Original Message --- From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 8:30:27 AM Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum Slater Managing Director CMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: get yesterdays date
Title: AW: get yesterdays date Hi John, try select trunc(sysdate) - 1 from dual Regards, Michael -Ursprüngliche Nachricht- Von: John Dunn [mailto:[EMAIL PROTECTED]] Gesendet am: Montag, 23. Juli 2001 13:36 An: Multiple recipients of list ORACLE-L Betreff: get yesterdays date Anyone know how to get yesterdays date in PL/SQL? 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).
RE: get yesterdays date
select sysdate-1 from dual; -Original Message- Sent: Monday, July 23, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Anyone know how to get yesterdays date in PL/SQL? 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: Shahid Malik(IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anyone know what refresh controlfile command is?
Ethan, There's not much on this event. It occurs when an operation that needs to update the controlfile has to wait while the controlfile is being resized (e.g. if new entries are being added). Seems most likley to occur in an OPS env where different instances could be updating the same controlfile. All of my test db's (non-OPS) have 1 wait on this event, so it occurs even on non-OPS db's. HTH, -- Anita --- Post, Ethan [EMAIL PROTECTED] wrote: Metalink is unusable at the moment and google gets me nada...it's one of the V$SYSTEM_EVENTS...what is it, what causes it, how often should it occur? refresh controlfile command - Thanks, - Ethan Post - http://www.geocities.com/epost1 -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get yesterdays date
I am not sure of exact syntax but just select sysdate -1 into variable from dual; Rick -Original Message- Sent: Monday, July 23, 2001 7:36 AM To: Multiple recipients of list ORACLE-L Anyone know how to get yesterdays date in PL/SQL? 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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: init.ora
This won't tell you of aditional config files (referenced using ifile= in you init file) but it will tell you the primary file. select * from v$parameter where name = 'ifile'; Rodd Holman Original Message On 7/23/01, 6:35:50 AM, Jon Walthour [EMAIL PROTECTED] wrote regarding Re: init.ora: Prasad: There is no way to tell from inside Oracle exactly what init.ora you used to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between the two init.ora files and querying sys.v_$parameter to check those differences. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:20 AM hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Exp/Imp - suppress screen output?
wow is that precision performance or what? :) -Original Message- Darren Sent: Friday, July 20, 2001 08:16 To: Multiple recipients of list ORACLE-L Or 21 /dev/null (One less character to type) -Original Message- Sent: July 20, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Jobs
i definitely agree with u. i feel if the information is recieved through the list. at least one should try to communicate individually. as the mails provides the sender's id clearly. it should'nt be to include all for your individual work. and with an attachment.. god save all!!! it's a common effort of the have's for the have not's. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 7:10 PM Listers: Is it appropriate to be sending one's resume to the mailing list (especially as an attachment)? I don't think so, but have not heard much to that effect thus far. So, maybe it is. Can someone please enlighten me? Jon Walthour --- Original Message --- From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 8:30:27 AM Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum Slater Managing Director CMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
The number of used cursors?
Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get yesterdays date
John: To get yesterday's, simply subtract 1 from sysdate ... like this: select sysdate-1 as yesterday from dual; Jon Walthour --- Original Message --- From: John Dunn [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 7:35:53 AM Anyone know how to get yesterdays date in PL/SQL? 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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get yesterdays date
select sysdate - 1 from dual; Gints Plivna John Dunn john.dunn@seTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fas.co.uk cc: Sent by: Subject: get yesterdays date root@fatcity. com 2001.07.23 13:35 Please respond to ORACLE-L Anyone know how to get yesterdays date in PL/SQL? 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off Topic: For Sale Sparc 5 170MHz capable of running 9i
Christopher, What would the total cost be for an upgrade to 256Mb RAM, and a 10 gig disk? Same for 512Mb RAM. Then of course there would be the cost of shipping it to the UK.. We are looking for a low range test box at the moment.. Cheers Mark -Original Message- Spence Sent: Sunday, July 22, 2001 02:35 To: Multiple recipients of list ORACLE-L If anyone is interested in a cheap machine to start playing with 9i with. I just got a lot of 100 Sparc 5's. Standard configuration is: HyperSparc 170MHz 64Mb Ram Internal CDROM and Floppy Turbo GX Video (13W Connector) 2Gb SCSI Hard Drive I am putting them on ebay at $225 each. Which is less than they normally go for, but I just want to get rid of this shipment so I can get this lot of Blade 1000's. To run Oracle 9i, I would recommend increasing the ram and disk. Which we have both. Sorry about the off topic, I know a few people mentioned they were looking for some machines. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup Oracle on Sun Cluster 2.2 ???
Don't know if this will work with Sun but with HP we would stop the database and the cluster (single script), then mount the filesystem locally. Hope it helps. Sinardy sinardyxing@To: Multiple recipients of list ORACLE-L bcsis.com [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: backup Oracle on Sun Cluster 2.2 com ??? 07/23/2001 01:45 AM Please respond to ORACLE-L Hi Don Granaman, If I shutdown Oracle, My cluster daemon will startup it back automatically. Regards, sinardy -Original Message- Granaman Sent: Monday, 23 July 2001 1:00 PM To: Multiple recipients of list ORACLE-L For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 8:10 PM Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Metablink .... down again?
Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get yesterdays date
SELECT SYSDATE - 1 from DUAL; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 2:35 PM Anyone know how to get yesterdays date in PL/SQL? 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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Jobs
IMHO: If recruiters can post jobs, each of us can post our need for a job. However, sending a resume is unnecessary. If someone is interestered, they can contact the poster privately and request a resume. Jenny Jacobson www.oracle-dba-consulting.com On Mon, 23 Jul 2001, Jon Walthour wrote: Listers: Is it appropriate to be sending one's resume to the mailing list (especially as an attachment)? I don't think so, but have not heard much to that effect thus far. So, maybe it is. Can someone please enlighten me? Jon Walthour --- Original Message --- From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 8:30:27 AM Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum Slater Managing Director CMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenny Jacobson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
tnsnames.ora in clients
Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener Security !!
Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl utility (or Database installation) at one Box, then you can stop the listener on another Box. Just change the parameter file (listener.ora) to have hostname of another (may be production server) box. Now goto lsnrctl and fire stop command. you would notice that the local listener is running but the remote listener is down... This is more serious issue on platforms like Unix and VMS where you can control listener (locally) only if you are a member of DBA group. This means that Listener doesn't have any cross OS check in it Is this a known issue/bug. Any-ideas, any patches? Oracle Corp guys, what you say? Waiting for you views.. Rajesh OC DBA 88i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Temp problem
Hi friends I had following error in my alert log file, Any ideas why its happening?? Mine is AIX ,oracle7. Mon Jul 23 08:53:43 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_96526.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 download website
WGET.There is a windows version as well as unix. -Original Message- Sent: Monday, July 23, 2001 9:46 AM To: Multiple recipients of list ORACLE-L hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to record history / procedure execution
Friends : I would like to record some history as : procedure name , start date, finish date and other things ... in a normal table. but, i wouldn´t to call the procedure doing it at the begin and at the finish of the procedure that i want to record the history ... Are there others ways to do it ? Like : a trigger of schema in execution of procedure.. Regards Eriovaldo [EMAIL PROTECTED] Brazil _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CASE Expressions
I'm doing some research for a book, and I need to know when Oracle began to support CASE expressions. I thought it was in Oracle9i, but the new features list seems to imply that CASE may have come about in 8.1.7. Can anyone with 8.1.7 verify this for me? I have 8.1.6 and 9.whatever, but not 8.1.7 or I'd try it myself. If you have 8.1.7, and have a second to experiment, try the following query as a test: SELECT CASE 1 WHEN 1 THEN 2 FROM dual; Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: The number of used cursors?
Use the view v$open_cursor. --- Szecsy Tamas [EMAIL PROTECTED] a écrit : Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off topic: Linux - NT dual boot
When u install linux u should install Lilo on MBR ie, Master Boot. Then Complete Linux installation. After first boot edit lilo.conf file from etc folder using vi editor. If u r installing Linux on same hard drive on diff partion on first partion u have NT then add following lines other /dev/had1 label = Winnt close the file saving changes run lilo -v command. when reboot u will get choice to select operating system. it should work. Good luck -- From: Sadzakovic Slavica[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Saturday, July 21, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Subject: Off topic: Linux - NT dual boot Hello listers Would someone explain (or point me to the web page) how to make Linux - NT dual boot system. When having Windows 9x/ME it is not problem at all. But, when installed Linux after NT installation, I simply lost NT installation. LILO offered linux boot only. Thank you in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sadzakovic Slavica INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inamdar, Deepa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get yesterdays date
Title: RE: get yesterdays date select sysdate - 1 from dual; -Original Message- From: John Dunn [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Subject: get yesterdays date Anyone know how to get yesterdays date in PL/SQL? 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).
Newbie kinda question
Hi Everybody, I'm currently studying for some Oracle Certification from a private organization, which will then put me through the Oracle DBA exams. I'm currently working on the PL/SQL programming modules. All the information I have consistently refers to Procedure Builder for programming with PL/SQL. However, I cannot seem to find where I can get a copy of Procedure Builder. I have gotten a copy of TOAD, however I'm not entirely happy with it. Statements which are allowed to run in SQL*Plus are not being run under TOAD for some reason. So, in summary, where can I get a copy of Procedure Builder ? Thanks, Michael.
RE: sql help
select distinct segment_type, owner, segment_name, tablespace_name from dba_segments This will get them all in one simple query. -Original Message- Sent: Saturday, July 21, 2001 10:45 AM To: Multiple recipients of list ORACLE-L hi dba's how to find out a users all objects+the tablespaces in which they reside. i tried using the flwng way: select tablespacename,table_name from dba_tables where obj in (select obj_nm from dba_objects where obj_type ='table' and owner='xyz') union select for indexes union select for clusters ; can anybody tell me any alternative statement for the above. thnx in adv. srinivas __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Re: Jobs
Jenny, et. al. I'm right there with you on this. I don't have a problem with someone announcing, Hey, I'm looking for a job. Anybody know of positions in blah-blah? What I don't care for the resume attachments and would just ask if it could be discontinued in the future. Jon Walthour --- Original Message --- From: Jenny Jacobson [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 10:30:52 AM IMHO: If recruiters can post jobs, each of us can post our need for a job. However, sending a resume is unnecessary. If someone is interestered, they can contact the poster privately and request a resume. Jenny Jacobson www.oracle-dba-consulting.com On Mon, 23 Jul 2001, Jon Walthour wrote: Listers: Is it appropriate to be sending one's resume to the mailing list (especially as an attachment)? I don't think so, but have not heard much to that effect thus far. So, maybe it is. Can someone please enlighten me? Jon Walthour --- Original Message --- From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 8:30:27 AM Hello, I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. Expecting to hear from you Regards Venkata Subramanian C.S. -- On Mon, 16 Jul 2001 11:30:50 Culum Slater wrote: Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum Slater Managing Director CMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenny Jacobson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to download website
hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 download website
WebReaper isn't bad. NetVampire is OK too. Some site will detect this kind of activity and will kill your connection. Regards, Mike Hately |+--- || prasad | || maganti | || prasadm_g@ya| || hoo.com | || | || 07/23/01 | || 03:46 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: How to download website | | hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: How to download website
Title: RE: How to download website Hi Prasad, There are a number of tools to do this. The only one I can remember at the moment is WebWhacker. see http://www.bluesquirrel.com/products/whacker/whacker32.html It costs fifty dollars -Original Message- From: prasad maganti [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 15:46 To: Multiple recipients of list ORACLE-L Subject: How to download website hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). All internet traffic to this site is automatically scanned for viruses and vandals.
Re: export/import object types
Thanks for the info. I looked at it, it's very informative. [EMAIL PROTECTED] 07/22/01 12:17PM Richard, This is an issue with TYPE objects as the TOID (type object ID) is exported (see the Utilities manual). Also see Note: 1066139.6 IMP-17 IMP-3 ORA-2304 IMP-63 FROMUSER/TOUSER Import of Table With Object Column HTH, -- Anita --- Richard Ji [EMAIL PROTECTED] wrote: Hi all, I wonder if anyone has seen this before. I export an user A, then import it into user B in a different database and everything is ok. Then I use the same export file to import into user C in the same database as user B and all the CREATE TYPE failed because Oracle retains the object id in the export file and when importing into user C it tries to create them with the same object id and since user B already has it it failed. I had to manually delete the object id from the log and recreate it. It's not a huge problem since it's rare that I do something like this. But just wondering why would Oracle retain the object id for TYPE? It certainly didn't keep the same object id for other objects like table, etc. Any thoughts? Richard Ji __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Metablink .... down again?
I wouldn't doubt it, metalink goes down more than Clinton's pants. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 23, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Metablink .... down again?
Its not you, Metablink is crawling on its knees again. ...JIM... [EMAIL PROTECTED] 7/23/01 9:20:32 AM Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 download website
Title: RE: How to download website I use shareware called Webstripper from www.solentsoftware.com. It is excellent 1.5Mb exe to install under Windows98 (for me anyway, I assume it also works for NT) and point it at a site and it strips the lot. I just pull text down never the images and it is pretty quick. Stores it all locally on the PC and the whole site can be viewed via the software and individual files only using Explorer. John -Original Message- From: prasad maganti [mailto:[EMAIL PROTECTED]] Sent: 23 July 01 15:46 To: Multiple recipients of list ORACLE-L Subject: How to download website hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Newbie kinda question
It is part of the Developper suite. However, I don't think it is the best tool for developping oracle stored objects. I know a lot of developpers around here are using PL/SQL developer (http://www.allroundautomations.nl/plsqldev.html). Djordje -Original Message-From: Michael [mailto:[EMAIL PROTECTED]]Sent: Monday, July 23, 2001 10:56 AMTo: Multiple recipients of list ORACLE-LSubject: Newbie kinda question Hi Everybody, I'm currently studying for some Oracle Certification from a private organization, which will then put me through the Oracle DBA exams. I'm currently working on the PL/SQL programming modules. All the information I have consistently refers to Procedure Builder for programming with PL/SQL. However, I cannot seem to find where I can get a copy of Procedure Builder. I have gotten a copy of TOAD, however I'm not entirely happy with it. Statements which are allowed to run in SQL*Plus are not being run under TOAD for some reason. So, in summary, where can I get a copy of Procedure Builder ? Thanks, Michael.
Re: Listener Security !!
Set a password for listener administration to prevent this. PASSWORDS_LISTENER=(mysecretpassword) Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/23/01 10:11AM Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl utility (or Database installation) at one Box, then you can stop the listener on another Box. Just change the parameter file (listener.ora) to have hostname of another (may be production server) box. Now goto lsnrctl and fire stop command. you would notice that the local listener is running but the remote listener is down... This is more serious issue on platforms like Unix and VMS where you can control listener (locally) only if you are a member of DBA group. This means that Listener doesn't have any cross OS check in it Is this a known issue/bug. Any-ideas, any patches? Oracle Corp guys, what you say? Waiting for you views.. Rajesh OC DBA 88i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Metablink .... down again?
So slow I can't even get in... Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -Original Message- Sent: Monday, July 23, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Speaks, Chuck W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Transparent Gateway for Sybase
Greetings, Apparently with the OTG for Sybase, we need to install either the Sybase Client or Server on our HP box. However, on the Sybase website, I can only get an evaluation copy of the Server for NT and Linux. Has anyone else who has installed OTG for Sybase run into this problem. Where did you get the Sybase software? We are currently studying the OTG option so we don't want to pay for anything yet. Any ideas? Thanks, Tom Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN
Well looks like i've held off learning RMAN long enough, any pointers, good RTFM, etc. thanks, joe
Re: Wildly OT. - Air fares
One source for the information is http://travel.yahoo.com/. A quick check shows it will probably be in the $200 - 250 range, depending on how far in advance you book your reservation, day of week, etc. Dennis Robertson Lee - lerobe wrote: Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Newbie kinda question
Purchase the D2K package from Oracle. However Procedure Builder is being phased out by Oracle. [EMAIL PROTECTED] 07/23/01 10:55AM Hi Everybody, I'm currently studying for some Oracle Certification from a private organization, which will then put me through the Oracle DBA exams. I'm currently working on the PL/SQL programming modules. All the information I have consistently refers to Procedure Builder for programming with PL/SQL. However, I cannot seem to find where I can get a copy of Procedure Builder. I have gotten a copy of TOAD, however I'm not entirely happy with it. Statements which are allowed to run in SQL*Plus are not being run under TOAD for some reason. So, in summary, where can I get a copy of Procedure Builder ? Thanks, Michael. This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Metablink .... down again?
Me too, can't get anything on metalink right now. [EMAIL PROTECTED] 07/23/01 10:20AM Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Metablink .... down again?
it's working again Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : James Howerton [mailto:[EMAIL PROTECTED]] Envoyé : lundi 23 juillet 2001 14:56 À : Multiple recipients of list ORACLE-L Objet : Re: Metablink down again? Its not you, Metablink is crawling on its knees again. ...JIM... [EMAIL PROTECTED] 7/23/01 9:20:32 AM Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INF/MEKKAOUI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Instance down
no From: Christian Trassens [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Instance down Date: Mon, 23 Jul 2001 00:15:25 -0800 I know it maybe a little latebut: are you trying to put tablespace read only ?. Regards. --- Seema Singh [EMAIL PROTECTED] wrote: Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: The number of used cursors?
Try this: select sum(value) as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic# and n.name = 'opened cursors current'; Jon Walthour --- Original Message --- From: Szecsy Tamas [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:55:24 AM Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get yesterdays date
try SELECT (sysdate - 1) FROM DUAL; MARK -Original Message- Karadeniz Sent: Monday, July 23, 2001 7:27 AM To: Multiple recipients of list ORACLE-L SELECT SYSDATE - 1 from DUAL; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 2:35 PM Anyone know how to get yesterdays date in PL/SQL? 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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wildly OT. - Air fares
Lee, You're gonna hate this answer: it depends. Dates? times of day? are you flexible on airport? on travel dates and times? the sites I use to check prices are: www.orbitz.com www.travelocity.com www.expedia.com www.trip.com this will give you some idea. On orbitz, for travel July 30 from NY and Aug 6th back, from LaGuardia to Seattle, I found this: all are one stopover/plane change, price ranging from $398 to $2297 Now if you fly into NY and don't plan on spending any time here (even if it's only a couple of hours in the airport) you do know that I will have to hunt you down and hurt you, don't you? :) When are you visiting? Rachel From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Wildly OT. - Air fares Date: Mon, 23 Jul 2001 06:26:55 -0800 Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off topic: Linux - NT dual boot
Try VMware... http://www.vmware.com/ You can download it for trial use. It costs money but it's really good. I bounce back and forth between Win2K and Linux on the laptop all day long and I'm suffering OS schizophrenia because of it. (I have to use Win2K for Outlook, productivity tools and company network stuff.) Steve Orr -Original Message- Sent: Monday, July 23, 2001 8:56 AM To: Multiple recipients of list ORACLE-L When u install linux u should install Lilo on MBR ie, Master Boot. Then Complete Linux installation. After first boot edit lilo.conf file from etc folder using vi editor. If u r installing Linux on same hard drive on diff partion on first partion u have NT then add following lines other /dev/had1 label = Winnt close the file saving changes run lilo -v command. when reboot u will get choice to select operating system. it should work. Good luck -- From: Sadzakovic Slavica[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Saturday, July 21, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Subject: Off topic: Linux - NT dual boot Hello listers Would someone explain (or point me to the web page) how to make Linux - NT dual boot system. When having Windows 9x/ME it is not problem at all. But, when installed Linux after NT installation, I simply lost NT installation. LILO offered linux boot only. Thank you in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sadzakovic Slavica INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inamdar, Deepa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: setting DbName in SQL*PLUS
Try this link: http://www.iherve.com/oracle/prompt_sqlplus.htm Script and explaination included. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 1:27 PM Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS thru glogin.sql? Shailesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrew Lieu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Locally managed tablespaces
Is there really any considerable overhead involved in dynamically allocating an extent? By creating free space chunks in a tablespace of uniform extent size, will you really reduce the amount of time and resources spent when a segment allocates those extents? I doubt it, but statistics from v$sesstat could convince me otherwise. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sun, 22 Jul 2001, Don Granaman wrote: If you are using uniform extents in LMT, you don't want to coalesce - ever. Since every extent will be the same size, it is useless overhead. This is even more true if you have adopted a uniform extents policy in any dictionary managed tablespaces. In fact, to reduce the overhead of throwing a new extent in the latter, you might try pre-fragmenting the tablespace by creating a junk table in it and manually allocating new extents, then dropping the table - during a low activity period of course. -- 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).
Re: Wildly OT. - Air fares
Check on www.hotwire.com - you may get a good rate if they handle Canada. Scott Shafer San Antonio, TX Robertson Lee - lerobe wrote: Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: The number of used cursors?
open_cursors is not a sum for the total number of users, but rather the maximum number of cursors an individual user can have open at any one time v$open_cursor SQL desc v$open_cursor NameNull?Type --- SADDRRAW(4) SID NUMBER USER_NAMEVARCHAR2(30) ADDRESS RAW(4) HASH_VALUE NUMBER SQL_TEXT VARCHAR2(60) From: Szecsy Tamas [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: The number of used cursors? Date: Mon, 23 Jul 2001 05:55:24 -0800 Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: init.ora
Rood: Not exactly correct. The ifile parameter will tell you all the files included in the init.ora via this method. However, it will not necessarily give you the location of the init.ora itself. Now, on a Windows NT system, this is how Oracle is able to keep the init.ora in the %ORACLE_ADMIN%\%ORACLE_SID%\pfile directory and still have a link to it in the %ORACLE_HOME%\dbs directory. However, on UNIX, where symlinks are used, there may be no ifile parameter in the init.ora and certainly probably not one pointing to the init.ora itself. Therefore, at best, this parameter is unreliable for finding the init.ora. Jon Walthour --- Original Message --- From: Rodd Holman [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:20:54 AM This won't tell you of aditional config files (referenced using ifile= in you init file) but it will tell you the primary file. select * from v$parameter where name = 'ifile'; Rodd Holman Original Message on 7/23/01, 6:35:50 am, jon walthour [EMAIL PROTECTED] wrote regarding Re: init.ora: Prasad: There is no way to tell from inside Oracle exactly what init.ora you u sed to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between t he two init.ora files and querying sys.v_$parameter to check those difference s. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:20 AM hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messe nger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lis ts To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: setting DbName in SQL*PLUS
Copy all three files into some directory (eg. c:\yourname\*.sql) Modify your registry for SQLPATH to c:\yourname(your first entry in SQLPATH) THen if you try to login to SQLPLUS, the prompt willbe always your global name. you might need to modify the login.sql file according to the path you have copied all the attached sql files. Baskar -Original Message- Sent: 23 July 2001 17:26 To: Multiple recipients of list ORACLE-L Try this link: http://www.iherve.com/oracle/prompt_sqlplus.htm Script and explaination included. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 1:27 PM Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS thru glogin.sql? Shailesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrew Lieu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). conn.sql login.sql LOGTEST.SQL
Re: CASE Expressions
It's available on 816 * --- Jonathan Gennick [EMAIL PROTECTED] a écrit : I'm doing some research for a book, and I need to know when Oracle began to support CASE expressions. I thought it was in Oracle9i, but the new features list seems to imply that CASE may have come about in 8.1.7. Can anyone with 8.1.7 verify this for me? I have 8.1.6 and 9.whatever, but not 8.1.7 or I'd try it myself. If you have 8.1.7, and have a second to experiment, try the following query as a test: SELECT CASE 1 WHEN 1 THEN 2 FROM dual; Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 download website
Title: RE: How to download website http://www.tenmax.com/has a good spider called "teleport pro". Not sure on costs tho. Alternatively, if you're a *nix kinda guy, you can use snarf. http://freshmeat.net/projects/snarf/and that ones free cheers, michael. - Original Message - From: Gillies, Garry [EMAIL PROTECTED] To: X Sent: Tuesday, July 24, 2001 1:46 AM Subject: RE: How to download website Hi Prasad, There are a number of tools to do this. The only one I can remember at the moment is WebWhacker. see http://www.bluesquirrel.com/products/whacker/whacker32.html It costs fifty dollars -Original Message- From: prasad maganti [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 15:46 To: Multiple recipients of list ORACLE-L Subject: How to download website hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). All internet traffic to this site is automatically scanned for viruses and vandals.
weird recursive sql
I'm expereinceing a weird problem. I have a tabl whihcis basically a collection of counters (NAME VARCHAR2, COUNTER NUMBER). For various reasons that are unimportant in this context the tables work by atempting an insert on (NAME, 1) and if that fails they do an update COUNTER = COUNTER +!; This has been running fine for 3 years. Suddenly in the past 3 weeks I have been seeing performance problems and the sudden appearance of some (apprently) constraint checking recursive sql whihc is in direct proportionto the inserts. This recursive sql was never in the sqlarea previously. The lines look like: select executions, sqltext from v$sqlarea; 166092573INSERT INTO HITCOUNTER ( ALIAS,USEHITCOUNTER,HITS ) VALUES ( :b1,1,0 )165799528select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# Further if I do: desc v$session;select sql_text from v$sqlarea sq, v$session sewhere prev_sql_addr = 'AA46049C' and prev_hash_value = '1318728909'and sql_address = sq.address and sql_hash_value = sq.hash_value; (that sql_address and hsah_value are for the insert statement above) I frequently (though not exclusively the recursive sql) I am always returned either no rows or that recursive sql statement (and these are not the most executed statements in the db either (they are 10th and 11th respectively, and any session is equally likely to run any of the the top 20 executed queries, in any pairings), so I would expect to see others if this was just a coincidence. I've searched Metalink and Google for this sql with basically no luck, and I have an open Tar which is getting no response. has anyone seen anything similair? Any clues, thoughts, etc? --George Schlossnagle1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
RE: Wildly OT. - Air fares
One way, around about mid september 2002 (Grizzly Bear watching at Knights Inlet BC). Regards Lee -Original Message- Sent: 23 July 2001 16:07 To: Multiple recipients of list ORACLE-L One way or round trip. What date? The longer period between the purchase of the ticket and when you are going will usually mean a cheaper flight. [EMAIL PROTECTED] 07/23/01 10:26AM Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CASE Expressions
Title: RE: CASE Expressions Jonathan CASE is not supported in 8.1.7. SQL select * from v$version; BANNER Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production SQL SELECT CASE 1 WHEN 1 THEN 2 2 FROM dual; SELECT CASE 1 WHEN 1 THEN 2 * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL Yuval -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 11:03 AM To: Multiple recipients of list ORACLE-L Subject: CASE Expressions I'm doing some research for a book, and I need to know when Oracle began to support CASE expressions. I thought it was in Oracle9i, but the new features list seems to imply that CASE may have come about in 8.1.7. Can anyone with 8.1.7 verify this for me? I have 8.1.6 and 9.whatever, but not 8.1.7 or I'd try it myself. If you have 8.1.7, and have a second to experiment, try the following query as a test: SELECT CASE 1 WHEN 1 THEN 2 FROM dual; Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: tnsnames.ora in clients
You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. [EMAIL PROTECTED] 07/23/01 10:55AM Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: tnsnames.ora in clients
One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. -Original Message- From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject: tnsnames.ora in clients Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wildly OT. - Air fares
It was around three hundred something last year when I flew to Vancouver. [EMAIL PROTECTED] 07/23/01 10:26AM Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Microsoft IIS
Someone, I don't remember who, posted a question a week of so ago about connecting to Oracle IAS via IIS instead of the provided Apache server because there damagement was afraid about being hacked. Well, pass the following along to damagement ask them again what they want to do: ** Internet Goes Red The Code Red worm ripped through Internet servers like no other previously unleashed piece of malicious code. We are witnessing Internet history, says Chris Rouland, director of Internet Security Systems X-Force, which tracks Internet vulnerabilities. Based on reports, Code Red has infected over 225,000 servers. The worm enters the targeted server through port 80. If the host is running Microsoft IIS, the worm executes a malformed HTTP get request to try to run a buffer overflow against the Microsoft IIS Indexing Service dynamic-link library. Once the worm successfully exploits the target, it starts searching for new servers to infect, and the compromised Web site is defaced. Code Red's ultimate target was Whithouse.gov. The worm was set to attack the White House Web site July 20 by unleashing a torrent of traffic at the site. According to Rouland, the White House managed to avoid the attack by switching the site's IP address. He says the author of Code Red made a critical design flaw by hard-coding the White House's IP address. That won't happen next time, he warns. When the ILoveYou virus struck last year, many copycats struck in the following weeks. I wouldn't be surprised to see many, many copy cats of this worm, he says. In fact, reports started surfacing Friday afternoon on security mailing list Bugtraq that several versions may already be loose. An explanation of, and patch for, the IIS buffer overflow vulnerability is available at http://update.informationweek.com/cgi-bin4/flo?y=eD2T0BdFGA0V20QKW0AK Has this one bit you? Tell other IT folks what you're doing to combat the problem in the Listening Post http://update.informationweek.com/cgi-bin4/flo?y=eD2T0BdFGA0V20Nmm0AD -- 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).
GA date for 9i database on Windows NT
Does anyone know when the NT version of 9i will be available ? Thanks, Jessie -- 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).
RE: Re: Jobs
Keep in mind that the last time this Venkata sent anything out to the list it was virus ridden.. Ma This might just be another virus attack. I , for one, am not even coming close to opening the attachment. It went straight into my delete folder via an outstanding Outlook rule. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup Oracle on Sun Cluster 2.2 ???
The whole point of clustering is that if your database crashes it is to automatically fail over to the other side, therefore making it impossible to shutdown your database. Something I just thought of though is that I some times edit my startup/shutdown scripts so that maintenance is performed on failover. You could try the same I would guess in Sun. -Original Message- Sent: Sunday, July 22, 2001 10:00 PM To: Multiple recipients of list ORACLE-L For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 8:10 PM Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN
Some misc. notes for RMAN with 8.1.6 on Tru64: - NLS_LANG must be set to the character set of the database you are backing up/restoring. e.g NLS_LANG=AMERICA_AMERICAN.WE8DEC - If doing a complete database restore, the database must be started up NOMOUNT. - When doing a cold backup, the database must be started up MOUNT. - Opening a database with RESETLOGS consitutes a new database incarnation. - Issue a RESET DATABASE after restoring using resetlogs. - These commands will tell RMAN to check to see what backup files are available (do it before trying to restore anything): allocate channel for maintenance type disk; crosscheck backup; Things I like about RMAN so far: - backups can be smaller than the database, since only used blocks are backed up. - incremental backups - the duplicate functionality - parallelizing the backup across multiple channels Things I dislike: - RMAN sometimes requests some backup files (when I am restoring a database) that I don't think it needs. This may be resolved by doing a database backup, followed by a separate command to backup the archivelogs. Issuing the database and archivelog backups in one big happy backup command my not include some of the archives that were generated while you were doing the backup (at least that is what Support told me). - Restoring a cold backup is easier (so I hear) if you use the TAG parameter during the backup. Otherwise you must use a point in time recovery, which requires some guessing as to what time/scn/seq# you really want to use. - The need to log into the catalog through SQL*Plus to get information that the list command doesn't give you. Sheesh! - The feeling that I lost a little bit of control to a piece of software that is supposed to do some of the thinking for me. I'm going through the school of hard knocks here, so I would love to hear from others. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/23/01 11:28AM Well looks like i've held off learning RMAN long enough, any pointers, good RTFM, etc. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Metablink .... down again?
I doubt that.. -Original Message- From: Christopher Spence [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Subject: RE: Metablink down again? I wouldn't doubt it, metalink goes down more than Clinton's pants. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: tnsnames.ora in clients
We switched to ONS 3 years ago have never regretted it. Getting rid of the tnsnames.ora file was the berries. Dick Goulet Reply Separator Author: Page; Bruce [EMAIL PROTECTED] Date: 7/23/2001 7:52 AM One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. -Original Message- From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject: tnsnames.ora in clients Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Wildly OT. - Air fares
GULP I wouldn't dream of going all the way to NY without spending some time there, so you can stand down :-) The idea was to fly into NY, spend about 4 nights there. Head off to Vancouver/Seattle, drive across to Vancouver Island, up to Campbell River, sea plane back over to the mainland and spend some time with the Grizzlies in Knights Inlet. Fly home from Vancouver, so the flight from NY to the West Coast would be one way. Probably about mid-september 2002. Looks like I may have to start being nice to the bank manager again Lee -Original Message- Sent: 23 July 2001 16:17 To: Multiple recipients of list ORACLE-L Lee, You're gonna hate this answer: it depends. Dates? times of day? are you flexible on airport? on travel dates and times? the sites I use to check prices are: www.orbitz.com www.travelocity.com www.expedia.com www.trip.com this will give you some idea. On orbitz, for travel July 30 from NY and Aug 6th back, from LaGuardia to Seattle, I found this: all are one stopover/plane change, price ranging from $398 to $2297 Now if you fly into NY and don't plan on spending any time here (even if it's only a couple of hours in the airport) you do know that I will have to hunt you down and hurt you, don't you? :) When are you visiting? Rachel From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Wildly OT. - Air fares Date: Mon, 23 Jul 2001 06:26:55 -0800 Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: setting DbName in SQL*PLUS
I changed my glogin.sql logged out, logged back on to sqlplus and nothing happened... Is there anything else I need to do? -Original Message- Sent: Monday, July 23, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Try this link: http://www.iherve.com/oracle/prompt_sqlplus.htm Script and explaination included. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 1:27 PM Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS thru glogin.sql? Shailesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrew Lieu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: RMAN
Joe, The Oracle-supplied "Oracle8i Recovery Manager User's Guide and Reference" has served me well. I'd advise experimenting with the various backup and recovery options and RMan commands on a little test DB to get the hang of it. RMan works very nicely. It's been much more reliable than the Veritas Netbackup tape backend. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Monday, July 23, 2001 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Well looks like i've held off learning RMAN long enough, any pointers, good RTFM, etc. thanks, joe