newbie

[u.-azmi]

halo all,
i'm a newbie trying to start learnig about oracle
programming
problem is.i don't where to start :(
enlighten pse...

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

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

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

Re: How to increase the number of inserts into a table to 2000 per second

[C.S.Venkata Subramanian]

 Hi u can try the bulk binding feature of Oracle 8i, U can reduce a lot of time in 
inserts update and delete.
--

On Thu, 01 Mar 2001 21:41:03  
 Ranganath K wrote:
>Dear DBA Gurus
>
> I am using Oracle 8.1.6 Work group server on Sun Solaris 2.8.
>I want to increase the number of inserts into a particular table per second
>to 2000 per second. Sun Microsystems claims that with the current hardware
>configuration the number of inserts can go upto 2800 per second.  Currently
>it is only 600 per second.  The insertion is done through a C program using
>OCI with an embedded SQL statement.  I am using a SunE4500 machine with  130
>gb hard disk, 4gb RAM and 4  Sparc CPU machine.  Please let me know as to
>how do I increase the number of inserts into that table as we require to
>implement the same into our application.  Any help in this regard will be
>higly appreciated.
>
>TIA and regards,
>
>Ranganath
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Ranganath K
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

svrmgrl ...only startup command not working

[Deepender_Gupta]

Hi all,
This is a special problem I am facing and hence I am not able to start my
database also..
At the svrmgrl prompt when I give
svrmgrl > startup
it suddenly comes on a $ promp and does not gives any error also
but when I give a wrong ORACLE_SID in the environment then it search for
the corresponding init parameter file and gives error.
I have removed all the extra parameters from the  init file and only needed
minimal parameters are there...I am not able to start my database...please
help meto come out of the problem..
Regds
Deepender




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

Rollback segment

[sinardyxing]

Hi,

Anyone have idea, how Oracle8i make used of multiple rollback segments to
reduce system contention?
I am currently using 4 rollback segments what will happen if 3 of them are
offline?
 :<(

Thanxs,

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

Pro*C ? segmentation fault (core dumped)...

[contact_me]

Hiii all, 

i'm a  real newbie using Pro*C, but i find it hard to precompile because i always
get a message : "segmentation fault (core dump)" when i try to precompile samples
shipped with Oracle. I'm using Oracle 8.1.6 on RedHat 6.2, egcs ver 2.91-66


is it 'bout memory or environment ...?
if it is.. how to ?

Does anyone have a clue 'bout this or maybe ever experience the same problem
? Please let me know


Please.

Ramada
Student


PS: Hampir lupa, kamu sudah punya pacar belum? Mau temenin aku Cari Cinta ngga di 
www.naver.co.id?

Get your free E-mail account at http://www.detik.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

pro*c compilation : core dumped ?

[contact_me]

Hii all,

im a real newbie trying to learn 'bout Pro*c, i've installed the Oracle 8.1.6
on Linux Redhat 6.2. But when i do : proc iname=select.pc oname=select.c or

$ make -f demo_proc.mk build OBJS=select.o EXE=select
it gives me a message : segmentation fault (core dump)

does anyone here ever experience the same thing ? 
please. 



PS: Hampir lupa, kamu sudah punya pacar belum? Mau temenin aku Cari Cinta ngga di 
www.naver.co.id?

Get your free E-mail account at http://www.detik.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

svrmgrl vs sys account

[sinardyxing]

Hi, 
I am a beginner DBA could you tell me
what is the diffrent:
create user /tablespace or else using 
svrmgrl>
and sys account
oh ya.. I'm using Oracle8i

Thank you very much

-- 
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: DBMS_JOB -- urgent !!!

[Gunawan Yuwono]

My $.02:
There are two ways (that I know of):
1. The long way: create different jobs for each day like:
   INTERVAL = 'NEXT_DAY(TRUNC(SYSDATE),''MONDAY'') + 22/24'
   INTERVAL = 'NEXT_DAY(TRUNC(SYSDATE),''TUESDAY'') + 22/24'

2. Create another stored procedure and submit it as a job (Note I didn't test
the following stored procedure, but you should get the idea):
   CREATE OR REPLACE PROCEDURE RUN_JOB
   AS
  v_day   VARCHAR2(10);
   BEGIN
  SELECT TO_CHAR(SYSDATE, 'DAY') INTO v_day FROM dual;

  IF v_day != 'SUNDAY' THEN
 ;
  END IF;

  EXCEPTION
WHEN OTHERS THEN
;
RAISE;
   END;
   /

And submit this stored procedure as a job everyday at 10 PM:
   INTERVAL = 'TRUNC(SYSDATE + 1) + 22/24'

Does this make sense?

HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, USA

--- Pablo ksksksk <[EMAIL PROTECTED]> wrote:
> Hi list,
> I need to cron a job every day at 10pm except
> sundays, how do I acomplish this ? I need the INTERVAL
> field.
> 
> I also need to cron another job every day except
> sundays an saturdays too, can you please help me with
> this? 
> 
> thanks in advance.
> 
> ___
> Do You Yahoo!?
> Envía mensajes instantáneos y recibe alertas de correo con 
> Yahoo! Messenger - http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gunawan Yuwono
  INET: [EMAIL PROTECTED]

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

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

.trc file management

[Hagedorn, Linda]

Title: .trc file management 





Has anyone written and is willing to share a shell which would: 


find the list of .trc files, tkprof the files to output files, grep the output files for the total line and email the file of total lines?   

And 


find the current .trc files and rm the ones older than 15 minutes?  (I can do dates, but need help with time).  


Any information or referrals to documentation is appreciated. 


Thanks, Linda

RE: PL/SQL Debug tools

[schmoldt]

Oracle's Procedure Builder has a basic debugger, and you probably already
have it if you use Forms and Reports.

> -Original Message-
> From: Venugopalan Nair C.N Nair [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 4:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject: PL/SQL Debug tools
> 
> 
> Hi,
> I a looking for some debuging tools for Pl/Sql in
> windows Environment. 
> 
> If any sugetions will be apreciated.
> 
> Thanks and Regards
> Venu G Nair
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Venugopalan Nair C.N Nair
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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).

PL/SQL Debug tools

[Venugopalan Nair C.N Nair]

Hi,
I a looking for some debuging tools for Pl/Sql in
windows Environment. 

If any sugetions will be apreciated.

Thanks and Regards
Venu G Nair

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Venugopalan Nair C.N Nair
  INET: [EMAIL PROTECTED]

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

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

[Dirk Gomez]

Yes, I have worked a while with Intermedia and I find it very easy to use and
very awful to administer. Its tight integration with Oracle is its main beauty
of course.

This as was a typo, I meant to ask: How good is Excalibur at sucking content
from Oracle schemas? Is there a required format for access control lists?

So you export all the data and the access control lists to some Excalibur
repository and do the searches there? 

cheers Dirk

"Gary Weber" <[EMAIL PROTECTED]> writes:

> Dirk,
> 
> Here at my site, it was decided to abandon InterMedia. I think the main
> reason was the lack of developers capable of supporting it. Excalibur's
> search engine is being considered as alternative, but from my limited
> exposure to the project I understand that it has limitations in handling
> BLOB/CLOB fields, at least at the current release level. Btw, in direct
> response to one of your questions: Intermedia index does NOT suck the
> content out of Oracle, but rather is stored INSIDE of Oracle, where it can
> be happily utilized, maintained and abused. Excalibur, on the other hand,
> "scans" Oracle and builds its indexes elsewhere. Watch out for time required
> by Excalibur to index Oracle tables, rebuild existing indexes, and take into
> consideration mechanism required to keep existing Excalibur indexes
> current - triggers'r'us.
> 
> Gary
> 
> -Original Message-
> Sent: Friday, March 02, 2001 3:47 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi folks,
> 
> I'll be working on a project pretty soon where I will have to use
> Excalibur. The goals are:
> 
> - integrating the contents of my database with the company-wide running
>   Excalibur. Questions: How good is Intermedia at sucking content from
> Oracle
>   schemas? Is there a required format for access control lists? I know
> there's
>   a gateway and I suppose this is pretty straight forward.
> 
> - for some reason I'll even have to replace Intermedia with Excalibur. Any
>   thoughts on this?
> 
> cheers Dirk
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dirk Gomez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Gary Weber
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dirk Gomez
  INET: [EMAIL PROTECTED]

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

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

ORA-12537 question

[Joseph S. Testa]

Ok anyone seen this error.

here is the scenario:

dev box - firewall - internet - prod db server

on the prod db server, protocol.ora is enabled to screen only legit ip
addys.

connect from dev box w/sqlplus and get a 12537 error, 

solaris, 8.1.5 on both dev and prod.

PC attempted also, 8.1.5 client.

all get the same error.

thanks, joe

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

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

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

RE: Removing files with PL/SQL

[John Lewis]

Sure.

use utl_file utility. 
Write to a file , that another process reads, have it execute the command.
Minor security hole but, it will work. Need to make parse strings so nothing

'bad' gets written to the file.

Or

Have a process, read a table that has files to be deleted ( we use this in
house)

-Original Message-
Sent: Friday, March 02, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


Good suggestion, but 'host' only works within SQLPLUS (unless I am
mistaken).  Any other ideas?

Alan

-Original Message-
Sent: Friday, March 02, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


How about the host command. This will shell out to the os and process the
command.

host erase c:\my_dir\my_file.txt

>>> <[EMAIL PROTECTED]> 03/02/01 02:32PM >>>
Hey listers,

Does anyone know of a way to remove files from an O/S file system using
PL/SQL without calling a java or an external C routine?

Thanks,

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
(303)-858-6394
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

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

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

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

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

RE: OEM 2.2. installation blues

[Jesse, Rich]

I've actually had a couple other requests to expound upon that, so here
'tis:

Nope, iFS is not working fine, which is why I've shut it down.  I've got
8.1.7 on order (should have been here days ago!) for a couple of other
platforms, so I'll be able to move the database off of my machine, and
attempt to once again re-install as a three-tier, instead of a two-tier.
The last time took me 4 weeks and 2 TARs to get it installed!  And I still
couldn't get JWS to run correctly.

My first problem is that I had already installed OEM v2.2 on my PC.  This
apparently is not a valid option.  Because iFS requires an 8.1.7 install, I
installed that in a different ORACLE_HOME, but it wouldn't let me install
OEM client required by iFS into the same ORACLE_HOME as it was already
installed in another.  And there's no way around it.  Oracle Support told me
to deinstall all Oracle products, including OEM, and reinstall them in a
single ORACLE_HOME.  They also told me that I wouldn't lose anything by
deinstalling OEM, since everything is in the repository DB.  But they forgot
to tell me that some of my custom backgrounds were stored there (and I
forgot, too), so I lost those.  Anyway, I reinstalled everything into the
same ORACLE_HOME, and fired up iFS.  After a major struggle with the 4 or 5
default passwords for different things, I finally got it to work in a
completely unsecured manor.  I never was able to secure it.  Anyone could
login and read/write to anyone else's directory.  And since the Java Web
Server never worked (503 errors when the webpage was surfed to), I will
reinstall again using the three-tier model (database is on another machine),
once the DB software arrives.

iFS has been a major pain for me-- very little documentation, and what
documentation there is seems to serve as a reference guide, as though you
already know the product, instead of a tutorial.  Kinda interesting concept
for an installation manual...

My $.02.

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

> -Original Message-
> From: Don Jerman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 15:46
> To: Multiple recipients of list ORACLE-L
> Subject: Re: OEM 2.2. installation blues
> 
> 
> We're struggling with iAS/ iFS now with a similar box (only 
> it's a leftover quad 400,
> 2GB mem from an appserver upgrade), could you elaborate on 
> the "TWICE" part?
> 
> "Jesse, Rich" wrote:
> 
> > Hi Patrice,
> >
> > I've successfully installed OEM 2.2 *TWICE* (thanks to 
> Oracle Support for
> > telling me that it was the only freaking way to get iFS 
> installed on the
> > same box...) on my P-III 800Mhz running Win2K ("WinTuke") 
> with SP1 and 512MB
> > memory.  You don't mention where your repository DB is, 
> however.  My DB is
> > an O8.0.5.0.1 on an OpenVMS box, which frees up about 200MB 
> of mem for me.
> >
> > I haven't had any problems regarding the installation.  
> It's just AFTER the
> > install that I run into chaos and mayhem.  Stupid events 
> won't deregister...


---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle Licensing

[Don Jerman]

Last time I danced with our sales rep, power units were per server, not per
user...  so the power unit price would be 400*100 = 40,000 for an unlimited (Ha!
at 200mhz?) number of users.  If you ask nicely, yours may agree to convert any
concurrent or named user licenses you have into power unit credits.

Dennis Taylor wrote:

> At 06:25 AM 3/2/01 -0800, you wrote:
> >the mire.  At any rate, there are suppose to be two basic licensing
> schemes, and
> >GOD only knows how many "allowed" permutations:
> >
> >1) Power Units which equates to the number of processors times the
> speed of
> >the processors in Megahertz.  Oh, BTW: it matters if their Intel or Risc
> >processors too.  Risc processors are more expensive.  In general this is the
> >MOST expensive way to go.
> >
>
> I went to the oracle site and did some calcs for adding users to Oracle
> Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of
> megahertz". Anyway, for a very behind-the-curve system (2x200mhz
> ppro's), it works out to $4000 per additional user.
>
> Or I can look at Interbase/Firebird, which is free.
>
> Today I will be assigning one of my staff the task of downloading,
> installing, and evaluating Firebird.
>
> The only way I can imagine that Oracle thinking can be going is: "Hey,
> revenues are dropping because of competition from free and less expensive
> dbms's". "No problem. Raise prices to make up the shortfall". Then I say to
> myself, "Naw, no-one can be that stupid". Then I check the per-user prices
> again
>
> Dennis Taylor
> 
> Good we must love, and must hate ill,
> For ill is ill, and good good still.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dennis Taylor
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: OEM 2.2. installation blues

[Don Jerman]

We're struggling with iAS/ iFS now with a similar box (only it's a leftover quad 400,
2GB mem from an appserver upgrade), could you elaborate on the "TWICE" part?

"Jesse, Rich" wrote:

