date:20010809




message has been successfully recalled.


 [EMAIL PROTECTED] 08/09/01 12:44PM 
Raj Gopalan would like to recall the message, "Extent's 
datafile.".-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Raj 
Gopalan INET: [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).

SOLVED: Copying table with LONG column (using copy getting ORA-01

2001-08-09 Thread Schoen Volker


Works for me:

set buffer 10

use the sqplus on dos..ie. sqlplus.exe

Thanks to Ashish

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



-Ursprüngliche Nachricht-
Von: Schoen Volker 
Gesendet: Donnerstag, 9. August 2001 12:50
An: LazyDBA.com Discussion
Betreff: AW: Copying table with LONG column (using copy getting
ORA-01458)


Hi Ashish, hi list,

copy command doesn't work in my environment, get ORA-01458 error. I searched
metaling fór a workarround, but the suggested workarround doesn't do it.

(workarround)
1. To create the new table and not copying the data do:
COPY FROM user/pw@instance TO user/pw@instance CREATE FUHRPARK_KOPIE USING
SELECT * FROM FUHRPARK WHERE 1=2;

2. To insert the data to the new table do:
COPY FROM user/pw@instance TO user/pw@instance APPEND FUHRPARK_KOPIE USING
SELECT * FROM FUHRPARK;

getting error (in german):
Array-Fetch-/Bindungsgröße ist 15. (Arraygröße ist 15)
Nach Beendigung erfolgt Commit. (COPYCOMMIT ist 0)
Maximale LONG-Größe ist 80. (LONG ist 80)

ERROR:
ORA-01458: Ungültige Länge in variabler Zeichenfolge

My environment is:
Oracle 8.1.5 on Windows NT SP6
Client SQPLUS 8.1.7.0.0

Maybe someone knows another workarround or knows which oracle path to apply.

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



-Ursprüngliche Nachricht-
Von: Ashish Arole (CTS) [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 9. August 2001 12:31
An: Schoen Volker; LazyDBA.com Discussion
Betreff: RE: Copying table with LONG column


Use the COPY command from SQL plus

-Original Message-
Sent: Thursday, August 09, 2001 3:25 PM
To: LazyDBA.com Discussion


Does someone know how to copy a table with a long column? Export/Import
works, but I like to do it with SQL.

TIA

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




Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. 
If you are not the intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message. Any unauthorised
review, use, disclosure, dissemination, forwarding, printing or copying of
this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com


Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schoen Volker
  INET: [EMAIL PROTECTED]

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

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

2001-08-09 Thread Koivu, Lisa

Title: RE: Copying table with LONG column





Use the copy command. That's one way. 


Lisa Koivu
Ft. Lauderdale, FL, USA


-Original Message-
From: Schoen Volker [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Copying table with LONG column


Does someone know how to copy a table with a long column? Export/Import
works, but I like to do it with SQL.


TIA


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



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


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

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

2001-08-09 Thread Hsu, Anthony C., ,CPMS


Increase the sort_area_size parameter in the init.ora file
to have more memory to play with. It is much quickere as it uses
RAM, rather than a hard disk, but then again, your server might not
have enough RAM to spare.



-Original Message-
Sent: Tuesday, August 07, 2001 1:43 PM
To: Multiple recipients of list ORACLE-L


If the transaction having problem is a SELECT statement and does SORT, then
I think the sort_area_size is too small.   

Can you show us the SQL?




-Original Message-
Sent: Tuesday, August 07, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L


Hi there,

Unfortunately you can't just throw things like FIRST_ROWS at a select
statement to make it run faster. The person who wrote the statement should
have taken into account such things as:

a) Size of tables, ordering, which is the driving table
b) Indexes, are the being used, running statements through explain plan will
show you where the bottlenecks are...failing that TKPROF will identify
potential problem areas with your database.
c) Size of queries, joins etc.

Too many developers do not write code to be efficient, as long as it returns
the correct values it doesn't matter whether it takes 2 minutes or  2
hours...

I've spent a number of hours/days/weeks/months tidying up poorly optimised
code, it's an absolute nightmare for the DBAs and it doesn't look good on
the developers.

Cheers,
Kev.
(a cheesed off developer...not a DBA!)


__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Tel: 0141 568 2314
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 07 August 2001 17:06
To: Multiple recipients of list ORACLE-L


Morning listers!

I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode... 

AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 
500 MB SGA, 70 concurrent users, mostly OLTP transactions.

I have tunned init parameters the best I can we the resources I have:

db_files = 70
db_writers = 4
db_file_multiblock_read_count = 16
db_block_buffers = 57600
db_block_size = 8192
shared_pool_size = 157286400
processes = 200
dml_locks = 1500
log_buffer = 655360
sequence_cache_entries = 800
sequence_cache_hash_buckets = 89
log_checkpoint_interval = 8
optimizer_mode=CHOOSE
session_cached_cursors =  300
sort_area_size=1048576
hash_area_size=262144
hash_multiblock_io_count=4
hash_join_enabled=TRUE
always_anti_join=HASH
job_queue_processes=8

35 rollback segments, inital 1MB, next 1MB, optimal 30 MB
8 multiplexed redologs, 30 MB each

I tried FIRST_ROWS, analyzing the tables, but users claimed that performance
was getting worse, so I chaged it to Choose. Always analyzing the tables

but, everytime I analyze the tables, performance gets worse.
Is this a normal behavior?

Any advice will be welcome!

thanks is advance,

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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


select de.segment_name,de.bytes,ddf.file_name
from dba_extents de, dba_data_files ddf
where de.file_id=ddf.file_id
and segment_name='MYTABLE'


-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L


DBAs

I manually allocated extents of a table to different datafiles. Which
performance views will give information relating extents and datafiles?

Cheers

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

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

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

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

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

Re: OT:I was thrown out of the list




it was

cozur anoviceOracle Certifiable 
DBBS

joe 
[EMAIL PROTECTED] 08/09/01 12:44PM 
Hi,
 I did not receive a mail for two days, 
I started smelling rat and sent a test mail to the list. I was told I am not a 
member. Is it some revamping happening or I was thrown out because did people 
start receiving viruses from my id ???
list administrator please help
jared
bruce

please explain
cozI am anoviceOracle Certifiable 
DBBS

Re: OT:I was thrown out of the list

2001-08-09 Thread DBarbour



I got a an e-mail announcing I was now a member of the BOUNCED-L LIST.  I
sort of figured somebody was playing games (didn't like my
questions/answers/comments?) and resubscribed (you lucky folks).

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


   
   
novicedba
   
novicedba@hot   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
mail.comcc:   
   
Sent by: Subject: OT:I was thrown out of the list  
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
08/09/2001 
   
11:44 AM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Hi,
   I did not receive a mail for two days, I started smelling rat and sent a
test mail to the list. I was told I am not a member. Is it some revamping
happening or I was thrown out because did people start receiving viruses
from my id ???
list administrator please help
jared
bruce

please explain
coz
I am a
novice
Oracle Certifiable DBBS



-- 
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: O/S copies of datafiles

2001-08-09 Thread Smith, Ron L.


normal shutdown!

-Original Message-
Sent: Thursday, August 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L


Yes, what this is doing is the same as restoring from a cold backup. If
the machines are the same, you can just shutdown Oracle and copy data
files, control files, redo logs and the contents $ORACLE_HOME across to
an identical directory structure on a new machine, change any settings
like tnsnames.ora and listener.ora which might be machine specific, then
start the database on the new machine and you're all set. If the version
of Oracle is only a minor revision, then datafiles, control files et al
will be compatible, just move everything except the software. 

We use a similar technique with Sun Jumpstart to create new instances
for our developers. 

g



-Original Message-
Sent: Thursday, August 09, 2001 3:06 AM
To: Multiple recipients of list ORACLE-L


Hi,

This might be a stupid question, but I'll give it a go anyway.

I have two Unix boxes - a production and a newly created test box. The
production box has 8.0.5 and the test has 8.0.6 installed.

Is it possible to stop the database, take a backup of all the datafiles
(through the operating system) and then move them to the test server (in
the
same directory structure they were in in the production box). Would the
database open successfully?

Thanks in advance for all your help.

Regards,

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

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

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

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

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

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

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

Oracle 8.1.7 client install on Win2K.


List,

I have just got my hands on a shiny new P4 1.3 gig box with Win2K pro. I
installed the Java 1.3.0_01 JRE, and tried to start up the 8.1.7 for NT
Oracle install to install the client software (this was downloaded from
technet BTW). The splash screen runs - but when going for the install (the
java one) nothing happens, I get an hourglass cursor for all of 3-4 seconds
then nothing..

There is nothing else installed on this box apart from Office 2000, as it
was totally empty apart from the OS when we got it.. Has anybody else had
these problems? I seem to remember somebody (I think it may have been
Kevin?) had a problem installing on a P4 box - was your problem similar to
this one?

All help is appreciated!

Regards

Mark

BTW - you may remember I had an OT problem a while back now - where I had a
brand new Geoforce 3 Gfx card, that wouldn't run. I slipped it in to this
new beast and you should see the thing run now!!

This PC now runs games in OpenGL and Direct3D modes with 1280*960 resolution
at roughly 65-70 frames per second!! With NO glitches!! Oh yeah I also have
one game installed on the system :)

