RE: What is wrong with this?
Hallo, select sys_store_id.nextval from dual; Cheers -Original Message- Sent: Wednesday, March 26, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Hallo, I have this sequence, CREATE SEQUENCE SYS_STORE_ID START WITH 1 INCREMENT BY 1 NOMAXVALUE NOCYCLE CACHE 10; I am trying to run this script, sys_store_id.nextval: but get this errormessage: unknown command beginning SYS_STORE_... - rest of line ignored. How can I solve this problem? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Retrieving Sets of Record via VB
Use the ADO Reordset Object PageSize Property to logically divide the Recordset object into a series of pages, Each of which has the number of records equal to PageSize (except for the last page which might have fewer records). http://members.evolt.org/help/caspdoc/html/ado_recordset_object_absolutepage _property.htm I haven't done anything like this before but if you search the net for ADO Recordset PageSize I'm Sure you'll find some examples to get you started. Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 07, 2003 7:58 AM All, My current application is written in VB accessing the Oracle back-end. I have just been asked about how to execute a query that may return many thousands of rows, but only display, let's say, 1000 at a time. After the first set of rows was returned, the user would click a button and request the next thousand. We are currently using reference cursors and everything is working well. I was wondering if anyone has done something like this, and how did you do it? I could see using an inline view and re-executing the query every time and selecting the range of records to return. Storing the result set in a temporary/rollup table might also work. I obviously would need to clear this table out every night. Any other ideas? thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Reliability means ?
Do Standby Databases Database Replication come under the subject Reliability ? Yes, this would come under the topic of High Availability Heres a ppt that might give you some more ideas: http://www.darc.com/ncoaug/presentations/2001-summer/Bondra.ppt HTH Ed -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Folks We are looking to present a Talk on :- Reliability with respect to Oracle 9i DB How does one even approach this subject ? What Sub-Topics would this envisage other than the following ? 1) Oracle Architecture of Data Storage 2) Backup Recovery Do Standby Databases Database Replication come under the subject Reliability ? Using our Application Product we have Experience on Hybrid Oracle Databases in :- 1) High End Database Performance Benchmarks 2) Regular Database Recoveries from Block Corruptions , Crashes 3) Keeping Production Databases of sizes upto 1 TB working optimally . Do you believe we can give a Talk on the Subject Reliability ? The presentation might have in attendance some of the Leading Oracle minds . Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SqlServer and Oracle on the Same NT Box
I've got 9i and SqlServer 7 both running on XP on my laptop. Also very small with few transactions. Just for fooling around with. No problems so far. I'm only assuming that if it works on XP it'll work on NT though. -Original Message- Sent: Tuesday, January 21, 2003 8:19 AM To: Multiple recipients of list ORACLE-L All, Has anyone installed and run SqlServer and Oracle on the same NT box? I've heard mixed rumors that either you can or cannot do it. Both databases would be very small with very few transactions. thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 21, 2003 6:34 AM To: Multiple recipients of list ORACLE-L I would say that tora may be a little excessive for a regular user.. How about a simple php / jsp type interface? Of course, you would have to develop this yourself.. -Original Message- Sent: 21 January 2003 09:09 To: Multiple recipients of list ORACLE-L hi try this one, it's a freeware tool called Tora http://www.globecom.se/tora/ Freeware tool to browse data in Oracle tables? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SqlServer and Oracle on the Same NT Box
-Original Message- Sent: Tuesday, January 21, 2003 11:18 AM To: Sherman, Edward I probably should have mentioned the laptop has 1GHz processor and 512 MB ram. Single hard drive. Some i/o contention but not too bad. Also I'm not using network connections and local apps connecting to local SqlServer on the laptop kick the company NT server's butt. -Original Message- Sent: Tuesday, January 21, 2003 10:53 AM To: '[EMAIL PROTECTED]' I've got 9i and SqlServer 7 both running on XP on my laptop. Also very small with few transactions. Just for fooling around with. No problems so far. I'm only assuming that if it works on XP it'll work on NT though. -Original Message- Sent: Tuesday, January 21, 2003 8:19 AM To: Multiple recipients of list ORACLE-L All, Has anyone installed and run SqlServer and Oracle on the same NT box? I've heard mixed rumors that either you can or cannot do it. Both databases would be very small with very few transactions. thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 21, 2003 6:34 AM To: Multiple recipients of list ORACLE-L I would say that tora may be a little excessive for a regular user.. How about a simple php / jsp type interface? Of course, you would have to develop this yourself.. -Original Message- Sent: 21 January 2003 09:09 To: Multiple recipients of list ORACLE-L hi try this one, it's a freeware tool called Tora http://www.globecom.se/tora/ Freeware tool to browse data in Oracle tables? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-2289 - anyone?
From SQL*PLUS: select sequence_name from dba_sequences; Do the sequence names tt1462788_work_item_srl, tt1462788_tmp_asn_ship_srl, etc. show up in the list? Log in to SQL*PLUS using the same account that the biora8x.cpp app uses to run SQL statements. Are you able to create and drop sequences using that account? Are you able to drop and recreate the tt1462788_work_item_srl sequence from that account in SQL*PLUS? From what I can see so far it is probably a problem with privileges. -Original Message- Sent: Tuesday, January 21, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Let me try this one more time. We are running Oracle 8.1.7 and I received an ORA-2289 as indicated below. Does anyone out there think he/she might be able to help me? Or at least point me in the right direction. Thanks again. Saira -Original Message- Somani Sent: January 20, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hi all, I'm new at this game and am running into this Oracle error in our training environment. I have searched on the web and the archives but I am not sure about a resolution to this issue. Any comments/insights would be appreciated. After investigating the issue, I found that there is a crash when trying to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other temporary tables. Here are the errors: biora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_item_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_load_err_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470 Error code = 2289. Here is the description of the 2289 error: // *Cause: The specified sequence does not exist, or the user does // not have the required privilege to perform this operation. // *Action: Make sure the sequence name is correct, and that you have // the right to perform the desired operation on this sequence. CUNAME:cu4 STATUS:-255 NATERR:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HELP..URGENT....NOT
Title: Message Dave, Was it this one? You might be able to find what you need at this site. http://web.singnet.com.sg/~petermag/oracle.html Dave-Original Message-Sent: Tuesday, October 22, 2002 8:39 PMTo: Multiple recipients of list ORACLE-LSHi,Does anyone know of any web site that contains materials about performance tuning of SQL (oracle or any other database) ? TIARegds,New Bee -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 5:29 AMTo: Multiple recipients of list ORACLE-LSubject: HELP..URGENTNOTA while back I posted a link to a website that has hundreds of Oracle links. It's a site that is good for Unix and Windoze bigots, pick your flavor. Well, I lost my hard drive and my internet favorites. If anyone has that link that I posted I would greatly appreciate it if you can now post it cuz I cannot remember the name of it.ThanksDave--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Farnsworth, Dave INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Big Brother is Here
Hmmm... Microsoft has already put together a network of more than 100 FM radio stations in the U.S. to broadcast precise time information... http://support.microsoft.com/default.aspx?scid=kb;en-us;131109 -Original Message- Sent: Friday, January 10, 2003 1:46 PM To: Multiple recipients of list ORACLE-L OK, this is a little off topic, but if MicroSlop gets this to work, how long before OEM will have a link into the same technology?? I always thought that the computers were here to server us, not the other way around. Just what I need, an OEM job blowing and my having to fix it from the head!! Dick Goulet Microsoft eyes global radio network to support smart devices Microsoft plans to build a global FM radio network to support its Smart Personal Objects Technology efforts, embedding an FM receiver that works anywhere in the world. http://computerworld.com/newsletter/0%2C4902%2C77442%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1410 Silliness
Title: Message I found this in the Oracle Concepts manual. Since your table is partitioned I thought it might be worth a look. Queries and Partition Maintenance Operations Queries whose execution starts before invocation of a partition maintenance operation, or before dictionary updates are done during a partition maintenance operation, correctly access via Consistent Read the data of the affected partitions as existing at query snapshot time. Such queries either successfully complete returning all relevant data as present at snapshot time, or fail to complete returning error ORA-8103 or ORA-1410. The application should reissue the query if one of these errors is returned. Queries that use a partitioned index, and that start with some of the index partitions marked as INDEX UNUSABLE, return an error when they actually access one of these partitions for the first time. This happens even if the partition has been made USABLE after query start. Good luck Ed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't given a chance to improve on it. It is basically a mainframe file that I have stored history of.
RE:
ðÏÍÏÝØ! -Original Message- Sent: Wednesday, December 18, 2002 10:30 AM To: Multiple recipients of list ORACLE-L I thought, it was: ARE YOU AN IDIOT? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:04 AM Ok, I'll ask the obligatory 'Are you stupid?' Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 9:19 AM EDOUARD, EDOUARD, EDOUARD HELP! -Original Message- Sent: Wednesday, December 18, 2002 7:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGEST EDOUARD DORMIDONTOV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to script or document jobs defined to the NT/MS2000 T
Jt.exe Download here: http://www.jsiinc.com/subf/tip2600/rh2621.htm Or here: ftp://ftp.microsoft.com/reskit/. See the C:\jt /se p example near the bottom of the page. Also looks like you might be able to put all your tasks in a command file and execute to recover any lost jobs. (I haven't tried this yet...) HTH Ed -Original Message- Sent: Thursday, December 05, 2002 9:24 AM To: Multiple recipients of list ORACLE-L We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9iAS R2 printing Unix
-n2 to get two copies for HP-UX -#2 yields: lp: illegal option -- # -Original Message- Sent: Wednesday, November 13, 2002 2:24 PM To: Multiple recipients of list ORACLE-L A week or so ago I posted WRT having problems printing a report directly to a printer from 9iAS R2. I've been battling Oracle ever since to get this BUG resolved. AFAIK, the bug exists for at least Solaris, AIX HP. Since I only have been working with Solaris for the last 6+ years, I might benefit from those who have more current knowledge on other variation of Unix. One of Oracle scripts builds the actual command line using either the lp or the lpr command. What is now being constructed for my system includes -#1; which according to the comments in the scripts supposed to be the number of copies of the report to be printed. Is this a valid command line qualifier for any Unix supporting Oracle? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT ksh day of week yesterday
My TZ is EST5EDT and I think the 5 implies GMT-05:00 What does the 26 in EST26EDT imply? Just curious. Ed -Original Message- Sent: Wednesday, November 13, 2002 2:24 PM To: Multiple recipients of list ORACLE-L yesterday=$(TZ=EST26EDT date +%a) On Wed, 13 Nov 2002, Barbara Baker wrote: Will someone take pity on this poor VMS'er lost in a unix world?? I'm trying to create a script (ksh) that reads a log file created yesterday. The log files are created with `date +%a` appended to the end of the log file name. Last night a log file was created called arc_indexlog.Tue It's easy enough to get today TDAY=`date +%a` grep -i ora /orasrv/ops/maint/logs/arc_indexlog.$TDAY grep -i ora /orasrv/ops/maint/logs/adv_indexlog.$TDAY but how do I get yesterday in the same format? (i.e., Tue instead of Wed) I man'd date, but it was no help. Thanks for any help. Barb - Do you Yahoo!? U2 on LAUNCH - Exclusive medley videos from Greatest Hits CD -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10i features
Get thee to the SQL Server!!! -Original Message- Sent: Tuesday, November 12, 2002 11:34 AM To: Multiple recipients of list ORACLE-L MS Word as SQL editor? MS Excel as sqlplus? Outlook as Instance Manager? :-) On Tuesday 12 November 2002 15:58, you wrote: .NET? -Original Message- From: Boivin, Patrice J [mailto:BoivinP;mar.dfo-mpo.gc.ca] Sent: Tuesday, November 12, 2002 7:59 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 10i features Any rumours about what might be included in 10i? 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] -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Download Oracle 7.3.4
Oooo! I forgot about the SCO. I never tried it but I had read about it. Those were the days eh? -Original Message- Sent: Thursday, October 24, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on metalink for Linux! ;-) Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 23 October 2002 22:29 To: Multiple recipients of list ORACLE-L The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Download Oracle 7.3.4
The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: anydata datatype update help
I don't know squat about the ANYDATA type but I wonder if there is a restriction that you can only update an ANYDATA column with a new value of the same type. For example, if you initially put a '101' VARCHAR2 into the ANYDATA column and then attempted to update it to 102, where 102 is a NUMBER datatype it might fail whereas if you tried to update it to '102', where 102 is a VARCHAR2 then it might work. Could this be causing your dilemma? I notice there is a GETTYPENAME member function that will return the type name of AnyData: MEMBER FUNCTION GetTypeName( self IN AnyData) RETURN VARCHAR2; The function will return NUMBER, etc. (the type stored in the ANYDATA record) This would let you know what type is stored in the ANYDATA column for a particular row and you could Make sure your updating with the same type. Maybe do an explicit type conversion of the new value before using it with UPDATE. Just a shot in the dark. HTH Ed -Original Message- Sent: Friday, October 04, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH - Original Message - From: Rachel Carmichael [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 04 Oct 2002 05:33:23 the subject line pretty much describes it. 9.2.0.1, Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, coredump) when we try to update the ANYDATA column. Within a PL/SQL process, using aliased tablenames and bind variables for all values: UPDATE MI.T_IN03_ObjPrpty SET IN03_Value_AD = :b7 ,IN03_Seq_NO = :b6 ,RF01_Publisher_KY = :b5 ,IN03_Amend_DT = :b4 ,RF02_Status_KY = :b3 ,IN03_Status_DT = :b2 WHEREIN03_ObjPrpty_KY = :b1 IN03_Value_AD is the ANYDATA column. Statement works fine if we remove that column. Statement blows up if we remove all OTHER columns or if we run it as is. We've posted an iTAR and are waiting. I've searched MetaLink and the docs. Nothing useful. But the search of the docs left me with a suspicion that you can't update an ANYDATA column. Has anyone either successfully updated an ANYDATA column or found documentation somewhere that says you can't? this is stopping development on a critical system. I'm not the primary DBA on it, but the consultant DBA doesn't have access to MetaLink and isn't on this list so I'm helping out. Suggestions? Worst case I suppose we could delete the original row and insert the new one but that's kludgy and messy and an additional performance hit on a system that needs to fly like the wind. I'd rather fix this properly... of course Oracle is capable of saying that the delete and insert IS the workaround and/or standard procedure for this. Rachel Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: Initialzation of c:\winnt\system32\DLL user32.dll failed
First, try a simple reinstall of your current service pack. If that fails to solve the problem then see if this link applies: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q142676; Is another virus protect product running at the same time as TrendMicro server protect? If so then try shutting down the services for the other product. Good Luck, Ed -Original Message- Sent: Wednesday, September 25, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Hi DBAs, WinNT service pack 6. Oracle 8.1.6. On several of the servers I am getting Initialzation of c: \winnt\system32\DLL user32.dll failed. Notes on MetaLink are not applicable. The only thing added to these servers was TrendMicro server protect 5.31. I do not know if coincidence or cause. The error is intermittent. Has anyone else had this failure? If so please share any cause/resolution. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Space Contention and LOG_BUFFER size
I can't find it in the docs either. Info at ixora.com suggests setting LOG_BUFFER to a multiple of the log block size. http://www.ixora.com.au/tips/tuning/log_buffer_size.htm This next link explains what a log block size is: http://www.ixora.com.au/notes/log_block_size.htm Have fun! Ed -Original Message- Sent: Tuesday, July 30, 2002 1:19 PM To: Multiple recipients of list ORACLE-L I am doing some performance monitoring on an 8.1.7 DB on Windoze. I ran the following query; SQL select name,value 2 from v$sysstat 3 where name = 'redo log space requests'; NAME VALUE -- redo log space requests 27 If the number of 'redo log space requests' is much over zero then I should increase the LOG_BUFFER size in my init.ora, at least that is what I get from RTFM. One question I have is that does the size of the LOG_BUFFER parameter have to be a multiple of the DB_BLOCK_SIZE parameter? I vaguely remember that it shuold be but have not found anything in TFM to verify this. 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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cloning Problems
Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -Original Message- Sent: Monday, July 29, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Yeah, went through the standard cloning process. My first line of trace file looked like this... CREATE CONTROLFILE SET DATABASE DM8 RESETLOGS NOARCHIVELOG I am wondering if I should have stated NORESETLOGS here instead, that way the data in the redo logs would be available and then the cloned instance could have performed instance recovery. I have always used the method above and never had any problems but that is likely because I have always done a SHUTDOWN NORMAL instead of SHUTDOWN IMMEDIATE. While the SHUTDOWN immediate performs a checkpoint it looks like there can still be stuff out there in the logs that will require instance recovery. Since I did a RESETLOGS I am guessing this necessary info is missing. Wondering if everything will be OK if I try to find another way to get the clone opened, like setting the hidden allow corrupt logs parameter. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Did you recover the database using backup controlfile? Try that. HTH, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cloning Problems
I was looking in the docs :-) In Recovery Manager Users Guide and Reference they have a script to shut down the database for cold backup using RMAN. It starts out something like this: # Shut down the database cleanly using immediate priority. This type of shutdown lets # current calls to the database complete, but prevents further logons or calls. # If the database is not up now, you will get a message saying so but RMAN will not # treat this situation as an error. shutdown immediate; # Start up the database in case it crashed or was not shutdown cleanly prior to # starting this script. This will perform a crash recovery if it is needed. Oracle # uses the default INIT.ORA file. Alternatively, use this form: startup force dba # pfile=filename. Use the DBA option because you are going to shut down again right # away and do not want to let users in during the short interval. Use the FORCE # option because it cannot hurt and might help in certain situations. startup force dba; shutdown immediate; # Here, we know that the database is cleanly closed and is now ready for a cold # backup. RMAN requires that the database be started and mounted to perform a backup, # so do that now. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76990/usingrma.htm#435660 You'll need to use your OTN account to see the page. Also in the Glossary they define: clean shutdown: A database shut down with the IMMEDIATE, TRANSACTIONAL, or NORMAL options of the SHUTDOWN command. A database shut down cleanly does not require recovery; it is already in a consistent state. -Original Message- Sent: Monday, July 29, 2002 4:15 PM To: Multiple recipients of list ORACLE-L Shutdown immediate always worked for me with 8.1.6 and 8.1.7.0.0 on HP-UX 11.0. Shutdown abort's another matter entirely. -Original Message- Sent: Monday, July 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -Original Message- Sent: Monday, July 29, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Yeah, went through the standard cloning process. My first line of trace file looked like this... CREATE CONTROLFILE SET DATABASE DM8 RESETLOGS NOARCHIVELOG I am wondering if I should have stated NORESETLOGS here instead, that way the data in the redo logs would be available and then the cloned instance could have performed instance recovery. I have always used the method above and never had any problems but that is likely because I have always done a SHUTDOWN NORMAL instead of SHUTDOWN IMMEDIATE. While the SHUTDOWN immediate performs a checkpoint it looks like there can still be stuff out there in the logs that will require instance recovery. Since I did a RESETLOGS I am guessing this necessary info is missing. Wondering if everything will be OK if I try to find another way to get the clone opened, like setting the hidden allow corrupt logs parameter. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Did you recover the database using backup controlfile? Try that. HTH, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538
RE: Badge of Oracle8i OCP
Title: Message OCP Success Kit After successfully completing all exams in the OCP Track, you will receive an OCP Success Kit which includes: * Letter of Congratulations * Oracle Certified Professional Certificate * OCP ID Card * Oracle Technology Network Membership * Exclusive access to OCP Online Forum * Subscription to Oracle Magazine http://otn.oracle.com/training/certification/introduction_ocpds.html How to get assistance on issues with receiving your OCA, OCP, or OCM credential with Oracle Corporation http://www.oracle.com/education/certification/faq/index.html?faq10a.html -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 7:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you
RE: OTN discount for OCP exams
I took a test last Monday with promotion code OPP and got 30% off (cost $80.00 USD) Somebody mentioned it before on this list. Thank you whoever that was! -Original Message- Sent: Wednesday, July 17, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Anybody knows the OTN promotion for code for the Prometric OCP exam discounts. The discount should be 20%. Apparently one can get that from OTN - that what a representative from Oracle University told me - but you send an e-mail and you wait few days, which would like to avoid. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OTN discount for OCP exams
So _that's_ what OPP stands for! I registered online at http://www.2test.com I just put the promotion code in the little text box. Don't have to talk to anyone that way or answer questions. If its your first time online you might have to go through an annoying registration process though. OPP worked for me. Haven't gotten my credit card bill yet though :-) Cheers -Original Message- Sent: Wednesday, July 17, 2002 5:41 PM To: Multiple recipients of list ORACLE-L Thanks. I tried it but they, Prometric, asked me whether my company is the member of the Oracle Partner Program (which OPP stands for) :-( ? Djordje -Original Message- From: Sherman, Edward [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: OTN discount for OCP exams I took a test last Monday with promotion code OPP and got 30% off (cost $80.00 USD) Somebody mentioned it before on this list. Thank you whoever that was! -Original Message- Sent: Wednesday, July 17, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Anybody knows the OTN promotion for code for the Prometric OCP exam discounts. The discount should be 20%. Apparently one can get that from OTN - that what a representative from Oracle University told me - but you send an e-mail and you wait few days, which would like to avoid. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DOS Script for pop up question ?
I'm not a windows guy but I think you should quit writing DOS batch files and use VBScript instead. I think if you look in any windows magazine you will see VBScript listings instead of batch file listings. VBScript is powerful like Perl and handles pop up windows well. VBScript doesn't seem to email very well, however, because an earlier post I sent contained a simple VBScript demo in the body of the email and it got bounced from ORACLE-L because it contained a virus signature. So here's a link to some simple code you can try: http://www.devguru.com/Technologies/wsh/quickref/wshshell_Popup.html Save the code to a file with a .vbs extension and click the resulting icon. You can get a book or search the web for code snippets like I do. Have fun! Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 4:37 PM All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: download leads to sales call
I never got a call for downloading Oracle 9i but they called me for downloading Developer 6i and they even called me for downloading an ODBC driver. These calls came after about 6 weeks after downloading the products. They wanted to know what I was doing with Developer 6i and I told them I was just messing around with it and we use VB for everything here (which is true). They called about the ODBC driver to ask if it worked (it didn't) and I told them I didn't like the fact that I had to invoke Oracle Universal Installer to get the driver installed and the dang thing didn't work. I told them we have an M$ ODBC driver that installs more easily and it works and we're using that. Then they asked me what version of Oracle I'm using and was I planning to go to 9i (I think this is unrelated to the 9i download because the download was so long ago). I told them not yet and they asked if I would like someone to call me to help with the ODBC driver. I told them okay but nobody ever called to help. Still using the M$ ODBC here. By the way, the Oracle 9i download was for OCP upgrade, which I really should start working on... tomorrow... heh! -Original Message- Sent: Monday, July 08, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Hey Jonathan, I remember getting a call a long time ago. I basically told them I was a DBA and just wanted to mess around and learn the new features, etc. of Oracle. I guess they tagged me as such and have never called since. On the other hand, I guess if you said it was for project X, then they would be calling back... -Original Message- Sent: Monday, July 08, 2002 12:48 PM To: Multiple recipients of list ORACLE-L Last week I downloaded Oracle9i for Linux from Technet. Today I just got a call from an Oracle salesperson wanting to know what I was doing with it. I suppose it's not unreasonable for them to call and ask what I'm doing with their software, but is it normal procedure? I can't remember whether this happened last time I did a Technet download. Jonathan Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix - scheduling
Roland, I'm assuming that every 4 weeks means every 28 days which means same day of the week (Every 4th Friday for example) If this meets your requirements then you can try the suggestion at this link: http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1b397b8d1de3d5118ff40090279 cd0f9,00.html Read A. Clay Stephenson's solution to this. Click the little paper clip in the top right hand corner of his post. You will need that attachment to run with your script. Ed -Original Message- Sent: Tuesday, July 02, 2002 4:43 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: V$SQLAREA vs. V$SQLTEXT
Did you join these tables by HASH_VALUE to other tables (or to each other) and discover that quirky bug relating to the 32 bit arithmetic? HASH_VALUE in v$sqltext is signed whereas HASH_VALUE in v$sqlarea is unsigned. This can cause joins to fail. Check for negative HASH_VALUE in v$sqltext. http://www.jlcomp.demon.co.uk/lost_sql.html Good Luck, Ed -Original Message- Sent: Tuesday, June 18, 2002 12:21 PM To: Multiple recipients of list ORACLE-L Can a statement be in V$SQLAREA and not in V$SQLTEXT at the same time? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 move 200 GB db from prod to dev?
I have a similar situation and here's how I deal with it. (I'm assuming your datafiles have the same name but the pathname is different) Production: SID = PROD = e.g. /zbackup/array3/oracle8/dbs73/PROD/wds01.data.dbf Development: SID = WDSU = e.g. /extdisk/oracle8/dbs73/PROD/wds01.data.dbf In SQL*PLUS: SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Locate the trace file and copy it to the development machine. Move data with a script similar to this: rcp -rp /zbackup/oracle1/dbs73/PROD/* george:/extdisk/oracle1/dbs73/PROD rcp -rp /zbackup/oracle2/dbs73/PROD/* george:/extdisk/oracle2/dbs73/PROD . . . rcp -rp /zbackup/array3/oracle8/dbs73/PROD/* george:/extdisk/oracle8/dbs83/PROD Yes it's annoying but you only have to write the script once! Now you can edit that trace file while you wait for your data to finish moving: In my trace file I change the line: CREATE CONTROLFILE REUSE DATABASE PROD NORESETLOGS ARCHIVELOG to CREATE CONTROLFILE SET DATABASE WDSU RESETLOGS NOARCHIVELOG This changes the instance name (I'm not using log archiveing on the dev database). Now I have to edit all those pathnames. I have stuff like LOGFILE GROUP 1 ( '/oracle4/dbs73/PROD/redoPROD07a.log', '/oracle1/dbs73/PROD/redoPROD07b.log' Need to be changed to: '/extdisk/oracle4/dbs73/PROD/redoPROD07a.log', '/extdisk/oracle1/dbs73/PROD/redoPROD07b.log' Also, things like '/array3/oracle8/dbs73/PROD/wds01data.1.dbf', Needs to be changed to '/extdisk/oracle8/dbs73/PROD/wds01data.1.dbf', But its not really a problem if you can use the vi editor: Hit ESC key then :1,$s/\/oracle/\/extdisk\/oracle/g ENTER This changes all the /oracle to /extdisk/oracle This also has the side effect that all my /array3/oracle8 has changed to /array3/extdisk/oracle8. Need to get rid of the /array3 In vi, Hit ESC Key then :1,$s/\/array3//g Now all my paths are correct for the development database. At the bottom of the controlfile tracefile I comment out the lines: -- RECOVER DATABASE -- ALTER SYSTEM ARCHIVE LOG ALL Change ALTER DATABASE OPEN; to ALTER DATABASE OPEN RESETLOGS; Delete lines in the trace file from the first line until you get to the line that says: STARTUP NOMOUNT Also delete or comment out any lines with a # character as the first character. Delete my old control files and run the trace file from SQL*PLUS to create the new controlfiles and open the instance. The renaming of the paths was done in two steps with vi but you can write a shell script using sed to do the substitution for you if you like. Maybe annoying but you only have to write the script once! In your example you need to change PCLDB1 to ROLAND You bring up the trace file with the CREATE CONTROLFILE script in vi and just do: Hit ESC :1,$s/PCLDB1/ROLAND/g ENTER and PCLDB1 will be substituted for ROLAND everywhere in the file. If you want to write a script for this and are not familiar with sed then maybe the UNIX sysadmin or a UNIX developer can help you with this. After you get the scripts written then its really easy to move you data and get the instance running. It's only annoying the first time! Good luck, Ed -Original Message- Sent: Thursday, June 06, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Hi! We are supposed to clone our production database onto a new development box (both boxes are Sun Solaris). The db is about 200 GB in size. What would be the best way to achieve this? Simply copying over the files won't work, since the instance names are different: Production: SID=PCLDB1 = e.g. /u02/oradata/PCLDB1/system01.dbf Development: SID=ROLAND = e.g. /u02/oradata/ROLAND/system01.dbf So would export/import the entire db be the only way? (But writing out dump file that big should be a little disk space problem...) Renaming all the datafiles (approx. 100) would be kind of annoying... Any ideas? This is 8.1.7 on Sun Solaris. Thanks, Helmut * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: linux vs any other os
Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 successfully execute dmesg command from Oracle accou
/etc/dmesg: 'can't read kernel memory' - must be root http://welcome.hp-ww.com/country/img/arrows/a_ff9900.gifprintable http://support2.itrc.hp.com/service/cki/docDisplay.do?printable=truef_Pass word=beige02f_RememberMe=falseTargetPage=http://support2.itrc.hp.com/servi ce/cki/docDisplay.do?docId=20006454298docId=20006454298y=0x=0f_U serID=CA254010 version path: Home http://support2.itrc.hp.com/service/cki/enterService.do?category=c0 http://welcome.hp-ww.com/country/img/corners/tl_corner_10.gif http://welcome.hp-ww.com/country/img/corners/tr_corner_10.gif date:8/12/94 document description:/etc/dmesg: 'can't read kernel memory' - must be root document id: A3413700 http://welcome.hp-ww.com/country/img/corners/bl_corner_10.gif http://welcome.hp-ww.com/country/img/corners/br_corner_10.gif You may provide http://support2.itrc.hp.com/service/ciss/doLogin.do?TargetPage=http://suppo rt2.itrc.hp.com/service/cki/docDisplay.do?docId=20006454298#feedbackform feedback on this document _ Problem1Problem Description What does this error mean, from /etc/dmesg ? 'Can't read kernel memory' Solution2Solution You will get this message if you are not logged in as root when you run /etc/dmesg. Alternative3Alternative Keywords workstation dmesg -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, June 03, 2002 3:05 PM To: Multiple recipients of list ORACLE-L account?? Dear List, When I run dmesg command from oracle account on HP-UX 11.0, it responds as can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x. Could someone tell me what needs to be done in order to execute dmesg command successfully from oracle account. Thanks, --Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. a_ff9900.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tl_corner_10.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tr_corner_10.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. bl_corner_10.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. br_corner_10.gif Description: GIF image
RE: Wait time for SQL*Net message
* * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Presentation for Beginners!
Looks like she took away the permissions. I never took a class here. I stumbled on the site several months ago using the Google search engine with the search string Using Oracle Blocks Efficiently. Back then that site was the first one returned by Google. Sorry the links were so short lived. I never thought the presentation would go away so soon. Ed -Original Message- Sent: Thursday, May 09, 2002 3:41 PM To: Multiple recipients of list ORACLE-L You are not using the full url, check the next line for the rest of the url 01_files/v3_document.htm you need les01_files/v3_document.htm -Original Message- Sent: May 9, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Any one got this message? Forbidden You don't have permission to access /~melody/courses/Spring2002Backup/BackupPPTS/les on this server. --- Sherman, Edward [EMAIL PROTECTED] wrote: Here's the slides! SQL/PL-SQL http://www.ecst.csuchico.edu/~melody/courses/Spg2001OraclePLSQL/PLSQL8iPPTS/ Default.htm Architecture and Admin http://www.ecst.csuchico.edu/~melody/courses/Fall2001CSCI379/TOC.html Performance Tuning http://www.ecst.csuchico.edu/~melody/courses/Spring2002PerfTune/TOC.html Backup and Recovery http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/les 01_files/v3_document.htm http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/les 02_files/v3_document.htm http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/les 03_files/v3_document.htm And here's a gal after my own heart! http://www.ecst.csuchico.edu/~melody/ Thanks Melody!!! Ed -Original Message- Sent: Monday, May 06, 2002 5:09 AM To: Multiple recipients of list ORACLE-L Hello all, because I am an human being I am also looking for the easiest solution :-) So, I need to have a training session concerning basic oracle features. I wonder if anyone of you know place/site where I could download some powerpoint slides. Or if you have your own, pls. send me a copy ... Any help will be highly appreciated. Thanks km the lazy dba -- __ Ota itsellesi luotettava kotimainen email http://www.jippii.fi/ Tutustu samalla netin parhaaseen pelipaikkaan JIPPIIGAMESIIN. -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Joshua INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Oracle Presentation for Beginners!
Here's the slides! SQL/PL-SQL http://www.ecst.csuchico.edu/~melody/courses/Spg2001OraclePLSQL/PLSQL8iPPTS/ Default.htm Architecture and Admin http://www.ecst.csuchico.edu/~melody/courses/Fall2001CSCI379/TOC.html Performance Tuning http://www.ecst.csuchico.edu/~melody/courses/Spring2002PerfTune/TOC.html Backup and Recovery http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/les 01_files/v3_document.htm http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/les 02_files/v3_document.htm http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/les 03_files/v3_document.htm And here's a gal after my own heart! http://www.ecst.csuchico.edu/~melody/ Thanks Melody!!! Ed -Original Message- Sent: Monday, May 06, 2002 5:09 AM To: Multiple recipients of list ORACLE-L Hello all, because I am an human being I am also looking for the easiest solution :-) So, I need to have a training session concerning basic oracle features. I wonder if anyone of you know place/site where I could download some powerpoint slides. Or if you have your own, pls. send me a copy ... Any help will be highly appreciated. Thanks km the lazy dba -- __ Ota itsellesi luotettava kotimainen email http://www.jippii.fi/ Tutustu samalla netin parhaaseen pelipaikkaan JIPPIIGAMESIIN. -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cronjob
If you crontab -e and a job is scheduled to run during the time that you are editing, then the job doesn't execute while you are editing. No jobs will execute while you're in crontab -e. Even if you :w your changes. No cronjobs will execute while the editor is open so don't forget to close that editor when you finish. I learned this from experience (HP-UX) Final Answer! Just guessing though. Is that what you're lookin fer? -Original Message- Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway? ) Jared Alex [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: [EMAIL PROTECTED] wrote: Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland man crontab -- -- Bill Shrek Thater ORACLE DBA [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. Your e-mail has been returned due to insufficient voltage. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: WHICH UNIX FOR ORACLE?
HP-UX Stable, Do you like patches? SolarisPopular, Good for the resume. AIXNo experience with this, Is that really UNIX? Linux Free + You get coolness points. IMHO... of course! -Original Message- Sent: Thursday, April 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Might as well get my two cents in... :-) 1. Solaris Tied for 2... AIX, Tru64, HP/UX (leaving NUMA out of the equation for now. If you like NUMA, then look into the status of IBM's acquisition of Sequent, I'm out of touch with that right now.) Different hardware solutions from different vendors have different performance, stability and cost characteristics, and so I'll assume that all vendors have an appropriate solution on these factors, this may not be the case. With these assumptions, the primary factor for me is the timeliness of the availability of releases, patches and patchsets. Sun Solaris 32-bit is the winner on this factor on the grounds that it is Oracle's internal development platform. All other platforms are ported from Sun Solaris 32-bit. When that changes, my recommendation would of course also change, as it did when Oracle moved away from Digital/VMS. Anyone who has been in a situation where a bug was causing service failure and who heard that a patch was available for Solaris but not your platform knows where I'm coming from on this one. Note: for the exact same reason, never use 64-bit Oracle on Solaris unless you absolutely need the very-large-sga support. 64-bit Oracle on Solaris is slow to get patches and releases. Best, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:48 PM What are you planning..? A religious war..:) well..here is my 2 cents,IMHO 1. HP-UX 2. SOlaris 3. AIX in the order of preference. I have worked with all three and I found HP machines to be reliable and HP-UX easy to work with. This is not to say solaris is not but I had some nightmare stroies to tell about the bugs and quality of support from SUN. Again this is only my opinion and as everybody knows OS is ,to some extent ,a matter of personal choice also. ( Running to put on flame proof suit..:) ) Cheers, RS --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Database Query Tool
You might try Oracle's Query Builder product. It seems to be an upgraded version of the old Oracle Browser. Its part of the Developer 6i package. You can download Developer 6i at http:\\technet.oracle.com to see if you like it. They have one for NT but it seems to run well on Win95/98 and XP from what I can tell. Haven't tried it on NT yet :-) Good Luck, Ed __ _ = -o)/ / (_)__ __ __ | Ed Sherman | /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional | _\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation | | Tel: (407) 859-7410 x2708 | = -Original Message- Sent: Monday, February 25, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi, I was asked to recommend a Query Tool for some of our end users. I have used Q+E aka DataDirect Explorer for years. Now I can't find it on the internet. It has changed owners many times and may not even be available now. Does any one have a recommendation for a COTS product that allows the user with minimum knowledge of SQL to create SQL queries, views tables, store/recall queries, ... Is there an Oracle product that does that? Discoverer seems to be a bit heavy handed. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tns-12545
Some questions for you: What are you using to try to connect to Oracle? Are you trying to use SQL*PLUS or and application that uses ODBC? Is the user who can successfully connect on the same domain as you or different domain? Does you connection go through an oracle names server? Can you post an entry from the sqlnet.log file that shows what happens when the connection fails? For starters, back up your tnsnames.ora file, get a copy of the tnsnames.ora from machine that connects and copy to your machine and try to connect. (Never mind that your tnsnames is correct... just try it). Some machines can have multiple copies of tnsnames.ora. Make sure you got the right one. If the tnsnames has a hostname in the HOST= paramter then try using the IP address of the target machine instead. Example1.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = Production1) hostname (Port = 1521) ) ) (CONNECT_DATA = (SID = SID1) ) ) Example1.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 172.16.17.100) use IP address instead. (Port = 1521) ) ) (CONNECT_DATA = (SID = SID1) ) ) __ _ = -o)/ / (_)__ __ __ | Ed Sherman | /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional | _\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation | | Tel: (407) 859-7410 x2708 | = Supporter of the coalition for grumpiness where grumpiness is due -Original Message- Sent: Friday, December 14, 2001 9:20 PM To: Multiple recipients of list ORACLE-L hi, can anybody help me w/ this error: TNS-12545: Connect failed because target host or object does not exist this message pops up when i try to login into my nt database . i've already checked the tnsnames and the entry is correct. thanks. Best Regards, Grace Lim Suy Sing Comm'l Corp. (632)-2474134 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot Drop Column
, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Testing
It's vewy vewy quiyet. * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: Has anyone heard of Mirror Accessible?
Same here! I have an HP-UX upgrade and an Oracle upgrade over the holidays. It's been on the queue for more than a year. bye-bye Oracle 7.3.4 Woo Hoo __ _ = -o)/ / (_)__ __ __ | Ed Sherman | /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional | _\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation | | Tel: (407) 859-7410 x2708 | = Supporter of the coalition for grumpiness where grumpiness is due -Original Message- Sent: Wednesday, December 05, 2001 5:25 PM To: Multiple recipients of list ORACLE-L Ain't being a DBA glamorous??? Me, I'm just in it because I heard that DBA's get all the chicks :) Believe me, I feel your pain. I have more Oracle 7.3.4 databases here to upgrade than I can say without embarassment. That's what I get for being the new hire. :) A fellow DBA, Scott Lockhart Oracle DBA I-Link, Ltd. Draper, UT -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. application/ms-tnef
RE: Export question - appending date to dmp file
Try this: DUMPFILE=EXPDATA_$(date '+%m%d%Y%H%M').dmp echo $DUMPFILE should return something like: EXPDATA_120420011626.dmp Which means export started on Dec. 4, 2001 at 4:26 PM. do 'man date' to customize it further for your specific needs HTH Ed __ _ == -o)/ / (_)__ __ __ | Ed Sherman Oracle Certified Professional | /\\ /__/ / _ \/ // /\ \/ / | ECC International Corporation | _\_v __/_/_//_/\_,_/ /_/\_\ | Tel: (407) 859-7410 x2708 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] | == * * * Supporter of the coalition for grumpiness where grumpiness is due * * * -Original Message- Sent: Tuesday, December 04, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Yes, I agree, but I have a valid reason for doing this in this way.. any sugesstions.. Ramana - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Tuesday, December 04, 2001 12:01 PM RK - The system nicely timestamps the file automatically for you. Isn't that good enough? Another idea - on Unix, tar several files and it will keep the system timestamps on them. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Hello All, I am trying to append date to dmp file while exporting it , no luck any ideas.. exp userid=user/passwd imp file=EXPDATA$DATE.dmp (I need to have system date and if possible time (TIMESTAMP ) appended to it .) TIA Cheers RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Drop a Table
Thats cheating!!! :-) -Original Message- Sent: Tuesday, November 20, 2001 9:00 AM To: Multiple recipients of list ORACLE-L I got around it by using DBA Studio. Thanks, Ken -Original Message- Sent: Tuesday, November 20, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject:Re: How to Drop a Table Logon as a dba or as sysdba, then try to drop them. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 7:45 AM I am deleting the demo DB. First I dropped the tablespaces - USERS and TEMP. Now I want to drop the four tables. However, when I tried it I get an error that these tables do not exist. I guess I should have dropped the tables first then the tablespaces. So, how do I drop these tables? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: NT cmd file parameters
**SHIFT If you notice, you can only use 9 parameters: from %1 to %9. In most of cases this it more than enough. But, if you need to use more than 9 parameters in your program, you can use the order SHIFT. SHIFT makes the parameters lose their current value and will give them the value of the next numbered parameters. Quite confusing, I know. Lets see it. If you give the order SHIFT, %1 lose it's value and, from now, has second parameter as content. The same with %2, that now refers to the third parameter... and so on till the %9 parameter. Now, the %9 values the 10th parameter, that was unaccesible before. You can execute SHIFT as many times as you want. But note that the maximun DOS order width is 255 characters, so you don't make a program that needs 50 parameters because you won't be able to type all of them. http://users.110.net/~pq1801/gtmhh/ms2p2.htm See also: http://www.robvanderwoude.com/index.html HTH Ed -Original Message- Sent: Friday, November 16, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Hi! Maybe You can help me: One can call a cmd or bat file with parameters like example.cmd para parb parc and in this cmd file I can refer to them using %1 %2 %3 and so on My problem is following How can I get more than 9 parameters because when I use %10 in cmd file I get first passed parameter wth concatened 0 at the end, ie., para0 ? TIA Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ok..this is funny.. how do you pronounce tuple
yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4
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: Randy Kirkpatrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 day of the month unix
I was trying to form a similar solution but found it didn't work for Sept.
2001
on HP-UX. Your solution returns 29 on HP-UX Does it work on your UNIX
flavor?
-Original Message-
Sent: Monday, October 29, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L
Well, you can do date functions in Unix. The date function is date. It's
not normal, because Unix Commands are supposed to be cryptic.
But, you could do the following. You'll want to test it because no to Unii
are the same...
cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)
HTH,
Bambi.
-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
-- Sinard Xing [EMAIL PROTECTED]
Hi,
Is there any function that can display out last day of the month for
example
lastday(Oct,2001) return me 31
Or a variable that store this value.
Is Date an object in unix ?
Check the Date::Manip package. The simplest way is to check
for
UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Bellows, Bambi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 day of the month unix
cal 9 2001 | grep '[0-9]$' | awk '{print $NF}' | tail -1
(or whatever) ;-)
-Original Message-
Sent: Monday, October 29, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
I was trying to form a similar solution but found it didn't work for Sept.
2001
on HP-UX. Your solution returns 29 on HP-UX Does it work on your UNIX
flavor?
-Original Message-
Sent: Monday, October 29, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L
Well, you can do date functions in Unix. The date function is date. It's
not normal, because Unix Commands are supposed to be cryptic.
But, you could do the following. You'll want to test it because no to Unii
are the same...
cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)
HTH,
Bambi.
-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
-- Sinard Xing [EMAIL PROTECTED]
Hi,
Is there any function that can display out last day of the month for
example
lastday(Oct,2001) return me 31
Or a variable that store this value.
Is Date an object in unix ?
Check the Date::Manip package. The simplest way is to check
for
UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Bellows, Bambi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! !! tsiL siht ot cipoT ffO tsop ton od esaelP !! You can read this article to get some info: http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html Ed -Original Message- Sent: Thursday, September 13, 2001 6:15 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Anyone here tried to use those locally managed tablespace? Some DBA here persuade me to use the locally managed TS for the rollback segment,tables, indexes, temp tablespace Can you tell me what are the benefits of using the locally managed tablespace, any disadvantages? Thanks in advance. Chris Harvest. Creative Consulting. __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: STOP THE PRESS!!
They attack when they sense weakness. Lagging economy, dumb guy in charge. They never hit hard enough though. If its not a knockout punch then they're going down. Remember what happened after Pearl Harbor? -Original Message- Sent: Tuesday, September 11, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Looks like the Pentagon was also just bombed. Denise Gwinn [EMAIL PROTECTED] -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Scripts for Rebuilding Indexes Nightly on Solaris
Try the script at the bottom of the page at: http://www.revealnet.com/newsletter-v2/rebuild.htm http://www.revealnet.com/newsletter-v2/rebuild.htm It will find indexes that need rebuilding and generate a script containing the ALTER INDEX REBUILD statements for those indexes that need rebuilding. You can read the article while waiting for the script to complete ;-) HTH Ed -Original Message- Sent: Thursday, September 06, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Nightly? That is a lot. Are you really entering that much data on a daily basis? -Original Message- Sent: Thursday, September 06, 2001 8:57 AM To: Multiple recipients of list ORACLE-L Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that they'd be willing to share? Also, in your experience is it better to run this through UNIX cron jobs than using the Oracle OEM job scheduler? I suspect the cron job will be the favorable answer. Thanks in advance, David Wagoner Oracle DBA * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP-UX
information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent -- pipe import ???
Leslie, This is what works for me on Oracle 7.3.4.4 on HP-UX (zcat /extdisk/exp1/acc_per_06300200.dmp.Z \ /extdisk/exp1/export_pipe ); \ imp parfile=/extdisk/exp1/newpar.par Maybe you can try this if your Sun has zcat. I have never seen a pipe work for a while and then fail. I think it is probably not the pipe (unless you try to run two imports through the same pipe at the same time?). From what I can see your syntax appears okay (I didn't test it) and if it was working at the start of import then it should continue working until the import finishes. You saw correct import messages displayed before it hung? Are you sure the export was a good one with message Export terminated successfully without warnings. in the log file? Let us know how it goes. Ed -Original Message- Sent: Monday, August 13, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I sent this last Friday. Maybe not too many people check mail on Friday, so I send it again: For 815 on Sun5.6, I'm using pipe to import a 1G dmp.Z file, which can be uncompressed to a 9G dmp file: The directory I issue the following commands has 4G available: mknod /tmp/imp_pipe p uncompress arbor_minexp_20010726.dmp.Z /tmp/imp_pipe imp file=/tmp/imp_pipe parfile=imp.par The import worked fine for a little while and then stuck in a table with 1048 row, which is not big at all. It stuck there for more than 8 hours until I kill it. (The database is not archived.) Anything could be wrong? Should I do the uncompress arbor_minexp_20010726.dmp.Z /tmp/imp_pipe in a directory that has 9G free space??? Also I'm not familiar with pipe, could the pipe fail? Thanks a lot! Leslie __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
Mr. Peabody and Sherman? Of course. I was into Creepy Crawlers and Vac-U-Form back then but I'll bet you were more into Incredible Edibles or Fun Flowers. Cheers -Original Message- Sent: Thursday, August 02, 2001 2:12 PM To: Multiple recipients of list ORACLE-L Okay, who remembers Fractured Fairy Tales and the Professor and his boy Sherman? From: Farnsworth, Dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Thu, 02 Aug 2001 08:41:38 -0800 And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? Very nice!! I saw that all the time on my Saturdays watching Rocky and Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!! Dave -Original Message- Sent: Thursday, August 02, 2001 10:27 AM To: Multiple recipients of list ORACLE-L And the question (still yet to be properly answered) is How many licks does it take to get to the center of a Tootsie Pop? I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Plus Quick Reference
Somebody was asking about SQL*Plus quick reference a while ago. Not sure if it was this list or the other one. I think the best we could do was to find a quick ref. for Oracle 7. SQL*Plus quick reference is now available for 8.1.7 and 9i (9.0.1) For 8.1.7 go to http://tahiti.oracle.com/pls/tahiti/tahiti.homepage Then click on the word books in the sentence List of books, including PDF for printing in the top right portion of the page. Scroll down the page until you see SQL*Plus Quick Reference. Click on the PDF link at the right side of the page. For 9i go to http://tahiti.oracle.com/pls/db901/db901.homepage Then click on the word books in the sentence List of books, including PDF for printing in the top right portion of the page. Scroll down the page until you see SQL*Plus Quick Reference. Click on the PDF link at the right side of the page. Hope this helps somebody Ed * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER port issue
C:\winnt\system32\drivers\etc\services -Original Message- Sent: Tuesday, July 17, 2001 3:43 PM To: Multiple recipients of list ORACLE-L I want to know which file is equivalent in WIN2000 to /etc/services in unix. From: Rodd Holman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: LISTENER port issue Date: Tue, 17 Jul 2001 10:05:58 -0800 Need to change tnsnames.ora for aliases that reference that listener. If not using ONS, need to make this change on each client's tnsnames.ora also. Rodd Original Message On 7/17/01, 12:11:45 PM, Seema Singh [EMAIL PROTECTED] wrote regarding LISTENER port issue: Hi Gurus Normally the listener use 1521 port.I want to change other port like 1524.I make change on listener.ora file.Is is required to add entry 1524 into other file.If yes,then which file on WIN2000 OS. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Pocket Guide
If you have SQL*Plus help installed you can try this: SQL spool set_help.txt SQL help set SQL spool off SQL edit set_help.txt Also try SQL help commands -Original Message- Sent: Thursday, June 28, 2001 12:43 PM To: Multiple recipients of list ORACLE-L I'm more interested in the SQLPlus commands. Especially the various SET options. They are not intuitive (to me) and, since I only use them in SQLPlus they are not fresh in my memory. -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A Question on the Basics of PL/SQL
Get the PL/SQL Programming book by Oracle Press. Thats where I got the definitions below from. It also comes with a CD containing scripts which will populate database tables so you can try the examples in the book. Go nuts! -Original Message- Sent: Thursday, June 28, 2001 5:17 PM To: Multiple recipients of list ORACLE-L I am a bit confused as to when to use the following. I cannot seem to find any definitive rules. - function Functions are named PL/SQL blocks that return a value and can be called with arguments. They can be used as part of an expression. They are legal in procedural statements, and certain functions can be used in SQL statements in PL/SQL 2.1 and higher. Functions can be stored in the database with the CREATE [OR REPLACE] FUNCTION command, or they can be located in the declarative section of another block. - cursor Cursors are used to control the processing for queries that return more than one row. A cursor is declared using the CURSOR..IS syntax, then processed with OPEN, FETCH, and CLOSE. Cursor attributes are used to determine the current status of a cursor, with information about how many rows the cursor has returned, whether the cursor is open, and whether the last fetch was successful. - procedure Procedures can be stored in the database with the CREATE OR REPLACE PROCEDURE statement, or they can be declared in the declarative secion of a block. A procedure is a named block that can be called with parameters. The parameters can either accept a value from the calling environment (IN), return a value to the calling environment (OUT), or both (IN OUT). - package Packages are defined as two separate data dictionary objects--the package header (or specification) and the package body. The header is created with the CREATE OR REPLACE PACKAGE command, the body with the CREATE OR REPLACE PACKAGE BODY command. Packages must be stored in the database; they cannot be placed in the declarative section like procedures or functions. Packages themselves can contain procedures, functions, variables, types, cursors, and exceptions. Items declared in the package header will be visible outside the package, while items defined in only the package body will be private to the package. Packages also break the dependency chain because the package body can be recompiled without affecting the package specification. If someone can point me to a white paper, or whatever, that defines the rules for their usage I would be most thankful. Thanks, Ken Janusz, CPIM -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix/HP-UX report for disk balancing
You might try the cfg2html script It dumps the ioscan,bdf,lvdisplay,pvdisplay,etc. as well as a lot of other information about the machine, into an html file that you can view on your browser. It might be a quick way to get some documentation on your 60 machines. You can download it at: http://members.tripod.com/rose_swe/cfg/cfg.html Screen shot for a sample HP-UX machine is at: http://members.tripod.com/rose_swe/cfg/bsp/gurke9.html HTH Ed -Original Message- Sent: Wednesday, June 27, 2001 5:32 AM To: Multiple recipients of list ORACLE-L Hi all I have about 60 machines without any documentation at all, I want to get started on the hardware so I can then map on the database files. Does anyone no of a utility that will report on the disk architecture on the server that gives number of disks with there partitions and maybe other info like raid levels etc. Otherwise the only way I know is to use ioscan, df/bdf lvdisplay, vgdisplay etc. Cheers Simon ** COLT Telecommunications Registered in England No. 2452736 Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ Tel. 020 7390 3900 This message is subject to and does not create or vary any contractual relationship between COLT Telecommunications, its subsidiaries or affiliates (COLT) and you. Internet communications are not secure and therefore COLT does not accept legal responsibility for the contents of this message. Any view or opinions expressed are those of the author. The message is intended for the addressee only and its contents and any attached files are strictly confidential. If you have received it in error, please telephone the number above. Thank you. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adams, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: 24 x 7 on NT?
Been running since 1913. Cool! In 1919 E. 0. Carissan (1880-1925) built a factoring machine http://www.math.uwaterloo.ca/~shallit/Papers/carissan.html -Original Message- Sent: Wednesday, June 27, 2001 12:14 PM To: Multiple recipients of list ORACLE-L Come on get real.. Who has had a Unix box for 88 years? Unless of course the box in a satellite circling the earth and the crossing of the dateline constitutes a day ROR mª¿ªm [EMAIL PROTECTED] 06/26/01 03:18PM Here's my Unix box: # uptime 12:09 pm up 32,245 days, 1:01, 14543 users, load average: 120.19, 430.48, 3450.70 Here's my NT box: # uptime 12:09 pm up 1 days, 1:01, 1 users, load average: 0.019, 0.008, 0.00070 So, obviously, NT sucks. dusting off hands. -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wher is an error ?
Try putting a space between $userid and the = and the xxx in your if [ ] test. The shell is picky about where put the spaces. Try this stuff below (note I added the spaces in [ $userid = xxx ];) userid=xxy export userid echo $userid xxy if [ $userid = xxx ]; then echo 'aaa'; else echo 'bbb'; fi bbb -Original Message- Sent: Wednesday, June 27, 2001 7:46 PM To: Multiple recipients of list ORACLE-L Did you export userid? Hewlett-Packard Company 3000 Hanover Street Palo Alto, CA 94304 U.S.A. Rights for non-DOD U.S. Government Departments and Agencies are as set forth in FAR 52.227-19(c)(1,2). userid=xxy export userid echo $userid xxy if [ $userid=xxx ]; then echo 'aaa'; else echo 'bbb'; fi aaa --Chris [EMAIL PROTECTED] -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, June 27, 2001 6:50 PM To: Multiple recipients of list ORACLE-L 17:17:14:oracle8i@coin-app:/u07/export8i:ORUNDEF 513- userid=xxy 17:17:26:oracle8i@coin-app:/u07/export8i:ORUNDEF 514- if [ $userid=xxx ]; then echo 'aaa'; else echo 'bbb'; fi aaa 17:17:51:oracle8i@coin-app:/u07/export8i:ORUNDEF 515- why does it print aaa instead of bbb? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: 24 x 7 on NT?
Well, my UNIX box would probably run forever except that the DDS3 tape changer can't seem to last a whole year without breaking. Need to shut the machine down to replace the tape changer. I'm hoping to get lucky this year. Only 120 days till victory! # uptime 12:09 pm up 245 days, 1:01, 4 users, load average: 0.19, 0.48, 0.70 -Original Message- Sent: Tuesday, June 26, 2001 9:26 AM To: Multiple recipients of list ORACLE-L On Mon, 25 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I agree with His Chrisness on this one. - -If the avg(NT Admin) avg(Unix Admin), we'd -all be reading this mail on Window's boxes. -Er.what I mean to say is.. - -sly grin - -but, in all seriousnesswhen there is a way -to find a *very good* NT admin out of all the -Wendy's employees, then NT boxes will be up -4 or 5 nines, easy. - -Besides guys, five nines means you're down -about FIVE MINUTES a year. - -Now, how many of the Unix boxes on this list -have done that this year? I bet less than -one percent. well, then there must be a whole lot of unix boxes out there because we've got 40 of them right here. i'd say all of my 32 databases have been up that much too, but i've only had 25 of them up a whole year.;-) yup, i know i've been lucky. -- 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. ~~ Expert systems are built to embody the knowledge of human experts. - Kulawiec -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: 24 x 7 on NT?
It isn't monochrome anymore... Really! :-) http://www.themes.org/php/pic.phtml?src=shots/990462645.jpg -Original Message- Sent: Tuesday, June 26, 2001 6:12 PM To: Multiple recipients of list ORACLE-L Oooh...wow! Quick, maybe we should run out and convince 90% of the business world that their entire infrastructure is a complete and udder pipe dream and that the idea of trying to simplify our lives with the GUI is also just a big fat waste of time. Then everyone can get rid of their computers that have windows and Unix can take over the world. Yeah...archaic coding at a monochrome terminal..jeez the future looks so bright KK :) * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Testing - Pls ignore
This is a test. * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Applications Suite CDs.
Get ready for some mystery meat web page navigation. Go to http://www.oracle.com Click on the Oracle Store Button You should see a row of tabs near the top of the page. Click on the Applications tab. After the Applications tab is selected click on the CD Packs link (just under and to the left of the Applications tab). Now you should see a list of Financial Applications products. They are $39.95 each. I'm gussing you want Oracle Applications 11i (You choose the OS). You'll get a box of about 40 CDs. HTH Ed -Original Message- Sent: Thursday, May 24, 2001 2:52 PM To: Multiple recipients of list ORACLE-L I would like to know how to obtain a trial or developer version of the Oracle Applications Suite... : ) 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
