Re: Rename Column in 9iR2

[Don Granaman]

To steal a quote from Matt Adam's white board (sorry Matt!):

"You gotta stop thinking logically, and start thinking Oracley" - Jim Droppa

Don Granaman
[OraSaurus]

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 2:00 PM


Rachel,
 I agree with your statement but since you used the word "logically" ,
I questioned the workings of Oracle and why or how they do things.
[...]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Warehouse Hardware Recommendations

[Yechiel Adar]

IBM mainframe. Nothing beats these dinosaurs.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 6:08 AM


> Our data warehouse box is nearing it's max capacity so we are looking for
> options for an upgrade. The current box is maxed out so it will be a
> forklift upgrade. Since we are less than satisfied with our current vendor
> we are open to changing platforms. I don't want to mention the current
> vendor so as not to prejudice any suggestions. What I would like to know
is
> what hardware (server and storage) folks are using for their data
warehouse.
> We are projecting our system to be around 10TB by the end of this year
with
> continued growth (3-5yr) projected at 70TB.
>
> Thanks
>
> MB
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Brooks
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename Column in 9iR2

[Yechiel Adar]

Upgrade to 9iR2 today.
Rename column does not work in 9.0.1.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 9:30 PM


> If those times are right... its a functionality you
> should not live without, its a direct money saver.
> Upgrade to 9i today!
>
> hats off to Oracle marketing... "if and when the
> database sales lose traction... we will release RENAME
> COLUMN"... and 20 years later... here it is.
>
> Keith
>
> Date: Wed, 22 May 2002 10:41:32 -0800
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Reply-to: [EMAIL PROTECTED]
> Organization: Fat City Network Services, San Diego,
> California
>
>
> Kevin,
>  I appreciate your testing efforts. Now to convince
> the bean-counters
> to upgrate to 9i.
> Ron
> ROR mª¿ªm
>
> >>> [EMAIL PROTECTED] 05/22/02 02:08PM >>>
> I reran my test. with 250,000 rows in the table. It
> took a whopping
> 0.25
> seconds to complete.
>
> -Original Message-
> Sent: Wednesday, May 22, 2002 12:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Kevin,
>  Yes but does it work with data in the column?, I do
> not have 9i set
> up
> yet. If it works as you describe with data in the
> column it will
> really
> help with the multi million row tables that "they"
> want to rename a
> column  after a release of a new lotto game.
> thanks,
> for the test and update.
> Ron
> ROR mª¿ªm
>
> >>> [EMAIL PROTECTED] 05/22/02 10:38AM >>>
> Summary: it works!
>
> SQL> SELECT * FROM v$version;
>
> BANNER
> 
> Oracle9i Enterprise Edition Release 9.2.0.1.0 -
> Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE9.2.0.1.0   Production
> TNS for Solaris: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
> SQL> create table test_table (wrong_name
> VARCHAR2(40));
>
> Table created.
>
> SQL> alter table test_table rename column wrong_name
> to right_name;
>
> Table altered.
>
> SQL> desc test_table;
>  Name  Null?
> Type
>  - 
> 
>  RIGHT_NAME
> VARCHAR2(40)
>
> SQL>
>
> Kevin Toepke
> [EMAIL PROTECTED]
>
>
>
> __
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Keith Peterson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-01595

[Bernard, Gilbert]

The accompanying messgage is 
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1) which is
being
freed


-Message d'origine-
De: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Date:   mercredi 22 mai 2002 16:29
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

Gilbert - The oerr utility says the key part is the accompanying
message.
Can you forward the accompanying messgage? 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback segment
(string))

I got this error when I tryed to shrink the rollback segment system,

What can I do to solve this problem, optiman does'nt solve it.

thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

USE_SHARED_SOCKET with Oracle 8.1.7 on NT.

[Andrey Bronfin]

hi !
Did anyone successfully use the USE_SHARED_SOCKET env variable with Oracle
8.1.7 on NT?
If so , how do you overcome the bug 1566794 , please ?
Thanks a lot in advance

DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: newbie seeks career direction: become a DBA or DEVELOPER?

[Farnsworth, Dave]

Or you can go straight into damagement.  It requires no technical skills, no people 
skills and the innate ability to royally screw things up.  Upon completion of screwing 
things up, leaving a mess for the DBA to cleanup, you then are promoted to a higher 
level damagement position with a pay raise.

;o)

Dave

-Original Message-
Sent: Wednesday, May 22, 2002 10:43 PM
To: Multiple recipients of list ORACLE-L


I always keep an open mind on these sort of things, I would suggest that 
you now look for an IT job, where you can get close to Oracle product and 
hopefully some people like are on this list. You are coming in with no 
experience it would appear, so you are in the same boat as a grad. You 
might try for some help desk role, and then find opportunities within that 
organisation to expand your skills. Developer, DBA whatever will come your 
way of you just keep at it. You also might like to consider looking at 
Oracle for phone support roles.

if you are enthusiastic and are adaptable and can express that to a 
prospective employer you might get into what you want. I think attitude 
and life experience are your catches for trying to get a role. Broaden 
your scope for the time being to allow you to get a toe in and then start 
working on the career path

A lot on the list here started out in some sort of entry role, the younger 
ones via hep desk or PC support roles and older ones via operator or grad 
programmer roles.

Cheers

--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=

This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 






"Tim Gorman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
23-05-2002 11:43 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Fax to: 
Subject:Re: newbie seeks career direction: become a DBA or DEVELOPER?


Sherry,

Sounds like good advice.  There is no way of actually knowing, but I'm 
sure
that the vast majority of DBAs on this list were systems- and
applications-developers first.  I still consider myself a "C" programmer
first and foremost even though nobody cares about "C" anymore, and just
about everything I learned that was undocumented was due to an 
understanding
of how "C" programs (like Oracle) work on UNIX (itself written in "C").  I
didn't make the switch to DBA until about 8 years ago, after about 10 
years
as a developer and sysadmin...

Of course, if you want to be the life of the party, be a dessert chef.  My
younger brother starts discussing the chocolate-chipotle-hazelnut-endive
tarts he made the other day, and instantly he is the center of attention.
Try doing that by discussing session waits...(yawn)...

-Tim

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 6:33 PM


> Hi gurus,
> I have taken a few Oracle DBA courses at UCLA Extension, passed my first
DBA
> certification exam, but have not been able to find an entry level 
position
> in this area. (My background is in printing and marketing... big career
> move...  I've been told my "timing is bad" cause the job market is bad
> here).
> It was suggested to me, by someone at the LA Oracle User Group meeting,
that
> I become an Oracle Developer first. Is this the path you recommend?
> Although I liked the UCLA classes, I was dissappointed that the Career
> Center was off limits to the Extension students. Can you suggest any
> better/cheaper classes in Southern California? Any with career 
placement?
> I have acquired many of the books that have been suggested in these
postings
> and have learned much by being a subscriber to this mailing list.
> Thanks in advance!
> SL
>
>
> _
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sherry Lopata
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California  

RE: Installing an app on a French configured server

[John Dunn]

Stephane

How do we make the character set  French?(WE8ISO8859P15) on our test
database? 
(Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).

Is this something that has to be done when installing Oracle, or when
creating the database(SID)? If so, how do we specify that we want this
character set?

Or can we change an existing installation or database?

Any assistance appreciated

John Dunn


> -Original Message-
> From: Stephane Faroult [SMTP:[EMAIL PROTECTED]]
> Sent: 16 May 2002 21:24
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Installing an app on a French configured server
> 
> Barry Deevey wrote:
> > 
> > Hello all,
> > 
> > There is a requirement to install our application at a site that will
> have
> > both Oracle (8.1.7) & Unix (AIX 5.1) configured in the French language.
> > 
> > Can anybody please advise me of anything that I need to be aware of in
> > relation to the differences between an English & French configuration??
> > 
> > Any help is greatly appreciated.
> > 
> > Best Regards,
> > 
> > Barry.
> 
> o Character sets (likely to be WE8ISO8859P15 in France - accents plus
> euro character)
> o Beware of tests on dates, especially if the day matters
> o Subtle but annoying, numbers. The default decimal character is a comma
> in France, and you sometimes (although rarely) meet a dot as separator
> for thousands. Can be a big problem when loading data from external
> sources - or generating files to be loaded say into Excel.
> 
> And Oracle error messages in French are totally ununderstandable, even
> to the French.
> 
> HTH,
> 
> Stephane Faroult
> Oriole Software
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stephane Faroult
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

news server

[Yechiel Adar]

I am looking for the address of oracle news server.

Yechiel Adar
Mehish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-01595

[Mark Leith]

It looks like you only have 1 extent within the system rollback segment
anyway?

Why are you trying to shrink it? Do you have other rollback segments in
place?

-Original Message-
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L


The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1) which is
being
freed


-Message d'origine-
De: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Date:   mercredi 22 mai 2002 16:29
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

Gilbert - The oerr utility says the key part is the accompanying
message.
Can you forward the accompanying messgage?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback segment
(string))

I got this error when I tryed to shrink the rollback segment system,

What can I do to solve this problem, optiman does'nt solve it.

thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle RAC and NAS

[Stefan Jahnke]

Hello everybody,

I was wondering if anybody has real "hands-on" experience with either a
combination of both RAC and NAS or just running 9i on an NAS. What are the
pros and cons ? Does anybody have some input on this topic ? Maybe some
helpful links besides technet ?

TIA
Stefan


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Installing an app on a French configured server

[Jack van Zanen]

Hi


Character set is choosen at database creation time (create database
statement).
It can not be changed later unless export recreate import is an option


Jack


   

  John Dunn

 
  co.uk>   cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE: Installing an app on a 
French configured server   
  [EMAIL PROTECTED] 

   

   

  23-05-2002 13:28 

  Please respond to

  ORACLE-L 

   

   




Stephane

How do we make the character set  French?(WE8ISO8859P15) on our test
database?
(Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).

Is this something that has to be done when installing Oracle, or when
creating the database(SID)? If so, how do we specify that we want this
character set?

Or can we change an existing installation or database?

Any assistance appreciated

John Dunn


> -Original Message-
> From:Stephane Faroult [SMTP:[EMAIL PROTECTED]]
> Sent:16 May 2002 21:24
> To:Multiple recipients of list ORACLE-L
> Subject: Re: Installing an app on a French configured server
>
> Barry Deevey wrote:
> >
> > Hello all,
> >
> > There is a requirement to install our application at a site that will
> have
> > both Oracle (8.1.7) & Unix (AIX 5.1) configured in the French language.
> >
> > Can anybody please advise me of anything that I need to be aware of in
> > relation to the differences between an English & French configuration??
> >
> > Any help is greatly appreciated.
> >
> > Best Regards,
> >
> > Barry.
>
> o Character sets (likely to be WE8ISO8859P15 in France - accents plus
> euro character)
> o Beware of tests on dates, especially if the day matters
> o Subtle but annoying, numbers. The default decimal character is a comma
> in France, and you sometimes (although rarely) meet a dot as separator
> for thousands. Can be a big problem when loading data from external
> sources - or generating files to be loaded say into Excel.
>
> And Oracle error messages in French are totally ununderstandable, even
> to the French.
>
> HTH,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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

Re: New bee: How to convert 'LONG' data

[Thomas Day]

Use a cursor.  Select the data into the cursor from 'x' and then insert it
into 'y'.

---
CREATE TABLE Y (
Y_IDNUMBER(10),
Y_LONG  LONG,
);
--
cursor x_cursor is
  select
X_ID
  , X_LONG
  from X;
--
BEGIN
 For Y_ROW IN X_CURSOR LOOP
  INSERT INTO Y
  (
   Y_ID
  ,Y_LONG
  )
  VALUES
  (
   Y_ROW.X_ID
  ,Y_ROW.X_LONG
  );
 END LOOP;
END;
/


   

Sridhar

Moparthy To: Multiple recipients of list ORACLE-L  



rthy cc:   

@wcom.com>   Subject: New bee: How to convert 'LONG' 
data  
Sent by: root  

   

   

05/22/2002 

06:03 PM   

Please 

respond to 

ORACLE-L   

   

   





Hi,

I have a table 'x' with one of the column as 'LONG'
I would like to copy the data from the above table 'x' into a different
table 'Y' with the same structure.

When I tried "insert into x select * from y" I am getting
"Illegal use of LONG data type".

Could any one please help me to move the data?


Thanks
Sridhar.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sridhar Moparthy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Warehouse experts, a simple question for you| Outdated?

[Rachel Carmichael]

Dennis,

I have on my desk, all in varying stages of being read: 
Inmon's book Building the Data Warehouse (very understandable)

Kimball's articles from his site and from the Intelligententerprise.com
site (somewhat understandable, I think you need a base from which to
read his articles). His books are on order and should arrive today

Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
started, as Tim tells me to read it AFTER I have a basic understanding
of data warehousing)

The Oracle8i Data Warehousing documentation (actually pretty readable
and understandable)

Ya think I might be over-researching this stuff and panicking a bit?

Rachel

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Ian, 
> 
>   - In the beginning was the data warehouse and yeah it was good. It
> would
> solve all corporate problems and would encompass all corporate data
> so all
> corporate minions would see the same data.
>   - But yeah it took so long to create the corporate data warehouse
> that
> management despaired and canceled the project. Or by the time the
> monster
> data warehouse came blinking and straining into the daylight all the
> users
> said that the company had evolved in the meanwhile and the warehouse
> was
> obsolete.
>   - So data warehouses gained a bad rep from corporate managers and
> yeah
> none would fain to propose the conception of a data warehouse for
> fear of
> castigation.
>   - Then some marketing interns bribed a DBA to send them data
> weekly. And
> they stored this data in a database and lo, their superiors were
> impressed.
>   - Everyone was in awe of the marketing database, but none dared
> tarnish it
> by speaking the name which shall not be mentioned, so it was
> christened a
> "data mart".
>   - And lo, the data marts multiplied and were fruitful. And the DBA
> cursed
> the day she was weak and did give data to the marketing interns.
>   - Then another prophet did arise and did challenge the prophet
> Kimball.
> His name was Inmon. And he did claim to be the progenitor of data
> warehouses. And therefore all should do data warehousing his way and
> use his
> terms.
>   - And great confusion arose over the land. And many debates ensued,
> including some face to face between Inmon and Kimball. And terms such
> as
> Operational Data Store (ODS) were bandied about.
>   - And some said that queries against the ODS were acceptable and
> others
> deemed them forbidden. And some said that if it looks like a data
> warehouse
> and smells like a data warehouse it verily indeed is a data
> warehouse.
>   - And consultants warred against consultants and did call the other
> consultants ignoramuses in front of management such that nobody knew
> what
> anybody was talking about.
>   - And the DBAs said that creating a data warehouse or data mart was
> not
> nearly as hard as figuring out what to call it.
> 
> The moral of the story is to figure out what you need to do and be
> aware
> that different authors use the same terms for different purposes and
> coin
> their own terms. Personally, I have understood everything that
> Kimball has
> written and have never been able to read one of Inmon's articles to
> the end.
> But maybe that is just me.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> Sent: Wednesday, May 22, 2002 2:38 PM
> To: Multiple recipients of list ORACLE-L
> Outdated?
> 
> 
> Ian,
> 
> Good question.  I think that I've seen more recenct references in
> articles
> that state the current thinking of DW/DM.  I'm sure that I've seen
> Inmon
> refer to them that way, or maybe it was Richard Winter?
> 
> Anyway, I guess that part is a bit dated.  There is so much good 
> information
> in that book though, that it's still worth its weight in gold.  You
> won't 
> find too many
> publications for $60 that will take you step by step through building
> an 
> entire
> data warehouse, including the infrastructure.
> 
> Jared
> 
> 
> 
> 
> 
> 
> "MacGregor, Ian A." <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/21/2002 05:48 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Data Warehouse experts, a simple question
> for
> you| Outdated?
> 
> 
> I am new to his books, three chapters in.  The first release of the
> "Data 
> Warehouse Toolkit"  defines a data warehouse much as a data mart is
> today. 
>  Today we think of a data warehouse as having a highly normalized 
> structure which stores information from various sources.  We build
> data 
> marts with structures optimized for querying; e.g., star schemas,
> from the 
>  warehouse.  Kimball writes of the warehouse itself being based on a
> star 
> schema.
> 
> The term data warehouse has not been immutable over the years.  It
> was 
> probably defined exactly as he has done when the book was first
> written. 
> Do his new books redefine "data warehouse"? 
> 
>

RE: ORA-01595

[Bernard, Gilbert]

I am trying to do this.
alter rollback segment SYSTEM shrink;
alter rollback segment R01 shrink;
alter rollback segment R02 shrink;
alter rollback segment R03 shrink;
alter rollback segment R04 shrink;
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1) which is
being
freed

And only on rollback system I got an error.  There are no transcations in
this RBS.
Any Idea.




-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date:   jeudi 23 mai 2002 13:33
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

It looks like you only have 1 extent within the system rollback
segment
anyway?

Why are you trying to shrink it? Do you have other rollback segments
in
place?

-Original Message-
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L


The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1)
which is
being
freed


-Message d'origine-
De: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Date:   mercredi 22 mai 2002 16:29
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

Gilbert - The oerr utility says the key part is the
accompanying
message.
Can you forward the accompanying messgage?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback segment
(string))

I got this error when I tryed to shrink the rollback segment
system,

What can I do to solve this problem, optiman does'nt solve
it.

thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
San Diego, California-- Public Internet access /
Mailing
Lists


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
San Diego, California-- Public Internet access /
Mailing
Lists


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (8

RE: newbie seeks career direction: become a DBA or DEVELOPER?

[Jamadagni, Rajendra]

Sherry,

I followed the same path, started as a developer and was interested in DBA
duties from the beginning. So, when a position opened up, they gave me the
choice and I took the offer. By then they knew what I could (and couldn't)
do, and so we both had a win win situation.

and I am glad to be on this side of the table.
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


***1

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.

***1

Re: Oracle Application Consultants - Austin, TX

[Rachel Carmichael]

if travel is 100% why does it matter WHERE you are local to?


--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> ...and you have to share a single motel room with 11 other people (3
> shifts
> of four), surrender accumulated frequent-flyer miles to the client,
> provide
> your own chair, laptop, and printer, and spend weekends onsite until
> project
> completion...
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 22, 2002 5:52 PM
> 
> 
> > Oracle Application Consultants - Austin, TX
> >
> > Experience with the CRM Sales Online module a MUST
> >
> > Candidate should be able to travel 100% and be local to the DFW or
> > Austin, TX areas. Candidates seeking permanent employment are
> preferred
> > but all resumes will be considered.
> >
> > If candidate is seeking a perm position, salary is negotiable. If
> > candidate is seeking contract work, rate will be $50-60 per hour
> plus
> > expenses, interviews to commence immediately.
> >
> > My client does not offer relocation reimbursement or H1B
> Sponsorship.
> >
> > To apply, send resume and salary/hourly requirement to
> [EMAIL PROTECTED]
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.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).

Re: newbie seeks career direction: become a DBA or DEVELOPER?

[Rachel Carmichael]

Mladen,

You? Sarcastic? Never :)


