Re: DBA_USERS view

[Luis DeUrioste]

What you can do is:
copy encrypted password  to some file
change user password to something else
run the tests you need
reset user password by copying encrypted password back

Tavo

Stefan Jahnke wrote:

> Hi,
>
> what information does the PASSWORD column in the DBA_USERS view provide.
> I know that it's the encrypted user password, but how can I actually use
> it ?
> For example: Can I reassign a password to a user via his encrypted
> password ?
> or: Can I test a logon with another user's encrpyted user password to
> test the logon ?
> I tried stuff like connect myuser/0CE92663BBC6FC34@MYDB, but that
> doesn't seem to work.
>
> TIA ...
>
> --
> Regards,
> Stefan Jahnke
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: SQL*Loader help

[Luis DeUrioste]

Just insert the string you want in the position you desire.

i.e.. (01110,"*",,,1,1,31460)

you would also have to specify the delimiters in the control file.

regards

Tavo

[EMAIL PROTECTED] wrote:

> Maybe some could help me.
> I'm having trouble trying to load a csv  file with sqlldr. The destination table
> has char columns defined as not null and the csv file has missing data for these
> columns. (These columns  will contain blanks in the database).
>
> Sqlldr wants to set  the missing fields to null, which results in record
> rejected errors. Is there a way around this.  I would be happy if I could insert
> blanks or insert any other marker-value  into the field like '***'..
> The input file lines looks something like   (011101,1,31460)
> Thanks
> Chaim
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

WIN2k - Backup

[Luis DeUrioste]

Dear List Members:

We are in the planning stage of upgrading from NT 40 to Windows2000
and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row.  My
question is, has anybody used Win2k Backup to Backup the database ?
Can it handle < somehow > shutting down the DB for cold Backups ?  I
currently use ArcServIT with the Oracle Agent and it handles the whole
"Enchilada".Should I upgrade ArcServIT and keep it?  Are there any
better Backup Solutions? Any input will be appreciated.

Regards

Tavo

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

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

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

Win2k Backup

[Luis DeUrioste]

Dear List Members:

We are in the planning stage of upgrading from NT 40 to Windows2000
and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row.  My
question is, has anybody used Win2k Backup to Backup the database ?
Can it handle < somehow > shutting down the DB for cold Backups ?  I
currently use ArcServIT with the Oracle Agent and it handles the whole

"Enchilada".Should I upgrade ArcServIT and keep it?  Are there any

better Backup Solutions? Any input will be appreciated.

Regards

Tavo


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Where can I find real-life-examples about ORACLE installations?

[Luis DeUrioste]

Beatriz,

What about starting by getting the "ORACLE 8i Starter Kit book" that should
get you off the ground.

Good Luck !

Tavo

Beatriz Martinez wrote:

> Hello list,
> We are beginning a proyect in ORACLE, and I wonder myself if there is
> any place where I could find any real implementation, or any experience
> (good or horrible.) for orienting correctly us.
> I mean, which different databases should we create, which
> restrictions... Something related with real implementation. Really I
> don´t know what we are looking for, but something that could help us to
> begin.
> Maybe it´s an strange petition. Anyway, if any of you have any idea, We
> would be very grateful,
> TIA, a lot
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Beatriz Martinez
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

RE: EM To Go

[Luis deUrioste]

I be Ari Kaplan, designer and creator of Pocket DBA is not very happy. On the other 
hand he should be, they are following his idea.

BTW, you can get a Palm VII [the dinosaur] for about $50 and it has a modem, probably 
more than you need to monitor a database. $70 with external keyboard.

Luis

-Original Message-
Sent: Monday, September 08, 2003 7:30 AM
To: Multiple recipients of list ORACLE-L


http://www.infoworld.com/article/03/09/05/HNorremote_1.html

Now if only I had a PDA.

Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database Link

[Luis deUrioste]

You need to configure your TNSNames in your 9i Box.
Luis

-Original Message-
Sent: Monday, September 08, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L


Dear List,

I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on
oracle 9.0.1(two separate box) I have created a database link under oracle
8 to oracle 9 database & it's working fine from 8 to 9, but when I try to
use this link from 9 to 8 it's failed to ORA-12154.
Any idea what could be this??

Thanks allot for your help.



Hamid Alavi

Office   :  818-737-0526
Cell phone  :  818-416-5095

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

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

9iAS v 1.0.2.2.0 Installation Problem

[Luis deUrioste]

We are trying to install 9iAS 1.0.2.2.0 on a Dell Poweredge 2650 / P4 2Gig, we have 
succesfully installed this software in older model machines. When we try to run the 
installer from the distribuition media we get an error that the installer did not run 
because it was probably aborted and to run setup again. We bypassed this by 
downloading the OUI 2.8.18.2 (installer 2.2) and that way we were able to run the 
installation. Everything seems to run fine until we get towards the end a CMD windows 
is display and it hangs, we closed it manually. Then a new CMD window is displayed and 
some script flashes trhough, after this the installation gets to 99% and it hangs. The 
installer shows that is installing a .gif file and it stays there.
Can somebody shed some light on me, and prompt me on a solution path? 

I spent hours serching through Metalink and havn't found anything that helped.

I submitted a TAR, but you guys know it may take a while and I'm pressed for time.

T.I.A..

Luis Octavio de Urioste
Systems Analyst
PH. (850) 454.2943
e-mail: [EMAIL PROTECTED]
Vertex Aerospace LLC



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Re[2]: Online tech books

[Luis deUrioste]

Bless you Bob !

I will use your pictures to settle the argument of too many books with my wife! I told 
her I reduce my number of books as long as she reduces the number of shoes. She got a 
bit offensive.

Luis

-Original Message-
Sent: Wednesday, July 02, 2003 10:11 AM
To: Multiple recipients of list ORACLE-L


Monday, June 30, 2003, 10:39:40 AM, you wrote:
BM> I just returned frm vacation, but I wanted to respond to Jonathan
BM> Gennick regarding my collection of books.( I managed to delete that
BM> message) But, Ive taken some pictures of my collection.. Ive actually
BM> purchaced all the books you see!
BM> http://162.42.213.232/books/index.html

Wow! Bob, I think you have me beat, and I'm no slouch when
it comes to ordering books.

Hey, you know what else, as I look very closely at your
bookcases, I think you use the same cheap,
partical-board-covered-with-paper, bendable-shelf brand that
I use.

I better get on the stick and order more books.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: LISTENER ON LINUX

[Luis deUrioste]

Sounds like a duplicated IP or duplicated Service name.
Luis

-Original Message-
Sent: Wednesday, July 02, 2003 12:36 PM
To: Multiple recipients of list ORACLE-L


Hi,
When I am trying to start listener on Linux box ,getting error
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use
I checked no process fro listener and no port used by another process.
Let me know how to fix that pl
thx
-Seema

_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ER Tools (was: erwin)

[Luis deUrioste]

There was a Tool I used in the past, Sdesigner, simple to use. Also if all you need is 
an older version of Designer, what you could always do is buy one of the books that 
bundle with a copy of developer 2.1 or 6i.

-Original Message-
Sent: Monday, July 07, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L


Anyone care to ballpark a $$$ on the registered version of ERwin?  I'm
guessing it's expensive, and Computer ASSociates doesn't exactly trip my
trigger.

I'm trying to find a low-cost ER tool in order to get some simple data
modeling done.  So far, this is what I've found (VERY briefly):

1)  Visio.  Needs Enterprise edition.  The UI is a pain, as far as I'm
concerned.  Pain, pain, pain.  Cheapest viable option so far at less than
$500/user.  It can be used for more than just data modeling.

2)  Oracle 9iDS.  Hugely bloated.  Relies on a 3GB (minimum) repository for
some stupid reason.  Apparently can't buy just Designer, which is all we
need.  Difficult to get started (concepts and management of workspace,
container).  Slow on a 2.4Ghz PC w/512MB RAM, although this may be due to me
having to create the [EMAIL PROTECTED] repository DB on the same PC.  Very
comprehensive, though, from what I've seen.  Can't access drawings from the
OS, since they're (probably) in the repository.