Cheers

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

-- 
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: List slow today?

2001-08-09 Thread Kevin Kostyszyn




Yeah I noticed that too, I 
thought my mail server was dead or something!!
KK

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: 
  Thursday, August 09, 2001 3:16 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT: List slow today?
  Other than during IOUG-A, I haven't seen this few messages. Is my 
  mail server eating messages or is it just a slow day?
  
  Stephen

Re: PERL PROGRAMMING

2001-08-09 Thread viraj


Naren,

The PERL cookbook is a good book to refer to.

raja
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 6:50 PM


 Hoe about www.perl.com
 
 http://www.perl.com/pub/q/documentation
 
 Rajesh
 -Original Message-
 Sent: Thursday, August 09, 2001 1:25 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi gurus,
 
 We have Lot of PERL scripts. (Previous DBA). 
 I am newby to perl . please suggest sites , to start.
 
 TIA
 naren
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Narender Akula
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Rao, UmaSankara S (CAP)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Rajesh Dayal
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: viraj
  INET: [EMAIL PROTECTED]

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

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


did you select * from v$lock...for his sid?

-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I had a developer come to me yesterday and tell me his session had hung,
and sure enough it had, he was executing an INSERT into a table with 5
columns. Oracle was just sitting there, but all the other sessions
logged into the database were fine. I got the SQL out of the SQL Area
and ran it in one of my own SQL*Plus windows, and sure enough it got
stuck for me too. The statement was part of a transaction that inserted
and updated about 8 tables, and this happens on the 3000th or so
transaction in that session. We killed that session and restarted the
application, and it was fine until it happened again. 

How would I go about diagnosing something like this? A couple of the
columns were from sequences, and I verified that these were OK. The
others were just text inserted into VARCHAR2s.

Thanks,

g

--
Guy Hammond
AVT Technologies
12-16 Westland Place
London N1 7LP UK

Email: [EMAIL PROTECTED]
Office: +44 (0) 207 454 1224
Mobile: +44 (0) 7966 164687

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

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

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

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

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

RE: OT:I was thrown out of the list

2001-08-09 Thread Kevin Kostyszyn




Oh man that was 
low!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 
  Thursday, August 09, 2001 4:16 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: OT:I was thrown out of the 
  list
  it was
  
  cozur anoviceOracle Certifiable 
  DBBS
  
  joe 
  [EMAIL PROTECTED] 08/09/01 12:44PM 
  Hi,
   I did not receive a mail for two 
  days, I started smelling rat and sent a test mail to the list. I was told I am 
  not a member. Is it some revamping happening or I was thrown out because did 
  people start receiving viruses from my id ???
  list administrator please help
  jared
  bruce
  
  please explain
  cozI am anoviceOracle Certifiable 
  DBBS

RE: O/S copies of datafiles

2001-08-09 Thread Gogala, Mladen


How about giving it a try? I'm a DBA, not a soothsayer and
to give a definite answer, I'd need minute details like OS on
each box, with version, what are you copying and how are you
copying it. As of now, I can tell you only one thing:
Idis redibis nunquam in bello peribis (commas are missing on purpose).
This should satisfy your urge for knowledge.

 -Original Message-
 From: Sujatha Madan [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 08, 2001 10:06 PM
 To: Multiple recipients of list ORACLE-L
 Subject: O/S copies of datafiles
 
 
 Hi,
 
 This might be a stupid question, but I'll give it a go anyway.
 
 I have two Unix boxes - a production and a newly created test box. The
 production box has 8.0.5 and the test has 8.0.6 installed.
 
 Is it possible to stop the database, take a backup of all the 
 datafiles
 (through the operating system) and then move them to the test 
 server (in the
 same directory structure they were in in the production box). 
 Would the
 database open successfully?
 
 Thanks in advance for all your help.
 
 Regards,
 
 Sujatha
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Sujatha Madan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

RE: List slow today?

2001-08-09 Thread Boivin, Patrice J


I think all the people with Oracle problems took the day off.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Stephen Andert [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, August 09, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: List slow today?

Other than during IOUG-A, I haven't seen this few messages.  Is my
mail server eating messages or is it just a slow day?
 
Stephen 

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

OTRE: age discrimination in IT industry


and/or if you are an idiot, slow learner, or have low iq.

I qualify for all of the above, so I barely made it through
the index, even powered by bran. :)

regards,
ep

principal data janitor
www.BSALERT.org
(bombastic, serendipitous alliance of legubrious, enigmatic 
research technicians)


 --
 
  From: Mohan, Ross [EMAIL PROTECTED]
  Date: Wed, 8 Aug 2001 14:52:17 -0400 
  Subject: OTRE: age discrimination in IT industry

[via ORACLE-L Digest -- Volume 2001, Number 221]

 
 If you were older, it would be one. 
 
 -Original Message-
 Sent: Wednesday, August 08, 2001 2:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Light, that is like 5 bathroom sessions.

...

 -Original Message-
 Sent: Wednesday, August 08, 2001 2:02 PM
 To: Multiple recipients of list ORACLE-L
 
 
 some light reading:
 
 http://heather.cs.ucdavis.edu/itaa.real.html
 
 (linked from: 
   http://cobra.csc.calpoly.edu/~jdalbey/csc300/index.html )
 
 -
 Debunking the Myth of a Desperate Software Labor Shortage 
 


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

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

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

2001-08-09 Thread Steve Haas

Title: Message

Doesthe order of tablesalso make a
difference with a RULE hint?

Steven HaasOpus Consultants, LLC

- Original Message -
From:
Christopher
Spence
To: Multiple recipients of list ORACLE-L

Sent: Wednesday, August 08, 2001 12:15
PM
Subject: RE: Optimizer Mode..how to
choose the right one?

I by
no means say CBO doesn't make mistakes. It by far does, but the original
statement stays accurate, order of tables only matters with RBO (if comes up
with tie) and ordered hint.

There is nothing wrong with getting it in a good order, I just wanted
to stress that it only truely matters during those two conditions.
That's all, not trying to be adversary.

CNA
is Novell Admin, I haven't done it in a while, I originally started as a
Novell Admin.
Raptor is a firewall product I spent about4 years working
with.

"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way
and have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73 Princeton Street North, Chelmsford 01863

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08,
2001 11:08 AMTo: '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'Subject: RE: Optimizer Mode..how to
choose the right one?
Ahh, but Christopher, therein lies
the problem. The CBO makes mistakes and sometimes needs the gentle
nudging of the ORDERED hint. I've seen a query go from hours to 2
seconds after some analysis of the execution plan that was failing
miserably.
Love the sig. You are a
CNA? A Raptor? Am I missing something?
Lisa Koivu Vikings Fan (and DBA) Ft. Lauderdale, FL, USA

-Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Subject: RE: Optimizer Mode..how to choose the right
one?
The driving table order does not matter when
using CBO, it will detirmine the order
based on cost, not placement.
The order only matters when dealing with the
RBO (when it hits a tie, otherwise it
will change it, but this happens often), or when using the
ordered hint.
"Do not criticize someone until you walked a
mile in their shoes, that way when you
criticize them, you are a mile a way and have their shoes."
Christopher R. Spence OCP MCSE MCP
A+ RAPTOR CNA Oracle DBA
Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73
Princeton Street North, Chelmsford
01863
-Original Message- Sent: Wednesday, August 08, 2001 4:30 AM
To: Multiple recipients of list
ORACLE-L
Order of the tables only matters when
using the ORDERED hint or using rbo AND there is a tie ranking.
But surely the very nature of the CHOOSE hint
is to select the best method to use
whether it's to follow the RBO or the CBO. Therefor ensuring that
you have the driving table defined in
the correct place within the query will have a benefit whether the database selects to use the RBO or
CBO...
IMHO. Kev.
__
Kevin Thomas Technical Analyst Deregulation
Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com
-Original Message- Sent: 07 August 2001 18:36 To: Multiple recipients of list ORACLE-L
When using first rows, you force the cost based
optimizer, in which the order of the
tables does not matter.
Order of the tables only matters when using the
ORDERED hint or using rbo AND there is
a tie ranking.
"Do not criticize someone until you walked a
mile in their shoes, that way when you
criticize them, you are a mile a way and have their shoes."
Christopher R. Spence OCP MCSE MCP
A+ RAPTOR CNA Oracle DBA
Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73
Princeton Street North, Chelmsford
01863
-Original Message- Sent: Tuesday, August 07, 2001 12:37 PM To: Multiple recipients of list ORACLE-L
Hi there,
Unfortunately you can't just throw things like
FIRST_ROWS at a select statement to
make it run faster. The person who wrote the statement should
have taken into account such things as:

a) Size of tables, ordering, which is the
driving table b) Indexes, are the being
used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF
will identify potential problem areas
with your database. c) Size of queries,
joins etc.
Too many developers do not write

stored procedure errors

2001-08-09 Thread Ranganath K


Hi Gurus,

I am creating a stored procedure using the below code.  The procedure gets
created successfully.  But while executing the procedure I am getting below
errors:
ERROR at line 1:
ORA-00907: missing right parenthesis
ORA-06512: at SCOTT.CREATE_RATEDOUTPUT, line 5
ORA-06512: at line 1

