RE: IBM AIX Shark storage?
James We use Shark internally, connected to AIX, Solaris and Windows servers. Much better than Hitachi IMO. The caching mechanism is similar to EMC, and the IO performance is excellent, even with RAID5. Actually I am told it is RAID-S, but it is all a black box to me. I just know that my DSS DW DB's load faster with the Shark than they do with ordinary raw volumes on SCSI. HTH. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Tuesday, 18 June 2002 9:22 AM To: Multiple recipients of list ORACLE-L DBA's Anyone using IBM's Shark storage solution? What is you're opinion? I understand it uses raid 5 :-( with a big cache in front. I've talked to a couple of DBA's that are using them and they think they are great and haven't experienced any problems with poor performance (including write speed). We've had a bad experience with Hitachi raid 5, salesman said it was great so the boss bought it. Thanks ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
The problem seems to be with the preferred ven-duh ! Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Tuesday, 18 June 2002 12:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Out of topic :Compare 2 data files in unix
BDY.RTF Description: RTF file
RE: SEQ#, DUAL and Oracle literacy
Hallo, What is dual? g -Original Message- Sent: Tuesday, June 18, 2002 2:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Viruses
Has anyone else received viruses from this list recently. This is the only list I am subscribed to via my works email now and I have had about 4 sent to me in the last 3 weeks. Sorry for the non-oracle subject matter Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Problem with the ?-sign (Euro)
Hi, We have a UTF-8 charcter-set in the database and running NLS_LANG as AMERICAN_AMERICA.WEISO8859P1 both on the database and the webservers. All is running OK besides that the Euro-sign shows up as a question-mark upside down. Is there a simple sollution for this problem? I have tried a lot with the convert function and looked in the database with the dump - command but I havn't found any sollution. Regards Anders Bengtsson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anders Bengtsson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
production database on aix won't be open, help
oracle-lHi, grurus: This is a production database 8.1.7.2 on aix 4.3.3, there are 17 instances running on the same box. I shutdown immediate the database and it hangs.After wait for one hour, i do a shutdown abort. When i startup again, it failed to open the database , just hangs at this stage like: Sun Jun 16 09:36:40 2002 SMON: enabling cache recovery SMON: enabling tx recovery And the sql*plus window hangs at : database mounted, but never showed open. From another shell prompt, i sqlplus internal and query the instance, it showed instance open in read write state! But from remote node via listener, client process showed 0134: oracle not available. I once met such kind of questions on sun solaris, it is because of solaris bug.But never heard of this kind on AIX. Oracle support suggest reboot the server, but as there is 16 other instance on it, it is not the solution. Can anyone help? Great thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chal_ping INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: IBM AIX Shark storage?
Hi We are not using them for our Oracle storage but other apps. But according to the UNIX boys they are much faster than the EMC symmetrix that we have here for our oracle storage. Setup may be different from a point of recoverability, availability so it's a little like comparing apples to pears. They are fast though. Jack James Howerton jhowerton@uabmc.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] edu cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: IBM AIX Shark storage? [EMAIL PROTECTED] 18-06-2002 18:21 Please respond to ORACLE-L DBA's Anyone using IBM's Shark storage solution? What is you're opinion? I understand it uses raid 5 :-( with a big cache in front. I've talked to a couple of DBA's that are using them and they think they are great and haven't experienced any problems with poor performance (including write speed). We've had a bad experience with Hitachi raid 5, salesman said it was great so the boss bought it. Thanks ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended
Printer Help !Urgent
Hi gurus I am calling report from Form The report DESTYPE is screen. Here I want user to print that output only once. Then the system shuold exit or should not allow them to print agian. How can I set ? Help needed please syed
Question about sql loader - help
Hallo all you gurus, I have a question: Is it possible that every time the sql loader script runs change the field names to the field names specified in the file to be loaded.: The field names should be different dates. The next time the script sqlloader run sit will be a new field name, which means a new date as the field name. Any one who can give me some help and an example of a control file which does this thing. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN -Alternate Host next problem
Recall our Netbackup server holds only 2 months tapes and Im trying to recover on an alternate host to the beginning of the year. I issue following : run { allocate channel ch1 type 'sbt_tape'; restore controlfile; alter database mount; } then once the current control files are back I issue run { set until time to_date('01-JAN-2002 03:00:01','DD-MON- HH24:MI:SS'); allocate channel ch1 type 'sbt_tape';restore database; recover database; } The logs (thanks for location guys) ask for tape DC3787 which was has a date last written 12/29/2001 22:29 netbackupsrv which I presume is the last cold backup taken by rman, it then restores okay to that point. RMAN-08023: channel ch1: restored backup piece 1 RMAN-08511: piece handle=bk_5942_1_449790981 tag=COLD_DB_BK_LEVEL0 params=NULL RMAN-08024: channel ch1: restore complete rman then seems to ask for correct archivelogs RMAN-03022: compiling command: recover RMAN-03022: compiling command: recover(1) RMAN-03023: executing command: partial resync RMAN-03022: compiling command: recover(2) RMAN-03022: compiling command: recover(3) RMAN-03023: executing command: recover(3) RMAN-08054: starting media recovery RMAN-03022: compiling command: recover(4) RMAN-03023: executing command: recover(4) RMAN-08017: channel ch1: starting archivelog restore to default destination RMAN-08022: channel ch1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=17138 RMAN-08022: channel ch1: restoring archivelog then i get errors 0ra-19511 backup up file not found. So I can see RMAN seems to know the archivelog files it needs, yet they are not on that tape,and the Netbackup log doesnt ask for the next tape. Can I manually recover these archivelogs or am I doing something wrong? I will be researching myself but if any of you guys can help it will be great. Plus my weekend starts today. thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: urgent: production database won't be opened
my guess is that the instance is rolling back transactions which, were interupted when u shutdown the db. -- From: chal_ping[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: urgent: production database won't be opened Hi, grurus: This is a production database 8.1.7.2 on aix 4.3.3, there are 17 instances running on the same box. I shutdown immediate the database and it hangs.After wait for one hour, i do a shutdown abort. When i startup again, it failed to open the database , just hangs at this stage like: Sun Jun 16 09:36:40 2002 SMON: enabling cache recovery SMON: enabling tx recovery And the sql*plus window hangs at : database mounted, but never showed open. From another shell prompt, i sqlplus internal and query the instance, it showed instance open in read write state! But from remote node via listener, client process showed 0134: oracle not available. I once met such kind of questions on sun solaris, it is because of solaris bug.But never heard of this kind on AIX. Oracle support suggest reboot the server, but as there is 16 other instance on it, it is not the solution. Can anyone help? Great thanks. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chal_ping INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Don't see any problems :-) CREATE TABLE SYS.SUPER_DUAL (specific_seq_num NUMBER(10)); DROP PUBLIC SYNONYM DUAL; CREATE PUBLIC SYNONYM DUAL FOR SYS.SUPER_DUAL; INSERT INTO SYS.SUPER_DUAL VALUES(666); Vua-la!!! ;) -- Alexandre Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Free Buffer Waits
Hi, I have the book from Gaja friends already, it's good THX. I could trace with evnt 10046 but it won't reproduce anymore, everything is peachy again (?) Backups run every night (cold) and are used for cloning to test twice a week. I would look at all the views you suggest if I could only have it happen again (but I'd be happy if it doesn't). The fact that nothing changed to the oracle environment and still see a change in behaviour also puzzled me. I'm sure nothing happened because there is only two DBA's here and my colleague was on leave for three weeks so I'm the only one with access to production and have some privileges to do something. (developers can only look at the production data because they also support the app) Competing for resources may be a valid point but I can not find more than one session on for the majority of the time (in the end users start coming in) and in short this session was doing a drop temp table, create temp table, open two cursors, manipulate the data from the cursors (in sequence) and fill a table with the data, close the cursors and ultimately drop the temp table. Don't see much competing for the same block there So I thank everybody that replied with suggestions and will check all of it when it becomes reproducable. Jack Johnson, Michael Michael.Johnson@oln-aTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fmc.af.mil cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Free Buffer Waits [EMAIL PROTECTED] 19-06-2002 00:09 Please respond to ORACLE-L Obviously, you have something in your system competing for resources. There are multiple sessions requesting the same block. Everything seemed to run fine and now all of a sudden things dont work , but nothing new has been introduced into the system. How can this be ?Perhaps you have other problems that have been created in the system in the last few days that wont be seen until your backups are run. It appears you are going to have to reproduce what you see and log certain events while the bottleneck is happening. I would set an event 10046 and comb through there ... I would also try to look at v$session_wait which will show the file#, clock# and id ( where id represents the status of the buffer busy wait event ). I would also buy Gaja Krishna Vaidyanatha and Kirti Deshpande's book Oracle Performance Tuning 101 as it has been a big help to me. Other things you might find helpful would be www.hotsos.com which goes into great detail on the 10046 event trace and they also have an excellent clinic I just went too. Good Luck and Peace ! Mike -Original Message- Sent: Tuesday, June 18, 2002 12:43 AM To: Multiple recipients of list ORACLE-L Hi, I came in early morning and saw the batch job had been taking forever. I immediately checked v$system_event (the job that took so long had just finished so session_wait was no longer option). Since we shutdown and backup our database every night the figure presented here was basically since the batch job started because that starts right after startup. So basically the system (with no other logins as per listener.ora file). had been waiting about 6-7 hours since startup on free buffer waits. We did not introduce any other jobs to the batch and it has been running normally since that one time strange behaviour. No logging of any hardware/software error was found on UNIX nor
RE: OID
don't like windog at al, but there is a cd UNIX TOOLS FOR WINDOWS that offers a shell functionality. it will cost some M$ just to mention it. but: CYGWIN works fine kr [EMAIL PROTECTED] 06/18/02 19:06 PM On Windohs, you'll need to install the GNU-licensed CygWin (http://www.cygwin.com) in order to use the Unixy shell scripts. I've tried this at home, and the scripts worked exactly like they do on Linux. Note that doesn't mean they always work *correctly*, they just work the same. HTH! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Deborah Weatherspoon [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 16, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: OID Hello everyone, I have successfully installed Oracle Internet Directory on a Window-XP platform. How do I use bulkload.sh to load data into OID. Thanks in advance for any help you can provide. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question about sql loader - help
Not directly, but a with little sed/awk/grep etc you could turn a template control file into a version ready for use. hth connor --- [EMAIL PROTECTED] wrote: Hallo all you gurus, I have a question: Is it possible that every time the sql loader script runs change the field names to the field names specified in the file to be loaded.: The field names should be different dates. The next time the script sqlloader run sit will be a new field name, which means a new date as the field name. Any one who can give me some help and an example of a control file which does this thing. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Pl/Sql renaming columns
Hallo, Anyone who has any good hint on how to write pl/sql if i wantto chang ethe name of the fields everytime the procedur runs? The field names should be 1-JULI-2002 the first time the procedur runs, the next time the procedur runs the name of procedur should be 1-AUG-2002 etc. Please help me with this. I have tried to look in the manual, but cant find any clue. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Exp Imp User ?
utilities guide, happy reading. guess who wrote: I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online vs offline backups
I once heard someone actually say 'For peace of mind, perform a monthly cold backup'. My opinion is that this is the biggest load of crap I have ever heard. If your backup, or more importantly, your recovery strategy has been tested, there is zero NEED for a cold backup, as you can fully recover just as easily from a hot backup. The same person that advocated a cold backup did not back up the online redo logs, so what use was it anyway, since the only way they would force open their DB is with a resetlogs option anyway. Think people, think ! Sometimes it really is not rocket science but just pure common sense based on some elementary knowledge. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Tuesday, 18 June 2002 3:59 PM To: Multiple recipients of list ORACLE-L If you create a new database and do a full online backup (this also includes future regular full online backups) is it ever necessary to do a full offline backup? I have heard conflicting answers, regarding this and am looking for some clarification. Don't 24x7 applications always have to execute offline backups? Are offline backups done for peace of mind, and if yes why? What issues are introduced if only offline backups are issued. In addition, we are using BMCs Sql BackTrack product and I am not sure if it is a requirement of the tool that an offline backup be periodically performed. If you know that as well, please share. Thanks everybody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).