3)  No freeware tools such as dia, VisioModeler (pre-MS version of Visio),
OpenOffice, or Koffice seemed to be able to draw crow's foot diagrams.

4)  Sybase PowerBuilder.  Didn't check out the download yet, although a demo
of an older version (v6) seems like it would work.  Not impressed with
Sybase in general and it's probably in the $1Ks/user.

5)  Data Architect from TheKompany.com only does physical modelling and
their Kivio product doesn't seem to support crow's foot.

6)  DeZign from datanamic.com.  Haven't downloaded the demo yet, but the
single screenshot looks promising.  And at $149/user or $119/user for 10
licenses, I'm hoping...

I've been looking thru past messages found on orafaq.com (better searching
than fatcity.com) and this is the majority of what I've been able to find.
Anyone have more to add?

Rich

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


> -Original Message-
> From: Jay Wade [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: erwin
> 
> 
> hello:
> 
> The below has info about the product:
> http://www3.ca.com/Solutions/Product.asp?ID=260
> 
> The below has the download link:
> http://www3.ca.com/Solutions/Collateral.asp?CID=33655&ID=260
> 
> 
> 
> >From: <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: erwin
> >Date: Mon, 07 Jul 2003 04:54:25 -0800
> >
> >How can I found a trial version of erwin
> >
> >Danke...
> >Arslan.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: service name, sid ..

[Luis deUrioste]

The 
laugh of the day
 
. 
the fecal matter hits the rotary oscillator.

  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 2:00 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  service name, sid ..
  AK,
   
      You can make it as simple or complicated as you 
  want.  Personally I prefer the KISS principle.  It's easier to 
  troubleshoot when the fecal matter hits the rotary 
  oscillator.
   
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
  
  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 3:34 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  service name, sid ..
  Tanel,
   
  Thanks for elaborate information , I really liked 
  it . Still why do u need to provide db name in tnsnames, all one should know 
  is which instance to connect . Instance know , which db to connect 
  .
  why do net8 bother about dbname ?
   
  -ak
   
   
  - Original Message - 
  
From: 
Tanel 
Poder 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, July 03, 2003 10:49 
AM
Subject: Re: service name, sid .

Hi!
 
There's actually more:
 
db_name - identifies database name, has to be 
the same what is stated in controlfile (using create database or create 
controlfile). You can have several databases with same db_name in one 
server, there is no restriction.
 
SID - When we actually want to open and use the 
database, we have to start an instance which will be servicing the 
database. When starting instance, whe have to specify SID (system 
identifier) for it. This is actually just a operating system name for 
instance (or should I say SGA shared memory segments). As you know, SID is 
specified using ORACLE_SID OS environment variable and is only used by 
listener, when spawning new processes or when attaching directly to SGA 
using bequeath protocol. You can not have instances with same SID in one 
server, even if you use different oracle homes.
 
instance_name - An Oracle parameter for 
specifying Oracle instance name. Seems that operating system doesn't know 
anything about it. For example, if you use SID_LIST parameters in your 
listener.ora, then listener always knows how to spawn processes for given 
SID, because (almost) all it takes to start another server process, is the 
location of oracle executable and SID value. But if you want to connect 
using instance name (not SID itself) then Oracle instance actually has to 
register itself with listener before any server processes can be spawned. 

Note that ORACLE_SID and instance_name 
variables do not have to match. (Tested on 9.2.0.1 on W2K). If my SID is 
ORCL for example and instance_name is TEST, then I can connect using both 
SID=ORCL and SID=TEST in CONNECT_DATA section of TNSNAMES (again, the 
instance name has to be registered with listener). V$INSTANCE still shows 
SID (ORCL) in instance name fielt.
 
As we know, in OPS and RAC environment you 
could have several instances servicing one database, this is one 
of common reasons why db_name and instance_name would be different. 
(ORCL for db_name, ORC0, ORC1, ORC2, etc.. for instance names for example). 
Btw, does anyone know if I can have the same instance name in all RAC nodes? 
RAC shouldn't care much, because it uses instance numbers 
anyway?
 
service_names - this is an 
additional layer for logically spreading work across nodes in RAC (and 
possibly other load balanced environments such replicated databases and even 
logical standby). For example, if you have 4 node RAC and have defined two 
"services" such OLTP and REPORTING, then you could assign OLTP for nodes and 
REPORTING for one, but during month end reporting you could still keep OLTP 
on 3 nodes, 1 node purely for REPORTING and add REPORTING to one or more 
OLTPs as well. So, when user's are connecting, they don't request a specific 
node or instance, they just request a service. And in load balancing 
environments then users are directed to instances, where appropriate service 
is defined. It gives somewhat flexibility, but I've never used it myself 
(thus my explanation here might wrong ;)
 
Cheers,
Tanel.

  - Original Message - 
  From: 
  AK 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Wednesday, July 02, 2003 9:49 
  PM
  Subject: service name, sid .
  
  I am reading oracle network admin guide and 
  getting confused abt service name, instance name , db name , sid . 
  
   
  why service name is not same as db 
  name . Earlier service name and sid used to be same thing .. isn't it 
  ( ? ) .
   
  Can some one clarify with 

RE: should you seperate indexes from tables in seperate datafiles?

[Luis deUrioste]

I LOVE THIS LIST!

A few more personalities (GAJA, ARI, IAN .) opinions added to this discussion and 
we could publish a paper on this thread alone.

Thank you GURUS

You are the ones that make monitoring this list worth more than anything !

Luis

-Original Message-
Sent: Tuesday, July 15, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
datafiles?


The thing that occurred to me a few years ago (as a result of a test
designed by Craig Shallahamer) is that "what disks do" gets very, very
complicated when you add users. On any system busy enough to have a
performance problem, the odds are usually slim that a disk is just "sitting
there" waiting for your next I/O call. On a busy system, someone else's I/O
call is almost always going to intercede between two of *your* I/O calls.

As has been said many times, many ways...

- DO separate tables and indexes into different tablespaces. There are lots
of reasons you should do this.

- DON'T necessarily feel that you have to put the index and data tablespaces
on different devices. One decision criterion is performance: don't ever put
two files on the same device if the sum of their I/O-per-second rates
exceeds the I/O-per-second capacity of the device. Another decision
criterion is availability: don't ever put more data on a device than you can
recover in your acceptable downtime window. The list goes on...


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Daniel Fink
Sent: Tuesday, July 15, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L

I may be way off base here, so any gurus please correct me with a gentle
slap to the back of the head...

Index and table access is not as simple as index entry..table row..index
entry..table row..etc. I just ran a quick test (which may not be
represntative and is using the primary key which can be understood as the
row number in physical order of the data blocks) and I found (using the
sequence of wait events) that there was substantial access to the index
datafiles initially, followed by substantial access to the data datafiles.
Then another single access to index, multiple access to data, single
access to index, multiple access to data. It seems to me that this pattern
is read several index blocks, then access several data blocks, read several
index blocks, access several data blocks. This may be due to the sequential
nature of the pk in the data blocks. It seems that the most efficient
algorithm is to read enough index blocks to set up a list of data blocks to
read, then go get them. Since you have the index block pinned, don't waste
any resource in releasing the pin to pin the data
blocks, then repin the index block.

The other issue is that indexes can be accessed using multiblock reads
(index fast full scan) and tables can be indexed using single block reads
(table access by rowid). 


Garry Gillies wrote:
> 
> It's hot here. I wish I was at the beach and I feel like a rant.
> 
> "oracle actually accesses indexes and tables serially"
> 
> Is it just me or is this blindingly obvious?
> You cannot access the table data until you have completed accessing the
> index data
> because the index data contains the location of the table data.
> 
> During an indexed query on a single table the index will be accessed, then
> the table,
> then the index,then the table,  then the index,then the table  then the
> index,then the table.
> If the index and the table are on the same disk then a lot of time will be
> taken up by
> head seek movement.
> If they are on the different disks then the "index" heads can locate their
> data and stay
> there - and the "data" heads can locate their data and stay there.
> Less head movement, less wasted time.
> 
> That is the argument for what it is worth. Real life is of course vastly
> more complex than
> this and we are swimming in very muddy waters, which is why there is so
> much
> argument on the subject (raid salesmen - spit).
> 
> Thanks for the vent
> 
> Garry Gillies

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

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

RE: faq broke?

[Luis deUrioste]

Seems to be Broke 

-Original Message-
Sent: Thursday, July 17, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L


Is it just me, or . . .

I have not been able to search the faq archives all
week (www.orfaq.net).

When I find a match and try to open it, I get a
message "Our apologies.  The page you are looking for
might have been removed, had its name changed, or is
temporarily unavailable"

Is it just me, or are others having problems?

Barb


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Metalink

[Luis deUrioste]

I think they don't like you, 
Metalink is UP and well. :(
 

  -Original 
  Message-From: Shannon St. Dennis 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle Metalink
  please tell me metalink is down and that they haven't 
  revoked my membership!
   
  Shannon St. DennisDatabase AdministratorCity of Regina(306) 
  777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] 
   
  The degree of normality in a database is inversely proportional to that 
  of its DBA

RE: optimizer parameters in Oracle 9.2

[Luis deUrioste]

10.000

 

Supposetly is the new version of the DB 9i, 10G ..

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L


For the ignorant, what is 10G?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



> -Original Message-
> From: Tim Gorman [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, July 30, 2003 12:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: optimizer parameters in Oracle 9.2
> 
> 
> Please be aware that the paper and presentation were written 
> in the 8i timeframe.  I swear I'll get it updated for 9i, but 
> already 10G is looming and it's summer and the weather is 
> nice...
> 
> 
> 
> on 7/30/03 8:24 AM, Gurelei at [EMAIL PROTECTED] wrote:
> 
> > Rich,
> > 
> > thanks a lot. I just finished reading Tim's paper and
> > it is truly enjoyable reading. I'm going to test his
> > advices in a few moments.
> > 
> > Gene
> > --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> >> Paging Mr. GormanMr. Tim Gorman...
> >> 
> >> I had wonderful luck with Tim's paper "The Search
> >> for Intelligent Life in
> >> the Cost-Based Optimizer" from: http://www.evdbt.com/papers.htm
> >> 
> >> Enjoy!  (And thanks again, Tim!)
> >> 
> >> Rich
> >> 
> >> Rich Jesse   System/Database
> >> Administrator
> >> [EMAIL PROTECTED]  Quad/Tech Inc,
> >> Sussex, WI USA
> >> 
> >> 
> >>> -Original Message-
> >>> From: Gurelei [mailto:[EMAIL PROTECTED]
> >>> Sent: Wednesday, July 30, 2003 9:04 AM
> >>> To: Multiple recipients of list ORACLE-L
> >>> Subject: optimizer parameters in Oracle 9.2
> >>> 
> >>> 
> >>> Hi all:
> >>> 
> >>> I have been reading on the optimizer_ parameters
> >> for
> >>> Oracle 9i - optimizer_max_permutation, optimizer_index_caching and
> >> optimizer_index_cost_adj.
> >>> I have also been playing whith them and I can see
> >> that
> >>> they affect the explain plans for some queries
> >> quite
> >>> dramatically. Is there any guidelines for what
> >> they
> >>> should be set to for optimum performance (some
> >> kind of
> >>> range and may be relationship between the values)
> >> or
> >>> is this mostly a trial and error kind of thing? I
> >> have
> >>> seen a few discussion on the Oracle Metalink, but
> >>> mostly they are very specific  - try this value or
> >> try
> >>> that value. Does anyone have a link to a document
> >> with
> >>> something more systematic than that?
> >>> 
> >>> 
> >>> thank you
> >>> 
> >>> Gene
> >> --
> >> Please see the official ORACLE-L FAQ:
> >> http://www.orafaq.net
> >> -- 
> >> Author: Jesse, Rich
> >>   INET: [EMAIL PROTECTED]
> >> 
> >> Fat City Network Services-- 858-538-5051
> >> http://www.fatcity.com
> >> San Diego, California-- Mailing list and web
> >> hosting services
> >> 
> > 
> -
> >> To REMOVE yourself from this mailing list, send an
> >> E-Mail message
> >> to: [EMAIL PROTECTED] (note EXACT spelling of
> >> 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB
> >> ORACLE-L
> >> (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! SiteBuilder - Free, easy-to-use web site design software 
> > http://sitebuilder.yahoo.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> 

RE: Oracle 9i and connect as sys

[Luis deUrioste]

It's the new way, the INN thing.



-Original Message-
Sent: Saturday, August 16, 2003 10:29 PM
To: Multiple recipients of list ORACLE-L



I have created my first 9i database on OS/390 v2.10.

On my Oracle 8i instance, I can connect to the database 
using: 

sys/[EMAIL PROTECTED]

HOWEVER, In Oracle 9i, I cannot do this. I am FORCED

to connect using:
sys/[EMAIL PROTECTED] as sysdba

I was wondering if this was a new 9i "feature"
or if it was configurable? Or just a weird thing
because of the mainframe environment.

Comments please.

Thanks in Advance
- Babette
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Babette Turner-Underwood
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

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

Urgent! Is it safe to aply patch Windows2000-KB823980?

[Luis deUrioste]

Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database?
We are running 9i  9.0.1.1.1 on an Windows 2000 advanced server and our network group 
is patching all the systems. Is there anything that I need to watch for?
We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be 
aware here?
Any information is very welcomed.
TIA
Luis Octavio de Urioste
Systems Analyst
PH. (850) 454.2943
e-mail: [EMAIL PROTECTED]
Vertex Aerospace LLC



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

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

RE: Urgent! Is it safe to aply patch Windows2000-KB823980?

[Luis deUrioste]

Thanks for your response.

-Original Message-
Sent: Tuesday, August 19, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database?
We are running 9i  9.0.1.1.1 on an Windows 2000 advanced server and our network group 
is patching all the systems. Is there anything that I need to watch for?
We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be 
aware here?
Any information is very welcomed.
TIA
Luis Octavio de Urioste
Systems Analyst
PH. (850) 454.2943
e-mail: [EMAIL PROTECTED]
Vertex Aerospace LLC



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Forms - as sysdba

[Luis deUrioste]

Title: RE: Forms - as sysdba



What 
about granting sysdba priviledge to yourself? then you could do everything sys 
could do!
 
my 
0.02
 
Luis

  -Original Message-From: Suhen Pather 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 6:19 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Forms - as sysdba
  One thing to bear in mind for forms development 
  is Oracle does not support connecting as "/" (OPS$). 
  
  Suhen 
  -Original Message- From: Jared 
  Still [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, 22 August 2003 1:02 AM To: Multiple recipients of list ORACLE-L Subject: Re: Forms - as sysdba 
  As this is Forms 6i, which was around long before 
  "connect '/ as sysdba'" was required, Forms 
  does not know about the new syntax. 
  Try checking on MetaLink for a patch. 
  Jared 
  On Thu, 2003-08-21 at 01:54, Robo wrote: > Hi all, > I have a 9.2.0.3 DB and I 
  need to connect to Forms 6i as user sys. There > 
  are 3 boxes for username, password and database. > 
  I tried a lot of combinations, eg: > Username: sys 
  as sysdba > Password: sys > Database: db > sys/[EMAIL PROTECTED] as 
  sysdba > sys/[EMAIL PROTECTED] /as sysdba > sys/[EMAIL PROTECTED] 'as sysdba' > sys/[EMAIL PROTECTED] 
  '/as sysdba' > But I always get an error message - 
  either invalid username/password or > TNS error 
  (can't recognize the connect string). > I have also 
  tried it from command line but didn't succeed. > 
  > Does anyone know if/how is it possible? 
  > > Thanks a lot 
  > Robert Pipich > 
  > 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- Author: Jared Still   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (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: Results of OCS mailing list survey

[Luis deUrioste]

I think that is not apathy or des-interest in such a list. I think that OCS has not 
hit the "main stream" yet, or maybe there are listers that don't know much about and 
would like to learn from the posts more.  Some of us use this lists as a learning and 
discovery tool.

Don't get discourage.

Luis

-Original Message-
Sent: Thursday, August 28, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L


Hi folks --

Response to my survey was dismal at best.  Am I on that many kill lists? ;-)  Anyhow, 
here are the counts:

For: 3
Against: 1

Even though the response was 3:1 "for" the list, four people will not be able to carry 
a mailing list, so I will not be adding one at this time.  Perhaps as OCS matures, 
there will be more demand.

thanks,
bruce

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Luis deUrioste
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: cleaning up oracle homes on NT

[Luis DeUrioste]

To avoid this problem on cleaning Registry what I do know (after painful
rebuilds of machines) is before I install any new Oracle Software, I export
(Backup) the oracle key from the registry and save it with a proper description
i.e.. Reg_before_9iAS, then I proceed to do the installs etc. etc.
If anything goes wrong then I delete the software and restore the registry from
the backup. I'm back to where I started.


Tavo

"Boivin, Patrice J" wrote:

> Andrea asked about removing NT services.
>
> What about Oracle homes?  The Oracle Universal Installer appears to be doing
> a poor job of cleaning those up when we de-install Oracle software.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO  | Région des Maritimes, MPO
>
> E-Mail: [EMAIL PROTECTED] 
>
> --
> 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).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: !! *Very* important Oracle-L message !!

[Luis DeUrioste]

Hope I'm not too late,
Im in $20 to start and a monthly fee if needed.

[EMAIL PROTECTED] wrote:

> Ok, now that I have your attention, please read the following message from
> Bruce Bergman,
> owner of fatcity.com.  It concerns the future of this list.
>
> Please read the entire message before replying.
>
> Thank you.
>
> Jared Still  ( List Owner )
>
> ---
>
> Hello ORACLE-L list members --
>
> I would like to take a few minutes of your time for a "State of the Union"
> address, if you can call it that.  This is a rather serious message, and I
> request that you take the time to read this message entirely.  I've got a
> problem that needs resolution this week, and I'm hoping you folks can help
> me come to a conclusion.  This message turned out to be fairly
> long-winded, so please excuse me for that. :-)
>
> Fat City (fatcity.com) is my company, and I am the provider of the list
> services that you receive ORACLE-L through.  I've been hosting Internet
> mailing lists for over 10 years, and carry quite a few lists, including a
> big selection of Oracle-related lists (14, in fact).  Fat City has always
> been a labor of love for me.  Over the years it has rarely generated any
> income at all, and it usually does not cover my expenses -- most of the
> time
> it is a monthly loss for me.  The vast majority of my 60+ mailing lists
> have
> been hosted for free, at my expense (as is the ORACLE-L list, for example).
> Yet I have absorbed these costs because I enjoy hosting discussion lists
> and I know a lot of lists can't afford to pay for quality service.
>
> I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
> gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
> another provider of high-speed Internet in order to continue operations.  I
> am at the point of either folding shop completely and going out of business
> myself, or trying to make Fat City a viable, money-making endeavor.  I need
> to make this decision by this Friday (for financial and planning reasons).
> After Friday, I am committed one way or the other.
>
> My upstream ISP and I are on very good terms, and in fact, I've been a
> customer of theirs since 1985!  As a result, they have graciously offered
> to help me out of this situation at considerable expense to themselves.
> I'm not at liberty to discuss the terms of the contract I would engage in
> with them, but suffice to say that is one of those once-in-a-lifetime
> opportunities that I'd be a fool to pass up.  I have this offer personally
> from the President of that company, if I want it.  Simply said, my ability
> to take them up on their offer and switch Fat City over to a dedicated T1
> or
> better solution revolves around being able to generate quite a bit of
> additional
> income per month, and very soon.  In an effort to be open and up-front with
> you folks about this, I basically need to generate an additional $500 more
> per
> month. Right now that seems daunting, but I've been working hard to line up
> that
> additional income, and I believe I can do it.  Just not right away.  My
> estimates are that it will take me four or five months to come up to that
> level.  I need to get out there and sell website hosting and list hosting
> packages, and get new customers.  That takes time, unfortunately.  I need a
> buffer to enable me to get past this startup phase.
>
> After some discussions with Jared (the list owner), and some encouragement
> from him, I am coming to you to ask for you help in keeping Fat City
> financially afloat until I can be self sufficient.  I'm not asking for a
> specific dollar amount from anyone, nor am I *expecting* anything from you
> folks.  But if it is within your power to contribute some money towards
> this
> end (and yes, I know these are hard financial times for everyone), I am
> hoping you can help.  If I can get sufficient promise of funds that will
> see
> me through the next few months, I am willing to jump in with both feet and
> make Fat City a viable business.  If it looks like the contributions are
> not
> sufficient to enable me to do that, I will cease operations within the next
> 45-60 days.
>
> Let me be clear about a few things: If I *do* cease operations, I will give
> all of my lists time to find new list providers, and will make every effort
> to aid the shift over to the new provider, provide list dumps, archives,
> mail forwarding, etc.  Even though Rhythms goes out of business on
> 10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
> this to happen.  So don't worry about having to rush into your conversion
> if
> things don't work out.  I would also like to clearly state that this is not
> some attempt to blackmail or coerce anyone into coming up with money.  This
> will either succeed or fail based on what you folks can comfortably and
> willingly contribute.  If I had the ability to cover this startup period
> myself,
>

Re: SQL DISTINCT alternate

[Luis DeUrioste]

What about using UNIQUE

Select UNIQUE.

Seema Singh wrote:

> Hi
> In a sql stmt what will be the impact if we used DISTINCT clause and how we
> can overcomes on the performance bottleneck caused by DISTINCT.
> like ... SELECT DISTINCT A,B,C FROM TAB_1
> I want to get same output without using distinct?Is this possible?If, YES
> then how?
> Thanks in advance
> -Seema
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

How do I configure DBA*Studio to run on the Web through a browser?

[Luis DeUrioste]

> Following Fridays thread, where would I find the docs to configue the
> Apache server to run OEM / DBA*Studio on the Web?

TIA

Tavo



begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Anyone else get spammed by OraKnowledge.com???

[Luis DeUrioste]

yes,
I hate the ^%##()&(

"Grabowy, Chris" wrote:

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, 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).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: OT: Keeping up w/list Email

[Luis DeUrioste]

I set up a bunch of filters in netscape mail, and created a folder for each
list (Designer, Developer, Java, DBA ) and
a sub folder for each list where I would keep the stuff that I think I will
need.  Inside the folder I sort the mail by subject, so if I'm away for a
couple of days I can just skim through the headers and delete chunks at a
time.

my way

Tavo

Casey Dyke wrote:

> Not sure how others handle getting behind on mail, but work lately
> leaves me precious little time to keep up.  Just spent the better part
> of a month clawing back through 6000 odd messages that queued up after a
> period  away from the list.
>
> My curiosity lies w/how others handle the situation.  I've always been
> reluctant to can the folder contents, as there's always gems hidden in
> there somewhere.  Now I'm totally caught up and it's a bloody big
> relief.  Gems were there too.  :-)
>
> Anyone find themselves in the same boat from time to time or do you just
> click, shift+left mouse and delete em' all?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Casey Dyke
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Anybody running 9iAS using Microsoft's IIS

[Luis DeUrioste]

Fellow LISTERS,

Is anybody running 9iAS on MicroSoft's IIS ?
Damagement has reservations on using Apache since it is Open Source. I guess
they fear hack attacks.
Any information will be highly appreciated.

TIA

Tavo


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Oracle Internet Structure

[Luis DeUrioste]

Dave,
I would strongly suggest you get the WEB APPLICATIONS 101 book, by Sten Vesterli
, It will bring you up to speed pretty quick. It is very easy to read.

Luis.

Dave Leach wrote:

> Hi,
>
> I realize I'm way behind on this but can anyone point me to any links which
> describe the components that make up Oracle's Application Server in a novice
> way.  The sort of things I'm looking for are
>
> In simple terms what is an Apps server?
> What is an Apache Server and how does this integrate with the Apps server?
> What is the difference between a Web site and Portal?
> What third party technologies are used with Oracle Apps server?.
>
> I have looked on OTN but cannot find something which describes the structure
> at the level required (ie. a complete novice)
>
> As I say I'm a complete novice in this area but our company is just starting
> to look at a web based solution and I want to get an understanding of what's
> involved and how this may effect me as a DBA.
>
> Any help would be appreciated.
>
> Dave Leach
>
> **
> The above information is confidential to the addressee and may be
> privileged.  Unauthorised access and use is prohibited.
>
> Internet communications are not secure and therefore this Company does
> not accept legal responsibility for the contents of this message.
>
> If you are not the intended recipient, any disclosure, copying,
> distribution or any action taken or omitted to be taken in reliance on
> it, is prohibited and may be unlawful.
>
> Claybrook Computing Limited is a subsidiary of
> Claybrook Computing (Holdings) Limited
> Registered Office: Abbey House. 282 Farnborough Road, Farnborough,
> Hampshire GU14 7NJ
> Registered in England and Wales No 1287205
>
> A Hogg Robinson plc company
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dave Leach
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Linux Download and ADSL

[Luis DeUrioste]

What about Cable Modems ? any such service?

Mark Leith wrote:

> LOL me too!! We have tried to get ADSL in our area - Worcester, UK - and
> have been told by BT that they have "No plans" to install it in our
> exchange! Now, Worcester is a City, and I've heard of cases around the
> country where smaller TOWNS can get hold of ADSL!!!
>
> I'm not even going to consider ISDN..
>
> Just a case of sit back and wait, and tweak my Diamond 56k as much as I
> can..
>
> -Original Message-
> John (NESL-IT)
> Sent: Tuesday, July 17, 2001 05:24
> To: Multiple recipients of list ORACLE-L
>
> My ARSE :o)
>
> -Original Message-
> Sent: 17 July 2001 15:57
> To: Multiple recipients of list ORACLE-L
>
> UK telecomms is in a hell of state.
> For most of us the best option is a fast connection at work and a CD writer.
>
> Cheers,
> Mike
>
> --
> 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).
> 
> 
> E mail Disclaimer
>
> You agree that you have read and understood this disclaimer and you agree to
> be bound by its terms.
>
> The information contained in this e-mail and any files transmitted with
> it (if any) are confidential and intended for the addressee only.  If you
> have
> received this e-mail in error please notify the originator or telephone
> 0191 210 2060 or e-mail [EMAIL PROTECTED]
>
> This e-mail and any attachments have been scanned for certain
> viruses prior to sending but neither Northern Electric plc nor any of the
> companies in the Northern Electric group of companies from whom this e-mail
> originates shall be liable for any losses as a result of any viruses being
> passed on.
>
> No warranty of any kind is given in respect of any information contained in
> this e-mail and you should be aware that that it might be incomplete, out of
> date or incorrect. It is therefore essential that you verify all such
> information with us before placing any reliance upon it.
>
> Northern Electric plc
> Carliol House
> Market Street
> Newcastle-upon-Tyne
> NE1 6NE
> Registered in England and Wales: Number 2366942
>
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Garner, John (NESL-IT)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Microsoft IIS

[Luis DeUrioste]

Thanks that was me, since then they decided that Apache was just fine.


Tavo

[EMAIL PROTECTED] wrote:

> Someone, I don't remember who, posted a question a week of so ago about
> connecting to Oracle IAS via IIS instead of the provided Apache server because
> there damagement was afraid about being hacked.  Well, pass the following along
> to damagement & ask them again what they want to do:
>
> ** Internet Goes Red
>
> The "Code Red" worm ripped through Internet servers like no other
> previously unleashed piece of malicious code. "We are witnessing
> Internet history," says Chris Rouland, director of Internet
> Security Systems X-Force, which tracks Internet vulnerabilities.
> Based on reports, Code Red has infected over 225,000 servers.
>
> The worm enters the targeted server through port 80. If the host
> is running Microsoft IIS, the worm executes a malformed HTTP
> "get" request to try to run a buffer overflow against the
> Microsoft IIS Indexing Service dynamic-link library. Once the
> worm successfully exploits the target, it starts searching for
> new servers to infect, and the compromised Web site is defaced.
>
> Code Red's ultimate target was Whithouse.gov. The worm was set to
> attack the White House Web site July 20 by unleashing a torrent
> of traffic at the site. According to Rouland, the White House
> managed to avoid the attack by switching the site's IP address.
> He says the author of Code Red made a critical design flaw by
> hard-coding the White House's IP address. "That won't happen next
> time," he warns.
>
> When the ILoveYou virus struck last year, many copycats struck in
> the following weeks. "I wouldn't be surprised to see many, many
> copy cats of this worm," he says. In fact, reports started
> surfacing Friday afternoon on security mailing list Bugtraq that
> several versions may already be loose.
>
> An explanation of, and patch for, the IIS buffer overflow
> vulnerability is available at
> http://update.informationweek.com/cgi-bin4/flo?y=eD2T0BdFGA0V20QKW0AK
>
> Has this one bit you? Tell other IT folks what you're doing to
> combat the problem in the Listening Post
> http://update.informationweek.com/cgi-bin4/flo?y=eD2T0BdFGA0V20Nmm0AD
> --
> 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).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

