date:20010307


That is because sequences are allocated in the library cache since 7.3. And
objects from this area of the shared pool are prone to be flushed. As
Gorbounov said you can set them nocache or use the dbms_shared_pool.keep for
pinning them in the library cache.

Regards.
 -Mensaje original-
 De:   Vadim Gorbounov [SMTP:[EMAIL PROTECTED]]
 Enviado el:   martes 6 de marzo de 2001 21:14
 Para: Multiple recipients of list ORACLE-L
 Asunto:   RE: [Q] why sequence number jump?
 
 do
 ALTER SEQUENCE  xxx nocache;
 
 
 -Original Message-
 Sent: Tuesday, March 06, 2001 2:35 PM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 
 
 We have ORACLE 8.1.6 on UNIX server.  The database has been run 4 years no
 sequence number probem.  Recently, user complaint on couple of sequence
 nuber jump rapidly.  The sequence number jump may 20, 40 or 100.
 
 I know I can use "alter sequence XXX nocahe" to avoid this problem.  I
 want know why it jump?
 
 
 Thanks.
 
 
 
 Think you know someone who can answer the above question? Forward it to
 them!
 to unsubscribe, send a blank email to [EMAIL PROTECTED]
 to subscribe send a blank email to [EMAIL PROTECTED] 
 Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vadim Gorbounov
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

2001-03-07 Thread Mark Leith


This happened because your new database did not have the
product_user_profile table created with all the relevant info.

It happened because Oracle says it happened, and gave you the route of how
to fix it.

It happened because you didn't run PUPBLD.SQL..

HTH :)

Mark

-Original Message-
Setiawan
Sent: Wednesday, March 07, 2001 05:55
To: Multiple recipients of list ORACLE-L


I've  tried it...
it works..

but my primary question not only how to fix it but
why this thing happened ?



 Bambang Setiawan 

 "Joseph S. Testa" [EMAIL PROTECTED] 03/07/01 11:35 
READ the screen it tell you what to do:


HINT:  You may need to run PUPBLD.SQL as SYSTEM



Does it get more easier than that?

if you dont understand, break out the documentation and start reading.

joe





Bambang Setiawan wrote:

 Wahai Guys,

 I created second database using Database Assistant on NT.
 There's no error when I create this 2nd DB.
 Then I make a host-string name 'dblokal2' for my second database.

 I can connect to my second db , but there's an error :
 the message written below :

 SQL conn beng/bambang@dblokal2;
 Error accessing PRODUCT_USER_PROFILE
 Warning:  Product user profile information not loaded!
 You may need to run PUPBLD.SQL as SYSTEM
 Connected.

 why ? for there's no error when I create 2nd DB.
 please help me to fix it ...

  Bambang Setiawan 



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

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

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

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

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

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

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

long row

2001-03-07 Thread benajam lhoussain


Oracle says data type Long can contain 2G data.
but when I insert it larger than 4k, I got the error :
oerr ora 01704:
01704, 0, "string literal too long"

thanx for your help.
Lhoussain.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: benajam lhoussain
  INET: [EMAIL PROTECTED]

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

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




Hi,

Our company's librarian search for that CD now,
It's that true we only can use RMAN with OEM, can I start learning to use
RMAN without installing OEM ?
Because I have to backup my company db

Thank you in advance



-Original Message-
Sent: Wednesday, 7 March 2001 5:22 PM
To: '[EMAIL PROTECTED]'


Hi.

No, its called Oracle Enterprise Manager, it normally comes in the box of
cd's that the Oracle8i Enterprise Edition comes in.
If not you will have to order it from Oracle, but it is worth having it.

*   Clinton S. Naud
*   Head systems administration
*   Tel: 011 685 4304
*   Fax: 011 685 4303
*   Cell: 082 377 1726
*   E-mail: [EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, March 07, 2001 11:17 AM
To: [EMAIL PROTECTED]


Hi,

Is the CD call Oracle8i Enterprise Edition ?

-Original Message-
Sent: Wednesday, 7 March 2001 5:06 PM
To: '[EMAIL PROTECTED]'


Hi.

OEM is on seperate disks.
Have you installed it before? The disks do normally come with Oracle
database cd's.
Check to see if you have the disks and then mail me if you do.

Clint

*   Clinton S. Naud
*   Head systems administration
*   Tel: 011 685 4304
*   Fax: 011 685 4303
*   Cell: 082 377 1726
*   E-mail: [EMAIL PROTECTED]


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


Dear Clinton and other Oracle Gurus,

Can you lead me how to start OEM, do I need to reinstall my oracle because I
was not choosing sever manager option in my first installation.

Thank you

-Original Message-
Naude
Sent: Wednesday, 7 March 2001 2:55 PM
To: Multiple recipients of list ORACLE-L


Use the OEm backup and recovery option.

You can create backup databases for fall over.
OEM also does exports as well as database backup (control files and archive
logs etc).

Clint

*   Clinton S. Naud
*   Head systems administration


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


Hi guys,

Do you guys have any idea..
How can I backup my entire Oracle8i system so that it allow me to recover
without reinstalling Oracle8i (reconfigure) after my hardisk crash?
What kind of os files I need to backup and I plan using tape. or may be CD-R

Thank You

Sinardy

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

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

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

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

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

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

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

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

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

2001-03-07 Thread Saurabh


I feel u can't insert in this way. this way it will only insert  value given
by u when it prompts.
if u give  then it will insert that only, else if u had to give the entire
value after the  sign in the original value.

i think the best way is to change the default define character with one not
used at all like. ~ or ^..or any other..

saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 3:10 PM


 WHen it asks for value just enter .It'll insert ATT.This is very simple
way
 wothout bothring about put  in strings or double quotes.You can try that
also

 Cheers
 Ganti



 ---

 The contents of this e-mail are confidential to the ordinary user
 of the e-mail address to which it was addressed and may also be
 privileged. If you are not the addressee of this e-mail you should
 not copy, forward, disclose or otherwise use it or any part of it
 in any form whatsoever. If you have received this e-mail in error
 please notify us by telephone or e-mail the sender by replying to
 this message, and then delete this e-mail and other copies of it
 from your computer system. Thank you

 We reserve the right to monitor all e-mail communications through
 our network
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author:
   INET: [EMAIL PROTECTED]

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

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

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

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

RE: Oracle Masters program

2001-03-07 Thread Ranganath K


Dear Mr. Robert,

Hi!  Do you have the ILT Study material for any of the masters' modules?
If so, can you lend it to me?  By the way, in which countries is the masters
certification program conducted?  Please reply.

Thanks and Regards,

Ranganath

-Original Message-
Robert D SSgt AFIT/SCA
Sent: Tuesday, March 06, 2001 11:52 PM
To: Multiple recipients of list ORACLE-L


As to whether or not it still exists...this should answer your question:

http://education.oracle.com/masters/index.html

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


Does it still exist?

I can't find reference to it anywhere in the new www.oracle.com
http://www.oracle.com  layout.

I am just curious - I had major problems with it when they informed me that
taking Microsoft courses on NT wasn't good enough, to be certifiable as an
Oracle on NT Master you had to have learned NT from... Oracle.  Even though
their course names were identical to the MS ones.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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


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

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

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

RE: Dropping datafiles


NO way. At least you could resize it smaller.

Regards.

 -Mensaje original-
 De:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 12:05
 Para: Multiple recipients of list ORACLE-L
 Asunto:   Dropping datafiles
 
 
 
 Ouch, big mistake : I added a datafile to a wrong tablespace...
 I don't know how to drop this datafile
 can anybody help ?
 
 Thanx !!
 
 L.A.
 
 
 -- 
 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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

2001-03-07 Thread Eriovaldo do Carmo Andrietta


Friend :

If you are using sql  plus type :

set define off

It will solve the problem.


Eriovaldo do Carmo Andrietta
[EMAIL PROTECTED]
Limeira/SP - Brasil

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


 WHen it asks for value just enter .It'll insert ATT.This is very simple
way
 wothout bothring about put  in strings or double quotes.You can try that
also

 Cheers
 Ganti



 ---

 The contents of this e-mail are confidential to the ordinary user
 of the e-mail address to which it was addressed and may also be
 privileged. If you are not the addressee of this e-mail you should
 not copy, forward, disclose or otherwise use it or any part of it
 in any form whatsoever. If you have received this e-mail in error
 please notify us by telephone or e-mail the sender by replying to
 this message, and then delete this e-mail and other copies of it
 from your computer system. Thank you

 We reserve the right to monitor all e-mail communications through
 our network
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author:
   INET: [EMAIL PROTECTED]

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

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

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

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

2001-03-07 Thread Mark Leith


alter database datafile_name offline drop;

I think you need to have the database in NOARCHIVELOG mode to do this
though. Also, I'm pretty sure that you will not be able to reuse the
datafile name, as it will still be stored within the bowels of Oracle.

The list can confirm if I am wrong though :)

HTH

Mark


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




Ouch, big mistake : I added a datafile to a wrong tablespace...
I don't know how to drop this datafile
can anybody help ?

Thanx !!

L.A.


--
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: 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: bitmap index problem


No. The problem is that Oracle 8i standard doesn't support bitmap. You must
purchase the 8i Enterprise Edition, if you need bitmaps. Refer to 70059.1 in
Metalink.
Regards.





 -Mensaje original-
 De:   Leslie Lu [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 3:06
 Para: Multiple recipients of list ORACLE-L
 Asunto:   Re: bitmap index problem
 
 Rocky,
 
 compatible is compatible=8.1.5
 
 
 --- Rocky Welch [EMAIL PROTECTED] wrote:
  Hi Leslie,
  What is your COMPATIBLE parameter set to in the
  init.ora file?
  
  -Rocky
  
  --- Leslie Lu [EMAIL PROTECTED] wrote:
   Hi all,
   
   When I tried to build a bitmap index (8.1.5), I
  got
   this:
   ERROR at line 1:
   ORA-00439: feature not enabled: Bit-mapped indexes
   
   The error desc is:
   SQL !oerr ora 439
   00439, 0, "feature not enabled: %s"
   // *Cause:  The specified feature is not enabled.
   // *Action: Do not attempt to use this feature.

   May I know how to enable the feature?  Thank you.
   
   
   
   Leslie
   
   
   __
   Do You Yahoo!?
   Get email at your own domain with Yahoo! Mail. 
   http://personal.mail.yahoo.com/
   -- 
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
   -- 
   Author: Leslie Lu
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
  FAX: (858) 538-5051
   San Diego, California-- Public Internet
  access / Mailing Lists
  
 
 
   To REMOVE yourself from this mailing list, send an
  E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
   the message BODY, include a line containing: UNSUB
  ORACLE-L
   (or the name of mailing list you want to be
  removed from).  You may
   also send the HELP command for other information
  (like subscribing).
  
  
  __
  Do You Yahoo!?
  Get email at your own domain with Yahoo! Mail. 
  http://personal.mail.yahoo.com/
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Rocky Welch
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 
 
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be removed
  from).  You may
  also send the HELP command for other information
  (like subscribing).
 
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail. 
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Leslie Lu
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

