date:20011206

Is Las Vegas laying odds on this?  I've got a few bucks I would wager
against...

This is not just unreasonable, but insane - even assuming that
everything goes perfectly (it won't).  It is more reasonable to assume
that a horse is a perfect sphere or that the Israeli-Palestinian
problem could be solved once and for all with a coin toss.  Keep the
Uzi around for a while after the upgrades.  You may need it for
self-defense when these same damagers come scapegoat hunting.

Don't underestimate the benefit of the "remotely" part.  At least they
won't hear you swearing at them and you won't have several of them in
your cube at all times - looking over your shoulder, asking intensely
stupid questions, and constantly talking on their cell phones relaying
status reports!  Also, if you have to make a break for it, you'll have
a decent lead.

Only a few years ago, I thought that Dilbert was comic exaggeration.
I have since come to the profound realization that it is subtle
understatement.

-Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 1:50 PM

> I hear you.  Some one came up with the idea that 30+
> HPUX 10.20, Oracle 7.3.3 systems could be updated to
> HPUX 11.x, Oracle 8.1.7 in less than 36 hours, with
> only 2 dba's and 2 sysadms, remotely.
>
> I shudder to think of the psychoactive compound
> dosages that led to this conclusion.  Oh well, I've
> got spare pillows out in the truck, right next to the
> postal worker uniform and the uzi...
>
> --S
>
>
> --- [EMAIL PROTECTED] wrote:
> > Ain't being a DBA glamorous???
> >
> > Me, I'm just in it because I heard that DBA's get
> > all the chicks :)
> >
> > Believe me, I feel your pain.  I have more Oracle
> > 7.3.4 databases here to upgrade than I can say
> > without embarassment.  That's what I get for being
> > the new hire. :)
> >
> > A fellow DBA,
> > Scott Lockhart
> > Oracle DBA
> > I-Link, Ltd.
> > Draper, UT
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Shafer
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Don Granaman
  INET: [EMAIL PROTECTED]

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

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

Redo log file sizing

2001-12-06 Thread Herman Susantio


Hi all,

Can anyone share how to do proper redo log file sizing ?
Would 1G redo log file be enough for 5 TB datafile ?

and how to define howmany redo log file we need to have in one database ?


Thanks & Regards
Herman



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

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

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


How about EBU?  It is actually fairly good in 7.3.4+ and is very
straightforward to set up.  Like RMAN, It uses a database catalog, but
the command syntax is radically different - in my opinion, much more
straightforward.  It also include a shell command line utility named
ebutool that is quite useful.  I used it for years on many systems
without significant problems.

What hardware (e.g. DLT IV, etc.) and software (e.g. Veritas
NetBackup) resources do you already have?  Will the entire backup fit
on one tape?  If so, I have a set of ksh & SQL scripts that do
extensive error checking and get the file list dynamically from
v$datafile - so no "new" datafiles are overlooked.  They also do
archive log cleanup, can verify the backup by reading it off of the
tape, and some other stuff.  These scripts may or may not be
appropriate for your case.

Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 12:29 PM


> I'm not sure if I'm bragging or complaining, but I've never setup
> or supported online backups for Oracle. I'm being directed to
> implement online backups for a V7.3.4.5 instance. A search of
> OTN reveals that Oracle no longer seems to have any V7 documents
> available anymore. :-(
>
> Since this DB is stuck at V7.3.4.5 for at least 6 more months,
> I need to get online backups operational without using RMAN.
> If somebody who has *nix shell script(s) or Perl code that
> implements online backups, I'd appreciate if you would send a
> copy my way. I'm just looking for something to get me started.
>
> TIA & HAND!
>
> --
> Charlie Mengler  Maintenance Warehouse
> [EMAIL PROTECTED] 10641 Scripps Summit
Ct.
> 858-831-2229 San Diego, CA 92131

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

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

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

Apache and Oracle config help

2001-12-06 Thread Don


If somebody could lend assistance, here or offline, I would appreciate it.

The prob:  Oracle SSP5 iprocurement installed on 8.0.5 DB with Oracle Apps 
11.0.3. has problems dealing with the 6th session that trys to do a search 
in iP.  The 6th session will cause ALL connected browser sessions to get a 
"server not found" error screen.

I found that if we recuded the -mx500m in the jserv.properties file down to 
about 50, we could keep 20+ sessions running, but now the search take 
upwards of 10 minutes to search 9000 items.  Using TOP, it looks like 
Apache grabs all CPU cycles (2-cpu) and spreads the cycles across the 
searches.  This immediately takes the cpus from 80% idle to 100+% used up, 
so nobody on the box gets good response time.

In talking with the HP folks, I have learned that the Apache that comes 
with iP is OLD.  About 5 versions old.

Is it necessary to use the "oracle" version of Apache, or can we upgrade 
the the current HP version of Apache, and still run Apps and iP?

Can a single "apache" service the needs of 3 databases?  Right now, we have 
an "apache" up and running for each db on the server.

Hardware:  HP9000 L2000 2-233mHz cpu, 4G RAM 300+G disk.


Thx : [EMAIL PROTECTED]



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

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

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


I, like many others, have a problem with the "size is everything"
definition.  I worked with a 2 TB DSS system six years ago that wasn't
a real "data warehouse".  And I've seen a true datawarehouse fledgling
that was under 200 GB (with lots of free space).

However, even making the nonsense assumption, there would have to be a
time factor.  What would have been a VLDB five years ago might be
smallish today.  And a few tomorrows into the future, it might be
"It's only a petabyte, you can't call THAT a data warehouse!".  At
this exact moment, the answer is 42 (x 10 GB).  However, that answer
is now obsolete.

-Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 3:55 PM


> Informal survey: Datawarehousing.
>
> Limiting Assumption:   "A necessary and sufficient condition for
defining
> something
> to be a datawarehouse is the amount of data
> to be stored."
>
> Question/Poll:   Given the above ridiculous constraint, at/above
what size
> can something
> be considered a data warehouse?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]


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

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

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

Re: Parallel Server


Quick answers:
Yes, Maybe, $$$, Yes.

Detailed answer to second part:

It depends on what you need and what you mean by "standby server".
OPS/RAC is multiple instances and a shared database.  If you really
need ultimate HA, OPS/RAC is second to none for system or instance
failure events.  If one instance or node is blown away (e.g. mainboard
meltdown), then failover to another instance can be very fast and
relatively transparent.  There are no data synchronization or data
loss issues as there might be with, for example, a standby database.
On the other hand, .  If you mean one catch-all solution for all
possible failure scenarios - HA and DR - then OPS/RAC isn't it.  A
shared database means that if there is a media failure, all nodes and
instances are affected.  It is run on a local cluster, so it provides
zero protection from site failure events.

OPS/RAC provides great protection against instance or system failure
and none against media or site failure.  It can be part of a hybrid
solution to provide complete protection.

-Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 1:35 PM


> Is anyone using Oracle Parallel Server?  It that the best solution
for a
> standby server?
> Any idea what it would cost?  Are there any classes covering
implementation?
>
> Ron Smith
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Don Granaman
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle on Pentium 4 conflict

2001-12-06 Thread David McVeigh


How about Linux or Solaris versions on the Pentium 4 hardware?

>>> Khoa Do <[EMAIL PROTECTED]> 12/07/01 11:30am >>>
Except for the most current version of 9i

-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


Ron, does this affect 9i?

Dave

>>> "Ron Rogers" <[EMAIL PROTECTED]> 12/07/01 04:28am >>>
List,
Received this the the SearchDatabase  org today. I thought some of you might
find it usefull. ROR mª¿ªm

ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja 

Here's a quick tip: The installation of Oracle8i on a Pentium 4 computer
will exit without any notice. The reason for this is that the Pentium 4
architecture has problems with the Just In Time installer. To fix this
problem, just find all copies of the file symcjit.dll and rename them to
symcjit.org. Then the installer will work. Copy the installation CD to the
HDD and make the changes, then install from the HDD.  Voila!

>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html 



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

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

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



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**

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

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

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

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

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



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**

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

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

RE: statspack interpretations

2001-12-06 Thread Tatireddy, Shrinivas (MED, Keane)


Hi Williams,

Thnq for responding. 

1) I need to tune the sql statemnet that have the queries using high
load %.

2) and need to look into the other issues too. like instance details
etc.

One of the list member Raj sent the documents. I am looking into them. I
think they will help for me.

If not , I will go for the books that you suggested. 

Thanx and Regards,

Srinivas


-Original Message-
Sent: Thursday, December 06, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L


Srinivas - 
- I assume that you have the Oracle Magazine articles. If not,
they
are available on-line.
- I'm confused (easily done). You say that you are tuning SQL
statements that statspack has identified and you want more information
on
statspack report interpretation. To me that is two separate issues. 
- How statspack identifies the top SQL statement offenders is
pretty
straightforward. There are good books on SQL statement tuning. I don't
have
a favorite at the moment, perhaps someone will 
- I haven't seen many resources on interpreting the rest of the
statspack report.
- Take a look at Don Burleson's book "Oracle High-Performance
Tuning
with Statspack". He offers many scripts to present Statspack results in
different forms. His main thesis is that Statspack should be run over a
period of time and the results reviewed to see what are the critical
performance periods for your system. I didn't find his tuning advice as
strong, but then I haven't found anyone that discusses server tuning
well.
There is a new movement to go from examining ratios (like the statspack
report) to examining waits.

Hope this helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 9:20 PM
To: Multiple recipients of list ORACLE-L


Hi lists,


I have a request to tune the sql statements that are generated in the
statspack report. I have a puff document on statspack. But it is of only
7 pages and explains only how to install and run statspack.

Does anybody have any document /  link for statspack report
intepretations.

if yes, can you please forward.

Thnx and Regards,

Srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

2001-12-06 Thread CHAN Chor Ling Catherine (CSC)


Hi Unix Gurus,

Does anyone know how to change the date of the Unix system ? I am running my
database server in Unix 2.6. Thanks.

Regds,
New Bee

PS.  Thank you, Kranti,  for your reply.

-Original Message-
From:   kranti pushkarna
[mailto:[EMAIL PROTECTED]]
Sent:   Friday, December 07, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change sysdate in database to a future
date 

change the date of the system on which the database resides

-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

I need to change the sysdate in the database to a future
date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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


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

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


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

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

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

2001-12-06 Thread Arn Klammer


SYSDATE is determined by the operating system's date.  You can't change the current 
date and time in Oracle; you have to change it at the OS level.

If, however, your aim is to determine things like "what's the date one week from 
today", then you can use Oracle's date arithmetic functionality (eg, "SYSDATE + 7" to 
determine the date one week from today).

hth

-arn

>>> [EMAIL PROTECTED] 7/12/2001 14:45:21 >>>
This message has been scanned by MAILSweeper.


Hi Gurus,

I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED] 

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

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



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

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

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

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

2001-12-06 Thread kranti pushkarna


change the date of the system on which the database resides

-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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

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

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

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

Change sysdate in database to a future date

2001-12-06 Thread CHAN Chor Ling Catherine (CSC)


Hi Gurus,

I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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

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


 Jared, 

Thanks. I have the main RK book. Like it. Understand what
little i have read of it. I am just interested in what
folks thought about "size vs. DW definition" was. 

I *do* think, tho, that "size does matter". 

I don't consider my shared E: drive a datawarehouse
because it can support a star query, one user, and 
300 MB of data. 

There is 'something' to do with the fact of...alot of
dataskewed dimensions...regular updates...data
cleaning...supporting mining ( and mining for a few
tiny facts in a big haystack requires, after all, the
big haystack ) 

Anyways. 

I figure anything under 250 GB doesn't even merit
being called a data Warehouse.

Maybe a data 7-11.

Thanks for the pointers and your thoughts. 

Ross

-Original Message-
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 12/6/2001 7:32 PM



Ross,

A DW is defined by purpose and design, not by size.

A collection of Data Marts, ( tables for star joins ) is not
a DW either.  DW's are used to create data marts.

If you don't already have the database books from
Kimball, I suggest you acquire them.

Data Warehouse Toolkit
http://www.amazon.com/exec/obidos/ASIN/0471153370/ref=pd_sim_books/104-7
669992-7054323

Data Warehouse Lifecycle Toolkit
http://www.amazon.com/exec/obidos/ASIN/0471255475/ref=pd_sim_books/104-7
669992-7054323

These are must haves for understanding and designing DW.

Jared




 

"Mohan, Ross"


SMI.com> cc:

Sent by: Subject: Datawarehouse
Sizes.informal poll.
[EMAIL PROTECTED]

om

 

 

12/06/01 01:55

PM

Please respond

to ORACLE-L

 

 





Informal survey: Datawarehousing.

Limiting Assumption:   "A necessary and sufficient condition for
defining
something
  to be a datawarehouse is the
amount of data
to be stored."

Question/Poll:   Given the above ridiculous constraint, at/above what
size
can something
  be considered a data
warehouse?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

Unix account from PL/SQL ??

2001-12-06 Thread Herman Susantio


Hi all,

I've got 2 questions here : (Platform : Sun Solaris) :

1. What is the command in PL/SQL to get unix userID who logged in when I
execute PL/SQL
script ?
2. I have created a new user : ABC123, and the primary group is oinstall.
When I start oracle instance using ABC123, how come the process still
belong to another
user (oracle) ?

Any feedback would be greatly appreciated

Thanks & Regards
Herman






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

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

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

2001-12-06 Thread Kimberly Smith

Oh, that was a low blow:-)

-Original Message-
Michael (TEM)
Sent: Thursday, December 06, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L

...and look what's happened to Enron!  :-0

And I might add, it works very well.

I did the same thing at Enron to prevent the
duhvelopers from changing account passwords.

Jared

Joe Testa

as.net>  cc:

Sent by: Subject: Re: Schema Owner

[EMAIL PROTECTED]

om

12/05/01 07:15

PM

Please respond

to ORACLE-L

You can't revoke the privilege from the schema owner but you CAN keep
them from doing ddl and dml by using database triggers.

now the catch is this:

the trigger HAS to be owned by someone other than the schema owner AND
the schema owner can't have the alter any trigger privilege(either
direct or via a role).

so yes Virgina(since its the xmas season), you can keep the schema owner
from altering data in its own schema.

joe

DENNIS WILLIAMS wrote:
>
> Hamid - this was discussed recently on this list and as I recall you
can't
> revoke the schema owner. Can you create a new userid and get them to use
> that? Then change the password on the schema owner. Barring that, you
could
> create a new schema, move the tables and indexes there, then grant select
to
> the original owner.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, December 05, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> May be odd question, but I realy need to do this, I want to revoke the
> privilege of the schema owner.
> I mean give only select priv to the schema owner.
> Thanks
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: Oracle on Pentium 4 conflict

2001-12-06 Thread Khoa Do


Except for the most current version of 9i

-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


Ron, does this affect 9i?

Dave

>>> "Ron Rogers" <[EMAIL PROTECTED]> 12/07/01 04:28am >>>
List,
Received this the the SearchDatabase  org today. I thought some of you might
find it usefull. ROR mª¿ªm

ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja 

Here's a quick tip: The installation of Oracle8i on a Pentium 4 computer
will exit without any notice. The reason for this is that the Pentium 4
architecture has problems with the Just In Time installer. To fix this
problem, just find all copies of the file symcjit.dll and rename them to
symcjit.org. Then the installer will work. Copy the installation CD to the
HDD and make the changes, then install from the HDD.  Voila!

>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html 



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

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

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



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**

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

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

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

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

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

2001-12-06 Thread Khoa Do


yes it does (resounding yes)

-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


Ron, does this affect 9i?

Dave

>>> "Ron Rogers" <[EMAIL PROTECTED]> 12/07/01 04:28am >>>
List,
Received this the the SearchDatabase  org today. I thought some of you might
find it usefull. ROR mª¿ªm

ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja 

Here's a quick tip: The installation of Oracle8i on a Pentium 4 computer
will exit without any notice. The reason for this is that the Pentium 4
architecture has problems with the Just In Time installer. To fix this
problem, just find all copies of the file symcjit.dll and rename them to
symcjit.org. Then the installer will work. Copy the installation CD to the
HDD and make the changes, then install from the HDD.  Voila!

>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html 



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

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

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



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**

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

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

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

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

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




Ross,

A DW is defined by purpose and design, not by size.

A collection of Data Marts, ( tables for star joins ) is not
a DW either.  DW's are used to create data marts.

If you don't already have the database books from
Kimball, I suggest you acquire them.

Data Warehouse Toolkit
http://www.amazon.com/exec/obidos/ASIN/0471153370/ref=pd_sim_books/104-7669992-7054323

Data Warehouse Lifecycle Toolkit
http://www.amazon.com/exec/obidos/ASIN/0471255475/ref=pd_sim_books/104-7669992-7054323

These are must haves for understanding and designing DW.

Jared




   
 
"Mohan, Ross"  
 

SMI.com> cc:   
 
Sent by: Subject: Datawarehouse Sizes.informal 
poll.
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/06/01 01:55 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Informal survey: Datawarehousing.

Limiting Assumption:   "A necessary and sufficient condition for defining
something
  to be a datawarehouse is the
amount of data
to be stored."

Question/Poll:   Given the above ridiculous constraint, at/above what size
can something
  be considered a data warehouse?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Re: Ping



Pong.



   
 
"Larry Elkins" 
 

.net>cc:   
 
Sent by: Subject: Ping 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/06/01 10:29 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





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

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



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

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

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

Re: Password Changes




It can be seen in dba_users.  The table is sys.user$.

Once you've changed it, the old value is gone for good.

Jared





   
 
"Burton, Laura 
 
L."  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Subject: Password Changes 
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/06/01 10:29 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




When you alter a user's password, what table does it update?


I need to 'restore' a password for a user back to what it was before I
changed it, but do not know what it was.


Any ideas??  Can this be done?


Thanks,
Laura







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

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

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

RE: Schema Owner

True, but I really didn't get much personal gain from that trigger.  :)

Jared

"Vergara,  

Michael (TEM)"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
 Subject: RE: Schema Owner 

Sent by:   

[EMAIL PROTECTED] 

om 

12/06/01 03:55 

PM 

Please respond 

to ORACLE-L

..and look what's happened to Enron!  :-0

And I might add, it works very well.

I did the same thing at Enron to prevent the
duhvelopers from changing account passwords.

Jared

Joe Testa

as.net>  cc:

Sent by: Subject: Re: Schema Owner

[EMAIL PROTECTED]

om

12/05/01 07:15

PM

Please respond

to ORACLE-L

You can't revoke the privilege from the schema owner but you CAN keep
them from doing ddl and dml by using database triggers.

now the catch is this:

the trigger HAS to be owned by someone other than the schema owner AND
the schema owner can't have the alter any trigger privilege(either
direct or via a role).

so yes Virgina(since its the xmas season), you can keep the schema owner
from altering data in its own schema.

joe

DENNIS WILLIAMS wrote:
>
> Hamid - this was discussed recently on this list and as I recall you
can't
> revoke the schema owner. Can you create a new userid and get them to use
> that? Then change the password on the schema owner. Barring that, you
could
> create a new schema, move the tables and indexes there, then grant select
to
> the original owner.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, December 05, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> May be odd question, but I realy need to do this, I want to revoke the
> privilege of the schema owner.
> I mean give only select priv to the schema owner.
> Thanks
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: Password Changes

2001-12-06 Thread Kevin Fries

Title: Password Changes




sys.dba_users-password is the field.

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Burton, Laura 
L.Sent: Thursday, December 06, 2001 12:29 PMTo: 
Multiple recipients of list ORACLE-LSubject: Password 
Changes
When you alter a user's password, what table does 
it update? 
I need to 'restore' a password for a user back to 
what it was before I changed it, but do not know what it was.  

Any ideas??  Can this be done? 
Thanks, Laura

Trigger exception problem

2001-12-06 Thread Kathy Duret


I am brain dead and can't figure this one out probably something really basic.

8.1.6 database

I have a delete trigger when I delete a row from user #1 address table and I want to 
insert a corresponding row into an archive address table that belongs to user #2. 
If there is any error inserting into the archive address table, I want to insert some 
information to an exception table owned by user #2

Insert priviledges have been granted to the 1st user on all the archive tables and the 
exception table by user #2.  The procedure that the trigger calls is valid.  The 
procedure is owned by user1.

The initial delete from user 1 works fine and populates the archive log table.
I reinserted the original row and tried to delete it again to get the exception to 
write to the
exception table.  I get:

SQL> delete from address where addr_id = 3; 
delete from address where addr_id = 3   
*   
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows   
ORA-06512: at "USER1.D_ARCH_ADDRESS", line 57
ORA-1: unique constraint (USER2.PK_ARCH_ADDRESS) violated
ORA-04088: error during execution of trigger 'PKMSPROD.D_ARCH_ADDRESS'  
 

There is only 1 row to delete from the address table.  I inserted it and checked it 
myself
I excepted the constraint to be violated for the archive address table 
I don't get an entry into my exception table

TRIGGER CODE:

CREATE OR REPLACE TRIGGER D_ARCH_ADDRESS
BEFORE DELETE ON ADDRESS
  FOR EACH ROW  
DECLARE 
  v_err_msg VARCHAR2(255) := NULL;  
  v_err_codeVARCHAR2(20)  := NULL;  
  v_process VARCHAR2(9)   := NULL;  
  V_ARCH_CREATED_BY VARCHAR2(30)  := NULL;  
BEGIN   
  select user into v_arch_created_by from dual; 
INSERT INTO USER2.ARCH_ADDRESS   
(   
WHSE,   
ADDR_ID,
ADDR_TYPE  ,
ADDR_KEY_1   ,  
ADDR_KEY_2   ,  
ADDR_LINE_1  ,  
ADDR_LINE_2  ,  
ADDR_LINE_3  ,  
CITY ,  
STATE , 
ZIP  ,
CNTRY , 
CONTACT  ,  
PHONE,  
FAX  ,  
EMAIL   ,   
CREATE_DATE_TIME   ,
MOD_DATE_TIME  ,
USER_ID  ,  
ARCH_CREATE_DATE_TIME,  
ARCH_CREATED_BY 
) VALUES
(   
   'IY'   , 
   :old.ADDR_ID,
   :old.ADDR_TYPE  ,
   :old.ADDR_KEY_1   ,  
   :old.ADDR_KEY_2   ,  
   :old.ADDR_LINE_1

RE: Schema Owner

2001-12-06 Thread Vergara, Michael (TEM)

...and look what's happened to Enron!  :-0

And I might add, it works very well.

I did the same thing at Enron to prevent the
duhvelopers from changing account passwords.

Jared

Joe Testa

as.net>  cc:

Sent by: Subject: Re: Schema Owner

[EMAIL PROTECTED]

om

12/05/01 07:15

PM

Please respond

to ORACLE-L

You can't revoke the privilege from the schema owner but you CAN keep
them from doing ddl and dml by using database triggers.

now the catch is this:

the trigger HAS to be owned by someone other than the schema owner AND
the schema owner can't have the alter any trigger privilege(either
direct or via a role).

so yes Virgina(since its the xmas season), you can keep the schema owner
from altering data in its own schema.

joe

DENNIS WILLIAMS wrote:
>
> Hamid - this was discussed recently on this list and as I recall you
can't
> revoke the schema owner. Can you create a new userid and get them to use
> that? Then change the password on the schema owner. Barring that, you
could
> create a new schema, move the tables and indexes there, then grant select
to
> the original owner.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, December 05, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> May be odd question, but I realy need to do this, I want to revoke the
> privilege of the schema owner.
> I mean give only select priv to the schema owner.
> Thanks
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

2001-12-06 Thread April Wells


 Barbara... have you been talking to men again...?

As I was instructed by the Oracle Data Warhouse class instructor last
year... it isn't the  amount of data, but what it's purpose is... what you
do with it.  

He was a neat teacher... Harley and all.

April
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/6/01 5:25 PM

Ross
Size doesn't matter.
No, really.
Who's imposing the "amount of data" constraint??
Push Dodge and Gorman's "Oracle8 Data Warehousing" book toward your
damagement, and somehow trick them into reading the first chapter.  They
quote Inmon (of course) -- a data warehouse is a "subject oriented,
integrated, nonvolatile, and time variant collection of data in support
of
management's decisions".  Actually, this manual is a good read on the
subject.

On a lighter note -- we don't have a warehouse, we have a "data mart".
Cuz
we were too small to be a warehouse (at only 30 gigs).

x
Barb


> --
> From: Mohan, Ross[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, December 06, 2001 2:55 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Datawarehouse Sizes.informal poll.
> 
> Informal survey: Datawarehousing. 
> 
> Limiting Assumption:   "A necessary and sufficient condition for
defining
> something
>   to be a datawarehouse is the amount of
data
> to be stored." 
> 
> Question/Poll:   Given the above ridiculous constraint, at/above what
size
> can something
>   be considered a data warehouse?
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: DBCA (DATAFILE SIZE PROBLEM)

2001-12-06 Thread Peter . McLarty


Try using Custom it will allow you to do that and more

Cheers

Peter McLarty                   E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.Mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461 
Brisbane,  Australia                Mobile: +61 (0)402 094 238           
--                    Facsimile: +61 (0)7 3303 3048






Harvinder Singh <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/12/2001 04:29 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        DBCA (DATAFILE SIZE PROBLEM)


Hi,

We are creating database using DBCA , but it only allows us to change the
location of datafile.
We need to chane the size . Is this option available using DBCA or we need
to alter the size
after database is created with default size.
Environment is 9i on sun 2.8

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




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

list down?

2001-12-06 Thread Joe Raube


I haven't received anything since this morning.

-Joe



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

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

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

RE: Column Title

2001-12-06 Thread Alexander . Feinstein

Title: RE: Column Title





Binay,


It is a bug related to cursor_sharing=force.
Try alter session set cursor_sharing=exact.


Alex.




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Column Title



Hello DBA-Gurus,


Executing the same query on 2 databases, but getting different output- the
column title. In all the databases its limited to the value of the row except
in one database we've. All the  databases are of 8.1.7.2 running on IBM/unix
server.


Database- A
--
select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;



SUB


---


LET


Database-B
--


select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;



SUBSTR('LETMEBABYONEMORET





LET


See the output of Database-B - that's the difference from the others.It seems
that its a database specific problem- we tried with all SQLPLUS versions, both
Unix and Windows and objerved the same.


Eager to know what makes the difference - all your comments are welcome.


Thanks




-Binay







---


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


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

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

Re: Parallel Server

Not here, no, too darn much, and yes.

--S

--- "Smith, Ron L." <[EMAIL PROTECTED]> wrote:
> Is anyone using Oracle Parallel Server?  It that the
> best solution for a
> standby server?
> Any idea what it would cost?  Are there any classes
> covering implementation?
> 
> Ron Smith

__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: [EMAIL PROTECTED]

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

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


Thanks for the assist, bro'.  They got me
jumping-through-my-own-hindquarters busy here.

Lisa K., you wanted meaningful work?  Move west and
I'll hook you up.  Meaningful?  Debatable.  Work?  Oh
yeah!

--S


--- Kevin Lange <[EMAIL PROTECTED]> wrote:
> Couple clarifications:
> 
> 1. -a : file exists (any type of file)
>-d : file is a directory
>-f : file is a regular file (like Scott Said)
> 
> 2. The test is not neccessary
> 
> vFILE_NAME='The file in question'
> 
> if [ -f ${vFILE_NAME} ]
> then
>   echo "File is there.  You do not have to spend
> hours recreating it."
> else
>   echo "Arggghhh !   Who the heck deleted my file !!
> Where the heck is my
> gun!"
> fi
> 
> 
> -Original Message-
> Sent: Wednesday, December 05, 2001 11:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> This is untested and from memory, but:
> 
> if [test -f ]
> then
> echo "found"
> else
> echo "help, are you an idiot"
> fi
> 
> --Scott
> 
> 
> --- Sinard Xing <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > 
> > Can someone recommend good unix mailing list
> > 
> > by the way how to check the existence of a file ?
> > 
> > My logic :
> > 
> > if (findThisFile(/tmp/myfile.txt) == 0)
> > echo "the file is exists"
> > else
> > echo "file not found"
> > endif
> > 
> > 
> > what is the unix function for findThisFile()
> > 
> > 
> > 
> > Thank you,
> > 
> > Sinardy
> > Hoping Peace in Middle East 
> > and the rest of the World
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Sinard Xing
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (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!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Scott Shafer
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: [EMAIL PROTECTED]

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

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




And I might add, it works very well.

I did the same thing at Enron to prevent the
duhvelopers from changing account passwords.

Jared



   

Joe Testa  

   
as.net>  cc:   

Sent by: Subject: Re: Schema Owner 

[EMAIL PROTECTED] 

om 

   

   

12/05/01 07:15 

PM 

Please respond 

to ORACLE-L

   

   





You can't revoke the privilege from the schema owner but you CAN keep
them from doing ddl and dml by using database triggers.

now the catch is this:

the trigger HAS to be owned by someone other than the schema owner AND
the schema owner can't have the alter any trigger privilege(either
direct or via a role).

so yes Virgina(since its the xmas season), you can keep the schema owner
from altering data in its own schema.

joe

DENNIS WILLIAMS wrote:
>
> Hamid - this was discussed recently on this list and as I recall you
can't
> revoke the schema owner. Can you create a new userid and get them to use
> that? Then change the password on the schema owner. Barring that, you
could
> create a new schema, move the tables and indexes there, then grant select
to
> the original owner.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, December 05, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> May be odd question, but I realy need to do this, I want to revoke the
> privilege of the schema owner.
> I mean give only select priv to the schema owner.
> Thanks
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed,
and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)

--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)

RE: Datawarehouse Sizes.....informal poll.

2001-12-06 Thread Baker, Barbara


Ross
Size doesn't matter.
No, really.
Who's imposing the "amount of data" constraint??
Push Dodge and Gorman's "Oracle8 Data Warehousing" book toward your
damagement, and somehow trick them into reading the first chapter.  They
quote Inmon (of course) -- a data warehouse is a "subject oriented,
integrated, nonvolatile, and time variant collection of data in support of
management's decisions".  Actually, this manual is a good read on the
subject.

On a lighter note -- we don't have a warehouse, we have a "data mart".  Cuz
we were too small to be a warehouse (at only 30 gigs).

x
Barb


> --
> From: Mohan, Ross[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, December 06, 2001 2:55 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Datawarehouse Sizes.informal poll.
> 
> Informal survey: Datawarehousing. 
> 
> Limiting Assumption:   "A necessary and sufficient condition for defining
> something
>   to be a datawarehouse is the amount of data
> to be stored." 
> 
> Question/Poll:   Given the above ridiculous constraint, at/above what size
> can something
>   be considered a data warehouse?
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

2001-12-06 Thread Joe Testa


user$ is updated and why not just reset it to the known value, only if 
you happen to have the "encrypted" password, then you could set it back 
using alter user  identified by values 'ENCRYPTED PASSWORD HERE';

otherwise you're outta luck.

joe


Burton, Laura L. wrote:

> When you alter a user's password, what table does it update?
> 
> I need to 'restore' a password for a user back to what it was before I 
> changed it, but do not know what it was. 
> 
> Any ideas??  Can this be done?
> 
> Thanks,
> Laura
> 


-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






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

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

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

Testing

2001-12-06 Thread Sherman, Edward


It's vewy vewy quiyet.


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

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

[no subject]

2001-12-06 Thread Koniszewski, Mike


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

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

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

LUHN formula

2001-12-06 Thread Joe LaCascio



Hey folks,

I don't want to reinvent the wheel if I don't have to.

Does anyone have a LUHN function they'd be willing to share?

Thanks,
Joe

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

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

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


Charlie,

You must first put your database in ArchiveLog mode, of course.  The basic
init.ora parameters to set and the command "Alter Database ArchiveLog"
(while mounted, but not open, after a clean shutdown) haven't really changed
from 7 to 8 to 8i, except now you can specify archive log duplexing.

A simple SQL script might get you started.
For each Tablespace:

Alter Tablespace  Begin Backup ;
Host cp /ts1_datafile_1.dbf 
Host cp /ts1_datafile_2.dbf 
...
Alter Tablespace  End Backup ;
...

Save the datafile copies and your archived redo logs, as well as backup
control files, and you've got it covered.  Oh, and don't back up your online
redo logs - they'll be worthless for a recovery and can cause you grief if
you restore them over your current, good, ones.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Mengler
Sent: Thursday, December 06, 2001 12:29 PM
To: Multiple recipients of list ORACLE-L


I'm not sure if I'm bragging or complaining, but I've never setup
or supported online backups for Oracle. I'm being directed to
implement online backups for a V7.3.4.5 instance. A search of
OTN reveals that Oracle no longer seems to have any V7 documents
available anymore. :-(

Since this DB is stuck at V7.3.4.5 for at least 6 more months,
I need to get online backups operational without using RMAN.
If somebody who has *nix shell script(s) or Perl code that
implements online backups, I'd appreciate if you would send a
copy my way. I'm just looking for something to get me started.

TIA & HAND!

--
Charlie Mengler  Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(dat
e_time,86400)/86400
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

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

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

Size of US7ASCII database vs. UTF8

2001-12-06 Thread Cherie_Machler



We are currently using US7ASCII for our 240 Gig data warehouse.

We are considering switching over to UTF8 for a new generation
of this product.   We would start small in the development database
but by the time that we get to production, we will have just as much
data as we do now.

My question is, does anyone know whether the size of the database
will be significantly impacted by using UTF8 character set as opposed
to US7ASCII?   Have you noticed any increase in database size if you
converted over?


Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

RE: [Q] ORACLE text string search case problem???

2001-12-06 Thread Gogala, Mladen


There are two solutions: 
a) Function based index on UPPER(required column)
b) Upgrading MS Access to support unlimited users on SUN Solaris.
   Do not forget to buy the row-locking option.

-Original Message-
Sent: Wednesday, December 05, 2001 5:10 PM
To: Multiple recipients of list ORACLE-L


We have third party application, while doing text string search, user need
type in upper case otherwise nothing display.  The vendor said it is
ORACLE problem, because "MS Access" do NOT have this problem.  Because we
does NOT have application source code, does their has way We can setup
parameter on "init.ora" file to make it work or not?


Our ORACLE version is 8.1.7 on SUN Solaris.


Thanks.



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

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

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

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

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

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

Re: Ping

2001-12-06 Thread Joe Testa


pong

Larry Elkins wrote:

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






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

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

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

REMOTE USER CREATION

2001-12-06 Thread Sakthi , Raj


Hi Folks ,
Somebody tell me I am not insane...please..!!
The problem is this...
As usual Everybody else except DBA ( me..) decided and
designed a program to create user in other database
using a procedure thru db_link.
Example. 
The programme exists in database A. When they want
they have to execute a procedure under sys schema in
Database B to create a user in database B and they
have to be able to pass username and password to teh
procedure.

well...God had other plans and they are getting 
ORA - 2064 "distributed operation not supported"
NOw I am stuck with troubleshooting.
Has anybody seen and/or used anything like this ?
ANy pointer is welcome and would be appreciated.
TIA
Cheers
RS




__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sakthi , Raj
  INET: [EMAIL PROTECTED]

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

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

DBCA (DATAFILE SIZE PROBLEM)

2001-12-06 Thread Harvinder Singh


Hi,

We are creating database using DBCA , but it only allows us to change the
location of datafile.
We need to chane the size . Is this option available using DBCA or we need
to alter the size
after database is created with default size.
Environment is 9i on sun 2.8

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

Re: Oracle DB Connection Problem

2001-12-06 Thread DBarbour



Ken,

You probably could use a DBA for support in your current project.  Hasn't
the company you're working with provided one?  In any case, the error
you're getting could be result of one of several things - it's W2K.  First
- generally the message "shared memory realm not available" means the SID
you're using isn't available on that box.  Usually due to the DB being
down, but it could be for a host of other reasons.  On W2K, making Oracle
available had two parts, the windoze Oracle Services must be running, and
the database must be mounted and open.  Are both these conditions
satisfied.  Second - if your using terminal services client to access the
server, depending on the version of the TSC, the SP of W2K, and the version
of Oracle, you nay not be able to use SQL Plus from the command line if you
are not a member of the "DBA" group, are using the bequeath protocol, or
your environmental variables are not properly set.  Third - kind of like
#2, but check your environment with the SET command.  Fourth - you have an
incorrect TNS names entry, or your listener is improperly configured, or
your sqlnet.ora file has a problem.

Troubleshooting connection problems, while it can be almost be reduced to a
checklisted science, is really more of an art.

Hope this helps.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
Ken Janusz 
   
  
fsys.com>cc:   
   
Sent by: Subject: Oracle DB Connection Problem 
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
12/05/2001 
   
07:30 PM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




 8.1.7 on Dell W2000 server.

When I try to login via sqlplus I get this:

ORA-01034 Oracle not available
ORA-27101 shared memory realm doesn't exist

Then I get:

Login:
Password:

And this error:
ORA-12560 TNS: protocol adapter error.

Any ideas as to what the problem is?

Thanks,
Ken Janusz
Sufficient Systems, Inc.



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

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

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




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

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

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

Re: V7 online backups

2001-12-06 Thread Joe Testa

Charlie, check out

alter tablespace begin backup.

thats has not changed since version 7, so even the 9i docs will cover it 
and with 9i docs, there is a whole section on user managed backups.

joe

Charlie Mengler wrote:

> I'm not sure if I'm bragging or complaining, but I've never setup
> or supported online backups for Oracle. I'm being directed to
> implement online backups for a V7.3.4.5 instance. A search of
> OTN reveals that Oracle no longer seems to have any V7 documents
> available anymore. :-(
> 
> Since this DB is stuck at V7.3.4.5 for at least 6 more months,
> I need to get online backups operational without using RMAN.
> If somebody who has *nix shell script(s) or Perl code that
> implements online backups, I'd appreciate if you would send a
> copy my way. I'm just looking for something to get me started.
> 
> TIA & HAND!
> 
> 

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)

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

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

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

RE: Off Topic: Australian Visa

2001-12-06 Thread Diego Cutrone

thanks all who answered.
greetings
DC

- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 06, 2001 3:10
AM
Subject: Re: Off Topic: Australian
Visa
Another site for employment
opportunities is www.jobnet.com.au.
From there you can find most of the agencies that work in IT employment. You
might be best checking out some of there websites and maybe contacting some of
those directly about visa requirements etc. Jobs aren't so prolific over here either anymore
however knowledgeable staff with strong skills are able to gain employment.
The current employment climate is sending a bunch of the paper certified's
back to there old fields of employment. HTHPeter McLarty
E-mail:
[EMAIL PROTECTED]Technical Consultant
WWW: http://www.Mincom.comAPAC Technical Services
Phone: +61 (0)7 3303 3461 Brisbane, Australia
Mobile: +61 (0)402 094 238
--
Facsimile: +61 (0)7 3303 3048

"Diego Cutrone"
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
05/12/2001 05:10 AM Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> cc:
Fax to: Subject:
Off Topic: Australian
VisaSorry for
the off-topic.
I'm from Argentina, and I'm finding out what the
steps I should follow to get a visa (for working) or may be a sponsor in
Australia. (A friend of mine told me that
Oracle proffesionals have a good chance of getting a job in this
country)
I hope that someone can help me (may be some
Australian) by pointing me where should I be searching for an Australian
Sponsor (something like www.dbajobs.com) or Jobs offers.
Thanks -- This transmission is for the intended addressee only and
is confidentialinformation. If you have received this transmission in
error, pleasedelete it and notify the sender. The contents of this e-mail
are theopinion of the writer only and are not endorsed by the Mincom
Groupof companies unless expressly stated
otherwise.

Password Changes

2001-12-06 Thread Burton, Laura L.

Title: Password Changes





When you alter a user's password, what table does it update?


I need to 'restore' a password for a user back to what it was before I changed it, but do not know what it was.  


Any ideas??  Can this be done?


Thanks,
Laura

Re: Oracle on Pentium 4 conflict

2001-12-06 Thread David McVeigh


Ron, does this affect 9i?

Dave

>>> "Ron Rogers" <[EMAIL PROTECTED]> 12/07/01 04:28am >>>
List,
Received this the the SearchDatabase  org today. I thought some of you might find it 
usefull.
ROR mª¿ªm

ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja 

Here's a quick tip: The installation of Oracle8i on a Pentium 4
computer will exit without any notice. The reason for this is that
the Pentium 4 architecture has problems with the Just In Time
installer. To fix this problem, just find all copies of the file
symcjit.dll and rename them to symcjit.org. Then the installer will
work. Copy the installation CD to the HDD and make the changes, then
install from the HDD.  Voila!

>> CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html 



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

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

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



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**

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

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

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

2001-12-06 Thread Tim Bunce


On Wed, Dec 05, 2001 at 03:00:19PM -0800, MacGregor, Ian A. wrote:
> How well does MySQL scale.

This well:   |<--->|

:)

> How does it handle parallel direct inserts?

It doesn't. But then it's faster than Oracle to start with.

Oracle will _always_ be able to beat MySQL at the top end.
But MySQL can (nearly) always beat Oracle at the bottom end.
It's in the middle that things get tricky and many other issues
come into play.

Oracle is much better at spreading IO over multiple disks with fine
granularity, and much better at data caching (MySQL basically only
does index caching - part of it's approach to reliability.)

> Does it do it better than the Oracle OCI interface.

Better? Probably not. But there's a sufficent API and, of course,
a Perl DBI driver :)

> We've got an Oracle experiment running now for our channel archive data, real time 
>data from sensors monitoring the  accelerator.   We haven't switched off the old 
>write to linked files method, and won't for a year.  
> 
> However, the proposed NLC, Next Linear Collider,  will need to capture this data at 
>a rate of 10,000 gigabytes!! a second.  Of course one might question the utility of 
>collecting monitoring data at a petabyte a second.  If the project is approved, 
>people have five years to come up with the why and how.
> 
> Perhaps I should recommend they use MySQL :)   

I'd certainly recommend that they look at it. It is *free* after all.
That means that money you save by not buying Oracle licences can
go into more hardware :)

I really don't want to get into any big debate about the pros and
cons of MySQL. It's certainly has it's faults, just like Oracle.
Looked at with an Oracle mindset it'll probably look too basic.
But as with all such issues, people need to try it for themselves.

Tim.

> -Original Message-
> Sent: Wednesday, December 05, 2001 9:31 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> Tim,
> 
> That sounds rather interesting, as the impression that  MySQL users
> sometimes give is that they're perfectly happy with MySQL and
> don't have any need to move to Oracle or anything else.
> 
> Any particular features of Oracle that the owners feel they
> need, or is it a move to satisfy  investors/auditors/etc.?
> 
> Jared
> 
> 
> 
>  
>   
> Tim Bunce
>   
> ORACLE-L <[EMAIL PROTECTED]>
> ox.com>  cc: 
>   
> Sent by: Subject: Re: Embedding perl in Oracle   
>   
> [EMAIL PROTECTED]   
>   
> om   
>   
>  
>   
>  
>   
> 12/05/01 03:30   
>   
> AM   
>   
> Please respond   
>   
> to ORACLE-L  
>   
>  
>   
>  
>   
> 
> 
> 
> 
> On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote:
> > My office mate (cc'd) also set this up to demo the process.  I'm
> > considering testing out the possibility of using an Oracle view on
> > top of function that calls a extproc_perl to a MySQL database.
> 
> I imagine that'll be at least an order of magnitude slower than
> using the Oracle ODBC Gateway and MyODBC to do the same thing.
> I'll also be read-only.
> 
> I'm due to be working on setting up a Oracle ODBC Gateway and MyODBC
> for a production system soonish. It's part of a strategy to simplify
> migration from MySQL to Oracle.
> 
> Tim.
> 
> > Tom
> >
> > On Wed, Dec 05, 2001 at 12:55:31AM +, Tim Bunce wrote:
> > > On Tue, Dec 04, 2001 at 01:45:46PM -0800, [EMAIL PROTECTED]
> wrote:
> > > >
> > > > Of course, you can already call Perl from oracle via extproc_perl.
> > > >
> > > > I've done it, it works.  Be aware that setting it up is not trivial,
> > > >

RE: Duplexing Archived Log Files


Dennis,

We use

log_archive_dest_1
log_archive_dest_2

sending a copy of each archived redo log to our Standby database
(log_archive_dest_2).

log_archive_dest_2 is used with the OPTIONAL parameter, since we don't want
to stop archiving if the Standby is down or there's some problem with the
LAN.

We also have
log_archive_min_succeed_dest = 1
to make sure that the archiving succeeds at least to the local target drive
(log_archive_dest_1).

It's worked great for us (8.1.6.0.0 EE under Win2k).

BTW, we use RMan for hot backups and like it very much.  We can also issue
the Alter Tablespace Begin Backup command and get instantaneous results -
which I had to do recently to restore some datafiles to the Standby after
one of its disks failed.  I wonder why you get such slow response?

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
WILLIAMS
Sent: Thursday, December 06, 2001 12:29 PM
To: Multiple recipients of list ORACLE-L


Is anyone using the LOG_ARCHIVE_DUPLEX_DEST parameter? Any problems with it?

We are on Oracle 8.1.6 on Compaq Tru64. On our ERP 150-gig. database, we are
currently doing a cold backup weekly. This means that we are very dependent
on archive logs.
   - Recovery time isn't a big concern. In the event of a failure, recovery
time isn't that critical. Loss of a week of work would be.
   - We have tried hot backups successfully on smaller databases, but we
found that once we issue ALTER TABLESPACE BEGIN BACKUP there was often a
delay of hours for that command to complete. So we gave up on hot backups.
   - We are starting to work with RMAN and feel in the long run this will be
an ideal solution. Thanks to everyone for answering my newby RMAN questions.
   - Recently Oracle has added a feature to duplex the archive log files.
This sounds like it would lessen our archive log vulnerability. However, it
causes my sys admin more work, so I would appreciate some feedback before I
add this burden to his work.
Thanks for any thoughts you care to share.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



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

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

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

RE: Duplexing Archived Log Files


if you duplex mandatory and one server destination fails..is fixed...the
time lag for the db to become aware of the now-available second mandatory
location can be lengthy. 

I have witnessed a test where it took 11 Minutes. 

that's a lng time, when you are waiting for the db to "figure out"
that everything is fixed and available to restart

same type of symptoms as a full archive log dest location, but longer
recovery/awareness time. 

hth

ross

-Original Message-
Sent: Thursday, December 06, 2001 1:29 PM
To: Multiple recipients of list ORACLE-L


Is anyone using the LOG_ARCHIVE_DUPLEX_DEST parameter? Any problems with it?

We are on Oracle 8.1.6 on Compaq Tru64. On our ERP 150-gig. database, we are
currently doing a cold backup weekly. This means that we are very dependent
on archive logs. 
   - Recovery time isn't a big concern. In the event of a failure, recovery
time isn't that critical. Loss of a week of work would be.
   - We have tried hot backups successfully on smaller databases, but we
found that once we issue ALTER TABLESPACE BEGIN BACKUP there was often a
delay of hours for that command to complete. So we gave up on hot backups.
   - We are starting to work with RMAN and feel in the long run this will be
an ideal solution. Thanks to everyone for answering my newby RMAN questions.
   - Recently Oracle has added a feature to duplex the archive log files.
This sounds like it would lessen our archive log vulnerability. However, it
causes my sys admin more work, so I would appreciate some feedback before I
add this burden to his work.
Thanks for any thoughts you care to share.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-12-06 Thread DENNIS WILLIAMS


Ross - I think if you ask a data warehousing list such as
mailto:[EMAIL PROTECTED]
  you'll find some contacts.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, December 06, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L


Anyone using NCR/Teradata for Data Warehousing out there? 
 

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

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

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

RE: statspack interpretations

2001-12-06 Thread DENNIS WILLIAMS


Srinivas - 
- I assume that you have the Oracle Magazine articles. If not, they
are available on-line.
- I'm confused (easily done). You say that you are tuning SQL
statements that statspack has identified and you want more information on
statspack report interpretation. To me that is two separate issues. 
- How statspack identifies the top SQL statement offenders is pretty
straightforward. There are good books on SQL statement tuning. I don't have
a favorite at the moment, perhaps someone will 
- I haven't seen many resources on interpreting the rest of the
statspack report.
- Take a look at Don Burleson's book "Oracle High-Performance Tuning
with Statspack". He offers many scripts to present Statspack results in
different forms. His main thesis is that Statspack should be run over a
period of time and the results reviewed to see what are the critical
performance periods for your system. I didn't find his tuning advice as
strong, but then I haven't found anyone that discusses server tuning well.
There is a new movement to go from examining ratios (like the statspack
report) to examining waits.

Hope this helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 9:20 PM
To: Multiple recipients of list ORACLE-L


Hi lists,


I have a request to tune the sql statements that are generated in the
statspack report. I have a puff document on statspack. But it is of only
7 pages and explains only how to install and run statspack.

Does anybody have any document /  link for statspack report
intepretations.

if yes, can you please forward.

Thnx and Regards,

Srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

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

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

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

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

Datawarehouse Sizes.....informal poll.


Informal survey: Datawarehousing. 

Limiting Assumption:   "A necessary and sufficient condition for defining
something
to be a datawarehouse is the amount of data
to be stored." 

Question/Poll:   Given the above ridiculous constraint, at/above what size
can something
be considered a data warehouse?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

Ping

2001-12-06 Thread Larry Elkins



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

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

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

V7 online backups

2001-12-06 Thread Charlie Mengler


I'm not sure if I'm bragging or complaining, but I've never setup
or supported online backups for Oracle. I'm being directed to
implement online backups for a V7.3.4.5 instance. A search of
OTN reveals that Oracle no longer seems to have any V7 documents
available anymore. :-(

Since this DB is stuck at V7.3.4.5 for at least 6 more months,
I need to get online backups operational without using RMAN.
If somebody who has *nix shell script(s) or Perl code that
implements online backups, I'd appreciate if you would send a
copy my way. I'm just looking for something to get me started.

TIA & HAND!

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(date_time,86400)/86400
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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


Jim,

An option that handles multiple duplicates is:

Delete
>From  MyTable
Where (MyColumn,RowID) In
(
 Select MyColumn,RowID
 From   MyTable
 Minus
 Select MyColumn,Min(RowID)
 From   MyTable
 Group By MyColumn
);

You could use Max(RowID) as well, depending on your needs.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
JAMES W [IT/1000]
Sent: Thursday, December 06, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L


Hello all,

I know this has come across many times now, and I thought I had it saved
somewhere - you know how that goes...

I need to query a table to find all duplicate rows based on a given column.
Don't feel like re-inventing the wheel...

Thanks in advance,
Jim




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

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

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

RE: Parallel Server

2001-12-06 Thread tday6


Actually, Oracle uses OPS internally on their e-mail system.  For that
reason (Larry likes his mail fresh every morning) the OPS gets patches and
bug fixes with a very high priority.  I used to have to install them.
Oracle runs it on HP-UX HA (High Availability).  It's expensive but it
performs flawlessly if it's set up by HP and Oracle.


   

"Johnston, 

Tim" To: Multiple recipients of list ORACLE-L  



@quallaby.comcc:   

>Subject: RE: Parallel Server  

Sent by: root  

   

   

12/05/2001 

07:20 PM   

Please 

respond to 

ORACLE-L   

   

   





What version and platform???  I've had some exposure to OPS in 7.3 on HP a
couple years ago and it was nightmare...  I've heard it is much better now
though...  Anyone using the 9i stuff yet???  I'm sure there are people with
more recent experience and their input more up to date than mine...  That
being said, my concerns are that OPS is a relatively low usage product for
Oracle...  And therefore, when you encounter an issue, it is more likely
that it is a "new" bug...  Which means more diagnostic patches, down time,
less people with experience to talk to and more sleepless nights...  Been
there, done that...  If I were you, I wouldn't consider it unless it was at
least 8.1 or above...  Get used to raw devices...  I'm not sure, but I
think
the Oracle OPS license is fairly expensive...  I really don't know for sure
though...  And, make sure you have enough money in the budget to have an
OPS
system in your TEST environment...  Trust me on that one...  Regardless of
the version...

My questions are...  Is this a new app or will you try to port an existing
app to OPS?  Is this solely a failover standby?  What is the failover time
requirements?  How much money do you have to spend?  Have you considered
standby databases?  Either from Oracle or a third party (i.e. Shareplex)...
How big is the database?

Tim

PS - Yes...  There are classes available for OPS...

-Original Message-
Sent: Wednesday, December 05, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L


Is anyone using Oracle Parallel Server?  It that the best solution for a
standby server?
Any idea what it would cost?  Are there any classes covering
implementation?

Ron Smith


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

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

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

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

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


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

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

Re: [Q] ORACLE text string search case problem???

2001-12-06 Thread tday6


It's not an Oracle vs Access problem, it's a UNIX vs Windows problem.  UNIX
is case sensitive.  Oracle is also when you are talking about literal
strings (as well it should be if you're talking about literals).  Vendor
doesn't know how to check for different cases and does shoddy work.


   

dist cash  

<[EMAIL PROTECTED]>

Sent by: rootcc:   

 Subject: [Q] ORACLE text string search 
case   
 problem???

12/05/2001 

05:10 PM   

Please 

respond to 

ORACLE-L   

   

   





We have third party application, while doing text string search, user need
type in upper case otherwise nothing display.  The vendor said it is
ORACLE problem, because "MS Access" do NOT have this problem.  Because we
does NOT have application source code, does their has way We can setup
parameter on "init.ora" file to make it work or not?


Our ORACLE version is 8.1.7 on SUN Solaris.


Thanks.



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

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

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

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


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

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

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

RE: SQL to find duplicate rows...


Jim,

Oops!  Right after I sent this, I saw that you asked to find, not delete,
duplicates.

Sorry, I've spent the last two days de-duping a bunch of tables, so I've got
deletion on the brain.

How about:

Select SomeColumn
>From   MyTable
Where  MyColumn In
(
 Select MyColumn
 From   My Table
 Group By MyColumn
 Having Count(*) > 1
)
;

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Sent: Thursday, December 06, 2001 3:34 PM
To: [EMAIL PROTECTED]


Jim,

An option that handles multiple duplicates is:

Delete
>From  MyTable
Where (MyColumn,RowID) In
(
 Select MyColumn,RowID
 From   MyTable
 Minus
 Select MyColumn,Min(RowID)
 From   MyTable
 Group By MyColumn
);

You could use Max(RowID) as well, depending on your needs.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
JAMES W [IT/1000]
Sent: Thursday, December 06, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L


Hello all,

I know this has come across many times now, and I thought I had it saved
somewhere - you know how that goes...

I need to query a table to find all duplicate rows based on a given column.
Don't feel like re-inventing the wheel...

Thanks in advance,
Jim




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

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

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

Duplexing Archived Log Files

2001-12-06 Thread DENNIS WILLIAMS


Is anyone using the LOG_ARCHIVE_DUPLEX_DEST parameter? Any problems with it?

We are on Oracle 8.1.6 on Compaq Tru64. On our ERP 150-gig. database, we are
currently doing a cold backup weekly. This means that we are very dependent
on archive logs. 
   - Recovery time isn't a big concern. In the event of a failure, recovery
time isn't that critical. Loss of a week of work would be.
   - We have tried hot backups successfully on smaller databases, but we
found that once we issue ALTER TABLESPACE BEGIN BACKUP there was often a
delay of hours for that command to complete. So we gave up on hot backups.
   - We are starting to work with RMAN and feel in the long run this will be
an ideal solution. Thanks to everyone for answering my newby RMAN questions.
   - Recently Oracle has added a feature to duplex the archive log files.
This sounds like it would lessen our archive log vulnerability. However, it
causes my sys admin more work, so I would appreciate some feedback before I
add this burden to his work.
Thanks for any thoughts you care to share.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

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

Oracle on Pentium 4 conflict

2001-12-06 Thread Ron Rogers


List,
Received this the the SearchDatabase  org today. I thought some of you might find it 
usefull.
ROR mª¿ªm

ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja 

Here's a quick tip: The installation of Oracle8i on a Pentium 4
computer will exit without any notice. The reason for this is that
the Pentium 4 architecture has problems with the Just In Time
installer. To fix this problem, just find all copies of the file
symcjit.dll and rename them to symcjit.org. Then the installer will
work. Copy the installation CD to the HDD and make the changes, then
install from the HDD.  Voila!

>> CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html



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

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

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

RE: Oracle DB Connection Problem

2001-12-06 Thread Mercadante, Thomas F


Ken

The database is not up.  The NT services are not running.

To start them, from GUI go to Start|Control Panel|Administrative
Tools|Services, find the Oracle service and start it.  Check the service to
be sure it is "Auto Start" enabled.

If you cannot get to the machine, telnet to the box and, at the DOS prompt, 
type :  net start oracleservice{sid}

The above will start the Oracle service and the database both.

hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 05, 2001 8:30 PM
To: Multiple recipients of list ORACLE-L


 8.1.7 on Dell W2000 server. 

When I try to login via sqlplus I get this: 

ORA-01034 Oracle not available 
ORA-27101 shared memory realm doesn't exist 

Then I get: 

Login: 
Password: 

And this error: 
ORA-12560 TNS: protocol adapter error. 

Any ideas as to what the problem is? 

Thanks, 
Ken Janusz 
Sufficient Systems, Inc. 

  

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

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

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

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

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

RE: SQL to find duplicate rows...

2001-12-06 Thread Jamadagni, Rajendra


select column1, count(*)
from my_table
group by column1
having count(*) > 1

__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

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



*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

SQL to find duplicate rows...

2001-12-06 Thread HAWKINS, JAMES W [IT/1000]


Hello all,

I know this has come across many times now, and I thought I had it saved
somewhere - you know how that goes...

I need to query a table to find all duplicate rows based on a given column.
Don't feel like re-inventing the wheel...

Thanks in advance,
Jim

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797

[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: HAWKINS, JAMES W [IT/1000]
  INET: [EMAIL PROTECTED]

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

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

300 gbyte data "warehouse"

Title: RE: Parallel Server



Anyone 
using NCR/Teradata for Data Warehousing out there?

RE: BMC Patrol DBXray / CA Unicenter


Embarcadero products?

-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


We are using OEM currently on our Oracle environments.  However, we have
about 100 Sybase servers and about 10 Microsoft SQL Server servers in
addition to the 20 or so Oracle instances we have.  There are only 6 of us
supporting all these environments, and not everybody is knowledgeable in all
the dbms'.  What we'd like to get is a proactive monitoring tool that can be
used for all of our databases.  










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

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

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

startup remote instance 9i

2001-12-06 Thread nlzanen1




Hi All,


client 8.1.6 (NT)
Server 9.0.1 (W2K)

I'm trying to start/stop the instance remotely and am not succeding.

First it complains about obsolete parameters
JOB_QUEUE_INTERVAL & MTS_DISPATCHERS, but they should not be there since
they are not in the pfile, nor the spfile (both on server)

then it goes on to start the instance, after which it complains about
identifying the controlfiles.

My understanding was that with an spfile I did not have to have a local
copy of the init files


What am I missing here??


TIA


Jack



===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying,  distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst &
Young is neither liable  for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===





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

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

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

Re: RE: Has anyone heard of "Mirror Accessible"?

I hear you.  Some one came up with the idea that 30+
HPUX 10.20, Oracle 7.3.3 systems could be updated to
HPUX 11.x, Oracle 8.1.7 in less than 36 hours, with
only 2 dba's and 2 sysadms, remotely.

I shudder to think of the psychoactive compound
dosages that led to this conclusion.  Oh well, I've
got spare pillows out in the truck, right next to the
postal worker uniform and the uzi...

--S

--- [EMAIL PROTECTED] wrote:
> Ain't being a DBA glamorous???
> 
> Me, I'm just in it because I heard that DBA's get
> all the chicks :)
> 
> Believe me, I feel your pain.  I have more Oracle
> 7.3.4 databases here to upgrade than I can say
> without embarassment.  That's what I get for being
> the new hire. :)
> 
> A fellow DBA,
> Scott Lockhart
> Oracle DBA
> I-Link, Ltd.
> Draper, UT
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: [EMAIL PROTECTED]

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

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

RE: OT : Listers met at OOW

2001-12-06 Thread K Gopalakrishnan


John,

Here is the update from Jonathan Gennick ...

http://oracle.oreilly.com/news/openworld_day3_1201.html


Best Regards,
K Gopalakrishnan


-Original Message-
Sent: Wednesday, December 05, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L

Dear all,

I had promised a few people on the list that I would send an update about
Listers meeting at OOW, so here goes!

A few of us got together at a Chevy's restaurant near Moscone for a chance
to say hello and put a face to a name. This included Steve 'Guru' Adams (yes
- *the* Steve A all the way from Downunder), Rachel 'DBA Godess' Carmichael,
Gaja 'Tuning 101' Vaidyanatha, Kirti 'Tuning 101' Deshpande, Ari 'Pocket
DBA' Kaplan, Steve 'now in Montana' Orr, Jeremiah '[EMAIL PROTECTED]'
Wilton, Kevin 'Tap-key' Toepke, Gopala 'X$' Krishnan, Jonathan 'OReilly'
Gennick, Gerardo 'local@Schwab' Molina and John 'sleepless@SanJose'
Kanagaraj. We did miss Eric 'Google-gunner' Pierce though!

Starting off with a first round of free drinks from Ari (c/o Expand Beyond -
thanks Ari!), everyone settled in to talk and listen and order and eat,
amidst swapping stories of glory and honor and sleepless nights recovering
the Db as well as horror stories of layoffs and interviewing clueless
candidates. Also swapped were details of X$ tables and other UNIX internal
structures (who can do without those!) as well as hunting and other
adventure trips. Ari showed us some cool toys (were there more than two
Pocket PCs on you, Ari?) and we all 'Oohed' and 'Aahed' over them.. Steve
A's birthday was celebrated in usual Chevy's style with the gift of a straw
hat and special birthday-boy dessert (although he claimed that his birthday
was actually today as per Australian time!). That was the signal for us to
start splitting - we would have continued through the night if the
restaurant didn't have to close up

Cheers!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Kill your killer-commute! Listen to great commercial-free christian music
24x7 (details at www.klove.com)

** The opinions and statements above are entirely my own and not
those of my employer or clients **
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

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


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

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

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

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

2001-12-06 Thread YTTRI Lisa


We are using OEM currently on our Oracle environments.  However, we have
about 100 Sybase servers and about 10 Microsoft SQL Server servers in
addition to the 20 or so Oracle instances we have.  There are only 6 of us
supporting all these environments, and not everybody is knowledgeable in all
the dbms'.  What we'd like to get is a proactive monitoring tool that can be
used for all of our databases.  If I could get OEM to monitor the others, I
would!

-Original Message-
Sent: Wednesday, December 05, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L


I have evaluated I/Watch and it was pretty good.  Especially with
Spotlight.  I have actually seen Spotlight help me quickly identify
a problem which I am not sure I could have found so easily with
out the visual picture.  I had both tools for about 3 months but
could not get anyone to agree to the bucks.

Depending on what you are looking for out of OEM it really is not
a bad tool.  It is the one that is the least intrusive on your servers
and you need not create objects in your database for it.  Thing
I learned though is to make sure you set up warnings for email and not
page.  Really annoying when you get paged at 3AM cause a tablespace is
80% full.  Ya, so, tell me tomorrow.  Make sure you do not have alert
log monitoring on for development systems.  If you do you may be
tempted to kill your developers.  It might not be the best tool out
there but if you work with the right versions of Oracle and use the
OEM agents for 8.1.7 or 9i its pretty good.  It does not have those problems
of not being able to deregister and all that fun stuff that existing
in 8.  Don't forget that the agents do not have be the same version as the
database.

-Original Message-
WILLIAMS
Sent: Wednesday, December 05, 2001 8:20 AM
To: Multiple recipients of list ORACLE-L


I appreciate everyone sharing their experiences.

My question on this topic is what tools are appropriate for what
environments? Some tools seem more extensive (and expensive) and therefore
appropriate to sites with many Oracle instances. I am currently responsible
for 5 production instances all at our HQ datacenter. On those rare occasions
when something goes down, some usually quickly contacts me, so I haven't
felt the need for a monitoring tool. However, we are discussing a project to
put servers in a handful of manufacturing plants and they would be more 23x7
situations, so I have been reviewing OEM (it fails a lot more often than the
instance, I'm not about to turn on its remote notification). Naturally
vendors will claim that their product is just ideal for your type of site.
Does anyone have any input on which monitoring tools are appropriate for
sites with a smaller number of Oracle instances? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


I second that, too long to list the problems I had w/ CA Unicenter,
worthless expensive product.  CA touts their product to top management, then
you get the call to implement.  Just my $.02, since you asked :)

Gene

>>> [EMAIL PROTECTED] 12/04/01 08:35PM >>>
CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked to
look at alternatives (I'm sure the cost will be prohibitive, but we'll see).

Also if you know of any comparable tools, I'm very interested to hear about
them.

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

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

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

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

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

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

RE: buffer busy wait & latch free ( cache buffer chain )