....A drop schema script ??

[Luis DeUrioste]

All mighty and powerful DBA supremes !

Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated

T I A



begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: ....A drop schema script ??

[Luis DeUrioste]

uhhh DUHHH !

I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
BRAIN ..

Thank you to all of you, and special thanks for not bashing me

Luis Octavio

Luis DeUrioste wrote:

> All mighty and powerful DBA supremes !
>
> Do any of you have a drop schema script that would be willing to share
> ??
> It'll be greatly appreciated
>
> T I A


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: OT - Books Covering Partitioning in 8i

[Luis DeUrioste]

What about Ian  Abramson 's book on DATA WAREHOUSING ? I have not read it from
cover to cover ( in scheduled readings)  but from what I've seen I think is what
you want.


Luis Octavio

[EMAIL PROTECTED] wrote:

> Listers,
>
> I might end up on a Data Warehouse and Data Mart project using 8i. I've read
> various white papers, Oracle doc's, etc on partitioning capabilities of
> 8/8i. And I've dinked around on my test machine a bit trying things out. Are
> there any books out there that you would recommend for digging deeper into
> the partitioning subject? I have some prior experience in the DW/DM arena on
> *V7*, but, a book going into real detail on partitioning in 8i, what works
> well when, what doesn't, gotcha's to look out for, etc would be helpful.
>
> I've already been planning on getting Jonathan Lewis's "Practical Oracle
> 8i". And I heard and/or read that it does a good job of covering
> partitioning. I've also accumulated a list of recommendations for Oracle
> specific DW books, though I don't have any of them yet. I already own, and
> have read, an assortment of Inmon and Kimball books on DW.
>
> Thanks,
>
> Larry G. Elkins
> [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).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: ....A drop schema script ??