--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> 
> O
> > if you are enthusiastic and are adaptable and can express that to a
> > prospective employer you might get into what you want. I think
> > attitude
> 
> My advice to those who want to become DBAs is that they shouldn't be 
> overly
> concerned if they feel a pang of enthusiasm: it will pass. Healthy 
> sarcasm
> is, most definitely, a necessary precondition for becoming a good
> DBA.
> I developed it into an art form.
> 
> -- 
> Mladen Gogala
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.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).

AW: Installing an app on a French configured server

[v . schoen]

I think in 8i there is a command for altering characterset. Look in docu for
alter database or alter instance. You should be careful when doing this.

regards

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Jack van Zanen [mailto:[EMAIL PROTECTED]]
Gesendet: Thursday, May 23, 2002 2:38 PM
An: Multiple recipients of list ORACLE-L
Betreff: RE: Installing an app on a French configured server



Hi


Character set is choosen at database creation time (create database
statement).
It can not be changed later unless export recreate import is an option


Jack


 

  John Dunn

 
  co.uk>   cc:   (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE: Installing an
app on a French configured server   
  [EMAIL PROTECTED]

 

 

  23-05-2002 13:28

  Please respond to

  ORACLE-L

 

 




Stephane

How do we make the character set  French?(WE8ISO8859P15) on our test
database?
(Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).

Is this something that has to be done when installing Oracle, or when
creating the database(SID)? If so, how do we specify that we want this
character set?

Or can we change an existing installation or database?

Any assistance appreciated

John Dunn


> -Original Message-
> From:Stephane Faroult [SMTP:[EMAIL PROTECTED]]
> Sent:16 May 2002 21:24
> To:Multiple recipients of list ORACLE-L
> Subject: Re: Installing an app on a French configured server
>
> Barry Deevey wrote:
> >
> > Hello all,
> >
> > There is a requirement to install our application at a site that will
> have
> > both Oracle (8.1.7) & Unix (AIX 5.1) configured in the French language.
> >
> > Can anybody please advise me of anything that I need to be aware of in
> > relation to the differences between an English & French configuration??
> >
> > Any help is greatly appreciated.
> >
> > Best Regards,
> >
> > Barry.
>
> o Character sets (likely to be WE8ISO8859P15 in France - accents plus
> euro character)
> o Beware of tests on dates, especially if the day matters
> o Subtle but annoying, numbers. The default decimal character is a comma
> in France, and you sometimes (although rarely) meet a dot as separator
> for thousands. Can be a big problem when loading data from external
> sources - or generating files to be loaded say into Excel.
>
> And Oracle error messages in French are totally ununderstandable, even
> to the French.
>
> HTH,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 originee

Re: ORA-2085

[Hemant K Chitale]

I'd never have thought that this was possible
in Advanced Replication

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 12:48 AM


> At last something that I have experience in.
>
> Just do the following:
>
> On the target database issue the following:
> Alter database rename global_name to donot_trigger;
>
> We had the same problem. This solves it.
> The global name has no other influence.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, May 21, 2002 6:08 PM
>
>
> > Yes, I "inherited" this, and I am setting up Multimaster
> > Advanced Replication, setting global_names=false isn't an
> > option.  I have suggested moving the donotfiretrigger logic
> > into the trigger, which has some initial support.  For the
> > moment, we are changing the code to point to a link with the
> > same name as the service name (which has obvious limitations,
> > so hopefully a real fix will get done).
> >
> > I was really hoping there might be another workaround bandaid
> > though, as I really don't want the "fix" to end up permanent.
> >
> > Thanks,
> >
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> >
> >
> >
> > -Original Message-
> > Sent: Tuesday, May 21, 2002 11:23 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > My guess is that you "inherited" an environment
> > where the DB-Link was setup that way [link-name different
> > from DB-name] . and then, sometime later,
> > you set GLOBAL_NAMES=TRUE
> >
> > Well you have no choice :
> > "// *Action: create a database link with the same name as the database
it
> > > //  connects to, or set global_names=false."
> >
> > Are you setting up Advanced Replication [MultiMaster]
> > or Simple Replication [Snapshots] ?  I believe that
> > Simple Replication does not mandate GLOBAL_NAMES=TRUE.
> >
> >
> > Hemant K Chitale
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, 21 May, 2002 9:23 PM
> >
> >
> > > Hi all.
> > >
> > > I have recently had to enable global_names in order to set up a
> > > replicated environment.  The application uses a database link to
> > > reconnect to the database under a differant user id (I inheirited
> > > this, I had nothing to do with the design!).  Appearantly,
> > > global_names has a prblem with this...
> > >
> > > SQL>  select * from [EMAIL PROTECTED];
> > > select * from [EMAIL PROTECTED]
> > >*
> > > ERROR at line 1:
> > > ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD
> > >
> > > SQL> !oerr ORA 2085
> > > 02085, 0, "database link %s connects to %s"
> > > // *Cause: a database link connected to a database with a different
> name.
> > > //  The connection is rejected.
> > > // *Action: create a database link with the same name as the database
it
> > > //  connects to, or set global_names=false.
> > >
> > > So, does anybody have any work arounds or ideas how I can get this
> > > thing working again?
> > >
> > > TIA,
> > >
> > > John P Weatherman
> > > Database Administrator
> > > Replacements Ltd.
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: John Weatherman
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Hemant K Chitale
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: John Weatherman
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > --

Re: 8.1.7.4

[Hemant K Chitale]

Nope.  .4 is supposed to be the last PSR (patchset release)
for 8.1.7

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 4:33 AM


>
> I hear that .5 is right around the corner.
>
> Vinny
>
>
> --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > I thought that .3 was the final patch.  I guess they found more stuff
that
> > needed fixing.
> >
> > Ruth
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 21, 2002 8:58 PM
> >
> >
> > > Has anyone patched up to 8.1.7.4 yet???
> > >
> > > Anything we should be aware of???
> > >
> > > Regards,
> > >
> > > Sujatha
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Sujatha Madan
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>
> __
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vincent Cimino
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename Column in 9iR2

[Hemant K Chitale]

An upgrade wouldn't cost anything.  It would be free
as part of your support contract.

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 2:41 AM


Kevin,
 I appreciate your testing efforts. Now to convince the bean-counters
to upgrate to 9i.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 02:08PM >>>
I reran my test. with 250,000 rows in the table. It took a whopping
0.25
seconds to complete.

-Original Message-
Sent: Wednesday, May 22, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Kevin,
 Yes but does it work with data in the column?, I do not have 9i set
up
yet. If it works as you describe with data in the column it will
really
help with the multi million row tables that "they" want to rename a
column  after a release of a new lotto game.
thanks,
for the test and update.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 10:38AM >>>
Summary: it works!

SQL> SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL> create table test_table (wrong_name VARCHAR2(40));

Table created.

SQL> alter table test_table rename column wrong_name to right_name;

Table altered.

SQL> desc test_table;
 Name  Null?Type
 - 

 RIGHT_NAME VARCHAR2(40)

SQL>

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant
Confidential
and may be legally privileged. It is intended solely for the
addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in
reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This
message and
its attachments could have been infected during transmission. By
reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Trilegiant Corporation is not liable for any loss or
damage
arising in any way from this message or its attachments.




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list yo

RE: ORA-01595

[Mark Leith]

How large are the rollback segments?

The ORA-01594 error states:

attempt to wrap into rollback segment (string) extent (string) which is
being freed

Cause: Undo generated to free a rollback segment extent is attempting to
write
into the same extent due to small extents and/or there are too many extents
to
free.

Action: The rollback segment shrinking will be rolled back by the system;
increase the optimal size of the rollback segment.

Can you try increasing the OPTIMAL parameter for the SYSTEM rollback
segment? Typically the SYSTEM rollback segment is created much smaller than
the "public" rollback segments..

  1  select segment_name,
  2  initial_extent,
  3  next_extent,
  4  status
  5* from dba_rollback_segs
sales>/

SEGMENT_NAME   INITIAL_EXTENT NEXT_EXTENT STATUS
-- -- --- --
SYSTEM  57344   57344 ONLINE
RBS0   524288  524288 ONLINE
RBS1   524288  524288 ONLINE
RBS2   524288  524288 ONLINE
RBS3   524288  524288 ONLINE
RBS4   524288  524288 ONLINE
RBS5   524288  524288 ONLINE
RBS6   524288  524288 ONLINE

alter rollback segment system storage(optimal 'X'M)

HTH

Mark

-Original Message-
Gilbert
Sent: 23 May 2002 14:18
To: Multiple recipients of list ORACLE-L


I am trying to do this.
alter rollback segment SYSTEM shrink;
alter rollback segment R01 shrink;
alter rollback segment R02 shrink;
alter rollback segment R03 shrink;
alter rollback segment R04 shrink;
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1) which is
being
freed

And only on rollback system I got an error.  There are no transcations in
this RBS.
Any Idea.




-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date:   jeudi 23 mai 2002 13:33
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

It looks like you only have 1 extent within the system rollback
segment
anyway?

Why are you trying to shrink it? Do you have other rollback segments
in
place?

-Original Message-
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L


The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1)
which is
being
freed


-Message d'origine-
De: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Date:   mercredi 22 mai 2002 16:29
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

Gilbert - The oerr utility says the key part is the
accompanying
message.
Can you forward the accompanying messgage?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback segment
(string))

I got this error when I tryed to shrink the rollback segment
system,

What can I do to solve this problem, optiman does'nt solve
it.

thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
San Diego, California-- Public Internet access /
Mailing
Lists


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858)

Re: news server

[Mladen Gogala]

On 2002.05.23 07:08 Yechiel Adar wrote:
> I am looking for the address of oracle news server.
metalink.oracle.com
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RESEND: clog error from fatcity, RH 73 and 9ir2

[JOE TESTA]

Ok i blew away rh 7.2 on laptop last night, did a plain install of rh 
7.3
 
did the install of 9ir2 afterwards
 
here is the only issue i've come up with:
 
 
Problem: Context option would not link, click ignore and let the installer 
go on its merry way
Solution:  
   1.  As root, cd /lib
   2.  rm libnsl.so.1
   3.  ln -s $ORACLE_HOME/lib/stubs/libnsl-2.2.2-stub.so 
libnsl.so.1
IMPORTANT 
NOTE
    OPEN A DIFFERENT WINDOW TO LOGIN IN AS ORACLE FOR STEP 
4, DO NOT CLOSE THE 
   WINDOW THAT YOU'RE LOGGED IN AS ROOT, 
OTHERWISE YOU WONT BE ABLE TO SU 
    TO ROOT OR LOGIN FROM ANOTHER 
WINDOW ONCE YOU DID STEP3.  IF YOU HAPPEN 
    TO CLOSE THAT WINDOW, YOU'LL 
NEED TO CUT POWER, BRING LINUX UP IN SINGLE 
    USER MODE TO DO STEP 7.

   4.  As oracle user
   5.  (set up ORACLE_HOME, etc).
   6.  relink all
   7.  If successful, as root, cd /lib; rm libnsl.so.1
   8   still as root:  ln -s libnsl-2.2.5-so 
libnsl.so.1
 
 
any questions, shoot them to me at [EMAIL PROTECTED]

Oracle to DB2 (OS/390) gateways

[Schauss, Peter]

The Oracle Store lists two products which allow connections
from Oracle to DB2 on a mainframe, Enterprise Integration Gateway and
Mainframe Integration Gateway.  The latter costs more than twice as
much as the former.  Can anyone who has used these products tell me
how I can determine which one I need?

Short of using ODBC drivers, is there a less expensive alternative
which would allow me to query DB2 tables from Oracle.

thanks,

Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RedHat

[Mladen Gogala]

On 2002.05.23 02:23 Santosh Varma wrote:
> I wanted to know what is this RedHat, its significance and its
> features. Any
> links/doc's on that ???
> Thanks and regards,
> 
> Santosh

Red hat is a piece of clothing which makes a fashion statement. It is 
very
impractical during the hot summer days when the SUN is strong. My 
advice is
to forget about clothing and devote your attention to the kitchen 
utensilia,
like the Mandrake cooker.
Plese, do not use Google and enter "Red Hat", "SUN" or "Mandrake" or, 
even worse,
go directly to www.redhat.com, www.mandrake.com or alike. That would be 
outrageous
and totally uncalled for.
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

so when did you switch from NT to unix for oracle

[JOE TESTA]

A question has been posed to me, when to switch from NT to unix for 
oracle.
 
Is it when the NT box starts getting out of memory issues, number of 
transactions, size of db?
 
just looking for some ball park answers.
 
thanks, joe
 

Runaway threads in 8.1.7.3.2 on NT/W2K

[Jeffrey Beckstrom]

We are running Oracle 8.1.7.3.2 on W2K/NT.  
 
We have experienced a problem while applying Oracle Apps patches that CPU 
shot to 100% for 4 threads.  The weird part is that the patch had aborted 
so nothing was running in the database.  Bouncing database cleared the 
problem.  
 
Continued with more patches and noticed CPU running at 25% with nothing 
running.  Again bounced database and back to normal.
 
Latest item we noticed today is that CPU is normal (less than 5%) with no 
users but we have 40 threads showing in task manager.  Did shutdown 
immediate and count only went down to 30.
 
Bounced database and now have 12 threads.  If connect / disconnect, I 
see the count go up and then down again.
 
Looks like Oracle is missing some threads - possibly why during our 
patching of the Oracle Apps we see CPU out of control.
 
We have a TAR on this but so far Oracle is lost regarding the high 
CPU.  Especially given that don't have it right now.  Hoping the extra 
threads will point to something.
 
 
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

Re: newbie seeks career direction: become a DBA or DEVELOPER?

[Mladen Gogala]

On 2002.05.23 07:03 "Farnsworth, Dave" wrote:
> Or you can go straight into damagement.  It requires no technical
> skills, no people skills and the innate ability to royally screw
> things up.  Upon completion of screwing things up, leaving a mess for
> the DBA to cleanup, you then are promoted to a higher level damagement
> position with a pay raise.
> 
Well, being a technically skilled expert helps even with the damagement
There is a guy that I know,who was promoted to the damagement and then 
has
spent his days in vi editor and C++-compiler. Needless to say, he 
didn't do
very much for the rest of us, techies.
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle Application Consultants - Austin, TX

[Tim Gorman]

because they use vans instead of airplanes?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 7:23 AM


> if travel is 100% why does it matter WHERE you are local to?
> 
> 
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > ...and you have to share a single motel room with 11 other people (3
> > shifts
> > of four), surrender accumulated frequent-flyer miles to the client,
> > provide
> > your own chair, laptop, and printer, and spend weekends onsite until
> > project
> > completion...
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 22, 2002 5:52 PM
> > 
> > 
> > > Oracle Application Consultants - Austin, TX
> > >
> > > Experience with the CRM Sales Online module a MUST
> > >
> > > Candidate should be able to travel 100% and be local to the DFW or
> > > Austin, TX areas. Candidates seeking permanent employment are
> > preferred
> > > but all resumes will be considered.
> > >
> > > If candidate is seeking a perm position, salary is negotiable. If
> > > candidate is seeking contract work, rate will be $50-60 per hour
> > plus
> > > expenses, interviews to commence immediately.
> > >
> > > My client does not offer relocation reimbursement or H1B
> > Sponsorship.
> > >
> > > To apply, send resume and salary/hourly requirement to
> > [EMAIL PROTECTED]
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like
> > subscribing).
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Tim Gorman
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Installing an app on a French configured server

[Mark Leith]

It should be noted that this only alters a character set that is a *SUBSET*
of the current character set. You cannot do something like change from a
Russian character set to a Japanese one for instance.

There is a document that provides a compatibility matrix - something like
"Oracle National Language Guide" that should be easy to find on OTN.

HTH

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 23 May 2002 14:28
To: Multiple recipients of list ORACLE-L


I think in 8i there is a command for altering characterset. Look in docu for
alter database or alter instance. You should be careful when doing this.

regards

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Jack van Zanen [mailto:[EMAIL PROTECTED]]
Gesendet: Thursday, May 23, 2002 2:38 PM
An: Multiple recipients of list ORACLE-L
Betreff: RE: Installing an app on a French configured server



Hi


Character set is choosen at database creation time (create database
statement).
It can not be changed later unless export recreate import is an option


