date:20010314


It just monitors Up/Down, I think.

Sometimes it doesn't work very well, my SQL Server has been down for two
days (I don't use it) and the green flag is still up inside the OEM.

I have problems with my test server though, jre.exe is hogging the system.

Do you know if the OEM can monitor MS Access and Excel?

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
From:   Nguyen, Long [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 13, 2001 6:07 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OEM day today?

I don't know about publicity but if you install OEM 2.2 (Management
Pack I think) you would see a product in there that allows the monitoring of
SQL
Server.

Long

-Original Message-
Sent: Wednesday, 14 March 2001 8:11 AM
To: Multiple recipients of list ORACLE-L


Since today seems to be the official OEM day on the list, here is
something
I just discovered (may not be news to others). OEM supports MS SQL
Server
services. While "discovering" one of Oracle databases running on
Win2k, I
noticed new entry in Console tree: SQLServers. Upon starting Data
Gatherer
on that lonely Windoz box, I was able to fire up Performance Manager
(part
of Diagnostics pack) and view all sorts of interesting info about
SQL Server
databases. Has this been publicized by Oracle anywhere?

Gary Weber

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

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

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

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

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

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

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

RE: oracle and America


The whole c2 security thing and the POSIX compliance for NT were so they
could sell their OS to the government, wasn't it?

I think they may have dropped POSIX from Windows2000, I don't know if it
ever worked very well.

They did the same thing when OS/2 seemed a plausible alternative, NT
supported HPFS.  When OS/2 dropped off the map, MS dropped support for HPFS.

They only support competing standards when they have to, I think.  Once they
gain market share they drop all that extra "fluff".  Then competing products
have to be compatible with theirs, not the other way around.  It saves them
on costs of development, support, etc.

I am waiting to see when they will drop NWLINK from their OS.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Jerry C [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 13, 2001 6:07 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: oracle and America

Holy mackerel!

I hope there isn't some rogue nation buying all our old VAX clusters
to run
their navy. We'll get our behinds kicked!


- Jerry

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:06 AM


 On Tue, 13 Mar 2001, Boivin, Patrice J wrote:

  I thought I heard a story about a U.S. Navy ship that was towed
to port
  because its systems ran on WindowsNT...
 
  Maybe it was an urban myth.
 
  I was glad to hear that the Boeing planes run on UNIX.
 
  ; )
 
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)

 No myth this.  ( yeth? ;)

 Here's a reference:

 http://www.gcn.com/archives/gcn/1998/july13/cov2.htm

 Jared


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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

RE: jre.exe using up too much CPU


I have 654M of RAM.

I logged a TAR with Oracle, we'll see how it goes today.

I will just monitor db up/down, listener up/down, host up/down for now, all
it takes is one bad item to mess up a server.

Thanks
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
From:   Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 13, 2001 4:38 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: jre.exe using up too much CPU

Not sure it is relevant, but:

Oracle Tech Support told me that to run OEM on a desktop
machine (PIII/700) that came with 128Mb RAM, it would be
necessary to add *AT LEAST* and additional 256Mb RAM. 
With all the stuff you've got installed I hope you have 
a lot of RAM in that box.

regards,
ep

On 13 Mar 2001, at 11:49, Boivin, Patrice J wrote:

Date sent:  Tue, 13 Mar 2001 11:49:44 -0800
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]

 Jre on my OEM test server is using up 80-96% of CPU, consistently.
This is
 while monitoring its own repository database, plus an Oracle 7.3.4
and 8.0.4
 database on my workstation.  Intelligent agent on my workstation
is from
 version 8.1.7., I upgraded it.  I also have an MS SQL Server 7
database that
 is idle.

...


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

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

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

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

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

Order of table_name resolution

2001-03-14 Thread Cale, Rick T (Richard)


Hi DBAs,

Can someone clarify/confirm on how Oracle determines what table to use in
select statement?

For ex. If I am login as Scott and do the following:

SELECT * FROM employee;

Of course Oracle will use Scott.employee if it exist. If it does not exist
but exist under another schema. Does
Oracle look at private synonyms then public synonyms or vice versa. 

My guess is Oracle checks in this order. Please confirm or correct.

1. Check if table exist in current schema
2. Check private synonyms
3. Check public synonyms
4. 3 strikes your out with an error.

Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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


I am not positive, but I think that is the correct order.  This had been
discussed before and ofcourse, with my limited brain capacity I can't
remember.
Kev

-Original Message-
T (Richard)
Sent: Wednesday, March 14, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L


Hi DBAs,

Can someone clarify/confirm on how Oracle determines what table to use in
select statement?

For ex. If I am login as Scott and do the following:

SELECT * FROM employee;

Of course Oracle will use Scott.employee if it exist. If it does not exist
but exist under another schema. Does
Oracle look at private synonyms then public synonyms or vice versa.

My guess is Oracle checks in this order. Please confirm or correct.

1. Check if table exist in current schema
2. Check private synonyms
3. Check public synonyms
4. 3 strikes your out with an error.

Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-03-14 Thread Adams, Matthew (GEA, 088130)

Title: RE: AW: Script for reversing a string?



Jack, 


According to 
the article, Oracle has not documented it
anywhere.
 R. Matt 
Adams - GE Appliances - [EMAIL PROTECTED]  Contrary to popular opinion, Unix is user 
friendly.  It's just 
particular about who it makes friends with. 


  -Original Message-From: Jack C. Applewhite 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 13, 2001 
  5:01 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: AW: Script for reversing a string?
  Matt,
  
  I'mglad to know where IOUGhas documented 
  this function, but I'd still like to know where (if?) Oracle has done 
  so.
  
  BTW, 
  I have frequently been a member of IOUG over the past 10 or 11 years, just not 
  at the present.
  
  Thanks.
  
  Jack
  Jack C. 
  ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 
  DBAiNetProfit, Inc.Austin, 
  Texaswww.iNetProfit.com[EMAIL PROTECTED]
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, 
088130)Sent: Tuesday, March 13, 2001 3:05 PMTo: 
Multiple recipients of list ORACLE-LSubject: RE: AW: Script for 
reversing a string?
If you were a member of the international oracle 
users group, you would have found this function 
documented in the Jan. 2001 issue of Select 
magizine 
 R. Matt Adams - GE 
Appliances - [EMAIL PROTECTED]  Contrary to popular opinion, Unix is user 
friendly.  It's just 
particular about who it makes friends with. 
 -Original Message-  
From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, March 13, 2001 3:31 PM  To: Multiple recipients of list ORACLE-L  Subject: RE: AW: Script for reversing a string?
Jared,   Well, I've 
RTFM for 8.1.6 and the SQL Reference doesn't  
mention a Reverse() function. However, there is a supplied 
 PL/SQL Reverse() function in the Utl_Raw 
package. Is there  a connection? If 
so, how? If not, are my 8.1.6 docs just  
wrong?   
Thanks.   
Jack

Re: Order of table_name resolution

2001-03-14 Thread Richard T. Vander Laan


Rick, I am looking for an Oracle DBA for our office in Des Moines, IA. Do
you know of anyone that might be interested.  Also, have Oracle Financial
and CRM positions open in Fall Church VA.  Let me know if you know of
someone.  Thank you in advance. Dick Vander Laan
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 5:00 AM


 Hi DBAs,

 Can someone clarify/confirm on how Oracle determines what table to use in
 select statement?

 For ex. If I am login as Scott and do the following:

 SELECT * FROM employee;

 Of course Oracle will use Scott.employee if it exist. If it does not exist
 but exist under another schema. Does
 Oracle look at private synonyms then public synonyms or vice versa.

 My guess is Oracle checks in this order. Please confirm or correct.

 1. Check if table exist in current schema
 2. Check private synonyms
 3. Check public synonyms
 4. 3 strikes your out with an error.

 Rick Cale, Science Applications International Corp.
 Phone:865-481-2198, fax:865-481-8555
 e-mail: [EMAIL PROTECTED]

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Cale, Rick T (Richard)
   INET: [EMAIL PROTECTED]

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

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

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

2001-03-14 Thread Tim Sawmiller


 oerr ora 24371
24371, 0, "data would not fit in current prefetch buffer"
// *Cause:  An internal OCI error has occurred.
// *Action: Please contact Oracle customer support.



 [EMAIL PROTECTED] 03/13/01 05:15PM 
Hi Gang,
One of the developers came to me with this error. There is nothing in the
alert log or no trace files were generated. I'm at a complete loss. He was
executing a query from a front-end API.

This is running on 8.1.6, Solaris 8 on a Sun 450.

TIA,

-Rocky

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED] 

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

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

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

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

Title: RE: Oracle Internals





HP, it is sleep/wake/check. it is up to the process to acquire the
resource. AFAIK, there is no message-passing type of algorithm to
tell waiting (whether spinning or sleeping) processes when the 
semaphore becomes unset ( ie the resource is available ) Sleeps 
are expensive in Latchville, and you can track their occurence 
via v$latch_waits and the SLEEP* columns. 


hope this partial answer helps. 


-Original Message-
From: Henry Poras [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Internals



I have been rereading Steve Adam's book a bit more carefully and have a
question. Just wondering if anyone has any answers.


When talking about latch sleeps, the book states a process sleeping for a
latch waits on its semaphore. However, latches don't support queuing and a
number of processes may be waiting for the same latch. If I am sleeping and
the latch frees, who knows I need that semaphore? Are all waiting processes
posted with the semaphores going on/off/on/off? or is no semaphore posted
and the processes go sleep/wake/check/sleep/wake/check? I can't quite
picture the details here.


Henry





Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
 INET: [EMAIL PROTECTED]


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

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

DBA job market in Australia and Asia?

2001-03-14 Thread dana



What's the job market like for Oracle DBAs in Australia (Queensland and
NSW)? Is demand being satisfied mostly with local talent? I've heard
that's the case for much of the IT market there.

Would it be difficult for an American Oracle DBA to secure a work visa
in Australia or Asia? Any demand for English-speaking Oracle DBAs in
Asia? I've heard English-speaking techs are in high-demand over in
Asia, but where specifically and doing what specifically I don't know
(possibly technical training conducted in English, or English for
programmers/engineers/techs; or technical writing).

How would a person go about finding these jobs? Any companies hiring
around Boston that would send Oracle DBAs on overseas assignments?


Thanks very much.

 - Dana


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread chaoping


hi, gurus:
 i read the article of  early time e and tried my self, hoping to insert a bin 
file into a lob column of the database.but failed.

my env:
win2000 prof+oracle817.

SQL  desc lobtable
 Name  Null?Type
 -  --
 NAME  NOT NULL VARCHAR2(80)
 LARGEOBJ   BLOB

SQL select name from lobtable;

NAME
---
test
test2
test3
and the largeobj of the third line is null.

first i created a directory:
SQL  create directory picture as 'h:\games';
Directory created.

then i wrote a stored program:
PROCEDURE LOAD_LOB is
  obj blob;
  fils bfile:=bfilename('picture','1.jpg');
  amt integer:=400;
  begin
  select largeobj into obj from lobtable where name='test3';
  dbms_lob.fileopen(fils,dbms_lob.file_readonly);
  dbms_lob.loadfromfile(obj,fils,amt);
 commit;
 dbms_lob.fileclose(fils);
  end;


and the 1.jpg does exist in the h:\game\1.jpg
and when i run the program, it said:
SQL exec load_lob;
BEGIN load_lob; END;

*
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 475
ORA-06512: at "CHAOS.LOAD_LOB", line 7
ORA-06512: at line 1

i checked the dbms_lob package's reference,but can't find out what is wrong.
i even tried replace the picture dir with 'h:\games', but also failed.
can u give me some advice?
thanks alot.