[Luis DeUrioste]

Thank you Jared for the words of encouragement and specially for the "SCRIPT"

Luis Octavio

Jared Still wrote:

> Luis,
>
> Don't feel bad, this is a valid question.
>
> DROP USER CASCADE is not always the most efficient way to
> drop a user, especially a user with a large number of objects.
>
> I've had that command fail a number of times, and had to rerun
> it until I decided there must be a better way.
>
> DROP USER CASCADE can generate a *lot* of recursive SQL,
> and therefore can take a very long time.  It also eats up system
> resources at a prodigious rate.
>
> I've found that when dropping a schema owner, it's much easier
> to drop their objects individually, then drop the user.
>
> e.g.
>
> spool '_dropscott.sql'
>
> select 'drop ' || object_type || ' scott.' || object_name ||
> decode(object_type, 'TABLE', ' cascade constraints;',';')
> from dba_objects
> where object_type in ('TABLE','PACKAGE','PROCEDURE','FUNCTION')
> and owner = 'SCOTT';
>
> spool off
> @_dropscott.sql
> drop user scott cascade;
>
> I still include the 'cascade' on drop user to pick up any objects not
> included in the above list.
>
> Works for me, YMMV.
>
> Jared
>
> On Thursday 17 May 2001 13:25, Luis DeUrioste wrote:
> > uhhh DUHHH !
> >
> > I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
> > BRAIN ..
> >
> > Thank you to all of you, and special thanks for not bashing me
> >
> > Luis Octavio
> >
> > Luis DeUrioste wrote:
> > > All mighty and powerful DBA supremes !
> > >
> > > Do any of you have a drop schema script that would be willing to share
> > > ??
> > > It'll be greatly appreciated
> > >
> > > T I A
>
> 
> Content-Type: text/x-vcard; charset="us-ascii"; name="Luis_deUrioste.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Luis Octavio de Urioste
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Developer, C/C++, Java lists