> Hi Patrice,
>
> I've successfully installed OEM 2.2 *TWICE* (thanks to Oracle Support for
> telling me that it was the only freaking way to get iFS installed on the
> same box...) on my P-III 800Mhz running Win2K ("WinTuke") with SP1 and 512MB
> memory.  You don't mention where your repository DB is, however.  My DB is
> an O8.0.5.0.1 on an OpenVMS box, which frees up about 200MB of mem for me.
>
> I haven't had any problems regarding the installation.  It's just AFTER the
> install that I run into chaos and mayhem.  Stupid events won't deregister...
>
> Good luck!  :)
>
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
>
> > -Original Message-
> > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 01, 2001 07:55
> > To: Multiple recipients of list ORACLE-L
> > Subject: OEM 2.2. installation blues
> >
> >
> > Hi,
> >
> > Has anyone successfully installed OEM 2.2. on their machine?
> >
> > My test server has 256M more RAM coming, but in the meantime
> > I haven't given
> > up hope.  Although hope is dwindling... I only have 380M of RAM.
> >
> > I started the installation process, then went to talk to
> > someone.  When I
> > returned there was a Blue Screen of Death waiting for me.
> >
> > After powering off and powering on my machine, Peak Memory usage on my
> > machine is at 680M of memory!  Is this NT going crazy or does
> > the Oracle
> > Universal Installer really need that much memory to install
> > OEM 2.2.?  Could
> > there be a creeping memory leak in the Universal Installer?
> > (make that a
> > galloping memory leak)
> >
> > I allocated 1G of virtual memory, but I know from experience
> > on this machine
> > at least that NT can't handle virtual memory very well, it keeps blue
> > screening when I exceed available physical memory by too much.
>
> ---
>
> This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

RE: Removing files with PL/SQL

[alan . aschenbrenner]

Good suggestion, but 'host' only works within SQLPLUS (unless I am
mistaken).  Any other ideas?

Alan

-Original Message-
Sent: Friday, March 02, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


How about the host command. This will shell out to the os and process the
command.

host erase c:\my_dir\my_file.txt

>>> <[EMAIL PROTECTED]> 03/02/01 02:32PM >>>
Hey listers,

Does anyone know of a way to remove files from an O/S file system using
PL/SQL without calling a java or an external C routine?

Thanks,

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
(303)-858-6394
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

3/2/01 - ORA-01767 on UPDATE

[Gorden-Ozgul, Patricia E]

Here's my code

update copy_rec_out_test
set
(copy_rec_out_test.sirsi_949m,
copy_rec_out_test.sirsi_949l,
copy_rec_out_test.sirsi_949k,
copy_rec_out_test.sirsi_949t,
copy_rec_out_test.sirsi_949x,
copy_rec_out_test.sirsi_949z)
=
select  (matrix.sirsi_949m,
matrix.sirsi_949l,
matrix.sirsi_949k,
matrix.sirsi_949t,
matrix.sirsi_949x,
matrix.sirsi_949z)
where
(matrix.libr_key,
matrix.avlb,
matrix.mtype,
matrix.ctype)
=
(copy_rec_out_test.libr_key,
copy_rec_out_test.avlb,
copy_rec_out_test.mtype,
copy_rec_out_test.ctype)
where exists
(select 1 from matrix
where
(matrix.libr_key,
matrix.avlb,
matrix.mtype,
matrix.ctype)
=
(copy_rec_out_test.libr_key,
copy_rec_out_test.avlb,
copy_rec_out_test.mtype,
copy_rec_out_test.ctype)
/
..

I'm getting ORA_01767: UPDATE ...SET expression must be a subquery on
execution.

Have you any idea what I'm doing wrong?
Much appreciated.

Pat

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


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

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

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

AW: DBMS_JOB -- urgent !!!

[Haunschmidt Andreas VASL/FAS]

Hi!

Create a function:

create or replace 
function all_days_except_sat_sun (iDate IN date)
return date
is
  oDate date;
begin
   select decode ( 
   to_number(to_char(iDate,'D')),
 1, iDate+1, -- if Sunday   then delay to Monday
   7, iDate+2, -- if Saturday then delay to Monday ***
 iDate) -- default new date
   into oDate from dual;
   return oDate;
end;
/


-- Test for function all_days_except_sat_sun 

set serveroutput on
declare
 adate := trunc(sysdate); -- start point
 ndate;   -- new calculated date
 hnumber := 22;   -- start hour
 xdate;   -- date to execute
 d1 varchar2(10); -- for the day name
 d2 varchar2(10); -- for the day name
  /*
  SUNDAY   1
  MONDAY   2
  TUESDAY  3
  WEDNESDAY4
  THURSDAY 5
  FRIDAY   6
  SATURDAY 7
  */

begin
-- 14 day check
for i in 0..13 loop
  n := a + i + h/24; -- calculate new date
  x:=all_days_except_sat_sun(n); -- correct execution date

  select to_char(n,'DAY') into d1 from dual;
  select to_char(x,'DAY') into d2 from dual;
  dbms_output.put_line(n || ' DAY ' || d1 || ' -> ' || x || ' DAY:' || d2);
end loop;
end;
/




So you could specify for the job's interval

'all_days_except_sat_sun(trunc(sysdate)+22/24))'

For jobs to run except Sunday just create a 2nd function
and remove the line marked with ***

Hope this helped

Andreas.

> --
> Von:  Pablo ksksksk[SMTP:[EMAIL PROTECTED]]
> Gesendet: Freitag, 2. März 2001 19:45
> An:   Multiple recipients of list ORACLE-L
> Betreff:  RE: DBMS_JOB -- urgent !!!
> 
> 
> Thanks for answering
> 
> That's not what I'm looking for, I don't want to do it
> with UNIX crontab.
> 
> I need to do it by using DBMS_JOB package !!!
> 
> 
> 
> 
> 
> 
> --- [EMAIL PROTECTED] escribió: > use
> 1-6 for every day except Sunday and
> > 1-5 for every day except Saturday and Sunday.
> > Days in cron are labelled 0-6, starting with Sunday,
> > respectively.
> > 
> > i.e., 
> > 
> > 00 17 * * 1-6 /opt/oracle/admin/scripts/
> > 00 17 * * 1-5 /opt/oracle/admin/scripts/
> > 
> > --Scott Shafer
> >   San Antonio, TX
> > 
> > > -Original Message-
> > > From: Pablo ksksksk [SMTP:[EMAIL PROTECTED]]
> > > Sent: Friday, March 02, 2001 8:51 AM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  DBMS_JOB -- urgent !!!
> > > 
> > > Hi list,
> > > I need to cron a job every day at 10pm except
> > > sundays, how do I acomplish this ? I need the
> > INTERVAL
> > > field.
> > > 
> > > I also need to cron another job every day
> > except
> > > sundays an saturdays too, can you please help me
> > with
> > > this? 
> > > 
> > > thanks in advance.
> > > 
> > >
> >
> ___
> > > Do You Yahoo!?
> > > Envía mensajes instantáneos y recibe alertas de
> > correo con 
> > > Yahoo! Messenger - http://messenger.yahoo.es
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > -- 
> > > Author: =?iso-8859-1?q?Pablo=20ksksksk?=
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- (858) 538-5051 
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (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!?
> Envía mensajes instantáneos y recibe alertas de correo con 
> Yahoo! Messenger - http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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

RE: Integrating Excalibur with an Oracle-based application

[Gary Weber]

Dirk,

Here at my site, it was decided to abandon InterMedia. I think the main
reason was the lack of developers capable of supporting it. Excalibur's
search engine is being considered as alternative, but from my limited
exposure to the project I understand that it has limitations in handling
BLOB/CLOB fields, at least at the current release level. Btw, in direct
response to one of your questions: Intermedia index does NOT suck the
content out of Oracle, but rather is stored INSIDE of Oracle, where it can
be happily utilized, maintained and abused. Excalibur, on the other hand,
"scans" Oracle and builds its indexes elsewhere. Watch out for time required
by Excalibur to index Oracle tables, rebuild existing indexes, and take into
consideration mechanism required to keep existing Excalibur indexes
current - triggers'r'us.

Gary

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


Hi folks,

I'll be working on a project pretty soon where I will have to use
Excalibur. The goals are:

- integrating the contents of my database with the company-wide running
  Excalibur. Questions: How good is Intermedia at sucking content from
Oracle
  schemas? Is there a required format for access control lists? I know
there's
  a gateway and I suppose this is pretty straight forward.

- for some reason I'll even have to replace Intermedia with Excalibur. Any
  thoughts on this?

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

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

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

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

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

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

Anyone Seen this? ACC_TRIGGER problem

[Dave Morgan]

Hi All,
Anyone have a clue? Seen it before?

Completed checkpoint up to RBA [0x20f.2.10], SCN: 0x.00665693
Thu Feb 22 13:16:16 2001
Errors in file /home/oracle/SCQQQI/bdump/pmon_47776_scqqqi.trc:
ORA-00600: internal error code, arguments: [kssdys 2: bad ch], [0],
[807311928], [0], [806153868], [], [
], []
ORA-00601: cleanup lock conflict
ORA-01401: inserted value too large for column
ORA-06512: at "SYS.ACC_TRIGGER", line 5
ORA-04088: error during execution of trigger 'SYS.ACC_TRIGGER'
Thu Feb 22 13:16:16 2001
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 47776

Oracle 8.1.6.2, AIX 4.3.3

It's not really important, on my development database,
damagement doesn't need Oracle support :{, but I still care.

Why? Cause they pay me and deserve my loyalty.

See next post for off-topic looking for work spam :)

I know I should spend the time to investigate but the 
list is so much easier. 
TIA
Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: [EMAIL PROTECTED]

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

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

Integrating Excalibur with an Oracle-based application

[Dirk Gomez]

Hi folks,

I'll be working on a project pretty soon where I will have to use
Excalibur. The goals are:
 
- integrating the contents of my database with the company-wide running
  Excalibur. Questions: How good is Intermedia at sucking content from Oracle
  schemas? Is there a required format for access control lists? I know there's
  a gateway and I suppose this is pretty straight forward.

- for some reason I'll even have to replace Intermedia with Excalibur. Any
  thoughts on this?

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

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

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

[Seley, Linda]

I've actually got two copies of the CDs.  S'pose the other set'll make nice
coasters.  The first set came pretty fast from customer service, 3 or 4
business days.  It was a rush order because we needed it before the demo
that Oracle sales was coming to do for us.  The second copy I got from our
sales guy when he found out we didn't have it yet.  

Linda

-Original Message-
Sent: Friday, March 02, 2001 7:36 AM
To: Multiple recipients of list ORACLE-L


Linda,
 Where did you get the CD's for the 9iAS? I tried the download method and
"FileSplit" them back together. No luck. WinZip reported the file was
corrupt. I tried the download method twice but still no luck. How long did
you have to wait for the CD's to arrive in smailmail? If you downloaded,
what site did you use? I tried from the OTN site to get the files.
ROR mª¿ªm



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

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

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

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

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

[Bill Pribyl]

> Does anyone know of a way to remove files from an O/S file system using
> PL/SQL without calling a java or an external C routine?

Hmm...how about this:

1. use UTL_FILE to append the filename to a list of files
2. use a scheduler (cron or equiv) to remove the files in the list and delete
them from the list

Probably not what you're looking for...

Bill
--

__
http://www.datacraft.com/http://plnet.org/


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

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

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

[Ron Rogers]

Ruth,
 Pleas be carefull with the pricing offerred. I understand the quality of home grown 
beef and your price is lower than the chain supermarket in Atlanta.
Does the offer include the people in the South??? (transplanted Yankee)

ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/02/01 02:39PM >>>
$4.50 a pound plus shipping and I will send them overnight, just like Omaha
Steaks.

;-) Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 2:16 PM


> Talk is cheap Ruth!!! Put up or shut up!!!
>
> I like mine medium rare by the way.
>
>
>
> -Original Message-
> Sent: Friday, March 02, 2001 1:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I used to buy Omaha steaks, but our home raised is even better than that.
> RBG
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 02, 2001 10:56 AM
>
>
> > It you want great corn feed beef (the reason for mad
> > cow is how they feed their livestock) visit the Omaha
> > Steaks web page.
> >
> > The US should never have any of these problems.  We
> > feed our cattle with grains such as corn.  We should
> > not have a problem with hoof and mouth because we
> > vaccinate our cattle against such diseases.
> > --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > > I don't think that the experts are telling anyone
> > > that Mad Cow Disease is
> > > not transferrable to humans.  It causes death in
> > > humans and cannot be killed
> > > by cooking at normal temperature.
> > >
> > > Hoof and Mouth disease is not transferrable to
> > > humans and should not be
> > > confused with the common human affliction Foot in
> > > Mouth disease.
> > >
> > > It is the former that may destroy the livestock
> > > industry  in Europe and lead
> > > to turning lots of folks into vegetarians.
> > >
> > > We raise our own beef so I am not going to turn into
> > > a vegetarian.
> > >
> > > Ruth
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L"
> > > <[EMAIL PROTECTED]>
> > > Sent: Friday, March 02, 2001 7:10 AM
> > >
> > >
> > > > Rachel,
> > > >
> > > > The "experts" tell us that the disease only
> > > affects certain animals but
> > > not
> > > > humans, even if you eat meat contaminated with
> > > disease.  I'm not
> > > enlightened
> > > > enough one way or the other to become a vegetarian
> > > as a consequence %-|
> > > >
> > > > Sean :)
> > > >
> > > > Rookie Data Base Administrator
> > > > [0%] OCP Oracle8i DBA
> > > > [0%] OCP Oracle9i DBA
> > > > 
> > > > Organon (Ireland) Ltd.
> > > > http://www.organon.ie 
> > > > E-mail: [EMAIL PROTECTED]   [subscribed:
> > > Digest Mode]
> > > >
> > > > Visit:
> > > http://groups.yahoo.com/group/Oracle-OCP-DBA 
> > > >
> > > > "They tell me nothing, but expect me to know
> > > everything!"
> > > >
> > > >
> > > > --
> > > >
> > > >  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
> > > >  Date: Thu, 01 Mar 2001 14:23:33 -
> > > >  Subject: RE: eek!
> > > >
> > > > Sean,
> > > >
> > > > I read about that crash this morning --
> > > horrifying!  And they are saying
> > > > there is something like $1 billion worth of damage
> > > from the quake. My
> > > > friends in Gresham (Oregon) felt it as well.
> > > >
> > > > You going to become a vegetarian based on the
> > > animal diseases raging over
> > > > there?
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com 
> > > > --
> > > > Author: O'Neill, Sean
> > > >   INET: [EMAIL PROTECTED] 
> > > >
> > > > Fat City Network Services-- (858) 538-5051
> > > FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet
> > > access / Mailing Lists
> > > >
> > >
> > 
> > > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > > removed from).  You may
> > > > also send the HELP command for other information
> > > (like subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com 
> > > --
> > > Author: Ruth Gramolini
> > >   INET: [EMAIL PROTECTED] 
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX:
> > > (858) 538-5051
> > > San Diego, California-- Public Internet
> > > access / Mailing Lists
> > >
> > 
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from).  You may