z}ND@Bm
+irhZDO8nrKyV
+r5pzqw9P9tT8'x'zq,).+-:*.}bf)+-jq
+j)fzh.+-}\i$ex(|k{azgw%)rj)
+I@ND+jg~f)+-j{mzj/yf(fj[(iaz~jXzn)

Inteligent Agent on Oracle817 for OS/390 OSDI

2001-03-14 Thread Sonja ehovi


List hi!
My colleuge have problem with this configuration
Does anyone have a cook book for configuring this product?
If anyone have it, would you be so kind to send it directly to:
[EMAIL PROTECTED]

TIA,
Sonja
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

RE: new in Developer 2000


Since you are using above 8.0.4, you can have multiple homes, so put it
wherever you want.

Dan

-Original Message-
Sent: Tuesday, March 13, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L



Dear Listers,

I plan to install Oracle Developer 2000 on my NT which Oracle Database
Server 8.0.5 Installed. I installed Oracle DB server in D:\orant

which better directory I have to choose for Dev2000 installation ?

thanks in advance : )

=bambang=


 Bambang Setiawan 

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

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

RE: Order of table_name resolution

2001-03-14 Thread Carle, William T (Bill), NLCIO


I don't think you can have a synonym that conflicts with a name in your own
schema. For example, if scott has an employee table and you try "create
synonym employee for mary.employee;", Oracle will give you an error "name is
already used by an existing object."


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Wednesday, March 14, 2001 7:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Order of table_name resolution

Hi DBAs,

Can someone clarify/confirm on how Oracle determines what table to use in
select statement?

For ex. If I am login as Scott and do the following:

SELECT * FROM employee;

Of course Oracle will use Scott.employee if it exist. If it does not exist
but exist under another schema. Does
Oracle look at private synonyms then public synonyms or vice versa. 

My guess is Oracle checks in this order. Please confirm or correct.

1. Check if table exist in current schema
2. Check private synonyms
3. Check public synonyms
4. 3 strikes your out with an error.

Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-03-14 Thread Gary Weber


Event-wise, yes, only UpDown is available out of the box. However, it lets
one see inside of the windows server AND inside of SQL db
(buffers/logs/hits/etc.).

Far as Access and Expell, for the right price I could prolly right few tcl
scripts to manage those as well :)

Gary Weber


-Original Message-
Patrice J
Sent: Wednesday, March 14, 2001 7:21 AM
To: Multiple recipients of list ORACLE-L


It just monitors Up/Down, I think.

Sometimes it doesn't work very well, my SQL Server has been down for two
days (I don't use it) and the green flag is still up inside the OEM.

I have problems with my test server though, jre.exe is hogging the system.

Do you know if the OEM can monitor MS Access and Excel?

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


-Original Message-
From:   Nguyen, Long [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 13, 2001 6:07 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OEM day today?

I don't know about publicity but if you install OEM 2.2 (Management
Pack I think) you would see a product in there that allows the monitoring of
SQL
Server.

Long

-Original Message-
Sent: Wednesday, 14 March 2001 8:11 AM
To: Multiple recipients of list ORACLE-L


Since today seems to be the official OEM day on the list, here is
something
I just discovered (may not be news to others). OEM supports MS SQL
Server
services. While "discovering" one of Oracle databases running on
Win2k, I
noticed new entry in Console tree: SQLServers. Upon starting Data
Gatherer
on that lonely Windoz box, I was able to fire up Performance Manager
(part
of Diagnostics pack) and view all sorts of interesting info about
SQL Server
databases. Has this been publicized by Oracle anywhere?

Gary Weber

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

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

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

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

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

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

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

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

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

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

Re: jre.exe using up too much CPU

2001-03-14 Thread Richard T. Vander Laan


Patrice, my company is looking for an Oracle DBA with Discoverer and Express
experience for our office in Des Moines, IA as well as Oracle Financial
developer with experience in the latest Oracle version for our Fall Church
VA office. If you know of someone, please let me know ASAP. Thank you in
advance
Dick Vander Laan
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 4:35 AM


 I have 654M of RAM.

 I logged a TAR with Oracle, we'll see how it goes today.

 I will just monitor db up/down, listener up/down, host up/down for now,
all
 it takes is one bad item to mess up a server.

 Thanks
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Rgion des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 -Original Message-
 From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 4:38 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: jre.exe using up too much CPU

 Not sure it is relevant, but:

 Oracle Tech Support told me that to run OEM on a desktop
 machine (PIII/700) that came with 128Mb RAM, it would be
 necessary to add *AT LEAST* and additional 256Mb RAM.
 With all the stuff you've got installed I hope you have
 a lot of RAM in that box.

 regards,
 ep

 On 13 Mar 2001, at 11:49, Boivin, Patrice J wrote:

 Date sent:  Tue, 13 Mar 2001 11:49:44 -0800
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]

  Jre on my OEM test server is using up 80-96% of CPU, consistently.
 This is
  while monitoring its own repository database, plus an Oracle 7.3.4
 and 8.0.4
  database on my workstation.  Intelligent agent on my workstation
 is from
  version 8.1.7., I upgraded it.  I also have an MS SQL Server 7
 database that
  is idle.

 ...


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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Boivin, Patrice J
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


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

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

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

2001-03-14 Thread Rocky Welch


Thanks, Tim. I checked the message and saw the same as you sent. I'm just
wondering if anyone has seen this before. The front end app is accessing
the data using java. Is it possible that and init.ora parameter is not set
correctly?

--- Tim Sawmiller [EMAIL PROTECTED] wrote:
  oerr ora 24371
 24371, 0, "data would not fit in current prefetch buffer"
 // *Cause:  An internal OCI error has occurred.
 // *Action: Please contact Oracle customer support.
 
 
 
  [EMAIL PROTECTED] 03/13/01 05:15PM 
 Hi Gang,
 One of the developers came to me with this error. There is nothing in
 the
 alert log or no trace files were generated. I'm at a complete loss. He
 was
 executing a query from a front-end API.
 
 This is running on 8.1.6, Solaris 8 on a Sun 450.
 
 TIA,
 
 -Rocky
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great prices.
 http://auctions.yahoo.com/ 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Rocky Welch
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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 Sawmiller
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Joseph Testa


Well(a cohort of mine on this list and) I worked with a 3terabyte(3000 gig) 
db before the project was dunked.

It was interesting to say the least playing with that much data.

it was to be an ODS and i played the dba role and the other guy(you know who 
you are) played the developer role,  he discovered some kewl stuff in 
dealing with hash partitions and how to determine the hash key beforehand, 
so that we could load millions of rows via sql*loader direct path into a 
specific partition.

joe



From: "Joan Hsieh" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Large DB Size? Manage datafiles?
Date: Wed, 14 Mar 2001 05:20:27 -0800
MIME-Version: 1.0
Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net 
(8.9.3/8.8.7) with ESMTP id JAA11449for jtestamail@localhost; Wed, 14 Mar 
2001 09:21:04 -0500
Received: from mail.the-testas.netby localhost with POP3 
(fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Wed, 14 Mar 2001 
09:21:04 -0500 (EST)
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by 
mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2EFLXw25355for 
[EMAIL PROTECTED]; Wed, 14 Mar 2001 09:21:33 -0600
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
(8.9.3/8.9.3) with UUCP id GAA81733;Wed, 14 Mar 2001 06:17:48 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002CC17E; 
Wed, 14 Mar 2001 05:20:27 -0800
Return-Path: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Joan Hsieh" [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match 
any local name
X-SpamBouncer: 1.2 (10/20/00)
X-SBPass: NoBounce
X-SBClass: OK
Status:

Our typical databases right now are 800gb size. Each datafile is 4gb on raw
disk (HP or SUNOS). One tablespace can have 85 datafiles. The data we deal
with are blobs. The performance is not that good. Lots of problem. This
place is not easy to change things. I think we should partition the table 
or
at least do parallel query.

Joan

-Original Message-
Sent: Wednesday, March 14, 2001 2:55 AM
To: Multiple recipients of list ORACLE-L


Dear All DBAs,

So far, I only manage small Oracle databases, size between 30-40 GB (all
datafiles). I just want to know how you will manage large Oracle database
with 100 or more GB. What size is the largest database size you ever 
manage?
How much data files and tablespaces you use for that database? Please share
your experience as enterprise DBA

Thank you in advance

Yuzzie

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

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

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

RE: Oracle Internals

Title: RE: Oracle Internals

make that "V$LATCH" to find the SLEEP1-11
columns

-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 14, 2001 9:06
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Internals
HP, it is sleep/wake/check. it is up to the process to acquire
the resource. AFAIK, there is no message-passing type
of algorithm to tell waiting (whether spinning or
sleeping) processes when the semaphore becomes unset (
ie the resource is available ) Sleeps are expensive in
Latchville, and you can track their occurence via
v$latch_waits and the SLEEP* columns.
hope this partial answer helps.
-Original Message- From: Henry
Poras [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:25 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Internals
I have been rereading Steve Adam's book a bit more carefully
and have a question. Just wondering if anyone has any
answers.
When talking about latch sleeps, the book states "a process
sleeping for a latch waits on its semaphore". However,
latches don't support queuing and a number of
processes may be waiting for the same latch. If I am sleeping and
the latch frees, who knows I need that semaphore? Are all
waiting processes posted with the semaphores going
on/off/on/off? or is no semaphore posted and the
processes go sleep/wake/check/sleep/wake/check? I can't quite picture the details here.
Henry
Think you know someone who
can answer the above question? Forward it to them! to
unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to
[EMAIL PROTECTED] Visit the list
archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
-- Please see the official
ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED]
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051 San Diego,
California -- Public Internet access
/ Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (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 installation

2001-03-14 Thread Yexley Robert D SSgt AFIT/SCA


Yeah I can see that absolutely.  I just completed migrating a test database
that we are testing for migration from 7.3.4 to 8.1.6.  The reason I
migrated it was because it had originally been on an UltraSparc 1 that had
192 MB of RAM and the thing would hardly run on that hardware.  We ended up
having to move it to another machine because of the lack of resources on the
original machine.  So yeah, I can see how doing this on a machine with 128
MB of RAM would take more than a day.

-::YEX::-
)))

-Original Message-
Sent: Wednesday, 14 March, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L


Hi,

Anyone tried install Oracle8i in Solaris with 128 Mbyte of memory ?
Is a stand alone server Oracle 8.1.6, not a production, is not hang but more
than 1 day to finish create a database ???

-- 
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: Yexley Robert D SSgt AFIT/SCA
  INET: [EMAIL PROTECTED]

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

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

STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread dana



Will statspack ever be available, in a supported version, for
Oracle 8.0.X? We'll be upgrading the machine I'm concerned about
to 8.1.X eventually (next six months or so); But for now, I'd like to
have access to a more sophisticated tuning-data gathering tool than
bstat/estat.

I find it appalling that bstat/estat can't collect, compare, and
contrast multiple sets of tuning data over time; that it can't
calculate db buffer cache hit ratios, etc.

We've purchased Spotlight on Oracle from Quest; But come to find out
(someone else did the research and made the purchase recommendation
before I became involved), Spotlight is merely a real-time monitor and
can't save tuning data. I thought about writing something to retrieve
data from the Spotlight tables, or modifying bstat/estat to make it do
what I want, but statspack seems to do everything I want - and who
wants to reinvent the wheel?

Any good tuning data gathering freeware out there (with statspack-like
functionality) for use with 8.0.X databases? 

Thanks very much.

 - Dana



__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: [EMAIL PROTECTED]

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

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


Ohhh, I think I remember having to set the classpath to also point to
the JRE rt.jar and I think you have to point to the actual file.  Sorry I
can't be more help, it's been a few months.

Dan

-Original Message-
Sent: Tuesday, March 13, 2001 10:10 PM
To: Multiple recipients of list ORACLE-L


when I unzip the zip file, it has 3 files: classes111.zip and 2 other files.

  I put it in the d:\jdbc\lib and set classpath=d:\jdbc\lib and the 
path=d:\jdbc\lib; Is that all I have to do?  I thought that I need to run 
something to set it up.  Thanks


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle JDBC driver
Date: Tue, 13 Mar 2001 15:15:20 -0800




Mai,

The only thing you have to do is to set your classpath correctly. That of
course if you are installing thin drivers. If you are installing any other
JDBC drivers (JDBC-OCI, etc., etc.) then you also need to make sure that
you have Oracle client installed correctly, etc., etc.

Hope this helps.

Val Gamerman.
To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Val Gamerman/Victoria Financial)
Date: 03/13/2001 10:06:52 PM GMT





does anyone can tell me where to install Oracle JDBC driver?  I looked up
oracle web site, but they just let me download the zip file and instruct
how
to set the classpath and i still get the error 'unsuitable ddriver"
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mai huynh
   INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

RE: Question about PL/SQL


Select
col1||'|'||
col2||'|'||
col3
From
table
Where
condition

set heading off
set pause off
set pages 1000
spool result.lst

Easiest way I know.
Then when you bring it into Excel, it's a delimited file with the | as a
delimiter.

Dan

-Original Message-
Sent: Wednesday, March 14, 2001 5:10 AM
To: Multiple recipients of list ORACLE-L


Hallo, all you experts

Does anyone have any good example of procedure,
that  does a select statement from the database and afterwards automatically
save this resultat to an excel file.?

Sincerely Roland Skldblom


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

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

RE: problem with UTL_FILE.FILE OPEN


I thought that a directory had to be specified by name in initora.  I don't
think you can specify a wildcard or a higher level directory.  I could be
wrong.

Dan

-Original Message-
Sent: Wednesday, March 14, 2001 5:16 AM
To: Multiple recipients of list ORACLE-L


List hi!
Oracle817 on AIX. (64 bit)
We have defined in initora file UTL_FILE_DIR=* 
When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH.
Everything is set and available (permissions are 777).
Do you have any idea what's wrong?

TIA,
Sonja




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

RE: Reports with Lexical Paramters


Using lexical parameter in Developer Reports.

Enter the query like this.
Select
  emp_name
From
  employee
Where
  emp_salary  100
  lx_param

Then the Report Builder will create a user parameter lx_param.  Next create
a before form trigger and set the code something like this.

IF :dept = 'SALES' THEN
  :lx_param := 'and emp_dept = 10';
ELSE
  :lx_param := 'and emp_dept = 20';
END IF;

Of course, :dept must be a user parameter entered via the parameter form
etc.

This is pretty much the simplest case.

If you are trying to use a lexical parameter as a column name, it must be
set with a default value that is correct.

Like this:
Select
  emp_name,
  col1 dept
From
  employee
Where
  blah blah blah;

Then in the properties for col1, you set a default value of emp_dept, then
in the trigger you can change the column based on some other condition just
like with the where.

This is about as advanced as I've been able to do and as you've no doubt
found out, there is pitifully little documentation on how to do a lot of
things in D2K.

Dan

-Original Message-
Sent: Wednesday, March 14, 2001 2:35 AM
To: Multiple recipients of list ORACLE-L




Hi Experts

Has anyone created a Report with lexial paramerters.
Can u please a small sample report.

Thanks
Richard


This email message may contain privileged/confidential information and/or
copyright material.  It is intended only for the use of the person(s) to
whom it
is addressed and any unauthorised use may be unlawful.  If you receive this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

The material contained in this message does not constitute a binding
contract
with any company within the MTL Instruments Group plc.  Opinions,
conclusions
and other information in this email that do not relate to the official
business
of this organisation shall be understood as neither given nor endorsed by
it.



-- 
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 e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

LONG: Re: Order of table_name resolution

