SP2 error
How do I investigate the following error? SP2-0735: unknown SET option beginning column_name=... I don't seem to find much... -- 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: SP2 error
Thank you Sergey, Your solution would not work because my error took place during an update. I was wondering what kind of errors the SP2 errors are and how to get more info on them. thanks to everyone who reply. -Original Message- Sent: Wednesday, February 13, 2002 11:53 AM To: Multiple recipients of list ORACLE-L You can't do that in SQL*Plus: SET COLUMN_NAME . You can see the list of parameters which you can set by issuing SHOW ALL (except a few). If you want to format a column, than: COL col_name_or_alias FORMAT . HTH, Best, Sergey -Original Message- Sent: Wednesday, February 13, 2002 11:18 AM To: Multiple recipients of list ORACLE-L How do I investigate the following error? SP2-0735: unknown SET option beginning column_name=... I don't seem to find much... -- 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: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
optimizer_mode/optimizer_rule
What is the difference between optimizet_mode and optimizer_goal parameters? Are they being used interchangeably? I've rtmf-ed. It is not clear. Thank you. -- 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: sqlplus question
What ring are you going to give to Kimberly? :-) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
sqlplus question
Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- 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: sqlplus question
Thanks Jared, that would be great and I did think about applying your suggestion. But there is a little detail I failed to mention. My rundays suppose to skip weekends( that is easy) and certain holidays. My OS is Windows NT. Any suggestion is greatly appreciated. -Original Message- Sent: Monday, January 28, 2002 6:09 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Yes, just run it on those days, skipping the days that you don't want it to run. ... But seriously, which platform? Unix, win32, OS/390, VMS? On unix use 'cron'. http://www.google.com/search?hl=enq=cron+tutorial On Win32 use the 'at' command: just type 'at /help' in a command window. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/02 02:21 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:sqlplus question Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 calculate Last and First Day of Month?
the first is always the first and the last may be calculated by using last_day function. -Original Message- Sent: Wednesday, January 23, 2002 4:32 PM To: Multiple recipients of list ORACLE-L Charlie Mengler wrote: I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards Another case of 'On what day does Xmas fall this year? - on December 25th'. I think that using the TRUNC() function with the suitable parameter must help you truncate SYSDATE to the first day of the month - perhaps TRUNC(SYSDATE, 'MM') or similar (too tired to RTFM). Then TO_CHAR with the suitable format should return whatever you want. For the last day, I presume that identifying the first day of the NEXT month and substracting 1 must simplify the 'is this 30/31/28/29' question. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sqlloader question
I need to load a text format file into my database using sqlloader. The table I am loading into contains a special code column 9 positions long with a following format ##--###--## (note dashes in between). Dashes are being stored in the database! (don't ask me why :-) ). My input file data for that column comes in straight text ( no dashes, of course ). It is 7 positions long. Is there a way to somehow input dashes using control file while loading data? I've looked 'concatenate' sqlloader command. It is not going to take care of my need. Thank you to everyone who replies. Have a safe a joyful new year. Lyuda Hoska -- 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 MAKE DELETION FAST
TRUNCATE TABLE :-) -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Loader Load Problem
page 121 'skipping fields you don't want to load' of g.gennick 'oracle sql*loader' book. -Original Message- Sent: Wednesday, December 19, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Ken, Good to know that it worked. Not sure what books you referred to, but if you deal with SQL*Loader a lot, then you may want to check out Jonathan Gennick's book titled 'Oracle SQL*Loader : The Definitive Guide' by O'Reilly. Regards. - Kirti -Original Message- Sent: Wednesday, December 19, 2001 7:20 AM To: Multiple recipients of list ORACLE-L Kirti: Another person recommended this approach and it worked very nicely. To bad it's not in the book. Thanks much, Ken -Original Message- Sent: Tuesday, December 18, 2001 10:20 PM To: Multiple recipients of list ORACLE-L Subject:RE: SQL Loader Load Problem Ken, If you are using 8i, then you can use the 'filler' fields. In this case the control file would look something like below(considering the fields are terminated by a comma and the table has columns a, b and c) load data infile 'myfile' into table mytable fields terminated by ',' (a char, b char, f3 filler char, f4 filler char, f5 filler char, f6 filler char, f42 filler char, c char ) If you are not using 8i, then you can not avoid an intermediate table, or use OS level tools to chop off the unwanted fields. HTH, - Kirti -Original Message- Sent: Tuesday, December 18, 2001 4:15 PM To: Multiple recipients of list ORACLE-L I have an input file that is delimited and contains 43 fields of various widths. I need to load only 3 fields into a DB table of 3 columns. 2 of the fields are at the beginning of the record and 1 is the very last field in the record. How can I load only these 3 cols and ignore the other 40 cols I don't need without having to use an intermediate table? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
how to pass argument to a dos batch program from sqlplus
Hello List, I need to pass several arguments to a dos batch program which is being called from sqlpus through HOST command. Example: host mybatch.bat myargument myargument Would such idea work? Thank you. -- 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: Not able to view table
Mark, I am a really confused with your last statement. Have you tried either of the following: select * from tblBundleCon; select * from 'tblBundleCon'; If you really did create them in lower and upper case, this could be your problem. Enclosing the table names in double quotes usually solves this.. Would you or someone else elaborate on this, pleeaassee? Are we still talking Oracle here -Original Message- Sent: Friday, November 30, 2001 7:25 AM To: Multiple recipients of list ORACLE-L Jyoti, Did you create the tables as SYSTEM? One thing I will say is that *YOU SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be stored in the SYSTEM tablespace - which is not a good idea. As system, create another tablespace (if one does not already exist), create a new user, with a default tablespace of the new tablespace, and use this user (with the appropriate system/object privileges) to create your tables/indexes/objects. On to another point about your mail - the password for SYSTEM is actually the default. How about changing that for security reasons? This may just be a test box, but there's nothing like good safe practice. Back to the original question: Who were you logged on as when you created the tables? Where did you create them? (tablespace). Have you tried either of the following: select * from tblBundleCon; select * from 'tblBundleCon'; If you really did create them in lower and upper case, this could be your problem. Enclosing the table names in double quotes usually solves this.. HTH Mark -Original Message- Sent: 30 November 2001 06:50 To: Multiple recipients of list ORACLE-L Hi all, I have created with the following details: Global DB name: manu.ifpjyo SID:manu Username: SYSTEM Password:manager Tables:tblBundleCon, tblTextCon, tblFinalImage I am able to connect to the database: SQL connect system@manu password: *** Connected. But I am unable to view the tables that I have created: SQLselect * from tblBundleCon; * ERROR at line 1: ORA-00942: table or view does not exist I get the above error. Where am I going wrong, Thanx a lot in advance. Jyoti. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NT Scheduler !!
'soon' command can run at any time interval. it doesn't have to be 3600 sec, could be any number of seconds. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 4:56 PM To: Multiple recipients of list ORACLE-L Hi, You could use the soon command (in the resource kit) to schedule it to run in 3600 seconds. The batch file could also have logic to check the current time to work out when to schedule it next. You could also use at and have your batch calculate the next time to run at - using either batch commands, some other scripting language or a freeware date time arithmetic program. Or as mentioned below, use the NT GUI scheduler (or some other scheduling tool that works on NT) Do you need more details? Regards, Bruce Reardon -Original Message- Sent: Wednesday, 31 October 2001 4:40 Saroj, The only way that I can do this is using NT's GUI Task Scheduler. There is an advanced option there that lets you repeat tasks at every specified interval and the duration. Regards, George -Original Message- Sent: Tuesday, October 30, 2001 12:20 AM Hello Guru, I want to run one batch in Windowns NT using At scheduler. Thw question is : a) There will be a start time end time ...say 7PM 12 PM b) Want to run the batch say in every hour (Have a fixed Interval time ) c)want to repeat step a b everyday I am facing the problem in AT command how to specify the interval time i.e every 1 hr the batch will be run. Please help me. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
data modeling processes
Hi, I am looking for some examples of DFD(data flow diagram), BPM(business process module), and SOW(statement of work); some web-pages with examples would be great. If someone can point those I would appreciate it. Thanks. Lyuda Hoska -- 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).
environmental variables
Is there any way to create NT environmental variables through script? Lyuda Hoska -- 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: environmental variables
John, may be it is a dump question.. but... there are certain directories my variables would go under. Note: I am declaring custom environmental variables. How do I address this issue? -Original Message- Sent: Monday, August 20, 2001 3:12 PM To: Multiple recipients of list ORACLE-L Simple. Put them in a batch file: @echo off set env1 = One set env2 = Two set oracle_sid = mydb ... Then reference like normal C:\ echo %oracle_sid% mydb Jon Walthour From: [EMAIL PROTECTED] Date: 2001/08/20 Mon PM 02:36:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: environmental variables Is there any way to create NT environmental variables through script? Lyuda Hoska -- 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: user holding session even after a re-boot
If the user already has his information displayed on the screen( retrieve already took place) and his/her machine freezes it is definitely application problem, may be networking problem but not back end problem. Printing problem is not an Oracle problem. If he/she is retrieving while printing it may be either. But still indications are your programmers didn't write good code. As to your question regarding the session I think it is not an unusual behavior. Check it in couple of minutes. It should be gone. -Original Message- Sent: Wednesday, August 15, 2001 12:11 PM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lost of all Control Files
If did 'alter database backup control file to trace' prior to your control files going bad check your user dump directory. Open that control file (it'll have .trc extension). They syntax will be right there. You will have to edit it deleting unnecessary info. HTH, [Lyuda Hoska] -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files Thanks, And what is the sintax of the create controlfile command ? How do I use it ? Now I will backup them :-) Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado el: Wednesday, 15 August, 2001 10:37 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs. You will loose the archiving and RMAN (if you have it) info though. At least you will not forget now to backup control files regularly ;-). Djordje -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 10:22 AMTo: Multiple recipients of list ORACLE-LSubject: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Speed up Truncate tables
Thomas, are your sure you can change the initial extent? My senior dba told me once it is not possible; you have to drop and recreate table if there is a need to change Initial extent. I am going to play with it today. -Original Message- Sent: Wednesday, August 15, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view) for the table in question, and modify them before you load the data. You can modify the INITIAL extent by issuing an 'alter table allocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (next x)' command to change the NEXT extent. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 11:02 AM To: Multiple recipients of list ORACLE-L I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Speed up Truncate tables
No, you cannot change the size of the initial extent. SQL select initial_extent/1024, next_extent/1024, min_extents, max_extents 2 from sys.dba_segments 3 where segment_name='T1'; INITIAL_EXTENT/1024 NEXT_EXTENT/1024 MIN_EXTENTS MAX_EXTENTS --- --- --- 64 64 1 2147483645 SQL ALTER TABLE T1 ALLOCATE EXTENT (SIZE 100 M); Table altered. SQL select initial_extent/1024, next_extent/1024, min_extents, max_extents 2 from sys.dba_segments 3 where segment_name='T1'; INITIAL_EXTENT/1024 NEXT_EXTENT/1024 MIN_EXTENTS MAX_EXTENTS --- --- --- 64 64 1 2147483645 The purpose of 'ALLOCATE EXTENT' option of ALTER TABLE command is to let you allocate a new extent explicitly. -Original Message- Sent: Wednesday, August 15, 2001 2:03 PM To: '[EMAIL PROTECTED]' Thomas, are your sure you can change the initial extent? My senior dba told me once it is not possible; you have to drop and recreate table if there is a need to change Initial extent. I am going to play with it today. -Original Message- Sent: Wednesday, August 15, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view) for the table in question, and modify them before you load the data. You can modify the INITIAL extent by issuing an 'alter table allocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (next x)' command to change the NEXT extent. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 11:02 AM To: Multiple recipients of list ORACLE-L I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RE: Lost of all Control Files
I said if you've done it before..Otherwise you're right :-(. May be a call Oracle support would help. -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 3:48 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files Hi Lyuda, Alter database backup controlfile to trace doesn't work because the DB doesn't mount. :-( Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de [EMAIL PROTECTED]Enviado el: Wednesday, 15 August, 2001 2:01 PMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If did 'alter database backup control file to trace' prior to your control files going bad check your user dump directory. Open that control file (it'll have .trc extension). They syntax will be right there. You will have to edit it deleting unnecessary info. HTH, [Lyuda Hoska] -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files Thanks, And what is the sintax of the create controlfile command ? How do I use it ? Now I will backup them :-) Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado el: Wednesday, 15 August, 2001 10:37 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs. You will loose the archiving and RMAN (if you have it) info though. At least you will not forget now to backup control files regularly ;-). Djordje -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 10:22 AMTo: Multiple recipients of list ORACLE-LSubject: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: having select from db link problems from 8.0.5.2.1
did you try to recreate the link? -Original Message- Sent: Tuesday, August 14, 2001 2:02 PM To: Multiple recipients of list ORACLE-L already did that , doesn't work, funny thing is I can tnsping that foreign database but doesn't work through db link. Thanks Sandesh -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Add the foreign host name to your local /etc/hosts file. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Naik, Sandesh S To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sandesh.naik@ cc: qwest.com Subject: having select from db link problems from 8.0.5.2.1 Sent by: [EMAIL PROTECTED] om 08/14/2001 12:06 PM Please respond to ORACLE-L Dear List, I have 8.0.5.2.1(32bit) database on HP-UX 11.0 server. I have a database link connecting to other database. I get following error while trying to access objects thorough db link ( db link goes to 8.1.6.2.0 (64bit) database on HP-UX 11.0 ORA-12545: Connect failed because target host or object does not exist There is work around to put IP address for this host in tnsnames.ora which fixes the problems. Is there any other good solution to this problem? All your suggestions are always welcome. Thank you Sandesh Naik Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- training
, but it does have to be a positive number. lhoska@calibr esys.com To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] root@fatcity.cc: com Subject: RE: OT -- training 08/13/2001 06:05 PM Please respond to ORACLE-L I've heard from my tax adviser your business doesn't have to show any profit for number of years after opening. I suspect even then it is not required. What if you having hard time making profit? It doesn't mean you have to close your business...I assume in that case you can also register as a non-profit organization. Are tax breaks better for non-profits? I don't know.. Also, if you don't already know.. some training companies (Learning Tree International per example) won't even register you for class if you're an individual. You have to be a corporation. Lyuda -Original Message- Sent: Monday, August 13, 2001 3:42 PM To: Multiple recipients of list ORACLE-L You could create a web site that features some technical materials and use it to advertise your services if you are willing to moonlight on a few jobs, just enough to turn a profit within a couple years. Then I would presume you would have no trouble writing the training off as a legitimate biz expense. - Ethan - http://www.geocities.com/epost1 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- training Patrice, There is resistance to any training that I feel is necessary to further my knowledge and/or enhance my understanding of the Oracle processes. Even though I have money in the budget for such items I have to submit a business case defining the gains to the company and after completing the course with a passing grade the company will reimburse me the expenses for the course only. I also have to sign a waver that I will pay the company back the full cost of the course if I leave their employment before 365 days. Needless to say I pay for everything myself and hope to write it off on taxes if they ever get the bill signed into law. ROR mª¿ªm [EMAIL PROTECTED] 08/13/01 11:46AM Just out of curiosity, how many days / weeks of real training did your employer provide you with in the last couple of years? real is in quotes, I don't mean the little 1 - 3 day seminars given by CareerTrack and other training companies, or management-related stuff like little MBA-flavoured certificates from universities. Oh, and did the amount of training you received match what you were told during your job interview? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
RE: OT -- training
I've heard from my tax adviser your business doesn't have to show any profit for number of years after opening. I suspect even then it is not required. What if you having hard time making profit? It doesn't mean you have to close your business...I assume in that case you can also register as a non-profit organization. Are tax breaks better for non-profits? I don't know.. Also, if you don't already know.. some training companies (Learning Tree International per example) won't even register you for class if you're an individual. You have to be a corporation. Lyuda -Original Message- Sent: Monday, August 13, 2001 3:42 PM To: Multiple recipients of list ORACLE-L You could create a web site that features some technical materials and use it to advertise your services if you are willing to moonlight on a few jobs, just enough to turn a profit within a couple years. Then I would presume you would have no trouble writing the training off as a legitimate biz expense. - Ethan - http://www.geocities.com/epost1 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- training Patrice, There is resistance to any training that I feel is necessary to further my knowledge and/or enhance my understanding of the Oracle processes. Even though I have money in the budget for such items I have to submit a business case defining the gains to the company and after completing the course with a passing grade the company will reimburse me the expenses for the course only. I also have to sign a waver that I will pay the company back the full cost of the course if I leave their employment before 365 days. Needless to say I pay for everything myself and hope to write it off on taxes if they ever get the bill signed into law. ROR mª¿ªm [EMAIL PROTECTED] 08/13/01 11:46AM Just out of curiosity, how many days / weeks of real training did your employer provide you with in the last couple of years? real is in quotes, I don't mean the little 1 - 3 day seminars given by CareerTrack and other training companies, or management-related stuff like little MBA-flavoured certificates from universities. Oh, and did the amount of training you received match what you were told during your job interview? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: OT -- training
knock, knock... :-) p.s. I always wondered if you can put blame on your tax adviser in case of trouble. I suspect, they won't buy it... [Lyuda Hoska]-Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 4:01 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT -- training Either to don't need to incorporate, or my tax accountant lied to me, I don't know which, but I have written off training and IOUG-A trips (that were paid for 100% by me) while I was an employee of a consulting firm. (Is that the IRS I hear knocking?) Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 3:42 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT -- training You can't write off training. you need to get incorporated. I'm a business entity and if/when the company i work for won't pay for training, you can bet it will get written off on my taxes, that includes all of the oracle books, OCP exams, you name it, it gets deducted as a legitimate company expense. 2 years ago the company i was working for didnt want to send me to openworld(and I knew i'd be leaving in less than 2months anyways), so i ate the cost and wrote the entire trip off. joe [EMAIL PROTECTED] 08/13/01 02:41PM Patrice,There is "resistance" to any training that I feel is necessary to further my knowledge and/or enhance my understanding of the Oracle processes. Even though I have money in the budget for such items I have to submit a business case defining the gains to the company and after completing the course with a passing grade the company will reimburse me the expenses for the course only. I also have to sign a waver that I will pay the company back the full cost of the course if I leave their employment before 365 days. Needless to say I pay for everything myself and hope to write it off on taxes if they ever get the bill signed into law.ROR mª¿ªm [EMAIL PROTECTED] 08/13/01 11:46AM Just out of curiosity, how many days / weeks of real training did youremployer provide you with in the last couple of years?"real" is in quotes, I don't mean the little 1 - 3 day seminars given byCareerTrack and other "training" companies, or management-related stuff likelittle MBA-flavoured certificates from universities.Oh, and did the amount of training you received match what you were toldduring your job interview?Regards,Patrice BoivinSystems Analyst (Oracle Certified DBA)Systems Admin Operations | Admin. et Exploit. des systèmesTechnology Services | Services technologiquesInformatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron Rogers INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: closing DB on NT with a scheduled BATCH FILE
or use oradim... oradimxx.exe -shutdown -sid sid -usrpwd password -shuttype inst -shutmode i oradimxx.exe -startup -sid sid -usrpwd password -starttype inst -pfile path\initsid.ora -Original Message- Sent: Thursday, August 09, 2001 12:45 PM To: Multiple recipients of list ORACLE-L 1. Create Batch file startdb.bat containts of startdb.bat --- SVRMGRL @c:\yourdirectory\startup.sql 2. create startup.sql containts of startup.sql connect internal/***; startup exclusive open; 3. Create Batch file stopdb.bat containts of stopdb.bat --- SVRMGRL @c:\yourdirectory\stop.sql 4. create stop.sql containts of stop.sql connect internal/***; shutdown immediate; now schedule startdb.bat stopdb.bat into NT scheduler. If you want to do it thru a single bat file than call the 2nd bat from 1st. I hope this clarifies your problem. Regards, Ramesh D Papnoi (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] Hi Ihoska , I am sorry to read your reply. Firstly Not a silly question. Yes I am sure batch file runs because I can run it directly correctly. Yes I create log file. I investigate task manager if svrmgrl runs and look at v$session and it connects . So not a silly question as you see. Only thing is you do not understand the problem perhaps. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 8:33 PM Subject: RE: closing DB on NT with a scheduled BATCH FILE silly question. Are you sure your batch file runs? Do you create logs? If so, did you check if log was created? How do you know it connects. I have similar batch files. They run either way with no problems. -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Subject: closing DB on NT with a scheduled BATCH FILE Dear Gurus , I have a question , In fact I wonder if it is a bug of NT . I want to close and reopen database with a .BAT file . When I execute the .bat file directly it executes correctly . But When I execute it with a schedule with AT command then it connects but does not close database. How can I handle That. ? What do you do when you want to schedule startups and shutdowns of database on NT? Thank you -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT Dorothy Parker :)
Congratulations on your survival Shrek. Having more work is better than having NO work. -Original Message- Sent: Thursday, August 09, 2001 4:46 PM To: Multiple recipients of list ORACLE-L geez, is it friday yet? i hope so, cuz we just got done laying off 25% of the people here. same work + less people := get-out-of-dodge-NOW. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. MIPS: Meaningless Indicator of Processor Speed. -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: closing DB on NT with a scheduled BATCH FILE
I had the same question. 'How does it matter whether the command file is on C drive or D/E (other) drives?' Does anyone know? -Original Message- Sent: Thursday, August 09, 2001 4:31 AM To: Multiple recipients of list ORACLE-L Jared, Just out of curiosity I am asking ( May be I am missing something) How does it matter whether the command file is on C drive or D/E (other) drives? Some other things I would suggest is 1. Generate a logfile for every command file (including one in schedular) for example on schedular you type the command as: c:\backup\startorcl.bat c:\backup\startorcl.log and not just c:\backup\startorcl.bat 2. Define the environment variables (ORACLE_SID , ORACLE_HOME etc) in bat file and provide the full path of commands e.g. SET ORACLE_SID=ORCL d:\orant\816\bin\svrmgrl.exe connect internal/pass h:\backup\shut1supp.sql h:\backup\logs\shut1supp.log 3. Use some GUI version of Schedular e.g. WINAT or NT's native schedular. If you need any more assistance do get back.. Regards, Rajesh -Original Message- [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 4:45 AM To: Multiple recipients of list ORACLE-L Because you are running this in the AT scheduler, it is not executing with the same permissions. I'll bet that your batch script it not on the C: drive. Put it on the C: drive and see if it works. Jared Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havels cc: an.com.tr Subject: closing DB on NT with a scheduled BATCH FILE Sent by: [EMAIL PROTECTED] 08/08/01 06:15 AM Please respond to ORACLE-L Dear Gurus , I have a question , In fact I wonder if it is a bug of NT . I want to close and reopen database with a .BAT file . When I execute the .bat file directly it executes correctly . But When I execute it with a schedule with AT command then it connects but does not close database. How can I handle That. ? What do you do when you want to schedule startups and shutdowns of database on NT? Thank you -- 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: closing DB on NT with a scheduled BATCH FILE
silly question. Are you sure your batch file runs? Do you create logs? If so, did you check if log was created? How do you know it connects. I have similar batch files. They run either way with no problems. -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001 9:15 AMTo: Multiple recipients of list ORACLE-LSubject: closing DB on NT with a scheduled BATCH FILE Dear Gurus , I have a question , In fact I wonder if it is a bug of NT . I want to close and reopen database with a .BAT file . When I executethe .bat file directly it executes correctly . But When I execute it with a schedule with AT command then it connects but does not close database. How can I handle That. ? What do you do when you want to schedule startups and shutdowns of database on NT? Thank you
RE: sqlloader stops
one after another. Thanks for your interest... -Original Message-From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: Re: sqlloader stops Lyuda, I'll jump intothe game of 20 questions. Is the batch file kicking off the jobs in serial (one after the other) or in parallel (maybe using to put each one in the background)? Stephen Andert [EMAIL PROTECTED] 08/08/01 07:06AM If I execute one load at the time maually it loads fine. It gives me hardtime when I try to run multiple loads(one after another) through the batchfile.- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, August 07, 2001 9:05 PM How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 2001 5:37 PM To: Multiple recipients of list ORACLE-L Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader.It works fine on other servers. There is this one server that is givingme a hard time. It loads 3 files and then stops. I commented out thethird call to sqlloader thinking may be there is something wrong with a thirdtext file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enoughspace on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lyudah INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
sqlloader stops
Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- 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: sqlloader stops
My impression is the ERRORS parameter is set for each single load not number of loads. No, there is no bad file. Thanks David. -Original Message- Sent: Tuesday, August 07, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Just a stab here... Check the .bad files to see if you are getting any data rows kicked out due to errors. If so, you might be exceeding the ERRORS parameter by the time you finish the third file. HTH. David Wagoner DBA -Original Message- Sent: Tuesday, August 07, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- 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: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlloader stops
Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 2001 5:37 PM To: Multiple recipients of list ORACLE-L Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
huge datafiles/need help
Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. Lyuda Hoska -- 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: Using AT command in NT
or try winat and get a window version of it.. -Original Message- Sent: Wednesday, August 01, 2001 4:04 PM To: Multiple recipients of list ORACLE-L Try, at 12:00pm /every:m,t,w,th,f c:\my_backups\backup.bat George -Original Message- Sent: Wednesday, August 01, 2001 11:28 AM To: LazyDBA.com Discussion I'm looking into setting up my backups and want to use the AT command in NT but I need some examples of the command line. I Know that I want it daily at midnight,but how do I do this in command line mode, What is the command? This is what I have tried and it does'nt work. AT /every:date M,T,W,TH,F 12:00pm c:\my_backups -- this does not work. Help please _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT -- suggestions to ensure nerdiness in potential IT staff
We need to admit the rest of the world considers us geeks. Even in IT world dba's are probably one of the geekeest (is it a new word I invented?), not too many people like us. Well, may be C++ programmers would come close in geekeness (new word again?) to us. My friend tried to hook me up with a guy whose profession had nothing to do with IT. He was concerned about my occupation... I need to let him read some of the e-mails on this list so he may know we're normal people and we know how to laugh. Should we also let duhvelopers in to prove to them we're OK? No, we won't bother... Lyuda -Original Message- Sent: Wednesday, August 01, 2001 4:52 PM To: Multiple recipients of list ORACLE-L What famous character was used to first advertise the IBM PC? Charlie Chaplin, easy one. Was it possible to connect two screens to the original IBM PC? How? I believe I did one through a Hercules graphics card, but dont quote me. How many boot disks did computers require before 1982? 0 How would you convert a 1-sided 5 ¼ diskette into a 2-sided one? Flip the floppy and cut a notch. I actually used scissors. I loved it when they came out with those precise clippers. How did the Commodore Pet make use of hard disk drives? Floppy drives? Never had one, sorry. What colour were the Verbatim 5 ¼ diskette pockets? Was it grey? Was that 3Ms? I remember paying 50 bucks for 10 floppies. I thought it was a great deal!! What IBM PS/2 model was listed as having a 2.88M diskette drive? Sorry, I went with all the generic PCs. What version of Windows did OS/2 not support? Why not? Did the first macintosh computer come with a handle? What is an MWave Windsurfer card? Which company could be argued started the certification fad in IT? Bonus points: What figurines appear on PC Magazine Vol 1., Issue 1's cover? (I notice PC Magazine has gone back to the thickness it had for issue 1, vol 1... heh heh I wonder what happened). Extremely important entertainment bonus question: What cartridges came with the Atari 2600 game system upon initial purchase? Asteroids, I think. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
There are some farmers who will let you visit their farm and let you pick some berries. I assume you need to pay a fee. A friend of mine invited me to go berry-picking with her passed Saturday. I could not make it because I had to work.. But if someone is interested there probably are some farms like that around your area. -Original Message- Sent: Wednesday, August 01, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Are they still there? anyone up for a field trip? :) From: April Wells [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest Date: Wed, 01 Aug 2001 13:22:02 -0800 Canteberry Acres farm Nutt Road Grove City Pennsylvania They were the farm next door when I was growing up. Charles Hamilton owner/operator... It was heavenly. I worked for him for 10 years clipping blossoms picking berries. It was then that I learned why you run your irrigation systems when there is frost in the early spring... =) -Original Message- Sent: Wednesday, August 01, 2001 4:02 PM To: Multiple recipients of list ORACLE-L While you're at it, April, could you tell me where I could get about 80 pounds of those strawberries? The frozen ones I've been using to make wine are not quite what I have hoped they'd be. David -Original Message- Carmichael Sent: Wednesday, August 01, 2001 1:16 PM To: Multiple recipients of list ORACLE-L April, Okay, now tell me WHERE I can get those? The ones from the greenmarket are already insanely wonderful, I'm not sure I could stand anything more intense :) Rachel From: April Wells [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest Date: Wed, 01 Aug 2001 10:37:19 -0800 Rachel, You need to try strawberries, warm from the sun, wet from the irrigation system, with the light dusty dirt still crunching on them. April -Original Message- Sent: Wednesday, August 01, 2001 12:17 AM To: Multiple recipients of list ORACLE-L Ian, You have my sympathies for your struggles. And my respect for how you seem to be dealing with them. My husband was a hemophiliac. Just living with that as an adult was hard. To live with a genetic disorder in a child must be infinitely harder. I have an enormous respect for my mother-in-law who raised such a child and did not wrap him in cotton-wool, in case he got hurt. You are in CA, where you can get a much better assortment of non-store-bought produce than I can here in NYC, although I tend to frequent the greenmarkets and try to buy what is in season when I buy in stores. Even then, store-bought doesn't taste as good as fresh-picked. I have converted one person at work to never eating store-bought strawberries again, he tried some from the greenmarket when they were in season and was convinced. Rachel From: MacGregor, Ian A. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest Date: Tue, 31 Jul 2001 15:15:35 -0800 So where do I get my woolly mammoth steaks. What was the life expectancy of early hominids? I don't know about Maine Blue Berries, but wild blueberries in Nova Scotia are just as sweet if not sweeter than the store bought ones. Where in a reputable peer-reviewed journal can one find an article store bought food is less nutritious than wild food. The purpose of fruit is to be eaten, the seeds passing through the digestive system intact to be planted with a little fertilizer. The sweeter the fruit, the more animals are attracted, the greater chance of the plant dispersing its progeny. As far as I can tell taste takes a second seat to looks with commercial produce. Produce is picked before its time so it can be transported unbruised. It doesn't taste as good as the stuff off a backyard tree. My daughter is autistic. We have her on a cassein and gluten free diet. It seems to have done her some good; her attentiveness has increased and her perserveration has dropped. My wife swears it has; I lean more towards non-casual coincidence, but I don't want to give her bread pudding in case I'm wrong. You won't believe how many things have gluten and cassein. Gluten is not naturally found in corn, but it's in corn flakes. Most soy cheeses have cassein in them so they melt like dairy cheeses. It is very difficult to keep on such a diet, taking all grains out of the diet would be harder still. Autism is a multi-genetic disorder; i.e, more than one gene is involved. Latest evidence is that the genes express themselves about the first month of pregnancy. In the future it will be
RE: sqlloader process dies
Thank you Kevin. No, drive has plenty of space. Any one else has a guess? -Original Message- Sent: Tuesday, July 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Since it can't create a log file either ... how about space ??? running out of space on the machine ?? -Original Message- Sent: Tuesday, July 31, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hi, I am experiencing a problem with sqlloader not being able to finish a large load. It tries to load between 1 and 2 millions records. Sometime during the load it just dies. I see an attempt to create a log file but the file size remains 0 bytes. It remains 0 size until the next day when new process kicks off. The described scenario occurs day after day. It is a cron job kicked from a batch file running multiple loads simultaneously. There are two particular loads that die every day... Anyone has any idea? Thank you for your help Lyuda -- 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: 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). -- 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: sqlloader process dies
I could do it but the trick it to load it all at once... -Original Message- Sent: Tuesday, July 31, 2001 7:06 PM To: Multiple recipients of list ORACLE-L Why don't you try to divide this load in several parts. Alex Hillman -Original Message- Sent: Tuesday, July 31, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Thank you Kevin. No, drive has plenty of space. Any one else has a guess? -Original Message- Sent: Tuesday, July 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Since it can't create a log file either ... how about space ??? running out of space on the machine ?? -Original Message- Sent: Tuesday, July 31, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hi, I am experiencing a problem with sqlloader not being able to finish a large load. It tries to load between 1 and 2 millions records. Sometime during the load it just dies. I see an attempt to create a log file but the file size remains 0 bytes. It remains 0 size until the next day when new process kicks off. The described scenario occurs day after day. It is a cron job kicked from a batch file running multiple loads simultaneously. There are two particular loads that die every day... Anyone has any idea? Thank you for your help Lyuda -- 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: 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). -- 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 clean NT services ???
Preferable solution: ORADIMxx -DELETE -SID SID xx will depend on your version or Oracle or ORADIMxx -DELETE -SRVC service_name service_name is your service name Alternative solution: In your registry settings. Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, and remove all keys that begin with ORACLE. -Original Message- Sent: Tuesday, July 31, 2001 7:06 PM To: Multiple recipients of list ORACLE-L Hi all, I installed, deinstalled, and reinstalled some Oracle tools. In the NT service window, I still see the service name for non-extisting services. How can I clean out these services? (NT 4.0, Oracle 815 EE for NT, OEM 204). Thanks. Andrea __ 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: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
FW: setting DbName in SQL*PLUS
I looked at rtfm and found sqlprompt will only work if sqlnumber is off. Added that line to the script, still doesn't work. Looks like it is not picking glogin.sql. Anyone has any idea what else I need to do? Thank you. Lyuda -Original Message- Sent: Monday, July 23, 2001 1:17 PM To: Lyuda Hoska I looked at rtfm and found sqlprompt will only work if sqlnumber is off. Added that line to the script, still doesn't work. Looks like it is not picking glogin.sql. Anyone has any idea what else I need to do? Thank you. Lyuda -Original Message- Sent: Monday, July 23, 2001 12:59 PM To: '[EMAIL PROTECTED]' 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: How to search all tables for a particular field?
select table_name, column_name from sys.dba_tab_columns where column_name like 'your_column_name%'; -Original Message- Sent: Thursday, July 19, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Hi, I am looking for a particular field if it exists in a database. How to search all tables for a particular field? Thanks in advance. Igor _ 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: igor z INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Re[2]: security problem with 8i
My old job had never changed any of the default passwords. And the reason why standard passwords are kept is because it is 'easy to remember'. Go figure... -Original Message- Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the standard password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the standard value and leave the room. Hey, it's a job. -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Last Update
Guys, can you please confirm to me you found dba_tab_modifications table. I checked both 7.3.4 and 8i versions and I don't seem to find the table. Thank you. -Original Message- Sent: Tuesday, July 17, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Hi, Thanks for the clarification. Always welcome. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: alter table monitoring. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
private/public rollbacks
Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- 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: alert log is not capturing all errors
Thank you John. -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 5:56 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log is not capturing all errors The alert log does not capture anything it considers to be a user error. HTH, John [EMAIL PROTECTED] 07/12/01 12:35PM Hi List,I have encountered a little strange incident. Here is a brief:I ran a package which runs every day early in the morning. I create a logof the process through the spool command.Today my package didn't run. It had an error saying 'ERROR at line 1: ORA-04068: existing state of packages has been discarded' . Anyway, not abig deal. I think I eliminated the error.The thing that puzzles me is that error IS NOT in the alert log. I had animpression that alert log would capture ALL of the errors occurring on thesystem. Isn't it the case?Thank you for your support.Lyuda Hoska-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: need to recreate database
Thank you very much to all who replied to this post and the post about oradim. Mission was accomplished successfully and everybody is happy. -Original Message- Sent: Wednesday, July 11, 2001 10:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Lyuda, If I understand your post correctly, your networking folks didn't install Oracle on the new server, but instead just copied the directory structures over. This means you don't have any of the registry entries. While it is theoretically possible to export the registry keys from one server and import them into another, I would NOT recommend doing this - it's far too easy to make a mistake somewhere and totally mess things up. Besides, Oracle Support will tell you you're unsupported if you do so. As long as the db was cleanly shut down when the files were backed up you should be able to open the db OK. 1. Install the software (select custom install and don't have it create a starter db for you). 2. Edit the init.ora and make any changes to directory locations, as needed. 3. Create the services for the db (see note: 61621.1 WINNT/WIN2000 Recreating Oracle Services and Instances from the Command Line) 4. If the directory structures (datafiles, online logs, etc...) and db_name will be the same on the new server then you don't need to recreate the controlfile. If they need to change, see steps 1, 6, 8 of note: 73301.1 How to make a copy of a database on the same Windows NT machine HTH, -- Anita --- [EMAIL PROTECTED] wrote: Hello, I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I need to do is to make the second part of the task work, create the database, services, etc and make it run. I have not done it before and if I was doing it I would probably do export/import type of thing but the higher ups would like to have it done this way. One of the people has an idea suggesting just recreating the registry setting by exporting it from the existing machine to the new one. The other option is to reinstall Oracle but I am not sure how to make it to accept existing physical components(datafiles, control file, etc). If someone has a suggestion I would greatly appreciate it. Thank you in advance. Lyuda Hoska -- 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
need to recreate database
Hello, I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I need to do is to make the second part of the task work, create the database, services, etc and make it run. I have not done it before and if I was doing it I would probably do export/import type of thing but the higher ups would like to have it done this way. One of the people has an idea suggesting just recreating the registry setting by exporting it from the existing machine to the new one. The other option is to reinstall Oracle but I am not sure how to make it to accept existing physical components(datafiles, control file, etc). If someone has a suggestion I would greatly appreciate it. Thank you in advance. Lyuda Hoska -- 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: Rename alert log
Yes, it can. Just rename it and there will be new one created with an old name at some point. -Original Message- Sent: Tuesday, July 10, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oradim
Can anyone point to oradim utility documentation? I am having a little hard time finding it. Thank you. Lyuda Hoska -- 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).
temp tablespace is permanent tablespace
Hi, One of the generic users (multiple people use the same logon/password) on one of my db's has been assigned temporary tablespace which is a permanent tablespace type, i.e. (select contents from dba_tablespaces where tablespace_name=my_ts_name; returns PERMANENT). I was told by let it stay that way. I am investigating the whole thing (just for myself). Is there any true reason why the user would need their temp tablespace to be permanent? Could my situation cause any major problems? If so, what things I need keep my eye on in order to avoid them? Thank you. Lyuda Hoska -- 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).
No Subject
test Lyuda Hoska -- 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: SUMMARY: BIG PROBLEM
Why don't you cc: copy your e-mail to your HR. Just one look at the subject line will make them to realize what they've done... ;-) -Original Message- Sent: Friday, June 29, 2001 6:24 PM To: Multiple recipients of list ORACLE-L Does that mean you won't need an Oracle DBA anymore? :) -Original Message- Sent: Friday, June 29, 2001 2:12 PM To: Multiple recipients of list ORACLE-L This worked great!!! Thanks to all who replied! -Original Message- Applewhite Sent: Friday, June 29, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Edward, Your database backup is OK. RMan just can't backup and delete the archived redo logs that you moved. If you want RMan to backup, then delete, those archived redo logs, you'll have to move them back to the drive from which they came. Then do another backup. If you've got lots of logs, it may take several batches to get them all. If you just want to go forward, with RMan backing up and deleting the logs from now on, issue the following command at the RMan prompt: allocate channel for maintenance type disk; change archivelog all crosscheck; release channel; That will cause RMan to forget about the archived redo logs you've moved, but it will pick up with the logs that have since been created and are still in the expected directory. Good luck. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carr Sent: Friday, June 29, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ... RMAN-03022: compiling command: backup RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not found or out of sync with catalog The problem here is twofold: 1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs. As I am not a DBA I have no clue how to fix this, but it needs to be done A.S.A.P. ... Thanks to anyone who can help me!!! -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Edward W. Carr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Venkata's pc is back in line VIRUS messgaes again
He finally got me, too. I received one e-mail sent directly to me as a reply to my yesterday's post to the list. I blocked his e-mail but is there anything we can do to refuse him access to the list for now? It becomes annoying, not to mention that if he is doing it on purpose he is the lowest form of life on this Earth. HELP -Original Message- Sent: Thursday, June 28, 2001 11:46 AM To: Multiple recipients of list ORACLE-L I Just received 3 messages from Venlata Apparao that had virus's attached. My mail server deleted the attachment. The mail was sent directly to me and not the ORACLE-L list. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: virus question
I think it might've been send directly because I did not receive any of the infected e-mails from that individual. Again I just joined the list recently. To refresh your memory, I also don't receive as many recruitment adds as you guys do. So, some people might've got a hold of the list members before I joined the list. Would you be able to determine if there were other e-mails from that person sent to the list with Oracle related questions or he/she is not even interested in Oracle but just a hacker? Buy the way, I don't have any of his/her e-mails... Just a little FYI. -Original Message- Sent: Wednesday, June 27, 2001 4:23 PM To: Multiple recipients of list ORACLE-L I think I must have something confused here. If this list removes attachments to avoid viruses, how does a virus in an attachment come through the list? I would think that it might be sent out directly. This makes some sense as it seems that not everyone is receiving the same attachment. At this point I haven't received any but since I frequently receive messages out of order that does prove anything. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: duel error
I think Dual is a table. 1 SELECT TABLE_NAME FROM SYS.DBA_TABLES 2* WHERE TABLE_NAME='DUAL' SQL / TABLE_NAME -- DUAL SQL DESC DUAL NameNull?Type --- DUMMYVARCHAR2(1) -Original Message- Sent: Tuesday, June 19, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Dual is not a table. It just a placeholder. At 11:04 AM 6/19/01 -0800, you wrote: You could always just run catalog.sql as sys. -Original Message- Sent: Tuesday, June 19, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hal Wigoda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS vs SYSTEM
Is it the same old rumor or it could be confirmed 100%? -Original Message- Sent: Friday, June 15, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Well you will have alot of scripts to change, internal is gone in 9i. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 15, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Greg, I was told by Oracle Support when I started using Rman under version 8.0 to use SYS or INTERNAL, as it is better. Between you and me, better is quite subjective. But, I wrote scripts that connect as INTERNAL, and it has been working fine ever since, so I did not re-visit it. Do you use a DBA account? Is there a better way? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 15, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Tom, Why do you use SYS exclusively for startup and shutdown, since your DBA priv account could also accomplish this? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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: OT SPAM : Become an Oracle Certified DBA in 5 Weeks
FYI, I am on the list and not on newsgroup and I did not receive that message. Another clue: I had joined just recently so it might've been some time ago some one got a hold of the list.. -Original Message- Sent: Thursday, June 14, 2001 11:47 AM To: Multiple recipients of list ORACLE-L On Thu, 14 Jun 2001,Boivin, Patrice J scribbled on the wall in glitter crayon: -FYI, - -I got one of these at home, but not at work. - -At home I have logged into the oracle.server newsgroup, but never Jared's -list. - -At work I subscribe to Jared's list, but never went to the newsgroup. - -This tells me that unless I received the e-mail at work as well and didn't -notice, our addresses were lifted off the newsgroup and not this list. - -Another reason why I don't like newsgroups all that much. except i got 2 and never go to the newsgroup.;-) but i did go to lazyDBA for a few hours. -- 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. ~~ Abstraction is achieved by data hiding and enforced by encapsulation. -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HELP !!! scrpt works with sql plus but not in a procedure
It may not be the real fix but you need a space before 'RECEIVED' on line 3. line 3: SUM(INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY) RECEIVED. Another thing: you don't need to say ALL in your select. ALL is a default. -Original Message- Sent: Wednesday, June 13, 2001 5:52 PM To: Multiple recipients of list ORACLE-L I have this script that works fine in sql plus but when I attach it to a procedure in my report it gives me an error error 101 Encountered a symbol SELECT when expecting one of the following The error surfaces when the bolded line (choosing the date) is included in the script. What is the possible fix for this? INSERT INTO AWW_ISSUED SELECT ALL INV.MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID, SUM(INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY)RECEIVED FROM INV.MTL_MATERIAL_TRANSACTIONS WHERE (INV.MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID=3 AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID IN (1, 31, 32, 33, 34, 36, 40, 41, 42, 18, 2, 50, 51, 12, 61, 21, 4, 80) AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY 0) AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE BETWEEN '01-JUN-01' AND '30-JUN-01' AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE BETWEEN (SELECT TO_DATE('01' || SUBSTR(TO_CHAR(SYSDATE),3,9)) FROM DUAL)AND (SELECT LAST_DAY(SYSDATE) FROM DUAL) GROUP BY INV.MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID; I appreciate all the help -- 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). -- 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: set feedback off in procedure
I am not sure what you're trying to do but look at the possibility of using dbms_output.put_line(...) in your pl/sql code. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Hi Harvinder! Sorry - no, you can't use these commands inside PL/SQL. set feedback on|off and alike are not SQL statements, but extensions outside SQL ( indicated by SQL*PLUS ) only available in the SQL*PLUS executables , but not in the PL/SQL or SQL engines of your Oracle clients or servers ( You can execute these commands without being connected to an Oracle instance). Does your application invoke SQL*PLUS? If yes, your application could invoke SQL*PLUS to build dynamically a script and then execute the script which contains the call to your procedure and embeds the set feedback ... commands. I need more information about what your program should do to, to get a chance to help you a little bit more. Andreas -- Von: Harvinder Singh[SMTP:[EMAIL PROTECTED]] Gesendet: Dienstag, 12. Juni 2001 01:50 An: Multiple recipients of list ORACLE-L Betreff: set feedback off in procedure Hi, Can we use the following commands inside the pl/sql procedure.(due to application requirement) set feedback off set fedback on If yes at what point in procedure. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: apology
'The Soviet Union does not exist any more in its present format'. What is that suppose to mean? Just curious... -Original Message- Sent: Tuesday, June 12, 2001 5:31 PM To: Multiple recipients of list ORACLE-L On Tue, 12 Jun 2001,Thater, William scribbled on the wall in glitter crayon: -well, i'm jealous. i could use some. my aunt died from breast cancer over the weekend and the funerial was today. oh damn, this was not supposed to go to the list. i'm sorry for bothering everyone with my personal stuff. put it down to lack of single malt.;-) -- 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. ~~ The Soviet Union does not exist any more in its present format. -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 prevent oracle from committing a transaction?
Commit will take place after any DDL statement. Besides that, Oracle Complete Reference by George Koch and Kevin Loney states that commit will occur after you execute the following commands: exit, quit, and even connect. If you are worried about unmanaged commits after the sudden instance crash then don't worry it won't happen. Oracle will roll everything back after the instance comes back up. As to commits occurring due to the 'exit' command it seems it is not possible to stop. But you have control in that situation. Just before typing 'exit' type 'rollback' and no changes will take place. Hope this helps, and please correct me if I am wrong. -Original Message- Sent: Tuesday, June 05, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Wait a minute here. Why would oracle do a commit on your transaction just because it needs to do a checkpoint, logfile switch, or shutdown? What if errors occur during validation? Do you think Oracle will commit the data anyways? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
This will work: RENAME TABLE_NAME TO table_name_2; create table TABLE_NAMEas select * from table_name_2; DROP TABLE table_name_2; Note you don't need to issue a 'commit' after after create table or drop table. Also, when you do create table as select from another table there is no need to specify the columns. The new table you created will have the same columns as the tables you're selecting your data from. -Original Message-From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 05, 2001 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Renaming columns ... will this work? RENAME TABLE_NAME TO table_name_2; create table TABLE_NAME(column_name_you_want...)as select * from table_name_2;COMMIT; DROP TABLE table_name_2;COMMIT; HTH "Deshpande, Kirti" [EMAIL PROTECTED] wrote: Hi Raj,1. There is a way to do it. And Mr. Steve A. has some good info about it (its implications) on his web site. (Sorry I do not have a direct URL link toit). I believe this works for all versions. 2. Yes, it does. I have played with it on my test database.However, I will not do this on a Production database as it involves adirect DML to modify sys.COL$. And Oracle does not recommend doing suchthings to your databases. I am not sure if renaming column is supported in 9i. Anyone else know forsure? If you are using 8i, the safe way to address this is to add a new column tothe table, populate it with the contents from the old, and drop the oldcolumn. If the column is not nullable, and if there are plenty of nullablecolumns towards the end of the table, I suggest considering reorganizationof the table. I just did that (! ! reorg) in the last couple of weeks with a60Mil row table to get the new not nullable columns towards the 'head' ofthe table. HTH,Regards,- Kirti Deshpande Verizon Information Serviceshttp://www.superpages.com -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Subject: Renaming columns ... Hi all, although I am searching information on Metalink and OTN, I just want to ask this question to the list ... 1. Is it possible to rename a column? (we have lots of columns that need to be renamed). Which version supports it? 2. Does renaming automatically takes care of indexes? Coding will be a lot of manual labor, but that's okay we can handle it. Thanks in advanc! ! e 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 ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Deshpande, KirtiINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the! ! HELP command for other information (like subscribing). Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
RE: what to put in place of null
Try applying data conversion function to_char/to_date or nvl function if dd and dd1 are numbers to the nulls in the second select. Example: cursor c1 is select dd,dd1,dd2,dd3 from dd union select to_char(null),to_char(null),dd2,dd3 from dd1; The point here is you need to have as many columns in your second select statement as your first select has and the datatypes have to match. -Original Message- Sent: Tuesday, June 05, 2001 5:31 PM To: Multiple recipients of list ORACLE-L Hi, I have a cursor declared as cursor c1 is select dd,dd1,dd2,dd3 from dd union select null,null,dd2,dd3 from dd1; i am getting error: * ERROR at line 1: ORA-01790: expression must have same datatype as corresponding expression ORA-06512: at DY.REST, line 4 ORA-06512: at DY.REST, line 10 ORA-06512: at line 1 what to replace null with.. dd1 has only 2 columns dd2 and dd3. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Auto Extend
What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- 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: Auto Extend
I am running multiple Oracle 7.3-8i databases on NT. Is there someone on this forum who can answer my question:which parameter I need to set up to increase the file size limit? I have a feeling there may not be one. I was told by one of the super-senior Oracle people :-) there is an Oracle (not NT) bug with Oracle versions below 8i which creates problems with datafiles above 2G size. Thank you. -Original Message- Sent: Thursday, May 31, 2001 4:10 PM To: Multiple recipients of list ORACLE-L On our old AIX system we had to set a system parameter for the file system that allowed us to have files bigger than 2 GB. I do not know if your system has something like that. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- 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: 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). -- 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: Script and control file
If it is NT you can create a batch file similar to Unix example given below which will do the same. The only difference here is you'll have to save your sqlplus scripts in a text or *.sql format and call them from the batch file. After that you can call sqlloader. -Original Message- Sent: Tuesday, May 29, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Andrea, Is this UNIX or NT. In UNIX ( I don't know NT that well), the most simple method would be to use a shell script. The following is about as basic as it comes but would need to be embellished with environment settings and error checking etc.. eg. Start of Script sqlplus username/passwd EOF create table TABLE1 ( col1, col2.); exit; EOF sqlldr parameters sqlplus username/password EOF2 select from TABLE1 where (.); exit; EOF2 End of Script - Regards Lee -Original Message- Sent: 29 May 2001 16:16 To: Multiple recipients of list ORACLE-L First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using SQL language. Is it possible do this inside a .sql file ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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).
simple question
Does any one have an example of 'alter tablespace add datafile' statement? I am having a little trouble.. Thank you. -- 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: simple question
Problem resolved. Oracle 8 Complete Reference I was using contains an incorrect syntax. They use MAXSIZE instead of SIZE in the syntax. Thank you to all of those who replied. -Original Message- Sent: Tuesday, May 29, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Does any one have an example of 'alter tablespace add datafile' statement? I am having a little trouble.. Thank you. -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).