Re: Removing files with PL/SQL

[William Beilstein]

How about the host command. This will shell out to the os and process the command.

host erase c:\my_dir\my_file.txt

>>> <[EMAIL PROTECTED]> 03/02/01 02:32PM >>>
Hey listers,

Does anyone know of a way to remove files from an O/S file system using
PL/SQL without calling a java or an external C routine?

Thanks,

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
(303)-858-6394
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

Re: RE: eek! completely off topic

[Ruth Gramolini]

$4.50 a pound plus shipping and I will send them overnight, just like Omaha
Steaks.

;-) Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 2:16 PM


> Talk is cheap Ruth!!! Put up or shut up!!!
>
> I like mine medium rare by the way.
>
>
>
> -Original Message-
> Sent: Friday, March 02, 2001 1:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I used to buy Omaha steaks, but our home raised is even better than that.
> RBG
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 02, 2001 10:56 AM
>
>
> > It you want great corn feed beef (the reason for mad
> > cow is how they feed their livestock) visit the Omaha
> > Steaks web page.
> >
> > The US should never have any of these problems.  We
> > feed our cattle with grains such as corn.  We should
> > not have a problem with hoof and mouth because we
> > vaccinate our cattle against such diseases.
> > --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > > I don't think that the experts are telling anyone
> > > that Mad Cow Disease is
> > > not transferrable to humans.  It causes death in
> > > humans and cannot be killed
> > > by cooking at normal temperature.
> > >
> > > Hoof and Mouth disease is not transferrable to
> > > humans and should not be
> > > confused with the common human affliction Foot in
> > > Mouth disease.
> > >
> > > It is the former that may destroy the livestock
> > > industry  in Europe and lead
> > > to turning lots of folks into vegetarians.
> > >
> > > We raise our own beef so I am not going to turn into
> > > a vegetarian.
> > >
> > > Ruth
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L"
> > > <[EMAIL PROTECTED]>
> > > Sent: Friday, March 02, 2001 7:10 AM
> > >
> > >
> > > > Rachel,
> > > >
> > > > The "experts" tell us that the disease only
> > > affects certain animals but
> > > not
> > > > humans, even if you eat meat contaminated with
> > > disease.  I'm not
> > > enlightened
> > > > enough one way or the other to become a vegetarian
> > > as a consequence %-|
> > > >
> > > > Sean :)
> > > >
> > > > Rookie Data Base Administrator
> > > > [0%] OCP Oracle8i DBA
> > > > [0%] OCP Oracle9i DBA
> > > > 
> > > > Organon (Ireland) Ltd.
> > > > http://www.organon.ie
> > > > E-mail: [EMAIL PROTECTED]   [subscribed:
> > > Digest Mode]
> > > >
> > > > Visit:
> > > http://groups.yahoo.com/group/Oracle-OCP-DBA
> > > >
> > > > "They tell me nothing, but expect me to know
> > > everything!"
> > > >
> > > >
> > > > --
> > > >
> > > >  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
> > > >  Date: Thu, 01 Mar 2001 14:23:33 -
> > > >  Subject: RE: eek!
> > > >
> > > > Sean,
> > > >
> > > > I read about that crash this morning --
> > > horrifying!  And they are saying
> > > > there is something like $1 billion worth of damage
> > > from the quake. My
> > > > friends in Gresham (Oregon) felt it as well.
> > > >
> > > > You going to become a vegetarian based on the
> > > animal diseases raging over
> > > > there?
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: O'Neill, Sean
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051
> > > FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet
> > > access / Mailing Lists
> > > >
> > >
> > 
> > > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > > removed from).  You may
> > > > also send the HELP command for other information
> > > (like subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX:
> > > (858) 538-5051
> > > San Diego, California-- Public Internet
> > > access / Mailing Lists
> > >
> > 
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from).  You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > =
> > Regards,
> > Linda Miller-Coker
> > My Ebay auctions are at:
> >
>
http://cgi6.ebay.com/aw-cgi/eBayISAPI.dll?ViewListedItems&userid=tazmacc&inc
> lude=0&since=-1&sort=2&rows=25
> > Also visi

Re: DataWarehouse Configuration

[Paul Parker]

Hi Bill,

Is 200GB the total size of the database?  If so,
have you considered only loading "new" data into
production?  

Paul

--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> Some data warehousing questions:
> 
> We are considering a setup where we have two
> separate machines,
> 1 for doing the ETL
> (ExtractTransformLoad)processing, and 1 for
> the production machine. Our env is Oracle 8.1.6
> on Sun.
> The main idea is to insulate the production
> machine from the effects
> of ETL processing; the only impact ETL would
> have on the production
> machine would be when the ETL has completed and
> the data is copied
> over to the production machine, which leads me
> to my question:
> what methods have been used to minimize the
> time needed for this copy step?
> 
> The amount of data to be transferred would be
> around 200GB, but expected
> to grow very fast.
> Both machines would be part of an existing
> ethernet network, and we've
> considered the following:
> 1) Just do the transfer over the existing
> ethernet network (figure about
>150GB/hour)
> 2) Position the machines close to each other,
> and run a short (6-foot or less)
>cable between serial ports or parallel ports
> on both machines
> 3) Set up a separate network; install an
> ethernet card in each machine, and
>connect them with ethernet
> 4) Go to a "disk-farm" setup - don't know a lot
> about this, but both machines
>would access subsets of a large shared disk
> array (is this EMC? or other vendors?)
> 
> The consensus is that fiberoptic, although
> faster, would be a waste since
> then the limiting factor would be disk read and
> write speeds.
> 
> Anyway, I would appreciate any
> comments/suggestions regarding the above,
> especially #4, and any other approaches.
> Thanks to any responders.
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Bill Becker
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send
> an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling
> of 'ListGuru') and in
> the message BODY, include a line containing:
> UNSUB ORACLE-L
> (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 email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Parker
  INET: [EMAIL PROTECTED]

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

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

[ODell, Charles]

Talk is cheap Ruth!!! Put up or shut up!!!

I like mine medium rare by the way.



-Original Message-
Sent: Friday, March 02, 2001 1:34 PM
To: Multiple recipients of list ORACLE-L


I used to buy Omaha steaks, but our home raised is even better than that.
RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:56 AM


> It you want great corn feed beef (the reason for mad
> cow is how they feed their livestock) visit the Omaha
> Steaks web page.
>
> The US should never have any of these problems.  We
> feed our cattle with grains such as corn.  We should
> not have a problem with hoof and mouth because we
> vaccinate our cattle against such diseases.
> --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > I don't think that the experts are telling anyone
> > that Mad Cow Disease is
> > not transferrable to humans.  It causes death in
> > humans and cannot be killed
> > by cooking at normal temperature.
> >
> > Hoof and Mouth disease is not transferrable to
> > humans and should not be
> > confused with the common human affliction Foot in
> > Mouth disease.
> >
> > It is the former that may destroy the livestock
> > industry  in Europe and lead
> > to turning lots of folks into vegetarians.
> >
> > We raise our own beef so I am not going to turn into
> > a vegetarian.
> >
> > Ruth
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Friday, March 02, 2001 7:10 AM
> >
> >
> > > Rachel,
> > >
> > > The "experts" tell us that the disease only
> > affects certain animals but
> > not
> > > humans, even if you eat meat contaminated with
> > disease.  I'm not
> > enlightened
> > > enough one way or the other to become a vegetarian
> > as a consequence %-|
> > >
> > > Sean :)
> > >
> > > Rookie Data Base Administrator
> > > [0%] OCP Oracle8i DBA
> > > [0%] OCP Oracle9i DBA
> > > 
> > > Organon (Ireland) Ltd.
> > > http://www.organon.ie
> > > E-mail: [EMAIL PROTECTED]   [subscribed:
> > Digest Mode]
> > >
> > > Visit:
> > http://groups.yahoo.com/group/Oracle-OCP-DBA
> > >
> > > "They tell me nothing, but expect me to know
> > everything!"
> > >
> > >
> > > --
> > >
> > >  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
> > >  Date: Thu, 01 Mar 2001 14:23:33 -
> > >  Subject: RE: eek!
> > >
> > > Sean,
> > >
> > > I read about that crash this morning --
> > horrifying!  And they are saying
> > > there is something like $1 billion worth of damage
> > from the quake. My
> > > friends in Gresham (Oregon) felt it as well.
> > >
> > > You going to become a vegetarian based on the
> > animal diseases raging over
> > > there?
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: O'Neill, Sean
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =
> Regards,
> Linda Miller-Coker
> My Ebay auctions are at:
>
http://cgi6.ebay.com/aw-cgi/eBayISAPI.dll?ViewListedItems&userid=tazmacc&inc
lude=0&since=-1&sort=2&rows=25
> Also visit my Yahoo Classifieds at:
> classifieds.yahoo.com (No bidding just buying!!!)
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Linda Miller Coker
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> -

Removing files with PL/SQL

[alan . aschenbrenner]

Hey listers,

Does anyone know of a way to remove files from an O/S file system using
PL/SQL without calling a java or an external C routine?

Thanks,

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
(303)-858-6394
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

help for SQL query ... start with connect by ....

[Kumar, Dharminder]

SQL> desc tbl_mgr
 Name  Null?Type
 - 

 MANAGERVARCHAR2(30)
 PROFILEID  NUMBER(3)
 PARENTID   NUMBER(3)

I am running the following query on the table.

select rpad(' ',level*20,' ')||Manager manager1,parentid,profileid 
 from tbl_mgr 
start with parentid = 0 
connect by  prior profileid= parentid  ;

and get the following result.

MANAGER1PARENTIDPROFILEID
   MSS  0   1   
  Bursh 1   2
 O Donnell  2   617
 Bursh Own  2   618
 Aursh Own  2   619
  Stredde   1   3



Now my requirement is that I want the output to be like mentioned bellow.

MANAGER1PARENTIDPROFILEID
   MSS  0   1   
  Bursh 1   2
 Aursh Own  2   619
 Bursh Own  2   618
 O Donnell  2   617

  Stredde   1   3

I mean that for level three managers the output should be sorted by manager
name.
And I want this to be accomplished by a SQL query only..

Thanks.

Dharminder Kumar


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

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

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

RE: 8.1.6.0 install problem - SOLVED! (maybe)

[blair]

Thanks for the help everyone.  The Oracle techrep solved the problem.  He asked
me to do 

lslpp -l all |grep libm

after this he saw that we did not have the math library installed.

thanks all,

..tom


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 11:57 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE:8.1.6.0 install problem
> 
> Tom,
> 
> Please set LIB_PATH (some thing like that )=/usr/lib  in your .profile before
> linking.LD_LIBRARY_PATH should be set to $ORACLE_HOME/lib
> 
> If anybody got better idea please
> 
> Chhers
> Ganti
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

Re: Re[2]:Oracle Licensing

[William Beilstein]

I doubt it, Oracle will say that their profit margins are too low so they will up 
their licence costs for everyone else. Larry can you spell greed.

>>> <[EMAIL PROTECTED]> 03/02/01 12:35PM >>>
Dennis,

I'm sitting in the middle of the East Coast dot bomb area.  I know of three
dot bombs that paid a total of $100 million between them for Oracle licenses. 
Now that the dot com sugar daddy has been licked clean maybe reality will
strike!!

Dick Goulet

Reply Separator
Author: Dennis Taylor <[EMAIL PROTECTED]>
Date:   3/2/2001 8:30 AM

At 06:25 AM 3/2/01 -0800, you wrote:
>the mire.  At any rate, there are suppose to be two basic licensing
schemes, and
>GOD only knows how many "allowed" permutations:
>
>1) Power Units which equates to the number of processors times the
speed of
>the processors in Megahertz.  Oh, BTW: it matters if their Intel or Risc
>processors too.  Risc processors are more expensive.  In general this is the
>MOST expensive way to go.
>

I went to the oracle site and did some calcs for adding users to Oracle
Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of
megahertz". Anyway, for a very behind-the-curve system (2x200mhz
ppro's), it works out to $4000 per additional user.

Or I can look at Interbase/Firebird, which is free.

Today I will be assigning one of my staff the task of downloading,
installing, and evaluating Firebird.

The only way I can imagine that Oracle thinking can be going is: "Hey,
revenues are dropping because of competition from free and less expensive
dbms's". "No problem. Raise prices to make up the shortfall". Then I say to
myself, "Naw, no-one can be that stupid". Then I check the per-user prices
again


Dennis Taylor

Good we must love, and must hate ill,
For ill is ill, and good good still.

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

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

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

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

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

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

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

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

Re: RE: eek! completely off topic

[Ruth Gramolini]

I used to buy Omaha steaks, but our home raised is even better than that.
RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:56 AM


> It you want great corn feed beef (the reason for mad
> cow is how they feed their livestock) visit the Omaha
> Steaks web page.
>
> The US should never have any of these problems.  We
> feed our cattle with grains such as corn.  We should
> not have a problem with hoof and mouth because we
> vaccinate our cattle against such diseases.
> --- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> > I don't think that the experts are telling anyone
> > that Mad Cow Disease is
> > not transferrable to humans.  It causes death in
> > humans and cannot be killed
> > by cooking at normal temperature.
> >
> > Hoof and Mouth disease is not transferrable to
> > humans and should not be
> > confused with the common human affliction Foot in
> > Mouth disease.
> >
> > It is the former that may destroy the livestock
> > industry  in Europe and lead
> > to turning lots of folks into vegetarians.
> >
> > We raise our own beef so I am not going to turn into
> > a vegetarian.
> >
> > Ruth
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Friday, March 02, 2001 7:10 AM
> >
> >
> > > Rachel,
> > >
> > > The "experts" tell us that the disease only
> > affects certain animals but
> > not
> > > humans, even if you eat meat contaminated with
> > disease.  I'm not
> > enlightened
> > > enough one way or the other to become a vegetarian
> > as a consequence %-|
> > >
> > > Sean :)
> > >
> > > Rookie Data Base Administrator
> > > [0%] OCP Oracle8i DBA
> > > [0%] OCP Oracle9i DBA
> > > 
> > > Organon (Ireland) Ltd.
> > > http://www.organon.ie
> > > E-mail: [EMAIL PROTECTED]   [subscribed:
> > Digest Mode]
> > >
> > > Visit:
> > http://groups.yahoo.com/group/Oracle-OCP-DBA
> > >
> > > "They tell me nothing, but expect me to know
> > everything!"
> > >
> > >
> > > --
> > >
> > >  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
> > >  Date: Thu, 01 Mar 2001 14:23:33 -
> > >  Subject: RE: eek!
> > >
> > > Sean,
> > >
> > > I read about that crash this morning --
> > horrifying!  And they are saying
> > > there is something like $1 billion worth of damage
> > from the quake. My
> > > friends in Gresham (Oregon) felt it as well.
> > >
> > > You going to become a vegetarian based on the
> > animal diseases raging over
> > > there?
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: O'Neill, Sean
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> 
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =
> Regards,
> Linda Miller-Coker
> My Ebay auctions are at:
>
http://cgi6.ebay.com/aw-cgi/eBayISAPI.dll?ViewListedItems&userid=tazmacc&inc
lude=0&since=-1&sort=2&rows=25
> Also visit my Yahoo Classifieds at:
> classifieds.yahoo.com (No bidding just buying!!!)
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Linda Miller Coker
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the m