2001-03-14 Thread Joseph Testa



An object name takes the following form:

[schema.]name[@database]


Some examples include:

Emp_tab
Scott.Emp_tab
Scott.Emp_tab@Personnel


A session is established when a user logs onto a database. Object names are 
resolved relative to the current user session. The
username of the current user is the default schema. The database to which 
the user has directly logged-on is the default database.

Oracle has separate namespaces for different classes of objects. All objects 
in the same namespace must have distinct names, but
two objects in different namespaces can have the same name. Tables, views, 
snapshots, sequences, synonyms, procedures,
functions, and packages are in a single namespace. Triggers, indexes, and 
clusters each have their own individual namespace. For
example, there can be a table, trigger, and index all named SCOTT.EMP_TAB.

Based on the context of an object name, Oracle searches the appropriate 
namespace when resolving the name to an object. For
example, in the following statement:

DROP CLUSTER Test


Oracle looks up TEST in the cluster namespace.

Rather than supplying an object name directly, you can also refer to an 
object using a synonym. A private synonym name has the
same syntax as an ordinary object name. A public synonym is implicitly in 
the PUBLIC schema, but users cannot explicitly
qualify a synonym with the schema PUBLIC.

Synonyms can only be used to reference objects in the same namespace as 
tables. Due to the possibility of synonyms, the
following rules are used to resolve a name in a context that requires an 
object in the table namespace:

  1.Look up the name in the table namespace.

  2.If the name resolves to an object that is not a synonym, then no further 
work is necessary.

  3.If the name resolves to a private synonym, then replace the name with 
the definition of the synonym and return to step 1.

  4.If the name was originally qualified with a schema, then return an 
error; otherwise, check if the name is a public synonym.

  5.If the name is not a public synonym, return an error; otherwise, then 
replace the name with the definition of the public
synonym and return to step 1.

When global object names are used in a distributed database (either 
explicitly or indirectly within a synonym), the local Oracle
session resolves the reference as is locally required (for example, 
resolving a synonym to a remote table's global object name).
After the partially resolved statement is shipped to the remote database, 
the remote Oracle session completes the resolution of
the object as above.



Joe


From: "Cale, Rick T (Richard)" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Order of table_name resolution
Date: Wed, 14 Mar 2001 05:00:21 -0800
MIME-Version: 1.0
Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net 
(8.9.3/8.8.7) with ESMTP id JAA11391for jtestamail@localhost; Wed, 14 Mar 
2001 09:10:40 -0500
Received: from mail.the-testas.netby localhost with POP3 
(fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Wed, 14 Mar 2001 
09:10:40 -0500 (EST)
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by 
mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2EF8Jw24812for 
[EMAIL PROTECTED]; Wed, 14 Mar 2001 09:08:19 -0600
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
(8.9.3/8.9.3) with UUCP id GAA80703;Wed, 14 Mar 2001 06:04:35 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002CC15E; 
Wed, 14 Mar 2001 05:00:21 -0800
Return-Path: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Cale, Rick T (Richard)" [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match 
any local name
X-SpamBouncer: 1.2 (10/20/00)
X-SBPass: NoBounce
X-SBClass: OK
Status:

Hi DBAs,

Can someone clarify/confirm on how Oracle determines what table to use in
select statement?

For ex. If I am login as Scott and do the following:

SELECT * FROM employee;

Of course Oracle will use Scott.employee if it exist. If it does not exist
but exist under another schema. Does
Oracle look at private synonyms then public synonyms or vice versa.

My guess is Oracle checks in this order. Please confirm or correct.

1. Check if table exist in current schema
2. Check private synonyms
3. Check public synonyms
4. 3 strikes your out with an error.

Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California

Off topic, humour, flagrant breach of the rules

2001-03-14 Thread Dave Morgan


This should make it through GE's filters but ..

I think they have it backwards though. Shouldn't it be
"something to protect the software from Matt" rather than 
"software to protect Matt from something"

My apologies Jared, but it's only one rule. I usually break 
them 4 or 5 at a time.

Announcing a new musical with music by The Travelling DBA's !!!

A one act musical on UNIX, NT/2000 clients are advised
to reboot after each song and apply all new Microsoft patches.

Curtain rises 

A DBA's spouse  wanders down to the basement where his or her partner
has been tele-commuting for the past little while and breaks into 
a song by George Thoroughgood.

Get a haircut and get a real job,
clean your act up and don't be a slob
Get it together like your LITTLE brother bob,
why don't you get a haircut and get a real job

Next we join our intrepid hero(ine) in SILICON VALLEY!!!

Working 5(am) to 9(pm), what a way to make a living
barely catching by, it's all taking and no giving 
they just use your mind, then they never give you credit 

Enter stage right, the NEW BOSS! Best portrayed by a young person
with no experience who has one of the following certificates, 
MSCE or OCP. (Cisco certified techies are ineligible for this role)

With apologies to AC/DC

Walk this way
Talk this way
DBA this way
Administer this way.

Cut to our hero(ine) who appears to have many more grey hairs 
(and wrinkles) laughing hysterically just before you hear the 
wonderful music of Johhny Paycheck!

Take this job and shove it 
I ain't working here no more 
My CLIENTS left and took all the reasons I was working for 
You better not try to stand in my way 
When I'm walking out the door 
Take this job and shove it 
I ain't working here no more 

Fade to a chorus of sysadmins, network admins, and data entry clerks
crooning to the tune of You've Lost That Lovin Feeling 

You've lost that Dee Bee Aaa
Whoa, that Dee Bee Aaa
You've lost that Dee Bee Aaa 
Now it's gone, gone, gone, woah 

Final shot 

Our hero, once again in the basement with the loving spouse
leaning over his/her shoulder whispering "I'm so glad you're 
back to stay"

Curtain falls .

 
Thanks to all who have helped me at this job. I will rely on
you at my next one :) (In Calgary, at one of Canada's largest ISP's)

Jared, I'll be good from now on, I promise.

After Friday I will be reachable at [EMAIL PROTECTED]

Dave
-- 
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-910-4183
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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


Remember, Oracle is very particular about which driver and which JDK.  If
you have those correct, then it usually installs in $ORACLE_HOME/jdbc in NT.
For Unix, I don't have any idea.

Dan

-Original Message-
Sent: Tuesday, March 13, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L



does anyone can tell me where to install Oracle JDBC driver?  I looked up 
oracle web site, but they just let me download the zip file and instruct how

to set the classpath and i still get the error 'unsuitable ddriver"
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

RE: 8.1.7



It seems like you should just be able to modify your CLASSPATH
and PATH to deal with this problem.

Jared

On Tue, 13 Mar 2001, Kevin Kostyszyn wrote:

 RE: 8.1.7Check this out, this is a known bug with Pentium 4 processors and
 Netware.  However, after tredging through Metaslink I found something that
 pointed me in the right direction.  Apperantly Oracle installer doesn't like
 it when you have different versions of Java on your machine.  I installed
 some Java runtime environment program for Pocket DBA and that is what was
 hosing the install.  Once I removed that program it worked.oh the joy!
 Kev

-- 
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: 8.1.7


Well yeah, I could have attempted to do that.  But what would I have done,
just remove the java_home, or remove any evidence in the path?  I found it
to be simpler to just uninstall the java then reinstall it when oracle was
completed.
kev

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L



It seems like you should just be able to modify your CLASSPATH
and PATH to deal with this problem.

Jared

On Tue, 13 Mar 2001, Kevin Kostyszyn wrote:

 RE: 8.1.7Check this out, this is a known bug with Pentium 4 processors and
 Netware.  However, after tredging through Metaslink I found something that
 pointed me in the right direction.  Apperantly Oracle installer doesn't
like
 it when you have different versions of Java on your machine.  I installed
 some Java runtime environment program for Pocket DBA and that is what was
 hosing the install.  Once I removed that program it worked.oh the joy!
 Kev

--
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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Kimberly Smith


heas03@ehdb:../oracle$ oerr ora 24371
24371, 0, "data would not fit in current prefetch buffer"
// *Cause:  An internal OCI error has occurred.
// *Action: Please contact Oracle customer support.

-Original Message-
Sent: Tuesday, March 13, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L


Hi Gang,
One of the developers came to me with this error. There is nothing in the
alert log or no trace files were generated. I'm at a complete loss. He was
executing a query from a front-end API.

This is running on 8.1.6, Solaris 8 on a Sun 450.

TIA,

-Rocky

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-03-14 Thread Jesse, Rich


Remember that if you use Oracle Migrate from 7.x to 8.x, instead of
export/import, you will get an icky performance hit the first time your data
is hit.  This is when the block-level changes will take place.  So, after
your migration is "complete", you will probably want to do FTSs on all
tables before opening the DB up to The Masses.  The changes will be taken
care of for you if you use export/import.

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


 -Original Message-
 From: Yexley Robert D SSgt AFIT/SCA [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 14, 2001 08:26
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle installation
 
 
 Yeah I can see that absolutely.  I just completed migrating a 
 test database
 that we are testing for migration from 7.3.4 to 8.1.6.  The reason I
 migrated it was because it had originally been on an 
 UltraSparc 1 that had
 192 MB of RAM and the thing would hardly run on that 
 hardware.  We ended up
 having to move it to another machine because of the lack of 
 resources on the
 original machine.  So yeah, I can see how doing this on a 
 machine with 128
 MB of RAM would take more than a day.
 


---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
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: EE on NT problem (on and off network) ???

2001-03-14 Thread Bala, Prakash


You might also need to comment out NAMES.DEFAULT_DOMAIN if any. This sets
the domain name.

HTH
Prakash

-Original Message-
Sent: Tuesday, March 13, 2001 11:20 PM
To: Multiple recipients of list ORACLE-L


better is to set it to none

sqlnet_authentication_services=(none)  in sqlnet.ora


From: "Joseph S. Testa" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: EE on NT problem (on and off network) ???
Date: Tue, 13 Mar 2001 16:35:50 -0800

Leslie, this one messed with ALOT of people for a long time, my boss
over New Years even figurd it out.

check out you sqlnet.ora file, look at the(i think it was)
sqlnet_authentication.services or something like that,  he just
commented it out and poof it worked.

Rachel, since I told you about it, do you remember what it was?


joe
Leslie Lu wrote:
 
  Hi all,
 
  I installed 815 EE on NT 4.0 on a laptop and created a
  testing database (did both while I was on network.)  I
  can connect to the database without problem, while
  remain on network.  However when I'm off the network,
  I cannot connect to the database. I got:
 
  ora 12570: TNS: packet reader failure
  ora 12571: TNS: packet writer failure
 
  It's a demo project for marketing people, and most
  probably they might not be able to connect to the
  network (in the plan or on the beach).  So I really
  need the db to run locally.
 
  Any idea,  thanks a lot.
 
  Leslie
 
  __
 

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
   INET: [EMAIL PROTECTED]

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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



My apologies for the RTFM.   I guess it
isn't documented, even though it has been
around for several years.

Jared

On Tue, 13 Mar 2001, Jack C. Applewhite wrote:

 Jared,

 Well, I've RTFM for 8.1.6 and the SQL Reference doesn't
 mention a Reverse() function.  However, there is a supplied
 PL/SQL Reverse() function in the Utl_Raw package.  Is there
 a connection?  If so, how?  If not, are my 8.1.6 docs just
 wrong?

 Thanks.

 Jack

 
 Jack C. Applewhite
 Database Administrator/Developer
 OCP Oracle8 DBA
 iNetProfit, Inc.
 Austin, Texas
 www.iNetProfit.com
 [EMAIL PROTECTED]


 -Original Message-
 [EMAIL PROTECTED]

 But this is so much easier:

  select reverse('reverse') from dual;

 A little RTFM goes a long way  :)

 Jared


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

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



There should be another error message with this.
What other messages do you see?

Jared

On Tue, 13 Mar 2001, Dash, Saroj  (CAP,CEF) wrote:

 Hello All,

 I got an Oracle error ORA-6512. I am unable to understand this problem.
 No PL/SQL error .
 Please help me.

 Saroj.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Dash, Saroj  (CAP,CEF)
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


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

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

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

2001-03-14 Thread Henry Poras


RM,
Thanks. Intuitively that seems like the way it should work. However it
appears to contradict what Steve wrote in his book about a sleeping process
waiting on its semaphore. I wonder if this is just a publishing error, or if
I am missing something in my understanding. I usually find it a good policy
to give Steve Adams the benefit of the doubt.
 
Henry

-Original Message-
Sent: Wednesday, March 14, 2001 9:06 AM
To: Multiple recipients of list ORACLE-L



HP, it is sleep/wake/check. it is up to the process to acquire the 
resource. AFAIK, there is no message-passing type of algorithm to 
tell waiting (whether spinning or sleeping) processes when the 
semaphore becomes unset ( ie the resource is available ) Sleeps 
are expensive in Latchville, and you can track their occurence 
via v$latch_waits and the SLEEP* columns. 

hope this partial answer helps. 

-Original Message- 
] 
Sent: Tuesday, March 13, 2001 10:25 PM 
To: Multiple recipients of list ORACLE-L 


I have been rereading Steve Adam's book a bit more carefully and have a 
question. Just wondering if anyone has any answers. 

When talking about latch sleeps, the book states "a process sleeping for a 
latch waits on its semaphore". However, latches don't support queuing and a 
number of processes may be waiting for the same latch. If I am sleeping and 
the latch frees, who knows I need that semaphore? Are all waiting processes 
posted with the semaphores going on/off/on/off? or is no semaphore posted 
and the processes go sleep/wake/check/sleep/wake/check? I can't quite 
picture the details here. 

