Re: Cache Object
NOT Hamid Alavi wrote: Hi All, I have a question regarding Cache Object in Memory, If I want to Cache a large data table in the memory i know it will much faster but what happen if server crash, in this case all modification on table will be gone or NOT. Any idea about cashing tables not only lookup tables realy appreciated. Hamid The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: Importing data from dump exported with different character set]
Brijesh Lal wrote: Hi The oracle version I am using is 8.15 and I am exporting the data into 8.1.6. When I try to import the data I get error that cannot that data cannot be imported as it is exported from database with USASCII7 and being impored into UTF8 format. Brijesh --- David A. Barbour [EMAIL PROTECTED] wrote: Brijesh, What are the Oracle versions you're exporting from and import into? UTF8 is a superset of US7ASCII, so you shouldn't be having problems. What error are you receiving? If you can't get it to work, can you redo the export? There are several ways to change character sets, which are documented on OTN and Metalink. Most involve changing the NLS_LANG for the session (import or export) but there was an interesting piece on editing the export file to change the reported character set last month on the list. Go to: http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274 for a précis on the procedure, and check out the various Metalink references. If you're going to edit the export file, you MUST use a binary editor. Brijesh Lal wrote: Hi All I have been given the task to export the data from the database which has the character set of USASCII7 and import it into Databse with UTF8 character. However when I try to this the import fails with error. I also searched oracle mannual but was unable to find any relevant information. Can anyone please tell me how to accomplish this task Thanks and Regards Brijesh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Importing data from dump exported with different character set
Brijesh, What are the Oracle versions you're exporting from and import into? UTF8 is a superset of US7ASCII, so you shouldn't be having problems. What error are you receiving? If you can't get it to work, can you redo the export? There are several ways to change character sets, which are documented on OTN and Metalink. Most involve changing the NLS_LANG for the session (import or export) but there was an interesting piece on editing the export file to change the reported character set last month on the list. Go to: http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274 for a précis on the procedure, and check out the various Metalink references. If you're going to edit the export file, you MUST use a binary editor. Brijesh Lal wrote: Hi All I have been given the task to export the data from the database which has the character set of USASCII7 and import it into Databse with UTF8 character. However when I try to this the import fails with error. I also searched oracle mannual but was unable to find any relevant information. Can anyone please tell me how to accomplish this task Thanks and Regards Brijesh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tivoli??
Actually ADSM is the backup software. They moved it over to the Tivoli brand last year and now call it their Data Protection product. Tivoli generally specializes in network management products, much like CA. See www.tivoli.com Regards, David A. Barbour C.S.Venkata Subramanian wrote: Tivoli is a backup software supplied by IBM. -- On Fri, 18 May 2001 08:45:47 Raghu Kota wrote: Hi Friends Could you people shed some light on tool Tivoli, Like what is functionality,purpose and more. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why I can not create temporary tablespace?
Robert, Check your syntax. CREATE TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' SIZE 50M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Regards, David A. Barbour Robert Chen wrote: hi, I connect as sys/change_on_install and execute this: create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M; Error at line 1: ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Please tell me why? I even change the directory to 777(anyone can read and write) still gotta this error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Security Functions
Miss yoga practice? Gogala, Mladen wrote: alter system electrocute user when an execution of [FUNCTION NAME] is attempted; -Original Message- Sent: Wednesday, May 16, 2001 4:17 PM To: Multiple recipients of list ORACLE-L How do I restrict access to functions? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: file output of a SP
Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your initSID.ora file to use the package which means you'll need to bounce the DB. Regards David A. Barbour Bunyamin K. Karadeniz wrote: Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, And in the procedure , how will I open a file and write to it and then close it ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Running remote scripts
Rajesh, You can't run interactive commands using rsh. You should be able to put all your commands into a script(s) and execute those. Otherwise try rlogin. Regards, David A. Barbour Rajesh Dayal wrote: Hi All, Env. is TRU64 Unix and Oracle 7.3.4 This is a standby server configuration. I want to run certain scripts(on secondary server), based on some incident on primary server. And on top of that, every thing has to be fully automated(using cron). I got stuck at a point where I need to run some script on secondary without explicitly logging on secondary server. I tried using rsh, but it executes just one single command. I would appreciate if some one can guide me on this. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Reporting tools
Dick, Go with Discoverer. As the admin, you can build a subset of the data and push it out to the power users with the data labeled any way you like. You can also give you power users the ability to create their own views if you are so inclined. They accomplish this through the GUI, with no 'direct' access to the database (of course they do, you need to set up their permissions etc., but you can lock it down pretty tight and what they're really creating is data about data which you can excise without harm to your DB at any time). Training is a snap, the interface is familiar and fairly intuitive, particularly for those with Access/Excel skills and experience. I used Discoverer for our Engineering teams to access Remedy (ugh!) data. Crystal Reports was the 'preferred' solution by the vendor, who wanted to send 20+ people to user training for a week to get them up to speed. The Discoverer solution was much simpler and more cost-effective for all involved. They were quite proud of their ability to create ad-hoc reports, and very lavish with their praise of the 'support' they were getting from the DBA! Regards, David A. Barbour Ruiz, Mary A (CAP, CDI) wrote: Hi Dick: I have a similar project on my plate. I like Business Objects. Actually, we do not want users to have to know table/column names and need a product where we can build a data repository. I am not sure if we need a complete end-to-end solution as many BI companies seem ready to provide. Other vendors on our short list are - Oracle (Discoverer), Cognos, Brio, Informatica (not sure if we need it) and Sagent (has a nice ETL product). Mary Ruiz /Atlanta -Original Message- Sent: Thursday, May 10, 2001 2:11 PM To: Multiple recipients of list ORACLE-L To ALL, I've been given a project to find a way to make data easily available to end users, preferably via a thin client (read that as browser based). We're looking at Discoverer 3000 and 9iAS, but the boss wants to know what other options are out there. The general idea would be to have a client/server based tool that we could deploy to the power users (of which we have only a few). These individuals are NOT programmers nor in the IS group, but they know the data. We want them to create the queries/reports (with graphics included which the Discoverer viewer does not do) and then publish them via the database. This is a lot of what Discoverer does, but are there other tools out there that do the same? Any recommendations??? Dick Goulet Senior Oracle DBA Vicor Corporation -- 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: Ruiz, Mary A (CAP, CDI) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL-procedures
Write a package. David A. Barbour [EMAIL PROTECTED] wrote: How can I write procedure which runs 3 different subprocedures.? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Taking your time when a crisis occurs
Eric, What's with you and Barbie? David A. Barbour Eric D. Pierce wrote: RE: Taking your time when a crisis occurs - http://www.amazon.com/exec/obidos/ASIN2/B4SU3E Barbie as Glinda from The Wizard of Oz Our Price: $19.99 Availability: Usually ships within 24 hours. Manufacturer's age: 3 years and up Shipping: Currently, item can be shipped only within the U.S. Shipping weight: 0.7 pounds. Note: Giftwrapping not available for this item. Packaging: This item may be delivered in the manufacturer's original packaging, which could reveal the contents of the box. ASIN: B4SU3E From Toysrus.com Amazon.com Editorial Review Are you a good witch or a bad witch? A good witch, of course--and pretty as well! Dressed as Glinda, the good witch of the North from the beloved book and movie The Wizard of Oz, Barbie is welcomed to Munchkinland. She has long, curly strawberry-blonde hair topped by a tall lavender-pink crown, and she's wearing a sparkling pink satin ball gown ornamented with silver stars and butterflies. She also has on a silver braided belt. Her outfit is completed with pink heels and a long, lavender magic wand that fits in her hand. Raise her arm (or press the button on her back), and you'll hear the wand's magical brrinnng! sound or Glinda's voice saying, Tap your heels together three times. Sound effects are produced by three included button cell batteries, which can be replaced. Say it again, Glinda, just so we'll never forget: There's no place like home. --Marcie Bovetz Safety Information Choking hazard: Small parts. Not for children under 3 years. - On 7 May 2001, at 10:21, Marianne Brooks wrote: Hmm, shaved head, why didn't I think of that? I would imagine a woman with a shaved head might be as effective...add a tatoo, some leather pants and a scowl and I've got a new me! :-) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: images question
Check out BLOBs. They're stored externally. Can be tough to work with but also can be very worthwhile. Regards, David A. Barbour Oracle DBA,OCP Casas, Claudia wrote: Do you recommend storing images in an oracle database or just storing the directory path to them instead. Somebody told me it would cause database fragmentation if I store images or binary data in databases?? --Claudia Casas- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casas, Claudia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: E-mail from Alert Logs
Siv, Check out all the email tools available at: http://www.freedownloadscenter.com/Email_Tools/ Regards, David A. Barbour Oracle DBA, OCP Siv Chelakkara wrote: Bunyamin, Would you please send a copy of the attachment directly to me, since the list does not allow binary attachments. Or if there is a URL where I can download or get more info, please e-mail that URL to the list. Thanks, Sivaram Bunyamin K.Karadeniz [EMAIL PROTECTED] 05/03/01 09:51AM There is a program (AUTOMAIL) which sends an email to anyone you idntify when there is a change in a file. Look at it . It is attached . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:00 PM Hi List Is there any way of receiving an e-mail or sms , whenever a ORA- error appears in the Oracle Alert Log, or when something unexpected happens to the Oracle Instance ? TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Siv Chelakkara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: please help
Jared, I think you hit the nail on the head when you said Best practice of course is to make a backup of your database in it's current condition prior to restoring it. Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see Training a DBA by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FILE SYSTEM BUFFER IN JFS : ON OR OFF
What flavor of UNIX and what type of storage are you considering? Regards, David A. Barbour Raj Sakthi wrote: Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and particular attension is being given to filesystem configuration and IO . I got this from one supposedly top notch Unix performance tuning expert . I would like to know if anybody implemeted this and what are the impacts . The options you want are mount options available only with Online JFS (not a free product, unfortunately.) The options you want are: RBS TEMP files : mincache=dsync, convosync=dsync DATAFILES REDO files : mincache=direct, convosync=direct TIA regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: How to Automate Procedure Execution
dba_jobsLists all the jobs in the database. user_jobs Lists all jobs owned by the user. dab_jobs_running Lists all jobs in the database that are currently running (join with V$LOCK to identify jobs that have locks). Hope this helps. David A. Barbour Oracle DBA, OCP abdul latif wrote: Raj, Which view do you use to view dbms_jobs? tia --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Yes, I have used with very good success it's all documented in T(ht) F(ine) M(anual). Or just open up $ORACLE_HOME/rdbms/admin/dbmsjob.sql ... this file itself is pretty good at explaining things. HTH Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: abdul latif INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: date format ?
Mohammed, Just off the top of my head, I don't think this will work unless you bring the day, month and year in separately. At first glance I thought perhaps if you took the length of the date string (less than 6 or more than eight you've got an error), backed out the last four as the year - so far so good, but the day/month is a problem. How would you evaluate '212' - as 2 December or 21 February? Regards, David A. Barbour Oracle DBA, OCP MOHAMMAD AMER wrote: hi oracle gurus, my client is very weird,he wants to enter the date in the format 'dd-mm-' without pressing space instead of delimiters,e.g. he presses '991999' and wants oracle to change it to '09-09-1999' .!!! Can I do it for him? If anyone knows how,I'll be very grateful. stucked with date formats Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PLEASE HELP !
Andrea, Build one database with different schemas for each user. When they log in, they'll only have access to their own data. You'll have to decide whether to use UNIX or NT depending on a variety of factors, but if you have the available resources, I'd go with UNIX (multiple users performing multiple tasks). Regards, David A. Barbour Oracle DBA, OCP Andrea Oracle wrote: Hi all, Our trainer needs to build training database/s, she is asking the following questions: 1. use Sybase or Oracle as the database server? We have some projects using Sybase databases, and old training database is on Sybase. 2. build the database on Unix vs NT platform? 3. She wants each trainee has his/her own database(!!!), since she doesn't want one use to see other user's data. And she said in Sybase it's really easy to do this, she has a script that can create multiple databases. Is it doable (please give some tip or script), or is it necessary ??? Any idea will be greatly appreciated!!! Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trace file does not reside in user_dump_dest. Why ?
Chor Ling, Go to the /dg1/oracle/niecomn/admin directory and run ls -al. If you see an arrow pointing to a directory description /dg1/oracle/nieora/8.1.6/rdbms/log, then it is a link. Regards, David A. BArbour Oracle DBA, OCP CHAN Chor Ling Catherine (CSC) wrote: Hi David, How do I know whether the udump directory is a link to the nieora/8.1.6/rdbms/log directory? My OS is Unix I am pretty new to Unix. Any advice ? TIA Regds, Chorling -Original Message- From: David A. Barbour [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:41 PM To: Multiple recipients of list ORACLE-L Subject:Re: Trace file does not reside in user_dump_dest. Why ? Catherine, Just a WAG, but could the udump directory be a link to the nieora/8.1.6/rdbms/log directory? David A. Barbour Oracle DBA, OCP CHAN Chor Ling Catherine (CSC) wrote: Hi Ed, SQL select name, value 2 from v$parameter 3 where name like '%user_dump%'; NAME VALUE user_dump_dest /dg1/oracle/niecomn/admin/udump The user_dump_dest is /dg1/oracle/niecomn/admin/udump but the trace file is dumped into another directory /dg1/oracle/nieora/8.1.6/rdbms/log. The unix permission for /dg1/oracle/niecomn/admin/udump /dg1/oracle/nieora/8.1.6/rdbms/log is the same. I just don't understand why the trace file is not located in user_dump_dest. Puzzled, New bee -Original Message- From: Shevtsov, Eduard [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Trace file does not reside in user_dump_dest. Why ? Hi have you got unix permissions to write to this directory? Try to logon as oracle owner and check it by writing any small file there. Also look at the output of the query select name, value from v$parameter where name like '%user_dump%'; It will show your actual user dump directory HTH Ed Hi, I forget to mention that when I show parameter dest* in server manager , the user_dump_dest is pointing to the right directory /dg1/oracle/niecomn/admin/udump. My earlier email : I issue the command alter database backup controlfile to trace, expecting my trace file to reside in the user_dump_dest directory. connect / as sysdba; startup pfile=/dg1/oracle/nieora/8.1.6/dbs/initNIE.ora In the startup file, User_dump_dest = /dg1/oracle/niecomn/admin/udump However, the trace file resides in another directory /dg1/oracle/nieora/8.1.6/rdbms/log. I am very... very puzzled. Could the gurus explain this phenomenon ? Thanks
Re: Please Advice on Performance Tuning
NJ, For each SQL statement in each instance, run a trace, then run tkprof against it with the explain option. When you compare the two, it should tell you what they are doing differently and what you're biggest time waster is. Regards, David A. Barbour Oracle DBA, OCP N J Neog wrote: Hi all, We have got a Payroll Application develeoped in-house. It takes 30-34 Minutes to Run this Batch Application. General feeling is - it should be able to process it within 10-15 Minutes may be less than that. I am to look into this problem and give a solution to it. Steps I had followed as 1. Import the payroll user to another Oracle User in the same database. 2. Removed unnecessary Index , Put parallelism into few tables by Alter table tab1 Parallel(DEGREE 5) 3. Analyze the tables with compute statistics; 4. Run the payroll without checking any inefficient SQL or wrong programming logic in the those Packages( It has only two Package in it no other stand alone Procedure or function). Payroll under this new Oracle User runs in 22-24 Minutes, 6-9 Minutes less. So, I asked Payroll Person to remove those unnecessary Index, asked him to put parallelism into those tables which I had done. He runs the Payroll with no Improvement at all. I asked again to drop those table and recreate it with new storage parameter same as the one created at New User. Still no visible Improvement. At this stage every table in both user has same storage parameter,same index ,and also analyzed. The question is why in One User it runs in 22-24 Min and in another 30-34 Min ? Now Please advice me what do I check or to do, so that the it time takes to run comes down to 22-24 Min, same as the new user. Oracle 8.1.4 Optimize goal : choose Biggest table haiving record less than 6 rows. Thanks in Advance Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Please Advice on Performance Tuning
NJ, From what you've outlined here, everything should be the same except in creating the new user, did you use import/export on the tables? If you did, then I'd check to see if row chaining might not be a problem. Have you tried forcing the application to use rule-based optimizer and seeing if you get different results? Regards, David A. BArbour Oracle DBA, OCP N J Neog wrote: Hi David, Thanks for your suggestion. I thought TRACE,TKPROF, EXPAIN PLAN will be the last thing thing I will do. Because There may be lot of SQL Statement I have to select from these two Package for probable degradation. Moreover in both user same two package was recompiled. If inefficient SQL are there in Package then it is there in both schema, so if in one user takes 22-24 Min. then the same should happen in other user also or otherway round. The question is what to check for the degradation ? To add to it. Our Oracle Server is in RAID. Both Schema does not have any auditing or Profile (Except default) Thanks once again. Regards. NJN. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:55 AM NJ, For each SQL statement in each instance, run a trace, then run tkprof against it with the explain option. When you compare the two, it should tell you what they are doing differently and what you're biggest time waster is. Regards, David A. Barbour Oracle DBA, OCP N J Neog wrote: Hi all, We have got a Payroll Application develeoped in-house. It takes 30-34 Minutes to Run this Batch Application. General feeling is - it should be able to process it within 10-15 Minutes may be less than that. I am to look into this problem and give a solution to it. Steps I had followed as 1. Import the payroll user to another Oracle User in the same database. 2. Removed unnecessary Index , Put parallelism into few tables by Alter table tab1 Parallel(DEGREE 5) 3. Analyze the tables with compute statistics; 4. Run the payroll without checking any inefficient SQL or wrong programming logic in the those Packages( It has only two Package in it no other stand alone Procedure or function). Payroll under this new Oracle User runs in 22-24 Minutes, 6-9 Minutes less. So, I asked Payroll Person to remove those unnecessary Index, asked him to put parallelism into those tables which I had done. He runs the Payroll with no Improvement at all. I asked again to drop those table and recreate it with new storage parameter same as the one created at New User. Still no visible Improvement. At this stage every table in both user has same storage parameter,same index ,and also analyzed. The question is why in One User it runs in 22-24 Min and in another 30-34 Min ? Now Please advice me what do I check or to do, so that the it time takes to run comes down to 22-24 Min, same as the new user. Oracle 8.1.4 Optimize goal : choose Biggest table haiving record less than 6 rows. Thanks in Advance Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
Re: Trace file does not reside in user_dump_dest. Why ?
Catherine, Just a WAG, but could the udump directory be a link to the nieora/8.1.6/rdbms/log directory? David A. Barbour Oracle DBA, OCP CHAN Chor Ling Catherine (CSC) wrote: Hi Ed, SQL select name, value 2 from v$parameter 3 where name like '%user_dump%'; NAME VALUE user_dump_dest /dg1/oracle/niecomn/admin/udump The user_dump_dest is /dg1/oracle/niecomn/admin/udump but the trace file is dumped into another directory /dg1/oracle/nieora/8.1.6/rdbms/log. The unix permission for /dg1/oracle/niecomn/admin/udump /dg1/oracle/nieora/8.1.6/rdbms/log is the same. I just don't understand why the trace file is not located in user_dump_dest. Puzzled, New bee -Original Message- From: Shevtsov, Eduard [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Trace file does not reside in user_dump_dest. Why ? Hi have you got unix permissions to write to this directory? Try to logon as oracle owner and check it by writing any small file there. Also look at the output of the query select name, value from v$parameter where name like '%user_dump%'; It will show your actual user dump directory HTH Ed Hi, I forget to mention that when I show parameter dest* in server manager , the user_dump_dest is pointing to the right directory /dg1/oracle/niecomn/admin/udump. My earlier email : I issue the command alter database backup controlfile to trace, expecting my trace file to reside in the user_dump_dest directory. connect / as sysdba; startup pfile=/dg1/oracle/nieora/8.1.6/dbs/initNIE.ora In the startup file, User_dump_dest = /dg1/oracle/niecomn/admin/udump However, the trace file resides in another directory /dg1/oracle/nieora/8.1.6/rdbms/log. I am very... very puzzled. Could the gurus explain this phenomenon ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego
UTL_FILE error
Morning all,
I've got a problem with the UTL_FILE package on a 7.3.4 database. The
UTL_FILE_DIR initialization parameter is set to *. I define my
filespecs as follows:
file_one UTL_FILE.FILE_TYPE;
BEGIN
file_one:= UTL_FILE.FOPEN('/oracle/P01','Jul_Dec96.csv','W');
The file gets created okay:
grendel:orap01 ls -al *.csv
-rw-r--r-- 1 orap01 dba0 Apr 27 11:18 Jul_Dec96.csv
I perform some selects and various data stuff then I go to add a
line(output severely reduced for testing purposes):
UTL_FILE.PUT_LINE(file_one,v_zcoanum);
I get :
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.UTL_FILE, line 87
ORA-06512: at SYS.UTL_FILE, line 218
ORA-06512: at SAPR3.COAPRODX3, line 123
ORA-06512: at line 1
The variable v_zcoanum is ALWAYS present - DBMS_OUTPUT.PUT_LINE shows it
just fine. I've bounced the instance, re-run the utlfile.sql, and tried
changing target directories. I've even tried a PUTF -
UTL_FILE.PUTF(file_one,'%s', v_zcoanum); but get the same type of
errors:
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.UTL_FILE, line 87
ORA-06512: at SYS.UTL_FILE, line 188
ORA-06512: at SYS.UTL_FILE, line 273
ORA-06512: at SYS.UTL_FILE, line 299
ORA-06512: at SAPR3.COAPRODX3, line 123
ORA-06512: at line 1
I'm wondering if I need to re-run catproc.sql? This same procedure
works on a test instance on a different box (same O/S, same
initSID.ora). Generally I'd see these types of errors when the
UTL_FILE package isn't installed or there are too many open file handles
tried to eliminate this by bouncing the instance). Does anybody have a
clue here?
Thanks,
David A. Barbour
Oracle DBA, OCP (Obviously not a path to enlightenment)
Worn to a frazzle staring at my own code and out of ideas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David A. Barbour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQLLDR - whitespace (tab space) problem
Helen, You can use the optionally parameter to specify multiple enclosed by/terminated by parameters. NULLIF is also available to assist in loading blanks. Regards, David A. Barbour Oracle DBA, OCP Helen Zhung wrote: Hello: I'm new to SQL Loader. Is there a way to code in control file that can separate 'a tab' and 'a blank space' ? I use FIELDS TERMINATED BY WHITESPACE, but it will TERMINATE a field when there is a space or a tab. However, the data fields were separated only by the tab, not 'a space'. Is it possible to identify the two? Thanks -- Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UTL_FILE error
Thanks IAN,
It confirmed what I already expected - it's a write error. I can't
figure out why though. This directory is owned by the oracle user. It
creates the file, but the refuses to write to it! I've changed the
specification to 'A and given /oracle and /P01 full permissions.
Touched the file and chmod 777 the file. Still the error.
Reran catproc.sql (I'm really out there now). If I execute the sql
statement: select osuser from v$session where audsid =
userenv('sessionid'); I get orap01, which should be the right guy.
Searched Metalink (response time isn't bad right now) with no luck.
This is on AIX 4.2.1 with which I used to pride myself on having some
sort of familiarity. Pride goeth before a fall.
Any other ideas?
David A. Barbour
Oracle DBA, OCP(and still searching for enlightenment)
This is
MacGregor, Ian A. wrote:
You need to handle the exception, for example
Exception
When no_data_found then
dbms_output.put_line ('no data found');
When utl_file.internal_error then
dbms_output.put_line('internal error');
When utl_file.invalid_filehandle then
dbms_output.put_line('invalid filehandle');
when utl_file.invalid_mode then
dbms_output.put_line('invalid mode');
when utl_file.invalid_operation then
dbms_output.put_line('invalid operation');
when utl_file.invalid_path then
dbms_output.put_line('invalid path');
when utl_file.read_error then
dbms_output.put_line('read error');
when utl_file.write_error then
dbms_output.put_line('write error');
when value_error then
dbms_output.put_line('value error');
when others then
dbms_output.put_line('unspecified exception raised');
--
Setting the utl_file parameter to * is a dangerous thing to do. It allows writes to
any file to which Oracle can write.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, April 27, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Morning all,
I've got a problem with the UTL_FILE package on a 7.3.4 database. The
UTL_FILE_DIR initialization parameter is set to *. I define my
filespecs as follows:
file_one UTL_FILE.FILE_TYPE;
BEGIN
file_one:= UTL_FILE.FOPEN('/oracle/P01','Jul_Dec96.csv','W');
The file gets created okay:
grendel:orap01 ls -al *.csv
-rw-r--r-- 1 orap01 dba0 Apr 27 11:18 Jul_Dec96.csv
I perform some selects and various data stuff then I go to add a
line(output severely reduced for testing purposes):
UTL_FILE.PUT_LINE(file_one,v_zcoanum);
I get :
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.UTL_FILE, line 87
ORA-06512: at SYS.UTL_FILE, line 218
ORA-06512: at SAPR3.COAPRODX3, line 123
ORA-06512: at line 1
The variable v_zcoanum is ALWAYS present - DBMS_OUTPUT.PUT_LINE shows it
just fine. I've bounced the instance, re-run the utlfile.sql, and tried
changing target directories. I've even tried a PUTF -
UTL_FILE.PUTF(file_one,'%s', v_zcoanum); but get the same type of
errors:
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.UTL_FILE, line 87
ORA-06512: at SYS.UTL_FILE, line 188
ORA-06512: at SYS.UTL_FILE, line 273
ORA-06512: at SYS.UTL_FILE, line 299
ORA-06512: at SAPR3.COAPRODX3, line 123
ORA-06512: at line 1
I'm wondering if I need to re-run catproc.sql? This same procedure
works on a test instance on a different box (same O/S, same
initSID.ora). Generally I'd see these types of errors when the
UTL_FILE package isn't installed or there are too many open file handles
tried to eliminate this by bouncing the instance). Does anybody have a
clue here?
Thanks,
David A. Barbour
Oracle DBA, OCP (Obviously not a path to enlightenment)
Worn to a frazzle staring at my own code and out of ideas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David A. Barbour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Re: Problems with hot backup via BCV's...
Jim, Don't know if this applies in your case, but a couple of years ago I had similar problems with hot backups on AIX. It seems that if the initialization parameter log_archive_buffers was set to anything higher than 1, I had the possibility of getting Fuzzy SCNs (they didn't call it that, they called it corrupted SCNs). There was supposed to be a patch (has to do with the AIX implementation of AIO), but I never saw it, never changed this parameter back, and haven't had any problems since. Regards, David A. Barbour Oracle DBA, OCP (still seeking the one true path) Jim Hawkins wrote: List, Oracle 8.0.4.3.0 AIX 4.3.3 EMC Symmetrix SAPR/3 4.0B 200,000+ transactions/day; 300GB database. Here's what we do: 1. Put all tablespaces in hot backup mode. 2. Split/Sync mirror. 3. Take tablespaces out of hot backup mode (usually after only 3-5 minutes). 4. Take BCV backup of this mirror. Problem is, when restored, sometimes the database can be opened resetlogs, and sometimes it can't. When it opens, we just apply all archive logs generated during steps 1 through 3, then open resetlogs and it works fine. The other half of the time, Oracle complains that the system datafile still needs more recovery. You can keep applying logs and it will never open. Oracle had me take header dumps to check for fuzzy SCN's, which these do appear to have. Oracle says this is a bad backup set even though EMC thinks it was fine. By the way, fuzzy SCN's are SCN's that have a hex value that evaluates to a nonnumeric, nonsensical number. Was wondering if anyone else was having issues with hot BCV backups and restoring them. We are current in terms of EMC TimeFinder and other software. It just seems to be hit or miss with these backups (obviously we take other backups too, but these are the easiest and most timely). Thanks, Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UTL_FILE Problem Solved
Thanks for the input Ian, I figured out the problem which really involved how I was logging into the database. There was a note on Metalink where somebody was having the same problem I was experiencing - the file would be created, but either nothing would be written, or you'd get a write error. The difference was that they were executing their procedure via a dblink and got the problem fixed when they replaced and restarted their listener. Thinking through this, I realized that this particular database had been installed by a contractor who started everything as the SAP admin user, and not as the Oracle user who owns the database and the listener. ps -ef showed all the core oracle processes(pmon, smon, dbwr, etc.) were owned by p01adm. So I switched to that user, went to the Oracle bin directory and started sqlplus from there, again not as the UNIX Oracle user, but as the UNIX SAP user. Logged in as normal, and voila - it works. Seems UTL_FILE picks up permissions/groups from the UNIX user that either started the database or started the listener. Hard won knowledge, but hopefully it will save somebody else the pain I've been through the last several hours. Hope everyone has a great weekend. David A. Barbour Oracle DBA, OCP (feeling a little lighter as I trod the path) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ftp
Roland, Are we not in just a little bit over our heads here? You don't say what you environment(s) is (are) but in UNIX, there are a couple of ways to do this. They depend on the security you have set up on each system and whether or not the source system has Oracle installed. I'm guessing PERL isn't an option here. If you actually have to go get the file, then you'll need to execute a shell script (you might also be able to use the oragetfile function). It may be more advantageous to have the source system ftp the file to the target (again, a shell script either on the source or the target will probably be required). If you just need to read the file, you can use the UTL_FILE package. In any case, you might have to set permissions, change initialization parameters, create database links, create synonyms, create users (both O/S an/or Oracle), and allow host access before any solution will be possible. Why don't you get a logon to OTN ( http://otn.oracle.com/index.html ) and do some research They also have some dandy examples. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: How can I write a PL/SQL procedur that connects to a ftp server and then gets a file from the unixsystem? Give an example, please. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cdump, bdump, udump
Sinardy, Some logs are generated by default (alert_SID.log) but actions triggering entries can be adjusted through either initialization parameters in the initSID.ora file, via commands issued by the DBA, or by users who have been granted specific privileges/roles (commands like ALTER DATABASE, ALTER SESSION and the dbms_trace package come to mind here). If you were able to get the doc on OFA, you now need to go and get the docs on Initialization Parameters and Oracle Supplied Packages as a minimum. Regards, David A. Barbour Oracle DBA Sinardy Xing wrote: Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MTSCost based Optimzer
If you have the time and horsepower, analyze the database. If not, wait until somebody complains and run a trace/tkprof against their SQL. You may want to consider using histograms on selected tables. There was a discussion on using histograms earlier this month. Steve Adams wrote a script to help in identifying possible candidates for histogram creation. It's on his web site at: http://www.ixora.com.au/scripts/query_opt.htm#consider_histogram Be judicious with its use. In general, I've found it useful to consider running an analysis of large tables used frequently in the select and where clauses of SQL statements. Regards, David A. Barbour Oracle DBA Deepender Kr Gupta wrote: How would you decide that out of total big and small tables (say 1500) these are the tables need to be analysed and these are not, as in our case Transaction types are both OLTP and DSS ?? -Original Message- Carmichael Sent: Tuesday, April 24, 2001 6:46 PM To: Multiple recipients of list ORACLE-L turning on cost-based is easy: set the optimizer_mode parameter to choose in your init.ora, stop and start your database and then analyze all your tables. HOWEVER (and this is a biggie) this will not automatically make all your queries run faster. You will need to examine each and every query to see if it needs to be rewritten to take advantage of CBO. In fact, sometimes there are queries that run faster in rule-based, and I have had to include hints in queries to force the optimizer to run rule. From: Venkat_Kalepalli [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: MTSCost based Optimzer Date: Tue, 24 Apr 2001 02:25:25 -0800 Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA. _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MTS and Cost Based Analyzer
Why would you be looking to change/implement something if you're not aware of the advantages/disadvantages? Changing to the cost based optimizer requires that both the DBA(s) and the Developer(s) understand how and why it works. Although a simple change to your initSID.ora file (yet another reference to that pesky animal) will enable cost based optimization, you'll probably need to set up some maintenance tasks (table/schema/database analysis comes to mind) and review slow running SQL to see how the change has affected some of your queries. There are additional initialization parameters you may or may not want to set in connection with the change. MTS is enable through another initialization parameter (I'd go to OTN and print out the doc on Initialization Parameters and become VERY familiar with it). There are however numerous other considerations, including client configuration and setup of your listener. Again, go to OTN and check out the docs. Regards, David A. Barbour Oracle DBA Venkat_Kalepalli wrote: Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Awfully annoying SQLLDR problem
Tom, Just cogitating and ruminating... You mentioned that you're executing the load as part of a larger procedure. Couldn't you execute a shell script that would ftp the file to the target server and run sqlldr via rsh -c? Another thought would be to have the target file on an NFS-mounted drive that could be accessed by the target and have sqlldr kicked off on the target via a trigger on a simple insert by the source into a DATA_LOAD_REQUIRED table on the target? Regards, David A. Barbour Oracle DBA [EMAIL PROTECTED] wrote: Thank you ever-so-much to Tim, Kirk, Peter, and especially Kirti for your intelligent responses. I'm going to open a TAR on Metalink. I'll probably get the quick and easy response We don't support it anymore. I'm no fan of Oracle but would not blame them for giving me that response. We will have upgraded our source database to 8.1.6.2 by mid July. Perhaps my project will have to wait till then. thanks again, ..tom -Original Message- From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 3:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Awfully annoying SQLLDR problem The missing verb is think, as in I don't think you can avoid [EMAIL PROTECTED] 04/23/01 02:46PM I don't you *can* avoid the larger issue. Oracle 8 has undergone some radical changes underneath the covers. I would expect SQLLDR to have changed just as radically... [EMAIL PROTECTED] 04/23/01 02:06PM No you are reading correctly. I have the data on a server with a 7.3.2.3 database and am using that databases' binary sqlldr to load into the 8.1.5 database. The problem is a timing issue. I need to execute the load from the 7.3.2.3 server as part of a larger script. I cannot ensure that the load will be executed i a timely manner if it is run on the distant server. Whether or not you agree with the timing issue I describe, I'd really appreciate an answer to the Oracle problem. I don't want to get into the larger issue of why I have to run it from one server vs. another. From an Oracle POV it should work either way. thanks, ..tom -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:27 PM To: Multiple recipients of list ORACLE-L Subject:RE: Awfully annoying SQLLDR problem Ok,maybe i am lazy or a poor reader, but are you using 732 sqlldr binaries to load an 815 db? Why not the 815 sqlldr binaries? I mean, it sounds like you have to ship data over the wire no matter what you do, so...why not use the latest version of the sqlldr bits? == -Original Message- == From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] == Sent: Monday, April 23, 2001 11:10 AM == To: Multiple recipients of list ORACLE-L == Subject: Awfully annoying SQLLDR problem == == == I am executing a SQLLDR shell file from a server :: == sourceserv; RDBMS 7.3.2.3 == AIX 4.3.2 == into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3 == using a SQL*Net connect string destserv_destSID. == == This connect string is defined in the local tnsnames.ora == and works. I confirmed == this by doing sqlplus user/pass@destserv_destSID and == verifying that I am == connected to the correct instance. == == The target table exists. I am connecting as the owner == of the target table. That == owner has DBA. == == but when I run == == sqlldr userid=tabowner/pass@destserv_destSID == CONTROL=localcontrolfile.ctl == (controlfile is below) == == I get SQL*Loader-925: Error while parsing a cursor (via ocisq3) == ORA-00942: table or view does not exist == == Help! Does anyone have any ideas? == == tia, == == ..tom == == here's the controlfile == == LOAD DATA == INFILE data1.dat BADFILE load.bad == DISCARDFILE load.dsc == INSERT == INTO TABLE OWNER.TEST_LOAD == FIELDS TERMINATED BY ',' == TRAILING NULLCOLS == (COL1,COL2,COL3) == == == -- == 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
Re: Listener.log
Okay, you moved the old one. Perhaps you haven't had any activity that would cause an entry to be generated for the log? Or have you changed any of the parameters in your listener.ora file? Regards, David A. Barbour Oracle DBA Nguyen Thanh-truc wrote: Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: set dml_lock value without bouncing db?
What was your exact error? Guang Mei wrote: Is this possible? Our 8.0.5 Oracle db (on Sun box) is 7x24. I got error saying Maximum number of DML exceeded. I tried alter system set dml_lock = 300 but it did not work. TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cdump, bdump, udump
Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Where can I find real-life-examples about ORACLE installations?
William, Have you tried to figure out Portal? Next to this beast, Remedy looks pretty good. David A. Barbour Oracle DBA "Thater, William" wrote: On Thu, 19 Apr 2001,Jared Still scribbled on the wall in glitter crayon: -If you're familiar with the Help Desk software 'Remedy', you will know that -it has one of the worst schemas ever designed by man or beast. If you -haven't seen it, you would have a hard time imagining it. Yes, worse than -Finanacials, Lawson, SAP, etc. take a look at MetaSolv's TBS.;-) i'll stack it up against Remedy anyday. can you say circular references? i knew you could.;-) -- Bill Thater Certifieable 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. ~~ Another megabytes the dust. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need Help.
Uday, Your problem may have more than one component. There are three immediate things I'd try/look at, one of which will provide you with information, the other two that may or may not improve your performance. For information on your select statement, start a trace on the session, run the select statement, than analyze the trace file using tkprof with the explain option. If you need specifics on how to do this, check out OTN - http://otn.oracle.com/index.html - search for Explain Plan. This should give you Chapter 13 of the tuning manual, you'll need Chapter 14 as well. I'd also check with your Systems Administrator to see if you're running Veritas Quick I/O. If not, asynchronous I/O is probably not working on your box. There was a big discussion about this last year on the list, and I ended up changing my initSID.ora file, setting disk_asynch_io = false and using multiple DB Writers. Depending on your box, you may want to use I/O slaves instead (either time responses or use a trace and tkprof to determine which works best in your case.). Also, check to see if your optimizer_mode is set to choose or rule. If choose, analyze your schema/database with compute statistics and see if that doesn't help. You may also want to use hints in your SQL. The cost-based optimizer has a number of other parameters which may help you. You can get these from OTN by searching for Initialization Parameters, reading the summary of what each does, and getting more specific information from the tuning guide. Also get a book(s). I've got a bunch, but I highly recommend Oracle 8 - The Complete Reference by Kevin Looney and George Koch. Not complete, nothing beats experience, but you will get enough information to guide you towards determining possible solutions. If your app is using java, check out Adrian Cockcroft's Sun Performance and Tuning: Java and the Internet. Tuning is fun. Have a blast, and oh - don't forget the old standbys iostat and vmstat. You didn't mention anything about your disk configuration. Or your SGA. There's also some v$ views, v$sysstat, v$waitstat, v$buffer_pool_statistics, v$session_wait and a host of others (is timed_statistics set to true in your init.ora?). So many tools - so little time. Start with the obvious, Explain Plan, Disk I/O and Optimizer to get the biggest bang for your buck, then work your way deeper. Hope this helps. David A. Barbour Oracle DBA udaycb wrote: Hi All, Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now this database is going online very soon. When we were testing we observed that, the application (select statement) is running very slow. (I don't know how fast it was earlier). I have a feeling that it is not using indexes properly. I have created 6 indexes on that table on each columns. also created a composite indexes. How do I know that the sql is using which index for select statement.? Is there any other ways to improve the performance? Thanks Uday Name: winmail.dat winmail.datType: ABC DataAnalyzer 1.1 Chart (application/x-unknown-content-type-ABCData) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do not belive BUSH and your army goverment so much
Okay Robert, you've had you 15 minutes of fame. Too bad it made you look so silly. Jared, humor was banished (although it tends to flourish with tongue-in-cheek replies), how about political diatribes (or at least the political diatriber - is that a word?)? Regards, David A. Barbour Oracle DBA Robert Chen wrote: right now, I understand US people also just belive TV or news. The news always controlled by goverment or service for the goverment. This fact is for sure that US is high-handed and arbitrary. US army fly to all over the world and control all the world. I hate this but I feel so frustrated that US army is No.1 in this world and all over the world can not even say a "NO" to US. Right now, I know many US people do not understand Chinese, Chinese do love peace very much. Many things, these days, China are better than US now. You should go and have a look in China. Do not be so stupid and arbitrary. Do not belive BUSH and your army goverment so much. When the army is so good, they want to invade China or some other coutries. I hate China does not have good people rights. But I hate US is so impolite when they know they will win on every army fight. What I have forcasted are becoming true now. When BUSH was selected as president. I forcasted he would make many bad things and use his army. Today I forcast he will invade China more and put all Chinese in extreme misery. He will because he is the people who care too much about army...He do not care about high-tech, you are losing your good salary now...You have lose you stock options. Just one more fact, yesterday I watched the TV, the announcer used intimidatory voice that made very unhappy, "fuck you", I growl to the TV. Just because you have the No.1 army so you can do all the things? Sorry for this post because it is not about ORACLE. If US and China finish the relationship, at least 10% more of you will lose your job. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:20 PM They ought to learn flying their bikes from ET.. leave fighter plane flying to others.. -Kirti -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: stupid DBA Well, according to the stereotype, they aren't very good drivers, so maybe it was inevitable. ep [EMAIL PROTECTED] 04/14 6:15 PM How was it mean? Considering how well they seem to do their job, it would be a heck of a lot easier to become a Chinese fighter pilot than a nurse. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: crontab script problem
Rajesh, Instead of running the .profile for the oracle user, you might try invoking the oracle user. I don't think you're seeing the $ORACLE_HOME. Try something like: su - oracle "-c sqlplus -s"END system/manager END @/oracle/test2.sql Hope this helps. David A. Barbour Oracle DBA, OCP Rajesh Dayal wrote: Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shell script to send mail
Viraj, As I remember, your initial query mentioned you were trying to send a message from an AIX box. First check to see if sendmail is running on your system. Execute the command ps -ef |grep sendmail . You should receive a response that includes a line like the following: root 3900 2084 0 Mar 24 - 0:01 sendmail: accepting connections If you don't, then your system isn't going to send any mail, because it isn't configured. If it's running, check your /etc/sendmail.cf file. This may be the cause of your problem. Remember, if you make any changes to this file, you must recompile it and issue the refresh -s sendmail command before it becomes effective. Your problem may also lie in the /etc/aliases file. This also needs to be recompiled and the refresh command issued if changed. There is a little bit of work required in setting up sendmail on any UNIX system - not just AIX - but these are three good places to look for problems to begin with. I suggest you get a copy of O'Reilly's Sendmail if you're going to be using mail from UNIX boxes on a regular basis. Assuming your sendmail is running, AIX uses the commands mail, Mail, and mailx interchangeably. I just use mail (cause I hate to type extra characters). Make sure you're executing the mail command from the directory containing the msg file, otherwise you'll need a fully qualified path. Try using single quotes instead of double quotes around your subject. To see if your box is sending mail at all try: mail -s 'Test' myusername@myunixhostnamemsg If you don't get the mail, see your sys admin. If you do, then the problem most likely lies in one of the two files I mentioned earlier. You'll probably need to see your sys admin there as well. Hope this helps. David A. Barbour Oracle DBA Viraj Luthra wrote: Hello, This is the second time I am writing this message, dont know what happened where the last message went. Basically wanted to thank every one who ever responded, with this easy construct in the shell. But the problem, is that I sent like this, mailx -s "from the sco box" [EMAIL PROTECTED] msg where msg is a regular file and contains the string - this is a test only But I have waited for a long time and it did not appear in the above address. Any ideas why it did not reach. I have looked at the man for mailx, and I have already checked the various files, like dead.letter etc. but of no use, it simply does not exist. Please help. Regards, Raja -- On Tue, 10 Apr 2001 09:15:40 SHAIBAL TALUKDER wrote: Raja, If you have unix mail utility you can send mail form unix. At the system prompt type - mailx -s "Subject" [EMAIL PROTECTED] msg hope this helps. Shaibal Viraj Luthra [EMAIL PROTECTED] wrote: Paul, I dont need that software. I need the code to write in my software itself. rgds, raja -- On Mon, 09 Apr 2001 21:10:52 Paul Drake wrote: check out tripwire ... http://sourceforge.net/projects/tripwire/ Viraj Luthra wrote: Hello all, I need help. I need to write a shell script (aix box), when ever some loads a piece of software. thanks raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you wan
Re: Oracle repository
Pierre, Have you looked into CVS(Concurrent Versioning System)? CVS allows concurrent editing of sources by several users working on releases built from a hierarchical set of directories. It works great and when set up properly, can make your life (and that of your system administrator) a whole lot easier by allowing developers to refresh their source code with previous versions. All stored procedures and packages can be loaded by the DBA into production (after testing) from the source repository. It's pretty easy to set up and use. Check out this link for more info: http://www.cvshome.org/ Regards, David A. Barbour Oracle DBA [EMAIL PROTECTED] wrote: I would be grateful if you can advise me if there are other products than Oracle Designer 6i which is able to build automatically a version control baseline and track the changes at the packages and stored procedure level. My goal is to have in place a control version program which could be used not by programmers, but the people from Internal Control dept which will track the changes at the level of database level. Thanks in advance, Pierre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery from noarchive db corrected
Sinardy Xing wrote: The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? Sinardy, You definitely want to turn archiving on. Without it, your recovery options are limited to the last offline backup of the database. If you do an offline backup of the development DB every night, then the most that would be lost is one day's worth of development. Depending on how and where the developers write and store their code, the least that would be lost is one day's worth of transactions in the development DB. Beyond that however, is the fact that you are a developer in a sense as well. Tuning databases to avoid the kind of contention the developers are worried about is part of what you do for a living. If the developer's fears are correct, and archiving causes their database to respond poorly, what will happen when their code goes into an archived production database? There are many parameters you can alter and steps you can take to reduce, minimize, or eliminate this type of contention. Combinations of things like adding redo logs, increasing the size of the log buffer, altering checkpoints, looking at v$latch and making appropriate adjustments to log_small_entry_max_size or log_simultaneous_copies are just a few of the options available to you as the DBA. Examining the code processing the batch is another. Tuning is like detective work, and is probably my favorite part of being a DBA. Start with one of the tuning manuals off OTN, then pick up (and read) Steve Adam's "Oracle 8i Internal Services" from O'Reilly. You'll be a better DBA, and who knows, you might even be able to teach the developers a trick or two. Good Luck. David A. Barbour Oracle DBA -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.
Re: Max # of Open Files for UTL_FILE in 7.3.4.3
Waleed, That is an answer. Opening and closing the files might be an option. Unfortunately, I have to work within the environment I was given. The application from which I'm extracting the data is poorly designed. Space and memory are a problem, and the table containing the master records is heavily chained and contains 27 million rows. Sorts, orders and groups are not an option. Thanks. David A. Barbour Oracle DBA "Khedr, Waleed" wrote: I'm not answering the question but suggesting sorting your data on that date column and opening, writing to, and closing a file for every unique value for this date column. -Original Message- Sent: Tuesday, April 03, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Greetings, Had an situation today in 7.3.4.3 running on AIX v4.2. I was extracting data to several different files based on the date record using UTL_FILE. I found I couldn't have more than 10 files open at any given time. I know the default in 8i is 50 files, but I looked on OTN and couldn't find either the default number of files (has to be 10) or any way to change it for 7.3x. Does anyone know if it can be increased and how? Thanks, David A. Barbour Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unable to open the database,Urgent!!!
Saroj, It appears you do not have enough semaphores available to bring up both instances. What flavor of UNIX are you operating on? David A. Barbour Oracle DBA "Dash, Saroj (CAP,CEF)" wrote: Hi, In a Unix Machine I want to create two instance on a single server.Its memory size is 1GB. I am trying to up one instance it is opening well .While Creating other instance I am getting this error. ORA-07279: spcre: semget error, unable to get first semaphore set. SVR4 Error: 28: No space left on device Additional information: 25 Additional information: 2 But I tred to shutdown the first database and open the second one ,the second one open well and Viceversa. But WhenTrying to open both the database it gives the above error. Please tell me what i wil do. Previously the SGA size was 15MB. The new one I tried to 6Mb ,then eror gives. Thne next method I tried SGA is 6Mb for 1st database and second is 2Mb.thne still error Tell me what I will do. Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Max # of Open Files for UTL_FILE in 7.3.4.3
Greetings, Had an situation today in 7.3.4.3 running on AIX v4.2. I was extracting data to several different files based on the date record using UTL_FILE. I found I couldn't have more than 10 files open at any given time. I know the default in 8i is 50 files, but I looked on OTN and couldn't find either the default number of files (has to be 10) or any way to change it for 7.3x. Does anyone know if it can be increased and how? Thanks, David A. Barbour Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Concatenate rows
Hi Wendy, Here's an example from a PL/SQL procedure: inputFromDate := startMonth||'/'||startDay||'/'||startYear; The '/' is a delimiter, if you don't want one just use: inputFromDate := startMonth||startDay||startYear; The individual data elements in this case were user input on a web browser, but the same syntax applies if the elements had been selected from tables. Hope this helps. David A. Barbour Oracle DBA, OCP Wendy Y wrote: Hello: Is there a way that we can Concatenate several rows (say 6 rows from a select statement) into one variable? Thanks Wendy -- Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Loader help
Chaim, Check out the sqlldr case studies on OTN. Ross has the right idea with the NULLIF. Here's a general description from OTN: Loading All-Blank Fields Totally blank fields for numeric or DATE fields cause the record to be rejected. To load one of these fields as null, use the NULLIF clause with the BLANKS keyword, as described in Comparing Fields to BLANKS. Case 6: Loading Using the Direct Path Load Method provides examples of how to load all-blank fields as null with the NULLIF clause. If an all-blank CHAR field is surrounded by enclosure delimiters, then the blanks within the enclosures are loaded. Otherwise, the field is loaded as null. More details on whitespace are presented in Trimming Blanks and Tabs and in Preserving Whitespace. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: Maybe some could help me. I'm having trouble trying to load a csv file with sqlldr. The destination table has char columns defined as not null and the csv file has missing data for these columns. (These columns will contain blanks in the database). Sqlldr wants to set the missing fields to null, which results in record rejected errors. Is there a way around this. I would be happy if I could insert blanks or insert any other marker-value into the field like '***'.. The input file lines looks something like (011101,1,31460) Thanks Chaim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Loader help - Another approach
Chaim, Along these lines, can't you disable the not null constraint, load the data, update the table/columns (UPDATE MY_TABLE SET THIS_COLUMN = 0 WHERE THIS COLUMN IS NULL) then re-enable the constraints? David Ron Rogers wrote: Chaim, If on the other hand the BLANK will not work properly on a numeric filed that is to be used in calculations. In that case you might want to have a 0(zero) loaded rather than a null,blank. Then you could use the NVL clause in your controll statement where the field type is numeric. ROR mm [EMAIL PROTECTED] 03/30/01 02:00PM Chaim, Check out the sqlldr case studies on OTN. Ross has the right idea with the NULLIF. Here's a general description from OTN: Loading All-Blank Fields Totally blank fields for numeric or DATE fields cause the record to be rejected. To load one of these fields as null, use the NULLIF clause with the BLANKS keyword, as described in Comparing Fields to BLANKS. Case 6: Loading Using the Direct Path Load Method provides examples of how to load all-blank fields as null with the NULLIF clause. If an all-blank CHAR field is surrounded by enclosure delimiters, then the blanks within the enclosures are loaded. Otherwise, the field is loaded as null. More details on whitespace are presented in Trimming Blanks and Tabs and in Preserving Whitespace. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: Maybe some could help me. I'm having trouble trying to load a csv file with sqlldr. The destination table has char columns defined as not null and the csv file has missing data for these columns. (These columns will contain blanks in the database). Sqlldr wants to set the missing fields to null, which results in record rejected errors. Is there a way around this. I would be happy if I could insert blanks or insert any other marker-value into the field like '***'.. The input file lines looks something like (011101,1,31460) Thanks Chaim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Crontab
Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if that day's date plus seven days falls into another month. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "DEMANCHE Luc (Cetelem)" wrote: Hi gurus, I want to schedule a script to run on the fourth sunday of the month. How can I do that ? TIA - Luc Demanche CETELEM Tl.: 01-46-39-14-49 Fax : 01-46-39-59-88 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Crontab - Ooops
Charlie, Some days are like that. You're right. Mike Hand had the right idea when he wrote: .. 2 choices are MM HH 22-28 * * (shell script checks for Sunday before proceeding) OR MM HH * * 0 (shell script checks for day of month between 22 and 28 before proceeding) Mike Charlie Mengler wrote: Just curious. Using your algorithm, what happens on those rare months where there are FIVE sundays? "David A. Barbour" wrote: Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if that day's date plus seven days falls into another month. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "DEMANCHE Luc (Cetelem)" wrote: Hi gurus, I want to schedule a script to run on the fourth sunday of the month. How can I do that ? TIA - Luc Demanche CETELEM Tl.: 01-46-39-14-49 Fax : 01-46-39-59-88 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert without telling column names
Roland, You can't. There are a number of ways to really cut down on the code required to do an insert, but if you think about it, how will Oracle know where the data is supposed to go if you don't give it the column name(at some point)? If you're using 8i, there is a direct load insert, but as far as I'm aware, this will work only for a select * from another table. Dynamic SQL works pretty well for this kind of stuff. What are you trying to do? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth [EMAIL PROTECTED] wrote: Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS_OUTPUT.PUT_LINE
Roland - Depending on how your inserts are being generated, why don't you use a counter or the ROWCOUNT function? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "Bunyamin K.Karadeniz" wrote: I looked at the documentation and could not see a function giving that . But you can declare a variable and increase it after each insert ( if you do the inserts in a loop , it is good). Then dbms_output.put_line(variable_name); Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 3:50 PM Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert without telling column names
Hi all -
I stand (sit?) before you with egg on my face. I KNOW you can insert
without naming column names if you're filling the entire row, I just
didn't consider that this might be what Roland was attempting to
accomplish. As Regina and Jacques both pointed out, if your package,
procedure or script is to be reused, it's probably best not to assume
the table structure you think will be there actually is there.
With humble apologies,
David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth
William Beilstein wrote:
You are misinformed. If you have a table of the form
col1varchar2(1)
col2 number
col3 date
You can insert into it with the insert statement
INSERT INTO MYTABLE VALUES('X',23,SYSDATE);
As long as ALL the columns are included in the values clause in the order they were
created in the table, you don't have to define the column names.
[EMAIL PROTECTED] 03/20/01 11:36AM
Roland,
You can't. There are a number of ways to really cut down on the code
required to do an insert, but if you think about it, how will Oracle
know where the data is supposed to go if you don't give it the column
name(at some point)?
If you're using 8i, there is a direct load insert, but as far as I'm
aware, this will work only for a select * from another table.
Dynamic SQL works pretty well for this kind of stuff. What are you
trying to do?
Regards,
David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth
[EMAIL PROTECTED] wrote:
Hallo,
How can I create an insert statement without telling all the names of the columns?
Give an example, please.
Roland Skldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David A. Barbour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David A. Barbour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Need Help For Installing Oracle On AIX
Neena, If I understand correctly, you have a server with the OS on it, and the DB on a set of external drives - right? Cable the external drives to the working server, reboot, and import the volume groups. Your database should be right there. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth NSC wrote: Hi All, Our application is based on the twodatabases ( on two diff. servers , os AIX). One of these server is down since yesterday because of some hardware (motherboard) problem.Finding out the exact problem and solution will take time. AMC person might give a replacement server till that time. We have five harddisks for this server . All are intact. OS is on the hard disk which is attached to the server. Oracle software and the database files harddisks are external harddisks in a separate machine. As the server will be replaced to recognize the new hardware we have to install OS and so Oracle. Can anyone tell me what are the steps for installing AIX (4.3)and Oracle 7.x on AIX 4.3 ? After installing Oracle how to configure the exisisting database and bring it up ? --Neena Terry Ball wrote: We have a support contract with IBM (for server support), and the support costs could be deceptive if you don't know how IBM works. The cost is on a per user basis. So if you only got one support license, your company would only be allowed to have one NAMED person calling in. If anyone else called in, they would not get any help. And IBM is vey sticky about answering only the named person(s). Terry P.S. Thanks, Dennis. This was a great help. Dennis Taylor wrote: Since the list doesn't allow attachments, I'm just merging in all this as text. It may be messy. sorry. Oh, and these are Canadian prices. U.S. prices will be 50% - 67% of the stated values. My original RFP: = I am looking for quotes on RDBMS products for the following scenarios: Server Platform: 2x750 MHz Intel, running Linux or NT DBMS: Enterprise Edition or equivalent. Scenario 1: 1 server, 1 location, 50 users. Scenario 2: 1 server, 1 location, 400 users. Scenario 3: 5 servers, different locations, with the following user counts: 200 users 100 users 40 users 40 users 20 users Scenario 4: 1 server, serving up data for an internet-based web server. I would also like information on: Annual maintenance costs Version upgrade costs and patch availabilities. Cost of a separate server which will serve up data for an internet-accessible web server. Price for Enterprise and Non-enterprise versions if applicable. Policies concerning maintaining backup systems, i.e. do we need a separate license for a separate system that is intended only as a failover? Price of any recommended or required companion software that may not be bundled with the RDBMS. Notes on the results that I got: All quotes are for "Enterprise Edition" versions of the RDBMS's. "Workgroup" versions are available from all companies, and are considerably less expensive. They typically are limited in the ability to replicate data between servers. In the case of SQLServer, for instance, the 'Standard" edition of SQLServer cannot do clustering and automatic failover. In the case of Oracle, the "Workgroup" edition cannot do automatic replication of data to other databases. There are also system and programming features missing, such as partitioning and function-based indexes in Oracle. The Enterprise editions of DB2 and SQLServer come in unlimited-user versions only. The Oracle Enterprise edition requires a minimum 50-user purchase at our level, and "tops out" at about 300 users, after which it make more sense to buy the unlimited-user version. All vendors require us to pay for a backup system. Only DB2 has a somewhat cheaper price for the backup RDBMS license. DB2 and SQLServer charge per-cpu for the Enterprise editions. Oracle charges per-cpu multiplied by clock speed. This means that if we later upgrade to a newer server, we have to pay Oracle more money, even if the software doesn't change. All vendors promise additional price breaks and other incentives, given further "negotiations". It's very much a moving target. Oracle's support, although the most expensive, is also the most comprehensive. The figures quoted for Oracle support are annual amounts. No, I'm not kidding. The IBM annual support cost is ludicrously low, but I was unable to get anyone to deviate from it. I suspect a rat. It's worth noting that, if we went with IBM, we
Re: problem with UTL_FILE.FILE OPEN
Connor - Fortunately, that requires dba privs which (see previous posts from Rachael, Lisa, et al) your folks don't have. Right? Actually though, you make a good point - there is some risk involved in setting the parameter to *. The files are created/written as the oracle user, so any filesystem oracle can write to is fair game. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth Connor McDonald wrote: utl_file_dir = * is VERY bad news... for i in ( select file_name from dba_data_files ) loop open file i.file_name for write end loop; and voila...No more db --- "Dasko, Dan" [EMAIL PROTECTED] wrote: Cool, you learn something new everyday. Dan -Original Message- Sent: Wednesday, March 14, 2001 8:05 PM To: Multiple recipients of list ORACLE-L Dan - I've previously used the * to define utl_file_dir with no problems. According to the documentation: "The parameter specification UTL_FILE_DIR = * has a special meaning. This entry turns off directory access checking, and it makes any directory accessible to the UTL_FILE functions." I'm wondering if the directory location in the procedure or package is entered correctly OR the filename is invalid for the operating system. I've had that problem when trying to dynamically name a file. Regards, David A. Barbour Oracle Database Administrator Formerly with the now defunct and bankrupt ConnectSouth "Dasko, Dan" wrote: I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions are 777). Do you have any idea what's wrong? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the
Re: problem with UTL_FILE.FILE OPEN
Dan - I've previously used the * to define utl_file_dir with no problems. According to the documentation: "The parameter specification UTL_FILE_DIR = * has a special meaning. This entry turns off directory access checking, and it makes any directory accessible to the UTL_FILE functions." I'm wondering if the directory location in the procedure or package is entered correctly OR the filename is invalid for the operating system. I've had that problem when trying to dynamically name a file. Regards, David A. Barbour Oracle Database Administrator Formerly with the now defunct and bankrupt ConnectSouth "Dasko, Dan" wrote: I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions are 777). Do you have any idea what's wrong? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