Re: DBMS_JOB -- urgent !!!

[William Beilstein]

Read the man page. It will explain all about crontab

On your Unix system type 

man crontab

Give a man a fish and he will eat one meal, teach a man to fish and he will never 
starve.

>>> "Mohammad Rafiq" <[EMAIL PROTECTED]> 03/02/01 12:01PM >>>
See Reply below


Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Mar 2001 06:51:05 -0800

Hi list,
 I need to cron a job every day at 10pm except
sundays, how do I acomplish this ? I need the INTERVAL
field.
--
00 22 * * 1-6 file_name


 I also need to cron another job every day except
sundays an saturdays too, can you please help me with
this?
---
00 22 * * 1-5 file_name   (assuming same time)

thanks in advance.

___
Do You Yahoo!?
Envfa mensajes instantßneos y recibe alertas de correo con
Yahoo! Messenger - http://messenger.yahoo.es 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
   INET: [EMAIL PROTECTED] 

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

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

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

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

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

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

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

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

RE: DBMS_JOB -- urgent !!!

[Pablo ksksksk]

Thanks for answering

That's not what I'm looking for, I don't want to do it
with UNIX crontab.

I need to do it by using DBMS_JOB package !!!






--- [EMAIL PROTECTED] escribió: > use
1-6 for every day except Sunday and
> 1-5 for every day except Saturday and Sunday.
> Days in cron are labelled 0-6, starting with Sunday,
> respectively.
> 
> i.e., 
> 
> 00 17 * * 1-6 /opt/oracle/admin/scripts/
> 00 17 * * 1-5 /opt/oracle/admin/scripts/
> 
> --Scott Shafer
>   San Antonio, TX
> 
> > -Original Message-
> > From:   Pablo ksksksk [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, March 02, 2001 8:51 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:DBMS_JOB -- urgent !!!
> > 
> > Hi list,
> > I need to cron a job every day at 10pm except
> > sundays, how do I acomplish this ? I need the
> INTERVAL
> > field.
> > 
> > I also need to cron another job every day
> except
> > sundays an saturdays too, can you please help me
> with
> > this? 
> > 
> > thanks in advance.
> > 
> >
>
___
> > Do You Yahoo!?
> > Envía mensajes instantáneos y recibe alertas de
> correo con 
> > Yahoo! Messenger - http://messenger.yahoo.es
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: =?iso-8859-1?q?Pablo=20ksksksk?=
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (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!?
Envía mensajes instantáneos y recibe alertas de correo con 
Yahoo! Messenger - http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

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

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

[John Dailey]

LOL  sad to say Lee but I live in DC/Northern Virginia and UK to LA is
probably better than what I face on some days...

:-)

just my $0.02



-Original Message-
Lee Robertson
Sent: Friday, March 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


I also got that email,

I told him thanks for the thought but as I am in the UK the commuting alone
would probably kill me.



-Original Message-
Sent: 02 March 2001 14:32
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with
technical, and some functional, experience supporting Oracle Financial
apps.

Ideally, we're hoping to find someone who has been through a few  backend
and application upgrades because we need to begin immediately.

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS
side then phasing out 10.7 smart client and moving  to Oracle 11i /
11.5.2.  We're also hoping to phase out  many of the customizations that
have been made to the financial modules such as HR, OM, GL, AR, AP and
Payroll.

We're located in the Glendale/Pasadena area which is a great place to
live.

If you or somebody you know is interested in becoming part of our Oracle
team, send me a resume.  If you're not interested in this job or don't
want to be bothered, send me an email and let me know.

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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


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

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

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

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

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

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

[dgoulet]

Ruth,

Is that synonymous with "head up $%#" disease?

Dick Goulet

Sorry, I just could not resist!

Reply Separator
Author: "Ruth Gramolini" <[EMAIL PROTECTED]>
Date:   3/2/2001 6:06 AM

I don't think that the experts are telling anyone that Mad Cow Disease is
not transferrable to humans.  It causes death in humans and cannot be killed
by cooking at normal temperature.

Hoof and Mouth disease is not transferrable to humans and should not be
confused with the common human affliction Foot in Mouth disease.

It is the former that may destroy the livestock industry  in Europe and lead
to turning lots of folks into vegetarians.

We raise our own beef so I am not going to turn into a vegetarian.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 7:10 AM


> Rachel,
>
> The "experts" tell us that the disease only affects certain animals but
not
> humans, even if you eat meat contaminated with disease.  I'm not
enlightened
> enough one way or the other to become a vegetarian as a consequence %-|
>
> Sean :)
>
> Rookie Data Base Administrator
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> 
> Organon (Ireland) Ltd.
> http://www.organon.ie
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "They tell me nothing, but expect me to know everything!"
>
>
> --
>
>  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>  Date: Thu, 01 Mar 2001 14:23:33 -
>  Subject: RE: eek!
>
> Sean,
>
> I read about that crash this morning -- horrifying!  And they are saying
> there is something like $1 billion worth of damage from the quake. My
> friends in Gresham (Oregon) felt it as well.
>
> You going to become a vegetarian based on the animal diseases raging over
> there?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE:8.1.6.0 install problem

[GANTI . SIVA]

Tom,

Please set LIB_PATH (some thing like that )=/usr/lib  in your .profile before
linking.LD_LIBRARY_PATH should be set to $ORACLE_HOME/lib

If anybody got better idea please

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

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

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

Re: 8.1.6.0 install problem

[Thater, William]

On Fri, 2 Mar 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:

->ld: 0706-006 Cannot find or open library file: -l m
->ld:open(): No such file or directory
->ar: No such file or directory
->ar: 0707-117 The fopen system call failed on file
->/u01/app/oracle/product/8.1.6/lib64/shr.o.
->
->Anyone have any ideas??

what's your LD_LIBRARY_PATH set to?  does that file exist and have the correct
permissions?
--
Bill Thater Certified ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~
Supercomputer:  Turns CPU-bound problem into I/O-bound problem.  - Ken Batcher

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

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

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

[Gene Sais]

I got it too.  Maybe we should all send back a response, at least a few hundred per 
user who received it.

>>> [EMAIL PROTECTED] 03/02 10:41 AM >>>
On Fri, 2 Mar 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:

->OK Folks,
->
->I got this in the old inbox this morning.  Most likely it came from one of
->the job search services like Monster.com.  Funny how those services just can't
->forget you.  Anyway it is of no interest to me, I like the New England area and
->am not interested in moving, but there may be one or more of you who are
->interested as has been said in the past.  So don't shoot the messenger & do make
->appropriate use of the delete key if needed.
->
->
->Dick Goulet

funny, i got exactally the same note, address harvesting?  maybe not.  anybody
else?  oh, and i can't relocate right now, so i'll pass.

--
Bill Thater Certified ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED] 
~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~
If it aint broke, don't fix it!

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

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

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

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

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

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

Re: Fwd:Oracle Upgrade DBA Wanted

[Brian Wisniewski]

It must be another person who's swiped names off of the oracle-l list
because I had it in my email box this morning also.  I've never posted
my resume online so I know they didn't get it off of some job board.

Maybe we can send out the oracle-l email mercenaries to hunt this guy
down and send him the doggie doo warning package to his front step!

- Brian

--- [EMAIL PROTECTED] wrote:
> OK Folks,
> 
> I got this in the old inbox this morning.  Most likely it came
> from one of
> the job search services like Monster.com.  Funny how those services
> just can't
> forget you.  Anyway it is of no interest to me, I like the New
> England area and
> am not interested in moving, but there may be one or more of you who
> are
> interested as has been said in the past.  So don't shoot the
> messenger & do make
> appropriate use of the delete key if needed.
> 
> 
> Dick Goulet
> 
> Forward Header_
> Author: Mike Green <[EMAIL PROTECTED]>
> Date:   3/1/2001 7:39 PM
> 
> 
> 
> Hi Dick
> 
> My company is currently looking to hire a full-time Senior Oracle DBA
> with 
> technical, and some functional, experience supporting Oracle
> Financial 
> apps.  
> 
> Ideally, we're hoping to find someone who has been through a few 
> backend 
> and application upgrades because we need to begin immediately.   
> 
> The initial project involves upgrading from Oracle 7x to 8i on the
> RDBMS 
> side then phasing out 10.7 smart client and moving  to Oracle 11i / 
> 11.5.2.  We're also hoping to phase out  many of the customizations
> that 
> have been made to the financial modules such as HR, OM, GL, AR, AP
> and 
> Payroll.
> 
> We're located in the Glendale/Pasadena area which is a great place to
> 
> live.
> 
> If you or somebody you know is interested in becoming part of our
> Oracle 
> team, send me a resume.  If you're not interested in this job or
> don't 
> want to be bothered, send me an email and let me know. 
> 
> Thanks,
> 
> Michael Green
> 
> Triad Project Management
> 3452 E Foothill Blvd  Suite 530
> Pasadena, CA  91107
> [EMAIL PROTECTED]
> 626-793-7314
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Wisniewski
  INET: [EMAIL PROTECTED]

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

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

[dgoulet]

Martin,

I replied privately to one of your colleagues as I sure would not mind the
commute to the UK.  Spent 4 years there at RAF Mildenhall.  Loved it.

Dick Goulet

Reply Separator
Author: Martin Kendall <[EMAIL PROTECTED]>
Date:   3/2/2001 8:40 AM

To say nothing about us in the "old" United Kingdom ..:-)

-Original Message-
Sent: 02 March 2001 15:46
To: Multiple recipients of list ORACLE-L


I got this also and I have a feeling he may have sent it to names he found
on this list.  If us New Englanders got it he must have sent it to a lot of
names.

Greg 
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

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

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

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

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

Re:Oracle Licensing

[Dennis Taylor]

At 06:25 AM 3/2/01 -0800, you wrote:
>the mire.  At any rate, there are suppose to be two basic licensing
schemes, and
>GOD only knows how many "allowed" permutations:
>
>1) Power Units which equates to the number of processors times the
speed of
>the processors in Megahertz.  Oh, BTW: it matters if their Intel or Risc
>processors too.  Risc processors are more expensive.  In general this is the
>MOST expensive way to go.
>

I went to the oracle site and did some calcs for adding users to Oracle
Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of
megahertz". Anyway, for a very behind-the-curve system (2x200mhz
ppro's), it works out to $4000 per additional user.

Or I can look at Interbase/Firebird, which is free.

Today I will be assigning one of my staff the task of downloading,
installing, and evaluating Firebird.

The only way I can imagine that Oracle thinking can be going is: "Hey,
revenues are dropping because of competition from free and less expensive
dbms's". "No problem. Raise prices to make up the shortfall". Then I say to
myself, "Naw, no-one can be that stupid". Then I check the per-user prices
again


Dennis Taylor

Good we must love, and must hate ill,
For ill is ill, and good good still.

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

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

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

[Rachel Carmichael]

I got that one too. and I've never signed up for Monster. And if I had, 
I would NEVER have used this email address for it, I reserve this address 
exclusively for this list.  I think someone/something managed to skim the 
mailing list (perhaps by signing up for the list and extracting the emails 
of the people who post?) and is spamming us

Rachel


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Fwd:Oracle Upgrade DBA Wanted
>Date: Fri, 02 Mar 2001 06:32:04 -0800
>
>OK Folks,
>
> I got this in the old inbox this morning.  Most likely it came from 
>one of
>the job search services like Monster.com.  Funny how those services just 
>can't
>forget you.  Anyway it is of no interest to me, I like the New England area 
>and
>am not interested in moving, but there may be one or more of you who are
>interested as has been said in the past.  So don't shoot the messenger & do 
>make
>appropriate use of the delete key if needed.
>
>
>Dick Goulet
>
>Forward Header_
>Author: Mike Green <[EMAIL PROTECTED]>
>Date:   3/1/2001 7:39 PM
>
>
>
>Hi Dick
>
>My company is currently looking to hire a full-time Senior Oracle DBA with
>technical, and some functional, experience supporting Oracle Financial
>apps.
>
>Ideally, we're hoping to find someone who has been through a few  backend
>and application upgrades because we need to begin immediately.
>
>The initial project involves upgrading from Oracle 7x to 8i on the RDBMS
>side then phasing out 10.7 smart client and moving  to Oracle 11i /
>11.5.2.  We're also hoping to phase out  many of the customizations that
>have been made to the financial modules such as HR, OM, GL, AR, AP and
>Payroll.
>
>We're located in the Glendale/Pasadena area which is a great place to
>live.
>
>If you or somebody you know is interested in becoming part of our Oracle
>team, send me a resume.  If you're not interested in this job or don't
>want to be bothered, send me an email and let me know.
>
>Thanks,
>
>Michael Green
>
>Triad Project Management
>3452 E Foothill Blvd  Suite 530
>Pasadena, CA  91107
>[EMAIL PROTECTED]
>626-793-7314
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

Re[2]:Oracle Licensing

[dgoulet]

Dennis,

I'm sitting in the middle of the East Coast dot bomb area.  I know of three
dot bombs that paid a total of $100 million between them for Oracle licenses. 
Now that the dot com sugar daddy has been licked clean maybe reality will
strike!!

Dick Goulet

Reply Separator
Author: Dennis Taylor <[EMAIL PROTECTED]>
Date:   3/2/2001 8:30 AM

At 06:25 AM 3/2/01 -0800, you wrote:
>the mire.  At any rate, there are suppose to be two basic licensing
schemes, and
>GOD only knows how many "allowed" permutations:
>
>1) Power Units which equates to the number of processors times the
speed of
>the processors in Megahertz.  Oh, BTW: it matters if their Intel or Risc
>processors too.  Risc processors are more expensive.  In general this is the
>MOST expensive way to go.
>

I went to the oracle site and did some calcs for adding users to Oracle
Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of
megahertz". Anyway, for a very behind-the-curve system (2x200mhz
ppro's), it works out to $4000 per additional user.

Or I can look at Interbase/Firebird, which is free.

Today I will be assigning one of my staff the task of downloading,
installing, and evaluating Firebird.

The only way I can imagine that Oracle thinking can be going is: "Hey,
revenues are dropping because of competition from free and less expensive
dbms's". "No problem. Raise prices to make up the shortfall". Then I say to
myself, "Naw, no-one can be that stupid". Then I check the per-user prices
again


Dennis Taylor

Good we must love, and must hate ill,
For ill is ill, and good good still.

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

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

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

[Dennis Taylor]

I got it too. I sent them an email telling them what I think of people who
harvest email addresses so they can spam me.

At 06:32 AM 3/2/01 -0800, you wrote:
>OK Folks,
>
>I got this in the old inbox this morning.  Most likely it came from
one of
>the job search services like Monster.com.  Funny how those services just
can't


Dennis Taylor

Good we must love, and must hate ill,
For ill is ill, and good good still.

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

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

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

Materialized views across a db link

[johnm9563]

Anybody using MV`s thru a db link.  

I am trying to create a MV that is updated on commit.  I can create this view if I get 
I keep it in the same db.  I can get a  MV that never will be refreshed working link. 
( What good is that ?)  

The query is below 
Platform Irix 6.5 Oracle 8.1.6 

Tia 
John 

QUERY 
select SYSTEM_CODE_ID,
 SYSTEM_CODE_GROUP_ID,
 LAST_UPDATE_DATETIME,
 LAST_UPDATE_USER_ID,
 LAST_UPDATE_PROGRAM,
 SYSTEM_CODE,
 SYSTEM_CODE_DESC,
 CODE_SEQUENCE_NBR,
 SYSTEM_CODE_REF_NBR,
 SYSTEM_CODE_REF_TEXT,
 ACTIVE_CODE_IND,
 count(*) dummy_count
from utility.system_code@mcdev
group by SYSTEM_CODE_ID,
 SYSTEM_CODE_GROUP_ID,
 LAST_UPDATE_DATETIME,
 LAST_UPDATE_USER_ID,
 LAST_UPDATE_PROGRAM,
 SYSTEM_CODE,
 SYSTEM_CODE_DESC,
 CODE_SEQUENCE_NBR,
 SYSTEM_CODE_REF_NBR,
 SYSTEM_CODE_REF_TEXT,
 ACTIVE_CODE_IND
/





__
Get your own FREE, personal Netscape Webmail account today at 
http://webmail.netscape.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

[Kevin Kostyszyn]

Jackson and Don,
I like Don's idea.  I think it is strange though, I only have one more
question.  How is the database started and stopped?  Can you only use
svrmgl?  I would have to go with Don's idea, if this is a 24/7 database I am
afraid it would have to be recycled.  I would think that if you went to your
boss and explained this horrid situation there would be an understanding.
Let me know what happens, I am very interested in this one.
Sincerely,
Kev
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 9:06 AM


> For the Oracle database to -run- the OracleServiceTEST (created with the
> oradim80 command below) must be running, so I infer that you're missing
the
> OracleStartTEST service.
>
> You can try:
>
> oradim80 -edit -sid SID -intpwd PASSWORD -startmode AUTO -pfile
> PATH/initSID.ora
>
> and that might create it, or it will do no harm if it fails.  I know the
> -startmode AUTO is the important part, and needs to be included in the
> creation if this doesn't work.
>
> Doing the delete/add cycle certainly requires downtime, but the good news
is
> you don't have to re-create the database, so you should be down only long
> enough to stop, run these commands, and start.  (take a backup first,
> though!)
>
> Jackson Dumas wrote:
>
> > In order to automatically start Oracle on NT, OracleServiceSID and
> > OracleStartSID must be started. They should be set to AUTOMATIC in
> > control panel, on NT.Now my case is that both those services are not
> > available or created. Now I read that I have to create those services.
> > e.g.
> > oradim80 -delete -sid TEST
> > oradim80 -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
> > c:\ORANT\DATABASE\INITTEST.ORA
> >
> > The version of Oracle is 806 and the version of NT is 4.0 Service pack
> > 5. As to who installed and created the database, that one I don't
> > know, maybe someone who was here before I joined the Oracle Team and
> > he left already.
> >
> > The question is whether is there a way of implemeting this without
> > having to ask for down time, in other words shutdown the Production
> > database ? I think the question is clear now Kevin. Is there another
> > way perhaps of creating this without having impact on the business by
> > shuting down the database ?
> >
> > On Thu, 01 Mar 2001 05:41:50 -0800 Kevin Kostyszyn ([EMAIL PROTECTED])
> > wrote:
> >
> > >What exactly are you asking?  What version of Oracle, What version of
> > NT?
> > >Who installed and created the DB?
> > >Kev
> > >
> > >-Original Message-
> > >Dumas
> > >Sent: Thursday, March 01, 2001 8:15 AM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > >
> > >I would like to find out how I can make a Oracle database running on
> > >NT to start up automatically if there is a power failure or something
> > >on the box without having to down that database. I read another
> > >article about Oradim and how to include the startup file if it's not
> > >there on Services running on NT. Actually I did check that there is
> > no
> > >startup service for database to be automatically started. Now my
> > >problem is whether it's possible for me to incorporate this without
> > >having to get down time, because this is a 24X7 system and it will
> > >take a long time before getting approval and things like those
> > >Please help me, I am new on these thangs.
> > >Ya help please .. 
> > >___
> > > http://www.webmail.co.za the South-African free email service
> > > WIN R10 000 by registering  for free online options for EasyMoney in
> > > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
> > Now!!!
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Jackson Dumas
> > >  INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from).  You may
> > >also send the HELP command for other information (like subscribing).
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Kevin Kostyszyn
> > >  INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing
> > Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the

Re: Oracle Upgrade DBA Wanted

[Kevin Kostyszyn]

Yeah, I got it as well, I have a feeling everyone got it.  Is our list under
attack by outside resources?
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:56 AM


> Hi Dick,
>
> I got this message too. Hey, I'd like to ask you a question personal. Do
you
> have dba position open in your company?
> I live in Andover. I can't stand this company anymore. I just start to
> looking for.
> Thanks,
>
> Joan
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Friday, March 02, 2001 9:32 AM
> To: Multiple recipients of list ORACLE-L
>
>
> OK Folks,
>
> I got this in the old inbox this morning.  Most likely it came from
one
> of
> the job search services like Monster.com.  Funny how those services just
> can't
> forget you.  Anyway it is of no interest to me, I like the New England
area
> and
> am not interested in moving, but there may be one or more of you who are
> interested as has been said in the past.  So don't shoot the messenger &
do
> make
> appropriate use of the delete key if needed.
>
>
> Dick Goulet
>
> Forward Header_
> Author: Mike Green <[EMAIL PROTECTED]>
> Date:   3/1/2001 7:39 PM
>
>
>
> Hi Dick
>
> My company is currently looking to hire a full-time Senior Oracle DBA with
> technical, and some functional, experience supporting Oracle Financial
> apps.
>
> Ideally, we're hoping to find someone who has been through a few  backend
> and application upgrades because we need to begin immediately.
>
> The initial project involves upgrading from Oracle 7x to 8i on the RDBMS
> side then phasing out 10.7 smart client and moving  to Oracle 11i /
> 11.5.2.  We're also hoping to phase out  many of the customizations that
> have been made to the financial modules such as HR, OM, GL, AR, AP and
> Payroll.
>
> We're located in the Glendale/Pasadena area which is a great place to
> live.
>
> If you or somebody you know is interested in becoming part of our Oracle
> team, send me a resume.  If you're not interested in this job or don't
> want to be bothered, send me an email and let me know.
>
> Thanks,
>
> Michael Green
>
> Triad Project Management
> 3452 E Foothill Blvd  Suite 530
> Pasadena, CA  91107
> [EMAIL PROTECTED]
> 626-793-7314
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: Oracle Upgrade DBA Wanted

[Martin Kendall]

To say nothing about us in the "old" United Kingdom ..:-)

-Original Message-
Sent: 02 March 2001 15:46
To: Multiple recipients of list ORACLE-L


I got this also and I have a feeling he may have sent it to names he found
on this list.  If us New Englanders got it he must have sent it to a lot of
names.

Greg 
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

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

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

[Kimberly Smith]

Man, and I thought I was the only one who got it:-)  I don't
feel its to much different then the dumb Bill Law ones except
he cost himself a lot more work instead of just sending to
one address.  I am sure he has plenty of e-mail himself this
morning.

-Original Message-
Sent: Friday, March 02, 2001 8:40 AM
To: Multiple recipients of list ORACLE-L


To say nothing about us in the "old" United Kingdom ..:-)

-Original Message-
Sent: 02 March 2001 15:46
To: Multiple recipients of list ORACLE-L


I got this also and I have a feeling he may have sent it to names he found
on this list.  If us New Englanders got it he must have sent it to a lot of
names.

Greg 
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

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

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

Re[2]: Fwd:Oracle Upgrade DBA Wanted

[dgoulet]

Well then! To the list, my apologies.  The original came direct, no CC or BCC's
included.  Does look like we all got spammed.  Again my apologies.

Dick Goulet

Reply Separator
Author: "Charlie Mengler" <[EMAIL PROTECTED]>
Date:   3/2/2001 7:56 AM

I was SPAMMED by this LUSER, too.
It appears that he harvested addresses from this list.
If you deem this behavior to be unacceptable, you might
want to consider sending Richard Fischer, the president
of his employer a complaint [[EMAIL PROTECTED]].

FWIW - This SPAM is illegal in the state of California.
-- 
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: 
  INET: [EMAIL PROTECTED]

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

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

[Mark Leith]

Foot in Mouth disease? LOL..

-Original Message-
Gramolini
Sent: Friday, March 02, 2001 02:07
To: Multiple recipients of list ORACLE-L


I don't think that the experts are telling anyone that Mad Cow Disease is
not transferrable to humans.  It causes death in humans and cannot be killed
by cooking at normal temperature.

Hoof and Mouth disease is not transferrable to humans and should not be
confused with the common human affliction Foot in Mouth disease.

It is the former that may destroy the livestock industry  in Europe and lead
to turning lots of folks into vegetarians.

We raise our own beef so I am not going to turn into a vegetarian.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 7:10 AM


> Rachel,
>
> The "experts" tell us that the disease only affects certain animals but
not
> humans, even if you eat meat contaminated with disease.  I'm not
enlightened
> enough one way or the other to become a vegetarian as a consequence %-|
>
> Sean :)
>
> Rookie Data Base Administrator
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> 
> Organon (Ireland) Ltd.
> http://www.organon.ie
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "They tell me nothing, but expect me to know everything!"
>
>
> --
>
>  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>  Date: Thu, 01 Mar 2001 14:23:33 -
>  Subject: RE: eek!
>
> Sean,
>
> I read about that crash this morning -- horrifying!  And they are saying
> there is something like $1 billion worth of damage from the quake. My
> friends in Gresham (Oregon) felt it as well.
>
> You going to become a vegetarian based on the animal diseases raging over
> there?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

Re: DBMS_JOB -- urgent !!!

[Mohammad Rafiq]

See Reply below


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Mar 2001 06:51:05 -0800

Hi list,
 I need to cron a job every day at 10pm except
sundays, how do I acomplish this ? I need the INTERVAL
field.
--
00 22 * * 1-6 file_name


 I also need to cron another job every day except
sundays an saturdays too, can you please help me with
this?
---
00 22 * * 1-5 file_name   (assuming same time)

thanks in advance.

___
Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con
Yahoo! Messenger - http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

[Scott . Shafer]

use 1-6 for every day except Sunday and
1-5 for every day except Saturday and Sunday.
Days in cron are labelled 0-6, starting with Sunday, respectively.

i.e., 

00 17 * * 1-6 /opt/oracle/admin/scripts/
00 17 * * 1-5 /opt/oracle/admin/scripts/

--Scott Shafer
  San Antonio, TX

> -Original Message-
> From: Pablo ksksksk [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 8:51 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  DBMS_JOB -- urgent !!!
> 
> Hi list,
> I need to cron a job every day at 10pm except
> sundays, how do I acomplish this ? I need the INTERVAL
> field.
> 
> I also need to cron another job every day except
> sundays an saturdays too, can you please help me with
> this? 
> 
> thanks in advance.
> 
> ___
> Do You Yahoo!?
> Envía mensajes instantáneos y recibe alertas de correo con 
> Yahoo! Messenger - http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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).

Baan with Oracle

[Raghu Kota]

Hi Friends


The error is

2001-03-02[11:27:20]sfkecper: *** S T A R T of Log message ***
2001-03-02[11:27:20]sfkecper: Log message called from 
/port.6.1b.05.01/vobs/tt/l
ib/al_1/al_strm.c: #495 keyword: strm
2001-03-02[11:27:20]sfkecper: Pid 107992 Uid 508 Euid 508 Gid 125 Egid 125
2001-03-02[11:27:20]sfkecper: user_type N language 2 user_name sfkecper tty 
ote
locale ISO88591/NULL
2001-03-02[11:27:20]sfkecper: Errno 9 (Bad file number) bdb_errno 509 (Bad 
memor
y cursor; bad table pointer specified)
2001-03-02[11:27:20]sfkecper: Log_mesg: sflush(): write error
2001-03-02[11:27:20]sfkecper: ** E N D of Log message **

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

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

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

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

Re: Fwd:Oracle Upgrade DBA Wanted

[Charlie Mengler]

I was SPAMMED by this LUSER, too.
It appears that he harvested addresses from this list.
If you deem this behavior to be unacceptable, you might
want to consider sending Richard Fischer, the president
of his employer a complaint [[EMAIL PROTECTED]].

FWIW - This SPAM is illegal in the state of California.
-- 
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).

8.1.6.0 install problem

[blair]

I'm trying to install Oracle Enterprise server 8.1.6.0 onto our AIX 4.3.3 64-bit
IBM server.

I'm getting a problem during the link phase.  I make sure we have 2x the swap
space as main memory.  The Oracle techrep told me to run
$ORACLE_HOME/bin/genclntsh64.  I did this but still get the same error messages:

ld: 0706-006 Cannot find or open library file: -l m
ld:open(): No such file or directory
ar: No such file or directory
ar: 0707-117 The fopen system call failed on file 
/u01/app/oracle/product/8.1.6/lib64/shr.o.

Anyone have any ideas??

thanks,

..tom


-- 
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: eek! completely off topic

[Linda Miller Coker]

It you want great corn feed beef (the reason for mad
cow is how they feed their livestock) visit the Omaha
Steaks web page.

The US should never have any of these problems.  We
feed our cattle with grains such as corn.  We should
not have a problem with hoof and mouth because we
vaccinate our cattle against such diseases.  
--- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> I don't think that the experts are telling anyone
> that Mad Cow Disease is
> not transferrable to humans.  It causes death in
> humans and cannot be killed
> by cooking at normal temperature.
> 
> Hoof and Mouth disease is not transferrable to
> humans and should not be
> confused with the common human affliction Foot in
> Mouth disease.
> 
> It is the former that may destroy the livestock
> industry  in Europe and lead
> to turning lots of folks into vegetarians.
> 
> We raise our own beef so I am not going to turn into
> a vegetarian.
> 
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Friday, March 02, 2001 7:10 AM
> 
> 
> > Rachel,
> >
> > The "experts" tell us that the disease only
> affects certain animals but
> not
> > humans, even if you eat meat contaminated with
> disease.  I'm not
> enlightened
> > enough one way or the other to become a vegetarian
> as a consequence %-|
> >
> > Sean :)
> >
> > Rookie Data Base Administrator
> > [0%] OCP Oracle8i DBA
> > [0%] OCP Oracle9i DBA
> > 
> > Organon (Ireland) Ltd.
> > http://www.organon.ie
> > E-mail: [EMAIL PROTECTED]   [subscribed:
> Digest Mode]
> >
> > Visit:
> http://groups.yahoo.com/group/Oracle-OCP-DBA
> >
> > "They tell me nothing, but expect me to know
> everything!"
> >
> >
> > --
> >
> >  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
> >  Date: Thu, 01 Mar 2001 14:23:33 -
> >  Subject: RE: eek!
> >
> > Sean,
> >
> > I read about that crash this morning --
> horrifying!  And they are saying
> > there is something like $1 billion worth of damage
> from the quake. My
> > friends in Gresham (Oregon) felt it as well.
> >
> > You going to become a vegetarian based on the
> animal diseases raging over
> > there?
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: O'Neill, Sean
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

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


=
Regards,
Linda Miller-Coker
My Ebay auctions are at:
http://cgi6.ebay.com/aw-cgi/eBayISAPI.dll?ViewListedItems&userid=tazmacc&include=0&since=-1&sort=2&rows=25
Also visit my Yahoo Classifieds at:
classifieds.yahoo.com (No bidding just buying!!!)

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Linda Miller Coker
  INET: [EMAIL PROTECTED]

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

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

[Joan Hsieh]

Hi Dick,

I got this message too. Hey, I'd like to ask you a question personal. Do you
have dba position open in your company?
I live in Andover. I can't stand this company anymore. I just start to
looking for.
Thanks,

Joan

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with
technical, and some functional, experience supporting Oracle Financial
apps.

Ideally, we're hoping to find someone who has been through a few  backend
and application upgrades because we need to begin immediately.

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS
side then phasing out 10.7 smart client and moving  to Oracle 11i /
11.5.2.  We're also hoping to phase out  many of the customizations that
have been made to the financial modules such as HR, OM, GL, AR, AP and
Payroll.

We're located in the Glendale/Pasadena area which is a great place to
live.

If you or somebody you know is interested in becoming part of our Oracle
team, send me a resume.  If you're not interested in this job or don't
want to be bothered, send me an email and let me know.

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

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

RE: Oracle Upgrade DBA Wanted

[lerobe - Lee Robertson]

I also got that email,

I told him thanks for the thought but as I am in the UK the commuting alone
would probably kill me.



-Original Message-
Sent: 02 March 2001 14:32
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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


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

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

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

RE: Oracle Upgrade DBA Wanted

[Paul Baumgartel]

Yeah, it was in my inbox as well...sounds like these people are mining this
mailing list for addresses.  


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

completely off topic BSE

[Dasko, Dan]

I suffer greatly from foot in mouth disease.  Usually, I open my mouth and
jam both feet in up to the ankle, but I digress.

The last I read about BSE was that it was coming under control with the
elimination of refeeding, but it will be a few years before we know for
sure.  The number of human cases peaked a couple of years ago, and while it
may take a while to eliminate it completely from the current herds, I figure
the problem will be controlled in time.  However, the vegetarians are
milking the issue for all it's worth, and I predict in 20 years, it will be
like Hanta Virus and Legionaire's Disease, something that we know about and
we know it's bad and we know what to do and what not to do to avoid it.

Dan
-Original Message-
Sent: Friday, March 02, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L


I don't think that the experts are telling anyone that Mad Cow Disease is
not transferrable to humans.  It causes death in humans and cannot be killed
by cooking at normal temperature.

Hoof and Mouth disease is not transferrable to humans and should not be
confused with the common human affliction Foot in Mouth disease.

It is the former that may destroy the livestock industry  in Europe and lead
to turning lots of folks into vegetarians.

We raise our own beef so I am not going to turn into a vegetarian.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 7:10 AM


> Rachel,
>
> The "experts" tell us that the disease only affects certain animals but
not
> humans, even if you eat meat contaminated with disease.  I'm not
enlightened
> enough one way or the other to become a vegetarian as a consequence %-|
>
> Sean :)
>
> Rookie Data Base Administrator
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> 
> Organon (Ireland) Ltd.
> http://www.organon.ie
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "They tell me nothing, but expect me to know everything!"
>
>
> --
>
>  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>  Date: Thu, 01 Mar 2001 14:23:33 -
>  Subject: RE: eek!
>
> Sean,
>
> I read about that crash this morning -- horrifying!  And they are saying
> there is something like $1 billion worth of damage from the quake. My
> friends in Gresham (Oregon) felt it as well.
>
> You going to become a vegetarian based on the animal diseases raging over
> there?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

RE: Oracle Upgrade DBA Wanted

[Nelson, Greg]

I got this also and I have a feeling he may have sent it to names he found
on this list.  If us New Englanders got it he must have sent it to a lot of
names.

Greg 
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

[paquette stephane]

Dick,

I received this mail personnaly this morning and hit
the delete key.



--- [EMAIL PROTECTED] a écrit : > OK Folks,
> 
> I got this in the old inbox this morning.  Most
> likely it came from one of
> the job search services like Monster.com.  Funny how
> those services just can't
> forget you.  Anyway it is of no interest to me, I
> like the New England area and
> am not interested in moving, but there may be one or
> more of you who are
> interested as has been said in the past.  So don't
> shoot the messenger & do make
> appropriate use of the delete key if needed.
> 
> 
> Dick Goulet
> 
> Forward
> Header_
> Author: Mike Green <[EMAIL PROTECTED]>
> Date:   3/1/2001 7:39 PM
> 
> 
> 
> Hi Dick
> 
> My company is currently looking to hire a full-time
> Senior Oracle DBA with 
> technical, and some functional, experience
> supporting Oracle Financial 
> apps.  
> 
> Ideally, we're hoping to find someone who has been
> through a few  backend 
> and application upgrades because we need to begin
> immediately.   
> 
> The initial project involves upgrading from Oracle
> 7x to 8i on the RDBMS 
> side then phasing out 10.7 smart client and moving 
> to Oracle 11i / 
> 11.5.2.  We're also hoping to phase out  many of the
> customizations that 
> have been made to the financial modules such as HR,
> OM, GL, AR, AP and 
> Payroll.
> 
> We're located in the Glendale/Pasadena area which is
> a great place to 
> live.
> 
> If you or somebody you know is interested in
> becoming part of our Oracle 
> team, send me a resume.  If you're not interested in
> this job or don't 
> want to be bothered, send me an email and let me
> know. 
> 
> Thanks,
> 
> Michael Green
> 
> Triad Project Management
> 3452 E Foothill Blvd  Suite 530
> Pasadena, CA  91107
> [EMAIL PROTECTED]
> 626-793-7314
> 
> -- 
> 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).


=
Stephane Paquette
DBA Oracle, Datawarehouse consultant
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

[Dasko, Dan]

Well, serial and parallel is much slower than ethernet.  You have to look at
what the bottleneck is likely to be.  I'm not an expert on SANs, but with
that much data, there might be advantages to separating out the storage from
the actual database engine.  If you want a bunch of info on SANs, just call
EMC or some other disk vendor, I'm sure they'd be happy to take you to lunch
and discuss the advantages of that approach.  Spring is coming, there might
even be some golf thrown in for good measure.

Dan - Not an expert in DW or SANs or Networking, but I know enough to be
dangerous in all 3

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


Hello,

Some data warehousing questions:

We are considering a setup where we have two separate machines,
1 for doing the ETL (ExtractTransformLoad)processing, and 1 for
the production machine. Our env is Oracle 8.1.6 on Sun.
The main idea is to insulate the production machine from the effects
of ETL processing; the only impact ETL would have on the production
machine would be when the ETL has completed and the data is copied
over to the production machine, which leads me to my question:
what methods have been used to minimize the time needed for this copy step?

The amount of data to be transferred would be around 200GB, but expected
to grow very fast.
Both machines would be part of an existing ethernet network, and we've
considered the following:
1) Just do the transfer over the existing ethernet network (figure about
   150GB/hour)
2) Position the machines close to each other, and run a short (6-foot or
less)
   cable between serial ports or parallel ports on both machines
3) Set up a separate network; install an ethernet card in each machine, and
   connect them with ethernet
4) Go to a "disk-farm" setup - don't know a lot about this, but both
machines
   would access subsets of a large shared disk array (is this EMC? or other
vendors?)

The consensus is that fiberoptic, although faster, would be a waste since
then the limiting factor would be disk read and write speeds.

Anyway, I would appreciate any comments/suggestions regarding the above,
especially #4, and any other approaches.
Thanks to any responders.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: OEM 2.2. installation blues

[Jesse, Rich]

Hi Patrice,

I've successfully installed OEM 2.2 *TWICE* (thanks to Oracle Support for
telling me that it was the only freaking way to get iFS installed on the
same box...) on my P-III 800Mhz running Win2K ("WinTuke") with SP1 and 512MB
memory.  You don't mention where your repository DB is, however.  My DB is
an O8.0.5.0.1 on an OpenVMS box, which frees up about 200MB of mem for me.

I haven't had any problems regarding the installation.  It's just AFTER the
install that I run into chaos and mayhem.  Stupid events won't deregister...

Good luck!  :)

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


> -Original Message-
> From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 07:55
> To: Multiple recipients of list ORACLE-L
> Subject: OEM 2.2. installation blues
> 
> 
> Hi,
> 
> Has anyone successfully installed OEM 2.2. on their machine?
> 
> My test server has 256M more RAM coming, but in the meantime 
> I haven't given
> up hope.  Although hope is dwindling... I only have 380M of RAM.
> 
> I started the installation process, then went to talk to 
> someone.  When I
> returned there was a Blue Screen of Death waiting for me.  
> 
> After powering off and powering on my machine, Peak Memory usage on my
> machine is at 680M of memory!  Is this NT going crazy or does 
> the Oracle
> Universal Installer really need that much memory to install 
> OEM 2.2.?  Could
> there be a creeping memory leak in the Universal Installer? 
> (make that a
> galloping memory leak)
> 
> I allocated 1G of virtual memory, but I know from experience 
> on this machine
> at least that NT can't handle virtual memory very well, it keeps blue
> screening when I exceed available physical memory by too much.


---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle Upgrade DBA Wanted

[Dasko, Dan]

Actually, I got it also and just figured someone was scooping the list
membership.

Dan

-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


OK Folks,

I got this in the old inbox this morning.  Most likely it came from one
of
the job search services like Monster.com.  Funny how those services just
can't
forget you.  Anyway it is of no interest to me, I like the New England area
and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do
make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

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

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

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

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

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

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

Re: Fwd:Oracle Upgrade DBA Wanted

[Thater, William]

On Fri, 2 Mar 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:

->OK Folks,
->
->I got this in the old inbox this morning.  Most likely it came from one of
->the job search services like Monster.com.  Funny how those services just can't
->forget you.  Anyway it is of no interest to me, I like the New England area and
->am not interested in moving, but there may be one or more of you who are
->interested as has been said in the past.  So don't shoot the messenger & do make
->appropriate use of the delete key if needed.
->
->
->Dick Goulet

funny, i got exactally the same note, address harvesting?  maybe not.  anybody
else?  oh, and i can't relocate right now, so i'll pass.

--
Bill Thater Certified ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~
If it aint broke, don't fix it!

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

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

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

[dgoulet]

You must have gotten in there before the rest of the east coast came to work. 
It's slow now!!  Was pretty quick at 5AM EST yesterday too.

Dick Goulet

Reply Separator
Author: "Adams; Matthew (GEA; 088130)" <[EMAIL PROTECTED]>
Date:   3/2/2001 6:01 AM

Wow!  Metalink is downright frisky this morning, 
responds to all requests rapidly.

Enjoy it while you can.


R. Matt Adams  - GE Appliances - [EMAIL PROTECTED]
 Contrary to popular opinion, Unix is user friendly. 
 It's just particular about who it makes friends with.






Metalink - actually respond well



Wow!  Metalink is downright frisky this morning, 
responds to all requests rapidly.


Enjoy it while you can.



R. Matt Adams  - GE Appliances -
[EMAIL PROTECTED]
 Contrary to popular opinion, Unix is
user friendly. 
 It's just particular about who it
makes friends with.




-- 
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: DBWR slaves in NT???

[Don Jerman]

If you're not archiving anyway the NOLOGGING option on import and index creation
might help things go faster (esp. if it's all on the same drive).  Don't turn it
on for the import if you're appending to existing data (unless you like living
dangerously) but for indexes it's a good option for speed (as you can just drop
and re-create them anyway if things go wrong).

Raghu Kota wrote:

> Hi Jesse
>
> Your insight is good, But due to all these problems(One controller) we
> could't enable archiving. So we are trying to reduce the overhead !! So the
> what ever minimum LGWR work will done okay...I think Iam correct
>
> Any way thanks to all people for understanding my problem
>
> Raghu.
>
> >From: "Jesse, Rich" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: DBWR slaves in NT???
> >Date: Thu, 01 Mar 2001 12:27:14 -0800
> >
> >H...I don't know how pounding a single drive with two threads instead
> >of
> >one would help, but it could be tried.  I would think that the LGWR would
> >be
> >the big complainer in a 1-disk config, instead of the DBWR.  Or at least I
> >think LGWR would complain more often...
> >
> >My post was simply to point out that the error message in TOAD about
> >"Number
> >of DB_FILES set too high" was inaccurate.  And as the "Tuning" stuff in
> >TOAD
> >has been redone, at least in the latest TOAD v7 Beta, this error message
> >won't be a hassle too much longer.
> >
> >Long live Toadman Jim!  :)
> >
> >Rich Jesse  System/Database Administrator
> >[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> >
> > > -Original Message-
> > > From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, March 01, 2001 14:09
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: DBWR slaves in NT???
> > >
> > >
> > > If I am completely off the wall here just slap me around a
> > > little bit.  But
> > > couldn't you play with the init parameteres DBWR_IO_SLAVES or
> > > DB_WRITER_PROCESSES to help improve write performance?  I
> > > mean, I agree with
> > > Ross, there is only one disk, but maybe it could help a little to help
> > > simulate asynchronous I/O?
> > > Kev
> > > Just thinkin out loud again!
> > >
> > > -Original Message-
> > > Sent: Thursday, March 01, 2001 2:31 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Actually, that message is invalid for Oracle8 DBs.  From what
> > > I can gather,
> > > the DB_FILES init.ora parameter only
> > > potentially affected DBWR performance in Oracle7.  In
> > > Oracle8, it ain't
> > > true.
> > >
> > > Remember, the DBWRs write dirty buffers (data in memory that has been
> > > modified from it's counterpart in a datafile) from the buffer
> > > cache (memory)
> > > to the datafiles (disk).  In O7, the DBWR I/O clump size, or
> > > how many dirty
> > > blocks could be written at once (also sometimes referred to
> > > as the DBWR's
> > > "internal write batch size"), was calculated as:
> > >
> > > DB_FILE_SIMULTANEOUS_WRITES*DB_FILES/2.
> > >
> > > In O8, the DBWR I/O clump size is static, and is different
> > > from platform to
> > > platform.  Thus, for Oracle8, the advise to change DB_FILES is bogus.
> > >
> > > HTH!
> > >
> > > Rich Jesse  System/Database Administrator
> > > [EMAIL PROTECTED] Quad/Tech International,
> > > Sussex, WI USA
> > >
> > > Disclaimer:  After taking the Oracle8 Perf Tuning class, I
> > > think I know more
> > > than I do.  Don't blame me for your (in)actions based on my opinion!
> > >
> > > -Original Message-
> > > Sent: Thursday, March 01, 2001 12:27
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > not a dbwriter problem.
> > > on a "single-disk wonder", your best
> > > bet is to DUMP all indexes on loadable
> > > tables, then load your data, then rebuild
> > > the indexes.
> > > of course, that might take just as long.
> > > any possiblity of getting more disk?
> > > like, several? a raid controller?
> > > mit gluck!
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Thursday, March 01, 2001 11:26 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi Friends
> > > I have toad tool for my NT database
> > > DBWR Average Scan Depth 1024  **Number of DB_Files too high??
> > > I got doubt due to from v$waitstat I got data block waits
> > > some time 8000 and
> > >
> > > some times higher number. How can I increase the DBWR slaves on NT??
> > > although I set in development box, How can I see as background process
> > > really working for me??
> > > I have my datafile and indexes same on E disk drive, My hit
> > > ratios are okay,
> > >
> > > My import is killing me.
> > > Any help appreciated.
> > > Thanks
> > > Raghu.
> > > __
> > > ___
> > > Get Your Private, Free E-mail from MSN Hotmail at

Fwd:Oracle Upgrade DBA Wanted

[dgoulet]

OK Folks,

I got this in the old inbox this morning.  Most likely it came from one of
the job search services like Monster.com.  Funny how those services just can't
forget you.  Anyway it is of no interest to me, I like the New England area and
am not interested in moving, but there may be one or more of you who are
interested as has been said in the past.  So don't shoot the messenger & do make
appropriate use of the delete key if needed.


Dick Goulet

Forward Header_
Author: Mike Green <[EMAIL PROTECTED]>
Date:   3/1/2001 7:39 PM



Hi Dick

My company is currently looking to hire a full-time Senior Oracle DBA with 
technical, and some functional, experience supporting Oracle Financial 
apps.  

Ideally, we're hoping to find someone who has been through a few  backend 
and application upgrades because we need to begin immediately.   

The initial project involves upgrading from Oracle 7x to 8i on the RDBMS 
side then phasing out 10.7 smart client and moving  to Oracle 11i / 
11.5.2.  We're also hoping to phase out  many of the customizations that 
have been made to the financial modules such as HR, OM, GL, AR, AP and 
Payroll.

We're located in the Glendale/Pasadena area which is a great place to 
live.

If you or somebody you know is interested in becoming part of our Oracle 
team, send me a resume.  If you're not interested in this job or don't 
want to be bothered, send me an email and let me know. 

Thanks,

Michael Green

Triad Project Management
3452 E Foothill Blvd  Suite 530
Pasadena, CA  91107
[EMAIL PROTECTED]
626-793-7314

-- 
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: eek! completely off topic

[Ruth Gramolini]

I don't think that the experts are telling anyone that Mad Cow Disease is
not transferrable to humans.  It causes death in humans and cannot be killed
by cooking at normal temperature.

Hoof and Mouth disease is not transferrable to humans and should not be
confused with the common human affliction Foot in Mouth disease.

It is the former that may destroy the livestock industry  in Europe and lead
to turning lots of folks into vegetarians.

We raise our own beef so I am not going to turn into a vegetarian.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 7:10 AM


> Rachel,
>
> The "experts" tell us that the disease only affects certain animals but
not
> humans, even if you eat meat contaminated with disease.  I'm not
enlightened
> enough one way or the other to become a vegetarian as a consequence %-|
>
> Sean :)
>
> Rookie Data Base Administrator
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> 
> Organon (Ireland) Ltd.
> http://www.organon.ie
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "They tell me nothing, but expect me to know everything!"
>
>
> --
>
>  From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>  Date: Thu, 01 Mar 2001 14:23:33 -
>  Subject: RE: eek!
>
> Sean,
>
> I read about that crash this morning -- horrifying!  And they are saying
> there is something like $1 billion worth of damage from the quake. My
> friends in Gresham (Oregon) felt it as well.
>
> You going to become a vegetarian based on the animal diseases raging over
> there?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

DBMS_JOB -- urgent !!!

[Pablo ksksksk]

Hi list,
I need to cron a job every day at 10pm except
sundays, how do I acomplish this ? I need the INTERVAL
field.

I also need to cron another job every day except
sundays an saturdays too, can you please help me with
this? 

thanks in advance.

___
Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con 
Yahoo! Messenger - http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

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

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

[Ron Rogers]

Linda,
 Where did you get the CD's for the 9iAS? I tried the download method and "FileSplit" 
them back together. No luck. WinZip reported the file was corrupt. I tried the 
download method twice but still no luck. How long did you have to wait for the CD's to 
arrive in smailmail? If you downloaded, what site did you use? I tried from the OTN 
site to get the files.
ROR mª¿ªm



--
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: Build a duplicate DB using hot backups

[SHAIBAL TALUKDER]

 Chuan,
Are you restoring the archived logfiles; cause you need the logfiles untill completion of the HOT BACKUP to clone the database.
Shaibal
  "Molina, Gerardo" <[EMAIL PROTECTED]> wrote: 
are you using recover using backup controlfile until cancel?make sure that the alter database open statement has the clause "resetlogs"Check the trace file that's generated when to backup the controlfile totrace.You need to edit that script to suit your needs.HTHGerardo-Original Message-Sent: Thursday, March 01, 2001 5:01 PMTo: Multiple recipients of list ORACLE-LHi, DBAs,I want to build a duplicate DB of the production DB using the hot backupswithout RMAN.Redo online log files are not included in the hot backups according toOracle recommendation.The control file is modified to suit for the new host configuration. When Ilog into svrmgrl and run this new creating control file script, it complainsthat the redo log files are not found. Should I backup the online redo logfiles? Ho!
!
w could I deal with the onlineredo log files for my purpose?Many thanks in advance.Chuan-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Molina, GerardoINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

DataWarehouse Configuration

[Bill Becker]

Hello,

Some data warehousing questions:

We are considering a setup where we have two separate machines,
1 for doing the ETL (ExtractTransformLoad)processing, and 1 for
the production machine. Our env is Oracle 8.1.6 on Sun.
The main idea is to insulate the production machine from the effects
of ETL processing; the only impact ETL would have on the production
machine would be when the ETL has completed and the data is copied
over to the production machine, which leads me to my question:
what methods have been used to minimize the time needed for this copy step?

The amount of data to be transferred would be around 200GB, but expected
to grow very fast.
Both machines would be part of an existing ethernet network, and we've
considered the following:
1) Just do the transfer over the existing ethernet network (figure about
   150GB/hour)
2) Position the machines close to each other, and run a short (6-foot or less)
   cable between serial ports or parallel ports on both machines
3) Set up a separate network; install an ethernet card in each machine, and
   connect them with ethernet
4) Go to a "disk-farm" setup - don't know a lot about this, but both machines
   would access subsets of a large shared disk array (is this EMC? or other vendors?)

The consensus is that fiberoptic, although faster, would be a waste since
then the limiting factor would be disk read and write speeds.

Anyway, I would appreciate any comments/suggestions regarding the above,
especially #4, and any other approaches.
Thanks to any responders.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: [EMAIL PROTECTED]

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

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

Metalink - actually respond well

[Adams, Matthew (GEA, 088130)]

Title: Metalink - actually respond well





Wow!  Metalink is downright frisky this morning, 
responds to all requests rapidly.


Enjoy it while you can.



R. Matt Adams  - GE Appliances - [EMAIL PROTECTED]
 Contrary to popular opinion, Unix is user friendly. 
 It's just particular about who it makes friends with.

Re:Oracle Licensing

[dgoulet]

Nick,

After several years of directly dealing with Oracle, we've decided to go
through a third party VAR to purchase software.  The reason is the licensing
methods that they use.  Seems what you need to be a mathematician, astrologer,
and soothsayer to figure it out.  I've even had Oracle sales reps get lost in
the mire.  At any rate, there are suppose to be two basic licensing schemes, and
GOD only knows how many "allowed" permutations:

1) Power Units which equates to the number of processors times the speed of
the processors in Megahertz.  Oh, BTW: it matters if their Intel or Risc
processors too.  Risc processors are more expensive.  In general this is the
MOST expensive way to go.

2) Named Users which equates to your being able to draw up a definitive list
of the actual individuals in the company who access the database.  Least
expensive way to go, but leaves you wide open for an audit.

Now then there are lots of other permutations that can be worked out, if you
want to use Linux and/or your going to deploy only behind your corporate
firewall, if it's near the end of the Oracle Quater or even better the end of
their fiscal year.  

Now if your good at predicting the future.  The best is one week before the
end of their fiscal year, when the moon will be full on the day they announce
the results, and Haley's comet is at it's perigee  Get the point!!

Dick Goulet

Reply Separator
Author: Nick Mundi <[EMAIL PROTECTED]>
Date:   3/1/2001 3:08 PM

Dear Esteemed List,

Though I am very familiar with the technical aspects of Oracle, I don't know
much about Oracle licensing. I have recently been asked by one of our staff
to get more information on licensing. I would be very grateful for any
information relating to this. 

Also, is licensing based on the number of OS's or is it only on processers
used/speed etc. What happens if you are running a passive/standby database,
or a OS clustering solution.

Thanks.

Regards,

Nick Mundi





Oracle Licensing



Dear Esteemed List,


Though I am very familiar with the technical
aspects of Oracle, I don't know much about Oracle licensing. I have recently
been asked by one of our staff to get more information on licensing. I would be
very grateful for any information relating to this. 

Also, is licensing based on the number of OS's or
is it only on processers used/speed etc. What happens if you are running a
passive/standby database, or a OS clustering solution.

Thanks.


Regards,


Nick Mundi




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

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

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

Re: ORACLE_ON_NT !!!!

[Don Jerman]

For the Oracle database to -run- the OracleServiceTEST (created with the
oradim80 command below) must be running, so I infer that you're missing the
OracleStartTEST service.

You can try:

oradim80 -edit -sid SID -intpwd PASSWORD -startmode AUTO -pfile
PATH/initSID.ora

and that might create it, or it will do no harm if it fails.  I know the
-startmode AUTO is the important part, and needs to be included in the
creation if this doesn't work.

Doing the delete/add cycle certainly requires downtime, but the good news is
you don't have to re-create the database, so you should be down only long
enough to stop, run these commands, and start.  (take a backup first,
though!)

Jackson Dumas wrote:

> In order to automatically start Oracle on NT, OracleServiceSID and
> OracleStartSID must be started. They should be set to AUTOMATIC in
> control panel, on NT.Now my case is that both those services are not
> available or created. Now I read that I have to create those services.
> e.g.
> oradim80 -delete -sid TEST
> oradim80 -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
> c:\ORANT\DATABASE\INITTEST.ORA
>
> The version of Oracle is 806 and the version of NT is 4.0 Service pack
> 5. As to who installed and created the database, that one I don't
> know, maybe someone who was here before I joined the Oracle Team and
> he left already.
>
> The question is whether is there a way of implemeting this without
> having to ask for down time, in other words shutdown the Production
> database ? I think the question is clear now Kevin. Is there another
> way perhaps of creating this without having impact on the business by
> shuting down the database ?
>
> On Thu, 01 Mar 2001 05:41:50 -0800 Kevin Kostyszyn ([EMAIL PROTECTED])
> wrote:
>
> >What exactly are you asking?  What version of Oracle, What version of
> NT?
> >Who installed and created the DB?
> >Kev
> >
> >-Original Message-
> >Dumas
> >Sent: Thursday, March 01, 2001 8:15 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >
> >I would like to find out how I can make a Oracle database running on
> >NT to start up automatically if there is a power failure or something
> >on the box without having to down that database. I read another
> >article about Oradim and how to include the startup file if it's not
> >there on Services running on NT. Actually I did check that there is
> no
> >startup service for database to be automatically started. Now my
> >problem is whether it's possible for me to incorporate this without
> >having to get down time, because this is a 24X7 system and it will
> >take a long time before getting approval and things like those
> >Please help me, I am new on these thangs.
> >Ya help please .. 
> >___
> > http://www.webmail.co.za the South-African free email service
> > WIN R10 000 by registering  for free online options for EasyMoney in
> > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
> Now!!!
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jackson Dumas
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Kevin Kostyszyn
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
> ___
>  http://www.webmail.co.za the South-African free email service
>  WIN R10 000 by registering  for free online options for EasyMoney in
>  http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jackson Dumas
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> -

RE: OAS and iAS file size comparisons

[Thomas Jeff]

Ha! I beat you.   9i ias for AIX comes on 4 CDs.

Jeff T
Thomson multimedia, Inc


-Original Message-
Sent: Thursday, March 01, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


Everything but the kitchen sink..  9iAS includes Apache, Forms Server,
Reports Server, Portal, DB Cache, Discoverer Server, Queue Manager, Wireless
if you want it, and possibly others I've left out.  Consider yourself lucky
if you only had 2 CDs, we (Solaris) had 3.

Linda
(installed but not working)

-Original Message-
Sent: Thursday, March 01, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L


OAS 4.0.8.2 for NT was 121M in size, zipped.

iAS for NT is two CDs in size, 569,609K + 403,131K.

What did they put in this new version that is so HUGE?

Unbelievable.

How big will Oracle 9i be, I wonder.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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

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

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

[Ruth Gramolini]

Spool the output of thie sql and then run the spooled file:
select 'alter table schema_name.'||table_name||' disable constraint
'||constraint_name||';'
from dba_constraints
where owner='schema_name'
and   CONSTRAINT_TYPE in ('R','P','U')  This line is optional.

This will disable the constraints in schema_name of choice.  You can enable
all of the constraints by changing disable to enable.  You can change
disable to drop  to drop all constraints.

I got this from a lister on one of the lists.  It works very well.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 3:30 AM


> Hi DBAs,
>
> We r using Oracle 8.1.6 . db.
> I would like to disable all the constraints on the Tables available
> under one schema.
> Is there any single command to do this in 8i . Any DBMS package
> available?
> Any other suggestions for doing the same??
>
> Thank You.
> Arul.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Arul kumar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: OFF TOPIC: load average figure in TOP

[Deshpande, Kirti]

Hi,
 Those figure represent average number of jobs in the run queue waiting for
CPU (in the last 1, 5 and 15 minutes). If this number is consistently more
than twice the number of CPUs, you may have CPU bottleneck. 

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

> -Original Message-
> From: KC [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 5:00 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OFF TOPIC: load average figure in TOP
> 
> Dear list,
>  
> The load average figure shown in top, does it represent average number of
> running jobs or running jobs + jobs ready to be run. One of my machine had
> 4 CPU, sometimes the load average is > 10, so I guess the load average
> number is not just running jobs. Any ideal??
>  
> Kam
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: OEM 2.2. installation blues

[Rao, Maheswara]

Title: RE: OEM 2.2. installation blues









Hi,

 

We
installed oem2.2 on NT with 256 MB RAM. 
Installation went through well and did not face any problems.  The packs installed – Tuning, Change
Management, Diagnostics.

 

Rao

 

[EMAIL PROTECTED]

 

-Original
Message-
From: Vincent Ruger [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 3:36
AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: OEM 2.2. installation
blues

 

Hi, 

Yes, w've installed oem2.2 on a nt (ibm)
machine with 180 Mb ram. It works fine, with the 3 major packs. (tuning, diag
and change)

The management server runs fine and even
the data gatherer works very good, we collect the data from unix (aix) trough
the nt dg for our packs and no problem.

nt with service pack 6 

hth 

Vincent Ruger 

 

-Oorspronkelijk bericht- 
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens
Boivin, Patrice J 
Verzonden: donderdag 1 maart 2001 14:55 
Aan: Multiple recipients of list ORACLE-L 
Onderwerp: OEM 2.2. installation blues 

 

Hi, 

Has anyone successfully installed OEM 2.2.
on their machine? 

My test server has 256M more RAM coming,
but in the meantime I haven't given up hope.  Although hope is
dwindling... I only have 380M of RAM. 

I started the installation process, then
went to talk to someone.  When I returned there was a Blue Screen of Death
waiting for me.  

After powering off and powering on my
machine, Peak Memory usage on my machine is at 680M of memory!  Is
this NT going crazy or does the Oracle Universal Installer really need that much
memory to install OEM 2.2.?  Could there be a creeping memory leak in the
Universal Installer? (make that a galloping memory leak) 

I allocated 1G of virtual memory, but I
know from experience on this machine at least that NT can't handle virtual
memory very well, it keeps blue screening when I exceed available physical
memory by too much. 

TIA 
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 

Systems Admin & Operations | Admin. et
Exploit. des systèmes

Technology Services    |
Services technologiques

Informatics Branch
| Direction de l'informatique 
Maritimes Region, DFO  | Région des
Maritimes, MPO 

E-Mail: [EMAIL PROTECTED] 


 

RE: How to increase the number of inserts into a table to 2000 p

[Toepke, Kevin M]

Ranganath:

If you all you really need is fast insert performance
1) Drop any indexes on the table
2) Drop all of the constraints on the table
-- Foreign Key
-- NOT NULL
3) Drop all trigers on the table
4) Use the SQL*Loader API (or use SQL*Loader)
-- ALTER TABLE xxx NOLOGGING;
-- Use the Direct Path method
5) Stripe the table across as many disks as possible.

Doing all of that should significantly improve the performance of your
inserts.

Up to 2800 inserts per second? Is that for a table with 1 column, no
indexes/constraints? Stripped across how many disks? 

Kevin

-Original Message-
Sent: Friday, March 02, 2001 12:41 AM
To: Multiple recipients of list ORACLE-L
second


Dear DBA Gurus

 I am using Oracle 8.1.6 Work group server on Sun Solaris 2.8.
I want to increase the number of inserts into a particular table per second
to 2000 per second. Sun Microsystems claims that with the current hardware
configuration the number of inserts can go upto 2800 per second.  Currently
it is only 600 per second.  The insertion is done through a C program using
OCI with an embedded SQL statement.  I am using a SunE4500 machine with  130
gb hard disk, 4gb RAM and 4  Sparc CPU machine.  Please let me know as to
how do I increase the number of inserts into that table as we require to
implement the same into our application.  Any help in this regard will be
higly appreciated.

TIA and regards,

Ranganath


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

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

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

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

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

RE: Oracle's Updates Subscription Service

[Ron Rogers]

Hang on to your wallets. Oracle announced that the latest returns would not meet 
the market expectations. Real $.10   Market $.12   stock dropped to $17 and change 
this morning.
  Maybe it was a fallout from BILL C@$$#&#
ROR mª¿ªm


--
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: How to increase the number of inserts into a table to 2000 per

[Joseph S. Testa]

ok all experts out there, thats a first, i've never seen a hardware
vendor say "you can only do max of 2800 inserts/second".

I'l assume thats based on MIPS or would someone kindly explain that one.

thanks, joe


Ranganath K wrote:
> 
> Dear DBA Gurus
> 
>  I am using Oracle 8.1.6 Work group server on Sun Solaris 2.8.
> I want to increase the number of inserts into a particular table per second
> to 2000 per second. Sun Microsystems claims that with the current hardware
> configuration the number of inserts can go upto 2800 per second.  Currently
> it is only 600 per second.  The insertion is done through a C program using
> OCI with an embedded SQL statement.  I am using a SunE4500 machine with  130
> gb hard disk, 4gb RAM and 4  Sparc CPU machine.  Please let me know as to
> how do I increase the number of inserts into that table as we require to
> implement the same into our application.  Any help in this regard will be
> higly appreciated.
> 
> TIA and regards,
> 
> Ranganath
> 
>

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

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

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

RE:Newbie question on Packages

[GANTI . SIVA]

Hi Rakesh,

The user has already having select permission.So login as system

Create public synonym V$_SESSION for SYS.V$_SESSION

Hope this'll work if none above works

Regards
Ganti



---

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: Disabling Constraints in a Schema!..??

[Joseph S. Testa]

-- the FK

select 'alter table '||table_name||' disable '||constraint_name||';'
from user_constraints 
where constraint_type = 'R';



there is check constraints, primary key, and unique, but i'll not give
you the entire answer.

joe
Arul kumar wrote:
> 
> Hi DBAs,
> 
> We r using Oracle 8.1.6 . db.
> I would like to disable all the constraints on the Tables available
> under one schema.
> Is there any single command to do this in 8i . Any DBMS package
> available?
> Any other suggestions for doing the same??
> 
> Thank You.
> Arul.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Arul kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

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

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

RE: RE: eek!

[O'Neill, Sean]

Rachel,

The "experts" tell us that the disease only affects certain animals but not
humans, even if you eat meat contaminated with disease.  I'm not enlightened
enough one way or the other to become a vegetarian as a consequence %-|

Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.   
http://www.organon.ie
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"They tell me nothing, but expect me to know everything!"


--

 From: "Rachel Carmichael" <[EMAIL PROTECTED]>
 Date: Thu, 01 Mar 2001 14:23:33 -
 Subject: RE: eek!

Sean,

I read about that crash this morning -- horrifying!  And they are saying 
there is something like $1 billion worth of damage from the quake. My 
friends in Gresham (Oregon) felt it as well.

You going to become a vegetarian based on the animal diseases raging over 
there?

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

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

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

[Cale, Rick T (Richard)]

Supposely they are loaded into a BLOB column in the CREATE$JAVA$LOB$TABLE.
The loadjava utility
loads the java files into the database in addition to creating
CREATE$JAVA$LOB$TABLE and
JAVA$CLASS$MD5$TABLE. 

Rick

> -Original Message-
> From: John Dunn [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 6:06 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  where does loadjava store stuff
> 
> When I run loadjava specifying a jar file what exactly gets stored where
> in
> the database?
> 
> John
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

RE:reset control, redo, logs etc

[GANTI . SIVA]

Hey Joe,

No need to worry.Is the database working now.You don't have to reset control
file..If you are in doubt create the control file again using
 the famous ALTER DATABASE BACKUP CONTROL FILE TO TRACE; etc

But if you want to retrieve the database from cold back up you have taken
while the database is up you are in trouble.Even in that case also
If you are lucky you can retrieve that also.If you are retriving from the
cold-backup you let me know

Regards
GAnti



---

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

where does loadjava store stuff

[John Dunn]

When I run loadjava specifying a jar file what exactly gets stored where in
the database?

John

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

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

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

OFF TOPIC: load average figure in TOP

[KC]

Dear list,
 
The load average figure shown in top, 
does it represent average number of running jobs or running jobs + jobs ready to 
be run. One of my machine had 4 CPU, sometimes the load average is > 10, so I 
guess the load average number is not just running jobs. Any ideal??
 
Kam

Re: EXPORT PROBLEM

[GANTI . SIVA]

MALA,
in the export log (typial) this is the order.

 exporting job queues
 exporting refresh groups and children
 exporting user history table
 exporting default and system auditing options
Export terminated successfully without warnings.



What you have to do is after importing you have to create refresh groups
etc.whatever written above.I am suspecting about the parameter

job_queue_processes etc in your init.ora file .I am not sure anyway.Otherwise
w.r.t. queues there might be some problem in your database.

So don't have to worry about all these .Just import from the dump and do the
above.The dump is OK

Cheers
GAnti



---

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: Excessive Archivals for NO Apparent Reason

[K Gopalakrishnan]

Vivek !!

> Oracle 7.3.4.5 on Solaris 2.6
> 
> DELAYED BLOCK CLEANOUT means what ? - Could you possibly Give some more
> Detail ?

http://www.geocities.com/kgkrish/transactions.html


There is an animated detailed explanation about this in the 
above link.. (Note that this has some errros. I have not
updated this afterwrds) But the concept is well explained.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA






_
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: Report Metalink Problems

[John Hallas]

Title: RE: Report Metalink Problems



I 
complained via our Oracle Account Manager (we had to find out his name first!!!) 
and I got a response within 6 hours from UK Metalink admitting the problems and 
blaming it on an upsurge in demand.
 
This 
begs all sorts of questions re capacity planning etc but at least it gives us 
something in writing to use next time we get into Oracle licensing 
talks
 
 
John
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 01 
  March 2001 21:34To: Multiple recipients of list 
  ORACLE-LSubject: RE: Report Metalink Problems
  SSgt Yexley, 
  I applaud your getting involved directly. I have done this. My 
  initial question to "essrv" has been unanswered for 
  months. 
  I know of at least one truly 'heavy hitter' on the list who is 
  getting the same response. 
  People will vote, over time, with their pocket books. 
  
  Support *matters*, and it is in my Top Two of things to ask 
  from a vendor. 
  - Ross Mohan 
  -Original Message- From: 
  Yexley Robert D SSgt AFIT/SCA [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, March 01, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Subject: Report Metalink Problems 
  Hey everyone, 
  Along with seemingly everyone else on this list, I have been 
  suffering from  

Re: RE: ORACLE_ON_NT !!!!

[Jackson Dumas]

In order to automatically start Oracle on NT, OracleServiceSID and
OracleStartSID must be started. They should be set to AUTOMATIC in
control panel, on NT.Now my case is that both those services are not
available or created. Now I read that I have to create those services.
e.g.
oradim80 -delete -sid TEST
oradim80 -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
c:\ORANT\DATABASE\INITTEST.ORA

The version of Oracle is 806 and the version of NT is 4.0 Service pack
5. As to who installed and created the database, that one I don't
know, maybe someone who was here before I joined the Oracle Team and
he left already.

The question is whether is there a way of implemeting this without
having to ask for down time, in other words shutdown the Production
database ? I think the question is clear now Kevin. Is there another
way perhaps of creating this without having impact on the business by
shuting down the database ?


On Thu, 01 Mar 2001 05:41:50 -0800 Kevin Kostyszyn ([EMAIL PROTECTED])
wrote:

>What exactly are you asking?  What version of Oracle, What version of
NT?
>Who installed and created the DB?
>Kev
>
>-Original Message-
>Dumas
>Sent: Thursday, March 01, 2001 8:15 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>I would like to find out how I can make a Oracle database running on
>NT to start up automatically if there is a power failure or something
>on the box without having to down that database. I read another
>article about Oradim and how to include the startup file if it's not
>there on Services running on NT. Actually I did check that there is
no
>startup service for database to be automatically started. Now my
>problem is whether it's possible for me to incorporate this without
>having to get down time, because this is a 24X7 system and it will
>take a long time before getting approval and things like those
>Please help me, I am new on these thangs.
>Ya help please .. 
>___
> http://www.webmail.co.za the South-African free email service
> WIN R10 000 by registering  for free online options for EasyMoney in
> http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
Now!!!
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jackson Dumas
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kevin Kostyszyn
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

___
 http://www.webmail.co.za the South-African free email service
 WIN R10 000 by registering  for free online options for EasyMoney in
 http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jackson Dumas
  INET: [EMAIL PROTECTED]

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

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