[Luis DeUrioste]

The developer list is ODTUG-DEV2K-L and it is hosted by fatcity also, there
is also a WEBDEV list and a Java list and if my memory doesn't fail me
there is also a PRO*C list.

\"Umesh Chander Sharma\" wrote:

> Hi Gurus,
>
> Any idea about lists existing like this one for other areas like Oracle
> Developer, C/C++/Pro*C and Java etc.
>
> TIA,
>
> Umesh
>
> ---
>
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
>
> We reserve the right to monitor all e-mail communications through
> our network.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: \"Umesh Chander 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).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Oracle Development Tool

[Luis DeUrioste]

Hi Deepak,

This is a good one, we use SQL* NAVIGATOR and TOAD, 2 cents are that on the
developer side SQL*Navigator would be a more complete tool, specially if you
buy all the bells and whistles available (SQL formatter, Knowledge Base
...), and TOAD would be a better tool on the DBA side of the House.  Yes
a lot of the functionality is very similar, but the bottom line is that they
are two different tools and depends on how you are going to use them.  I
suggest you download a trial version and call Quest for a technical
walkthrough on both of the tools (Engineer on the phone very good and free)
then you can make your final decision based on your own experience.  Before
calling for the walkthrough I would prepare a list of the tasks that you
would like to perform or expect to perform in a routine manner and compare
the tools based on that list.