CREATE OR REPLACE procedure create_ratedOutput(tablename IN varchar2)
authid current_user
IS
BEGIN
EXECUTE IMMEDIATE 'create table '|| tablename ||'(
version char(1) not null,
ne_id number(5) not null,
ne_sequence number(9) not null,
ne_date date not null,
device_id_indictor char(1) not null,
device_id varchar2(40) not null,
service_type_1_rule char(1) not null,
raw_service_type1_id varchar2(20) not null,
override1_id varchar2(20),
service_type_2_rule char(1) not null,
raw_service_type2_id varchar2(20),
override2_id varchar2(20),
call_date date not null,
call_completion number(3) not null,
call_termination number(3) not null,
call_direction char(1) not null,
mobile_to_mobile_indicator char(1) not null,
electronic_serial_number varchar2(11),
initial_cell_site varchar2(10),
second_number varchar2(20) not null,
dest_address varchar2(64),
special_cases varchar2(5) not null,
call_start_time_1 date not null,
call_duration_1 number(6) not null,
call_start_time_2 date,
call_duration_2 number(6),
home_zone duration number(6),
roaming_indicator char(1) not null,
roaming_direction char(1),
service_provider number(9),
service_provider_batch number(9),
service_provider_location varchar2(12),
ip_address varchar2(15),
data_size number(9),
user_defined1 varchar2(40),
user_defined2 varchar2(40),
user_defined3 varchar2(40),
user_defined4 varchar2(40),
user_defined5 varchar2(40),
user_defined6 varchar2(40),
user_defined7 varchar2(40),
user_defined8 varchar2(40),

us_call_type number(2),
day_type number(2),
origin_city varchar2(15),
origin_state char(2),
origin_country_abbr char(4),
destination_city varchar2(15),
destination_state char(2),
destination_country_abbr char(4),
destination_lata char(4),
destination_ocn char(4),
destination_rocn char(4),
destination_ioc_boc char(1),
distance_dialed number(9),
billed_duration number(6),
rate_periods_used number(1),
rate_period_description varchar2(30),
st1_rate_period_1 number(2),
st1_billed_duration_1 number(6),
st1_charge_1 number(18, 4),
st1_rate_period_id_2 number(2),
st1_billed_duration_2 number(6),
st1_charge_2 number(18, 4),
st1_billed_duration_rest number(6),
st1_charge_rest number(18, 4),
st2_rate_period_1 number(2),
st2_billed_duration_1 number(6),
st2_charge_1 number(18, 4),
st2_rate_period_id_2 number(2),
st2_billed_duration_2 number(6),
st2_charge_2 number(18, 4),
st2_billed_duration_rest number(6),
st2_charge_rest number(18, 4),
state_taxes number(18, 4),
local_taxes number(18, 4),

status char(1),
status_date date,
billed_id varchar2(20) not null,
customer char(6) not null,
billed_start_date date not null,
duplicate_key_sequence char(1) not null,
company char(3),
actual_service_type1 varchar2(20),
actual_service_type2 varchar2(20),
customer_cycle number(2),
usage_file_end_day number(2),
sort_method char(1),
rate_plan varchar2(20),
rate_plan_effective_date date,
revenue_code_by_plan char(4),
revenue_code_by_service1 char(4),
revenue_code_by_service2 char(4),
billing_item char(4),
billing_seq char(2),
billing_po char(2),
billing_cancel_date date,
free_usage_method char(1),
volume_discount_method char(1),
invoice_summary1 char(1),
invoice_summary2 char(1),
free_usage_amount1 number(18, 4),
free_usage_amount2 number(18, 4),
free_usage_details varchar2(40),
vol_disc_amount_applied1 number(18, 4),
vol_disc_amount_applied2 number(18, 4),
vol_disc_details varchar2(40),
carrier1 varchar2(20),
action_type1 char(1),
carrier2 varchar2(20),
action_type2 char(1),
actual_st1_charge_total number(18, 4),
actual_st2_charge_total number(18, 4),
alternate_amounts_calculated char(1),
alternate_amount_1 number(18, 4),
alternate_amount_2 number(18, 4),

CONSTRAINT RatedCDROut_PK
PRIMARY KEY (billed_id, customer, billed_start_date,
duplicate_key_sequence))';
execute immediate 'insert into outputstatus
values('||chr(39)||tablename||chr(39)||','||chr(39)||1||chr(39)||')';
commit;
end;
/

Can anyone help me in this regard?

Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.

www.subexgroup.com


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

RE: O/S copies of datafiles


Just be sure that if you copy your listener.ora file from the first box you
change the hostname!  Otherwise you'll risk shutting down the listener on
the original box.

-Original Message-
Sent: Thursday, August 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L


Yes, what this is doing is the same as restoring from a cold backup. If
the machines are the same, you can just shutdown Oracle and copy data
files, control files, redo logs and the contents $ORACLE_HOME across to
an identical directory structure on a new machine, change any settings
like tnsnames.ora and listener.ora which might be machine specific, then
start the database on the new machine and you're all set. If the version
of Oracle is only a minor revision, then datafiles, control files et al
will be compatible, just move everything except the software. 

We use a similar technique with Sun Jumpstart to create new instances
for our developers. 

g



-Original Message-
Sent: Thursday, August 09, 2001 3:06 AM
To: Multiple recipients of list ORACLE-L


Hi,

This might be a stupid question, but I'll give it a go anyway.

I have two Unix boxes - a production and a newly created test box. The
production box has 8.0.5 and the test has 8.0.6 installed.

Is it possible to stop the database, take a backup of all the datafiles
(through the operating system) and then move them to the test server (in
the
same directory structure they were in in the production box). Would the
database open successfully?

Thanks in advance for all your help.

Regards,

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

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

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

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

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

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

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

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

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

2001-08-09 Thread Charles Wolfe


Does the owner of the batch job have Log on as a batch job permissions?
This is generally necessary for scheduled batch jobs on NT/2K.

hth

Chuck

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 08, 2001 8:45 PM




 Because you are running this in the AT scheduler, it is not executing
 with the same permissions.

 I'll bet that your batch script it not on the C: drive.

 Put it on the C: drive and see if it works.

 Jared





 Bunyamin K.
 Karadeniz  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
 bunyamink@havels   cc:
 an.com.tr  Subject: closing DB on NT
with a scheduled BATCH FILE
 Sent by:
 [EMAIL PROTECTED]


 08/08/01 06:15 AM
 Please respond to
 ORACLE-L






 Dear Gurus , I have a question , In fact I wonder if it is a bug of NT .

 I want to close and reopen database with a .BAT file .
  When I execute the .bat file directly it executes correctly . But When I
 execute it with a schedule with AT command then it connects but does not
 close database.

 How can I handle That. ?
 What do you do when you want to schedule startups and shutdowns of
database
 on NT?

 Thank you





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

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

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




break out the concepts manual and start reading.

joe

 [EMAIL PROTECTED] 08/08/01 10:25PM 
Hello gurus,I need some help here. I am trying to get 
some understanding of the following:- (Pardon my stupidity, if you can call 
this)1. What are chained rows?2. What is index/table 
partitioning?3. In case of getting a table fragmentation report, what 
does the following have a physical meaning:-pct_free 
?pct_used?it says Rows = 130750,?but my actual table has got 
more no. rows than that, how did that happen, even though I just ANALYSED the 
table, I did a Estinate statistics though, does it matter, not a compute 
statistics.block_alloc?block hwm?MB alloc?MB 
hwm?%hwm bytes used?TIArajaGet 250 color 
business cards for FREE!http://businesscards.lycos.com/vp/fastpath/-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Viraj 
Luthra INET: [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).

re: Designer 2000 install on Linux


If you saw my other post, it looks like designer is only
on NT/Win. If you can dual boot your system, you should
be able to get both the database and designer working on
NT or Win2000.

http://www.odtug.com has an email list (free, even to
non-members) for designer. also for JAVA, develop, etc.

As a student, you probably don't have access to Metalink,
but fyi, here is what is shown for Designer in the Technical
Libraries tab:




| Index Area -- Oracle Designer/Repository
|
| Use this self-service area to browse our Knowledge Base for
| support articles including technical bulletins, alerts, and 
| scripts. Also included here are reference materials such as
| product manuals, read me documents, installation guides, release
| notes, and white papers. This Self-Service Center contains the
| same information that is used by Oracle analysts to research
| technical issues. 
|
| Product Maintenance   Alerts   Documentation
|
| Information about patch sets, maintenance  releases and product
| compatibility. Note: for downloads click on the Patches button  of
| the main MetaLink menu. 
|
| Articles about known problems,   high-priority issues and specific
| recommendations to users. For additional Alerts, please refer to
| the Product Lifecycle   section of MetaLink. 
|
| Product specific documentation including  Installation Guides,
| Release Notes, and ReadMe files, as well as other concept and
| reference materials. 
|
| White Papers  Technical Notes
|
| Essays about products, features, and technology; written by Oracle
| subject  matter experts. 
|
| Product specific technical solutions, notes and documents.
|
| Browse the latest articles for useful information from our
| Knowledge Base. To search additional articles from the Knowledge
| Base, type related keywords in the Search field above and click
| Search. 
|
| Product Overview
|
| Oracle Designer 6i and Oracle Repository 6i are integral
| components of the Oracle Internet Developer Suite. 
|
| Oracle Designer 6i offers a rich toolset to model, generate, and
| capture the requirements of client-server and web-based
| applications quickly, accurately, and efficiently and support for
| these extensive features is provided by Oracle Repository 6i which
| is a highly scalable software configuration management (SCM)
| system. Oracle Repository manages structured and unstructured data
| throughout the development life cycle and can support
| multi-developer, multi-stream software development projects of any
| size and complexity. Product FAQ 
|
| Oracle 8.1.7 support requires use of a minimum certified
| Repository version, for additional information see  note:60705.1
| and support alert note:123484.1 
|
|
| This page was last updated 17-July-2001
|