Jack




  John Dunn

  
  co.uk>   cc:   (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE: Installing an
app on a French configured server
  [EMAIL PROTECTED]





  23-05-2002 13:28

  Please respond to

  ORACLE-L








Stephane

How do we make the character set  French?(WE8ISO8859P15) on our test
database?
(Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).

Is this something that has to be done when installing Oracle, or when
creating the database(SID)? If so, how do we specify that we want this
character set?

Or can we change an existing installation or database?

Any assistance appreciated

John Dunn


> -Original Message-
> From:Stephane Faroult [SMTP:[EMAIL PROTECTED]]
> Sent:16 May 2002 21:24
> To:Multiple recipients of list ORACLE-L
> Subject: Re: Installing an app on a French configured server
>
> Barry Deevey wrote:
> >
> > Hello all,
> >
> > There is a requirement to install our application at a site that will
> have
> > both Oracle (8.1.7) & Unix (AIX 5.1) configured in the French language.
> >
> > Can anybody please advise me of anything that I need to be aware of in
> > relation to the differences between an English & French configuration??
> >
> > Any help is greatly appreciated.
> >
> > Best Regards,
> >
> > Barry.
>
> o Character sets (likely to be WE8ISO8859P15 in France - accents plus
> euro character)
> o Beware of tests on dates, especially if the day matters
> o Subtle but annoying, numbers. The default decimal character is a comma
> in France, and you sometimes (although rarely) meet a dot as separator
> for thousands. Can be a big problem when loading data from external
> sources - or generating files to be loaded say into Excel.
>
> And Oracle error messages in French are totally ununderstandable, even
> to the French.
>
> HTH,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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,

Re: RedHat

[Steven Lembark]

-- Santosh Varma <[EMAIL PROTECTED]>

> I wanted to know what is this RedHat, its significance and its features.
> Any links/doc's on that ???

It is the most common "corporate" Linux distribution out
there. The people at RH worked with Oracle, IBM, Sybase,
and other package vendors to help them port their various
products to linux. Net result is that RH is the "standard"
distro for most packages to be vetted on for linux.

The distribution has some tradeoffs. It is generally easier
to manage than the others but doesn't match Mandrake for
capacity to locate and correctly configure new equipment.
If you need speed, Mandrake is probably a better bet.

Information on linux in general and the varous distro's
are available at www.linux.org, www.redhat.com, www.tummy.com,
or under varous points on your favorite search engine.


--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA_ENCRYPT_LOGIN

[Richard Huntley]

Title: RE: ORA_ENCRYPT_LOGIN





Hmm...after trying to verify password being passed as plain text, I went back to
do some research on metalink, and it looks like encryption of passwords is done
by default in 8.1.5 (Net8) and higher.  Only confusion now is whether I need to
set ORA_ENCRYPT_LOGIN = TRUE only in sqlnet.ora on the client or also in the 
NT registry.  Guess I'll go look through the docs on this and I'll send an update
if I find a definitive answer.  Thanks for the replies.


-Original Message-
From: Rahul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 12:33 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA_ENCRYPT_LOGIN



could not say about the net8, but in oracle 7 clients, if the initial login
fails, the client will do the *next*
login attempt  using  *plain text* as password !!! but if this param is set
to TRUE, all the attempts are 
done using an encrypted password. 


set ORA_ENCRYPT_LOGIN = TRUE , in the correct ORACLE_HOME using regedit (if
on windows) 
turn the tracing level to 16, try to connect and see the trace file, u wud
see the userid in plain text but thepassword will be
encrypted...



> --
> From:     MacGregor, Ian A.[SMTP:[EMAIL PROTECTED]]
> Reply To:     [EMAIL PROTECTED]
> Sent:     Thursday, May 23, 2002 2:52 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: ORA_ENCRYPT_LOGIN
> 
> If you want to be absolutely sure the password is being encrypted, you'll
> need to place a sniffer on the network.  Work with your network guys and
> whoever else needs to be involved.   In most company's  using an
> unauthorized sniffer will  result in dismissal. 
>  
> Let me reinterate what I stated.  SQL*NET encrypts passwords even if the
> ORA_ENCRYPT_LOGIN parameter is not set to TRUE  I wouldn't label it strong
> encryption.  If you really need that there is the Advanced Security
> Option.  
>  
>  I'm not 100% sure when the passwrod is sent in the clear.   It is never
> sent  plain text when the ORA_ENCRYPT_L0gin parameter is set to TRUE.  I
> believe it will be sent in the clear if the Oracle server side of SQL*NET
> is incapable of handling encrypted passwords and ORA_ENCRYPT_LOGIN  is
> set to false. ( I cannot , off the top of my head, remember if the
> parameter takes YES/NO or TRUE/FALSE).
>  
> The first thing I would do is ensure ORA_ENCRYPT_LOGIN  is true for all
> clients.
>  
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
>  
>  
> 
>   -Original Message-
>   From: Richard Huntley [mailto:[EMAIL PROTECTED]]
>   Sent: Wednesday, May 22, 2002 9:59 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: ORA_ENCRYPT_LOGIN
> 
> 
>   That's exactly what I want to stop, passwords being sent in the
> clear.  However, I'm not able to verify it's working so far. I've turned
> on tracing, as recommended in another reply on this topic, did a login
> before enabling then after enabling this parameter and the differences are
> very minor and I'm seeing nothing that specifically points
>   to this parameter being used other than output saying the parameter
> is detected.  How are you all having developers connect to the production
> box via SQL*Plus client on developer workstations, so that the password is
> not sent in the clear?
>    
>   -Original Message-
>   From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
>   Sent: Tuesday, May 21, 2002 8:18 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: ORA_ENCRYPT_LOGIN
> 
> 
>   Even without this parameter being set the password is encrypted.
> What the parameter does is stop the password from being sent in the clear
> if logging in with the encrypted password fails.   I believe the
> encryption is a 54-bit  variant of DES.  It is very rare that  someone
> improves DES by fiddling with it.  It also always encrypts to the same
> value and provides no protection against replay attacks.
>    
>   Ian MacGregor
>   Stanford Linear Accelerator Center
>   [EMAIL PROTECTED]
> 
>       -Original Message-
>       From: Richard Huntley [mailto:[EMAIL PROTECTED]]
>       Sent: Tuesday, May 21, 2002 9:34 AM
>       To: Multiple recipients of list ORACLE-L
>       Subject: ORA_ENCRYPT_LOGIN
> 
> 
>       Anyone using this and if so, do you know of a way to verify
> that the password is actually being encrypted?
>    
>       Thanks.
> 
> 
-- 
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

Re: 8.1.7.4

[Mladen Gogala]

I heard that too, but I think that they'll be weighing their options.
If 8.1.7.4 is messed up badly, they'll probably give us 8.1.7.5 for
Christmas.

On 2002.05.23 09:33 Hemant K Chitale wrote:
> 
> Nope.  .4 is supposed to be the last PSR (patchset release)
> for 8.1.7
> 
> Hemant K Chitale
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, 23 May, 2002 4:33 AM
> 
> 
> >
> > I hear that .5 is right around the corner.
> >
> > Vinny
> >
> >
> > --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > > I thought that .3 was the final patch.  I guess they found more
> stuff
> that
> > > needed fixing.
> > >
> > > Ruth
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, May 21, 2002 8:58 PM
> > >
> > >
> > > > Has anyone patched up to 8.1.7.4 yet???
> > > >
> > > > Anything we should be aware of???
> > > >
> > > > Regards,
> > > >
> > > > Sujatha
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Sujatha Madan
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
> Lists
> > > > 
> 
> > > > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You
> may
> > > > also send the HELP command for other information (like
> subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> Lists
> > > 
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You
> may
> > > also send the HELP command for other information (like
> subscribing).
> >
> >
> > __
> > Do You Yahoo!?
> > LAUNCH - Your Yahoo! Music Experience
> > http://launch.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Vincent Cimino
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Hemant K Chitale
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

screen shots of Oracle installer in action?

[John Dunn]

Does any one have or know of any documents on the Web that contain screen
shots of the Oracle installer in action(Preferably 8i Enterprise Edition on
AIX)?

I need to to include these in some documentation, but don't really want to
do an install just to get some screen shots?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename Column in 9iR2

[Ron Rogers]

Hemant,
  The price I am referring to is the cost involved with moving from a
Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
company sided issues that have to be addressed and cases made for the
move. In this case the software is not an issues as you stated, the
issues revolve around the hardware and developmental considerations. I
would be more that happy to move to the latest and greatest "solid"
platform/database combination. It would allow us to create and implement
browser based applications rather easily and would allow us to use the
9iAS Suite of products.
 For now all I can do is make requests for item to be included in the
budget as we move "forward, backwards, sideways, dance on circles".
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 09:38AM >>>

An upgrade wouldn't cost anything.  It would be free
as part of your support contract.

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 2:41 AM


Kevin,
 I appreciate your testing efforts. Now to convince the bean-counters
to upgrate to 9i.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 02:08PM >>>
I reran my test. with 250,000 rows in the table. It took a whopping
0.25
seconds to complete.

-Original Message-
Sent: Wednesday, May 22, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Kevin,
 Yes but does it work with data in the column?, I do not have 9i set
up
yet. If it works as you describe with data in the column it will
really
help with the multi million row tables that "they" want to rename a
column  after a release of a new lotto game.
thanks,
for the test and update.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 10:38AM >>>
Summary: it works!

SQL> SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL> create table test_table (wrong_name VARCHAR2(40));

Table created.

SQL> alter table test_table rename column wrong_name to right_name;

Table altered.

SQL> desc test_table;
 Name  Null?Type
 - 

 RIGHT_NAME VARCHAR2(40)

SQL>

Kevin Toepke
[EMAIL PROTECTED] 



The information in this electronic mail message is Trilegiant
Confidential
and may be legally privileged. It is intended solely for the
addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in
reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This
message and
its attachments could have been infected during transmission. By
reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Trilegiant Corporation is not liable for any loss or
damage
arising in any way from this message or its attachments.

--
--


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 PRO

Re:Data Warehouse Hardware Recommendations

[dgoulet]

Mary,

We've been very happy with our mix of HP-9000 series UNIX servers and EMC
disk arrays.  Right now the 1TB warehouse is running on a K570 with 4 processors
and 2 GB of RAM.  The server supports two database instances with no problems. 
We're going to upgrade to a L2000 4 way class machine in the next 2 months for
support reasons only..  One recommendation though, If you go with EMC storage
buy their PowerPath product.  Yes it is more money, but there is one heck of a
disk io performance increase not to mention that it makes the server and array
much more fault tolerant.

Dick Goulet

Reply Separator
Author: "Mark Brooks" <[EMAIL PROTECTED]>
Date:   5/22/2002 8:08 PM

Our data warehouse box is nearing it's max capacity so we are looking for
options for an upgrade. The current box is maxed out so it will be a
forklift upgrade. Since we are less than satisfied with our current vendor
we are open to changing platforms. I don't want to mention the current
vendor so as not to prejudice any suggestions. What I would like to know is
what hardware (server and storage) folks are using for their data warehouse.
We are projecting our system to be around 10TB by the end of this year with
continued growth (3-5yr) projected at 70TB.

Thanks

MB


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Brooks
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

TEST

[RAJESH DAYAL]

Title: TEST






TEST 

RE: ORA_ENCRYPT_LOGIN

[Richard Huntley]

Title: RE: ORA_ENCRYPT_LOGIN





Here is what the docs have to say...


"By setting the following values, you can require that the password used to verify a connection always be encrypted: 


Set the ORA_ENCRYPT_LOGIN environment variable to TRUE on the client machine. 


Set the DBLINK_ENCRYPT_LOGIN server initialization parameter to TRUE. 


If enabled at both the client and server, passwords will not be sent across the network "in the clear", but will be encrypted using a modified DES (Data Encryption Standard) algorithm. 

The DBLINK_ENCRYPT_LOGIN initialization parameter is used for connections between two Oracle servers (for example, when performing distributed queries). If you are connecting from a client, Oracle checks the ORA_ENCRYPT_LOGIN environment variable. 

Whenever you attempt to connect to a server using a password, Oracle encrypts the password before sending it to the server. If the connection fails and auditing is enabled, the failure is noted in the audit log. Oracle then checks the appropriate DBLINK_ENCRYPT_LOGIN or ORA_ENCRYPT_LOGIN value. If it set to FALSE, Oracle attempts the connection again using an unencrypted version of the password. If the connection is successful, the connection replaces the previous failure in the audit log, and the connection proceeds. To prevent malicious users from forcing Oracle to re-attempt a connection with an unencrypted version of the password, you must set the appropriate values to TRUE."


-Original Message-
From: Richard Huntley 
Sent: Thursday, May 23, 2002 9:14 AM
To: '[EMAIL PROTECTED]'
Subject: RE: ORA_ENCRYPT_LOGIN



Hmm...after trying to verify password being passed as plain text, I went back to
do some research on metalink, and it looks like encryption of passwords is done
by default in 8.1.5 (Net8) and higher.  Only confusion now is whether I need to
set ORA_ENCRYPT_LOGIN = TRUE only in sqlnet.ora on the client or also in the 
NT registry.  Guess I'll go look through the docs on this and I'll send an update
if I find a definitive answer.  Thanks for the replies.


-Original Message-
From: Rahul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 12:33 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA_ENCRYPT_LOGIN



could not say about the net8, but in oracle 7 clients, if the initial login
fails, the client will do the *next*
login attempt  using  *plain text* as password !!! but if this param is set
to TRUE, all the attempts are 
done using an encrypted password. 


set ORA_ENCRYPT_LOGIN = TRUE , in the correct ORACLE_HOME using regedit (if
on windows) 
turn the tracing level to 16, try to connect and see the trace file, u wud
see the userid in plain text but thepassword will be
encrypted...



> --
> From:     MacGregor, Ian A.[SMTP:[EMAIL PROTECTED]]
> Reply To:     [EMAIL PROTECTED]
> Sent:     Thursday, May 23, 2002 2:52 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: ORA_ENCRYPT_LOGIN
> 
> If you want to be absolutely sure the password is being encrypted, you'll
> need to place a sniffer on the network.  Work with your network guys and
> whoever else needs to be involved.   In most company's  using an
> unauthorized sniffer will  result in dismissal. 
>  
> Let me reinterate what I stated.  SQL*NET encrypts passwords even if the
> ORA_ENCRYPT_LOGIN parameter is not set to TRUE  I wouldn't label it strong
> encryption.  If you really need that there is the Advanced Security
> Option.  
>  
>  I'm not 100% sure when the passwrod is sent in the clear.   It is never
> sent  plain text when the ORA_ENCRYPT_L0gin parameter is set to TRUE.  I
> believe it will be sent in the clear if the Oracle server side of SQL*NET
> is incapable of handling encrypted passwords and ORA_ENCRYPT_LOGIN  is
> set to false. ( I cannot , off the top of my head, remember if the
> parameter takes YES/NO or TRUE/FALSE).
>  
> The first thing I would do is ensure ORA_ENCRYPT_LOGIN  is true for all
> clients.
>  
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
>  
>  
> 
>   -Original Message-
>   From: Richard Huntley [mailto:[EMAIL PROTECTED]]
>   Sent: Wednesday, May 22, 2002 9:59 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: ORA_ENCRYPT_LOGIN
> 
> 
>   That's exactly what I want to stop, passwords being sent in the
> clear.  However, I'm not able to verify it's working so far. I've turned
> on tracing, as recommended in another reply on this topic, did a login
> before enabling then after enabling this parameter and the differences are
> very minor and I'm seeing nothing that specifically points
>   to this parameter being used other than output saying the parameter
> is detected.  How are you all having developers connect to the production
> box via SQL*Plus client on developer workstations, so that the password is
> not sent in the clear?
>    
>   -Original Message-
>   From: MacGregor, Ia

RE: ORA-01595

[Bernard, Gilbert]

50K

-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date:   jeudi 23 mai 2002 15:59
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

How large are the rollback segments?

The ORA-01594 error states:

attempt to wrap into rollback segment (string) extent (string) which
is
being freed

Cause: Undo generated to free a rollback segment extent is
attempting to
write
into the same extent due to small extents and/or there are too many
extents
to
free.

Action: The rollback segment shrinking will be rolled back by the
system;
increase the optimal size of the rollback segment.

Can you try increasing the OPTIMAL parameter for the SYSTEM rollback
segment? Typically the SYSTEM rollback segment is created much
smaller than
the "public" rollback segments..

  1  select segment_name,
  2  initial_extent,
  3  next_extent,
  4  status
  5* from dba_rollback_segs
sales>/

SEGMENT_NAME   INITIAL_EXTENT NEXT_EXTENT STATUS
-- -- --- --
SYSTEM  57344   57344 ONLINE
RBS0   524288  524288 ONLINE
RBS1   524288  524288 ONLINE
RBS2   524288  524288 ONLINE
RBS3   524288  524288 ONLINE
RBS4   524288  524288 ONLINE
RBS5   524288  524288 ONLINE
RBS6   524288  524288 ONLINE

alter rollback segment system storage(optimal 'X'M)

HTH

Mark

-Original Message-
Gilbert
Sent: 23 May 2002 14:18
To: Multiple recipients of list ORACLE-L


I am trying to do this.
alter rollback segment SYSTEM shrink;
alter rollback segment R01 shrink;
alter rollback segment R02 shrink;
alter rollback segment R03 shrink;
alter rollback segment R04 shrink;
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1)
which is
being
freed

And only on rollback system I got an error.  There are no
transcations in
this RBS.
Any Idea.




-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date:   jeudi 23 mai 2002 13:33
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

It looks like you only have 1 extent within the system
rollback
segment
anyway?

Why are you trying to shrink it? Do you have other rollback
segments
in
place?

-Original Message-
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L


The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent
(1)
which is
being
freed


-Message d'origine-
De: DENNIS WILLIAMS
[mailto:[EMAIL PROTECTED]]
Date:   mercredi 22 mai 2002 16:29
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

Gilbert - The oerr utility says the key part is the
accompanying
message.
Can you forward the accompanying messgage?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback
segment
(string))

I got this error when I tryed to shrink the rollback
segment
system,

What can I do to solve this problem, optiman does'nt
solve
it.

thanks
--
Please see the official ORACLE-L FAQ:
http://www.orafaq

Re: screen shots of Oracle installer in action?

[Jack van Zanen]

   

  John Dunn

 
  co.uk>   cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  screen shots of Oracle 
installer in action?   
  [EMAIL PROTECTED] 

   

   

  23-05-2002 16:33 

  Please respond to

  ORACLE-L 

   

   








Does any one have or know of any documents on the Web that contain screen
shots of the Oracle installer in action(Preferably 8i Enterprise Edition on
AIX)?

I need to to include these in some documentation, but don't really want to
do an install just to get some screen shots?



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
===


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 53

RE: so when did you switch from NT to unix for oracle

[Karniotis, Stephen]

Hey Joe: 


 

  
I generally switch from NT to Unix when availability becomes a central
issue.  When you can look at the
performance monitor in NT and see that the box is not scaling properly is
another cautionary flag. 
Additionally, people switch when they get frustrated with the
installation and update processes for software upgrades.

 

  I
have, as you do, Oracle on my NT laptop and think that Oracle could do a MUCH
BETTER JOB implementing the software. 
Given that cost is no longer an issue with platform-specific pricing
gone, I guess it is a subjective decision when to switch.

 

Thank
You

 

Stephen
P. Karniotis

Product Architect

Compuware Corporation

Direct:   (248)
865-4350

Mobile:  (248)
408-2918

Email:  [EMAIL PROTECTED]

Web:    www.compuware.com

 

-Original
Message-
From: JOE TESTA
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 9:48
AM
To: Multiple recipients of list
ORACLE-L
Subject: so when did you switch
from NT to unix for oracle

 

A question
has been posed to me, when to switch from NT to unix for oracle.

 

Is it when
the NT box starts getting out of memory issues, number of transactions, size of
db?

 

just looking
for some ball park answers.

 

thanks, joe

 










The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. 

RE: Installing an app on a French configured server

[Jesse, Rich]

Or unless the old characterset is US7ASCII and the new characterset is a
superset of that, like UTF8, WE8ISO8859Px, etc., and you're database is at
least v8.x.