Luis

"Suri, Deepak" wrote:

> I have a feeling that this is not the most appropriate list for this
> question, but then I swear by the postings of folks on this list, which
> means I value their opinions very much, so here goes ...
>
> Our organization is evaluating several tools to help us with our Oracle
> application development (excluding that done using Developer/2000). The
> front runners are TOAD and SQL Navigator both sold by Quest Software. The
> prices are comparable, the functionality is similar, support is the same,
> integration with PVCS is available etc.
>
> Would any of you gurus out there care to comment on which one and why one
> tool might be better than the other ?
>
> thanx !
> deepak
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suri, Deepak
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: MS access

[Luis DeUrioste]

Migrate to ORACLE !
< sorry could not resist t>
"Li, Xiangli" wrote:
 
Hi, List
Is there anyone happen to know what's
the database size limitation for MS access97? I heard it's 1 gigabytes,
how to overcome it if that's true?
thanks
Li


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: 16 bit sqlplus cannot connect to PO8i

[Luis DeUrioste]

Rahul,
It seems to me that you are having a problem reading the proper TNSNAMES.ORA for
the different DBs.  What I would do in your situation is to search for all
TNSNAMES.ORA files in your PC, since you have products installed in more than
one home and more than one version you should have multiple.  Edit them and see
which ones contain the entries that you need, in one or more of them some
entries will be missing, what you can do is copy/paste the missing entries, once
you have the file you want then copy it to all the different "Homes" and you
should be able to connect to the different DB's.

Hope it helps.

Luis Octavio

Rahul wrote:

> Jkstill,
> i'm using sql*net 2, and can connect to other 8i database
> on the AIX machine, but then i installed PO 805 (in another home) , and
> cannot use the sqlplus to connect to the local DB. (the sqlplus installed
> under
> the same home as the database can connect without problems)
>
> Regards
>
> PS: infact i did mention the platform and oracle version in my earlier mail
> also.
>
> > --
> > From: Jared Still[SMTP:[EMAIL PROTECTED]]
> > Reply To: [EMAIL PROTECTED]
> > Sent: Tuesday, May 29, 2001 1:20 AM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Re: 16 bit sqlplus cannot connect to PO8i
> >
> > On Monday 28 May 2001 11:00, Kimberly Smith wrote:
> > > Hey Jraed,
> > > Why did you change your name?  Sorry, I am bored.  Management decided to
> > > move us around so I am unpacking.
> >
> > I should change it, as I find Jread much easier to type than Jared.
> >
> > Jraed
> >
> > >
> > > -Original Message-
> > > Sent: Monday, May 28, 2001 10:20 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > If by "16 bit sqlplus" you mean version 1 of SqlNet, you
> > > can't connect to an 8i database with it.
> > >
> > > Some version numbers here would help.
> > >
> > > platform:
> > > version of platform:
> > > version of Oracle:
> > > etc...
> > >
> > > Jraed
> > >
> > > On Monday 28 May 2001 00:40, Rahul wrote:
> > > > List,
> > > > i'm trying to make a connect to 8i database (installed under orawin95)
> > > > from a 16 bit sqlplus (installed under orawin)
> > > >
> > > > i tried to configure the IPC in listener, the sqlplus in orawin95 is
> > able
> > > > to connect,
> > > > but the 16 bit sqlplus returns error...(cant get server error
> > > > message)
> > > >
> > > > +-+-+-++-- LISTENER.ORA
> > > >
> > > > LISTENER =
> > > >   (ADDRESS_LIST =
> > > > (ADDRESS=
> > > >   (PROTOCOL= IPC)
> > > >   (KEY= oracle.world)
> > > > )
> > > > (ADDRESS=
> > > >   (PROTOCOL= IPC)
> > > >   (KEY= ORCL)
> > > > )
> > > >   )
> > > > +-+-+-++-- TNSNAMES.ORA
> > > > local.world =
> > > >   (DESCRIPTION =
> > > > (ADDRESS_LIST =
> > > > (ADDRESS =
> > > >   (PROTOCOL = BEQ)
> > > >   (PROGRAM = oracle80)
> > > >   (ARGV0 = oracle80ORCL)
> > > >   (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
> > > > )
> > > > )
> > > > (CONNECT_DATA = (SID = ORCL)
> > > > )
> > > >   )
> > > >
> > > > this is win95 and PO805
> > > >
> > > > TIA
> > > >
> > > > Regards
> > > > Rahul
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octav

Re: multiple versions of SQLPlus.exe

[Luis DeUrioste]

Dave,

It seems to me that you are having a problem reading the proper TNSNAMES.ORA for

the different DBs.  What I would do in your situation is to search for all
TNSNAMES.ORA files in your PC, since you have products installed in more than
one home and more than one version you should have multiple.  Edit them and see
which ones contain the entries that you need, in one or more of them some
entries will be missing, what you can do is copy/paste the missing entries, once

you have the file you want then copy it to all the different "Homes" and you
should be able to connect to the different DB's.

Hope it helps.

Luis Octavio

"Farnsworth, Dave" wrote:

> I have a server NT4.0, SP5 that has two versions of Oracle installed.  On
> drive J is Oracle 8.0.5 which is used by a third party app and has been up
> and running for about a year.  This last week I installed on drive E Oracle
> 8i 8.1.7 and have not yet created a database.  This Saturday on of the
> operations people re-booted this server.  That night the app using 8.0.5 had
> an error.  From what I can tell the following happened to cause the app to
> fail.
> When the server was re-booted, it reset the PATH setting in the environment
> in the win.ini file to point oracle to the 8.1.7 version.
>
> PATH=E:\ORA817\bin;E:\ORA817\Apache\Perl\5.00503\bin\mswin32-x86;
> E:\ORA817\Oracle\jre\1.1.7\bin;E:\ORANT\bin;c:\DMI\win32\bin;
> C:\WINNT\system32;C:\WINNT;E:\COBOL32\EXEDLL;E:\orawin\bin;
> j:\merant\net express\base\bin;e:\cobol32\exedll
>
> The app then tried to execute a batch file that calls sqlplus.exe.  This is
> where the error occurs and the app sits at a sceen wanting a login name and
> password for sqlplus.  Below is the batch file.
>
> J:
> cd \logility\Ora_sql
> set oracle_sid=LV54
> SqlPlus user/pass@lv54 @Qry_Log.sql
> Notepad.exe qry_log.txt
> ::Qry_log_show.bat
>
> I get this error when the batch file is executed, "ora-12154  TNS: Could not
> resolve service name".  I assume that because the path is now set to point
> at 8.1.7 that sqlplus is now looking at the 8.1.7 tnsnames.ora which
> currently has no entries for databases.  If I edit the PATH setting and put
> a reference to the 8.0.5 version on J drive, then it works fine but now I
> get the 8.0.5 sqlplus when I try go to e drive and type sqlplus at the
> command prompt.
> Can I have multiple versions of sqlplus that can be called from the command
> prompt on the same box?  Can I have multiple versions of tnsnames.ora?
> Would I need to include all the database names for each version in every
> tnsnames.ora file?
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: OEM Book Recommendation

[Luis DeUrioste]

The only book that I've found that touches the OEM in an ok way is ORACLE8 on
Windows NT by Lilian Hobbs ISBN 1-8-190-0




begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: Windows ME and Net8

[Luis DeUrioste]

I would try using the WIN2K Client CD.

Good Luck

April Wells wrote:

> We have several clients, mostly running NT or 98, and we have been able to
> get Net8 to install fine.  Using the same CD, we cannot get it to install on
> Windows ME.  I have been trying to get an answer as to support from
> Metalink, but so far have been unable to get an answer.  Does anyone have
> any experience one way or another?
>
> Thank You
> April Wells
>
> -Original Message-
> Sent: Monday, June 04, 2001 1:24 PM
> To: April Wells
>
>
> April,
>
> Here is the error message that I received when attempting to install Oracle
> 8.1.6's Net on Windows ME.
>
> "there was an problem in accessing the staging area. Please make sure the
> specified values for 'Source' and 'DESTINATION' are valid".
>
> The information contained in this e-mail is strictly confidential and for the 
>intended use of the addressee only; it may also be legally privileged and/or price 
>sensitive.  Notice is hereby given that any disclosure, use or copying of the 
>information by anyone other than the intended recipient is prohibited and may be 
>illegal.  If you have received this message in error, please notify the sender 
>immediately by return e-mail.
>
> Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
>attachment to this e-mail has been swept for viruses.  We accept no liability for any 
>damage sustained as a result of software viruses and advise you carry out your own 
>virus checks before opening any attachment.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: April Wells
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: iAS installation update

[Luis DeUrioste]

Patrice,
I've installed 9iAS successfully, what I've done is just run the installer from
the CD and on a new machine (virgin OS install) I selected all the defaults, and
guess what everything work.  In turn 9iAS created an ORACLE home in which there
is a 806 and an iSuites directory, apparently when they say the 806 home what
they refer to is that directory, the 806 directory seems to be where the tool
set (Forms/ Reports) are housed and the iSuites where the Apache server and that
stuff is.

On a machine with a whole bunch of other ORACLE products, such as DEV 1.6 (FORMS
4.5 / Reports2.5), Designer 2000, Developer 6i and Personal Oracle 8.1.7, I've
chosen a different home for each product and everything works fine. Of course a
bunch of stuff is duplicated, but who cares Hard drive is cheap, the main thing
is that everything works as advertised. When I tried installing everything on
default Oracle homes nothing worked and it was a nightmare.

My experience from the installs.

Good luck

Tavo

"Boivin, Patrice J" wrote:

> FYI,
>
> I logged a TAR with Oracle last week or so because one Metalink tech had
> said in passing that Forms and Reports had to go into its own, separate
> oracle_home.  This follows from a previous TAR I had logged with them,
> simply asking which products work best together.
>
> I had read the installation manual for iAS and had earlier found this:
>
> Note: Be sure not to install Oracle9i Application Server in an Oracle_home
> containing other Oracle products, including the database.  Such an
> installation could overwrite shared components, causing the products to
> malfunction.  (on p. 3-5, 4-5, 5-5).
>
> Now, in Oracle Reports Developer Getting Started - Release 6i for Windows,
> it says:
>
> Reports Developer 6i must reside in the default oracle_home.
> Reports Developer 6i and the Oracle8 or Oracle8i server must reside in
> separate oracle_Homes, although they can reside on the same physical
> machine.
> Similarly, in a web application deployment, Report Server and Oracle
> Application Server must reside in separate oracle_homes, although they can
> reside on the same physical machine. (p.1-16)
>
> Forms and Reports 6i happen to require an Oracle 8.0.6. oracle_home.
>
> This posed a dilemma:  how can I install iAS in the default home, when many
> of its components require access to an "origin" database.  I do not plan to
> use iAS with 8.0.6., I plan to use it with 8.1.7..
>
> I thought I would have to install Forms and Reports 6i first, remove the
> tidbits that the Oracle Universal Installer installs by default, then
> install 8.1.7., and then install the iSuite components.  Of course by the
> end of this tortuous process there were errors.
>
> I had a different Metalink technician this time, who told me to ignore what
> the first technician had said, and to just install iAS based on the
> installation manual, never mind the other worries that I had.
>
> So, I am ignoring the Oracle Reports Developer Getting Started manual, and I
> am installing based on the iAS installation manual.
>
> Hopefully that will work.
>
> /begin rant
> I still wish the Oracle techs could have told me which versions of the
> various products are concurrent, they just keep insisting that all their
> products are certified to work together.  All I wanted to know was which
> oracle_home type do the various products use?  Forms and Reports 6i requires
> an 8.0.6. home, Developer6 used an 8.0.5 home, etc. the Metalink techs do
> not appear to have a list, they didn't understand my question.  When I
> logged a TAR on this I received three e-mails telling me that my TAR had
> been passed to different people, in the end the last tech told me that
> products sometimes are released together, but that it is not all that
> important, because everything is certified to work together.
>
> I can't shake the feeling that iAS is a bundle of things that were just
> slapped together.  Seeing the old installer pop up during the installation
> doesn't help remove that impression.  Hopefully when the next release comes
> out it will install in something other than an (old) Oracle 8.0.6.
> oracle_home.  Since it's called Oracle9i iAS, maybe the Forms and Reports
> Servers will go into a 9i oracle_home (?).
> /end rant
>
> (this is my impression, not my employer's etc. etc.)
>
> Sorry if this comes across as a little harsh.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO  | Région des Maritimes, MPO
>
> E-Mail: [EMAIL PROTECTED] 
>
> --
> 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 Int

Re: OT / LOL/ Serious Question (believe it or not)...

[Luis DeUrioste]

Well I think if we all pitch in a bit, and put out one heck of a book and
convince Steven Spielberg to take it to the screen, yes we would be rolling in
Do.
Oracle from the ground up ! a thriller, starring in order of appearance:
"The Goddess"  Rachel Carmichael
"The Tuner" --- Gaja Krishna Vaidyanatha
"Remote" --- Ari Kaplan
"Store Keeper" -- Ian Abramson
..

and others, just imagine the movie it would be wicked!

oops!
Sorry I Just lost it

Rachel Carmichael wrote:

> let's see, I think Dad paid something on the order of $10K to publish his
> book (about 100 copies). Of course, it was a hard-cover edition.
>
> and editors don't come cheap.
>
> Alex -- how much money do you really think an author makes on a book???
>
> I'd figure that the average book (and technical books have to be updated
> about every 18 months) takes about 500 hours to write (this is a number
> Kevin Loney has come up with and I'm willing to believe him, given his
> experience)
>
> So... as a consultant let's say I work cheap (in NY anyway) for $100/hr
>
> 500 hours over a 40 hour week = 12.5 weeks or about 3 months
>
> so 500*100 = $50,000  for 3 months, or $200,000 over a year
>
> THERE IS NO WAY IN HELL YOU MAKE ANYTHING LIKE THAT AS AN AUTHOR!!!
>
> Damn it, best-selling authors don't make that kind of money.
>
> Geez, wake up and smell the coffee, technical writing is NOT done to get
> rich.
>
> >From: "Hillman, Alex" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Serious Question (believe it or not)...
> >Date: Thu, 07 Jun 2001 12:11:00 -0800
> >
> >I am sure that any of working DBA's have this money to put up front. I
> >don't
> >think that risk to invest in the book is more than in the stock market.
> >Also
> >what is the problem to hire editor (especially not technical). Should not
> >be
> >too expencive. Of cource it is more work, but one can get much more money.
> >
> >Alex Hillman
> >
> >-Original Message-
> >Sent: Thursday, June 07, 2001 3:26 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >self-publishing houses charge you to publish the book (yes, they do, that's
> >how my father-in-law published his book)
> >
> >I also doubt that they give you much in the way of help in editing your
> >book, so that if your English is not good (as the case of the author that
> >Jonathan is working with) you end up with an unreadable book.
> >
> >
> > >From: "Hillman, Alex" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: Serious Question (believe it or not)...
> > >Date: Thu, 07 Jun 2001 07:45:49 -0800
> > >
> > >I would one of self-publishing houses like Technion where you can get 33%
> > >of
> > >sales.
> > >If your book is any good it will sell in the same volume as with any
> >other
> > >publisher (not that they spend a lot of money for promotion any way).
> > >
> > >Alex Hillman
> > >
> > >-Original Message-
> > >Sent: Thursday, June 07, 2001 4:31 AM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >First would be to prepare and send a synopsis to the
> > >'big name' oracle publishers - O'Reilly, Wrox and the
> > >like..
> > >
> > >hth
> > >connor
> > >
> > >--- Jim Hawkins <[EMAIL PROTECTED]> wrote: > All,
> > > >
> > > > I am very interested in collaborating with others in
> > > > the writing of an
> > > > Oracle technical book (DBA subject matter).  I am
> > > > interested in how those of
> > > > you who have done this (ala Rachel), got started or
> > > > made the right
> > > > connections.  I do have a somewhat literary
> > > > background, so I know I can do
> > > > this.
> > > >
> > > > Jim
> > > >
> > > > Jim Hawkins
> > > > Lead SAPR/3 Oracle Database Administrator
> > > > MEMC Electronic Materials, Inc.
> > > > 600 Pearl Drive
> > > > St. Louis, MO  633376
> > > > 9636) 474-7832
> > > > [EMAIL PROTECTED] (work)
> > > > [EMAIL PROTECTED] (home)
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Jim Hawkins
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX:
> > > > (858) 538-5051
> > > > San Diego, California-- Public Internet
> > > > access / Mailing Lists
> > > >
> > >
> > > > To REMOVE yourself from this mailing list, send an
> > > > E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > > 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB
> > > > ORACLE-L
> > > > (or the name of mailing list you want to be removed
> > > > from).  You may
> > > > also send the HELP command for other information
> > > > (like subscribing).
> > >
> > >
> > >=
> > >Connor McDonald
> > >http://www.oracledba.co.uk (mirrored at
> > >http://www.oradba.freeserve.co.uk)
> > >