[end excerpt]



*ALSO* 

Does your school have membership in the Oracle
Academic Initiative (or whatever they call it now)?

They used to give schools *any* Oracle software for a
one time $500 payment. I think that included what used to
be called bronze support.

If you wanted upgrades, you had to pay another $500.

Congratulations on picking a very interesting topic of study.

regards,
ep


 --
 
  From: Kevin Hedger [EMAIL PROTECTED]
  Date: Wed, 08 Aug 2001 14:05:57 +
  Subject: Designer 2000 install on Linux

[via ORACLE-L Digest -- Volume 2001, Number 221]


 
 I am in need of some advise.  I have a class that is requiring that I 
 install Oracle Designer 2000.  The class provides Designer 2000 for windows 
 with the book Rapid Applications Development with Oracle Designer 2000 
 Billings, Chris / Billings, Maria / Tower, Julia.
 
 The problem is that I have Oracle 8i Enterprise Edition loaded on a Redhat 
 6.2 Linux box.  I need to know where I can download designer 2000 for Linux 
 and if anyone has done this install I would greatly appreciate any advice or 
 direction anyone can give me.


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

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

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

2001-08-09 Thread Grabowy, Chris




Possibly related? 


"UUNET is experiencing 
a major outage in the North East part of the country. UUNET reports there is another major 
fiber cut in Baltimore."

-Original Message-From: 
Larry Elkins [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 
2001 4:03 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: List slow today?

  Stephen,
  
  I am seeing the same problem. 
  I went to the fatcity site (http://www.fatcity.com/ListGuru/login.php) 
  to see what was being posted, and quite a few messages have been sent to the 
  list. But very few have made it to my machine. Things have started to pick up 
  a tad in the last hour or so -- I've gotten 10 or so 
  messages.
  
  Regards,Larry G. 
  Elkins[EMAIL PROTECTED]214.954.1781 
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: 
Thursday, August 09, 2001 2:16 PMTo: Multiple recipients of list 
ORACLE-LSubject: OT: List slow today?
Other than during IOUG-A, I haven't seen this few messages. Is my 
mail server eating messages or is it just a slow day?

Stephen

Oracle8i eBoot Camp

2001-08-09 Thread kjanusz


Does anyone have any experience with the Oracle8i eBoot 
Camp put on by OraKnowledge?

Thanks,
Ken Janusz, CPIM


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

Oracle 8.1.7 client install on Win2K.


List,

I have just got my hands on a shiny new P4 1.3 gig box with Win2K pro. I
installed the Java 1.3.0_01 JRE, and tried to start up the 8.1.7 for NT
Oracle install to install the client software (this was downloaded from
technet BTW). The splash screen runs - but when going for the install (the
java one) nothing happens, I get an hourglass cursor for all of 3-4 seconds
then nothing..

There is nothing else installed on this box apart from Office 2000, as it
was totally empty apart from the OS when we got it.. Has anybody else had
these problems? I seem to remember somebody (I think it may have been
Kevin?) had a problem installing on a P4 box - was your problem similar to
this one?

All help is appreciated!

Regards

Mark

BTW - you may remember I had an OT problem a while back now - where I had a
brand new Geoforce 3 Gfx card, that wouldn't run. I slipped it in to this
new beast and you should see the thing run now!!

This PC now runs games in OpenGL and Direct3D modes with 1280*960 resolution
at roughly 65-70 frames per second!! With NO glitches!! Oh yeah I also have
one game installed on the system :)

Cheers

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

-- 
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: Fwd: RE: RAID or NOT to RAID?


Now that's a post :)

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Thursday, August 09, 2001 3:11 AM
To: Multiple recipients of list ORACLE-L


Hi all.
I've been disconnected for awhile - found myself out in Nebraska. Installing
81715/Win2000 on a new Dell PowerEdge 2500. Only had 6 drives on 1 IO
channel configured as 3 containers - RAID 1. The front grille reminds me
of an electric shaver. It was the kinda trip that ended with me pulling a
hamstring while unplugging a power cord for my notebook. Gotta stay hydrated
and get that daily banana for potassium.


repeat after me ...

RAID 10 != RAID 0+1
RAID 0+1 != RAID 10

Even with only 4 drives, when they might seem the same, 
RAID 0+1 is stripe first, then mirror.
RAID 10 is mirror first, then stripe.
As someone once said, the best way to tell how its configured, is to pull a
drive out of a hot swap bay, put it back in and see how many drives
re-silver. 
A corollary would be - pull one drive - and then pull another non-adjacent
drive (e.g. in the other cage). If its RAID 01 - you're completely hosed. So
much for non-destructive testing. :)

oh yeah, and it depends.

If you only need 8KB or 64 KB blocks at one time, go for neither, and just
separate files onto different RAID 1 volumes of 2 disks each. If you're
daring, don't even bother to use hardware RAID for the online redo logs -
and just duplex them with multiple log members of a redo log group.

After you locate what your point of contention is - either move the hot
spots out to dedicated drives, or add more drives to the volume that has the
most I/O. 

If you need massive amounts of data from full table scans - go for deeper
stripes. Even numbers of drives in a volume are preferable for RAID 0
stripes, odd for RAID 3,5. This makes it easy to calculate the stripe depths
as a multple of the db_block_size and OS io_size in your head.

Gaja wrote a great section on this topic in the Performance Tuning 101 Book.

And you can fix the RAID configuration by simply deleting the existing
RAID config - and starting from scratch. I had a site where a Dell Tech took
a perfectly good 4 x RAID 1 (8 drives) config and turn it into a single RAID
0+1 config. Ctrl-A at boot gets you into where you can wipe it clean and
start from scratch - assuming that you can wipe the slate clean.

And I'll beat Joe T to the punch - since you're going to have to re-install
the OS - Dell boxes run Linux pretty well. 
Just that Dell still sucks badly for calling RedHat Linux  Linux 7 on
their store website. That still pisses me off. 

Linux != RedHat.

Paul


[EMAIL PROTECTED] wrote:
 
 In a previous job I had to deal with this issue.  WinNT 4.0 on a dual 
 processor Dell box with 24G of RAID.  I had specified RAID 0 + 1 but 
 someone knew better and got it with RAID 5 (5 is obviously better 
 than 0).  The SA wouldn't or couldn't reconfigure and the job needed 
 to get done.
 
 It was for a decision support system (basically read-only) and it may 
 be that sort of a system is less impacted.  I abandoned any thought of 
 OFA. Just stick all the datafiles out on one directory branch (makes 
 cold backups easier) and let the RAID sort out the contention.
 
 I didn't like it because I was basically trusting to someone else's 
 decisions but performance was adequate and the task was successful.  
 I'm not sure that this would be true with an OLTP system.
 
 I've seen the notation RAID 10 (which is RAID 0 + 1).  Perhaps we 
 should standardize on that.  Obviously RAID 10 has to be twice as good 
 as RAID 5. Right?
 
 
 Denmark Weatherburne
 denmark_weatherburne@hoTo: Multiple
recipients of list ORACLE-L
 tmail.com  [EMAIL PROTECTED]
 Sent by:cc:
 [EMAIL PROTECTED]Subject: Fwd: RE:
RAID or NOT to RAID?
 
 
 08/08/2001 02:47 PM
 Please respond to
 ORACLE-L
 
 
 
 Hi DBA's,
 
 I hope I'm not opening a can of worms, but I'd like your feedback on 
 the issue of using RAID 5 on NT 4.0 with Oracle 8.0.5.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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

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

RE: Optimizer Mode......how to choose the right one?

Title: Message



Only 
if you hit a tie with the rank of predicates.

"Do not criticize someone until you walked a 
mile in their shoes, that way when you criticize them, you are a mile a way and 
have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 
Fuelspot 73 Princeton Street North, Chelmsford 01863  

  
  -Original Message-From: Steve Haas 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 12:55 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Optimizer Mode..how to choose the right one?
  Doesthe order of tablesalso make a 
  difference with a RULE hint?
  
  Steven HaasOpus Consultants, LLC
  
- Original Message - 
From: 
Christopher 
Spence 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, August 08, 2001 12:15 
PM
Subject: RE: Optimizer Mode..how to 
choose the right one?

I 
by no means say CBO doesn't make mistakes. It by far does, but the 
original statement stays accurate, order of tables only matters with RBO (if 
comes up with tie) and ordered hint. 

There is nothing wrong with getting it in a good order, I just wanted 
to stress that it only truely matters during those two conditions. 
That's all, not trying to be adversary.

CNA is Novell Admin, I haven't done it in a while, I originally 
started as a Novell Admin.
Raptor is a firewall product I spent about4 years working 
with.