Henry 



 
Think you know someone who can answer the above question? Forward it to
them! 
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
http://www.LAZYDBA.com/odbareadmail.pl  
Tell yer mates about http://www.farAwayJobs.com http://www.farAwayJobs.com

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

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

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

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

2001-03-14 Thread Kimberly Smith


The sad part is the Canadian government feels compelled
to follow the Americans are replacing some of their
apps that ran on Unix to Windows.  Actually, the app is 
an American one that they let us use.  A lot of critical
stuff is still on Unix.  Then again, ours ships really 
don't need reliable stuff as we don't do anything except
support:-)

-Original Message-
Sent: Tuesday, March 13, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


Holy mackerel!

I hope there isn't some rogue nation buying all our old VAX clusters to run
their navy. We'll get our behinds kicked!


- Jerry

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:06 AM


 On Tue, 13 Mar 2001, Boivin, Patrice J wrote:

  I thought I heard a story about a U.S. Navy ship that was towed to port
  because its systems ran on WindowsNT...
 
  Maybe it was an urban myth.
 
  I was glad to hear that the Boeing planes run on UNIX.
 
  ; )
 
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)

 No myth this.  ( yeth? ;)

 Here's a reference:

 http://www.gcn.com/archives/gcn/1998/july13/cov2.htm

 Jared


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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

Note on comp.databases.oracle.server

2001-03-14 Thread Henry Poras

Just saw this note posted this morning for all that are interested.

Subject: 
 Goodbye to all that
Date: 
 Mon, 5 Mar 2001 22:20:02 +1100
   From: 
 "Howard J. Rogers" [EMAIL PROTECTED]
 Organization: 
 CWO Customer - reports relating to abuse should be sent to
[EMAIL PROTECTED]
 Newsgroups: 
 comp.databases.oracle.server

Just thought I'd let anyone who's interested know

As of April 6th, I cease to work for Oracle and instead begin employment
with (gulp!) Informix.

I'm looking forward to it, actually.  Informix has competent products, even
if not in the Oracle league, and I shall enjoy getting to grips with it.

I dare say that few will be aware of my passing from the Oracle world, and
fewer will care.  But I shall miss this newsgroup, and its assorted
characters.  I've found it an invaluable resource for learning to deal with
real-world problems, and consequently it has undoubtedly enriched my
training courses.

Last time I checked Deja.com, before it was so rudely bought out, I'd
submitted around 3000 replies to posts, which if nothing else indicates a
pretty sad sort of existence!  Some have been kind enough to mail me their
appreciation for answers given.  One or two have seen fit to flood my in-box
with abuse.  I guess I may have asked for it from time to time!  Whatever:
I've learnt from all of you, and hopefully become a better trainer as a
result of my experiences here.

Having frequently given advice that those coming to Oracle from, say, SQL
Server should clear their minds of SQL Server preconceptions, it behoves me
to begin clearing my mind of Oracle preconceptions.  Accordingly, I give
myself a week to wind out of existing threads, and thereafter to refrain
from posting altogether.  My apologies to those who may want further
support.

With warm regards to you all,
HJR

Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Browett, Darren


Try http://www.oracle.com/oramag/oracle/00-Mar/statspack-other.html

It outlines the steps to install adn run statspack within 8.0.x.

I haven't run it myself as of yet, but it looks straight forward.

-Original Message-
Sent: March 14, 2001 6:31 AM
To: Multiple recipients of list ORACLE-L



Will statspack ever be available, in a supported version, for
Oracle 8.0.X? We'll be upgrading the machine I'm concerned about
to 8.1.X eventually (next six months or so); But for now, I'd like to
have access to a more sophisticated tuning-data gathering tool than
bstat/estat.

I find it appalling that bstat/estat can't collect, compare, and
contrast multiple sets of tuning data over time; that it can't
calculate db buffer cache hit ratios, etc.

We've purchased Spotlight on Oracle from Quest; But come to find out
(someone else did the research and made the purchase recommendation
before I became involved), Spotlight is merely a real-time monitor and
can't save tuning data. I thought about writing something to retrieve
data from the Spotlight tables, or modifying bstat/estat to make it do
what I want, but statspack seems to do everything I want - and who
wants to reinvent the wheel?

Any good tuning data gathering freeware out there (with statspack-like
functionality) for use with 8.0.X databases? 

Thanks very much.

 - Dana



__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-03-14 Thread Bala, Prakash


Check user_tables.avg_row_len

-Original Message-
Sent: Tuesday, February 13, 2001 6:35 AM
To: Multiple recipients of list ORACLE-L


but i did'nt find any bytes column in user_tables
analyzed table in compute mode..

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 09, 2001 9:05 PM


 analyze the table in compute mode.

 Then select bytes from user_tables where table_name = 'MY_TABLE';


 -Original Message-
 Sent: 09 February 2001 14:56
 To: Multiple recipients of list ORACLE-L


 Dear friends
 I have a little problem

 I have a table 
 here the description ...

 create table my_table
 ( id number primary key.
namevarchar2(20),
address varchar2(50),
notesvarchar2(4000)
 );

 and then ... I inserted one record, and I wanna know ...
 How to count a resource allocation from one record ? byte ? kb ?

 I hope one of you can give me a solution to count resource allocation from
 one record.

 Thanks

 regards
 abimanyu

 "I'll be back!"
 Arnold Schwarzenegger

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


 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: lerobe - Lee Robertson
   INET: [EMAIL PROTECTED]

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

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

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

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

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

2001-03-14 Thread Shankar Shanmugaswamy


Hi,

Eventhough you have given the path as * in initora
Make sure that the path where you are creating the file 
is access to the Unix User , who is  running the script
The unix user should have the access Read , Write and Execute
But the User thur which Oracle is Installed will be able to run the same
without any problem , try that 

Get back if you need more info..

S.S

 [EMAIL PROTECTED] 03/14/01 05:15AM 
List hi!
Oracle817 on AIX. (64 bit)
We have defined in initora file UTL_FILE_DIR=* 
When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH.
Everything is set and available (permissions are 777).
Do you have any idea what's wrong?

TIA,
Sonja




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

2001-03-14 Thread Gogala, Mladen


You're supposed to set the parameter to a directoryname, 
not an asterisk. Setting the parameter to something like 
/oracle/base/8.1.7/work
and setting the protection of the directory to 0644 (files are 
written by the oracle server processes) should help.

-Original Message-
Sent: Wednesday, March 14, 2001 5:16 AM
To: Multiple recipients of list ORACLE-L


List hi!
Oracle817 on AIX. (64 bit)
We have defined in initora file UTL_FILE_DIR=* 
When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH.
Everything is set and available (permissions are 777).
Do you have any idea what's wrong?

TIA,
Sonja




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Gorden-Ozgul, Patricia E


In answer to my own question, I did the following:

ALTER TABLESPACE  COALESCE;
ALTER TABLESPACE  ADD '' 100M;

...worked like a charm.

__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159





 -Original Message-
 From: Gorden-Ozgul, Patricia E 
 Sent: Wednesday, March 14, 2001 12:38 PM
 To:   'Oracle-L'
 Subject:  3/14/01 - ORA-01653:  unable to extend table ... by 2572 in
 tablespace ...
 
 I've been inserting tens of thousands of records into a database.
 I've hit the above error message and am looking to you folks for advice
 about what I should do.
 
 Is this where I need to add another data file to the tablespace or what?
 ...and how?
 
 Thanks in advance.
 Pat
 
 __
 Pat Gorden-Ozgul   BNL-ISD Systems
 [EMAIL PROTECTED] 631-344-5159
 
 
 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorden-Ozgul, Patricia E
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Streeter, Lerone A LBX


thanks.

crash course, must have, aggressive deadline situation.  nothing unusual for
me, similar pains rolling out and learning NT, Exchange, MS-SQL, RPG, VB,
etc... (see a pattern?)

i've toyed w/ the downloaded oracle 8.1.7 personal just to get some
inceptionary idea of what it takes and how it works, i'll do something a
little more formal when i've got a better grasp and more memory...  of
course i've ran into problems but i'm positive i can resolve them and i'll
use the information you've supplied to learn and fill in the gaps.

maybe my next post will be relatively intelligent.



thanks again for all the info:

http://oradoc.photo.net 

DBA 101

Please keep in mind the two official reference points from Oracle:
http://metalink.oracle.com = for offical FAQ of what to do in various
situations, bug reports, how to install, etc.
http://technet.oracle.com = Repository for all documentation and software of
Oracle.  Mostly free to download.
http://www.ioug.org = International Oracle Users Group.
http://www.orafaq.com.
http://www.lazydba.com and http://www.revealnet.com
TOAD (http://www.toadsoft.com) or Quest software.

Note that the lords of Oracle tutelage are Kevin Loney and Stephen
Feurstein, so their books are among the

===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED]
===

-Original Message-
Sent: Tuesday, March 13, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L


hello,
we're in the process of upgrading an application, right now it's a 16-bit
client application with the backend running on MS-SQL 6.0, windows NT 4
server.  the company we're working with is willing to upgrade to 32-bit code
oracle 8x, still running on NT; probably 2000.

i'm looking for some starter information since i'll probably be the DBA.

i've downloaded oracle 8i personal and a couple of PDFs, i'm wondering if
you can point me to some starter information?  is there a "first read" or
something similar?

===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED]
===
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Streeter, Lerone  A LBX
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-03-14 Thread Rachel Carmichael

that's the right order

From: "Kevin Kostyszyn" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Order of table_name resolution
Date: Wed, 14 Mar 2001 06:05:56 -0800

I am not positive, but I think that is the correct order.  This had been
discussed before and ofcourse, with my limited brain capacity I can't
remember.
Kev

-Original Message-
T (Richard)
Sent: Wednesday, March 14, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L

Hi DBAs,

Can someone clarify/confirm on how Oracle determines what table to use in
select statement?

For ex. If I am login as Scott and do the following:

SELECT * FROM employee;

Of course Oracle will use Scott.employee if it exist. If it does not exist
but exist under another schema. Does
Oracle look at private synonyms then public synonyms or vice versa.

My guess is Oracle checks in this order. Please confirm or correct.

1. Check if table exist in current schema
2. Check private synonyms
3. Check public synonyms
4. 3 strikes your out with an error.

Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
   INET: [EMAIL PROTECTED]

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

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: LONG: Re: Order of table_name resolution

2001-03-14 Thread Jacques Kilchoer

Title: RE: LONG: Re: Order of table_name resolution





 -Original Message-
 From: Joseph Testa [mailto:[EMAIL PROTECTED]]
 Due to the possibility of synonyms, the
 following rules are used to resolve a name in a context that 
 requires an 
 object in the table namespace:


etc...


That was an excellent post Mr. Testa. My chapeau goes off to you.
Also it seems that Oracle keeps track of the names it goes through when doing synonym resolution, as the example below shows:

SQL create synonym x for y ;


Synonym created.


SQL create synonym y for x ;


Synonym created.


SQL select * from x ;
select * from x
 *
ERROR at line 1:
ORA-01775: looping chain of synonyms


--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.


Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: Advanced Korn Question


On Tue, 13 Mar 2001, hp wrote:

 can you tell mne what the difference is between:
   $log 21  
 and
 21  $log 

 if tried both ways and the std err and std out go to the log both ways.


Probably not, unless you have some strange variant of ksh.

When you redirect STDOUT with " $log", STDOUT is no longer
pointing to file descriptor 1, it is pointing to some
new file descriptor.

Here's what happens when you redirect STDERR first:

  date -%sdfd 21 |date.txt

STDERR is redirected to STDOUT, which is file descriptor
number 1.  STDOUT is then redirected to some new file
descriptor.  STDERR from this command will not appear
in the file "date.txt", but rather will appear on the
screen, which is still file descriptor 1. Try it.

Now change it to this:

  date -%sdfd  |date.txt 21


Now STDOUT is redirected first, and it is sent to some
new file descriptor.  When STDERR is next redirected,
it will point at the new file descriptor for STDOUT, and
the error output will appear in the file.


Jared



-- 
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: STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread Ruth Gramolini


They are available, at a price, for OEM 1.6x.  However, you can monitor an
8.0.x database with OEM2.x by using  a small database in 8.1.7 for the OEM
repository.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 9:31 AM



 Will statspack ever be available, in a supported version, for
 Oracle 8.0.X? We'll be upgrading the machine I'm concerned about
 to 8.1.X eventually (next six months or so); But for now, I'd like to
 have access to a more sophisticated tuning-data gathering tool than
 bstat/estat.

 I find it appalling that bstat/estat can't collect, compare, and
 contrast multiple sets of tuning data over time; that it can't
 calculate db buffer cache hit ratios, etc.

 We've purchased Spotlight on Oracle from Quest; But come to find out
 (someone else did the research and made the purchase recommendation
 before I became involved), Spotlight is merely a real-time monitor and
 can't save tuning data. I thought about writing something to retrieve
 data from the Spotlight tables, or modifying bstat/estat to make it do
 what I want, but statspack seems to do everything I want - and who
 wants to reinvent the wheel?

 Any good tuning data gathering freeware out there (with statspack-like
 functionality) for use with 8.0.X databases?

 Thanks very much.

  - Dana



 __
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great prices.
 http://auctions.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: dana
   INET: [EMAIL PROTECTED]

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



Take a look at the JDBC manual, it's on the doc CD.

Just adding d:\jdbc\lib to your classpath isn't good enough.

The needed classes are not in a jar file, they are in a zip file.
Include d:\jdbc\lib\classes12.zip in your CLASSPATH.

Jared

On Tue, 13 Mar 2001, mai huynh wrote:

 when I unzip the zip file, it has 3 files: classes111.zip and 2 other files.
   I put it in the d:\jdbc\lib and set classpath=d:\jdbc\lib and the
 path=d:\jdbc\lib; Is that all I have to do?  I thought that I need to run
 something to set it up.  Thanks


 From: [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: Oracle JDBC driver
 Date: Tue, 13 Mar 2001 15:15:20 -0800
 
 
 
 
 Mai,
 
 The only thing you have to do is to set your classpath correctly. That of
 course if you are installing thin drivers. If you are installing any other
 JDBC drivers (JDBC-OCI, etc., etc.) then you also need to make sure that
 you have Oracle client installed correctly, etc., etc.
 
 Hope this helps.
 
 Val Gamerman.
 To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:(bcc: Val Gamerman/Victoria Financial)
 Date: 03/13/2001 10:06:52 PM GMT
 
 
 
 
 
 does anyone can tell me where to install Oracle JDBC driver?  I looked up
 oracle web site, but they just let me download the zip file and instruct
 how
 to set the classpath and i still get the error 'unsuitable ddriver"
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: mai huynh
INET: [EMAIL PROTECTED]
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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).

 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

2001-03-14 Thread Gogala, Mladen


Of course, with 8.1.7 you can implement your own UTL_FILE package,
using external calls to C routines.

-Original Message-
Sent: Wednesday, March 14, 2001 5:16 AM
To: Multiple recipients of list ORACLE-L


List hi!
Oracle817 on AIX. (64 bit)
We have defined in initora file UTL_FILE_DIR=* 
When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH.
Everything is set and available (permissions are 777).
Do you have any idea what's wrong?

TIA,
Sonja




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Anderson, Brian


I believe * is valid (though I can't find the page in a book right now),
though it could be dangerous, utl_file writes as oracle, make sure some
duhveloper doesn't overwrite/append to your datafiles.

Look at the UTL_FILE.FOPEN commands and verify the paths.

  lv_log_file:= UTL_FILE.FOPEN('/dir1/dir2/dir3','logfile.dat','A');



 Brian L. Anderson
 Flunky/SA/DBA
 Darton College
 [EMAIL PROTECTED]




 -Original Message-
 From: Dasko, Dan [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 14, 2001 10:07 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: problem with UTL_FILE.FILE OPEN
 
 
 I thought that a directory had to be specified by name in 
 initora.  I don't
 think you can specify a wildcard or a higher level directory. 
  I could be
 wrong.
 
 Dan
 
 -Original Message-
 Sent: Wednesday, March 14, 2001 5:16 AM
 To: Multiple recipients of list ORACLE-L
 
 
 List hi!
 Oracle817 on AIX. (64 bit)
 We have defined in initora file UTL_FILE_DIR=* 
 When we start function UTL_FILE.FOPEN it raises exception 
 INVALID_PATH.
 Everything is set and available (permissions are 777).
 Do you have any idea what's wrong?
 
 TIA,
   Sonja
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 _
 This e-mail message has been scanned for the presence of all 
 known computer
 viruses by the MessageLabs Virus Control Center.  However, it is still
 recommended that you use local virus scanning software to 
 monitor for the
 presence of viruses.  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Dasko, Dan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

How do I migrate 7.3.4 database that supports Des/2000?

2001-03-14 Thread Cherie_Machler



I am migrating a 7.3.4 database to 8.1.5 on Sun Solaris 2.6.
This database holds the repository for Des/2000.

We do not want to upgrade Des/2000.   I basically just want
to migrate the underlying database.   Can I do this?

I've read through all of the documentation for Des/2000 but
it all pertains to migrating the underlying database as
part of an overall migration of Des/2000 (which I don't want to do).

I've looked on Metalink and on Technet and can't find any
information on how to migrate the underlying database without
migrating the Des/2000 tool.

Can it be done?   Has anyone on the list done it?  What steps
need to be taken above and beyond those of a regular database
migration?

If anyone can direct me to some enlightening documentation,
I'd appreciate it.

Thanks,

Cherie Machler
Gelco Information Network

-- 
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: Order of table_name resolution



Here's more than you wanted to know about name resolution:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/d_names.htm#3693

Jared

On Wed, 14 Mar 2001, Cale, Rick T (Richard) wrote:

 Hi DBAs,

 Can someone clarify/confirm on how Oracle determines what table to use in
 select statement?

 For ex. If I am login as Scott and do the following:

 SELECT * FROM employee;

 Of course Oracle will use Scott.employee if it exist. If it does not exist
 but exist under another schema. Does
 Oracle look at private synonyms then public synonyms or vice versa.

 My guess is Oracle checks in this order. Please confirm or correct.

 1. Check if table exist in current schema
 2. Check private synonyms
 3. Check public synonyms
 4. 3 strikes your out with an error.

 Rick Cale, Science Applications International Corp.
 Phone:865-481-2198, fax:865-481-8555
 e-mail: [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).

failover problem

2001-03-14 Thread Vulpe Cristian


Hi!

I am working on an application that has many concurrent users and I
would like to configure a background failover server. I am asking you if
I can do that and where should I read some documentation about this...

Best regards,
Vulpe Cristian

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

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

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

Informix training question

2001-03-14 Thread Gene Sais


In addition to unix admin  oracle dba duties, I am now tasked with an informix db.  
Not that I mind, with oracle's pricing, it may become the db of choice :).  Any 
recommendations on which informix dba course to take to get up to speed for a seasoned 
sys admin/oracle dba? 

--
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: Off topic, humour, flagrant breach of the rules

2001-03-14 Thread Steve Orr


Hey Dave,

GREAT STUFF!!

It was nice having you in the Silicon Valley neighborhood. Please don't
forget that classic, "Do You Know the Way to San Jose?" :) Just had some
"stout" medicine (oatmeal stout that is) at the Rock Bottom Cafe this
weekend so when you're ever back in the neighborhood just let me know... The
next stout's on me.

So how many miles did you put on your bike anyway? Might be kind of hard to
bicycle commute in Calgary this time of year. :)

Keep in touch!
Steve Orr


-Original Message-
Sent: Wednesday, March 14, 2001 7:46 AM
To: Multiple recipients of list ORACLE-L


This should make it through GE's filters but ..

I think they have it backwards though. Shouldn't it be
"something to protect the software from Matt" rather than
"software to protect Matt from something"

My apologies Jared, but it's only one rule. I usually break
them 4 or 5 at a time.

Announcing a new musical with music by The Travelling DBA's !!!

A one act musical on UNIX, NT/2000 clients are advised
to reboot after each song and apply all new Microsoft patches.

Curtain rises 

A DBA's spouse  wanders down to the basement where his or her partner
has been tele-commuting for the past little while and breaks into
a song by George Thoroughgood.

Get a haircut and get a real job,
clean your act up and don't be a slob
Get it together like your LITTLE brother bob,
why don't you get a haircut and get a real job

Next we join our intrepid hero(ine) in SILICON VALLEY!!!

Working 5(am) to 9(pm), what a way to make a living
barely catching by, it's all taking and no giving
they just use your mind, then they never give you credit

Enter stage right, the NEW BOSS! Best portrayed by a young person
with no experience who has one of the following certificates,
MSCE or OCP. (Cisco certified techies are ineligible for this role)

With apologies to AC/DC

Walk this way
Talk this way
DBA this way
Administer this way.

Cut to our hero(ine) who appears to have many more grey hairs
(and wrinkles) laughing hysterically just before you hear the
wonderful music of Johhny Paycheck!

Take this job and shove it
I ain't working here no more
My CLIENTS left and took all the reasons I was working for
You better not try to stand in my way
When I'm walking out the door
Take this job and shove it
I ain't working here no more

Fade to a chorus of sysadmins, network admins, and data entry clerks
crooning to the tune of You've Lost That Lovin Feeling

You've lost that Dee Bee Aaa
Whoa, that Dee Bee Aaa
You've lost that Dee Bee Aaa
Now it's gone, gone, gone, woah

Final shot

Our hero, once again in the basement with the loving spouse
leaning over his/her shoulder whispering "I'm so glad you're
back to stay"

Curtain falls .


Thanks to all who have helped me at this job. I will rely on
you at my next one :) (In Calgary, at one of Canada's largest ISP's)

Jared, I'll be good from now on, I promise.

After Friday I will be reachable at [EMAIL PROTECTED]

Dave
--
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-910-4183
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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

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

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

Title: RE: Off topic, humour, flagrant breach of the rules





LoLDave, it was AEROSMITH who did Walk This Way !!


-Original Message-
From: Dave Morgan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
Subject: Off topic, humour, flagrant breach of the rules



This should make it through GE's filters but ..


I think they have it backwards though. Shouldn't it be
something to protect the software from Matt rather than 
software to protect Matt from something


My apologies Jared, but it's only one rule. I usually break 
them 4 or 5 at a time.


Announcing a new musical with music by The Travelling DBA's !!!


A one act musical on UNIX, NT/2000 clients are advised
to reboot after each song and apply all new Microsoft patches.


Curtain rises 


A DBA's spouse wanders down to the basement where his or her partner
has been tele-commuting for the past little while and breaks into 
a song by George Thoroughgood.


 Get a haircut and get a real job,
 clean your act up and don't be a slob
 Get it together like your LITTLE brother bob,
 why don't you get a haircut and get a real job


Next we join our intrepid hero(ine) in SILICON VALLEY!!!


 Working 5(am) to 9(pm), what a way to make a living
 barely catching by, it's all taking and no giving 
 they just use your mind, then they never give you credit 


Enter stage right, the NEW BOSS! Best portrayed by a young person
with no experience who has one of the following certificates, 
MSCE or OCP. (Cisco certified techies are ineligible for this role)


 With apologies to AC/DC


 Walk this way
 Talk this way
 DBA this way
 Administer this way.


Cut to our hero(ine) who appears to have many more grey hairs 
(and wrinkles) laughing hysterically just before you hear the 
wonderful music of Johhny Paycheck!


 Take this job and shove it 
 I ain't working here no more 
 My CLIENTS left and took all the reasons I was working for 
 You better not try to stand in my way 
 When I'm walking out the door 
 Take this job and shove it 
 I ain't working here no more 
 
Fade to a chorus of sysadmins, network admins, and data entry clerks
crooning to the tune of You've Lost That Lovin Feeling 


 You've lost that Dee Bee Aaa
 Whoa, that Dee Bee Aaa
 You've lost that Dee Bee Aaa 
 Now it's gone, gone, gone, woah 


Final shot 


Our hero, once again in the basement with the loving spouse
leaning over his/her shoulder whispering I'm so glad you're 
back to stay


Curtain falls .



Thanks to all who have helped me at this job. I will rely on
you at my next one :) (In Calgary, at one of Canada's largest ISP's)


Jared, I'll be good from now on, I promise.


After Friday I will be reachable at [EMAIL PROTECTED]


Dave
-- 
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-910-4183
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
 INET: [EMAIL PROTECTED]


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

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

3/14/01 - ORA-01653: unable to extend table ... by 2572 in table

2001-03-14 Thread Gorden-Ozgul, Patricia E


I've been inserting tens of thousands of records into a database.
I've hit the above error message and am looking to you folks for advice
about what I should do.

Is this where I need to add another data file to the tablespace or what?
...and how?

Thanks in advance.
Pat

__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159





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

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

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

2001-03-14 Thread John Hindmarsh


Any thoughts?

This is version 2.2.

Development license per download from ORacle.

-Original Message-
Hindmarsh
Sent: Tuesday, March 13, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L


I downloaded EM.  Trying to install in Windows 2000 environment.  THe first
screen starts up ok, but when I select the install option, it all just fades
away and nothing happens.  No obvious error, no messages logged that I can
see, etc.

Any suggestions?

Cheers,

John

-

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

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

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

2001-03-14 Thread Miller, Jay


Hi Kirti,

Huh.

This function isn't even mentioned in Koch's Oracle8 The "Complete"
Reference (I just double checked because I couldn't believe I'd miss
something like that.

Thanks!

Jay

-Original Message-
Sent: Monday, March 12, 2001 6:40 PM
To: Multiple recipients of list ORACLE-L


Hi.

How about using a simple 'reverse' function available with SQL ??

Here is an example from 7.3.4.3 :

Connected to:
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed and parallel query options
PL/SQL Release 2.3.4.3.0 - Production

SQL select reverse('oracle') from dual;

REVERS
--
elcaro

And with 8.1.7 :

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL select reverse('ORACLE') from dual;

REVERS
--
ELCARO

SQL 

We played with this, probably undocumented feature in 7.3.4, to index
columns( since reverse key indexes were not available, so this was the
trick).

HTH..
- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Mandar Ghosalkar [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, March 12, 2001 4:11 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Script for reversing a string?
 
 U did the right thing Jay. Oracle does provides u the answer.
 thats why its called Oracle (answer to everything), except when it comes
 to
 licensing
 
 
 select
 utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK')))
 from
 dual
 /
 
 -Mandar
 
  -Original Message-
  From: Miller, Jay [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 12, 2001 3:17 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Script for reversing a string?
  
  
  Before I reinvent the wheel, I was wondering if anyone has written a
  function that will reverse a string?
  Our auditors are requiring that Oracle passwords not contain 
  the reverse of
  the user name and I was about to start writing this function 
  when I decided
  to check here first.
  
  Thanks!
  
  Jay Miller
  
  
  
  -Original Message-
  Sent: Friday, March 09, 2001 3:26 PM
  To: Multiple recipients of list ORACLE-L
  
  
  It hasn't caused me any problems - have only tried it on this 
  test server so
  far, and on my workstation.  
  
  The workstation has Oracle 7.3. and 8.0.4 on it they have 
  been running for
  over a year.
  
  I wouldn't try this on a production system!  These are test 
  databases only.
  
  I am just curious why the files are so fragmented.
  
  Regards,
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
  
  Systems Admin  Operations | Admin. et Exploit. des systmes
  Technology Services| Services technologiques
  Informatics Branch | Direction de l'informatique 
  Maritimes Region, DFO  | Rgion des Maritimes, MPO
  
  E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
  
  
  -Original Message-
  From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
  Sent:   Friday, March 09, 2001 3:36 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Does NT write to random locations on disk?
  
  I wouldn't think you would want to reorg an Oracle 
  tablespace with
  an NT
  defrag utility.  You would corrupt the data.
  Ron Smith
  Database Administration
  [EMAIL PROTECTED]
   
  
  -Original Message-
  Sent: Friday, March 09, 2001 1:01 PM
  To: Multiple recipients of list ORACLE-L
  
  
  Using a little utility called contig I noticed that the 
  Oracle 8.1.6
  datafiles on my test NT server are quite fragmented, an 
  average of
  177
  fragments per file, 118 fragments for the OEM 
  repository datafile.
  The poor
  utility couldn't do anything with the database files, 
  they are too
  large
  perhaps.
  
  These were created on an empty server, 8i release 2 
  went on it after
  a
  defrag, then the OEM.  This is on a hard disk with 1.2G of free
  space, none
  of the datafiles come close to that.
  
  Why so many fragments?  Oracle created those files in 
  one pass, does
  NT
  write randomly to disk or what?
  
  Won't this have an impact on my NT database's performance?
  
  Oracle says tablespace fragmentation is not a big deal, but
  fragmentation at
  the OS level matters.   Supposedly that's why NT and 
  WndowsXX came
  with
  defragmentation tools.
  
  ???
  
  Is there a registry setting somewhere to tell NT to write
  contiguously to
  disk?
  
  TIA
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
  
  Systems Admin  Operations | Admin. et Exploit. des systmes
  Technology Services| Services technologiques
  Informatics Branch | Direction de l'informatique 
  Maritimes Region, DFO  | Rgion des Maritimes, MPO
  
  E-Mail: [EMAIL PROTECTED] 
  mailto:[EMAIL PROTECTED]

A question about upgrading Oracle Applications

2001-03-14 Thread William Beilstein


I am asking in this format because I want the opinion of the DBA who did the work.

We are currently using Oracle Applications 10.7SC (Smart Client) with the project 
module and are looking to go to Oracle Applications 11i. I am looking for any opinions 
on the ease or headaches of performing an upgrade as opposed to a fresh install. What 
was your opinion on the Oracle Migration tools. Is there anyone who jumped directly 
from 10.7SC to 11i? Any information would be appreciated.

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

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

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

SQL*Loader - error writing to bad file

2001-03-14 Thread Michelle Buyer


Hi,

I am using Oracle 8.0.4 on Solaris 2.6.

Trying to load data from a text file to a table using
SQL*Loader.

Receiving the following error during the load:

SQL*Loader-523: error-2 writing to file
(/mnt/voyager/ccuser/ccuser.bad)

The load.shl file contains bad file parameter:
BAD=$DIR/$FILENAME.bad \

Tried changing permissions on .bad file from:
-rwx-- to -rw-r--r--.  Still receive error.

We are using fixed position records.  The errant
record is too short.  I have also tried adding
TRAILING NULLCOLS to the control file, but the error
still occurs.

Any ideas?

Thanks,
Michelle


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michelle Buyer
  INET: [EMAIL PROTECTED]

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

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

2001-03-14 Thread Carle, William T (Bill), NLCIO


Gene,

You would want to take their Online Dynamic Server Administration course
or whatever they are calling it now. I do both Informix and Oracle so if you
have any questions, let me know.


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Wednesday, March 14, 2001 1:22 PM
To: Multiple recipients of list ORACLE-L
Subject:Informix training question

In addition to unix admin  oracle dba duties, I am now tasked with an
informix db.  Not that I mind, with oracle's pricing, it may become the db
of choice :).  Any recommendations on which informix dba course to take to
get up to speed for a seasoned sys admin/oracle dba? 

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

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

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

Connecting from VAX/VMS to Remote Oracle Data Base

2001-03-14 Thread Tim Sawmiller


My client is trying to connect from an RDB database on a VAX/VMS machine to an Oracle 
database on an HP machine.  Can this be done?  How?

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

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

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

Gupta/centura SQLBASE

2001-03-14 Thread Malkuns, Skip


We have to convert data from an old sqlbase database into Oracle.
Does anyone know if SQLBASE has views or system tables like Oracle does for
getting a listing of 
table names, columns and column types/lengths like dba_tables, dba_views,
all_tables that
Oracle has? I've had no luck searching the web to get this information.
Any ideas?? Anyone worked with SQLBASE??
Thanks
Skip


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

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

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

2001-03-14 Thread Guidry, Chris


Hello,
Yes you can use an asterisk which means any directory path
is available for using UTL_FILE (at least in 7.3). Oracle recommends
you do not do this due to security concerns. You must refer to
the server directory structure not to mapped drives and you must
have the proper permission to create files in the target.

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

 -Original Message-
 From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, March 14, 2001 11:05 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: problem with UTL_FILE.FILE OPEN
 
 You're supposed to set the parameter to a directoryname, 
 not an asterisk. Setting the parameter to something like 
 /oracle/base/8.1.7/work
 and setting the protection of the directory to 0644 (files are 
 written by the oracle server processes) should help.
 
 -Original Message-
 Sent: Wednesday, March 14, 2001 5:16 AM
 To: Multiple recipients of list ORACLE-L
 
 
 List hi!
 Oracle817 on AIX. (64 bit)
 We have defined in initora file UTL_FILE_DIR=* 
 When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH.
 Everything is set and available (permissions are 777).
 Do you have any idea what's wrong?
 
 TIA,
   Sonja
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gogala, Mladen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle JDBC driver

2001-03-14 Thread mai huynh


Here is the code:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =
  DriverManager.getConnection ("jdbc:oracle:oci8:@myserver", "admin", 
"admin");

This failed when call DriverManager.registerDriver(new 
oracle.jdbc.driver.OracleDriver());

Now after set the classpath=d:\jdbc\lib\classes111.zip.  It gives me the 
error ORA805.dll not found in the specified path
From: "Marin Dimitrov" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle JDBC driver
Date: Wed, 14 Mar 2001 01:20:23 -0800

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 00:06


 
  does anyone can tell me where to install Oracle JDBC driver?  I looked 
up
  oracle web site, but they just let me download the zip file and instruct
how
  to set the classpath and i still get the error 'unsuitable ddriver"


How do u initialize the driver in your application? How do the class name
and the url look like?


 Marin


"When someone is seeking, it happens quite easily that he only sees
the thing that he is seeking; that he is unable to find anything, unable to
absorb anything, because he is only thinking of the thing he is seeking,
because he is obsessed with his goal. Seeking means: to have a goal;
but finding means: to be free, to be receptive, to have no goal. ..."


 Herman Hesse, "Siddhartha"


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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

2001-03-14 Thread Kimberly Smith


We don't want to be powerful though.  Actually, I am
half kidding there.  I do believe that Canada can stand
on its own if need be.  I believe they proved it in the last
war we participated in.  Its that we normally choose not
to join in war.  We do support the USA when ever asked 
(as it is always a NATO thing) and we do command the NATO
Atlantic Navy force out of Halifax, NS.  

As a Canadian I spend a lot of time picking on my country.
We all pretty much do so (even those who deny it) but at the
same time I will defend it to anyone who critizes it.  If it
weren't for the mountains here in Oregon I would still be
there and fully plan on returning.  

-Original Message-
Sent: Wednesday, March 14, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


I agree with Kimberly, I don't why Canada simply following US?? I think 
Canada has every capacity to emerge as powerful nation. Simply following 
with out any backbone creates lot of problems in economy and society too.


From: Kimberly Smith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: oracle and America
Date: Wed, 14 Mar 2001 08:16:25 -0800

The sad part is the Canadian government feels compelled
to follow the Americans are replacing some of their
apps that ran on Unix to Windows.  Actually, the app is
an American one that they let us use.  A lot of critical
stuff is still on Unix.  Then again, ours ships really
don't need reliable stuff as we don't do anything except
support:-)

-Original Message-
Sent: Tuesday, March 13, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


Holy mackerel!

I hope there isn't some rogue nation buying all our old VAX clusters to run
their navy. We'll get our behinds kicked!


- Jerry

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:06 AM


  On Tue, 13 Mar 2001, Boivin, Patrice J wrote:
 
   I thought I heard a story about a U.S. Navy ship that was towed to 
port
   because its systems ran on WindowsNT...
  
   Maybe it was an urban myth.
  
   I was glad to hear that the Boeing planes run on UNIX.
  
   ; )
  
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
 
  No myth this.  ( yeth? ;)
 
  Here's a reference:
 
  http://www.gcn.com/archives/gcn/1998/july13/cov2.htm
 
  Jared
 
 
  --
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

To REMOVE yourself from this mailing list,

Re: Oracle JDBC driver



You will need to set your PATH to include the location
of the required DLL's.

Jared

On Wed, 14 Mar 2001, mai huynh wrote:

 I set the classpath point to the zip file.  Now, in java file, when run the
 following line, I get the error: the dynamic link library ORA805.dll could
 not be found in the specified path.
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

 From: [EMAIL PROTECTED]
 To: mai huynh [EMAIL PROTECTED]
 CC: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: Oracle JDBC driver
 Date: Wed, 14 Mar 2001 08:36:33 -0800 (PST)
 
 
 Take a look at the JDBC manual, it's on the doc CD.
 
 Just adding d:\jdbc\lib to your classpath isn't good enough.
 
 The needed classes are not in a jar file, they are in a zip file.
 Include d:\jdbc\lib\classes12.zip in your CLASSPATH.
 
 Jared
 
 On Tue, 13 Mar 2001, mai huynh wrote:
 
   when I unzip the zip file, it has 3 files: classes111.zip and 2 other
 files.
 I put it in the d:\jdbc\lib and set classpath=d:\jdbc\lib and the
   path=d:\jdbc\lib; Is that all I have to do?  I thought that I need to
 run
   something to set it up.  Thanks
  
  
   From: [EMAIL PROTECTED]
   Reply-To: [EMAIL PROTECTED]
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Subject: Re: Oracle JDBC driver
   Date: Tue, 13 Mar 2001 15:15:20 -0800
   
   
   
   
   Mai,
   
   The only thing you have to do is to set your classpath correctly. That
 of
   course if you are installing thin drivers. If you are installing any
 other
   JDBC drivers (JDBC-OCI, etc., etc.) then you also need to make sure
 that
   you have Oracle client installed correctly, etc., etc.
   
   Hope this helps.
   
   Val Gamerman.
   To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   cc:(bcc: Val Gamerman/Victoria Financial)
   Date: 03/13/2001 10:06:52 PM GMT
   
   
   
   
   
   does anyone can tell me where to install Oracle JDBC driver?  I looked
 up
   oracle web site, but they just let me download the zip file and
 instruct
   how
   to set the classpath and i still get the error 'unsuitable ddriver"
   _
   Get your FREE download of MSN Explorer at http://explorer.msn.com
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: mai huynh
  INET: [EMAIL PROTECTED]
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (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).
  
   _
   Get your FREE download of MSN Explorer at http://explorer.msn.com
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: mai huynh
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
  
 

 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to:

Re: 3/14/01 - ORA-01653: unable to extend table ... by 2572 in table

2001-03-14 Thread Ruth Gramolini


You could either resize the existing datafile(s) or create a new datafile.

To resize:
alter database datafile '/full_path/datafile_name.dbf' resize M;

To create another datafile:
alter tablespace TBSP_NAME add datafile '/full_path/datafile_name.dbf'  size
M.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 12:36 PM


 I've been inserting tens of thousands of records into a database.
 I've hit the above error message and am looking to you folks for advice
 about what I should do.

 Is this where I need to add another data file to the tablespace or what?
 ...and how?

 Thanks in advance.
 Pat

 __
 Pat Gorden-Ozgul   BNL-ISD Systems
 [EMAIL PROTECTED] 631-344-5159





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

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

2001-03-14 Thread Raghu Kota

I agree with Kimberly, I don't why Canada simply following US?? I think 
Canada has every capacity to emerge as powerful nation. Simply following 
with out any backbone creates lot of problems in economy and society too.

From: Kimberly Smith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: oracle and America
Date: Wed, 14 Mar 2001 08:16:25 -0800

The sad part is the Canadian government feels compelled
to follow the Americans are replacing some of their
apps that ran on Unix to Windows.  Actually, the app is
an American one that they let us use.  A lot of critical
stuff is still on Unix.  Then again, ours ships really
don't need reliable stuff as we don't do anything except
support:-)

-Original Message-
Sent: Tuesday, March 13, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L

Holy mackerel!

I hope there isn't some rogue nation buying all our old VAX clusters to run
their navy. We'll get our behinds kicked!

- Jerry

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:06 AM

  On Tue, 13 Mar 2001, Boivin, Patrice J wrote:

   I thought I heard a story about a U.S. Navy ship that was towed to 
port
   because its systems ran on WindowsNT...

   Maybe it was an urban myth.

   I was glad to hear that the Boeing planes run on UNIX.

   ; )

   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)

  No myth this.  ( yeth? ;)

  Here's a reference:

  http://www.gcn.com/archives/gcn/1998/july13/cov2.htm

  Jared

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

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