2001-03-07 Thread Clinton Naude


Of course there is.
Alter database datafile '" offline drop.

*   Clinton S. Naud
*   Head systems administration
*   Tel: 011 685 4304
*   Fax: 011 685 4303
*   Cell: 082 377 1726
*   E-mail: [EMAIL PROTECTED]


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


NO way. At least you could resize it smaller.

Regards.

 -Mensaje original-
 De:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 12:05
 Para: Multiple recipients of list ORACLE-L
 Asunto:   Dropping datafiles
 
 
 
 Ouch, big mistake : I added a datafile to a wrong tablespace...
 I don't know how to drop this datafile
 can anybody help ?
 
 Thanx !!
 
 L.A.
 
 
 -- 
 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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

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

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


No, because the datafile will be remaining in the dictionary. The clause
offline or offline drop deletes from the controlfile. Therefore, you will
receive dbwr errors on account that it expects to allocate data in that
datafile. The behaviour is the same even if you use locally management
tablespace.

As I said before the only thing you could do, is resize it if you can't
recreate the tablespace.

Regards.

 -Mensaje original-
 De:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 12:55
 Para: Multiple recipients of list ORACLE-L
 Asunto:   RE:Dropping datafiles
 
 alter database 'datafile' offline drop
 and then recreate the datafile in some othe tablespace
 
 Cheers
 Ganti
 
 
 
 ---
 
 The contents of this e-mail are confidential to the ordinary user
 of the e-mail address to which it was addressed and may also be
 privileged. If you are not the addressee of this e-mail you should
 not copy, forward, disclose or otherwise use it or any part of it
 in any form whatsoever. If you have received this e-mail in error
 please notify us by telephone or e-mail the sender by replying to
 this message, and then delete this e-mail and other copies of it
 from your computer system. Thank you
 
 We reserve the right to monitor all e-mail communications through
 our network
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

2001-03-07 Thread Clinton Naude


Quite correct, offline drop is archive log mode, using just drop is non
archive log mode.

Clint

*   E-mail: [EMAIL PROTECTED]


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


alter database datafile_name offline drop;

I think you need to have the database in NOARCHIVELOG mode to do this
though. Also, I'm pretty sure that you will not be able to reuse the
datafile name, as it will still be stored within the bowels of Oracle.

The list can confirm if I am wrong though :)

HTH

Mark


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




Ouch, big mistake : I added a datafile to a wrong tablespace...
I don't know how to drop this datafile
can anybody help ?

Thanx !!

L.A.


--
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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Clinton Naude
  INET: [EMAIL PROTECTED]

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

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

2001-03-07 Thread Mark Leith


A 12154 is TNS could not resolve service name. This means that you have
either entered the wrong connect description, or you do not have the right
entry in your tnsnames.ora file. Now I am a little confused with this, as
you HAVE managed to connect to shut the database down, but can no longer
connect to start it up again?

First of all I would check the tnsnames files on both your PC, and the
server you are trying to connect to - check the service name is valid. If
nothing jumps out at you, you could then post it to the list, as even
missing a parenthesis could cause this problem..

HTH

Mark

-Original Message-
Dasgupta
Sent: Tuesday, March 06, 2001 07:21
To: Multiple recipients of list ORACLE-L


Hi:

I am trying to startup and shutdown a remote database on NT using SQLPLUS. I
can shutdown alright but while attempting to startup I get ORA-12154. I am
connecting as internal .
What am I doing wrong?

Manas.


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

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

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

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

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

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

RE: Oracle Masters program

2001-03-07 Thread Martin Kendall


This is my understanding as I am studying for my Certificate at the moment.

At the end I will be an OCP but a DBA type of OCP .

Martin

-Original Message-
Sent: 07 March 2001 12:51
To: Multiple recipients of list ORACLE-L


This is funny, because last year they were tagging "Masters" courses at the
end of the OCP training path - you earned your OCP, and only then could you
take Masters courses.

They had at least twenty, including Internet DBA courses, Internet
Applications DBA courses, Master DBA on Solaris, on NT, etc.  Now I learn
that the Masters program was a legacy training path, that it has been
discontinued, etc.  

I assume this means very very few people bought into the idea of taking
Masters sessions after earning an OCP, maybe it wasn't worth the costs.

Now they have "job-related" paths.

???

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


-Original Message-
From:   Yexley Robert D SSgt AFIT/SCA [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 06, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Masters program

As to whether or not it still exists...this should answer your
question:

http://education.oracle.com/masters/index.html

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


Does it still exist?

I can't find reference to it anywhere in the new www.oracle.com
http://www.oracle.com  layout.

I am just curious - I had major problems with it when they informed
me that
taking Microsoft courses on NT wasn't good enough, to be certifiable
as an
Oracle on NT Master you had to have learned NT from... Oracle.  Even
though
their course names were identical to the MS ones.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


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

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

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

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

Script for INDEX creation

2001-03-07 Thread Sonja ehovi


List hi!
From one schema in production database  I want to create same indexes on the
other (same schema on different instance). 
I know that I can do it with imp in indexfile, but it is not good enough.
Does anyone have script with which I could dinamicaly create indexes on all
tables within schema? 
Something like this:
select ('drop index'||' '||index_name||';' )
from user_indexes
 
TIA,
Sonja

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

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

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

RE: Re[2]: PL/SQL Debug tools

2001-03-07 Thread Jamadagni, Rajendra


Procedure builder is going away  you'll have to use stored procedure
editor from within forms builder.

HTH
Raj

*

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 ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

*

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

Fw: Virus Alert! (yes, you can open this)

2001-03-07 Thread Ruth Gramolini



- Original Message -
To: "tax announce" [EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 9:08 AM


 ***
 THIS IS VERY IMPORTANT!!!
 ***

 I received a virus alert from our anti-virus software provider this
morning
 concerning a new e-mail virus.  You probably have also received a warning
 from George Benda.  This is a REAL VIRUS and a serious one!  Do not open
it
 if you see it.  OUR PC'S ARE CURRENTLY NOT PROTECTED against this virus.

 Here's the specifics on the new virus:

 Subject:  "FW: Naked Wife"

 Message body:
My wife never look like that! ;)
Best Regards,
UserName

 Attachment:  "NakedWife.exe"

 IF YOU EXECUTE THIS IT MAY RENDER YOU PC UNBOOTABLE!!
 I REPEAT, DO NOT OPEN THIS!

 Thank You

 Peter F. Jaquith
 Network Administrator
 Vermont Department of Taxes
 [EMAIL PROTECTED]
 (802) 828-5174


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

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

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

RE: Dropping datafiles


Clint,

I advise you to read Oracle Backup  Recovery from Rama Velpuri. One of
McGraw series.

Regards.

 -Mensaje original-
 De:   Clinton Naude [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 13:36
 Para: Multiple recipients of list ORACLE-L
 Asunto:   RE: Dropping datafiles
 
 Quite correct, offline drop is archive log mode, using just drop is non
 archive log mode.
 
 Clint
 
 * E-mail: [EMAIL PROTECTED]
 
 
 -Original Message-
 Sent: Wednesday, March 07, 2001 2:06 PM
 To: Multiple recipients of list ORACLE-L
 
 
 alter database datafile_name offline drop;
 
 I think you need to have the database in NOARCHIVELOG mode to do this
 though. Also, I'm pretty sure that you will not be able to reuse the
 datafile name, as it will still be stored within the bowels of Oracle.
 
 The list can confirm if I am wrong though :)
 
 HTH
 
 Mark
 
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Wednesday, March 07, 2001 11:05
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 Ouch, big mistake : I added a datafile to a wrong tablespace...
 I don't know how to drop this datafile
 can anybody help ?
 
 Thanx !!
 
 L.A.
 
 
 --
 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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Clinton Naude
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

OPS on RS6000

2001-03-07 Thread Dave Morgan


Hi Cyril, Alex,

Oracle Parallel Server 8.1.6 on IBM AIX 4.3.3 requires
HACMP/ESClustering software, Add on to AIX 

SSA Serial Storage Array, IBM's Disk Array
provide shared disk

Hi speed Interconnect   Serial Port to Serial port direct connection
- this is not a network interface!

Alex, if you can cluster SUNs clustering IBM's is trivial :) 
Hooray for smitty !

HTH
Dave

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

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

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

Re: Dropping datafiles

2001-03-07 Thread Rachel Carmichael


depends on if you can take away that tablespace for a while.

If you can, and you really truly want to remove the datafile:

export the data from that tablespace (either table by table or by user)

alter that tablespace offline and drop it

recreate the tablespace without that datafile

import the data you exported.


If you can't take that tablespace away, and you are willing to live with the 
"vestige" datafile:

you can resize the datafile down to a trivial amount and just leave it 
there.

Rachel


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Dropping datafiles
Date: Wed, 07 Mar 2001 03:05:23 -0800



Ouch, big mistake : I added a datafile to a wrong tablespace...
I don't know how to drop this datafile
can anybody help ?

Thanx !!

L.A.


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

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

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

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

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

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

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

RE:Dropping datafiles

2001-03-07 Thread Rachel Carmichael


NOO

you will screw up the database that way.

You MUST recreate the tablespace without it. You cannot just offline drop 
it.


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE:Dropping datafiles
Date: Wed, 07 Mar 2001 03:55:27 -0800

alter database 'datafile' offline drop
and then recreate the datafile in some othe tablespace

Cheers
Ganti



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you

We reserve the right to monitor all e-mail communications through
our network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Connected users ??

2001-03-07 Thread dieter . oberkofler


Hi!
Have a look at my shareware tool
named OSession. It's small and
easy to use.
Cheers

DO

email: [EMAIL PROTECTED]
web:   www.materialdreams.com

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


Hi guys,

It is possible to list all user that currently connected to my Oracle8i ?
and what is the command or script or source of information ?

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

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

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

2001-03-07 Thread Orastaff


*Description:
Oklahoma City, Oklahoma company needs an Oracle DBA experience to join 
its' I.T. team.
This position will have typical DBA responsibilities i.e.: physical
database design, installations,performance analysis, system tuning, backup, 
recovery, etc.
This is a  full time staff position. No sub-contractors please.

* Requirements:
  - 3+ yrs Oracle DBA experience.
  - Unix and NT experience highly desired
  - U.S. Citizenship or permanent residency

This position offers:
* Opportunity to become a key member of the team
* Compensation- Base salary 65-95K D.O.E.  
* Challenge
* Relocation Assistance

NO sub contracting positions available.

*U.S. citizenship or green card holders only

PLEASE do not send your resume if you are not in the
United States.

For  immediate consideration, please send your resume
as an attachment to:

OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need
sponsorship
Email: [EMAIL PROTECTED]
Please use job code: One/DBA/OK. City/Frank

Note: This is only one of the many opportunities that
we have available across the U.S. 
for candidates with Oracle skills who are U.S.
citizens or permanent residents. 
So if this one is not a match for you, we invite you 
to send us your resume- as we quite possibly have the
opportunity that you are seeking.

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
you.
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:8.0.5 to 8i upgrade

2001-03-07 Thread GANTI . SIVA




Hi man,

during migration you just follow these steps.I didn't read any document.The
migration typically takes 2-3 hours on each database (You have to upgrade your
replication also if it is there).It depends on your machine RAM etc ofcourse

1) run u0800050.sql in $ORACLE_HOME/rdbms/admin directory

2) Run catrep.sql to install new replication objects

3)Run r0800050.sql  on top of catrep.This'll update any replication objects

Revalidate all objects using utlrp.sql

don't forget to read these scripts before mig.. Take backup of existing
databases

Enjoy man

Cheers
Ganti



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Dropping datafiles

2001-03-07 Thread Joanne Graham


If you're on an appropriate version on Oracle and the file doesn't yet
contain any data you could always resize the file to virtually nothing.


-Original Message-
Christian
Sent: Wednesday, March 07, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L


Clint,

I advise you to read Oracle Backup  Recovery from Rama Velpuri. One of
McGraw series.

Regards.

 -Mensaje original-
 De:   Clinton Naude [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 13:36
 Para: Multiple recipients of list ORACLE-L
 Asunto:   RE: Dropping datafiles

 Quite correct, offline drop is archive log mode, using just drop is non
 archive log mode.

 Clint

 * E-mail: [EMAIL PROTECTED]


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


 alter database datafile_name offline drop;

 I think you need to have the database in NOARCHIVELOG mode to do this
 though. Also, I'm pretty sure that you will not be able to reuse the
 datafile name, as it will still be stored within the bowels of Oracle.

 The list can confirm if I am wrong though :)

 HTH

 Mark


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




 Ouch, big mistake : I added a datafile to a wrong tablespace...
 I don't know how to drop this datafile
 can anybody help ?

 Thanx !!

 L.A.


 --
 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: 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).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Clinton Naude
   INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: Off Topic - PKZIP

2001-03-07 Thread nldrien1



Check out  Info zip at :  http://www.info-zip.org/pub/infozip/

It has zip/unzip utils for almost all platforms (including MAC and
Windows).

HTH,

Dave Drienhuizen




   

"Smith, Ron

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

om  Subject: Off Topic - PKZIP

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

07-03-2001 

16:41  

Please respond 

to ORACLE-L

   

   




This is off topic but I figured someone on the list would know the answer.
Is there a way to create a PKZIP file on a MAC machine and then unzip it on
an NT machine?

Ron Smith
Database Administration
[EMAIL PROTECTED]


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




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopien te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst  Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of

Re: Oracle Masters program

2001-03-07 Thread Jonathan Gennick


Tuesday, March 06, 2001, 9:05:27 AM, Patrice Boivin wrote:
BPJ I am just curious - I had major problems with it when they informed me that
BPJ taking Microsoft courses on NT wasn't good enough, to be certifiable as an
BPJ Oracle on NT Master you had to have learned NT from... Oracle.  Even though
BPJ their course names were identical to the MS ones.

My impression of the Oracle Masters program is that it
exists in order to get people to take courses. To get a
master's certificate, it's not a matter of whether you know
the material, or learn it somewhere else, it's just a matter
of paying to sit through a specific list of courses offered
by Oracle. At least with OCP certification, you have to go
through an exam to show that you know something.


Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org


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

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

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


Do you have set it TWO_TASK ?. If the answer is yes, unset it. 

Do you have the parameter SQLNET.AUTHENTICATION_SERVICES = in the
sqlnet.ora ?. Remove it.

Regards.

 -Mensaje original-
 De:   Raghu Kota [SMTP:[EMAIL PROTECTED]]
 Enviado el:   mircoles 7 de marzo de 2001 18:16
 Para: Multiple recipients of list ORACLE-L
 Asunto:   Re: Svrmgrl "connect internal" asks for password??
 
 give default password "oracle"
 
 
 From: "Fowler, Kenneth R" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Svrmgrl "connect internal" asks for password??
 Date: Wed, 07 Mar 2001 09:00:44 -0800
 
 List,
 
 
 I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl
 "connect internal" seems to want a password...
 
 
 Sun Microsystems Inc.   SunOS 5.8   Generic February 2000
 
 
 Configured oracle environment aliases...
 
 Alias SID   Oracle Home
 - ---   ---
 dba816dba816/Volumes/app/oracle/product/8.1.6
 dba817dba817/Volumes/app/oracle/product/8.1.7
 
 $ id
 uid=301(oracle) gid=300(dba)
 $ groups
 dba
 $ env | grep ORACLE
 ORACLE_BASE=/Volumes/app/oracle
 $ dba816
 dba816 $ env | grep ORACLE
 ORACLE_BASE=/Volumes/app/oracle
 ORACLE_SID=dba816
 ORACLE_HOME=/Volumes/app/oracle/product/8.1.6
 dba816 $ cdcreate
 /Volumes/app/oracle/admin/dba816/create
 dba816 $ svrmgrl
 
 Oracle Server Manager Release 3.1.6.0.0 - Production
 
 Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
 
 Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
 With the Partitioning option
 JServer Release 8.1.6.2.0 - Production
 
 SVRMGR connect internal;
 Password:
 Password:
 ORA-01031: insufficient privileges
 SVRMGR ^D
 Server Manager complete.
 dba816 $ dba817
 dba817 $ env | grep ORACLE
 ORACLE_BASE=/Volumes/app/oracle
 ORACLE_SID=dba817
 ORACLE_HOME=/Volumes/app/oracle/product/8.1.7
 dba817 $ cdcreate
 /Volumes/app/oracle/admin/dba817/create
 dba817 $ svrmgrl
 
 Oracle Server Manager Release 3.1.7.0.0 - Production
 
 Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
 
 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
 With the Partitioning option
 JServer Release 8.1.7.0.0 - Production
 
 SVRMGR connect internal;
 Connected.
 SVRMGR ^D
 Server Manager complete.
 
 
 I know that the usual reason for this is that the account running svrmgrl
 
 is
 not a member of the appropriate unix group (usually "dba" or as specified
 
 at
 installation time) but this is not the case here.  On this server I have
 Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7
 (Home = /Volumes/app/oracle/product/8.1.7).  My login script sets up 
 aliases
 for each SID listed in /var/opt/oracle/oratab.  These aliases use the 
 oraenv
 script with environment variable ORAENV_ASK=NO to set appropriate values 
 for
 ORACLE_SID, ORACLE_HOME and PATH etc.  Other than that, the environment
 is
 exactly the same regardless of what SID I switch to (see log above).
 However "connect internal" asks for a password for Oracle 8.1.6 but does 
 not
 ask for one for Oracle 8.1.7.  I am pretty sure that I specified that the
 group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue.
 
 
 Can anybody give me some pointers of other things to look at to try and
 resolve the problem???
 
 
 Thanks,
 Ken
 _
 Clinical and Regulatory Informatics - Groton/New London
 Coordinator, Business and Technical Services
 Tel: (860) 732-0026Fax: (860) 715-8346
 Email: [EMAIL PROTECTED]
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Fowler, Kenneth R
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Raghu Kota
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of

RE: Off Topic - PKZIP

Title: RE: Off Topic - PKZIP

 -Original Message-
 From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
 Sent: mercredi, 7. mars 2001 07:41
 To: Multiple recipients of list ORACLE-L
 Subject: Off Topic - PKZIP

 This is off topic but I figured someone on the list would 
 know the answer.
 Is there a way to create a PKZIP file on a MAC machine and 
 then unzip it on
 an NT machine?

Another suggestion, since no one has mentioned this- the best (IMO) compression program on the Macintosh is Stuffit.
http://www.aladdinsys.com/products/stuffit/index.html
It can create self-extracting files (.exe) to send to a PC, and I'm pretty sure that it can create zip files (but I would have to check at home.)

I just used it yesterday to uncompress a UNIX tar file on my Macintosh at home.
It's a very common program so someone around the office might have it on their machine.
Unfortunately the freeware version only decompresses files.

Disclaimer: I am not affiliated with Aladdin Systems and do not profit from sales of Stuffit in anyway.

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

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

RE: Svrmgrl connect internal asks for password??

2001-03-07 Thread Mohan, Ross

Title: RE: Svrmgrl connect internal asks for password??





Metalink: 114384.1


-Original Message-
From: Terry Ball [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Svrmgrl connect internal asks for password??



Try looking in $ORACLE_HOME/rdbms/audit directory. If this directory is
full, it can not create the .aud file to log that someone is using svrmgrl and
will
ask for password.


Terry


Fowler, Kenneth R wrote:


 List,

 I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl
 connect internal seems to want a password...

 Sun Microsystems Inc. SunOS 5.8 Generic February 2000

 Configured oracle environment aliases...

 Alias SID Oracle Home
 - --- ---
 dba816 dba816 /Volumes/app/oracle/product/8.1.6
 dba817 dba817 /Volumes/app/oracle/product/8.1.7

 $ id
 uid=301(oracle) gid=300(dba)
 $ groups
 dba
 $ env | grep ORACLE
 ORACLE_BASE=/Volumes/app/oracle
 $ dba816
 dba816 $ env | grep ORACLE
 ORACLE_BASE=/Volumes/app/oracle
 ORACLE_SID=dba816
 ORACLE_HOME=/Volumes/app/oracle/product/8.1.6
 dba816 $ cdcreate
 /Volumes/app/oracle/admin/dba816/create
 dba816 $ svrmgrl

 Oracle Server Manager Release 3.1.6.0.0 - Production

 Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

 Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
 With the Partitioning option
 JServer Release 8.1.6.2.0 - Production

 SVRMGR connect internal;
 Password:
 Password:
 ORA-01031: insufficient privileges
 SVRMGR ^D
 Server Manager complete.
 dba816 $ dba817
 dba817 $ env | grep ORACLE
 ORACLE_BASE=/Volumes/app/oracle
 ORACLE_SID=dba817
 ORACLE_HOME=/Volumes/app/oracle/product/8.1.7
 dba817 $ cdcreate
 /Volumes/app/oracle/admin/dba817/create
 dba817 $ svrmgrl

 Oracle Server Manager Release 3.1.7.0.0 - Production

 Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

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

 SVRMGR connect internal;
 Connected.
 SVRMGR ^D
 Server Manager complete.

 I know that the usual reason for this is that the account running svrmgrl is
 not a member of the appropriate unix group (usually dba or as specified at
 installation time) but this is not the case here. On this server I have
 Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7
 (Home = /Volumes/app/oracle/product/8.1.7). My login script sets up aliases
 for each SID listed in /var/opt/oracle/oratab. These aliases use the oraenv
 script with environment variable ORAENV_ASK=NO to set appropriate values for
 ORACLE_SID, ORACLE_HOME and PATH etc. Other than that, the environment is
 exactly the same regardless of what SID I switch to (see log above).
 However connect internal asks for a password for Oracle 8.1.6 but does not
 ask for one for Oracle 8.1.7. I am pretty sure that I specified that the
 group name be dba for 8.1.6 and 8.1.7 so that should not be the issue.

 Can anybody give me some pointers of other things to look at to try and
 resolve the problem???

 Thanks,
 Ken
 _
 Clinical and Regulatory Informatics - Groton/New London
 Coordinator, Business and Technical Services
 Tel: (860) 732-0026 Fax: (860) 715-8346
 Email: [EMAIL PROTECTED]

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

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


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

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

2001-03-07 Thread Fowler, Kenneth R


Something I forgot to mention in the original post...


I am trying to create test databases (one for Oracle 8.1.6 and one for
Oracle 8.1.7).  The database creation scripts and the parameter files are
created from templates and thus all parameters are pretty much equivalent
except in places where they obviously need to differ (dbname etc).  Here is
an example...


$ dba816
dba816 $ cdpfile
/Volumes/app/oracle/admin/dba816/pfile
dba816 $ ls *.ora
configdba816.ora  initdba816.orainitdba816_0.ora
dba816 $ cat initdba816.ora
ifile = /Volumes/app/oracle/admin/dba816/pfile/configdba816.ora

rollback_segments =
(r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12,r13,r14,r15,r16)

db_file_multiblock_read_count = 32
db_block_buffers = 3200
shared_pool_size = 900
processes = 200
dml_locks = 500
log_buffer = 163840

compatible = 8.1.6.0.0

audit_trail = true
timed_statistics = true

max_dump_file_size = 10240

log_archive_start = true

job_queue_interval = 60
job_queue_processes = 2

global_names = true

db_domain = groton.pfizer.com
db_name = dba816
dba816 $ cat configdba816.ora
control_files   = (/ora1/oradata/dba816/ctrl/dba816_control1.ctl,
   /ora2/oradata/dba816/ctrl/dba816_control2.ctl)

background_dump_dest= /Volumes/app/oracle/admin/dba816/bdump
core_dump_dest  = /Volumes/app/oracle/admin/dba816/cdump
user_dump_dest  = /Volumes/app/oracle/admin/dba816/udump
log_archive_dest= /Volumes/app/oracle/admin/dba816/arch
log_archive_format  = "ora_dba816_%t_%s.arc"
db_block_size   = 8192
dba816 $ cdcreate   
/Volumes/app/oracle/admin/dba816/create
dba816 $ ls *.sql

crdb1dba816.sql  crdb2dba816.sql
dba816 $ cat crdb1dba816.sql
set termout on
set echo on

spool /Volumes/app/oracle/admin/dba816/create/crdb1dba816.out

connect internal

startup nomount
pfile=/Volumes/app/oracle/admin/dba816/pfile/initdba816_0.ora

create database "dba816"
maxdatafiles 255
maxinstances 8
maxlogfiles 32
maxloghistory 1000
maxlogmembers 4
character set "US7ASCII"
datafile
'/ora1/oradata/dba816/data/dba816_system01.dbf' size 200M
logfile
group 1 ('/ora1/oradata/dba816/redo/dba816_redo1_1.rdo',
'/ora2/oradata/dba816/redo/dba816_redo1_2.rdo') size 10M,
group 2 ('/ora1/oradata/dba816/redo/dba816_redo2_1.rdo',
'/ora2/oradata/dba816/redo/dba816_redo2_2.rdo') size 10M,
group 3 ('/ora1/oradata/dba816/redo/dba816_redo3_1.rdo',
'/ora2/oradata/dba816/redo/dba816_redo3_2.rdo') size 10M;

disconnect

spool off
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fowler, Kenneth R
  INET: [EMAIL PROTECTED]

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

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

RE: Off Topic - PKZIP

Title: RE: Off Topic - PKZIP





 -Original Message-
 From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
 Sent: mercredi, 7. mars 2001 07:41
 To: Multiple recipients of list ORACLE-L
 Subject: Off Topic - PKZIP
 
 
 This is off topic but I figured someone on the list would 
 know the answer.
 Is there a way to create a PKZIP file on a MAC machine and 
 then unzip it on
 an NT machine?


Addendum to my previous e-mail - Stuffit ( http://www.aladdinsys.com/products/stuffit/index.html )can create zip files (as I found out upon further reading at their website.)

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


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

Re: Oracle Licensing

2001-03-07 Thread Don Jerman


The disk packs (probably still) come with 60 day trials for everything you
didn't buy.

Alternatively, if you have 10 developers, you could buy a 15-user license for
your developer  test machine (10 devs + you, your assistant, your operator and
a couple spares in case you expand).   The software works the same no matter how
you licensed it.

You should buy support for everything, just in case.  Hard to explain to
management/stockholders why you didn't when the servers are down ;-).

Yes it is expensive if you have a "real" client-test setup where you can run in
parallel with production, but heck, that's what vendor negotiations are for :-).




Steve Orr wrote:

  NOT happy making for the DBA (me)

 Yeah, what if you needed a "temporary install" on a new machine to test
 something? Am I really expected to get a license for a temporary install?
 Suppose you want to test some UNIX parameters and you can't use the
 "Development" or "QA" servers? (Not to mention production:-) Software locks
 just complicate things. Can't we still keep "the spirit of the law" without
 being subjected to draconian measures to enforce licensing?

 How do you "setup shop" for licensing and support? Say you have 3 fairly
 equal servers for Development, Test, and Production. Each server is
 basically the same: same manufacturer; same hardware; same O/S version and
 patches, same Oracle version, etc. OK, maybe your production machine has
 four times the CPU and memory and a 1000 times more connections. How do you
 license and support these machines? An ORA-00600 or ORA-07445 on one machine
 "should" occur on the other machines for the same reasons with the same
 causes and producing the same effects/symptoms. Do you buy support for all
 three machines or do you just buy support for a smaller machine and apply
 patches across the board? What are the fine print legally correct answers
 versus the ethically correct practices in the real world? Is there a
 distinction? I can imagine what the answers would be if Oracle included
 these questions on the OCP tests. ;-)  What do you say?

 Comments and confessions anyone? Feel free to email me privately.

 Steve Orr
 [EMAIL PROTECTED]
 www.arzoo.com

 -Original Message-
 Carmichael
 Sent: Tuesday, March 06, 2001 9:46 AM
 To: Multiple recipients of list ORACLE-L

 Ingres used to do that for expiration date... you had to enter an
 authorization string when you installed the database. It would check and
 refuse to come up if the software expired.

 Except they

 a) never warned you you were close to expiration
 b) usually shut you down around 10AM EST so people who had logged in earlier
 could work
 c) were a pita about sending a new string

 you had to shut down production in order to apply the new string.

 NOT happy making for the DBA (me)

 Rachel

 From: Dennis Taylor [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: Oracle Licensing
 Date: Tue, 06 Mar 2001 07:40:43 -0800
 
 At 03:35 AM 3/6/01 -0800, you wrote:
  my .02 is the whole power unit thing is a good concept but the $$ per
  unit is way outta whack.  the only reason i say that is its been hard
  for oracle to denote when people were using more than the licenses they
  bought were being used.  I had always setup the databases with the
  v$license parms setup in the database. But sometimes damagement
  "required" me to "uplift" the limits.  We'll leave it at that.
  
 
 I've always been very surprised that Oracle didn't put some kind of
 licensing enforcement in their software. They're the perfect situation for
 it -- High ticket, relatively low volume. They could afford to "brand" the
 software before sending it to the customer. I bet they'd more than make up
 enough revenue to be able to drop their prices to something non-lunatic.
 
 
 Dennis Taylor
 
 In any human endeavor, once you have exhausted all
 possibilities and have failed, there will be one solution,
 simple and obvious, highly visible to everyone else.
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Dennis Taylor
INET: [EMAIL PROTECTED]

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1

RE: Change tablespace for Local Index Partition

2001-03-07 Thread Vadim Gorbounov


Hi, Alex,

1. Can I ask you, what's UT.222? If UT supposed to be oracle schema, 222 is
not valid index name. 
2. You can specify tablespace for EVERY next index partition, if you specify
CREATE INDEX ... TABLESPACE xxx and then move all partitions wherever you
want. After all new partition will go to TABLESPACE xxx.

Vadim Gorbounov
Oracle DBA



-Original Message-
Sent: Wednesday, March 07, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L



Hi,

I'm running Oracle 8.0.5 and I have a partitioned table with local indexes.
I try to: put partition data and partitioned indexes in different
tablespaces.

As you probably know Oracle when you create a new table partition creates
implicit local indexes partitions, but you cannot specify to put them in a
specific tablespace.

I issue command:

 SQLALTER INDEX UT.222 REBUILD PARTITION M3 TABLESPACE "TSM_IX_3" ;
 ORA-02243: invalid ALTER INDEX or ALTER SNAPSHOT option

Do you know any command which will work?

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

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

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

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

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

Title: RE: error after creating second database

-Original Message-
From: Bambang Setiawan [mailto:[EMAIL PROTECTED]]
Sent: mardi, 6. mars 2001 21:55

but my primary question not only how to fix it but
why this thing happened ?

Joseph S. Testa [EMAIL PROTECTED] 03/07/01 11:35
HINT: You may need to run PUPBLD.SQL as SYSTEM

Read the following manual
SQL*Plus User's Guide and Reference
Release 8.1.5
A66736-01

(or the corresponding manual for your version of Oracle)

Appendix E, security, describes the use of the PRODUCT_USER_PROFILE table

Various Oracle products use PRODUCT_USER_PROFILE, a table in the SYSTEM account, to provide product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles.

Overview
DBAs can use PRODUCT_USER_PROFILE to disable certain SQL and SQL*Plus commands in the SQL*Plus environment on a per-user basis. SQL*Plus--not Oracle--enforces this security. DBAs can even restrict access to the GRANT, REVOKE, and SET ROLE commands to control users' ability to change their database privileges.

SQL*Plus reads restrictions from PRODUCT_USER_PROFILE when a user logs in to SQL*Plus and maintains those restrictions for the duration of the session. Changes to PRODUCT_USER_PROFILE will only take effect the next time the affected users log in to SQL*Plus.

You can find online documentation at the Oracle Technology Network website
http://otn.oracle.com/docs/index.htm

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

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

RE: NUMBER datatype

Title: RE: NUMBER datatype





 -Original Message-
 From: paquette stephane [mailto:[EMAIL PROTECTED]]
 Sent: mercredi, 7. mars 2001 00:31
 To: Multiple recipients of list ORACLE-L
 Subject: RE: NUMBER datatype
 
 
 Hi Steve,
 
 I posted that question a couple of days ago but got no
 answer. Do you agree that if I create a table with
 plain number fields instead of number (x,y) I can
 store any value with any precision as long as I do not
 reach Oracle limits ?


Do I understand your question correctly? Yes, a number field can contain any positive or negative number up to a certain precision.

I seem to lose precision after 40 digits.


SQL create table t (row_num number (2), n number) ;


Table created.


SQL -- 40-digit number
SQL insert into t (row_num, n)
 2 values (1, 1234567890123456789012345678901234567890) ;


1 row created.


SQL -- 41-digit number
SQL insert into t (row_num, n)
 2 values (2, 12345678901234567890123456789012345678901) ;


1 row created.


SQL select row_num,
 2 to_char (n, rpad ('9', 50, '9')) as big_num
 3 from t ;


 ROW_NUM BIG_NUM
-- ---
 1 1234567890123456789012345678901234567890
 2 12345678901234567890123456789012345678900


SQL select * from v$version ;


BANNER

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production


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


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

Re[2]: Imp abnormally terminated without errors.

2001-03-07 Thread dgoulet


I've also experienced this one time in the past, but there was one added piece
to the puzzle.  I had ftp'd the dump file from one machine to another and had
done so in ASCII mode by accident.  Retransferring the file in BINARY mode fixed
the problem.

Dick Goulet

Reply Separator
Author: "Ruth Gramolini" [EMAIL PROTECTED]
Date:   3/7/2001 11:15 AM

I had this happen once.  The export seemed to go okay but when I went to
import it everything fell apart. Try doing the export again.  When I tried
it again it worked. Oracle support had to reason for it.

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


  Dear All,

Has anyone had this experience?

  Recently,   when I imported a database dump with a series of 2G dum files
by pipe(this worked before), the import always terminated abnormally without
errors. I have checked the alert log file and the import log file. I checked
the rollback segments, redo log files, the data and indexes spaces as well.
Everything is normal for me.

  What could it be the cause?

  Thanks very much for your advice.

  This is on Solaris 2.7 with Oracle 8.1.5EE

  Chuan




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

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

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

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

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

how to compile these object in oracle 8i

2001-03-07 Thread mala singh


Hi gurus
I found that one of objects has status INVALID.
The following are the output.
OWNEROBJECT_NAMEOBJECT_TYPESTATUS
 -- -- ---
SCOTTEMP_SNAPUNDEFINED  INVALID

How to correct this object.
Please advice me.
Thanks.
-Mala



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

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

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

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

Oracle V9 DB server

2001-03-07 Thread Charlie Mengler


What is the latest guesstimate when Oracle 9 DB server will be released?

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE: Re[2]: Imp abnormally terminated without errors.

2001-03-07 Thread Henry Poras


You can try importing with a SHOW=Y to check for corruption and to see where
it stops.

Henry

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


I've also experienced this one time in the past, but there was one added
piece
to the puzzle.  I had ftp'd the dump file from one machine to another and
had
done so in ASCII mode by accident.  Retransferring the file in BINARY mode
fixed
the problem.

Dick Goulet

Reply Separator
Author: "Ruth Gramolini" [EMAIL PROTECTED]
Date:   3/7/2001 11:15 AM

I had this happen once.  The export seemed to go okay but when I went to
import it everything fell apart. Try doing the export again.  When I tried
it again it worked. Oracle support had to reason for it.

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


  Dear All,

Has anyone had this experience?

  Recently,   when I imported a database dump with a series of 2G dum files
by pipe(this worked before), the import always terminated abnormally without
errors. I have checked the alert log file and the import log file. I checked
the rollback segments, redo log files, the data and indexes spaces as well.
Everything is normal for me.

  What could it be the cause?

  Thanks very much for your advice.

  This is on Solaris 2.7 with Oracle 8.1.5EE

  Chuan




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

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

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

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

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

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

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

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

RE: long row

2001-03-07 Thread Kimberly Smith


The long can handle two Gig but not much else
can.  For example, PL/SQL can handle 32k and the last
numbers I have from Oracle Forms is 56k.  

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


Oracle says data type Long can contain 2G data.
but when I insert it larger than 4k, I got the error :
oerr ora 01704:
01704, 0, "string literal too long"

thanx for your help.
Lhoussain.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: benajam lhoussain
  INET: [EMAIL PROTECTED]

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

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

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

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

Oracle Compiler Bug? (+) symbol in Decode Allowed?

2001-03-07 Thread Sam Bootsma


I am running Oracle 8.1.6 on Windows NT.  The query below to create a view
compiles on Oracle 8.1.6.1.0, but not on 8.1.6.3.0.  If I remove the (+)
from within the decode statement, it compiles in 8.1.6.3.0.  Our lead
developer insists it is valid and he also insists the query gives different
results when the (+) sign in the decode is removed.  I have not confirmed
this. 

According to my understanding of outer joins (and from what I have seen in
the documentation) the (+) in the decode is invalid syntax.   Can somebody
confirm this for me?

Here is the view in question:

CREATE OR REPLACE VIEW RULE$TYPE
(ruletype, caption, genlevel, defaultval, exposetype, switch, override)
AS
SELECT A.*,DECODE(B.RULETYPE(+),NULL,'G','M') FROM RULETYPE A,
RULETYPE_OVERRIDE B
WHERE B.RULETYPE(+)=A.RULETYPE

And here is an excerpt from the documentation:

Outer Joins 
An outer join extends the result of a simple join. An outer join returns all
rows that satisfy the join condition and those rows from one table for which
no rows from the other satisfy the join condition. Such rows are not
returned by a simple join. To write a query that performs an outer join of
tables A and B and returns all rows from A, apply the outer join operator
(+) to all columns of B in the join condition. For all rows in A that have
no matching rows in B, Oracle returns NULL for any select list expressions
containing columns of B. See the syntax for an outer join in "SELECT and
Subqueries" ch4l2.htm ch4l2.htm. 
Outer join queries are subject to the following rules and restrictions: 
*   The (+) operator can appear only in the WHERE clause or, in the
context of left-correlation (that is, when specifying the TABLE clause) in
the FROM clause, and can be applied only to a column of a table or view. 


Thanks for any input...


Sam Bootsma


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

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

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

2001-03-07 Thread Hagedorn, Linda

Title: RE: Dropping datafiles





If this datafile is one of a group of datafiles, that is to say tablespace TS1 has multiple datafiles along with the one created in error, do not offline drop the datafile. Oracle knows of the datafile and offline drop does not remove the information. 

Story: A hot-talking DBA came into the shop where I used to work, created additional unneeded datafiles, and then did an offline drop on one of them. Production came to a standstill 40 minutes later. While hot-shot tried to fix it, we lost six-figures in orders, and eventually had to recover from the last hot backup (recovery assistance provided by Joe. Thank you). 

Moral: Don't do an offline drop of a datafile in a group of datafiles unless you are planning a recovery exercise. 


-Original Message-
From: Joanne Graham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Dropping datafiles



If you're on an appropriate version on Oracle and the file doesn't yet
contain any data you could always resize the file to virtually nothing.

Re: how to compile these object in oracle 8i

2001-03-07 Thread Gunawan Yuwono


From Metalink:

Problem Description:

 
While querying "user_objects", under the "OBJECT_TYPE" column, you see a value
of "UNDEFINED" on some of the objects.  What does this signify?

The "dba_objects" view shows LOB object type as UNDEFINED ; 
but "user_objects" view shows it correctly as LOB.  
If you run the query:

select object_type from user_objects;

you see some rows showing a value "UNDEFINED".

What is the object type, when "user_objects" view shows object type as
UNDEFINED?
 

Solution Description:
=

Using the "object_id" column of "user_objects" for the UNDEFINED object, query 
obj$:

select type# from sys.obj$ where obj#=object_id

If type# returned is 42, then it is an object type that was previously
called a SUMMARY object.  This object is created when one runs:

create materialized view ... command. 
[Or equivalently  "create snapshot..." command. ] 


Explanation:

 
The object is most likely a SUMMARY object associated with materialized views.


References:
===

[BUG:1188948]  SNAPSHOT IS SHOWING AS UNDEFINED IN DBA_OBJECTS IN RDBMS 8.1.6 
 IN SOLARIS 2.6


--- mala singh [EMAIL PROTECTED] wrote:
 Hi gurus
 I found that one of objects has status INVALID.
 The following are the output.
 OWNEROBJECT_NAMEOBJECT_TYPESTATUS
  -- -- ---
 SCOTTEMP_SNAPUNDEFINED  INVALID
 
 How to correct this object.
 Please advice me.
 Thanks.
 -Mala
 
 
 
 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: mala singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Gunawan Yuwono
Oracle DBA
Kansas City, USA

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

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

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

RE: 8.0.5 to 8i upgrade

2001-03-07 Thread Kimberly Smith


I did an 8.0.something(4 or 5) upgrade to 8.1.6.  First I had to 
reinstall the OS (well actually the sys. admin. dudes did 
that) from 10.20 to 11.  They reinstalled instead of upgrade
because it went from 32-bit to 64-bit.  Then we put the logical
mounts for the database back in and did the upgrade.  That
really did not take long.  Make sure you increase the size
of the system tablespace first as 8i needs a bigger one.
Also, I am not sure which option puts in the u805.sql script
in but I did not have it in there and I had to call 
Oracle and get them all shipped to me.  Make sure you have
it there first.  I have a feeling its the migration portion
although that is not the case with 8.0.6.

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



We want to do an 8.0.5 to 8i upgrade (HPUX).  There are six databases
on the system where the upgrade is required.  How long does the
upgrade typically take?  What kind of downtime should be expected?
 Are there any major "gotchas" of doing the 8.0.5 to 8i upgrade?

-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

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

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

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

Recommended # of CPUs and MHz

2001-03-07 Thread Simpson, Don


I've been looking around for ways to determine how much processor speed I
need for a new installation.  From what I found so far there are basically
two ways to do this.
1.  Spend the time and money on resources and tools to analyze the needs.
2.  Make a best guess and go from there.

Given the limited time and budget I would like simply to make a best guess.
I'm hoping a query to the mass might produce some suggestions for me.

I'm estimating about 100 to 150 users on a machine that will be dedicated
strictly to the database, no app servers or any other programs outside of
normal OS and database processes will run on it.  I will have  3 Oracle
instances running on it, all together about 10 gig of data manipulated in a
OLTP environment.

I'll probably go with a SUN 420 with 2 450MHz processors to start.  I'd like
to have more but then that would raise the ante on the Oracle licensing.
I'll attempt to compensate with loads of memory.

What do you think, am I being unrealistic with only 900MHz or can I skate
by? 

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

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

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

Experiences with AIX and NIS+

2001-03-07 Thread Peter Barnett


Does anyone have any experience with AIX in an NIS+ environment.  In 
theory, this is possible.  So far, we have not be able to get it to 
work.  AIX and Oracle 8.1.7 work well with local accounts for Oracle and 
the DBAs.  Automounting file systems has been successful.  However, NIS+ 
just does not work and throws all sorts of other errors that crashes 
everything.

Has anyone successfully done this?


Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]


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

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

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

How to know which are the snapshots suposed to be getting refreshed from master?

2001-03-07 Thread Muru


Hello Forumists,

How to know which are the snapshots supposingly to get
refreshed from the master? In my situation, I have
around 40 databases refreshing from a single master
and seems to be all the 40 databases' snapshots are
getting refreshed. So, why my snapshot still grows
without purging automatically is the question. If I
manually purge the snapshots using
dbms_snapshot.purge() procedure then, I have to make a
COMPLETE refresh for all these snapshots which will
involve more efforts. So, I would like to know if
there is a way to find which are the snapshots
supposed to refresh from master. Perhaps there is a
way to find this out at the master using some
dictionary tables etc..which I am not aware of. If
anybody has an idea please let me know.

Thank you very much,
Muru

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

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

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

2001-03-07 Thread Tony Johnson


Im doing this on a dual 500Mhx Dell box with a Raid5 array now and 1g of
memory.
No issues.


--
Tony JohnsonEmail  : [EMAIL PROTECTED]
Senior Database Administrator   Voice  : ( 480 ) 682 - 0849
GRID DATA, INC.   Cell   : ( 602 ) 363 - 7328
7408 W. Detroit #100Fax: ( 480 ) 961 - 8801
Chandler, AZ 85226

--
Murphy's Data Constant:Data will be damaged in direct proportion to its
value

-Original Message-
Don
Sent: Wednesday, March 07, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


I've been looking around for ways to determine how much processor speed I
need for a new installation.  From what I found so far there are basically
two ways to do this.
1.  Spend the time and money on resources and tools to analyze the needs.
2.  Make a best guess and go from there.

Given the limited time and budget I would like simply to make a best guess.
I'm hoping a query to the mass might produce some suggestions for me.

I'm estimating about 100 to 150 users on a machine that will be dedicated
strictly to the database, no app servers or any other programs outside of
normal OS and database processes will run on it.  I will have  3 Oracle
instances running on it, all together about 10 gig of data manipulated in a
OLTP environment.

I'll probably go with a SUN 420 with 2 450MHz processors to start.  I'd like
to have more but then that would raise the ante on the Oracle licensing.
I'll attempt to compensate with loads of memory.

What do you think, am I being unrealistic with only 900MHz or can I skate
by?

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

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

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

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

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

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

2001-03-07 Thread Kathy Duret

Title: OT: ODBC version errors



Lisa

In 
general, I disable Dr Watson because it seems to have alot of problems with 
Oracle Reports and other packages. Sorry I can't answer your other ODBC 
issues as I haven't had any problems with the 8.1 Oracle drivers. I know 
we use Intersolv drivers for Crystal reports if that is any help to 
you.

Kathy

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Yttri, LisaSent: 
  Wednesday, March 07, 2001 1:11 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT: ODBC version errors
  Hi everyone - 
  I have several developers telling me that their web 
  applications (some are purchased packages and some are developed in-house) do 
  not work with Oracle ODBC drivers if they are version 8. Every one of 
  their applications seems to run fine with the 7.3.4 ODBC drivers. They 
  get a variety of errors - some get odd messages when they try to login, others 
  get Dr. Watson errors when there are more than x number of users 
  connecting.
  Does anyone know of existing problems (or fixes) related to 
  the 8 (both 8.0 and 8.1) drivers?  or, can you point me to 
  any documents / sites / user groups that could better answer my 
  question?
  Thanks very much - Lisa

RE: Change tablespace for Local Index Partition

2001-03-07 Thread Diana Duncan


Alex,

You have the syntax correct, but your index name seems invalid.  Also, there
is no need to put double quotes around the tablespace name.

alter index index name rebuild partition partition name tablespace
tablespace name

is correct, though.

HTH,

Diana

-Original Message-
Sent: Wednesday, March 07, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L



Hi,

I'm running Oracle 8.0.5 and I have a partitioned table with local indexes.
I try to: put partition data and partitioned indexes in different
tablespaces.

As you probably know Oracle when you create a new table partition creates
implicit local indexes partitions, but you cannot specify to put them in a
specific tablespace.

I issue command:

 SQLALTER INDEX UT.222 REBUILD PARTITION M3 TABLESPACE "TSM_IX_3" ;
 ORA-02243: invalid ALTER INDEX or ALTER SNAPSHOT option

Do you know any command which will work?

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

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

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

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

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

Off-Topic OAS, IAS, and Apache

2001-03-07 Thread Garrity Ed R

Title: Off-Topic OAS, IAS, and Apache

I have little experience using web servers for high volume sites. We have one project that expects to have 1,000 concurrent users. They're using OAS and load testing with Load Runner. They're having problems getting anywhere close to that. I don't know the details. They're debating whether or not they should move to IAS or just use Apache by itself.

I'm pretty sure that the OAS documentation states that it allows 750 concurrent connections per web listener. I'm not sure what the limitation is on IAS. Does any one know if there is there a limitation with Apache? I've been reading through the Apache documentation and I've found a directive called MaxClients, which has a default value of 256. The documentation states the following:

The MaxClients directive sets the limit on the number of simultaneous requests that can be supported; not more than this number of child server processes will be created. To configure more than 256 clients, you must edit the HARD_SERVER_LIMIT entry in httpd.h and recompile.

Any connection attempts over the MaxClients limit will normally be queued, up to a number based on the ListenBacklog directive. Once a child process is freed at the end of a different request, the connection will then be serviced.

I've been searching for the parameter HARD_SERVER_LIMIT at apache.org, but so far I can't find it. I'm wondering if this value has a limit. I've been told that the limit is 1024, but I've not been able to verify this.

Any insight into this, experiences, comparisons between IAS (which contains the Apache web server) and Apache by itself would be most appreciated. The project is using java servlets. I believe they preload a few of them.

RE: Change tablespace for Local Index Partition

2001-03-07 Thread Vadim Gorbounov


Hi, Alex,

1. Can I ask you, what's UT.222? If UT supposed to be oracle schema, 222 is
not valid index name. 
2. You can specify tablespace for EVERY next index partition, if you specify
CREATE INDEX ... TABLESPACE xxx and then move all partitions wherever you
want. After all new partition will go to TABLESPACE xxx.

Vadim Gorbounov
Oracle DBA



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


Alex,

You have the syntax correct, but your index name seems invalid.  Also, there
is no need to put double quotes around the tablespace name.

alter index index name rebuild partition partition name tablespace
tablespace name

is correct, though.

HTH,

Diana

-Original Message-
Sent: Wednesday, March 07, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L



Hi,

I'm running Oracle 8.0.5 and I have a partitioned table with local indexes.
I try to: put partition data and partitioned indexes in different
tablespaces.

As you probably know Oracle when you create a new table partition creates
implicit local indexes partitions, but you cannot specify to put them in a
specific tablespace.

I issue command:

 SQLALTER INDEX UT.222 REBUILD PARTITION M3 TABLESPACE "TSM_IX_3" ;
 ORA-02243: invalid ALTER INDEX or ALTER SNAPSHOT option

Do you know any command which will work?

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

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

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

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

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

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

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

Title: RE: export/import





 -Original Message-
 From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
 Sent: mercredi, 7. mars 2001 14:32
 
 Can I import a database from NT which was 
 exported from AIX RS6000 servers? Do I just
 move the expdat.dmp (exported output) from
 AIX to NT and simply use the export/import 
 utilities?



Yes. If you use FTP to transfer the file make sure that you FTP in binary mode. Also the two instances should be running the same version of Oracle RDBMS. (If they aren't you may have to do some extra steps such as running catexp.sql for the corresponding Oracle version before you do the export.)

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


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

Re: Oracle Compiler Bug? (+) symbol in Decode Allowed?

2001-03-07 Thread Peter Barnett


Many queries that worked in the past, which were syntactically 
challenged, fail with Oracle8.  In theory, they never should have 
worked.  Oracle is just applying the theory more strictly.  


Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]


On Wed, 7 Mar 2001, Sam Bootsma wrote:

 I am running Oracle 8.1.6 on Windows NT.  The query below to create a view
 compiles on Oracle 8.1.6.1.0, but not on 8.1.6.3.0.  If I remove the (+)
 from within the decode statement, it compiles in 8.1.6.3.0.  Our lead
 developer insists it is valid and he also insists the query gives different
 results when the (+) sign in the decode is removed.  I have not confirmed
 this. 
 
 According to my understanding of outer joins (and from what I have seen in
 the documentation) the (+) in the decode is invalid syntax.   Can somebody
 confirm this for me?
 
 Here is the view in question:
 
 CREATE OR REPLACE VIEW RULE$TYPE
 (ruletype, caption, genlevel, defaultval, exposetype, switch, override)
 AS
 SELECT A.*,DECODE(B.RULETYPE(+),NULL,'G','M') FROM RULETYPE A,
 RULETYPE_OVERRIDE B
 WHERE B.RULETYPE(+)=A.RULETYPE
 
 And here is an excerpt from the documentation:
 
 Outer Joins 
 An outer join extends the result of a simple join. An outer join returns all
 rows that satisfy the join condition and those rows from one table for which
 no rows from the other satisfy the join condition. Such rows are not
 returned by a simple join. To write a query that performs an outer join of
 tables A and B and returns all rows from A, apply the outer join operator
 (+) to all columns of B in the join condition. For all rows in A that have
 no matching rows in B, Oracle returns NULL for any select list expressions
 containing columns of B. See the syntax for an outer join in "SELECT and
 Subqueries" ch4l2.htm ch4l2.htm. 
 Outer join queries are subject to the following rules and restrictions: 
 * The (+) operator can appear only in the WHERE clause or, in the
 context of left-correlation (that is, when specifying the TABLE clause) in
 the FROM clause, and can be applied only to a column of a table or view. 
 
 
 Thanks for any input...
 
 
 Sam Bootsma
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Sam Bootsma
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Peter Barnett 
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle Compiler Bug? (+) symbol in Decode Allowed?


Hey Sam,

Dont take it so seriously. Ur "Lead Developer" is just testing ur patience.

-Mandar

 -Original Message-
 From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 07, 2001 2:22 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Oracle Compiler Bug? (+) symbol in Decode Allowed?
 
 
 I am running Oracle 8.1.6 on Windows NT.  The query below to 
 create a view
 compiles on Oracle 8.1.6.1.0, but not on 8.1.6.3.0.  If I 
 remove the (+)
 from within the decode statement, it compiles in 8.1.6.3.0.  Our lead
 developer insists it is valid and he also insists the query 
 gives different
 results when the (+) sign in the decode is removed.  I have 
 not confirmed
 this. 
 
 According to my understanding of outer joins (and from what I 
 have seen in
 the documentation) the (+) in the decode is invalid syntax.   
 Can somebody
 confirm this for me?
 
 Here is the view in question:
 
 CREATE OR REPLACE VIEW RULE$TYPE
 (ruletype, caption, genlevel, defaultval, exposetype, switch, 
 override)
 AS
 SELECT A.*,DECODE(B.RULETYPE(+),NULL,'G','M') FROM RULETYPE A,
 RULETYPE_OVERRIDE B
 WHERE B.RULETYPE(+)=A.RULETYPE
 
 And here is an excerpt from the documentation:
 
 Outer Joins 
 An outer join extends the result of a simple join. An outer 
 join returns all
 rows that satisfy the join condition and those rows from one 
 table for which
 no rows from the other satisfy the join condition. Such rows are not
 returned by a simple join. To write a query that performs an 
 outer join of
 tables A and B and returns all rows from A, apply the outer 
 join operator
 (+) to all columns of B in the join condition. For all rows 
 in A that have
 no matching rows in B, Oracle returns NULL for any select 
 list expressions
 containing columns of B. See the syntax for an outer join in 
 "SELECT and
 Subqueries" ch4l2.htm ch4l2.htm. 
 Outer join queries are subject to the following rules and 
 restrictions: 
 * The (+) operator can appear only in the WHERE clause or, in the
 context of left-correlation (that is, when specifying the 
 TABLE clause) in
 the FROM clause, and can be applied only to a column of a 
 table or view. 
 
 
 Thanks for any input...
 
 
 Sam Bootsma
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Sam Bootsma
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Mandar Ghosalkar
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle Licensing

2001-03-07 Thread Patrick Housholder


ha, 

thank-god they save 1 billion dollars on using there own software.

p-

===
Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO
 

*-Original Message-
*From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Eric D.
*Pierce
*Sent: Wednesday, March 07, 2001 11:07 AM
*To: Multiple recipients of list ORACLE-L
*Subject: RE: Oracle Licensing
*
*
*
*Oracle profit warning spells doom:
*
*http://www.zdnet.co.uk/news/2001/8/ns-21312.html
*
*---excerpt---
* Lowered spending for software has hit Oracle
* where it hurts 
*
* Oracle, the world's second largest software
* company, on Thursday joined the list of
* technology bellwethers warning that a slowing
* economy would cause profits to come in lower
* than expected. 
*
* Oracle had been one of the few industry titans to
* appear unscathed by corporate America's
* reluctance to commit to big-ticket technology
* purchases. 
*
* With Thursday's announcement after the close of
* trading, Oracle joined the growing list of high-tech
* companies, including Cisco Systems, Microsoft
* and Sun Microsystems -- that have issued profit
* warnings or indicated that deteriorating economic
* conditions likely will make for a difficult business
* climate during the first half of the calendar year. 
*
* "We're seeing a very substantial slowdown in the
* US economy that is making people cautions in all
* of their spending, including spending for
* software," Oracle chairman and chief executive
* Larry Ellison said. 
*
* Oracle said its formerly bullish forecasts began to
* crumble when senior executives in the United
* States were reluctant to give final approvals as
* Oracle pushed to close sales for its fiscal third
* quarter, which ended on Wednesday. 
*
* "We didn't see a slowdown and that was
* consistent up until about last Friday," Oracle chief
* financial officer Jeff Henley said. 
*
* "After that, every day it got worse. Literally the
* last day of the quarter we had a number of
* transactions that didn't happen," he said. 
*
* Oracle shares, which had rallied $2-3/8 to close
* at $21-3/8, fell to a new year-low of $16.94 in
* after-hours trading on the Island system. The stock
* is well off its year-high of $46-7/16. 
*
* Based on the slowing sales, Oracle now expects
* to report earnings per share at 10 cents, up 25
* percent from 8 cents a year ago, excluding
* investment gains. The company had been expected
* to earn 12 cents a share, according to First
* Call/Thomson Financial. 
*
* Ellison said Oracle's operating income would be
* about $900m, compared with Wall Street's
* forecast of $1bn. 
*
* Oracle executives also said the company did not
* yet see evidence that sales were slowing in Japan,
* Asia and Europe. 
*
* "Through the third quarter, at least, there didn't
* appear to be any leakage abroad, but that doesn't
* mean it couldn't happen," Henley said. 
*
* "It's just going to bring down the whole software
* sector. Obviously, no one's immune. I think the
* whole group is vulnerable. This is the spill over
* of technology," Credit Suisse First Boston analyst
* Brent Thill said. "Software was the last standing
* soldier." 
*
* The software vendor said total revenue grew
* around 9 percent for the quarter and software
* license sales revenue rose by 6 percent. Of the
* company's two software product lines, Oracle
* said its applications business of enterprise and
* front office software grew 50 percent while its
* database business was flat to slightly negative.
* Oracle is slated to give detailed fourth-quarter
* financial guidance when it reports third-quarter
* earnings on 15 March. 
*
* In the months leading up to the warning, Oracle
* said applications revenue would increase by 75
* percent or more in the third quarter. 
*
* Analysts had been lowering forecasts for Oracle's
* database revenue -- which accounted for more
* than one-third of the company's second-quarter
* revenues -- citing a slowing economy and dot-com
* failures. Nevertheless, many thought it would
* grow by at least 10 percent. 
*
* "I was expecting things to not be great. But I was
* not expecting it to be this bad. I still thought the
* database business would exhibit some growth,"
* Epoch Partners senior analyst Mark Verbeck, said.
*
* While the warning marks the second time in a
* decade that Oracle's earnings are expected to miss
* forecasts, Ellison said the company's
* year-over-year profit and margins show
* improvement despite the tough economic
* atmosphere. 
*
* Oracle's operating margin improved to 33 percent,
* an increase from 31 percent a year ago, said
* Ellison, who added that the company also will
* continue to manage expenses by allowing its head
* count to fall through natural attrition. 
*
* "As long as the economy doesn't get worse, we
* think we're going to be just fine. We think we're
* better equipped to deal with the slowdown than
* any other company on earth," Ellison

RE: ODBC version errors

Title: OT: ODBC version errors



Lisa,

Dont ever use Oracle 8/8i drivers. I had a pretty bad experience 
with them. 

I was 
called at a clients place to check their web app. they were using silk test to 
check the load performance against SQL Server 7 and Oracle 8i. 

when 
connected to SQL Server the app was reporting an avg response of 1.5 secs, 
whereas with Oracle it was around 17 secs.

After 
checking it was found that the Oracle odbc driver was the culprit. after 
switching to MS provided Oracle driver, Oracle performance was a 
beau.

I have 
all the statspack reports before and after the driver switch

-Mandar

  -Original Message-From: Yttri, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 07, 2001 3:11 
  PMTo: Multiple recipients of list ORACLE-LSubject: OT: 
  ODBC version errors
  Hi everyone - 
  I have several developers telling me that their web 
  applications (some are purchased packages and some are developed in-house) do 
  not work with Oracle ODBC drivers if they are version 8. Every one of 
  their applications seems to run fine with the 7.3.4 ODBC drivers. They 
  get a variety of errors - some get odd messages when they try to login, others 
  get Dr. Watson errors when there are more than x number of users 
  connecting.
  Does anyone know of existing problems (or fixes) related to 
  the 8 (both 8.0 and 8.1) drivers?  or, can you point me to 
  any documents / sites / user groups that could better answer my 
  question?
  Thanks very much - Lisa

RE: export/import

2001-03-07 Thread Rao, Maheswara


 Joseph,

Following might help you.

We have databases 8.1.6 on Solaris 2.7. On NT4 we have 8.0.4. We export user
schema/tables from 816 and import the schema/tables into 804 on NT.
Important things are:

If your databases versions are same on both the machines, then use the same
exp/imp software versions. Else use the lesser version.  For example, to
export the tables from 816, I use exp version from 804. Reason: exp/imp are
downward compatible but not upwards.  Also, while ftp, keep the file
transfer in binary.

Hope this might clarify some things.

Rao



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 03/07/2001 5:31 PM

Can I import a database from NT which was 
exported from AIX RS6000 servers? Do I just
move the expdat.dmp (exported output) from
AIX to NT and simply use the export/import 
utilities?

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

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

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

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

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

RE: 8.0 / 8i Bang for the Buck Features

2001-03-07 Thread elkinsl


Paul,

Thanks for the heads up. The application in question uses a lot of in-line
views, sometimes nested quite a few levels deep. On 7.3, they encountered
various aliasing problems -- needing to alias the column names in the
in-line views even if the name remained the same as the column name when
moving the SQL into PL/SQL blocks. I can't recall if I have seen cases where
they used the same alias for different in-line views at different levels
within an SQL statement (though I wouldn't have expected that to work at
all). It's something to keep an eye out for, thanks.

Also saw a bug in 7.3.4.3 where in-line views using UNION in SELECT
statement in PL/SQL could return incorrect results. That bit them since the
bug was fixed in 7.3.4.4, their development and QA boxes are 7.3.4.5, and
production is 7.3.4.3 (a bug of significant impact kept them from upgrading
prod to 7.3.4.5 -- don't know why they didn't back down test and QA to match
prod). Code that worked fine "broke" when moved to prod. Had a fun weekend
working through that one the first time it was encountered.

One of my concerns is how the CBO is going to behave. Will well behaving SQL
statements go South due to changes in the CBO and how it "calculates" the
most efficient access path.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 06, 2001 11:05 PM
To: Multiple recipients of list ORACLE-L


Larry,

Watch out for non-unique table aliases used in a multi-tiered statement.
(particularly if you're rolling statements dynamically)
Query re-write needs to have the table (or inline view) aliases unique.

That was the only hitch that I saw when upgrading from 7.3.4 to 8.1.6.

Paul


-- 
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 Help: Comparison between BMC Patrol and some other performance tool

2001-03-07 Thread Viraj Luthra


This is request for the second time; please any one there know anything or can provide 
value

rgds,

raja
 
--

On Tue, 06 Mar 2001 21:15:48  
 Viraj Luthra wrote:
Hello every one,

This one is may be a bit off topic but an important topic, for me at least. Is there 
some one out there who has made a comparitive analysis between BMC Patrol and some 
other performance tool? If some one has a report like that, would really like to see  
that report. I need to know how good/bad is BMC PATROL in monitoring NT, UNIX and 
also Oracle both for NT and Unix. If you also have a cost benefit analysis, please 
also share.

I am trying to monitor NT 2000, Unix: aix 4.3.3 and Oracle 8i; actually a whole lot 
of unix flavours;

This will be a big help and would really appreciate it, if some one can help with 
some kind of report.

Thanks and Regards,

Raja


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

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

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



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

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

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

RE: Oracle Licensing

2001-03-07 Thread Patrick Housholder


*thank-god they save 1 billion dollars on using there own software.
ooppss...their

===
Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO
 

*-Original Message-
*From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Patrick
*Housholder
*Sent: Wednesday, March 07, 2001 4:32 PM
*To: Multiple recipients of list ORACLE-L
*Subject: RE: Oracle Licensing
*
*
*ha, 
*
*thank-god they save 1 billion dollars on using there own software.*
*p-
*
*===
*Patrick Housholder
*Sr. Staff Anl Tech Spt Design
*United Airlines Flight Training Center
*Denver CO
* 
*
**-Original Message-
**From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Eric D.
**Pierce
**Sent: Wednesday, March 07, 2001 11:07 AM
**To: Multiple recipients of list ORACLE-L
**Subject: RE: Oracle Licensing
**
**
**
**Oracle profit warning spells doom:
**
**http://www.zdnet.co.uk/news/2001/8/ns-21312.html
**
**---excerpt---
** Lowered spending for software has hit Oracle
** where it hurts 
**
** Oracle, the world's second largest software
** company, on Thursday joined the list of
** technology bellwethers warning that a slowing
** economy would cause profits to come in lower
** than expected. 
**
** Oracle had been one of the few industry titans to
** appear unscathed by corporate America's
** reluctance to commit to big-ticket technology
** purchases. 
**
** With Thursday's announcement after the close of
** trading, Oracle joined the growing list of high-tech
** companies, including Cisco Systems, Microsoft
** and Sun Microsystems -- that have issued profit
** warnings or indicated that deteriorating economic
** conditions likely will make for a difficult business
** climate during the first half of the calendar year. 
**
** "We're seeing a very substantial slowdown in the
** US economy that is making people cautions in all
** of their spending, including spending for
** software," Oracle chairman and chief executive
** Larry Ellison said. 
**
** Oracle said its formerly bullish forecasts began to
** crumble when senior executives in the United
** States were reluctant to give final approvals as
** Oracle pushed to close sales for its fiscal third
** quarter, which ended on Wednesday. 
**
** "We didn't see a slowdown and that was
** consistent up until about last Friday," Oracle chief
** financial officer Jeff Henley said. 
**
** "After that, every day it got worse. Literally the
** last day of the quarter we had a number of
** transactions that didn't happen," he said. 
**
** Oracle shares, which had rallied $2-3/8 to close
** at $21-3/8, fell to a new year-low of $16.94 in
** after-hours trading on the Island system. The stock
** is well off its year-high of $46-7/16. 
**
** Based on the slowing sales, Oracle now expects
** to report earnings per share at 10 cents, up 25
** percent from 8 cents a year ago, excluding
** investment gains. The company had been expected
** to earn 12 cents a share, according to First
** Call/Thomson Financial. 
**
** Ellison said Oracle's operating income would be
** about $900m, compared with Wall Street's
** forecast of $1bn. 
**
** Oracle executives also said the company did not
** yet see evidence that sales were slowing in Japan,
** Asia and Europe. 
**
** "Through the third quarter, at least, there didn't
** appear to be any leakage abroad, but that doesn't
** mean it couldn't happen," Henley said. 
**
** "It's just going to bring down the whole software
** sector. Obviously, no one's immune. I think the
** whole group is vulnerable. This is the spill over
** of technology," Credit Suisse First Boston analyst
** Brent Thill said. "Software was the last standing
** soldier." 
**
** The software vendor said total revenue grew
** around 9 percent for the quarter and software
** license sales revenue rose by 6 percent. Of the
** company's two software product lines, Oracle
** said its applications business of enterprise and
** front office software grew 50 percent while its
** database business was flat to slightly negative.
** Oracle is slated to give detailed fourth-quarter
** financial guidance when it reports third-quarter
** earnings on 15 March. 
**
** In the months leading up to the warning, Oracle
** said applications revenue would increase by 75
** percent or more in the third quarter. 
**
** Analysts had been lowering forecasts for Oracle's
** database revenue -- which accounted for more
** than one-third of the company's second-quarter
** revenues -- citing a slowing economy and dot-com
** failures. Nevertheless, many thought it would
** grow by at least 10 percent. 
**
** "I was expecting things to not be great. But I was
** not expecting it to be this bad. I still thought the
** database business would exhibit some growth,"
** Epoch Partners senior analyst Mark Verbeck, said.
**
** While the warning marks the second time in a

RE: guidance for career in US as D.B.A.


Hi neena

 Hi All ,
  I am in India . I am an OCP DBA (8i)  
 having three years  IT experience ( Oracle( 7.3, 8 ) and
 Developer2000 , OS -
 windows NT).Three months back I have  joined one of the known 
 company of India.  The role of mine in the present job is
 of DBA. I
 have to handle two Oracle 7.3 databases on AIX of an 
 application which is stable since last five years. As the
 application is stable I am
 not getting good / challenging  exposure to DBA activities. 
First imp thing is that u always be in this situation. once the app becomes
stable u will always find urself idle.

1. Design a Disaster Recovery plan doc for ur db
2. Write db health check routines
3. research and find out how fatal bugs in 7.3 can stop ur production site
4. find out what wld stop (techincally) from migrating to 8i
5. learn AIX

 My aim is to go to US . Can you guide me :
Well the green paper is always yummy...

 
 1.. How to get the list of good firms in US , to apply for a 
 DBA post ?
www.dbajobs.com
www.dice.com

 2. Shall I change my present job , just because the database 
 is of older version ( which I was not knowing while joining
 ) ?
change ur job if u dont hv work. not the question of version. its the
question of what u know in that version. remember versions will keep on
coming.
by the time u come to US and settle here, it may be 9i, who knows. there r
many gurus on this list who r masters in 7.x, cos that what their job
demanded. i met a guy in LA who had worked for NASA and had been working on
almost all types of unixes and oracle 7, was a dba, but hardly knew any
features of 8i. well he didnt found a need to keep up to date. 


 3. Will certification of Sun Solaris System Administration be 
 helpful to me?
learning an OS never harms. it wld certainly add to ur resume.

 4. Will an Advanced DBA course ( Oracle parallel server, 
 Replication, distributed DB)  be helpful to me ?
where will u apply that? well u can always learn everything, but try to
balance it against ur job requirements and in which sector of Oracle admin u
want to excel.

For a start why dont u try getting ur OCP in 8i.

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

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

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

Script for heaven


Hi guys,

I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
dictionary view, do you have any scripts to share such as to display
redologs, tablespaces, earlier potential problems ?

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

Script from heaven



Hi guys,

I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
dictionary view, do you have any scripts to share such as to display
redologs, tablespaces, earlier potential problems detection?

Thank you so much..

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

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

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

RE: Script for heaven

select * from dict_comments

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 07, 2001 8:26 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Script for heaven

 Hi guys,

 I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
 dictionary view, do you have any scripts to share such as to display
 redologs, tablespaces, earlier potential problems ?

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

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

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

Re: Script from heaven

2001-03-07 Thread Joseph S. Testa


start by reading the docs on dba_* views.

joe


[EMAIL PROTECTED] wrote:
 
 Hi guys,
 
 I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
 dictionary view, do you have any scripts to share such as to display
 redologs, tablespaces, earlier potential problems detection?
 
 Thank you so much..

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

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

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

Script for oracle8i on solaris 2.7


Hi Mandar and other Oracle gurus,

As DBA, I don't have the table called "dict_comments" do you guys have any
ideas how to create one and populate with the correct information the
tables? or may be I have to run an oracle's script to get that table ?

-Original Message-
Ghosalkar
Sent: Thursday, 8 March 2001 10:45 AM
To: Multiple recipients of list ORACLE-L


select * from dict_comments

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 07, 2001 8:26 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Script for heaven


 Hi guys,

 I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
 dictionary view, do you have any scripts to share such as to display
 redologs, tablespaces, earlier potential problems ?

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

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

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

Script to display user infromation