Then you can follow MetaClink article 66320.1, where you just need a few
ALTER DATABASE commands and a few instance bounces.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Jack van Zanen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 23, 2002 7:38 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Installing an app on a French configured server
> 
> 
> 
> Hi
> 
> 
> Character set is choosen at database creation time (create database
> statement).
> It can not be changed later unless export recreate import is an option
> 
> 
> Jack
-- 
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).

web based query tool

[Arslan Bahar]

Do you know any web based  query tool  for  end users   except oracle
solutions

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:web based query tool

[dgoulet]

Brio.

Dick Goulet

Reply Separator
Author: "Arslan Bahar" <[EMAIL PROTECTED]>
Date:   5/23/2002 7:13 AM

Do you know any web based  query tool  for  end users   except oracle
solutions

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Sql Ldr Problem

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

RE: patchset 8.1.7.3 or 8.1.7.4

[Ben]

Hi

Are these patch sets cumulative? If I am at 8.1.7.0 can I
just apply the 8.1.7.4 patch set or do I have to apply
them all in order. Thanks.

-Original Message-
Travis
Sent: May 22, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=120607.1

http://ap103aru.us.oracle.com/ARULink/PatchSearch/get_form

> -Original Message-
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 22, 2002 1:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: patchset 8.1.7.3 or 8.1.7.4
>
>
> Dear List,
>
> What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I
> download them?   I looking on the FTP site and on Metalink
> but I couldn't
> tell which was which.
>
> Thanks,
> Ruth
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glenn Travis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ben
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Warehouse experts, a simple question for you| Outdated?

[Jack Silvey]

Is there such a thing as being TOO knowledgable and
well-read? I don't think so!

/jack


> Dennis,
> 
> I have on my desk, all in varying stages of being
> read: 
> Inmon's book Building the Data Warehouse (very
> understandable)
> 
> Kimball's articles from his site and from the
> Intelligententerprise.com
> site (somewhat understandable, I think you need a
> base from which to
> read his articles). His books are on order and
> should arrive today
> 
> Tim Gorman's book Essential Oracle8i Data
> Warehousing (this I haven't
> started, as Tim tells me to read it AFTER I have a
> basic understanding
> of data warehousing)
> 
> The Oracle8i Data Warehousing documentation
> (actually pretty readable
> and understandable)
> 
> Ya think I might be over-researching this stuff and
> panicking a bit?
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Ian, 
> > 
> >   - In the beginning was the data warehouse and
> yeah it was good. It
> > would
> > solve all corporate problems and would encompass
> all corporate data
> > so all
> > corporate minions would see the same data.
> >   - But yeah it took so long to create the
> corporate data warehouse
> > that
> > management despaired and canceled the project. Or
> by the time the
> > monster
> > data warehouse came blinking and straining into
> the daylight all the
> > users
> > said that the company had evolved in the meanwhile
> and the warehouse
> > was
> > obsolete.
> >   - So data warehouses gained a bad rep from
> corporate managers and
> > yeah
> > none would fain to propose the conception of a
> data warehouse for
> > fear of
> > castigation.
> >   - Then some marketing interns bribed a DBA to
> send them data
> > weekly. And
> > they stored this data in a database and lo, their
> superiors were
> > impressed.
> >   - Everyone was in awe of the marketing database,
> but none dared
> > tarnish it
> > by speaking the name which shall not be mentioned,
> so it was
> > christened a
> > "data mart".
> >   - And lo, the data marts multiplied and were
> fruitful. And the DBA
> > cursed
> > the day she was weak and did give data to the
> marketing interns.
> >   - Then another prophet did arise and did
> challenge the prophet
> > Kimball.
> > His name was Inmon. And he did claim to be the
> progenitor of data
> > warehouses. And therefore all should do data
> warehousing his way and
> > use his
> > terms.
> >   - And great confusion arose over the land. And
> many debates ensued,
> > including some face to face between Inmon and
> Kimball. And terms such
> > as
> > Operational Data Store (ODS) were bandied about.
> >   - And some said that queries against the ODS
> were acceptable and
> > others
> > deemed them forbidden. And some said that if it
> looks like a data
> > warehouse
> > and smells like a data warehouse it verily indeed
> is a data
> > warehouse.
> >   - And consultants warred against consultants and
> did call the other
> > consultants ignoramuses in front of management
> such that nobody knew
> > what
> > anybody was talking about.
> >   - And the DBAs said that creating a data
> warehouse or data mart was
> > not
> > nearly as hard as figuring out what to call it.
> > 
> > The moral of the story is to figure out what you
> need to do and be
> > aware
> > that different authors use the same terms for
> different purposes and
> > coin
> > their own terms. Personally, I have understood
> everything that
> > Kimball has
> > written and have never been able to read one of
> Inmon's articles to
> > the end.
> > But maybe that is just me.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, May 22, 2002 2:38 PM
> > To: Multiple recipients of list ORACLE-L
> > Outdated?
> > 
> > 
> > Ian,
> > 
> > Good question.  I think that I've seen more
> recenct references in
> > articles
> > that state the current thinking of DW/DM.  I'm
> sure that I've seen
> > Inmon
> > refer to them that way, or maybe it was Richard
> Winter?
> > 
> > Anyway, I guess that part is a bit dated.  There
> is so much good 
> > information
> > in that book though, that it's still worth its
> weight in gold.  You
> > won't 
> > find too many
> > publications for $60 that will take you step by
> step through building
> > an 
> > entire
> > data warehouse, including the infrastructure.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > "MacGregor, Ian A." <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 05/21/2002 05:48 PM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list
> ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:RE: Data Warehouse
> experts, a simple question
> > for
> > you| Outdated?
> > 
> > 
> > I am new to his books, three chapters in.  The
> first release of the
> > "Data 
> > Warehouse Toolkit"  defines a data warehouse much
> as a data mart is
> > today. 
> >  Today we think of a data warehouse as having a
>

Re[2]: Oracle Application Consultants - Austin, TX

[dgoulet]

I don't know.  I've gotten several messages from this 'techiedude' over the last
couple of days that were not addrressed to the list.  I think he/she is just a
spammer.

Dick Goulet

Reply Separator
Author: Rachel Carmichael <[EMAIL PROTECTED]>
Date:   5/23/2002 5:23 AM

if travel is 100% why does it matter WHERE you are local to?


--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> ...and you have to share a single motel room with 11 other people (3
> shifts
> of four), surrender accumulated frequent-flyer miles to the client,
> provide
> your own chair, laptop, and printer, and spend weekends onsite until
> project
> completion...
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 22, 2002 5:52 PM
> 
> 
> > Oracle Application Consultants - Austin, TX
> >
> > Experience with the CRM Sales Online module a MUST
> >
> > Candidate should be able to travel 100% and be local to the DFW or
> > Austin, TX areas. Candidates seeking permanent employment are
> preferred
> > but all resumes will be considered.
> >
> > If candidate is seeking a perm position, salary is negotiable. If
> > candidate is seeking contract work, rate will be $50-60 per hour
> plus
> > expenses, interviews to commence immediately.
> >
> > My client does not offer relocation reimbursement or H1B
> Sponsorship.
> >
> > To apply, send resume and salary/hourly requirement to
> [EMAIL PROTECTED]
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Financials, online requisitioning

[sean . hull]

Does anyone know if these are available for download off of Technet?  I've
looked and can't seem to find them.  Second question, is "online
requisitioning" part of "Procurement"?  Any urls or info would be
appreciated.

Thanks,
Sean

-.-..-.-..-.--..-
Heavyweight Internet Consulting   (http://www.iheavy.com)
O'Reilly Author, Oracle & Opn Src (http://www.oreilly.com/catalog/oracleopen)

-- 
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: news server

[Ron Rogers]

Get Oracle News at the Oracle newsroom www.oracle.com/newsroom/ 
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 09:53AM >>>

On 2002.05.23 07:08 Yechiel Adar wrote:
> I am looking for the address of oracle news server.
metalink.oracle.com
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).

RE: screen shots of Oracle installer in action?

[Grabowy, Chris]

Yeah, been there...attached is the presentation I created, which is purely
composed of screen shots of the Oracle installer screens.  It was for an
Oracle install on Windows NT.

HTH

-Original Message-
Sent: Thursday, May 23, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L


Does any one have or know of any documents on the Web that contain screen
shots of the Oracle installer in action(Preferably 8i Enterprise Edition on
AIX)?

I need to to include these in some documentation, but don't really want to
do an install just to get some screen shots?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




Installing the Oracle RDBMS 101.zip
Description: Binary data

alter table move resets NEXT?

[Gurelei]

Hi all:

We are running oracle 8.1.7.2 in parallel mode.
A DBA on my team noticed that when he moves a table
into a new tablespace via:

alter table XXX move tablespace YYY;

the table XXX's NEXT extent is being changed to its
original value (the one table was created with). Even
when he tried 

alter table XXX move tablespace YYY storage (NEXT ZZZ)

it still didn't help and the next extent was not set
to ZZZ. I know that truncate command does this -
resets NEXT to its original value, but does alter
table move resets NEXT too? Does anyone know if this
is a bug? a feature?

thanks

Gene

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RedHat

[Mercadante, Thomas F]

LOL - Mladen, you are bad!


-Original Message-
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



On 2002.05.23 02:23 Santosh Varma wrote:
> I wanted to know what is this RedHat, its significance and its
> features. Any
> links/doc's on that ???
> Thanks and regards,
> 
> Santosh

Red hat is a piece of clothing which makes a fashion statement. It is 
very
impractical during the hot summer days when the SUN is strong. My 
advice is
to forget about clothing and devote your attention to the kitchen 
utensilia,
like the Mandrake cooker.
Plese, do not use Google and enter "Red Hat", "SUN" or "Mandrake" or, 
even worse,
go directly to www.redhat.com, www.mandrake.com or alike. That would be 
outrageous
and totally uncalled for.
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Data Warehouse experts, a simple question for you| Outdated?

[DENNIS WILLIAMS]

Rachel
  - Glad Inmon's book is working for you. I have only read (or more
correctly attempted to read) his articles, which can be found at
http://www.datawarehousing.com/, or at least they previously were available.
  - Just be aware that when you switch from reading Inmon or one of his
followers to Kimball or one of his followers, that the meaning of some terms
change.
  - The oldest Kimball articles at
http://www.intelligententerprise.com/ports/search_webhouse.shtml are the
best to start with because they describe the fundamentals of data warehouse
design.
  - I still think the email list is one of the best resources.
   For help with list commands, send a message
   to  with the
   word "help" in the body of the message.
(I'm listing these for the benefit of others on this list)
Not to discourage you, but companies often take the approach of yours, and
hire consultants to build the site. They tend to go into a corner and
develop it and then unveil it when they are "finished", collect their check
and leave. If you ask questions, it is easy for them to blow past you
because they are the experts. So from that standpoint, don't panic, just go
along for the ride and what you can learn. But it is good to read up on
warehousing so you can ask intelligent questions and don't sound like a
dinosaur by asking questions like "whaddya mean it isn't normalized?". In
DW, the real participants are the ones that interview the potential users
and try to locate data the users will find useful. The DBA tends to be the
one that gets ordered to load 100-gig of data every night. DW work is like a
lot of other DBA work, but quite different in some respects. At least with
the email list, if something sounds odd, you can ask some real people for
some input.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, May 23, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L
Outdated?


Dennis,

I have on my desk, all in varying stages of being read: 
Inmon's book Building the Data Warehouse (very understandable)

Kimball's articles from his site and from the Intelligententerprise.com
site (somewhat understandable, I think you need a base from which to
read his articles). His books are on order and should arrive today

Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
started, as Tim tells me to read it AFTER I have a basic understanding
of data warehousing)

The Oracle8i Data Warehousing documentation (actually pretty readable
and understandable)

Ya think I might be over-researching this stuff and panicking a bit?

Rachel

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Ian, 
> 
>   - In the beginning was the data warehouse and yeah it was good. It
> would
> solve all corporate problems and would encompass all corporate data
> so all
> corporate minions would see the same data.
>   - But yeah it took so long to create the corporate data warehouse
> that
> management despaired and canceled the project. Or by the time the
> monster
> data warehouse came blinking and straining into the daylight all the
> users
> said that the company had evolved in the meanwhile and the warehouse
> was
> obsolete.
>   - So data warehouses gained a bad rep from corporate managers and
> yeah
> none would fain to propose the conception of a data warehouse for
> fear of
> castigation.
>   - Then some marketing interns bribed a DBA to send them data
> weekly. And
> they stored this data in a database and lo, their superiors were
> impressed.
>   - Everyone was in awe of the marketing database, but none dared
> tarnish it
> by speaking the name which shall not be mentioned, so it was
> christened a
> "data mart".
>   - And lo, the data marts multiplied and were fruitful. And the DBA
> cursed
> the day she was weak and did give data to the marketing interns.
>   - Then another prophet did arise and did challenge the prophet
> Kimball.
> His name was Inmon. And he did claim to be the progenitor of data
> warehouses. And therefore all should do data warehousing his way and
> use his
> terms.
>   - And great confusion arose over the land. And many debates ensued,
> including some face to face between Inmon and Kimball. And terms such
> as
> Operational Data Store (ODS) were bandied about.
>   - And some said that queries against the ODS were acceptable and
> others
> deemed them forbidden. And some said that if it looks like a data
> warehouse
> and smells like a data warehouse it verily indeed is a data
> warehouse.
>   - And consultants warred against consultants and did call the other
> consultants ignoramuses in front of management such that nobody knew
> what
> anybody was talking about.
>   - And the DBAs said that creating a data warehouse or data mart was
> not
> nearly as hard as figuring out what to call it.
> 
> The moral of the story is to figure out what you need to do and be
> aware
> that different authors use the same terms for different pur

Re:so when did you switch from NT to unix for oracle

[dgoulet]

When you get started.  Never, in my book, use NT for anything other than a
sandbox.

Dick Goulet
Sworn ANTI MicroSoft warrior.

Reply Separator
Author: "JOE TESTA" <[EMAIL PROTECTED]>
Date:   5/23/2002 5:48 AM

A question has been posed to me, when to switch from NT to unix for oracle.

Is it when the NT box starts getting out of memory issues, number of
transactions, size of db?

just looking for some ball park answers.

thanks, joe






A question has been posed to me, when to switch from NT to unix for 
oracle.
 
Is it when the NT box starts getting out of memory issues, number of 
transactions, size of db?
 
just looking for some ball park answers.
 
thanks, joe
 

-- 
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: Financials, online requisitioning

[Hately Mike]

No, you can't download them but you can buy them for £28 plus delivery from
the "CD Packs" section of the Oracle Store.

Cheers
Mike

-Original Message-
Sent: 23 May 2002 16:09
To: Multiple recipients of list ORACLE-L



Does anyone know if these are available for download off of Technet?  I've
looked and can't seem to find them.  Second question, is "online
requisitioning" part of "Procurement"?  Any urls or info would be
appreciated.

Thanks,
Sean

-.-..-.-..-.--..-
Heavyweight Internet Consulting   (http://www.iheavy.com)
O'Reilly Author, Oracle & Opn Src
(http://www.oreilly.com/catalog/oracleopen)

-- 
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).


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle and OpenVMS (was: Rename Column in 9iR2)

[Jesse, Rich]

As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this.  At least as far up as
8i, Oracle has really done themselves a disservice by bastardizing their own
install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY difficult to
create and maintain a database without using Oracle's horrid scripts.
Oracle refuses to recognize VMS logicals in the DB (although you can fool
it).  And do NOT use OpenVMS if you need MTS because it simply does not
work, even in 9i (see the Midrange forum on MetaClink).

I'm saying this and I'm a huge fan of VMS.  I've been working with it since
v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
reason, companies that produce software on multiple platforms tend to screw
up their VMS installs.  I have no idea why.  I've been working in Unix for
four or five years now and just don't understand why people in the
Unix/Winders world make OpenVMS so difficult!  It's EASY!



VMS (whoops..."OpenVMS") gets a bad rap because of poor marketing, and a
poor understanding of how VMS works by the people that develop on it and/or
manage the systems.  Hell, my OpenVMS box here that's running 4 Oracle 8.0.5
instances has had 5 minutes of down time in the past 716 days.  And that
downtime was due to a network failure.  Five "9"s, baby, and then some!

Woah...once again, DBA need beer.

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 23, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rename Column in 9iR2
> 
> 
> Hemant,
>   The price I am referring to is the cost involved with moving from a
> Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
> company sided issues that have to be addressed and cases made for the
> move. In this case the software is not an issues as you stated, the
> issues revolve around the hardware and developmental considerations. I
> would be more that happy to move to the latest and greatest "solid"
> platform/database combination. It would allow us to create 
> and implement
> browser based applications rather easily and would allow us to use the
> 9iAS Suite of products.
>  For now all I can do is make requests for item to be included in the
> budget as we move "forward, backwards, sideways, dance on circles".
> Ron
> ROR mª¿ªm
--
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).

Re: Installing an app on a French configured server

[Ruth Gramolini]

You can do it at anytime if the character set you are changing to is a
supset of the current set.  If it is not, you will have to export and import
you database for the changes to take place.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 7:28 AM


> Stephane
>
> How do we make the character set  French?(WE8ISO8859P15) on our test
> database?
> (Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).
>
> Is this something that has to be done when installing Oracle, or when
> creating the database(SID)? If so, how do we specify that we want this
> character set?
>
> Or can we change an existing installation or database?
>
> Any assistance appreciated
>
> John Dunn
>
>
> > -Original Message-
> > From: Stephane Faroult [SMTP:[EMAIL PROTECTED]]
> > Sent: 16 May 2002 21:24
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Installing an app on a French configured server
> >
> > Barry Deevey wrote:
> > >
> > > Hello all,
> > >
> > > There is a requirement to install our application at a site that will
> > have
> > > both Oracle (8.1.7) & Unix (AIX 5.1) configured in the French
language.
> > >
> > > Can anybody please advise me of anything that I need to be aware of in
> > > relation to the differences between an English & French
configuration??
> > >
> > > Any help is greatly appreciated.
> > >
> > > Best Regards,
> > >
> > > Barry.
> >
> > o Character sets (likely to be WE8ISO8859P15 in France - accents plus
> > euro character)
> > o Beware of tests on dates, especially if the day matters
> > o Subtle but annoying, numbers. The default decimal character is a comma
> > in France, and you sometimes (although rarely) meet a dot as separator
> > for thousands. Can be a big problem when loading data from external
> > sources - or generating files to be loaded say into Excel.
> >
> > And Oracle error messages in French are totally ununderstandable, even
> > to the French.
> >
> > HTH,
> >
> > Stephane Faroult
> > Oriole Software
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Stephane Faroult
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: so when did you switch from NT to unix for oracle

[Ron Rogers]

Joe,
  Please locate the "flack jacket" and wrap it security around your
body. You are about to get a barrage of comments ranging from "ASAP, to
fix what you have". 
  I would suggest that sense you asked the question that there must be
something in the wind at your location that would cause you to consider
the move. If in your opinion the time is near for the move then that is
the answer. If OS problems or support is the problem then I would
suggest that you dig deeply into the alternatives and come up with a
solution that is acceptable to you and the company. Companies just can'
afford to move to a different platform if there are reasonable methods
to correct what's wrong.
  Personally, I would start when you have a viable road map laid out
and a buy in from the purse strings. 

Ron.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 09:48AM >>>
A question has been posed to me, when to switch from NT to unix for
oracle.

Is it when the NT box starts getting out of memory issues, number of
transactions, size of db?

just looking for some ball park answers.

thanks, joe
--
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).

Re: ORA-2085

[Yechiel Adar]

Been there, Done that, Works in production.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:33 PM


>
> I'd never have thought that this was possible
> in Advanced Replication
>
> Hemant K Chitale
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, 23 May, 2002 12:48 AM
>
>
> > At last something that I have experience in.
> >
> > Just do the following:
> >
> > On the target database issue the following:
> > Alter database rename global_name to donot_trigger;
> >
> > We had the same problem. This solves it.
> > The global name has no other influence.
> >
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 21, 2002 6:08 PM
> >
> >
> > > Yes, I "inherited" this, and I am setting up Multimaster
> > > Advanced Replication, setting global_names=false isn't an
> > > option.  I have suggested moving the donotfiretrigger logic
> > > into the trigger, which has some initial support.  For the
> > > moment, we are changing the code to point to a link with the
> > > same name as the service name (which has obvious limitations,
> > > so hopefully a real fix will get done).
> > >
> > > I was really hoping there might be another workaround bandaid
> > > though, as I really don't want the "fix" to end up permanent.
> > >
> > > Thanks,
> > >
> > > John P Weatherman
> > > Database Administrator
> > > Replacements Ltd.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Tuesday, May 21, 2002 11:23 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > My guess is that you "inherited" an environment
> > > where the DB-Link was setup that way [link-name different
> > > from DB-name] . and then, sometime later,
> > > you set GLOBAL_NAMES=TRUE
> > >
> > > Well you have no choice :
> > > "// *Action: create a database link with the same name as the database
> it
> > > > //  connects to, or set global_names=false."
> > >
> > > Are you setting up Advanced Replication [MultiMaster]
> > > or Simple Replication [Snapshots] ?  I believe that
> > > Simple Replication does not mandate GLOBAL_NAMES=TRUE.
> > >
> > >
> > > Hemant K Chitale
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, 21 May, 2002 9:23 PM
> > >
> > >
> > > > Hi all.
> > > >
> > > > I have recently had to enable global_names in order to set up a
> > > > replicated environment.  The application uses a database link to
> > > > reconnect to the database under a differant user id (I inheirited
> > > > this, I had nothing to do with the design!).  Appearantly,
> > > > global_names has a prblem with this...
> > > >
> > > > SQL>  select * from [EMAIL PROTECTED];
> > > > select * from [EMAIL PROTECTED]
> > > >*
> > > > ERROR at line 1:
> > > > ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD
> > > >
> > > > SQL> !oerr ORA 2085
> > > > 02085, 0, "database link %s connects to %s"
> > > > // *Cause: a database link connected to a database with a different
> > name.
> > > > //  The connection is rejected.
> > > > // *Action: create a database link with the same name as the
database
> it
> > > > //  connects to, or set global_names=false.
> > > >
> > > > So, does anybody have any work arounds or ideas how I can get this
> > > > thing working again?
> > > >
> > > > TIA,
> > > >
> > > > John P Weatherman
> > > > Database Administrator
> > > > Replacements Ltd.
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: John Weatherman
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
Lists
> > > > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (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: Hemant K Chitale
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L

RE: Data Warehouse experts, a simple question for you| Outdated?

[Grabowy, Chris]

Oh yeah...oh yeah!!  Oracle Data Warehousing 101 coming up

-Original Message-
Sent: Thursday, May 23, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L
Outdated?


Dennis,

I have on my desk, all in varying stages of being read: 
Inmon's book Building the Data Warehouse (very understandable)

Kimball's articles from his site and from the Intelligententerprise.com
site (somewhat understandable, I think you need a base from which to
read his articles). His books are on order and should arrive today

Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
started, as Tim tells me to read it AFTER I have a basic understanding
of data warehousing)

The Oracle8i Data Warehousing documentation (actually pretty readable
and understandable)

Ya think I might be over-researching this stuff and panicking a bit?

Rachel

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Ian, 
> 
>   - In the beginning was the data warehouse and yeah it was good. It
> would
> solve all corporate problems and would encompass all corporate data
> so all
> corporate minions would see the same data.
>   - But yeah it took so long to create the corporate data warehouse
> that
> management despaired and canceled the project. Or by the time the
> monster
> data warehouse came blinking and straining into the daylight all the
> users
> said that the company had evolved in the meanwhile and the warehouse
> was
> obsolete.
>   - So data warehouses gained a bad rep from corporate managers and
> yeah
> none would fain to propose the conception of a data warehouse for
> fear of
> castigation.
>   - Then some marketing interns bribed a DBA to send them data
> weekly. And
> they stored this data in a database and lo, their superiors were
> impressed.
>   - Everyone was in awe of the marketing database, but none dared
> tarnish it
> by speaking the name which shall not be mentioned, so it was
> christened a
> "data mart".
>   - And lo, the data marts multiplied and were fruitful. And the DBA
> cursed
> the day she was weak and did give data to the marketing interns.
>   - Then another prophet did arise and did challenge the prophet
> Kimball.
> His name was Inmon. And he did claim to be the progenitor of data
> warehouses. And therefore all should do data warehousing his way and
> use his
> terms.
>   - And great confusion arose over the land. And many debates ensued,
> including some face to face between Inmon and Kimball. And terms such
> as
> Operational Data Store (ODS) were bandied about.
>   - And some said that queries against the ODS were acceptable and
> others
> deemed them forbidden. And some said that if it looks like a data
> warehouse
> and smells like a data warehouse it verily indeed is a data
> warehouse.
>   - And consultants warred against consultants and did call the other
> consultants ignoramuses in front of management such that nobody knew
> what
> anybody was talking about.
>   - And the DBAs said that creating a data warehouse or data mart was
> not
> nearly as hard as figuring out what to call it.
> 
> The moral of the story is to figure out what you need to do and be
> aware
> that different authors use the same terms for different purposes and
> coin
> their own terms. Personally, I have understood everything that
> Kimball has
> written and have never been able to read one of Inmon's articles to
> the end.
> But maybe that is just me.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> Sent: Wednesday, May 22, 2002 2:38 PM
> To: Multiple recipients of list ORACLE-L
> Outdated?
> 
> 
> Ian,
> 
> Good question.  I think that I've seen more recenct references in
> articles
> that state the current thinking of DW/DM.  I'm sure that I've seen
> Inmon
> refer to them that way, or maybe it was Richard Winter?
> 
> Anyway, I guess that part is a bit dated.  There is so much good 
> information
> in that book though, that it's still worth its weight in gold.  You
> won't 
> find too many
> publications for $60 that will take you step by step through building
> an 
> entire
> data warehouse, including the infrastructure.
> 
> Jared
> 
> 
> 
> 
> 
> 
> "MacGregor, Ian A." <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/21/2002 05:48 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Data Warehouse experts, a simple question
> for
> you| Outdated?
> 
> 
> I am new to his books, three chapters in.  The first release of the
> "Data 
> Warehouse Toolkit"  defines a data warehouse much as a data mart is
> today. 
>  Today we think of a data warehouse as having a highly normalized 
> structure which stores information from various sources.  We build
> data 
> marts with structures optimized for querying; e.g., star schemas,
> from the 
>  warehouse.  Kimball writes of the warehouse itself being based on a
> star 
> schema.
> 
> The term data warehous

RE: Data Warehouse experts, a simple question for you| Outdated?

[Rachel Carmichael]

read my electrons here:

I AM NOT WRITING ANOTHER BOOK.


--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> Oh yeah...oh yeah!!  Oracle Data Warehousing 101 coming up
> 
> -Original Message-
> Sent: Thursday, May 23, 2002 9:13 AM
> To: Multiple recipients of list ORACLE-L
> Outdated?
> 
> 
> Dennis,
> 
> I have on my desk, all in varying stages of being read: 
> Inmon's book Building the Data Warehouse (very understandable)
> 
> Kimball's articles from his site and from the
> Intelligententerprise.com
> site (somewhat understandable, I think you need a base from which to
> read his articles). His books are on order and should arrive today
> 
> Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
> started, as Tim tells me to read it AFTER I have a basic
> understanding
> of data warehousing)
> 
> The Oracle8i Data Warehousing documentation (actually pretty readable
> and understandable)
> 
> Ya think I might be over-researching this stuff and panicking a bit?
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Ian, 
> > 
> >   - In the beginning was the data warehouse and yeah it was good.
> It
> > would
> > solve all corporate problems and would encompass all corporate data
> > so all
> > corporate minions would see the same data.
> >   - But yeah it took so long to create the corporate data warehouse
> > that
> > management despaired and canceled the project. Or by the time the
> > monster
> > data warehouse came blinking and straining into the daylight all
> the
> > users
> > said that the company had evolved in the meanwhile and the
> warehouse
> > was
> > obsolete.
> >   - So data warehouses gained a bad rep from corporate managers and
> > yeah
> > none would fain to propose the conception of a data warehouse for
> > fear of
> > castigation.
> >   - Then some marketing interns bribed a DBA to send them data
> > weekly. And
> > they stored this data in a database and lo, their superiors were
> > impressed.
> >   - Everyone was in awe of the marketing database, but none dared
> > tarnish it
> > by speaking the name which shall not be mentioned, so it was
> > christened a
> > "data mart".
> >   - And lo, the data marts multiplied and were fruitful. And the
> DBA
> > cursed
> > the day she was weak and did give data to the marketing interns.
> >   - Then another prophet did arise and did challenge the prophet
> > Kimball.
> > His name was Inmon. And he did claim to be the progenitor of data
> > warehouses. And therefore all should do data warehousing his way
> and
> > use his
> > terms.
> >   - And great confusion arose over the land. And many debates
> ensued,
> > including some face to face between Inmon and Kimball. And terms
> such
> > as
> > Operational Data Store (ODS) were bandied about.
> >   - And some said that queries against the ODS were acceptable and
> > others
> > deemed them forbidden. And some said that if it looks like a data
> > warehouse
> > and smells like a data warehouse it verily indeed is a data
> > warehouse.
> >   - And consultants warred against consultants and did call the
> other
> > consultants ignoramuses in front of management such that nobody
> knew
> > what
> > anybody was talking about.
> >   - And the DBAs said that creating a data warehouse or data mart
> was
> > not
> > nearly as hard as figuring out what to call it.
> > 
> > The moral of the story is to figure out what you need to do and be
> > aware
> > that different authors use the same terms for different purposes
> and
> > coin
> > their own terms. Personally, I have understood everything that
> > Kimball has
> > written and have never been able to read one of Inmon's articles to
> > the end.
> > But maybe that is just me.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, May 22, 2002 2:38 PM
> > To: Multiple recipients of list ORACLE-L
> > Outdated?
> > 
> > 
> > Ian,
> > 
> > Good question.  I think that I've seen more recenct references in
> > articles
> > that state the current thinking of DW/DM.  I'm sure that I've seen
> > Inmon
> > refer to them that way, or maybe it was Richard Winter?
> > 
> > Anyway, I guess that part is a bit dated.  There is so much good 
> > information
> > in that book though, that it's still worth its weight in gold.  You
> > won't 
> > find too many
> > publications for $60 that will take you step by step through
> building
> > an 
> > entire
> > data warehouse, including the infrastructure.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > "MacGregor, Ian A." <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 05/21/2002 05:48 PM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:RE: Data Warehouse experts, a simple
> question
> > for
> > you| Outdated?
> > 
> > 
> > I am new to his books, three chapters in.  The first release of t

Re: Data Warehouse experts, a simple question for you| Outdated?

[Yechiel Adar]

That's not panicking, just common sense.
Too many data warehouse projects went down the drain
so you need to learn all you can before starting such project.

Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:13 PM


> Dennis,
> 
> I have on my desk, all in varying stages of being read: 
> Inmon's book Building the Data Warehouse (very understandable)
> 
> Kimball's articles from his site and from the Intelligententerprise.com
> site (somewhat understandable, I think you need a base from which to
> read his articles). His books are on order and should arrive today
> 
> Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
> started, as Tim tells me to read it AFTER I have a basic understanding
> of data warehousing)
> 
> The Oracle8i Data Warehousing documentation (actually pretty readable
> and understandable)
> 
> Ya think I might be over-researching this stuff and panicking a bit?
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Ian, 
> > 
> >   - In the beginning was the data warehouse and yeah it was good. It
> > would
> > solve all corporate problems and would encompass all corporate data
> > so all
> > corporate minions would see the same data.
> >   - But yeah it took so long to create the corporate data warehouse
> > that
> > management despaired and canceled the project. Or by the time the
> > monster
> > data warehouse came blinking and straining into the daylight all the
> > users
> > said that the company had evolved in the meanwhile and the warehouse
> > was
> > obsolete.
> >   - So data warehouses gained a bad rep from corporate managers and
> > yeah
> > none would fain to propose the conception of a data warehouse for
> > fear of
> > castigation.
> >   - Then some marketing interns bribed a DBA to send them data
> > weekly. And
> > they stored this data in a database and lo, their superiors were
> > impressed.
> >   - Everyone was in awe of the marketing database, but none dared
> > tarnish it
> > by speaking the name which shall not be mentioned, so it was
> > christened a
> > "data mart".
> >   - And lo, the data marts multiplied and were fruitful. And the DBA
> > cursed
> > the day she was weak and did give data to the marketing interns.
> >   - Then another prophet did arise and did challenge the prophet
> > Kimball.
> > His name was Inmon. And he did claim to be the progenitor of data
> > warehouses. And therefore all should do data warehousing his way and
> > use his
> > terms.
> >   - And great confusion arose over the land. And many debates ensued,
> > including some face to face between Inmon and Kimball. And terms such
> > as
> > Operational Data Store (ODS) were bandied about.
> >   - And some said that queries against the ODS were acceptable and
> > others
> > deemed them forbidden. And some said that if it looks like a data
> > warehouse
> > and smells like a data warehouse it verily indeed is a data
> > warehouse.
> >   - And consultants warred against consultants and did call the other
> > consultants ignoramuses in front of management such that nobody knew
> > what
> > anybody was talking about.
> >   - And the DBAs said that creating a data warehouse or data mart was
> > not
> > nearly as hard as figuring out what to call it.
> > 
> > The moral of the story is to figure out what you need to do and be
> > aware
> > that different authors use the same terms for different purposes and
> > coin
> > their own terms. Personally, I have understood everything that
> > Kimball has
> > written and have never been able to read one of Inmon's articles to
> > the end.
> > But maybe that is just me.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, May 22, 2002 2:38 PM
> > To: Multiple recipients of list ORACLE-L
> > Outdated?
> > 
> > 
> > Ian,
> > 
> > Good question.  I think that I've seen more recenct references in
> > articles
> > that state the current thinking of DW/DM.  I'm sure that I've seen
> > Inmon
> > refer to them that way, or maybe it was Richard Winter?
> > 
> > Anyway, I guess that part is a bit dated.  There is so much good 
> > information
> > in that book though, that it's still worth its weight in gold.  You
> > won't 
> > find too many
> > publications for $60 that will take you step by step through building
> > an 
> > entire
> > data warehouse, including the infrastructure.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > "MacGregor, Ian A." <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 05/21/2002 05:48 PM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:RE: Data Warehouse experts, a simple question
> > for
> > you| Outdated?
> > 
> > 
> > I am new to his books, three chapters in.  The first release of the
> > "Data 
> > Warehouse T

RE: Oracle RAC and NAS

[DENNIS WILLIAMS]

Stefan - By NAS, I assume you mean "Network Attached Storage". We use a Net
Appliance on our test server and it works well for the purpose. Basically we
have about a dozen Oracle instances which are used infrequently, so it
provides tons of cheap storage that isn't used that much. I found out the
hard way that you can overwhelm it with too many simultaneous heavy batch
jobs. My guess is that with both RAC and NAS the key is to configure the
highest-speed dedicated connections possible.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 23, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L


Hello everybody,

I was wondering if anybody has real "hands-on" experience with either a
combination of both RAC and NAS or just running 9i on an NAS. What are the
pros and cons ? Does anybody have some input on this topic ? Maybe some
helpful links besides technet ?

TIA
Stefan


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Ron Rogers]

Rich,
  I thank you for the heads up. I have read the install and release
notes for Oracle on OpenVMS and will approach with a lot of caution. I
am very familiar with the Unix world commands and expected actions but,
the OpenVMS commands I have to learn and try to understand before I
attempt the install. We have 2 boxes and 1 disk farm to use. One box
will be the development server and the other server will be production.
I have the advantage of learning with the development install first to
correct any errors in my install.
 Do you have any suggested links or doc's that would be of help or
guidance?
Thanks,
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 11:33AM >>>
As a side note, please please please become familiar with OpenVMS and
more
importantly Oracle on OpenVMS before tackling this.  At least as far up
as
8i, Oracle has really done themselves a disservice by bastardizing
their own
install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY difficult
to
create and maintain a database without using Oracle's horrid scripts.
Oracle refuses to recognize VMS logicals in the DB (although you can
fool
it).  And do NOT use OpenVMS if you need MTS because it simply does
not
work, even in 9i (see the Midrange forum on MetaClink).

I'm saying this and I'm a huge fan of VMS.  I've been working with it
since
v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
reason, companies that produce software on multiple platforms tend to
screw
up their VMS installs.  I have no idea why.  I've been working in Unix
for
four or five years now and just don't understand why people in the
Unix/Winders world make OpenVMS so difficult!  It's EASY!



VMS (whoops..."OpenVMS") gets a bad rap because of poor marketing, and
a
poor understanding of how VMS works by the people that develop on it
and/or
manage the systems.  Hell, my OpenVMS box here that's running 4 Oracle
8.0.5
instances has had 5 minutes of down time in the past 716 days.  And
that
downtime was due to a network failure.  Five "9"s, baby, and then
some!

Woah...once again, DBA need beer.

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex,
WI USA

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, May 23, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rename Column in 9iR2
> 
> 
> Hemant,
>   The price I am referring to is the cost involved with moving from
a
> Dell server on Novell to a Compaq OpenVMS server.  There are a lot
of
> company sided issues that have to be addressed and cases made for
the
> move. In this case the software is not an issues as you stated, the
> issues revolve around the hardware and developmental considerations.
I
> would be more that happy to move to the latest and greatest "solid"
> platform/database combination. It would allow us to create 
> and implement
> browser based applications rather easily and would allow us to use
the
> 9iAS Suite of products.
>  For now all I can do is make requests for item to be included in
the
> budget as we move "forward, backwards, sideways, dance on circles".
> Ron
> ROR mª¿ªm
--
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: 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).

RE: ORA-01595

[Mark Leith]

So have you tried increasing this?

-Original Message-
Gilbert
Sent: 23 May 2002 15:44
To: Multiple recipients of list ORACLE-L


50K

-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date:   jeudi 23 mai 2002 15:59
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

How large are the rollback segments?

The ORA-01594 error states:

attempt to wrap into rollback segment (string) extent (string) which
is
being freed

Cause: Undo generated to free a rollback segment extent is
attempting to
write
into the same extent due to small extents and/or there are too many
extents
to
free.

Action: The rollback segment shrinking will be rolled back by the
system;
increase the optimal size of the rollback segment.

Can you try increasing the OPTIMAL parameter for the SYSTEM rollback
segment? Typically the SYSTEM rollback segment is created much
smaller than
the "public" rollback segments..

  1  select segment_name,
  2  initial_extent,
  3  next_extent,
  4  status
  5* from dba_rollback_segs
sales>/

SEGMENT_NAME   INITIAL_EXTENT NEXT_EXTENT STATUS
-- -- --- --
SYSTEM  57344   57344 ONLINE
RBS0   524288  524288 ONLINE
RBS1   524288  524288 ONLINE
RBS2   524288  524288 ONLINE
RBS3   524288  524288 ONLINE
RBS4   524288  524288 ONLINE
RBS5   524288  524288 ONLINE
RBS6   524288  524288 ONLINE

alter rollback segment system storage(optimal 'X'M)

HTH

Mark

-Original Message-
Gilbert
Sent: 23 May 2002 14:18
To: Multiple recipients of list ORACLE-L


I am trying to do this.
alter rollback segment SYSTEM shrink;
alter rollback segment R01 shrink;
alter rollback segment R02 shrink;
alter rollback segment R03 shrink;
alter rollback segment R04 shrink;
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1)
which is
being
freed

And only on rollback system I got an error.  There are no
transcations in
this RBS.
Any Idea.




-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date:   jeudi 23 mai 2002 13:33
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

It looks like you only have 1 extent within the system
rollback
segment
anyway?

Why are you trying to shrink it? Do you have other rollback
segments
in
place?

-Original Message-
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L


The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent
(1)
which is
being
freed


-Message d'origine-
De: DENNIS WILLIAMS
[mailto:[EMAIL PROTECTED]]
Date:   mercredi 22 mai 2002 16:29
À:  Multiple recipients of list ORACLE-L
Objet:  RE: ORA-01595

Gilbert - The oerr utility says the key part is the
accompanying
message.
Can you forward the accompanying messgage?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback
segment
(string))

I got this error when I tryed to shrink the rollback
segment
system,

What can I do to solve this problem, optiman does'nt
solve
it.

Re: news server

[Joe Raube]

comp.databases.oracle.server
comp.databases.oracle.tools
comp.databases.oracle.misc
comp.databases.oracle.marketplace

I access these via groups.google.com

-Joe

--- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> Sorry, I wish that e-mails had a way to attach what I wanted
> to say.
> 
> I meant news group on the subject of oracle.
>  
> Yechiel Adar
> Mehish
> - Original Message - 
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Thursday, May 23, 2002 3:53 PM
> 
> 
> > 
> > On 2002.05.23 07:08 Yechiel Adar wrote:
> > > I am looking for the address of oracle news server.
> > metalink.oracle.com
> > -- 
> > Mladen Gogala
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
>

> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Yechiel Adar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: so when did you switch from NT to unix for oracle

[Mark Leith]

First things first Joe - forget "NT" and use Win2K!!

When memory needs become greater than 3gig,.
When reliability is *essential* (24*7).
Security is essential (yea yea they *say* it's secure - but...)

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


 -Original Message-
Sent: 23 May 2002 14:48
To: Multiple recipients of list ORACLE-L


A question has been posed to me, when to switch from NT to unix for oracle.

Is it when the NT box starts getting out of memory issues, number of
transactions, size of db?

just looking for some ball park answers.

thanks, joe

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find current ORACLE_HOME programmatically

[Gene Sais]

Alex - the reg is the place:, hlocal > soft > oracle > all_homes > last_home.

hth,
gene


>>> [EMAIL PROTECTED] 05/22/02 12:53PM >>>
Looks like no takers, except one whos great advice was to find it somewhere
in the registry.

Alex Hillman

-Original Message-
Hillman
Sent: Monday, May 20, 2002 7:08 PM
To: Multiple recipients of list ORACLE-L


Hi, guys.

I need to find current value of ORACLE_HOME on the client from VB program,
running on that client. I understand that it is in the registry somewhere. I
have 2 client installations - one is 8.1.7 and another is 9 on the same
client. Apparently EM from 9 installation knows that needed tsnames.ora is
in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation.
And my VB program select tsnames.ora from 8.1.7 installation

Any ideas?

Alex Hillman


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Alex Hillman
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Alex Hillman
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RedHat

[Gogala, Mladen]

I know. That's my nature. I even advised a young lady from LA to do the
same.

> -Original Message-
> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 23, 2002 11:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RedHat
> 
> 
> LOL - Mladen, you are bad!
> 
> 
> -Original Message-
> Sent: Thursday, May 23, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> On 2002.05.23 02:23 Santosh Varma wrote:
> > I wanted to know what is this RedHat, its significance and its
> > features. Any
> > links/doc's on that ???
> > Thanks and regards,
> > 
> > Santosh
> 
> Red hat is a piece of clothing which makes a fashion statement. It is 
> very
> impractical during the hot summer days when the SUN is strong. My 
> advice is
> to forget about clothing and devote your attention to the kitchen 
> utensilia,
> like the Mandrake cooker.
> Plese, do not use Google and enter "Red Hat", "SUN" or "Mandrake" or, 
> even worse,
> go directly to www.redhat.com, www.mandrake.com or alike. 
> That would be 
> outrageous
> and totally uncalled for.
> -- 
> Mladen Gogala
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

RE: RedHat

[April Wells]

Actually... I thought it was rather good.

-Original Message-
Sent: Thursday, May 23, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


LOL - Mladen, you are bad!


-Original Message-
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



On 2002.05.23 02:23 Santosh Varma wrote:
> I wanted to know what is this RedHat, its significance and its
> features. Any
> links/doc's on that ???
> Thanks and regards,
> 
> Santosh

Red hat is a piece of clothing which makes a fashion statement. It is 
very
impractical during the hot summer days when the SUN is strong. My 
advice is
to forget about clothing and devote your attention to the kitchen 
utensilia,
like the Mandrake cooker.
Plese, do not use Google and enter "Red Hat", "SUN" or "Mandrake" or, 
even worse,
go directly to www.redhat.com, www.mandrake.com or alike. That would be 
outrageous
and totally uncalled for.
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: so when did you switch from NT to unix for oracle

[Yechiel Adar]

Hello Joe
 
I think that the main reason is response 
time.
An NT machine can get only 4 CPUs.
If you have all the CPUs and memory and the NT does 
not carry the load
then it is time to consider a change.
 
A change can be to Unix or to 
clustering.
If you are all NT shop then I would consider 
clustering.
In a mixed shop the move to Unix is easier, 
otherwise you will also
need system administrator and have learning 
curve.
 
Just my 0.02$
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  JOE 
  TESTA 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, May 23, 2002 3:48 
PM
  Subject: so when did you switch from NT 
  to unix for oracle
  
  A question has been posed to me, when to switch from NT to unix for 
  oracle.
   
  Is it when the NT box starts getting out of memory issues, number of 
  transactions, size of db?
   
  just looking for some ball park answers.
   
  thanks, joe
   

RE: RedHat

[Brian McGraw]

Maybe we should birth a new catch phrase - 

DAFGS

(Do a **Fine** Google Search)

-Original Message-
Wells
Sent: Thursday, May 23, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L

Actually... I thought it was rather good.

-Original Message-
Sent: Thursday, May 23, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


LOL - Mladen, you are bad!


-Original Message-
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



On 2002.05.23 02:23 Santosh Varma wrote:
> I wanted to know what is this RedHat, its significance and its
> features. Any
> links/doc's on that ???
> Thanks and regards,
> 
> Santosh

Red hat is a piece of clothing which makes a fashion statement. It is 
very
impractical during the hot summer days when the SUN is strong. My 
advice is
to forget about clothing and devote your attention to the kitchen 
utensilia,
like the Mandrake cooker.
Plese, do not use Google and enter "Red Hat", "SUN" or "Mandrake" or, 
even worse,
go directly to www.redhat.com, www.mandrake.com or alike. That would be 
outrageous
and totally uncalled for.
-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian McGraw
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: news server

[Yechiel Adar]

Sorry, I wish that e-mails had a way to attach what I wanted
to say.

I meant news group on the subject of oracle.
 
Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:53 PM


> 
> On 2002.05.23 07:08 Yechiel Adar wrote:
> > I am looking for the address of oracle news server.
> metalink.oracle.com
> -- 
> Mladen Gogala
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 8.1.7.4

[Arun Chakrapani]

They have royally messed up the library cache,
We are applying applying .. work arounds for this 8.1.7,Each time we
call up they come back saying that there is a work around for this.
We have very heavy contentions on library cache, the sql which are using
bind variables are not getting shared.
We are still seeing lots of latch free waits on library cache,row cache
objects and shared pool.
Now that they have released this 8.1.7.4 I am pretty sure they would have
messed up something else and we will have to start applying some other work
around for this Or like somebody said .5 will be around the corner.


-Original Message-
Sent: Thursday, May 23, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L


I heard that too, but I think that they'll be weighing their options.
If 8.1.7.4 is messed up badly, they'll probably give us 8.1.7.5 for
Christmas.

On 2002.05.23 09:33 Hemant K Chitale wrote:
> 
> Nope.  .4 is supposed to be the last PSR (patchset release)
> for 8.1.7
> 
> Hemant K Chitale
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, 23 May, 2002 4:33 AM
> 
> 
> >
> > I hear that .5 is right around the corner.
> >
> > Vinny
> >
> >
> > --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > > I thought that .3 was the final patch.  I guess they found more
> stuff
> that
> > > needed fixing.
> > >
> > > Ruth
> > >
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, May 21, 2002 8:58 PM
> > >
> > >
> > > > Has anyone patched up to 8.1.7.4 yet???
> > > >
> > > > Anything we should be aware of???
> > > >
> > > > Regards,
> > > >
> > > > Sujatha
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Sujatha Madan
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
> Lists
> > > > 
> 
> > > > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You
> may
> > > > also send the HELP command for other information (like
> subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> Lists
> > > 
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You
> may
> > > also send the HELP command for other information (like
> subscribing).
> >
> >
> > __
> > Do You Yahoo!?
> > LAUNCH - Your Yahoo! Music Experience
> > http://launch.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Vincent Cimino
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Hemant K Chitale
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858

Re: patchset 8.1.7.3 or 8.1.7.4

[Hemant K Chitale]

The patchsets _are_ cumulative.  You can
go direct from 8.1.7.0 to 8.1.7.3 or to 8.1.7.4
[we normally don't go to the latest patchset level
but wait a few weeks or a couple of months to
see that no major issues are reported with the
latest patchsetlevel].

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 11:18 PM


> Hi
>
> Are these patch sets cumulative? If I am at 8.1.7.0 can I
> just apply the 8.1.7.4 patch set or do I have to apply
> them all in order. Thanks.
>
> -Original Message-
> Travis
> Sent: May 22, 2002 2:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=120607.1
>
> http://ap103aru.us.oracle.com/ARULink/PatchSearch/get_form
>
> > -Original Message-
> > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, May 22, 2002 1:06 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: patchset 8.1.7.3 or 8.1.7.4
> >
> >
> > Dear List,
> >
> > What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I
> > download them?   I looking on the FTP site and on Metalink
> > but I couldn't
> > tell which was which.
> >
> > Thanks,
> > Ruth
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Glenn Travis
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ben
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename Column in 9iR2

[Hemant K Chitale]

The bane of trying to keep up with technology.
But why OpenVMS and not Tru64, then.
We have a large number of Tru64 Oracle Databases
(we do have OpenVMSs for Promis databases
used in manufacturing, I believe).

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 11:03 PM


Hemant,
  The price I am referring to is the cost involved with moving from a
Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
company sided issues that have to be addressed and cases made for the
move. In this case the software is not an issues as you stated, the
issues revolve around the hardware and developmental considerations. I
would be more that happy to move to the latest and greatest "solid"
platform/database combination. It would allow us to create and implement
browser based applications rather easily and would allow us to use the
9iAS Suite of products.
 For now all I can do is make requests for item to be included in the
budget as we move "forward, backwards, sideways, dance on circles".
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 09:38AM >>>

An upgrade wouldn't cost anything.  It would be free
as part of your support contract.

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 2:41 AM


Kevin,
 I appreciate your testing efforts. Now to convince the bean-counters
to upgrate to 9i.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 02:08PM >>>
I reran my test. with 250,000 rows in the table. It took a whopping
0.25
seconds to complete.

-Original Message-
Sent: Wednesday, May 22, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Kevin,
 Yes but does it work with data in the column?, I do not have 9i set
up
yet. If it works as you describe with data in the column it will
really
help with the multi million row tables that "they" want to rename a
column  after a release of a new lotto game.
thanks,
for the test and update.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 10:38AM >>>
Summary: it works!

SQL> SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL> create table test_table (wrong_name VARCHAR2(40));

Table created.

SQL> alter table test_table rename column wrong_name to right_name;

Table altered.

SQL> desc test_table;
 Name  Null?Type
 - 

 RIGHT_NAME VARCHAR2(40)

SQL>

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant
Confidential
and may be legally privileged. It is intended solely for the
addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in
reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This
message and
its attachments could have been infected during transmission. By
reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Trilegiant Corporation is not liable for any loss or
damage
arising in any way from this message or its attachments.

--
--


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: htt

SORT

[Remacle Jean]

Hi all,

I did some testing on sorts. I sorted a table of 269 MB. I did set the
sort_area_size to a minimum value of 10k. I set event 10032 to level 1 and
looked after the initial runs to be able to calculate a good value for
sort_area_size. Once this done, I did run the statement with event 10053 set
to level 1 and discovered that initial runs did not match.
With 10032 I get 6 as initial runs and sort_area_size is 385024 where under
10053 I get 1069 initial runs and an area_size of 264192. So if you make the
maths you discover that the sorted size is about (6*385024) 2.2 MB for 10032
and is (1069*264192) 269 MB for 10053.
I guess that event 10053 reports just a simulation and it divides the table
size by its area size to get the number of initial runs. Event 10032 reports
the real numbers of what happened. 
But then my question is how can it sort 269 MB of data in 2.2 MB of sort
space? My guess is that it only needs space for sorted rows and this is a
group by. So, the number of rows to sort is 3884794 times 73 bytes (avg row
length) is 269 MB. The number of output rows is 19839 times 73 is 1.4 MB it
will fit in 2.2 MB.
Another question is why that SORT_SIZE is reported instead of
SORT_AREA_SIZE?

Here is the statement and execution plan:

SELECT 
  trunc(collecttime, 'HH24'),
  expname,
  ipaddr,
  hostname,
  instance,
  sum(floatvalue),
  sum(stopticks - startticks) / 10 cnt
FROM 
  coldata  
group by expname,
 ipaddr,
 hostname, 
 instance,
 trunc(collecttime, 'HH24');

Execution Plan
--
0SELECT STATEMENT Optimizer=FIRST_ROWS (Cost=95599 Card=3866581
Bytes=220395117)
10 SORT (GROUP BY) (Cost=95599 Card=3866581 Bytes=220395117)
21   TABLE ACCESS (FULL) OF 'COLDATA' (Cost=2294 Card=3866581
Bytes=220395117)

Jean Remacle

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Remacle Jean
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Gene Sais]

vms is a great os, if only dec ported it to the intel chip, then ms would not be what 
it is today.  ohh well, that's history.  for installs on vms use oracleins not the gui 
installer.  they give you 2 choices, guess b/c the gui doesn't work :).  wish they 
would bring back orainst /c for unix!

gene


>>> [EMAIL PROTECTED] 05/23/02 11:33AM >>>
As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this.  At least as far up as
8i, Oracle has really done themselves a disservice by bastardizing their own
install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY difficult to
create and maintain a database without using Oracle's horrid scripts.
Oracle refuses to recognize VMS logicals in the DB (although you can fool
it).  And do NOT use OpenVMS if you need MTS because it simply does not
work, even in 9i (see the Midrange forum on MetaClink).

I'm saying this and I'm a huge fan of VMS.  I've been working with it since
v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
reason, companies that produce software on multiple platforms tend to screw
up their VMS installs.  I have no idea why.  I've been working in Unix for
four or five years now and just don't understand why people in the
Unix/Winders world make OpenVMS so difficult!  It's EASY!



VMS (whoops..."OpenVMS") gets a bad rap because of poor marketing, and a
poor understanding of how VMS works by the people that develop on it and/or
manage the systems.  Hell, my OpenVMS box here that's running 4 Oracle 8.0.5
instances has had 5 minutes of down time in the past 716 days.  And that
downtime was due to a network failure.  Five "9"s, baby, and then some!

Woah...once again, DBA need beer.

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, May 23, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rename Column in 9iR2
> 
> 
> Hemant,
>   The price I am referring to is the cost involved with moving from a
> Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
> company sided issues that have to be addressed and cases made for the
> move. In this case the software is not an issues as you stated, the
> issues revolve around the hardware and developmental considerations. I
> would be more that happy to move to the latest and greatest "solid"
> platform/database combination. It would allow us to create 
> and implement
> browser based applications rather easily and would allow us to use the
> 9iAS Suite of products.
>  For now all I can do is make requests for item to be included in the
> budget as we move "forward, backwards, sideways, dance on circles".
> Ron
> ROR mª¿ªm
--
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: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: so when did you switch from NT to unix for oracle

[Thomas Day]

Number of users.  I have a 170G Oracle 8.1.6 database running on WinNT 4.0
with 3xx of RAM just fine, as long as there are no more than 2 users.  Jump
up to about 16 users and response time goes down the tube.

So I guess that transactions are the answer.  I don't have any benchmarks.
Just my $.02.



   

JOE TESTA  



com> cc:   

Sent by: rootSubject: so when did you switch from NT 
to
 unix for oracle   

   

05/23/2002 

09:48 AM   

Please 

respond to 

ORACLE-L   

   

   






A question has been posed to me, when to switch from NT to unix for
oracle.

Is it when the NT box starts getting out of memory issues, number of
transactions, size of db?

just looking for some ball park answers.

thanks, joe




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Karniotis, Stephen]

I can add to Jesse's comments.  VMS has always been the bastard of Oracle
Platforms even though it was written for VMS initially.  Remember that Larry
first wrote Oracle on the VMS platform.

The installation process is actually very clean as compared to many other
environments. Yes, it does require additional knowledge of how logicals and
symbols function, and yes OFA does not "truly" exist within the spectrum as
it does on Unix.   However, OFA does exist within the OpenVMS environment
and is the responsibility of the DBA to exercise the implementation of it.
Thus, only war-torn DBAs understand the VMS environment of Oracle and have a
relatively easy time implementing on this platform.

As far as logicals within the database, Jesse is correct in that Oracle is
not very friendly with them if you want datafiles to use logicals.  However,
if you define the logicals as "terminal, rooted" logicals, Oracle does not
translate them.  In fact, this is the proper way to define data files versus
using the device name.  What happens if you have to move the device from
DSA10 to DSA100, but the disk is still the same?  It is simply moving to
another controller.  You are screwed if you use the physical device name.
If you use logicals, all works well.

Jesse is right.  VMS is the strongest and most robust platform Oracle runs
on.  If not, then why did Oracle buy RDB and use Compaq (sorry DEC) for the
clustering technology for 9i RAC?  Contradict that one and you should open
up your own database company.

Enough ranting.  Become familiar with Open VMS and all will be well.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, May 23, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle and OpenVMS (was: Rename Column in 9iR2)

As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this.  At least as far up as
8i, Oracle has really done themselves a disservice by bastardizing their own
install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY difficult to
create and maintain a database without using Oracle's horrid scripts.
Oracle refuses to recognize VMS logicals in the DB (although you can fool
it).  And do NOT use OpenVMS if you need MTS because it simply does not
work, even in 9i (see the Midrange forum on MetaClink).

I'm saying this and I'm a huge fan of VMS.  I've been working with it since
v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
reason, companies that produce software on multiple platforms tend to screw
up their VMS installs.  I have no idea why.  I've been working in Unix for
four or five years now and just don't understand why people in the
Unix/Winders world make OpenVMS so difficult!  It's EASY!



VMS (whoops..."OpenVMS") gets a bad rap because of poor marketing, and a
poor understanding of how VMS works by the people that develop on it and/or
manage the systems.  Hell, my OpenVMS box here that's running 4 Oracle 8.0.5
instances has had 5 minutes of down time in the past 716 days.  And that
downtime was due to a network failure.  Five "9"s, baby, and then some!

Woah...once again, DBA need beer.

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 23, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rename Column in 9iR2
> 
> 
> Hemant,
>   The price I am referring to is the cost involved with moving from a
> Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
> company sided issues that have to be addressed and cases made for the
> move. In this case the software is not an issues as you stated, the
> issues revolve around the hardware and developmental considerations. I
> would be more that happy to move to the latest and greatest "solid"
> platform/database combination. It would allow us to create 
> and implement
> browser based applications rather easily and would allow us to use the
> 9iAS Suite of products.
>  For now all I can do is make requests for item to be included in the
> budget as we move "forward, backwards, sideways, dance on circles".
> Ron
> ROR mª¿ªm
-- 
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

Re: news server

[Yechiel Adar]

Thanks Joe

Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 6:23 PM


> comp.databases.oracle.server
> comp.databases.oracle.tools
> comp.databases.oracle.misc
> comp.databases.oracle.marketplace
> 
> I access these via groups.google.com
> 
> -Joe
> 
> --- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> > Sorry, I wish that e-mails had a way to attach what I wanted
> > to say.
> > 
> > I meant news group on the subject of oracle.
> >  
> > Yechiel Adar
> > Mehish
> > - Original Message - 
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Thursday, May 23, 2002 3:53 PM
> > 
> > 
> > > 
> > > On 2002.05.23 07:08 Yechiel Adar wrote:
> > > > I am looking for the address of oracle news server.
> > > metalink.oracle.com
> > > -- 
> > > Mladen Gogala
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > -- 
> > > Author: Mladen Gogala
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> > 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> > in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Yechiel Adar
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joe Raube
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Baker, Barbara]

Ron:
There's a list at
iouga-vms-l

The traffic is very-very-very-very light. However, when I've needed help,
the responses have been exceptional.

Good luck!
Barb

> --
> From: Ron Rogers[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, May 23, 2002 10:33 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Oracle and OpenVMS (was: Rename Column in 9iR2)
> 
> Rich,
>   I thank you for the heads up. I have read the install and release
> notes for Oracle on OpenVMS and will approach with a lot of caution. I
> am very familiar with the Unix world commands and expected actions but,
> the OpenVMS commands I have to learn and try to understand before I
> attempt the install. We have 2 boxes and 1 disk farm to use. One box
> will be the development server and the other server will be production.
> I have the advantage of learning with the development install first to
> correct any errors in my install.
>  Do you have any suggested links or doc's that would be of help or
> guidance?
> Thanks,
> Ron
> ROR mª¿ªm
> 
> >>> [EMAIL PROTECTED] 05/23/02 11:33AM >>>
> As a side note, please please please become familiar with OpenVMS and
> more
> importantly Oracle on OpenVMS before tackling this.  At least as far up
> as
> 8i, Oracle has really done themselves a disservice by bastardizing
> their own
> install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY difficult
> to
> create and maintain a database without using Oracle's horrid scripts.
> Oracle refuses to recognize VMS logicals in the DB (although you can
> fool
> it).  And do NOT use OpenVMS if you need MTS because it simply does
> not
> work, even in 9i (see the Midrange forum on MetaClink).
> 
> I'm saying this and I'm a huge fan of VMS.  I've been working with it
> since
> v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
> reason, companies that produce software on multiple platforms tend to
> screw
> up their VMS installs.  I have no idea why.  I've been working in Unix
> for
> four or five years now and just don't understand why people in the
> Unix/Winders world make OpenVMS so difficult!  It's EASY!
> 
> 
> 
> VMS (whoops..."OpenVMS") gets a bad rap because of poor marketing, and
> a
> poor understanding of how VMS works by the people that develop on it
> and/or
> manage the systems.  Hell, my OpenVMS box here that's running 4 Oracle
> 8.0.5
> instances has had 5 minutes of down time in the past 716 days.  And
> that
> downtime was due to a network failure.  Five "9"s, baby, and then
> some!
> 
> Woah...once again, DBA need beer.
> 
> Enjoy!  :)
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex,
> WI USA
> 
> > -Original Message-
> > From: Ron Rogers [mailto:[EMAIL PROTECTED]] 
> > Sent: Thursday, May 23, 2002 10:04 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Rename Column in 9iR2
> > 
> > 
> > Hemant,
> >   The price I am referring to is the cost involved with moving from
> a
> > Dell server on Novell to a Compaq OpenVMS server.  There are a lot
> of
> > company sided issues that have to be addressed and cases made for
> the
> > move. In this case the software is not an issues as you stated, the
> > issues revolve around the hardware and developmental considerations.
> I
> > would be more that happy to move to the latest and greatest "solid"
> > platform/database combination. It would allow us to create 
> > and implement
> > browser based applications rather easily and would allow us to use
> the
> > 9iAS Suite of products.
> >  For now all I can do is make requests for item to be included in
> the
> > budget as we move "forward, backwards, sideways, dance on circles".
> > Ron
> > ROR mª¿ªm
> --
> 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: 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, 

RE: Data Warehouse experts, a simple question for you| Outdated?

[Rachel Carmichael]

Dennis,

We are active participants in the process. We are also making an offer
to someone with an extensive background in developing data warehouses,
which will help me to sleep much more comfortably at night :)

Rachel

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Rachel
>   - Glad Inmon's book is working for you. I have only read (or more
> correctly attempted to read) his articles, which can be found at
> http://www.datawarehousing.com/, or at least they previously were
> available.
>   - Just be aware that when you switch from reading Inmon or one of
> his
> followers to Kimball or one of his followers, that the meaning of
> some terms
> change.
>   - The oldest Kimball articles at
> http://www.intelligententerprise.com/ports/search_webhouse.shtml are
> the
> best to start with because they describe the fundamentals of data
> warehouse
> design.
>   - I still think the email list is one of the best resources.
>For help with list commands, send a message
>to  with the
>word "help" in the body of the message.
> (I'm listing these for the benefit of others on this list)
> Not to discourage you, but companies often take the approach of
> yours, and
> hire consultants to build the site. They tend to go into a corner and
> develop it and then unveil it when they are "finished", collect their
> check
> and leave. If you ask questions, it is easy for them to blow past you
> because they are the experts. So from that standpoint, don't panic,
> just go
> along for the ride and what you can learn. But it is good to read up
> on
> warehousing so you can ask intelligent questions and don't sound like
> a
> dinosaur by asking questions like "whaddya mean it isn't
> normalized?". In
> DW, the real participants are the ones that interview the potential
> users
> and try to locate data the users will find useful. The DBA tends to
> be the
> one that gets ordered to load 100-gig of data every night. DW work is
> like a
> lot of other DBA work, but quite different in some respects. At least
> with
> the email list, if something sounds odd, you can ask some real people
> for
> some input.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Thursday, May 23, 2002 8:13 AM
> To: Multiple recipients of list ORACLE-L
> Outdated?
> 
> 
> Dennis,
> 
> I have on my desk, all in varying stages of being read: 
> Inmon's book Building the Data Warehouse (very understandable)
> 
> Kimball's articles from his site and from the
> Intelligententerprise.com
> site (somewhat understandable, I think you need a base from which to
> read his articles). His books are on order and should arrive today
> 
> Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
> started, as Tim tells me to read it AFTER I have a basic
> understanding
> of data warehousing)
> 
> The Oracle8i Data Warehousing documentation (actually pretty readable
> and understandable)
> 
> Ya think I might be over-researching this stuff and panicking a bit?
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Ian, 
> > 
> >   - In the beginning was the data warehouse and yeah it was good.
> It
> > would
> > solve all corporate problems and would encompass all corporate data
> > so all
> > corporate minions would see the same data.
> >   - But yeah it took so long to create the corporate data warehouse
> > that
> > management despaired and canceled the project. Or by the time the
> > monster
> > data warehouse came blinking and straining into the daylight all
> the
> > users
> > said that the company had evolved in the meanwhile and the
> warehouse
> > was
> > obsolete.
> >   - So data warehouses gained a bad rep from corporate managers and
> > yeah
> > none would fain to propose the conception of a data warehouse for
> > fear of
> > castigation.
> >   - Then some marketing interns bribed a DBA to send them data
> > weekly. And
> > they stored this data in a database and lo, their superiors were
> > impressed.
> >   - Everyone was in awe of the marketing database, but none dared
> > tarnish it
> > by speaking the name which shall not be mentioned, so it was
> > christened a
> > "data mart".
> >   - And lo, the data marts multiplied and were fruitful. And the
> DBA
> > cursed
> > the day she was weak and did give data to the marketing interns.
> >   - Then another prophet did arise and did challenge the prophet
> > Kimball.
> > His name was Inmon. And he did claim to be the progenitor of data
> > warehouses. And therefore all should do data warehousing his way
> and
> > use his
> > terms.
> >   - And great confusion arose over the land. And many debates
> ensued,
> > including some face to face between Inmon and Kimball. And terms
> such
> > as
> > Operational Data Store (ODS) were bandied about.
> >   - And some said that queries against the ODS were acceptable and
> > others
> > deemed them forbidden. And some said that if it looks like a data

RE: so when did you switch from NT to unix for oracle

[Disser, Arno]

Here are my 0.02EUR
 
Turn this reasoning around: Why would anyone use NT for a serious Oracle
DB-server? 
Okay, for some minor development perhaps, but for an production environment?
 
b.t.w., ever considered a switch to VMS?
 
Arno Disser
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Disser, Arno
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: init.ora params for quick i/0

[Mohammed . Ahsanuddin]

As suggested by Frank, turning on Cached option of Quick I/O really helped
the reads (at the same time with some negative impact on writes). At this
point I have enabled cache quick i/o on data file systems. This is on a sun
e10k with 28 cpu and 28g ram. 

If anyone who has used cached quick i/o can comment if there are any
pros/cons of using this option, would be great. 

Thanks

Mohammed Ahsanuddin
Oracle DBA

-Original Message-
Sent: Tuesday, May 21, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L


Silly question maybe, but have you verified that those kaio call are 
succeeding?

Their mere appearance in the truss output only verifies async is being 
attempted.

If the kaio calls fail, they fall back on standard io calls.

Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you 
will find
it invaluable.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/21/2002 09:13 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:init.ora params for quick i/0


Hello,

We have implemented quick i/o on a sun server running solaris 8 and Oracle
8173. I have set disk_asynch to true. I have verified using truss that 
dbwr
is making kaio calls. Is there anything I am missing on the db side to 
make
proper use of quick i/o ?

Also, I am noticing heavy I/O related waits for a process (db file
sequential read, db file parallel write etc..) and would like to involve 
our
sys admin in tuning this particular process..If anyone has any idea what I
can specifically ask the sys admin to look at, please do let me know..

I really appreciate any feedback I could get..

Thanks

Mohammed Ahsanuddin
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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: PARALLEL SERVER

[Bill Pass]

I have done OPS/RAC on 7.x, 8.x, 8i and 9i w/IBM SP,
RS/6000 and Sun.

Believe it or not you can encounter database hangs on
OPS/RAC on any of these versions that you do not
encounter on non-OPS/RAC solutions (or as Oracle likes
to put it in some cases slows down so much that it
appears hung). 

In most cases you can steer clear of these issues by
not executing DDL very often while the system is
running in a production mode or by avoiding full
consistent exports. Replication is another area that
can lead to hung databases when used in conjunction
with OPS/RAC.

I still advise clients to not go their unless they
have to (adding more CPU's will give you more bang for
the buck than another system in most cases like
yours). 

In cases where you need the scalability and your
application is designed for it (pre-9i), you can make
it work. The simpler the application the easier it
will be to get functional.

I prefer the terminal releases of any of these
versions up to and including 9.0.1.4.

Bill

--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> I have one application which is running on Oracle
> 8.1.6.But most of time CPU 
> idea is very low due to capacity peak.I am looking
> for either Oracle 
> Parallel server or Oracle9i.Oracle Parallel server
> would distribute the load 
> but question is.
> Is Oracle Parallel server is stable in rel 8.1.7 or
> rel 9i?
> We are also thinking to upgrade Oracle9i,What Would
> be the group View on 
> Oracle9i?
> Is is ok to move forward Oracle9i for production
> database?
> Any statistics how much %of peoples are using Oracle
> Parallel server and 
> Oracle 9i right now?
> Thanks
> -Seema
> 
> 
>
_
> Send and receive Hotmail on your mobile device:
> http://mobile.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Rename Column in 9iR2

[DENNIS WILLIAMS]

Hermat - We are on Tru64 and I couldn't be more pleased. However, I believe
that HP/Compaq has decided to eventually withdraw Tru64. My guess is that is
so they can support HPUX. However, they were pretty clear that OpenVMS would
continue. My guess is that Ron is hinting that there are other reasons to
move to VMS at his company. Just sign me as "learning Solaris".
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 23, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L



The bane of trying to keep up with technology.
But why OpenVMS and not Tru64, then.
We have a large number of Tru64 Oracle Databases
(we do have OpenVMSs for Promis databases
used in manufacturing, I believe).

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 11:03 PM


Hemant,
  The price I am referring to is the cost involved with moving from a
Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
company sided issues that have to be addressed and cases made for the
move. In this case the software is not an issues as you stated, the
issues revolve around the hardware and developmental considerations. I
would be more that happy to move to the latest and greatest "solid"
platform/database combination. It would allow us to create and implement
browser based applications rather easily and would allow us to use the
9iAS Suite of products.
 For now all I can do is make requests for item to be included in the
budget as we move "forward, backwards, sideways, dance on circles".
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 09:38AM >>>

An upgrade wouldn't cost anything.  It would be free
as part of your support contract.

Hemant K Chitale

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 2:41 AM


Kevin,
 I appreciate your testing efforts. Now to convince the bean-counters
to upgrate to 9i.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 02:08PM >>>
I reran my test. with 250,000 rows in the table. It took a whopping
0.25
seconds to complete.

-Original Message-
Sent: Wednesday, May 22, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Kevin,
 Yes but does it work with data in the column?, I do not have 9i set
up
yet. If it works as you describe with data in the column it will
really
help with the multi million row tables that "they" want to rename a
column  after a release of a new lotto game.
thanks,
for the test and update.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/22/02 10:38AM >>>
Summary: it works!

SQL> SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL> create table test_table (wrong_name VARCHAR2(40));

Table created.

SQL> alter table test_table rename column wrong_name to right_name;

Table altered.

SQL> desc test_table;
 Name  Null?Type
 - 

 RIGHT_NAME VARCHAR2(40)

SQL>

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant
Confidential
and may be legally privileged. It is intended solely for the
addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in
reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This
message and
its attachments could have been infected during transmission. By
reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Trilegiant Corporation is not liable for any loss or
damage
arising in any way from this message or its attachments.

--
--


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  

Re: SORT

[basher 59]

Sort area size is used to sort, but so is the temporary table space.  Can 
increase your sort area size?   Both sort_area_size and 
sort_area_retained_size need to be looked into.
sort_area_retained_size specifies in bytes the maximum amount of the user 
global area (UGA) memory retained after a sort.
SORT_AREA_SIZE specifies in bytes the maximum amount of memory Oracle will 
use for a sort.

So sort_area_retained_size is the min and sort_area_size is the max.
You will also use the temporary table space to do sorts.   Also as a note 
not everything will be sorted in memory.  Sometimes our sorts go to disk.

Here is a big key when trying to increase the speed of sorts.  Check the 
paramers of the temporary table space.   What is the initial extent size and 
what is the next extent size.   Some time our sorts have 100's of extents.   
This is bad , try and minimize this by increase the extent sizes.

BYE.
MN