"Do not criticize someone until you walked 
a mile in their shoes, that way when you criticize them, you are a mile a 
way and have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 
Fuelspot 73 Princeton Street North, Chelmsford 01863  

  
  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 
  2001 11:08 AMTo: '[EMAIL PROTECTED]'; 
  '[EMAIL PROTECTED]'Subject: RE: Optimizer Mode..how to 
  choose the right one?
  Ahh, but Christopher, therein 
  lies the problem. The CBO makes mistakes and sometimes needs the 
  gentle nudging of the ORDERED hint. I've seen a query go from hours 
  to 2 seconds after some analysis of the execution plan that was failing 
  miserably.
  Love the sig. You are a 
  CNA? A Raptor? Am I missing something? 
  Lisa Koivu Vikings Fan (and DBA) Ft. Lauderdale, FL, USA 
  
-Original Message- 
From: Christopher Spence [SMTP:[EMAIL PROTECTED]] 
Sent: Wednesday, August 08, 2001 10:27 AM 
To: 
Multiple recipients of list ORACLE-L 
Subject: 
RE: Optimizer Mode..how to choose the right 
one? 
The driving table order does not matter when 
using CBO, it will detirmine the 
order based on cost, not placement. 
The order only matters when dealing with the 
RBO (when it hits a tie, otherwise it 
will change it, but this happens often), or when using the 
ordered hint. 
"Do not criticize someone until you walked a 
mile in their shoes, that way when 
you criticize them, you are a mile a way and have their shoes." 

Christopher R. Spence OCP MCSE 
MCP A+ RAPTOR CNA Oracle DBA 
Phone: (978) 322-5744 Fax: (707) 885-2275 
Fuelspot 73 Princeton Street North, 
Chelmsford 01863  

-Original Message- Sent: Wednesday, August 08, 2001 4:30 AM 
To: Multiple recipients of list 
ORACLE-L 
Order of the tables only matters when 
using the ORDERED hint or using rbo AND there is a tie ranking. 
But surely the very nature of the CHOOSE hint 
is to select the best method to use 
whether it's to follow the RBO or the CBO. Therefor ensuring that 
you have the driving table defined in 
the correct place within the query will have a benefit whether the database selects to use the RBO or 
CBO... 
IMHO. Kev. 
__ 
Kevin Thomas Technical Analyst Deregulation 
Services Calanais Ltd. 
Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com 

-Original Message- Sent: 07 August 2001 18:36 To: Multiple recipients of list ORACLE-L 
When using first rows, you force the cost 
based optimizer, in which the order 
of the tables does not matter. 
Order of the tables only matters when using 
the ORDERED hint or using rbo AND 
there is a tie ranking. 
"Do not criticize someone until you walked a 
mile in their shoes, that way when 
you criticize them, you are a mile a way and have their shoes." 

Christopher R. Spence OCP MCSE 
MCP

OT:I was thrown out of the list




LOL!!

Oh goshwhat happened to the 
Good Old Days, when people had names?

I mean, should I call 
myself "Dusty Old Sack of Shit DBA" ?

sigh


thanks for a laugh Joe. 


  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 4:16 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OT:I was thrown out of the list
  it was
  
  cozur anoviceOracle Certifiable 
  DBBS
  
  joe 
  [EMAIL PROTECTED] 08/09/01 12:44PM 
  Hi,
   I did not receive a mail for two 
  days, I started smelling rat and sent a test mail to the list. I was told I am 
  not a member. Is it some revamping happening or I was thrown out because did 
  people start receiving viruses from my id ???
  list administrator please help
  jared
  bruce
  
  please explain
  cozI am anoviceOracle Certifiable 
  DBBS

OT Dorothy Parker :)


I would like to apologise to anyone that was offended by
the topic.

I would also would like to apologise to anyone that was
offended by the above apology.

I would also like to apologise to anyone that might have
been offended by the implication that males can't be
wh*res.

I would also would like to apologise to anyone that was
offended by the above apology.

I would also would like to apologise to anyone that was
offended by all these apologies.


--

| From: Ruth Gramolini [EMAIL PROTECTED]
| Date: Wed, 8 Aug 2001 09:32:49 -0400
| Subject: Re: computer history stories - Now: Age discrimination?
|
|Now we are getting a bit sexist...better watch it or I'll tell your 
|Mothers
|and/or Wives.
|
|RBG
|- Original Message -
|To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|Sent: Wednesday, August 08, 2001 10:02 AM
|
|
| Eric,
|
|  When challenged (at a party), to use to word
| 'horticulture' correctly in a sentence,
| Dorethy Parker immediately replied'
|
| You can lead a horticulture, but
| you can't make her think
|
| 
|  didn't some famous person such as Mae West say
|  you can lead a horse to water,
|  but not a horticulture. ???

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

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

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

2001-08-09 Thread tday6


Thanks for the enlightenment.  What is the performance difference, from an
Oracle database standpoint, between RAID 0+1 and RAID 1+0?

Unfortunately one cannot change the configuration on Government Furnished
Equipment without a bit of a hassle.  In a more perfect world, of course,
but in real life, not likely.


   

Paul Drake 

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

om  [EMAIL PROTECTED]

Sent by: cc:   

root@fatcity.Subject: Re: Fwd: RE: RAID or NOT to 
RAID?
com

   

   

08/09/2001 

03:10 AM   

Please 

respond to 

ORACLE-L   

   

   





Hi all.
I've been disconnected for awhile - found myself out in Nebraska.
Installing 81715/Win2000 on a new Dell PowerEdge 2500.
Only had 6 drives on 1 IO channel configured as 3 containers - RAID 1.
The front grille reminds me of an electric shaver.
It was the kinda trip that ended with me pulling a hamstring while
unplugging a power cord for my notebook. Gotta stay hydrated and get
that daily banana for potassium.


repeat after me ...

RAID 10 != RAID 0+1
RAID 0+1 != RAID 10

Even with only 4 drives, when they might seem the same,
RAID 0+1 is stripe first, then mirror.
RAID 10 is mirror first, then stripe.
As someone once said, the best way to tell how its configured, is to
pull a drive out of a hot swap bay, put it back in and see how many
drives re-silver.
A corollary would be - pull one drive - and then pull another
non-adjacent drive (e.g. in the other cage). If its RAID 01 - you're
completely hosed.
So much for non-destructive testing. :)

oh yeah, and it depends.

If you only need 8KB or 64 KB blocks at one time, go for neither, and
just separate files onto different RAID 1 volumes of 2 disks each. If
you're daring, don't even bother to use hardware RAID for the online
redo logs - and just duplex them with multiple log members of a redo log
group.

After you locate what your point of contention is - either move the hot
spots out to dedicated drives, or add more drives to the volume that has
the most I/O.

If you need massive amounts of data from full table scans - go for
deeper stripes.
Even numbers of drives in a volume are preferable for RAID 0 stripes,
odd for RAID 3,5.
This makes it easy to calculate the stripe depths as a multple of the
db_block_size and OS io_size in your head.

Gaja wrote a great section on this topic in the Performance Tuning 101
Book.

And you can fix the RAID configuration by simply deleting the existing
RAID config - and starting from scratch. I had a site where a Dell Tech
took a perfectly good 4 x RAID 1 (8 drives) config and turn it into a
single RAID 0+1 config. Ctrl-A at boot gets you into where you can
wipe it clean and start from scratch - assuming that you can wipe the
slate clean.

And I'll beat Joe T to the punch - since you're going to have to
re-install the OS - Dell boxes run Linux pretty well.
Just that Dell still sucks badly for calling RedHat Linux  Linux 7 on
their store website.
That still pisses me off.

Linux != RedHat.

Paul


[EMAIL PROTECTED] wrote:

 In a previous job I had to deal with this issue.  WinNT 4.0 on a dual
 processor Dell box with 24G of RAID.  I had specified RAID 0 + 1 but
 someone knew better and got it with RAID 5 (5 is obviously better than
 0).  The SA wouldn't or couldn't reconfigure and the job needed to get
 done.

 It was for a decision support system (basically read-only) and it may be
 that sort of a system is less impacted.  I abandoned any thought of OFA.
 Just stick all the datafiles out on one directory branch (makes cold
 backups easier) and let the RAID sort out the contention.

 I didn't like it because I was basically trusting to someone else's
 decisions but performance was adequate and the task was successful.  I'm
 not sure that this would

Re: OT Dorothy Parker :)

2001-08-09 Thread Thater, William


Scott Shafer wrote:

 Eric,

 flame bate
 If anyone is offended that easily, they need to get a helmet, because
 their life sucks - and will continue to suck until they butch up a bit.
 Political Correctness allows the weak-minded to exert control over a
 society that they otherwise could not handle...
 /flame bate - hey the list IS slow ;-) 

 Scott Shafer
 San Antonio, TX

geez, is it friday yet?  i hope so, cuz we just got done laying off 25% of
the people here.

same work + less people := get-out-of-dodge-NOW.


--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

MIPS:  Meaningless Indicator of Processor Speed.

-- 
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: List slow today?

2001-08-09 Thread Jenkins, Michael


Let's face it.  The only decent operating system was TRS-DOS. :o

Just doing my part!

--Michael

-Original Message-
Sent: Thursday, August 09, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L


how about this:
 
unix sucks.
 
that ought to generate a little bit of traffic.
 
hth.
 
Paul
 

-Original Message-
Sent: Thursday, August 09, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


Other than during IOUG-A, I haven't seen this few messages.  Is my mail
server eating messages or is it just a slow day?
 
Stephen 


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

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

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

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

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

FW: karma - DBD module

2001-08-09 Thread Larry Elkins


Listers,

Have any of you got Karma up and running on HP-UX 11.0 against 8.1.7.x EE? I
have sent an email back asking my friend for more details on the problems he
is seeing, but it would be helpful in the meantime to at least know if
others have been successful.

See his question below.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

-Original Message-
Sent: Thursday, August 09, 2001 12:10 AM
To: [EMAIL PROTECTED]


Larry - how are things going?

Sam and I are trying to get Karma running.  No problems installing perl or
the DBI module, but the DBD module fails.  Do you know anyone who has
successfully set this up on an hp system?

Thanks, Lance

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

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

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

REVISIT: FK Constraint naming.


Hi List,

A few weeks ago somebody sent a message to the list about the naming of FK
constraints to something other than the system generated names. I have come
across a pretty nifty script that will do this for you automatically - check
it out:

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759997,00.html

HTH whoever asked..

Mark

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

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

REVISIT: FK Constraint naming.


Hi List,

A few weeks ago somebody sent a message to the list about the naming of FK
constraints to something other than the system generated names. I have come
across a pretty nifty script that will do this for you automatically - check
it out:

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759997,00.html

HTH whoever asked..

Mark

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

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

OT: Klipsh

Title: OT:  Klipsh





OMG the Klipsh computer setup is killer! Just replaced my JBL Pro-Logic setup with it, and this was $100 cheaper than when I bought my JBL 3 years ago. Highly worth it for anyone gaming/music.

Just figured I would mention it ;)


Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863

RE: OT:I was thrown out of the list




lighten up.

joe

 John Lewis [EMAIL PROTECTED] 08/09/01 
04:16PM 
Was this really 
necessary?

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 1:16 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OT:I was thrown out of the list
  it was
  
  cozur anoviceOracle Certifiable 
  DBBS
  
  joe 
  [EMAIL PROTECTED] 08/09/01 12:44PM 
  Hi,
   I did not receive a mail for two 
  days, I started smelling rat and sent a test mail to the list. I was told I am 
  not a member. Is it some revamping happening or I was thrown out because did 
  people start receiving viruses from my id ???
  list administrator please help
  jared
  bruce
  
  please explain
  cozI am anoviceOracle Certifiable 
  DBBS

RE: PERL PROGRAMMING


Highly recommend O'Reilly's Perl Library, You can get the entire thing on a
single cd for around $65.  I have all the books, even though I don't use
Perl often.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Thursday, August 09, 2001 2:25 AM
To: Multiple recipients of list ORACLE-L


Hi gurus,

We have Lot of PERL scripts. (Previous DBA). 
I am newby to perl . please suggest sites , to start.

TIA
naren

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

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

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

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

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


h Paaauuul!

Can you give a quick explication of how many drives/mount-points
are advised, in terms of recovery issues, for the OS (NT/Win2k),
Oracle software, database files, etc.?

(is there something about this in Sean O'Neill's NT standards 
document?)

thanks,
ep

ps, glad you enjoyed the midwest, I have a friend in Omaha.

general RAID backgrounder: http://www.evdbt.com/Raid.pdf
(linked from: http://www.evdbt.com/library.htm )


 
 --
 
  From: Paul Drake [EMAIL PROTECTED]
  Date: Thu, 09 Aug 2001 02:10:33 -0400
  Subject: Re: Fwd: RE: RAID or NOT to RAID?

[via ORACLE-L Digest -- Volume 2001, Number 221]

...

 repeat after me ...
 
 RAID 10 != RAID 0+1
 RAID 0+1 != RAID 10
 
 Even with only 4 drives, when they might seem the same, 
 RAID 0+1 is stripe first, then mirror.
 RAID 10 is mirror first, then stripe.

...
 Gaja wrote a great section on this topic in the Performance Tuning 101
 Book.

...

  Hi DBA's,
  
  I hope I'm not opening a can of worms, but I'd like your feedback on the
  issue of using RAID 5 on NT 4.0 with Oracle 8.0.5.
 
 
 --


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

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

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

ADMIN: List status, bounces, archives

2001-08-09 Thread Bruce Bergman


Yes, the lists were down virtually all night (Pacific time).  I had been
doing some work on the server around midnight and maybe an hour after I
called it quits, the server locked up.  Sorry for the span of silence and
the ensuing rush of E-mail that is *still* being sent out.  All should be
well shortly.

Yes, some of you were bounced.  novicedba@hotmail was bounced because
his/her mailbox was too full (over quota) to accept new messages (a problem
with using free E-mail, I know).  You folks using free E-mail services need
to watch to make sure your mailbox doesn't fill up.  On a high traffic list
like this one, it's easy to do, and if you get over quota, ListGuru will
bounce you.  DBarbour was bounced because of transient delivery failures in
getting the mail to your site.  Normally I don't give public reasons for
bounces, but since those two asked in a public forum, I figure they were
fair game. ;-)

Finally, a reminder that there ARE archives at our site.  Go to
http://www.fatcity.com/ListGuru and sign up if you haven't already (it's
free).  You can then browse old archives, search, etc.  The archives are in
a wide-beta, and work is ongoing virtually daily, but you should be able to
mutz around with a minimum of hassle.  Feedback, suggestions, requests for
certain features, criticism, etc., are all welcome and appreciated.

A major new release of the archive site will be made next week.  One of the
cool features you'll see is the ability to find out if there are any
problems
with the list server, which lists are closed, etc.  Stay tuned.

thanks,
bruce
[EMAIL PROTECTED]


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

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

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

Password_verify_function in 8.1.6 doesn't allow ALTER USER IDENTI


I found plenty of angry people with my problem on Metalink forums, but no
one that got an answer from Oracle.

We still have a number of people connecting to Oracle via Powerbuilder
applications.  We want to use a password_verify_function but we'll be
upgrading 8.1.6 soon, and the ALTER USER xxx IDENTIFIED BY xxx; command will
no longer work in conjunction with it (I just discovered this today during
testing in development).  The Powerbuilder code to change the password
currently uses ALTER USER

Does anyone know if
1) There is any way to get it to work short of granting ALTER USER (*not* an
option :) to each user
2) OCIPasswordChange() can be called from Powerbuilder, and where I could
find sample code to do so if it is possible
3) There is any other solution?

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

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

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


Main things I noticed were: 
jumpers became sweaters
u was removed from words like colour 
Philosopher's Stone became the Sorcerer's Stone

Of course I only read the first two books...

-Original Message-
Sent: Thursday, August 09, 2001 2:50 AM
To: Multiple recipients of list ORACLE-L


How do the two versions differ?

 [EMAIL PROTECTED] 5/8/2001 4:32:27 
J.K. Rowling (does Harry Potter count as science fiction?) American and 
British versions, as well as the cassettes of all 4 books (that was my 
birthday present from my parents last year)




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

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

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

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

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

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

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

2001-08-09 Thread Jenkins, Michael





itworks
4 me

cozweerall
Oracle 
CertifiableDOSSDBAs

--Michael-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 4:41 
PMTo: Multiple recipients of list ORACLE-LSubject: OT:I 
was thrown out of the list

  LOL!!
  
  Oh goshwhat happened to 
  the Good Old Days, when people had names?
  
  I mean, should I call 
  myself "Dusty Old Sack of Shit DBA" ?
  
  sigh
  
  
  thanks for a laugh Joe. 
  
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 
4:16 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: OT:I was thrown out of the 
list
it was

cozur anoviceOracle Certifiable 
DBBS

joe 
[EMAIL PROTECTED] 08/09/01 12:44PM 
Hi,
 I did not receive a mail for two 
days, I started smelling rat and sent a test mail to the list. I was told I 
am not a member. Is it some revamping happening or I was thrown out because 
did people start receiving viruses from my id ???
list administrator please help
jared
bruce

please explain
cozI am anoviceOracle Certifiable 
DBBS

RE: backup, recovery web site ?

2001-08-09 Thread John Leadeham



 I saw a backup  recovery web site a while ago.  That
 site devotes to B  R and it claims it has the most
 knowledge on BR topic.  I cannot find it anymore. 


www.backupcentral.com

John. 


This message is intended only for the use of the person(s) (the intended recipient 
(s)) to whom it is addressed.
It may contain information which is privileged and confidential. 
If you are not the intended recipient, please contact the sender as soon as possible.
The views expressed in this communication may not necessarily be the views of InterX 
plc.
Any copyright in this message shall remain vested in InterX plc © and the intended 
recipient may only copy the same for internal business purposes or as otherwise stated 
in this message.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Leadeham
  INET: [EMAIL PROTECTED]

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

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

2001-08-09 Thread Mohammad Rafiq


Use following couple of times till your stale staus is changed

alter system switch logfile
/



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 09 Aug 2001 10:41:06 -0800

Hi listers,
Issuing a select * from v$logfile I found that the status of several of
redologs is STALE.
What does this mean? How can I solve it?
Thanks in advance!

Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua

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

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

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

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

OT ADMIN: List status, bounces, archives


Bruce, could you bounce me for a day, for...oh, say, foul
language, outdated information, unsuitably patriarchal
grammar...something...anything.

But...then againdon't.   I don't want to miss any of
this!

;-)

Ross


-Original Message-
Sent: Thursday, August 09, 2001 5:46 PM
To: Multiple recipients of list ORACLE-L


Yes, the lists were down virtually all night (Pacific time).  I had been
doing some work on the server around midnight and maybe an hour after I
called it quits, the server locked up.  Sorry for the span of silence and
the ensuing rush of E-mail that is *still* being sent out.  All should be
well shortly.

Yes, some of you were bounced.  novicedba@hotmail was bounced because
his/her mailbox was too full (over quota) to accept new messages (a problem
with using free E-mail, I know).  You folks using free E-mail services need
to watch to make sure your mailbox doesn't fill up.  On a high traffic list
like this one, it's easy to do, and if you get over quota, ListGuru will
bounce you.  DBarbour was bounced because of transient delivery failures in
getting the mail to your site.  Normally I don't give public reasons for
bounces, but since those two asked in a public forum, I figure they were
fair game. ;-)

Finally, a reminder that there ARE archives at our site.  Go to
http://www.fatcity.com/ListGuru and sign up if you haven't already (it's
free).  You can then browse old archives, search, etc.  The archives are in
a wide-beta, and work is ongoing virtually daily, but you should be able to
mutz around with a minimum of hassle.  Feedback, suggestions, requests for
certain features, criticism, etc., are all welcome and appreciated.

A major new release of the archive site will be made next week.  One of the
cool features you'll see is the ability to find out if there are any
problems
with the list server, which lists are closed, etc.  Stay tuned.

thanks,
bruce
[EMAIL PROTECTED]


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

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

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

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

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

RE: Unix Client Install


Hmm, could one do this onto a different version of UNIX and just relink the
software?

-Original Message-
Sent: Wednesday, August 08, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L


well, um, that's how I will install oracle (same version obviously) on 
second and third machines.

I work with my SA, making sure everything is the same (Unix patches, 
filesystems, etc) and then we copy.


From: Ed Maurer [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Unix Client Install
Date: Wed, 08 Aug 2001 16:25:39 -0800


Given virtually identical Unix machines (i.e.,
same kernel and patch sets,) is there any reason NOT
to take the cowards way out and use a tar file of
$ORACLE_HOME from the first client only install
(from CD with X-win client) to install to another
machine? My original install CD has 'walked'; I
could download and cpio ... or wait 3 days for
support to get me new CD's. Why shouldn't I use
the working installation as a base? Are there any
machine specific actions taken by the installer
besides obvious tnsnames if you use the installation
gui) for client installations ?

TIA
Ed Maurer
Acquirex

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

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

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

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

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

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

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

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

2001-08-09 Thread Jamadagni, Rajendra


What is the extra comma doing before the CONSTRAINT RatedCDROut_PK ??

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

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

*2

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

*2

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

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

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

Re: OT Dorothy Parker :)

2001-08-09 Thread Scott Shafer


Eric,

flame bate
If anyone is offended that easily, they need to get a helmet, because
their life sucks - and will continue to suck until they butch up a bit. 
Political Correctness allows the weak-minded to exert control over a
society that they otherwise could not handle...
/flame bate - hey the list IS slow ;-) 

Scott Shafer
San Antonio, TX

PS -- I realize your response was humorous, Ruth.  grin


dark matter wrote:
 
 I would like to apologise to anyone that was offended by
 the topic.
 
 I would also would like to apologise to anyone that was
 offended by the above apology.
 
 I would also like to apologise to anyone that might have
 been offended by the implication that males can't be
 wh*res.
 
 I would also would like to apologise to anyone that was
 offended by the above apology.
 
 I would also would like to apologise to anyone that was
 offended by all these apologies.
 
 --
 
 | From: Ruth Gramolini [EMAIL PROTECTED]
 | Date: Wed, 8 Aug 2001 09:32:49 -0400
 | Subject: Re: computer history stories - Now: Age discrimination?
 |
 |Now we are getting a bit sexist...better watch it or I'll tell your
 |Mothers
 |and/or Wives.
 |
 |RBG

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

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

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

RE: OT Dorothy Parker :)


ROFL!!!

G*damn, the best laugh all day!

-Original Message-
Sent: Thursday, August 09, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I would like to apologise to anyone that was offended by
the topic.

I would also would like to apologise to anyone that was
offended by the above apology.

I would also like to apologise to anyone that might have
been offended by the implication that males can't be
wh*res.

I would also would like to apologise to anyone that was
offended by the above apology.

I would also would like to apologise to anyone that was
offended by all these apologies.


--

| From: Ruth Gramolini [EMAIL PROTECTED]
| Date: Wed, 8 Aug 2001 09:32:49 -0400
| Subject: Re: computer history stories - Now: Age discrimination?
|
|Now we are getting a bit sexist...better watch it or I'll tell your 
|Mothers
|and/or Wives.
|
|RBG
|- Original Message -
|To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|Sent: Wednesday, August 08, 2001 10:02 AM
|
|
| Eric,
|
|  When challenged (at a party), to use to word
| 'horticulture' correctly in a sentence,
| Dorethy Parker immediately replied'
|
| You can lead a horticulture, but
| you can't make her think
|
| 
|  didn't some famous person such as Mae West say
|  you can lead a horse to water,
|  but not a horticulture. ???

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

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

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

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

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

Re[2]: OT Dorothy Parker :)

2001-08-09 Thread dgoulet


OY VAY, I must of missed a good one!!  Thank God!

Dick Goulet

Thought for the day: Never be afraid to try something  new. Remember that
a lone amateur built the Ark. A large group of  professionals built the
Titanic.

Reply Separator
Author: Thater; William [EMAIL PROTECTED]
Date:   8/9/2001 12:45 PM

Scott Shafer wrote:

 Eric,

 flame bate
 If anyone is offended that easily, they need to get a helmet, because
 their life sucks - and will continue to suck until they butch up a bit.
 Political Correctness allows the weak-minded to exert control over a
 society that they otherwise could not handle...
 /flame bate - hey the list IS slow ;-) 

 Scott Shafer
 San Antonio, TX

geez, is it friday yet?  i hope so, cuz we just got done laying off 25% of
the people here.

same work + less people := get-out-of-dodge-NOW.


--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

MIPS:  Meaningless Indicator of Processor Speed.

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

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

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

FW: karma

2001-08-09 Thread Larry Elkins


Listers,

I'm relaying something from a friend. This is a follow-up to an earlier
email where he had problems with DBD. He got that squared away and is now
seeing the following when starting Karma.

Anyone have ideas?

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

Larry,

I found it in a README file (doh!) - you have to use the latest version of
perl (5.6.1) with a ccflag of +z and libraries -lcl and -lpthread.  After
reinstalling perl, DBD installs fine.  Now we are trying Karma.  It installs
with no errors, but when I start it, I receive the following (know anyone
who knows c and perl?):

$ karmactl -s -c basic.conf
main::printHelp() called too early to check prototype at
/opt/perl5/bin//karmactl line 96.
main::startKarma() called too early to check prototype at
/opt/perl5/bin//karmactl line 102.
main::checkRunning() called too early to check prototype at
/opt/perl5/bin//karmactl line 119.
main::refreshKarma() called too early to check prototype at
/opt/perl5/bin//karmactl line 122.
main::stopKarma() called too early to check prototype at
/opt/perl5/bin//karmactl line 125.
main::reloadKarma() called too early to check prototype at
/opt/perl5/bin//karmactl line 134.
main::statusKarma() called too early to check prototype at
/opt/perl5/bin//karmactl line 136.
main::cleanupKarma() called too early to check prototype at
/opt/perl5/bin//karmactl line 143.
main::printHelp() called too early to check prototype at
/opt/perl5/bin//karmactl line 146.
main::get_pid() called too early to check prototype at
/opt/perl5/bin//karmactl line 116.
Missing braces on \N{} at /opt/perl5/bin//karmactl line 363, within pattern
Execution of /opt/perl5/bin//karmactl aborted due to compilation errors.


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

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

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

RE: OT:I was thrown out of the list




No, but as Garrison Keillor 
said recently, 


Why would any comedian 
give up such a laugh? It would be like not
milking a cow. You lose the milk and it irritates the cow. 


  -Original Message-From: John Lewis 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 
  5:21 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: OT:I was thrown out of the list
  Was this really 
  necessary?
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 
1:16 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: OT:I was thrown out of the 
list
it was

cozur anoviceOracle Certifiable 
DBBS

joe 
[EMAIL PROTECTED] 08/09/01 12:44PM 
Hi,
 I did not receive a mail for two 
days, I started smelling rat and sent a test mail to the list. I was told I 
am not a member. Is it some revamping happening or I was thrown out because 
did people start receiving viruses from my id ???
list administrator please help
jared
bruce

please explain
cozI am anoviceOracle Certifiable 
DBBS

RE: stored procedure errors

2001-08-09 Thread Koivu, Lisa

Title: RE: stored procedure errors