Re: LOT (Little OT): Interesting Oracle related URL's.

[Luis DeUrioste]

Authors, and List,

I do agree that it is wrong to post papers without permissions etc. etc.,
but lets not be so harsh.  I come from a Third world country (BOLIVIA)
where getting up to-date Literature is almost impossible, most all
documentation that people work with is obsolete, and this people heavily
rely on papers posted somewhere.  As far as books you could forget it, the
cost of a book here is around $50.oo (101) series that is about 1/3 of
their monthly salary.  Some of the people that are benefited from this
"Piracy" are college students that one day may become the next GAJA ,
RACHEL, or KEVIN.  Lets remember that the NET's intent was to ease the
sharing of information.  Please, please lets not be to harsh on the people
that post this materials, but lets ask them to give all the credit to the
authors and if possible try to get their permission.

We are lucky to live in a Country where we can afford to pay for this
materials or to pay for conferences etc. other nations are not so lucky.

I just had to let it out.

Sorry
Regardless

Friend 4 ever

Tavo

Gaja Krishna Vaidyanatha wrote:

> Hi Steve and list,
>
> While we are on the subject, I found my RAID paper on
> multiple sites including this site :
> http://www.vampired.net/articles/php/concepts.php and
> I know for a fact that no one has gotten permission
> from me or IOUG-A, in this regard. Does this not
> mirror what is done on Marin's site?
>
> Gaja
>
> --- Steve Adams <[EMAIL PROTECTED]> wrote:
> > Hi Rachel and list,
> >
> > The person responsible for that site is Marin
> > Dimitrov [mailto:[EMAIL PROTECTED]].
> > Almost all the papers there are illegal copies
> > (including one of mine). I once
> > asked Marin to explain himself on the matter. His
> > explanation was that the
> > collection was for his personal use only. At the
> > time, he removed the index to
> > make the collection largely invisible to the rest of
> > the net, but it appears to
> > have come back! It can also be seen at
> > http://harbinger.sirma.bg/Oracle/ and an
> > older version is mirrored at
> >
> http://www.itsystems.lv/gints/files/oracle/oracle.htm.
> >
> > I have copied Marin (and the person responsible for
> > the mirror site) on this
> > mail. Hopefully they will at least remove the
> > indexes again, but I would prefer
> > the papers to disappear too. Maybe if others add
> > their votes to Rachel's and
> > mine they'll take the stuff down. Bulgaria and
> > Latvia may be immune to
> > international copyright law, but individuals are
> > seldom immune to community
> > disapprobation.
> >
> > @   Regards,
> > @   Steve Adams
> > @   http://www.ixora.com.au/
> > @   http://www.christianity.net.au/
> >
> >
> > -Original Message-
> > Sent: Friday, 8 June 2001 3:01
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I hate to be a spoilsport -- but this link (actually
> > the fact that the paper
> > is on his site) bothers me...
> >
> > "DBA101: A Refresher Course"
> > http://pillango.sirma.bg/oracle/N092_dba.doc
> >
> > Neither Marlene nor I gave permission for this paper
> > (which is copyrighted)
> > to be posted there. Of course, he is not in the US,
> > so the fact that this is
> > illegal doesn't count.
> >
> > For what it's worth:  it is only legal in the US to
> > post a link to a legal
> > copy of this sort of information. It is NOT legal to
> > post copyrighted
> > information without the express permission of the
> > copyright holder.
> >
> > Having said that, I would have gladly sent a copy of
> > the paper to anyone who
> > asked or given permission to post it. But I would
> > prefer to be ASKED.
> >
> > And Mark -- www.oracle-users.com now points you to
> > the NY user group web
> > page, as the company (Oracle User Resources) that
> > sponsored it and the ECO
> > conference, does not exist anymore.
> >
> > Rachel
> >
> >
> > >From: "Mark Leith" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > >Subject: RE: LOT (Little OT): Interesting Oracle
> > related URL's.
> > >Date: Thu, 07 Jun 2001 06:41:43 -0800
> > >
> > >Thanks for your input guys - a great help! I had a
> > few already - namely the
> > >"Guru's of the list" (That reminds me of a film
> > title in a way :) But there
> > >were a few I didn't have. Here is my list so far..
> > >
> > >IXOra.com (Steve Adam's Site)
> > >http://ixora.com.au/
> > >
> > >Oracle Technet
> > >http://technet.oracle.com
> > >
> > >OraPub (Craig Shallahamer's Website)
> > >www.orapub.com
> > >
> > >DBA Support
> > >http://www.dbasupport.com/
> > >
> > >Thomas Kyte's Website
> > >http://osi.oracle.com/~tkyte/
> > >
> > >Connor McDonald's Web Site
> > >http://www.oracledba.co.uk/
> > >
> > >Hotsos (Cary Millsap's Site)
> > >www.hotsos.com
> > >
> > >Jared Still's Website
> >
> >http://www.cybcon.com/~jkstill/util/util_master.html
> > >
> > >Thomas Cox's Website
> > >http://www.geocities.com/tbcox23/
> > >
> > >Evergreen Database Tech

isqlPlus

[Luis DeUrioste]

I'm interested in using iSQL but I can't figure out where to install it
from? 9iAS, 8i1.7, DEVELOPER 6i ?
Could somebody shed some light upon me, there are way to many CDs to go
through them all.


TIA

Tavo


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard