RE: IBM AIX Shark storage?

2002-06-19 Thread Ferenc Mantfeld
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

RE: SEQ#, DUAL and Oracle literacy

2002-06-19 Thread Ferenc Mantfeld
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:

Out of topic :Compare 2 data files in unix

2002-06-19 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

RE: SEQ#, DUAL and Oracle literacy

2002-06-19 Thread Farnsworth, Dave
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

OT: Viruses

2002-06-19 Thread Robertson Lee - lerobe
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,

Problem with the ?-sign (Euro)

2002-06-19 Thread Anders Bengtsson
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

production database on aix won't be open, help

2002-06-19 Thread chal_ping
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

Re: IBM AIX Shark storage?

2002-06-19 Thread Jack van Zanen
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

Printer Help !Urgent

2002-06-19 Thread sultan
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

2002-06-19 Thread Roland . Skoldblom
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,

RMAN -Alternate Host next problem

2002-06-19 Thread rabbit
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

RE: urgent: production database won't be opened

2002-06-19 Thread Rahul
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

Re: SEQ#, DUAL and Oracle literacy

2002-06-19 Thread Alexandre Gorbatchev
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

RE: Free Buffer Waits

2002-06-19 Thread Jack van Zanen
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

RE: OID

2002-06-19 Thread Markus Reger
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)

Re: Question about sql loader - help

2002-06-19 Thread Connor McDonald
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

Pl/Sql renaming columns

2002-06-19 Thread Roland . Skoldblom
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

Re: Exp Imp User ?

2002-06-19 Thread Joe Testa
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 ,

RE: Online vs offline backups

2002-06-19 Thread Ferenc Mantfeld
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