>From: Remacle Jean <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: SORT
>Date: Thu, 23 May 2002 08:28:38 -0800
>
>Hi all,
>
>I did some testing on sorts. I sorted a table of 269 MB. I did set the
>sort_area_size to a minimum value of 10k. I set event 10032 to level 1 and
>looked after the initial runs to be able to calculate a good value for
>sort_area_size. Once this done, I did run the statement with event 10053 
>set
>to level 1 and discovered that initial runs did not match.
>With 10032 I get 6 as initial runs and sort_area_size is 385024 where under
>10053 I get 1069 initial runs and an area_size of 264192. So if you make 
>the
>maths you discover that the sorted size is about (6*385024) 2.2 MB for 
>10032
>and is (1069*264192) 269 MB for 10053.
>I guess that event 10053 reports just a simulation and it divides the table
>size by its area size to get the number of initial runs. Event 10032 
>reports
>the real numbers of what happened.
>But then my question is how can it sort 269 MB of data in 2.2 MB of sort
>space? My guess is that it only needs space for sorted rows and this is a
>group by. So, the number of rows to sort is 3884794 times 73 bytes (avg row
>length) is 269 MB. The number of output rows is 19839 times 73 is 1.4 MB it
>will fit in 2.2 MB.
>Another question is why that SORT_SIZE is reported instead of
>SORT_AREA_SIZE?
>
>Here is the statement and execution plan:
>
>SELECT
>   trunc(collecttime, 'HH24'),
>   expname,
>   ipaddr,
>   hostname,
>   instance,
>   sum(floatvalue),
>   sum(stopticks - startticks) / 10 cnt
>FROM
>   coldata
>group by expname,
>  ipaddr,
>  hostname,
>  instance,
>  trunc(collecttime, 'HH24');
>
>Execution Plan
>--
>0SELECT STATEMENT Optimizer=FIRST_ROWS (Cost=95599 Card=3866581
>Bytes=220395117)
>10 SORT (GROUP BY) (Cost=95599 Card=3866581 Bytes=220395117)
>21   TABLE ACCESS (FULL) OF 'COLDATA' (Cost=2294 Card=3866581
>Bytes=220395117)
>
>Jean Remacle
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Remacle Jean
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: basher 59
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: patchset 8.1.7.3 or 8.1.7.4

[Ray Stell]

The readme added today on 8.1.7.4 patch says:

Post Release Issues Issues that are discovered after release of this
patch set are documented on the Oracle Metalink website. Customers
should check here for the latest status prior to installing this patch
set in a production environment.

To see the latest Status and Alerts for this patch set, please read
Doc.Id: 120607.1 





On Thu, May 23, 2002 at 08:03:34AM -0800, Hemant K Chitale wrote:
> 
> The patchsets _are_ cumulative.  You can
> go direct from 8.1.7.0 to 8.1.7.3 or to 8.1.7.4
> [we normally don't go to the latest patchset level
> but wait a few weeks or a couple of months to
> see that no major issues are reported with the
> latest patchsetlevel].
> 
> Hemant K Chitale
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, 23 May, 2002 11:18 PM
> 
> 
> > Hi
> >
> > Are these patch sets cumulative? If I am at 8.1.7.0 can I
> > just apply the 8.1.7.4 patch set or do I have to apply
> > them all in order. Thanks.
> >
> > -Original Message-
> > Travis
> > Sent: May 22, 2002 2:39 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> > ase_id=NOT&p_id=120607.1
> >
> > http://ap103aru.us.oracle.com/ARULink/PatchSearch/get_form
> >
> > > -Original Message-
> > > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, May 22, 2002 1:06 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: patchset 8.1.7.3 or 8.1.7.4
> > >
> > >
> > > Dear List,
> > >
> > > What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I
> > > download them?   I looking on the FTP site and on Metalink
> > > but I couldn't
> > > tell which was which.
> > >
> > > Thanks,
> > > Ruth
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Glenn Travis
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Ben
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Hemant K Chitale
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
Sa

Re: Rename Column in 9iR2

[Ron Rogers]

Hemant,
  Being an "ol" unix admin I would like very much to use Tru64 but we
have a lot of applications written for OpenVMS that would have to be
converted and then there would be the issue of sysadmin training or hire
and licensing issues and costs. These all cost $$$ and we are an
institution that has to return a minimum sales % to the winner and the
schooling endeavors.  Besides I think it will be exiting and challenging
to learn a new system. 
Ron

>>> [EMAIL PROTECTED] 05/23/02 12:28PM >>>

The bane of trying to keep up with technology.
But why OpenVMS and not Tru64, then.
We have a large number of Tru64 Oracle Databases
(we do have OpenVMSs for Promis databases
used in manufacturing, I believe).

Hemant K Chitale

-- 
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).

RE: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Ron Rogers]

Thanks, Barb.
 From the traffic on this issue I think that there is quite a few VMS
users on the list. They have been quiet and do not generate a lot of
traffic. Does this mean that I have to watch all of the other traffic
and think to myself " why not convert to VMS and not have the
problems?"
 Just rambling
Ron
ROR mô¿ôm

>>> [EMAIL PROTECTED] 05/23/02 01:13PM >>>
Ron:
There's a list at
iouga-vms-l

The traffic is very-very-very-very light. However, when I've needed
help,
the responses have been exceptional.

Good luck!
Barb


--
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).

Re: so when did you switch from NT to unix for oracle

[Ron Rogers]

Joe,
 I do not know if it is still valid but here is part of a message from
05/2000 that talked about the 4GB on NT.
"With Oracle 8.1.6 on NT there is an option to allow you to use all of
the 4 GIG as noted in the 8I Administrators Guide for Windows NT section
10. 4GB RAM Tuning (4GT) for windows NT server, Enterprise Edition. More
information can be found at
http://www.microsoft.com/ntserver/ntserverenterprise/exec/feature/4gbt.asp


Ron
ROR mª¿ªm



>>> [EMAIL PROTECTED] 05/23/02 12:33PM >>>

Number of users.  I have a 170G Oracle 8.1.6 database running on WinNT
4.0
with 3xx of RAM just fine, as long as there are no more than 2 users. 
Jump
up to about 16 users and response time goes down the tube.

So I guess that transactions are the answer.  I don't have any
benchmarks.
Just my $.02.



   
   
JOE TESTA  
   

   
com> cc:   
   
Sent by: rootSubject: so when did you
switch from NT to
 unix for oracle   
   
   
   
05/23/2002 
   
09:48 AM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   





A question has been posed to me, when to switch from NT to unix for
oracle.

Is it when the NT box starts getting out of memory issues, number of
transactions, size of db?

just looking for some ball park answers.

thanks, joe




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).

NEED YOUR ADVISE

[Hamid Alavi]

Hi List,

I faced with an strange problem, I have an query some times when I run this
query I got error ORA-01722 invalid number and then when I rebuild the table
then rerun the query it's running OK, anybody have any idea what should be
wrong.
Same table same query failed first time then when I rebuild the table with
same data running OK.

Oracle 8.1.7.0 & 8.1.6 sun solaris


Thanks in Advance



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
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. 
= End Confidentiality Statement =  


-- 
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).

RE: Data Warehouse experts, a simple question for you|

[Ron Rogers]

Rachel,
 This was just received from the "SearchDatabase" email and I thought
it might be of interest to you.
.
TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2)

By William McKnight, SearchCRM Expert

Another question I received [last week at the Data Warehousing
Institute World Conference] had to do with placement of the data
warehouse and the potential myriad of other databases (staging, data
marts, ODS, etc.) in the data warehouse architecture. The recommended
approach by the questioner's management was to place them all on the
same DBMS instance -- the same instance that the main operational
source system was on...

Read the rest of this strategy at:
http://www.searchCRM.com/tip/1,289483,sid11_gci825543,00.html 

Read the first part of this strategy at:
http://searchcrm.techtarget.com/tip/1,289483,sid11_gci824982,00.html?FromTaxonomy=/pr/288366



Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/23/02 01:43PM >>>
Dennis,

We are active participants in the process. We are also making an offer
to someone with an extensive background in developing data warehouses,
which will help me to sleep much more comfortably at night :)

Rachel


--
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).

RE: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Gene Sais]

VMS uses logicals as much as Unix uses environment variables.  I use vms logicals and 
unix env variables in my db create scripts.  VMS logicals also work for init.ora 
params (eg. control_files) whereas in Unix, you must spell it out.

gene
*used vms b4 dos was around :)*

>>> [EMAIL PROTECTED] 05/23/02 12:33PM >>>
I can add to Jesse's comments.  VMS has always been the bastard of Oracle
Platforms even though it was written for VMS initially.  Remember that Larry
first wrote Oracle on the VMS platform.

The installation process is actually very clean as compared to many other
environments. Yes, it does require additional knowledge of how logicals and
symbols function, and yes OFA does not "truly" exist within the spectrum as
it does on Unix.   However, OFA does exist within the OpenVMS environment
and is the responsibility of the DBA to exercise the implementation of it.
Thus, only war-torn DBAs understand the VMS environment of Oracle and have a
relatively easy time implementing on this platform.

As far as logicals within the database, Jesse is correct in that Oracle is
not very friendly with them if you want datafiles to use logicals.  However,
if you define the logicals as "terminal, rooted" logicals, Oracle does not
translate them.  In fact, this is the proper way to define data files versus
using the device name.  What happens if you have to move the device from
DSA10 to DSA100, but the disk is still the same?  It is simply moving to
another controller.  You are screwed if you use the physical device name.
If you use logicals, all works well.

Jesse is right.  VMS is the strongest and most robust platform Oracle runs
on.  If not, then why did Oracle buy RDB and use Compaq (sorry DEC) for the
clustering technology for 9i RAC?  Contradict that one and you should open
up your own database company.

Enough ranting.  Become familiar with Open VMS and all will be well.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
Sent:   Thursday, May 23, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle and OpenVMS (was: Rename Column in 9iR2)

As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this.  At least as far up as
8i, Oracle has really done themselves a disservice by bastardizing their own
install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY difficult to
create and maintain a database without using Oracle's horrid scripts.
Oracle refuses to recognize VMS logicals in the DB (although you can fool
it).  And do NOT use OpenVMS if you need MTS because it simply does not
work, even in 9i (see the Midrange forum on MetaClink).

I'm saying this and I'm a huge fan of VMS.  I've been working with it since
v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
reason, companies that produce software on multiple platforms tend to screw
up their VMS installs.  I have no idea why.  I've been working in Unix for
four or five years now and just don't understand why people in the
Unix/Winders world make OpenVMS so difficult!  It's EASY!



VMS (whoops..."OpenVMS") gets a bad rap because of poor marketing, and a
poor understanding of how VMS works by the people that develop on it and/or
manage the systems.  Hell, my OpenVMS box here that's running 4 Oracle 8.0.5
instances has had 5 minutes of down time in the past 716 days.  And that
downtime was due to a network failure.  Five "9"s, baby, and then some!

Woah...once again, DBA need beer.

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, May 23, 2002 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rename Column in 9iR2
> 
> 
> Hemant,
>   The price I am referring to is the cost involved with moving from a
> Dell server on Novell to a Compaq OpenVMS server.  There are a lot of
> company sided issues that have to be addressed and cases made for the
> move. In this case the software is not an issues as you stated, the
> issues revolve around the hardware and developmental considerations. I
> would be more that happy to move to the latest and greatest "solid"
> platform/database combination. It would allow us to create 
> and implement
> browser based applications rather easily and would allow us to use the
> 9iAS Suite of products.
>  For now all I can do is make requests for item to be included in the
> budget as we move "forward, backwards, sideways, dance on circles".
> Ron
> ROR mª¿ªm
-- 
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 

RE: Oracle RAC and NAS

[David Wagoner]

Here is an informative article entitled "Sane SAN", by James Morle that
describes the use of SAN and NAS from a database performance perspective.
Good reading...

http://miracleas.dk/DBF/Morle/Sane_SAN_WP.pdf



HTH,

david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Office (919) 466-6723
Pager [EMAIL PROTECTED]
Fax (919) 466-6783
http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Thursday, May 23, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

Stefan - By NAS, I assume you mean "Network Attached Storage". We use a Net
Appliance on our test server and it works well for the purpose. Basically we
have about a dozen Oracle instances which are used infrequently, so it
provides tons of cheap storage that isn't used that much. I found out the
hard way that you can overwhelm it with too many simultaneous heavy batch
jobs. My guess is that with both RAC and NAS the key is to configure the
highest-speed dedicated connections possible.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 23, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L


Hello everybody,

I was wondering if anybody has real "hands-on" experience with either a
combination of both RAC and NAS or just running 9i on an NAS. What are the
pros and cons ? Does anybody have some input on this topic ? Maybe some
helpful links besides technet ?

TIA
Stefan



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Wagoner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Rename Column in 9iR2

[Gene Sais]

Ron - I have my VMS env set similar to my unix env.  I use vms symbols to match unix 
aliae's/cmds, vms logicals to match unix env variables, vms dcl scripts to match unix 
ksh scripts.  Even have a crontab dcl script that works much like unix cron (well 
almost :)).  I have 1 dcl script for all batch scheduling.  VMS is fun, just wish 
there were more companies using it.  Strange to see companies considering to start 
using VMS.  Usually they go w/ W2K or Unix.  Old oracle licensing is cheaper on VMS.  

Gene

>>> [EMAIL PROTECTED] 05/23/02 02:32PM >>>
Hemant,
  Being an "ol" unix admin I would like very much to use Tru64 but we
have a lot of applications written for OpenVMS that would have to be
converted and then there would be the issue of sysadmin training or hire
and licensing issues and costs. These all cost $$$ and we are an
institution that has to return a minimum sales % to the winner and the
schooling endeavors.  Besides I think it will be exiting and challenging
to learn a new system. 
Ron

>>> [EMAIL PROTECTED] 05/23/02 12:28PM >>>

The bane of trying to keep up with technology.
But why OpenVMS and not Tru64, then.
We have a large number of Tru64 Oracle Databases
(we do have OpenVMSs for Promis databases
used in manufacturing, I believe).

Hemant K Chitale

-- 
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: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle and OpenVMS (was: Rename Column in 9iR2)

[Gogala, Mladen]

Do this:
$define/system sys$error nla0:  
and everything will be working fine. Those pesky error messages will be
gone. Just kidding. There is, however an open source project called
"FreeVMS" 
which wants to do exactly that: to create a free version of OpenVMS for PCs,
much like Linux. The home page of the project is at:
http://freevms.free.fr/indexGB.html
There is also a commercial company providing a wonderfull emulation for
various
Unix systems. They ported DCL, backup and, yes, my favorite "GOLD-PF6" EDT
editor.
EVE (Extended VAX Editor) was by far the best editor I've ever worked with.
Utilities like monitor (mon modes, mod disk/item=queue, mon page, mon pool) 
and backup (backup/ignore=interlock), help system and sysgen are unsurpassed
peaks of computing and I've never seen anything even remotely as practical
as an OpenVMS system. Even tricks of the trade, like "set watch" command
were asthetically nice.

> -Original Message-
> From: Gene Sais [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 23, 2002 2:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
> 
> 
> 
> VMS uses logicals as much as Unix uses environment variables. 
>  I use vms logicals and unix env variables in my db create 
> scripts.  VMS logicals also work for init.ora params (eg. 
> control_files) whereas in Unix, you must spell it out.
> 
> gene
> *used vms b4 dos was around :)*
> 
> >>> [EMAIL PROTECTED] 05/23/02 12:33PM >>>
> I can add to Jesse's comments.  VMS has always been the 
> bastard of Oracle
> Platforms even though it was written for VMS initially.  
> Remember that Larry
> first wrote Oracle on the VMS platform.
> 
> The installation process is actually very clean as compared 
> to many other
> environments. Yes, it does require additional knowledge of 
> how logicals and
> symbols function, and yes OFA does not "truly" exist within 
> the spectrum as
> it does on Unix.   However, OFA does exist within the OpenVMS 
> environment
> and is the responsibility of the DBA to exercise the 
> implementation of it.
> Thus, only war-torn DBAs understand the VMS environment of 
> Oracle and have a
> relatively easy time implementing on this platform.
> 
> As far as logicals within the database, Jesse is correct in 
> that Oracle is
> not very friendly with them if you want datafiles to use 
> logicals.  However,
> if you define the logicals as "terminal, rooted" logicals, 
> Oracle does not
> translate them.  In fact, this is the proper way to define 
> data files versus
> using the device name.  What happens if you have to move the 
> device from
> DSA10 to DSA100, but the disk is still the same?  It is 
> simply moving to
> another controller.  You are screwed if you use the physical 
> device name.
> If you use logicals, all works well.
> 
> Jesse is right.  VMS is the strongest and most robust 
> platform Oracle runs
> on.  If not, then why did Oracle buy RDB and use Compaq 
> (sorry DEC) for the
> clustering technology for 9i RAC?  Contradict that one and 
> you should open
> up your own database company.
> 
> Enough ranting.  Become familiar with Open VMS and all will be well.
> 
> Thank You
> 
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED] 
> Web:  www.compuware.com 
> 
>  -Original Message-
> Sent: Thursday, May 23, 2002 11:33 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle and OpenVMS (was: Rename Column in 9iR2)
> 
> As a side note, please please please become familiar with 
> OpenVMS and more
> importantly Oracle on OpenVMS before tackling this.  At least 
> as far up as
> 8i, Oracle has really done themselves a disservice by 
> bastardizing their own
> install on OpenVMS.  There is no OFA on OpenVMS.  It is VERY 
> difficult to
> create and maintain a database without using Oracle's horrid scripts.
> Oracle refuses to recognize VMS logicals in the DB (although 
> you can fool
> it).  And do NOT use OpenVMS if you need MTS because it 
> simply does not
> work, even in 9i (see the Midrange forum on MetaClink).
> 
> I'm saying this and I'm a huge fan of VMS.  I've been working 
> with it since
> v4.7 and haven't seen an OS that compares.  HOWEVER, for some unknown
> reason, companies that produce software on multiple platforms 
> tend to screw
> up their VMS installs.  I have no idea why.  I've been 
> working in Unix for
> four or five years now and just don't understand why people in the
> Unix/Winders world make OpenVMS so difficult!  It's EASY!
> 
> 
> 
> VMS (whoops..."OpenVMS") gets a bad rap because of poor 
> marketing, and a
> poor understanding of how VMS works by the people that 
> develop on it and/or
> manage the systems.  Hell, my OpenVMS box here that's running 
> 4 Oracle 8.0.5
> instances has had 5 minutes of down time in the past 716 
> days.  And that
> downtime was due to a network failure.