RE: oracle and America

2001-03-14 Thread Jacques Kilchoer

Title: RE: oracle and America





 -Original Message-
 From: Raghu Kota [mailto:[EMAIL PROTECTED]]
 Sent: mercredi, 14. mars 2001 10:36
 
 I agree with Kimberly, I don't why Canada simply following 
 US?? I think 
 Canada has every capacity to emerge as powerful nation. 
 Simply following 
 with out any backbone creates lot of problems in economy and 
 society too.



Well said. Who on the list is Canadian? I think our list friends from the frozen north should get together to develop their own brand of UNIX. You can call it Canux. :)

Once Canux is written and available for an Intel or Amdahl processor, I promise I'll install it on my PC at home. But please make it Linux-compatible. Also it should have an install option for french of course. I want to see french man pages.

RE: Oracle JDBC driver

2001-03-14 Thread Val_Gamerman/Victoria_Financial . VICTORIA_FINANCIAL


Which version JDK are you using?  I only got the thin driver working.  Try
getting the thin driver working.

Dan

-Original Message-
Sent: Wednesday, March 14, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L


Here is the code:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =
  DriverManager.getConnection ("jdbc:oracle:oci8:@myserver", "admin", 
"admin");

This failed when call DriverManager.registerDriver(new 
oracle.jdbc.driver.OracleDriver());

Now after set the classpath=d:\jdbc\lib\classes111.zip.  It gives me the 
error ORA805.dll not found in the specified path
From: "Marin Dimitrov" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle JDBC driver
Date: Wed, 14 Mar 2001 01:20:23 -0800

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 00:06


 
  does anyone can tell me where to install Oracle JDBC driver?  I looked 
up
  oracle web site, but they just let me download the zip file and instruct
how
  to set the classpath and i still get the error 'unsuitable ddriver"


How do u initialize the driver in your application? How do the class name
and the url look like?


 Marin


"When someone is seeking, it happens quite easily that he only sees
the thing that he is seeking; that he is unable to find anything, unable to
absorb anything, because he is only thinking of the thing he is seeking,
because he is obsessed with his goal. Seeking means: to have a goal;
but finding means: to be free, to be receptive, to have no goal. ..."


 Herman Hesse, "Siddhartha"


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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

RE: STATSPACK or equivalent for 8.0.X databases?

2001-03-14 Thread Leonardo Fernandez




Hi,
As shipment my file report.txt, generated with statspack to www.oraperf.com?
That steps should carry out ?

Thanks,
Leonard F.





"Browett, Darren" [EMAIL PROTECTED]@fatcity.com on 14/03/2001
11:36:21 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


Try http://www.oracle.com/oramag/oracle/00-Mar/statspack-other.html

It outlines the steps to install adn run statspack within 8.0.x.

I haven't run it myself as of yet, but it looks straight forward.

-Original Message-
Sent: March 14, 2001 6:31 AM
To: Multiple recipients of list ORACLE-L



Will statspack ever be available, in a supported version, for
Oracle 8.0.X? We'll be upgrading the machine I'm concerned about
to 8.1.X eventually (next six months or so); But for now, I'd like to
have access to a more sophisticated tuning-data gathering tool than
bstat/estat.

I find it appalling that bstat/estat can't collect, compare, and
contrast multiple sets of tuning data over time; that it can't
calculate db buffer cache hit ratios, etc.

We've purchased Spotlight on Oracle from Quest; But come to find out
(someone else did the research and made the purchase recommendation
before I became involved), Spotlight is merely a real-time monitor and
can't save tuning data. I thought about writing something to retrieve
data from the Spotlight tables, or modifying bstat/estat to make it do
what I want, but statspack seems to do everything I want - and who
wants to reinvent the wheel?

Any good tuning data gathering freeware out there (with statspack-like
functionality) for use with 8.0.X databases?

Thanks very much.

 - Dana



__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dana
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

2001-03-14 Thread Richard Ji


Try to include d:\jdbc\lib in your PATH as well.  Are you using the thin
driver or OCI driver?

-Original Message-
Sent: Wednesday, March 14, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L


I think my question is not clear.  I have Oracle database on another
machine.  My machine doesn't have Oracle on it.  I just want to install
Oracle JDBC driver for my java program to connect to database.  I down load
the JDBC driver on Oracle website.  It's just a zip file, contains
classes111.zip, classes12.zip, ocij805dbc.dll,oci805jdbc_g.dll.  I extract
them under folder d:\jdbc\lib and set
classpath=d:\jdbc\lib\classes111.zip;d:\jdbc\lib\classes12.zip
It gives me the error: ORA805.dll missing in the specified path when I call
the code:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Thanks


From: "Dasko, Dan" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle JDBC driver
Date: Wed, 14 Mar 2001 06:46:09 -0800

Remember, Oracle is very particular about which driver and which JDK.  If
you have those correct, then it usually installs in $ORACLE_HOME/jdbc in
NT.
For Unix, I don't have any idea.

Dan

-Original Message-
Sent: Tuesday, March 13, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L



does anyone can tell me where to install Oracle JDBC driver?  I looked up
oracle web site, but they just let me download the zip file and instruct
how

to set the classpath and i still get the error 'unsuitable ddriver"
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
   INET: [EMAIL PROTECTED]

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

Locally Managed Tablespace Uniform Extent

2001-03-14 Thread Jim Walski


I have to move a 7.3.4 database to 8i and I want to use the uniform extent
size to reduce fragmentation.  I read the article "stop defragmenting and
start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M.

I also read an article on Steve Adams site that indicates to keep the number
of extents under (db_block_size/16) - 7 ( which in my case ( 8k block) would
be 505 extents. )

In the database I am moving there are some segments that are currently 1GB
in size, if i was to put those in the 4M tablespace it would already have
over 250 extents starting off.  Are there any other performance type issues
to consider?

Should I create another extent size between 4M and the 128M?  Maybe 64M
increment?

Thanks,
Jim

Jim Walski
ClassicPlan
Chino, CA 91710
email [EMAIL PROTECTED]
http://www.classicplan.com

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

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

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

2001-03-14 Thread Brian D. Silverio

This is very hardware vendor specific and rather complex. 
Start by asking your your hardware vendor or visiting their web site.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vulpe
 Cristian
 Sent: Wednesday, March 14, 2001 12:11 PM
 To: Multiple recipients of list ORACLE-L
 Subject: failover problem

 Hi!

 I am working on an application that has many concurrent users and I
 would like to configure a background failover server. I am asking you if
 I can do that and where should I read some documentation about this...

 Best regards,
 Vulpe Cristian

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

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

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

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

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

2001-03-14 Thread eric harrington


Hi Skip,

SQLBase does have similar views.  I only remember a few (I think these are
correct): SYSTABLES, SYSCOLUMNS, SYSPKCONSTRAINTS, SYSFKCONSTRAINTS etc.

They are listed in the back of the Administrator's guide.  Hopefully you can
get your hands on the hardcopy or electronic copy.  I do not have access to
this information anymore.

Eric Harrington

-Original Message-
Skip
Sent: Wednesday, March 14, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L


We have to convert data from an old sqlbase database into Oracle.
Does anyone know if SQLBASE has views or system tables like Oracle does for
getting a listing of
table names, columns and column types/lengths like dba_tables, dba_views,
all_tables that
Oracle has? I've had no luck searching the web to get this information.
Any ideas?? Anyone worked with SQLBASE??
Thanks
Skip


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

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

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

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

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

2001-03-14 Thread Steve Cawley


Informix offers a DBA course for Oracle DBA's:

http://www.informix.com/informix/training/courses/educat/descrpt/level1/crsL
1-760.htm

-Original Message-
Sent: Wednesday, March 14, 2001 1:22 PM
To: Multiple recipients of list ORACLE-L


In addition to unix admin  oracle dba duties, I am now tasked with an
informix db.  Not that I mind, with oracle's pricing, it may become the db
of choice :).  Any recommendations on which informix dba course to take to
get up to speed for a seasoned sys admin/oracle dba? 

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Cawley
  INET: [EMAIL PROTECTED]

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

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





Mai,

This is exactly what I was talking about when I said that you need to make
sure sure that you use thin drivers. If you get an error message
complaining about a missing DLL then your java program is using JDBC-OCI
drivers or JDBC-ODBC drivers.

Get documentation and samples for using the THIN JDBC drivers.

What is your connect string?

Get documentation and samples for using the THIN JDBC drivers.

Another thing: do NOT add both ZIP files to your path. classes111.zip if
for JDK1.1 and the other one is for JDK1.2. Figure out which one you are
using.

Get documentation and samples for using the THIN JDBC drivers.

Hope this helps.
Val Gamerman.

To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Val Gamerman/Victoria Financial)
Date: 03/14/2001 07:56:20 PM GMT




I think my question is not clear.  I have Oracle database on another
machine.  My machine doesn't have Oracle on it.  I just want to install
Oracle JDBC driver for my java program to connect to database.  I down load
the JDBC driver on Oracle website.  It's just a zip file, contains
classes111.zip, classes12.zip, ocij805dbc.dll,oci805jdbc_g.dll.  I extract
them under folder d:\jdbc\lib and set
classpath=d:\jdbc\lib\classes111.zip;d:\jdbc\lib\classes12.zip
It gives me the error: ORA805.dll missing in the specified path when I call
the code:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Thanks

From: "Dasko, Dan" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle JDBC driver
Date: Wed, 14 Mar 2001 06:46:09 -0800

Remember, Oracle is very particular about which driver and which JDK.  If
you have those correct, then it usually installs in $ORACLE_HOME/jdbc in
NT.
For Unix, I don't have any idea.

Dan

-Original Message-
Sent: Tuesday, March 13, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L



does anyone can tell me where to install Oracle JDBC driver?  I looked up
oracle web site, but they just let me download the zip file and instruct
how

to set the classpath and i still get the error 'unsuitable ddriver"
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
This e-mail message has been scanned for the presence of all known
computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mai huynh
  INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

RE: oracle and America


Yeah, but there's still some good things about Canada.  They have free
health care, schools are free and they invented hockey!!  Besides, I
wouldn't exactly say that Canada is following the us as much as they are
Europe, they are more of a European type nation.  They just follow us a
little bit because they are so close to us, besides, why get involved in the
bs of the world when you have the US to protect you?

-Original Message-
Sent: Wednesday, March 14, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


I agree with Kimberly, I don't why Canada simply following US?? I think
Canada has every capacity to emerge as powerful nation. Simply following
with out any backbone creates lot of problems in economy and society too.


From: Kimberly Smith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: oracle and America
Date: Wed, 14 Mar 2001 08:16:25 -0800

The sad part is the Canadian government feels compelled
to follow the Americans are replacing some of their
apps that ran on Unix to Windows.  Actually, the app is
an American one that they let us use.  A lot of critical
stuff is still on Unix.  Then again, ours ships really
don't need reliable stuff as we don't do anything except
support:-)

-Original Message-
Sent: Tuesday, March 13, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


Holy mackerel!

I hope there isn't some rogue nation buying all our old VAX clusters to run
their navy. We'll get our behinds kicked!


- Jerry

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:06 AM


  On Tue, 13 Mar 2001, Boivin, Patrice J wrote:
 
   I thought I heard a story about a U.S. Navy ship that was towed to
port
   because its systems ran on WindowsNT...
  
   Maybe it was an urban myth.
  
   I was glad to hear that the Boeing planes run on UNIX.
  
   ; )
  
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
 
  No myth this.  ( yeth? ;)
 
  Here's a reference:
 
  http://www.gcn.com/archives/gcn/1998/july13/cov2.htm
 
  Jared
 
 
  --
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

RE: OT -- Canada and U.S. (was: oracle and America)

2001-03-14 Thread John Lewis


Bravo!

Canada is wonderful place!!! What a boring little planet this would
be if we all thought the same way. God save us from 'one size fits all'.

As a Northwesterner, I find myself having more in common with 
Canada, esp. British Columbia,  than those "bubba's" in Washington, DC.

john f. lewis

-Original Message-
Sent: Wednesday, March 14, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L


Well, that's a bit of a flame, also coming from an anonymous Hotmail account
I see. (Hotmail is always anonymous, although I believe the accounts can be
traced)

When I lived in Ottawa I used to know someone from Spain who talked about
Canadians not being aggressive enough, people should fight their government,
etc. etc. but look at the result - bombings, etc. and for many years, a
dictatorship.  Life is short, why waste time bashing each other over the
head.  Do what you can to leave a good mark, while you can.  Violence
doesn't solve anything, but I agree that sometimes situations are
unbearable.  Work through them.  Economic disparities can cause major
problems, I agree that's pretty obvious.  But there are a lot of factors at
play in that.

It's ironic that in some cases people who are very aggressive end up with a
dictatorship...  I think that says a lot about the authoritarian personality
(read Erich Fromm).

There is something to be said for being assertive but not aggressive, it
helps reduce the crime rate for example.  Being assertive doesn't mean being
passive.  You can be a goat, don't have to be a sheep or a wolf.

Kimberly moved to the U.S. because she got a good offer through EDS and
because after Y2K, the opportunities here in Halifax were not what they were
before Y2K.  I am sure she would have been able to find something in
Halifax, or in Canada, but she probably got a better offer in the U.S.
first.  There are a number of Americans working in Canada, and vice versa.
Canada is the U.S.'s largest trading partner, and we have a Free Trade
Agreement with our southern neighbors.  The two cultures have a lot in
common.

Our economy is beginning a bit of a slump right now, but overall it hasn't
been that bad.  I read last night that there are many H1-B visa people in
the U.S. who have been laid off by high-tech firms, now they have 2 months
to find another job or they have to leave.