Ranganath, 
Your dynamic statement is missing a paren somewhere, that's why it compiles without error. 
Dig through your statement, you'll find where the paren is missing (it'll be within your quotes


HTH
Lisa Koivu
Headache Queen and DBA
Ft. Lauderdale, FL, USA


-Original Message-
From: Ranganath K [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
Subject: stored procedure errors


Hi Gurus,


I am creating a stored procedure using the below code. The procedure gets
created successfully. But while executing the procedure I am getting below
errors:
ERROR at line 1:
ORA-00907: missing right parenthesis
ORA-06512: at SCOTT.CREATE_RATEDOUTPUT, line 5
ORA-06512: at line 1


CREATE OR REPLACE procedure create_ratedOutput(tablename IN varchar2)
authid current_user
IS
BEGIN
EXECUTE IMMEDIATE 'create table '|| tablename ||'(
version char(1) not null,
ne_id number(5) not null,
ne_sequence number(9) not null,
ne_date date not null,
device_id_indictor char(1) not null,
device_id varchar2(40) not null,
service_type_1_rule char(1) not null,
raw_service_type1_id varchar2(20) not null,
override1_id varchar2(20),
service_type_2_rule char(1) not null,
raw_service_type2_id varchar2(20),
override2_id varchar2(20),
call_date date not null,
call_completion number(3) not null,
call_termination number(3) not null,
call_direction char(1) not null,
mobile_to_mobile_indicator char(1) not null,
electronic_serial_number varchar2(11),
initial_cell_site varchar2(10),
second_number varchar2(20) not null,
dest_address varchar2(64),
special_cases varchar2(5) not null,
call_start_time_1 date not null,
call_duration_1 number(6) not null,
call_start_time_2 date,
call_duration_2 number(6),
home_zone duration number(6),
roaming_indicator char(1) not null,
roaming_direction char(1),
service_provider number(9),
service_provider_batch number(9),
service_provider_location varchar2(12),
ip_address varchar2(15),
data_size number(9),
user_defined1 varchar2(40),
user_defined2 varchar2(40),
user_defined3 varchar2(40),
user_defined4 varchar2(40),
user_defined5 varchar2(40),
user_defined6 varchar2(40),
user_defined7 varchar2(40),
user_defined8 varchar2(40),


us_call_type number(2),
day_type number(2),
origin_city varchar2(15),
origin_state char(2),
origin_country_abbr char(4),
destination_city varchar2(15),
destination_state char(2),
destination_country_abbr char(4),
destination_lata char(4),
destination_ocn char(4),
destination_rocn char(4),
destination_ioc_boc char(1),
distance_dialed number(9),
billed_duration number(6),
rate_periods_used number(1),
rate_period_description varchar2(30),
st1_rate_period_1 number(2),
st1_billed_duration_1 number(6),
st1_charge_1 number(18, 4),
st1_rate_period_id_2 number(2),
st1_billed_duration_2 number(6),
st1_charge_2 number(18, 4),
st1_billed_duration_rest number(6),
st1_charge_rest number(18, 4),
st2_rate_period_1 number(2),
st2_billed_duration_1 number(6),
st2_charge_1 number(18, 4),
st2_rate_period_id_2 number(2),
st2_billed_duration_2 number(6),
st2_charge_2 number(18, 4),
st2_billed_duration_rest number(6),
st2_charge_rest number(18, 4),
state_taxes number(18, 4),
local_taxes number(18, 4),


status char(1),
status_date date,
billed_id varchar2(20) not null,
customer char(6) not null,
billed_start_date date not null,
duplicate_key_sequence char(1) not null,
company char(3),
actual_service_type1 varchar2(20),
actual_service_type2 varchar2(20),
customer_cycle number(2),
usage_file_end_day number(2),
sort_method char(1),
rate_plan varchar2(20),
rate_plan_effective_date date,
revenue_code_by_plan char(4),
revenue_code_by_service1 char(4),
revenue_code_by_service2 char(4),
billing_item char(4),
billing_seq char(2),
billing_po char(2),
billing_cancel_date date,
free_usage_method char(1),
volume_discount_method char(1),
invoice_summary1 char(1),
invoice_summary2 char(1),
free_usage_amount1 number(18, 4),
free_usage_amount2 number(18, 4),
free_usage_details varchar2(40),
vol_disc_amount_applied1 number(18, 4),
vol_disc_amount_applied2 number(18, 4),
vol_disc_details varchar2(40),
carrier1 varchar2(20),
action_type1 char(1),
carrier2 varchar2(20),
action_type2 char(1),
actual_st1_charge_total number(18, 4),
actual_st2_charge_total number(18, 4),
alternate_amounts_calculated char(1),
alternate_amount_1 number(18, 4),
alternate_amount_2 number(18, 4),


CONSTRAINT RatedCDROut_PK
PRIMARY KEY (billed_id, customer, billed_start_date,
duplicate_key_sequence))';
execute immediate 'insert into outputstatus
values('||chr(39)||tablename||chr(39)||','||chr(39)||1||chr(39)||')';
commit;
end;
/


Can anyone help me in this regard?


Regards,


Ranganath



DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your

Is there any place(except AUDIT LOG) to see the activities

2001-08-09 Thread ASHOKE MANDAL


Greetings,

I like to know if there is any view or place in Oracle where we can see who 
has dropped an oracle user or did some other activities in the datbase.

My understanding is that such auditing can be done by turning on the 
AUDITING. But our auditing is not on and we need to find out who has done 
some changes to the database.

Is there any way?

Thanks,
Ashoke

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

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

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

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

2001-08-09 Thread Kevin Kostyszyn




LOLhhehehehehe, that was 
good work. well I am off, gonna go melt onto the Garden State Parkway 
oven!!!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Thursday, August 09, 2001 4:41 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT:I was thrown out of the 
  list
  LOL!!
  
  Oh goshwhat happened to 
  the Good Old Days, when people had names?
  
  I mean, should I call 
  myself "Dusty Old Sack of Shit DBA" ?
  
  sigh
  
  
  thanks for a laugh Joe. 
  
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 
4:16 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: OT:I was thrown out of the 
list
it was

cozur anoviceOracle Certifiable 
DBBS

joe 
[EMAIL PROTECTED] 08/09/01 12:44PM 
Hi,
 I did not receive a mail for two 
days, I started smelling rat and sent a test mail to the list. I was told I 
am not a member. Is it some revamping happening or I was thrown out because 
did people start receiving viruses from my id ???
list administrator please help
jared
bruce

please explain
cozI am anoviceOracle Certifiable 
DBBS

RE: List slow today?

2001-08-09 Thread Arich Henneman


Maybe that last upgrade of Oracle fixed all the problems and we can
dispand this group, DBA's are no longer needed :)

We can concentrate on NT sucks :)

Arich Henneman
Not Oracle Certified

 [EMAIL PROTECTED] 08/09/01 12:51PM 
I think all the people with Oracle problems took the day off.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Stephen Andert [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, August 09, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: List slow today?

Other than during IOUG-A, I haven't seen this few messages.  Is
my
mail server eating messages or is it just a slow day?
 
Stephen 

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

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

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

RE: OT:I was thrown out of the list

2001-08-09 Thread John Lewis




Was this really 
necessary?

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 1:16 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OT:I was thrown out of the list
  it was
  
  cozur anoviceOracle Certifiable 
  DBBS
  
  joe 
  [EMAIL PROTECTED] 08/09/01 12:44PM 
  Hi,
   I did not receive a mail for two 
  days, I started smelling rat and sent a test mail to the list. I was told I am 
  not a member. Is it some revamping happening or I was thrown out because did 
  people start receiving viruses from my id ???
  list administrator please help
  jared
  bruce
  
  please explain
  cozI am anoviceOracle Certifiable 
  DBBS

Oracle DBA Needed in Cleveland, Ohio..

2001-08-09 Thread OraStaff


This Biotechnology Client in the Cleveland Ohio area, needs an Oracle DBA
to join its' I.T. staff.

* Candidates local to the Greater Cleveland area only will be considered.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.


*Responsibilities:
-Oracle instance creation and maintenance. 
-Tunes hardware and software to ensure acceptable database performance. 
-Performs regularly scheduled backup and recovery tasks. 
-Establishes regular schedule for such activities. 
-Brings technology expertise to the table and evaluates new technologies,
solutions and products. 
-Identifies tasks associated necessary within a project and works within
standards and set
 timeframes. 
-Provides schema version control. 
-Provides internal troubleshooting and on occasion at customer sites. 


*Requirements:
-2-5 years of experience in the IT industry. 
-2-3 years experience creating, maintaining and tuning Oracle databases 
 (core database server products). 
-Demonstrated experience trouble shooting and resolving problems internally
 and preferably at customer sites as well. 
-Must have experience working with large databases (100+ gigabyte). 
-Development skills in PERL, shell script, and Java. 
-Other desirable skills include instance creation and maintenance, backup
and recovery, 
 technology expertise and evaluation, and schema version control.
 
- U.S. Citizenship or permanent residency also required.
  

These positions offer:
   * Stability 
   * The opportunity to become a key member of the team.
   * Base salary of 82K-D.O.E...maybe more
   
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
ph: 1-800 -549-8502
Please use job code One/Cleve/DBA/Kristen

Candidates who we are interested in will be contacted immediately.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




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

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

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