Taxes here are higher than in the U.S., and we have a smaller population
therefore some people who can do it go south to find better opportunities.

I agree with you that one should not follow without thinking, it would prove
the behaviorists right.  We are all just a bunch of conditioned animals then
if that's true.  It is better to remain conscious I think, between the
stimulus and the response.  I believe that some eastern groups are better at
this than we are.  At least they talk about it more, whether they actually
practice mindfulness or not is another matter.

Also, our past Prime Minister Pierre Trudeau used to say that when you sleep
next to elephant, every time he shifts in his sleep you go into alert mode.
(this is not an exact quote, but you get the idea).

I have a long list of things I would like to get done if I was Prime
Minister, but my wife said she would leave the country if that ever
happened.  I am sure a lot of Americans think about what they would do if
they were to become President.  But how much influence do those jobs really
have nowadays?  Don't know.  I suspect a lot of people just complain but
assume that nothing can be done to improve things.

Anyway, that's my take on this. 

: )

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Raghu Kota [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, March 14, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: oracle and America

I agree with Kimberly, I don't why Canada simply following US?? I
think 
Canada has every capacity to emerge as powerful nation. Simply
following 
with out any backbone creates lot of problems in economy and society
too.


From: Kimberly Smith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: oracle and America
Date: Wed, 14 Mar 2001 08:16:25 -0800

The sad part is the Canadian government feels compelled
to follow the Americans are replacing some of their
apps that ran on Unix to Windows.  Actually, the app is
an American one that they let us use.  A lot of critical
stuff is still on Unix.  Then again, ours ships really
don't need reliable stuff as we don't do anything except
support:-)

-Original Message-
Sent: Tuesday, March 13, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


Holy mackerel!

I hope there isn't some rogue

RE: Oracle Internals

Title: RE: Oracle Internals





Henry, 


You are welcome. I have not read Steve's book, so can't comment
on the prose there, but..coupla points:


0) Semaphores usually (but not always!) protect binary resources...
things requiring mutual exclusion (one at a time) or which have
producer/consumer relationships ( i put a value in, you take it out
for further processing. think PQO ). (There *are* things called
mutex locks which are more efficient than semaphores for pure mutex
applications...) 


1) semaphores need not be binary. Eg, I can protect a multibuffer 
resource with a semaphore that decrements down from MAXBUFFER. 
When it hits zero, there are no more buffers in that resource. 
(And then it blocks)


2) semaphores can be implemented in the OS or the dbms kernel 
(for the former, consider the family of SEMOP() calls.)


3) processes may act differently upon resources acquisition failure, 
they wait (by CPU spin, by sleep, by erroring out) or they can
do something else for a while and re-check. In all cases, it
is the interested process who has the responsibility to acquire
resources. A semaphore is not responsible for the acquisition of
resources, only the *protection* of them. 


So, to answer your question : If I am sleeping and the latch frees, 
who knows I need that semaphore? The answer is: You do. ( you in
this context, is the process needing the resource, of course.) 


And, to answer your question: Are all waiting processes posted with 
the semaphores going on/off/on/off? the answer, for Unix, is No.
Semaphores do not broadcast. They are merely set or not set. 


And, for a punchline, kind of: People sometimes confuse postwait drivers
with semaphores. They are NOT the same. Much different animals. But, they
can share functionality in some cases ( oracle is one! ) and so there is
room for confusion. 


hth


Ross
-Original Message-
From: Henry Poras [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Internals



RM,
Thanks. Intuitively that seems like the way it should work. However it
appears to contradict what Steve wrote in his book about a sleeping process
waiting on its semaphore. I wonder if this is just a publishing error, or if
I am missing something in my understanding. I usually find it a good policy
to give Steve Adams the benefit of the doubt.

Henry


-Original Message-
Sent: Wednesday, March 14, 2001 9:06 AM
To: Multiple recipients of list ORACLE-L




HP, it is sleep/wake/check. it is up to the process to acquire the 
resource. AFAIK, there is no message-passing type of algorithm to 
tell waiting (whether spinning or sleeping) processes when the 
semaphore becomes unset ( ie the resource is available ) Sleeps 
are expensive in Latchville, and you can track their occurence 
via v$latch_waits and the SLEEP* columns. 


hope this partial answer helps. 


-Original Message- 
] 
Sent: Tuesday, March 13, 2001 10:25 PM 
To: Multiple recipients of list ORACLE-L 



I have been rereading Steve Adam's book a bit more carefully and have a 
question. Just wondering if anyone has any answers. 


When talking about latch sleeps, the book states a process sleeping for a 
latch waits on its semaphore. However, latches don't support queuing and a 
number of processes may be waiting for the same latch. If I am sleeping and 
the latch frees, who knows I need that semaphore? Are all waiting processes 
posted with the semaphores going on/off/on/off? or is no semaphore posted 
and the processes go sleep/wake/check/sleep/wake/check? I can't quite 
picture the details here. 


Henry 




 
Think you know someone who can answer the above question? Forward it to
them! 
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
http://www.LAZYDBA.com/odbareadmail.pl 
Tell yer mates about http://www.farAwayJobs.com http://www.farAwayJobs.com


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


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


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

RE: Order of table_name resolution


whoo hooo

-Original Message-
Carmichael
Sent: Wednesday, March 14, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L


that's the right order


From: "Kevin Kostyszyn" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Order of table_name resolution
Date: Wed, 14 Mar 2001 06:05:56 -0800

I am not positive, but I think that is the correct order.  This had been
discussed before and ofcourse, with my limited brain capacity I can't
remember.
Kev

-Original Message-
T (Richard)
Sent: Wednesday, March 14, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L


Hi DBAs,

Can someone clarify/confirm on how Oracle determines what table to use in
select statement?

For ex. If I am login as Scott and do the following:

SELECT * FROM employee;

Of course Oracle will use Scott.employee if it exist. If it does not exist
but exist under another schema. Does
Oracle look at private synonyms then public synonyms or vice versa.

My guess is Oracle checks in this order. Please confirm or correct.

1. Check if table exist in current schema
2. Check private synonyms
3. Check public synonyms
4. 3 strikes your out with an error.

Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
   INET: [EMAIL PROTECTED]

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

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- Canada and U.S. (was: oracle and America)

2001-03-14 Thread Jack C. Applewhite


Yes, and even a die-hard Texan like me much prefers
sentences followed by "Eh?" to the obnoxious U.S.ism "ya
know?".

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
John Lewis
Sent: Wednesday, March 14, 2001 3:22 PM
To: Multiple recipients of list ORACLE-L


Bravo!

Canada is wonderful place!!! What a boring little planet
this would
be if we all thought the same way. God save us from 'one
size fits all'.

As a Northwesterner, I find myself having more in common
with
Canada, esp. British Columbia,  than those "bubba's" in
Washington, DC.

john f. lewis

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

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

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

RE: Locally Managed Tablespace Uniform Extent

2001-03-14 Thread Jack C. Applewhite


Jim,

I'm probably a bit extreme here, but, with all due respect
to Steve Adams (because I really do), I wouldn't worry
terribly much about numbers of extents.

Our 8.1.6 production db on Win2k has 8KB block size and
uniform extent size of 1MB in all tablespaces.  Our largest
segment stores the out-of-line CLOBs of a partition of our
largest table - it has over 22,000 extents.  Another
partition has a CLOB segment of over 18,000 extents.  Since
we hit those segments by RowID during InterMedia Text index
queries, we've had absolutely no performance problems - we
get 1 to 5 second response times.  Actually, the InterMedia
Text index segments have over 1,000 extents.

A bunch of our tables with non-LOB data have hundreds of
extents as well, which probably puts them in line with
Steve's guidelines, but I wouldn't be worried if they got up
into the thousands of extents.

I'm sure there are numerous situations where different
extent sizes in different tablespaces makes sense.  Maybe
I'm just too lazy.  We don't have that many small tables
where 1MB extents waste a lot of space and, like I said, I
don't worry about too many extents, though if extents
approached the hundreds of thousands, I might create a
tablespace or two with large extents for those segments.
I've just not seen really convincing arguments that large
(but not huge) numbers of extents cause significant
performance problems, especially compared to the really BAD
SQL that Duhvelopers seem so fond of writing.   ;-)

A big advantage is that I can't even remember the last time
I worried about coelescing and fragmentation!

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Jim Walski
Sent: Wednesday, March 14, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L


I have to move a 7.3.4 database to 8i and I want to use the
uniform extent
size to reduce fragmentation.  I read the article "stop
defragmenting and
start living" and it indicates to have 3 extent sizes -
128K, 4M, 128M.

I also read an article on Steve Adams site that indicates to
keep the number
of extents under (db_block_size/16) - 7 ( which in my case
 8k block) would
be 505 extents. )

In the database I am moving there are some segments that are
currently 1GB
in size, if i was to put those in the 4M tablespace it would
already have
over 250 extents starting off.  Are there any other
performance type issues
to consider?

Should I create another extent size between 4M and the 128M?
Maybe 64M
increment?

Thanks,
Jim

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

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

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

2001-03-14 Thread Deshpande, Kirti


Hi Jay..
 No, you did not miss it. 
 It's been an undocmented little nice feature..and I believe it still is
undocumented as far as Oracle Docs go. 

Cheers ! 

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Miller, Jay [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, March 14, 2001 11:11 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Script for reversing a string?
 
 Hi Kirti,
 
 Huh.
 
 This function isn't even mentioned in Koch's Oracle8 The "Complete"
 Reference (I just double checked because I couldn't believe I'd miss
 something like that.
 
 Thanks!
 
 Jay
 
 -Original Message-
 Sent: Monday, March 12, 2001 6:40 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi.
 
 How about using a simple 'reverse' function available with SQL ??
 
 Here is an example from 7.3.4.3 :
 
 Connected to:
 Oracle7 Server Release 7.3.4.3.0 - Production
 With the distributed and parallel query options
 PL/SQL Release 2.3.4.3.0 - Production
 
 SQL select reverse('oracle') from dual;
 
 REVERS
 --
 elcaro
 
 And with 8.1.7 :
 
 Connected to:
 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
 With the Partitioning option
 JServer Release 8.1.7.0.0 - Production
 
 SQL select reverse('ORACLE') from dual;
 
 REVERS
 --
 ELCARO
 
 SQL 
 
 We played with this, probably undocumented feature in 7.3.4, to index
 columns( since reverse key indexes were not available, so this was the
 trick).
 
 HTH..
 - Kirti Deshpande 
   Verizon Information Services
http://www.superpages.com
 
  -Original Message-
  From:   Mandar Ghosalkar [SMTP:[EMAIL PROTECTED]]
  Sent:   Monday, March 12, 2001 4:11 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Script for reversing a string?
  
  U did the right thing Jay. Oracle does provides u the answer.
  thats why its called Oracle (answer to everything), except when it comes
  to
  licensing
  
  
  select
  utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK')))
  from
  dual
  /
  
  -Mandar
  
   -Original Message-
   From: Miller, Jay [mailto:[EMAIL PROTECTED]]
   Sent: Monday, March 12, 2001 3:17 PM
   To: Multiple recipients of list ORACLE-L
   Subject: Script for reversing a string?
   
   
   Before I reinvent the wheel, I was wondering if anyone has written a
   function that will reverse a string?
   Our auditors are requiring that Oracle passwords not contain 
   the reverse of
   the user name and I was about to start writing this function 
   when I decided
   to check here first.
   
   Thanks!
   
   Jay Miller
   
   
   
   -Original Message-
   Sent: Friday, March 09, 2001 3:26 PM
   To: Multiple recipients of list ORACLE-L
   
   
   It hasn't caused me any problems - have only tried it on this 
   test server so
   far, and on my workstation.  
   
   The workstation has Oracle 7.3. and 8.0.4 on it they have 
   been running for
   over a year.
   
   I wouldn't try this on a production system!  These are test 
   databases only.
   
   I am just curious why the files are so fragmented.
   
   Regards,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
   
   Systems Admin  Operations | Admin. et Exploit. des systmes
   Technology Services| Services technologiques
   Informatics Branch | Direction de l'informatique 
   Maritimes Region, DFO  | Rgion des Maritimes, MPO
   
   E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
   
   
 -Original Message-
 From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
 Sent:   Friday, March 09, 2001 3:36 PM
 To: Multiple recipients of list ORACLE-L
 Subject:RE: Does NT write to random locations on disk?
   
 I wouldn't think you would want to reorg an Oracle 
   tablespace with
   an NT
 defrag utility.  You would corrupt the data.
 Ron Smith
 Database Administration
 [EMAIL PROTECTED]
  
   
 -Original Message-
 Sent: Friday, March 09, 2001 1:01 PM
 To: Multiple recipients of list ORACLE-L
   
   
 Using a little utility called contig I noticed that the 
   Oracle 8.1.6
 datafiles on my test NT server are quite fragmented, an 
   average of
   177
 fragments per file, 118 fragments for the OEM 
   repository datafile.
   The poor
 utility couldn't do anything with the database files, 
   they are too
   large
 perhaps.
   
 These were created on an empty server, 8i release 2 
   went on it after
   a
 defrag, then the OEM.  This is on a hard disk with 1.2G of free
   space, none
 of the datafiles come close to that.
   
 Why so many fragments?  Oracle created those files in 
   one pass, does
   NT
 write randomly to disk or what?
   
 Won't this have an impact on my NT database's performance?
   
 Oracle says tablespace fragmentation is not a big deal, but
   fragmentation at
 the OS level matters.   Supposedly

OT -- Canada and U.S. (was: oracle and America)