date:20011121


Marlene goes over it in the networking 101 book -- it's a new feature


--- Mohan, Ross [EMAIL PROTECTED] wrote:
 Anyone seen this fecality in their listener.ora?  It's a new one on
 me, 
 but then again, what with all the newfangled features in this here 
 product, I am probably just losing track..
 
 
 
 (DESCRIPTION =
   (PROTOCOL_STACK =
 (PRESENTATION = GIOP)
 (SESSION = RAW)
   )
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
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: SQL question

2001-11-21 Thread Nicoll, Iain (Calanais)


Fawzia,

You should be able to use mod(field,1) to get the remainder of the
number divided by 1, which should be the last four digits.

Cheers

Iain Nicoll

-Original Message-
Sent: Wednesday, November 21, 2001 4:04 PM
To: Multiple recipients of list ORACLE-L



Hi,

Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??

Any advice/hints would be greatly appreciated

Rgds

Fawzia 


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

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

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


yeah that would work too :)


--- [EMAIL PROTECTED] wrote:
 Rachel,
 
 I create a role called 'developer' in each instance at create
 time.  Make it
 look something like resource, but without the unlimited tablespace
 priv, and use
 it in place of resource.  saves a step.
 
 Dick Goulet
 
 Reply Separator
 Subject:Re: Index File Name
 Author: Rachel Carmichael [EMAIL PROTECTED]
 Date:   11/21/2001 7:45 AM
 
 standard create user script for a user who will own objects:
 
 create user xyz identifed by abc
 default tablespace default
 temporary tablespace temp
 quota unlimited on default
 /
 grant connect, resource to xyz
 /
 revoke unlimited tablespace from xyz
 /
 
 
 I've gotten this drilled into my people's heads... and I check up
 on it :)
 --- Stephane Faroult [EMAIL PROTECTED] wrote:
  Mark Leith wrote:
   
   And just to add to that - make sure that the user has the
  appropriate
   privileges on the system, such as CREATE TABLE / INDEX, or the
 role
  RESOURCE
   or whatever.. :)
   
   Just to nitpick :)
   
  
  NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if
 you
  cannot grant it to a role, usually - but Oracle 5 compatibility has
  its
  reasons ...). Not that I am paranoid, but the idea of users being
  able
  to create their tables in SYSTEM makes me nervous.
   I know, someone should tell to the Oracle folks who prepare demo
  scripts ...
  -- 
  Regards,
  
  Stephane Faroult
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:+44  (0) 7050-696-449 
  Performance Tools  Free Scripts
  --
  http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
  --
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Stephane Faroult
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 
 
 __
 Do You Yahoo!?
 Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
 http://geocities.yahoo.com/ps/info1
 -- 
 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).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
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: SQL question

2001-11-21 Thread Stephane Faroult


Malik, Fawzia wrote:
 
 Hi,
 
 Can you tell me if its possible to write some sql to change some data.
 Basically I need to run a scritp to change data of column: id from 12345678
 to the last four digits. Is this possible to do in sql/plsql??
 
 Any advice/hints would be greatly appreciated
 
 Rgds
 
 Fawzia
 

I assume that id is a number.

1) If it happens to be a PK, drop all the FK constraints refering it,
and the PK itself.
2)  Update T
set id = to_number(substr(to_char(number), length(to_char(number)) -
4))

should do the trick (give or take a parenthese).

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools  Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Problem Running DDL SQL Script

2001-11-21 Thread Ken Janusz


I have this script that will generate a DB with a number of create table and
create index statements.  When I try to run it in SQL*Plus I get this error:

ORA-00959 tablespace SOS2_TBLSPC does not exist.  
ORA-00942 table or view doesn't exist

Here is a sample of one of the create statements:

DROP TABLE ACCESS_RIGHT CASCADE CONSTRAINTS ; 

CREATE TABLE ACCESS_RIGHT ( 
  ACCESS_RIGHT_ID  NUMBERNOT NULL, 
  GROUP_ID NUMBERNOT NULL, 
  MODULE_IDNUMBERNOT NULL, 
  CONSTRAINT PK_AR_ALL
  PRIMARY KEY ( ACCESS_RIGHT_ID, GROUP_ID, MODULE_ID ) 
USING INDEX 
 TABLESPACE SOS2_TBLSPC PCTFREE 10
 STORAGE ( INITIAL 120K NEXT 104K PCTINCREASE 0 ))
   TABLESPACE SOS2_TBLSPC NOLOGGING 
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 30720
   NEXT 8192
   MINEXTENTS 1
   MAXEXTENTS 505
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

When I check the DB this tablespace exists and is online.  I'm logged in as
system/manager.  The environment is W2000/8.1.7.

Any idea what the problem is?

Thanks,

Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, Inc.  
Minneapolis, MN





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

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

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

Re: Index File Name


heck, I've occasionally logged in as system and forgotten to specify
the tablespace.

power is a dangerous thing

--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Mark Leith wrote:
  
  Yeah but for a tightly controlled schema *owner* - what's the
 problem?
  Wouldn't you *want* to have unlimited tablespace for the schema
 owner -
  which the users *should not* have access to anyway?
  
  (no this is not rhetorical - I have no production experience)
  
  Thanks
  
  Mark
 
 End-users are not the ones to fear. Developers are. Assume you
 control
 as tightly as you want, we all have our bad days and forget someday
 to
 do something we should have - and know we should have. Just imagine a
 user with UNLIMITED TABLESPACE for which you forgot to change the
 default tablespace from SYSTEM. I am ready to bet that before long
 you'll find unique indexes named (good case) TABLENAME_PK or (bad
 case)
 SYS_C12345 in SYSTEM. Don't give people any right they do not
 need.
 -- 
 Regards,
 
 Stephane Faroult
 Oriole Corporation
 Voice:  +44  (0) 7050-696-269 
 Fax:+44  (0) 7050-696-449 
 Performance Tools  Free Scripts
 --
 http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
 --
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Stephane Faroult
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
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).

close_cached_open_cursors error

2001-11-21 Thread Denham Eva

Title: close_cached_open_cursors error





Hello Guru's


I hope someone can shed light on this problem, more a nuisance really.
The below Alter Session statement has been appearing in the *alrt.log file.


ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter


The system is a Compaq 8500R system, Win2K and Oracle 817.
Does anyone have an idea of what this is as everyone I have approached here at my work claims not to be using it, I suspect a third party product. 

Absolutely any info will be appreciated.


TIA
Denham




This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoftware.com

RE: Oracle 9i and OEM

2001-11-21 Thread Kimberly Smith


Have you got all your instances defined in the oratab file?
If not, define the missing one and restart the agent and
see if that fixes your problem.

-Original Message-
Sent: Tuesday, November 20, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a problem with Enterprise Manager.

I am trying to refresh a node in order to get information of all instances 
on that machine. I am able to see two of three instances. Why I cannot see 
all of them. Setting up the preferences are ok, I have tested all user-id's 
and passwords.

TIA,

Sepi



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

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

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

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

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

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

RE: Reliable alerting system that is not so costly??

2001-11-21 Thread Kumanan Balasundaram


Hi,

There is a free monitoring/alerting system with escalation that is commonly
used and is called Netsaint.

We are to try this out.

Thanks to those who responded.
Kumanan



 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: 21 November 2001 15:52
 To:   Kumanan Balasundaram
 Subject:  Re:Reliable alerting system that is not so costly??
 
 Kumanan,
 
 Many years ago I wrote a Pro*C program to do the alerting and fixing
 for me.
  It has grown over the years and become kind of a cornerstone around here.
 If
 your into C programming your welcome to a copy of the source code.
 
 Dick Goulet
 Oracle Certified 8i DBA
 
 Reply Separator
 Subject:Reliable alerting system that is not so costly??
 Author: Kumanan Balasundaram [EMAIL PROTECTED]
 Date:   11/21/2001 3:50 AM
 
 Hi  there,
 
 Any of you using or have come across a reliable alert system that can also
 escalate 
 to different persons based on criteria such as how important that system
 is?
 
 We are looking to invest in such a software.
 
 Kumanan Balasundaram
 Database Administrator, IT
 QXL ricardo plc
 www.qxl.com
 P: +44 (0)208 962 7409
 
  QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge
 Road,
  London W6 9EJ
  Registered in England No 3430894 VAT number - GB 701 8915 43
  
  The information transmitted is intended only for the person or entity to
  which it is addressed and may contain confidential and/or privileged
  material.  Any review, retransmission, dissemination or other use of, or
  taking of any action in reliance upon, this information by persons or
  entities other than the intended recipient is prohibited.   If you
  received  this in error, please contact the sender and delete the
 material
  from any computer
  
 
 
 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 [EMAIL PROTECTED]
 
 This footnote also confirms that this email message has been swept by
 MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer
 viruses.
 
 **
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Kumanan Balasundaram
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Kumanan Balasundaram
  INET: [EMAIL PROTECTED]

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

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

2001-11-21 Thread Deshpande, Kirti


That's precisely what I do..
I have  *_user and schema_owner_developer role with just what they need.
No more. No less. However, certain developers will have direct access to
tables for coding stored procedures, but those are very limited in number.  
Standard ksh script to add these users to the database, accepting userid,
password, roles etc. So the backup DBA can do this when I am out. 

- Kirti  

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, November 21, 2001 10:04 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re[2]: Index File Name
 
 Rachel,
 
 I create a role called 'developer' in each instance at create time.
 Make it
 look something like resource, but without the unlimited tablespace priv,
 and use
 it in place of resource.  saves a step.
 
 Dick Goulet
 
 Reply Separator
 Author: Rachel Carmichael [EMAIL PROTECTED]
 Date:   11/21/2001 7:45 AM
 
 standard create user script for a user who will own objects:
 
 create user xyz identifed by abc
 default tablespace default
 temporary tablespace temp
 quota unlimited on default
 /
 grant connect, resource to xyz
 /
 revoke unlimited tablespace from xyz
 /
 
 
 I've gotten this drilled into my people's heads... and I check up
 on it :)
 --- Stephane Faroult [EMAIL PROTECTED] wrote:
  Mark Leith wrote:
   
   And just to add to that - make sure that the user has the
  appropriate
   privileges on the system, such as CREATE TABLE / INDEX, or the role
  RESOURCE
   or whatever.. :)
   
   Just to nitpick :)
   
  
  NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
  cannot grant it to a role, usually - but Oracle 5 compatibility has
  its
  reasons ...). Not that I am paranoid, but the idea of users being
  able
  to create their tables in SYSTEM makes me nervous.
   I know, someone should tell to the Oracle folks who prepare demo
  scripts ...
  -- 
  Regards,
  
  Stephane Faroult
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:+44  (0) 7050-696-449 
  Performance Tools  Free Scripts
  --
  http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
  --
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Stephane Faroult
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 __
 Do You Yahoo!?
 Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
 http://geocities.yahoo.com/ps/info1
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Have a good Thanksgiving--THANKSGIVING_LOAD.SQL

2001-11-21 Thread tday6


--THANKSGIVING_LOAD.SQL
--T. Day, SAI, 21-NOV-01
--Run on WORLD.UNIVERSE using schema with DEITY role
declare
cursor c_thanksgiving is
  select
PERSON_ID   /* NOT SSN -- generated by sequence generator
(Jared) */
   ,RELATION
   ,CONDITION
  from YOUR.LIFE@WORLD where RELATION is not null;

V_CONDITION   VARCHAR2 := NULL;
--
BEGIN
  For PERSON_ROW in C_thanksgiving  LOOP
V_CONDITION   := NULL;
  BEGIN
IF PERSON_ROW.RELATION = 'FRIEND' THEN
   V_CONDITION := 'CONFIDENCE'
ENDIF;
IF PERSON_ROW.RELATION = 'ENEMY' THEN
   V_CONDITION := 'CONFUSION'
ENDIF;
  UPDATE YOUR.LIFE@WORLD SET CONDITION = V_CONDITION WHERE
PERSON_ID = PERSON_ROW.PERSON_ID;
  END;
COMMIT;
 END LOOP
END;

Does that make it on topic?

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

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

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

Re: RE:

2001-11-21 Thread Moucka otakar


I have next problem , syntax its ok.

SQL Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace tablespace_core including content;
ORACLE instance started.
 
Total System Global Area  178213024 bytes
Fixed Size73888 bytes
Variable Size 161189888 bytes
Database Buffers   16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SQL
Database altered.
 
SQL
Database altered.
 
SQL drop tablespace tablespace_core including content
*
ERROR at line 1:
ORA-02216: tablespace name expected



Dne st 21. listopad 2001 17:03 jste napsal(a):
 Jaysus, note the date and time. It's a freaking miracle.

 ;-)

 -Original Message-
 Sent: Wednesday, November 21, 2001 10:54 AM
 To: Mohan; Ross; Multiple recipients of list ORACLE-L


 OOPS! sorry, your right

 Reply Separator
 Author: Mohan; Ross [EMAIL PROTECTED]
 Date:   11/21/2001 7:40 AM

 cascade?  probably more abject ignorance on my part, but wasn't it
 including contents?

 -Original Message-
 Sent: Wednesday, November 21, 2001 10:15 AM
 To: Multiple recipients of list ORACLE-L


 Startup mount
 alter database datafile '/data/db/database/core.dbf' offline drop;
 alter database open;
 drop tablespace tablespace_name cascade;


 Dick Goulet

 Reply Separator
 Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= [EMAIL PROTECTED]
 Date:   11/21/2001 5:40 AM

  Hello
 I need a help with one problem. In the Oracle version 8.1.7 I've deleted
 a tablespace in the Linux, but before this I did't use a function 
 Drop.
  After reboot a database, there was a error:
 ERROR at line 1:
 ORA-01116: error in opening database file 7
 ORA-01110: data file 7: '/data/db/database/core.dbf'
 ORA-27041: unable to open file
 Linux Error: 2: No such file or directory
 Additional information: 3
 Is there a some re-step to drop tablespace and then regulary delete
 this object and restart the database ?
   Thanx a lot for your answer.

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

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

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

2001-11-21 Thread Henry Poras


You need to move the database to 8.1.6 (upgrade, run catalog et al).
Compatible will just keep certain feature turned off.

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


That's exactly what I was saying I think.  ie. To quickly move 8.0.5 to
8.1.6, set compatible and everything should run without doing anything else
(including the u*.sql script).  You can run migration later if you need
new features of 8.1.6.

Reasonable statement?

Best,

Ed

-Original Message-
Sent: Wednesday, November 21, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment.

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the compatible parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

 Ed,

   There's more to it than just setting the
 COMPATIBLE parameter.  The basic steps
 are

 1) install new 8.1.6 executables
 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
   making whatever modifications are necessary due to
   new or obsoleted parameters
 3) startup database
 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
 to new forms needed by 8.1.6 software.  Once this is done, NEVER
 open the database using the old version, as it can corrupt the database.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Doing linear scans over an associative array is like
 trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)

  -Original Message-
  From: Ed [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, November 20, 2001 6:00 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Upgrade 8.0.5 to 8.1.6
 
 
  A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
  by using export/import.  This will probably work, but wouldn't it be
  easier to just do a cold backup and open them using the
  COMPATIBLE parameter in the 8.1.6 environment?  Is there
  any downside to using export/import? (ie. will it affect snapshots,
  db links, etc...).
 
  I thought the whole point of the compatible parameter was that
  it let you open up an older database with no questions asked.
  Then you could run any of the upgrade .sql scripts at your leisure,
  yes?
 
  Best,
 
  Ed
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Ed
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Mr. Clark
  INET: [EMAIL PROTECTED]

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

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

Re: Fwd: A problem

2001-11-21 Thread Dias Costa


Hi !


May be this will help you (I hope).
This solution is for Windows (X) but 
with some work it will do also in UNIX.



A procedure called BackupOSC is created by 
the DBA in his schema.
A job is created with at command, invoking
the batch command file backup_OSC.cmd wich 
in turn calls SQLPLUSW to run the above procedure.
The outcome is a batch command file called exp_OSC.cmd
wich is invoked by the firts batch file to perform the
real export.

The secret is to use the SQL to create the second file
since DOS hasn't the ability to handle strings.


Hope it helps.
Dias Costa


P.S.:   The files are attached.
The file exp_Ora.ftp is a parameter file for 
to FTP the DMP files to other machine.
If you find some strange words in the files,
they are Portuguese.











Jared Still wrote:
 
 --  Forwarded Message  --
 Date: Wed, 21 Nov 2001 15:34:27 +0100
 
 I have created a job to export a user shema
 How can I tell Oracle each time it make the export to use lets say
 namedate.dmp
 I mean for example if today is 21.11.2001
 the exported file whoud have name21112001.dmp or something like this...
 
 ---
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jared Still
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


exp_OSC.cmd
Description: application/unknown-content-type-cmdfile

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.


--  file: backupSmartUser.sql
--  -
set linesize 300
set echo on
set feed off
set serveroutput on size 1
set sqlprompt 'REM '
spool D:\Export_Oracle\exp_OSC.cmd
execute system.BackupOSC;
spool off
exit



--  file: cp_BackupOSC.sql
--  --
--
--  procedure invoked for the backup of schema: OSC
--
--
create or replace procedure BackupOSC as
--
   Linha0 varchar2 (20);
   Linha1 varchar2 (100);
   Linha2 varchar2 (200);
   Linha3 varchar2 (30);
   Linha4 varchar2 (40);
   Linha5 varchar2 (250);
   Linha6 varchar2 (250);
   Linha7 varchar2 (10);

begin
Linha0 := 'ECHO ON';
--
SELECT   'ECHO 
 ' 
into  Linha1
FROM  DUAL;
-- 
SELECT   'ECHO Backing up the OSC user (Instance DC8i)  done on: ' || 
TO_CHAR(SYSDATE,'/MM/DD') || ' starting time ' || TO_CHAR(SYSDATE,'hh:mm:ss') 
into  Linha2
FROM  DUAL;
--
Linha3 := 'SET ORACLE_SID=DC8i';
Linha4 := 'SET ORACLE_HOME=E:\ORACLE\ORA81';
--
SELECT   'exp USERID=system/manager owner=OSC FILE=d:\Export_Oracle\OSC_' || 
TO_CHAR(SYSDATE,'MMDD_HHMI') || ' LOG=d:\Export_Oracle\OSC_' || 
TO_CHAR(SYSDATE,'MMDD_HHMI') || ' BUFFER=40 COMPRESS=y' 
into  Linha5
FROM  DUAL;
--
SELECT   'ECHO Backup finished: ' || TO_CHAR(SYSDATE,'hh:mi:ss') || '  
d:\Export_Oracle\OSC_backups.log' 
into  Linha6
FROM  DUAL;
--
Linha7 := 'EXIT';
--
dbms_output.put_line(linha0);
dbms_output.put_line(linha1);
dbms_output.put_line(linha2);
--dbms_output.put_line(Linha3); not needed
--dbms_output.put_line(Linha4); not needed
dbms_output.put_line(linha5);
dbms_output.put_line(linha6);
--dbms_output.put_line(linha7); will see
end BackupOSC;
/



oracle01
franca4
binary
prompt no
cd /usr/oraexp
mput d:\Export_Oracle\*.DMP
bye




backup_OSC.cmd
Description: application/unknown-content-type-cmdfile

RE: applying patch 2032040 to Oracle Purchasing

2001-11-21 Thread John Kanagaraj


Matt,
 
I installed the whole HTML/PDF set of manuals that comes with the 11i CD Set
onto my laptop. This then provides an indexed version of the manuals in PDF
from a HTML page. FWIW, I am also one of those who recently (just about 1
year) 'migrated' from a normal DBA to doing Apps stuff, and those manuals
are invaluable (if not a bother to digest all in one go).
 
Have a nice holiday everyone - and safe driving/travelling!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

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

** The opinions and statements above are entirely my own and not
those of my employer or clients **


-Original Message-
Sent: Wednesday, November 21, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L



I looked in metalink and maybe I'm just blind, 
but I don't find a 'Maintaining Oracle 
Applications' manual. 

URLs would be greatly apprecieated. 

 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
Doing linear scans over an associative array is like 
trying to club someone to death with a loaded Uzi. 
- Larry Wall (creator of Perl) 

 -Original Message- 
 From: John Kanagaraj [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] 
 Sent: Tuesday, November 20, 2001 7:45 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: RE: applying patch 2032040 to Oracle Purchasing 
 
 
 Matt, 
  
 I think you should get to read the 'Maintaining Oracle 
 Applications' manual 
 - all the ad utilities are described therein. My 
 understanding is that the 
 install progress is recorded in the FND_INSTALL table and a 
 restart will 
 look up this and decipher what else needs to be done. As far 
 as your error 
 goes, the solution is to open an iTar and sit back until you 
 get called... 
 As I said before, Patching is the bane of an Apps DBA! 
  
 John Kanagaraj 
 Oracle Applications DBA 
 DBSoft Inc 
 (W): 408-970-7002 
 
 Kill your killer-commute! Listen to great commercial-free 
 christian music 
 24x7 (details at www.klove.com) 
 
 ** The opinions and statements above are entirely my own and not 
 those of my employer or clients ** 
 
 
 -Original Message- 
 Sent: Tuesday, November 20, 2001 6:00 AM 
 To: Multiple recipients of list ORACLE-L 
 
 
 
 After applying the c.drv portion of the patch, 
 I'm attempting to apply the d.drv portion of patch 
 the patch above and adwork1 is failing applying the d.drv file. 
 
 In the adwork1.log file I see, 
 jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail 
 -thin -user USERNAME/PASSSWORD@host:port:SID 
 /opt/oracle/testappl/admin/test/out/p01ldjva.jar 
 
 followed by a ton of 
 ORA-03115 unsupported network/data/type or representation 
 and 
 ORA-29509 incorrectly formed Java binary class definition 
 errors. 
 
 I suspect that the file 
 /opt/oracle/testappl/admin/test/out/p01ldjva.jar 
 was taken from new xmlparserv2.zip file that is present in 
 the patch. 
 
 Being the relative newcomer at this, my question is 
 what do I do now?  It's already got part way through 
 applying the d.drv file, which means (if i understand this 
 correctly) that I cannot un-patch.  I have to recover from the 
 backup.  What can I do to try to move this forward rather 
 than recovering and starting over? 
 
  
 Matt Adams - GE Appliances - [EMAIL PROTECTED] 
 Doing linear scans over an associative array is like 
 trying to club someone to death with a loaded Uzi. 
 - Larry Wall (creator of Perl) 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com  
 -- 
 Author: John Kanagaraj 
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
 San Diego, California-- Public Internet access / Mailing Lists 
  
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L 
 (or the name of mailing list you want to be removed from).  You may 
 also send the HELP command for other information (like subscribing). 
 

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

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

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

RE: Odd Listener.ora Stanza


For all this means to me I might as well post it on the OT list.

LOL!!!  yeait makes sense, at least in terms of all of
the acronyms being internally self-consistent.

Yours in Inflating Acronyms, 

Ross 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/21/2001 11:05 AM

Ross,

fecality? Is that the F in RTFM? Well, things are pretty slow here (who
am I
kidding. They have been, no wait. It has been pretty slow here for
months)
so I grabbed my Net8 book. Not that this makes a lot of sense, but this
is
what it says.

PRESENTATIONIdentifies the presentation layer
Default TTC
Values  TTC|GIOP

TTC Two-task Common
GIOP IIOP clients require GIOP. It is an alias
for
either oracle.aurora.server.SGiopServer or
 oracle.aurora.server.GiopServer using
TCP/IP or
TCP/IP with SSL

SESSION Identifies the session layer (oh)
Default NS
Values  NS|RAW

IIOP clients require no session layer (RAW)
Typical Net8 clients use a session layer of
Transparent Network Substrate (TNS) Network Session (NS).

For all this means to me I might as well post it on the OT list.

HB

Henry



-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the newfangled features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: OT: X Win client

2001-11-21 Thread Jared Still



Yes, Xfree86.

Just do a search on google.  I use it to run Oracle
installs, so it works well enough.

Jared

On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
 Hi all!

 Is there any free (important: free) X client software for NT?

 Regards,
 Vladimir Barac


Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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

Re[2]: RE:

2001-11-21 Thread dgoulet


In many a case on the list we don't have the information to fill in to all sql
statements, like in this case the name of the tablespace.  The common way to
indicate that is to frame the variable with a set or '' brackets.  What you
need to do is replace the 'tablespace_core' with the rean tablespace name, in
your case, from previous posts:

drop tablespace core including contents;


BTW: you should be able to simply startup your database by now.  Tablespace core
should be offline.

Dick Goulet

Reply Separator
Author: Moucka otakar [EMAIL PROTECTED]
Date:   11/21/2001 10:10 AM

I have next problem , syntax its ok.

SQL Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace tablespace_core including content;
ORACLE instance started.
 
Total System Global Area  178213024 bytes
Fixed Size73888 bytes
Variable Size 161189888 bytes
Database Buffers   16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SQL
Database altered.
 
SQL
Database altered.
 
SQL drop tablespace tablespace_core including content
*
ERROR at line 1:
ORA-02216: tablespace name expected



Dne st 21. listopad 2001 17:03 jste napsal(a):
 Jaysus, note the date and time. It's a freaking miracle.

 ;-)

 -Original Message-
 Sent: Wednesday, November 21, 2001 10:54 AM
 To: Mohan; Ross; Multiple recipients of list ORACLE-L


 OOPS! sorry, your right

 Reply Separator
 Author: Mohan; Ross [EMAIL PROTECTED]
 Date:   11/21/2001 7:40 AM

 cascade?  probably more abject ignorance on my part, but wasn't it
 including contents?

 -Original Message-
 Sent: Wednesday, November 21, 2001 10:15 AM
 To: Multiple recipients of list ORACLE-L


 Startup mount
 alter database datafile '/data/db/database/core.dbf' offline drop;
 alter database open;
 drop tablespace tablespace_name cascade;


 Dick Goulet

 Reply Separator
 Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= [EMAIL PROTECTED]
 Date:   11/21/2001 5:40 AM

  Hello
 I need a help with one problem. In the Oracle version 8.1.7 I've deleted
 a tablespace in the Linux, but before this I did't use a function 
 Drop.
  After reboot a database, there was a error:
 ERROR at line 1:
 ORA-01116: error in opening database file 7
 ORA-01110: data file 7: '/data/db/database/core.dbf'
 ORA-27041: unable to open file
 Linux Error: 2: No such file or directory
 Additional information: 3
 Is there a some re-step to drop tablespace and then regulary delete
 this object and restart the database ?
   Thanx a lot for your answer.

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

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

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

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

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

Re: Fwd: A problem

2001-11-21 Thread Scott Shafer


Try sumthin' like:

EDATE=$(date +%C%y%m%d)
FILENAME=name${EDATE}.dmp

exp / file=${FILENAME} ...

Do a 'man date' to see the different formatting options.

HTH,

Scott Shafer
San Antonio, TX


Jared Still wrote:
 
 --  Forwarded Message  --
 Date: Wed, 21 Nov 2001 15:34:27 +0100
 
 I have created a job to export a user shema
 How can I tell Oracle each time it make the export to use lets say
 namedate.dmp
 I mean for example if today is 21.11.2001
 the exported file whoud have name21112001.dmp or something like this...

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

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

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

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

Re: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Deepak Thapliyal


Ed,

the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out

Deepak

--- Ed [EMAIL PROTECTED] wrote:
 A DBA here is trying to upgrade several 8.0.5
 databases to 8.1.6
 by using export/import.  This will probably work,
 but wouldn't it be
 easier to just do a cold backup and open them using
 the
 COMPATIBLE parameter in the 8.1.6 environment?  Is
 there
 any downside to using export/import? (ie. will it
 affect snapshots,
 db links, etc...).  
 
 I thought the whole point of the compatible
 parameter was that
 it let you open up an older database with no
 questions asked.
 Then you could run any of the upgrade .sql scripts
 at your leisure,
 yes?
 
 Best,
 
 Ed
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Ed
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

2001-11-21 Thread Miller, Jay


The only problem with this technique is that you won't reclaim the space in
the first tablespace that used to be used by the indexes (since the high
water marke will be set).  If this isn't an issue (either lots of storage
space or the data is expected to grow enough to use this space) then I agree
this is the better option.

Jay Miller

-Original Message-
Sent: Wednesday, November 21, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L


Sorry forgot the command in my earlier email

To recap, here are the steps

1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
  alter index index_owner.index_name rebuild online tablespace 
new_tablespace;


From: Ken Janusz [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Fixing a DB
Date: Wed, 21 Nov 2001 05:25:34 -0800

We have a DB that is currently in more-or-less development mode for a state
government client.  The DB has been created (11,300 lines of SQL*Plus code)
with the tables and indexes stored in the permanent tablespace
(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
currently holds test data.  I think the process to correct this would be:

1. Determine the size, etc. of the INDEX tablespace, write the script and
then run it to create the tablespace.

2. Go through the DDL SQL script for OKSOS (state gov. office name
abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
tablespace name.

3. Then run the DDL SQL script to create the new DB.

4. Then do and Export of the data from the old DB and Import it into the 
new
DB.

5. Then I think I have to regenerate your indexes.  I'm not clear on this
point. Will the Export/Import process may take care of this?

Is there anything I have missed?  I'm sure there is.

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN


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

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

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


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

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

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

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

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

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

ftp tools

2001-11-21 Thread Ball, Terry


Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

2001-11-21 Thread Ed


Yes, I agree 100%, but people here are concerned that upgrading will break
the database, and we have to QUICKLY move everything over to 8.1.6. (Long
story).  What I was really after in my original question was: why is the
upgrade script a better solution than just recreating the tablespaces in
8.1.6 and importing from an export of the old database?  Does it just save
time?  Is there a downside to using export/import this way?

Best!

Ed

-Original Message-
Thapliyal
Sent: Wednesday, November 21, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Ed,

the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out

Deepak

--- Ed [EMAIL PROTECTED] wrote:
 A DBA here is trying to upgrade several 8.0.5
 databases to 8.1.6
 by using export/import.  This will probably work,
 but wouldn't it be
 easier to just do a cold backup and open them using
 the
 COMPATIBLE parameter in the 8.1.6 environment?  Is
 there
 any downside to using export/import? (ie. will it
 affect snapshots,
 db links, etc...).

 I thought the whole point of the compatible
 parameter was that
 it let you open up an older database with no
 questions asked.
 Then you could run any of the upgrade .sql scripts
 at your leisure,
 yes?

 Best,

 Ed


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

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


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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-11-21 Thread Bill Conner


At 01:10 PM 11/21/2001 -0800, you wrote:
Does anyone know a site where one can get a FREE gui ftp tool?

How about warftp   i think that it is www.warftp.com.


Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

2001-11-21 Thread Bill Conner


At 01:10 PM 11/21/2001 -0800, you wrote:
Does anyone know a site where one can get a FREE gui ftp tool?


Sorry it is http://www.jgaa.com.


How about warftp   i think that it is www.warftp.com.


Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

2001-11-21 Thread Deepak Thapliyal


Terry, check out www.vandyke.com ..

Deepak

PS: more so check out google.com .. ;)

--- Ball, Terry [EMAIL PROTECTED] wrote:
 Does anyone know a site where one can get a FREE gui
 ftp tool?
 
 Thanks,
 Terry
 
 Terry Ball, DBA
 Birch Telecom
 Work: 816-300-1335
 FAX:  816-300-1801
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Ball, Terry
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

2001-11-21 Thread Jared Still



Ed, 

If your databases are more than a couple of gig, 
upgrading is faster.

If over 10 gig, don't even think about importing it.

Jared

On Wednesday 21 November 2001 13:15, Ed wrote:
 Yes, I agree 100%, but people here are concerned that upgrading will
 break the database, and we have to QUICKLY move everything over to 8.1.6.
 (Long story).  What I was really after in my original question was: why is
 the upgrade script a better solution than just recreating the tablespaces
 in 8.1.6 and importing from an export of the old database?  Does it just
 save time?  Is there a downside to using export/import this way?

 Best!

 Ed

 -Original Message-
 Thapliyal
 Sent: Wednesday, November 21, 2001 12:20 PM
 To: Multiple recipients of list ORACLE-L


 Ed,

 the whole point of compatable is to mimick behaviour
 of an older release .. like optimizer plans etc.
 upgrading the db would be the way to go for this..
 like many have already pointed out

 Deepak

 --- Ed [EMAIL PROTECTED] wrote:
  A DBA here is trying to upgrade several 8.0.5
  databases to 8.1.6
  by using export/import.  This will probably work,
  but wouldn't it be
  easier to just do a cold backup and open them using
  the
  COMPATIBLE parameter in the 8.1.6 environment?  Is
  there
  any downside to using export/import? (ie. will it
  affect snapshots,
  db links, etc...).
 
  I thought the whole point of the compatible
  parameter was that
  it let you open up an older database with no
  questions asked.
  Then you could run any of the upgrade .sql scripts
  at your leisure,
  yes?
 
  Best,
 
  Ed
 
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Ed
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists

 

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

 __
 Do You Yahoo!?
 Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
 http://geocities.yahoo.com/ps/info1
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Deepak Thapliyal
   INET: [EMAIL PROTECTED]

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

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

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

RE: ftp tools

2001-11-21 Thread Suhen Pather


Terry,

WS_FTP is a freeware

Check www.tucows.com

Regards
Suhen

Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

ORA-4031 error on one instance but not on other

2001-11-21 Thread Jamadagni, Rajendra


Hi all,

I have two 9i instances, one of them consistently produces following error,
whereas other doesn't.

SQLException:61000java.sql.SQLException: ORA-04031: unable to allocate
1028736 bytes of shared memory (shared pool,unknown object,hash-join
subh,kllcqc:kllcqslt) ORA-06512: at ESPN.INTRANETGAMEINFO, line 412
ORA-06512: at line 1 

I have searched and searched Metalink for this error and its parameters, but
no clues.  This procedure is called from a jdbc client, it is a jsp, which
uses a servlet, which calls a pl/sql package. We identified what portion is
causing the problem, it is a cursor loop. If there are now rows returned by
the cursor, no problem, it works fine. But other wise this error is
returned. The max number of rows returned is about 40, the row size is
pretty small too. One more thing, in the cursor loop user is populating a
varray.

The large pool is set to 0, SGA has enough free space available.
Any ideas are greatly appreciated.
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

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




*1

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

*1

Re: ftp tools

2001-11-21 Thread Gene Sais


not free, but ipswitch's ftp is nice and cheap ~$400.
very easy to admin.

http://www.ipswitch.com/

gene

 [EMAIL PROTECTED] 11/21/01 16:55 PM 
Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

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

RE: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Kent Wayson



When I did this, the migration assistant was much quicker than export/import.


Kent


Yes, I agree 100%, but people here are concerned that upgrading will break
the database, and we have to QUICKLY move everything over to 8.1.6. (Long
story).  What I was really after in my original question was: why is the
upgrade script a better solution than just recreating the tablespaces in
8.1.6 and importing from an export of the old database?  Does it just save
time?  Is there a downside to using export/import this way?

Best!

Ed

-Original Message-
Thapliyal
Sent: Wednesday, November 21, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Ed,

the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out

Deepak

--- Ed [EMAIL PROTECTED] wrote:
 A DBA here is trying to upgrade several 8.0.5
 databases to 8.1.6
 by using export/import.  This will probably work,
 but wouldn't it be
 easier to just do a cold backup and open them using
 the
 COMPATIBLE parameter in the 8.1.6 environment?  Is
 there
 any downside to using export/import? (ie. will it
 affect snapshots,
 db links, etc...).

 I thought the whole point of the compatible
 parameter was that
 it let you open up an older database with no
 questions asked.
 Then you could run any of the upgrade .sql scripts
 at your leisure,
 yes?

 Best,

 Ed


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

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


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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

2001-11-21 Thread Deepak Thapliyal


Yes it will save time as well ..all the upgrade does
is mess the datafile headers so they are 816 format 
also the upgrade script will simply re-initialze the
catalog to 816 is also quite fast and will complete in
a few minutes .. 

if you have a 1TB db for e.g. upgrade would definitely
be a far more faster option .. 

as for upgrade breaking your db .. more chances that
your approach of only setting the compatable flag
might in turn lead to software corruption in the long
run if not immediately .. thing change with ever
release .. and when its oracle .. this REALLY change a
lot .. and hence they recommend the upgrade path .. 

however if your db is small .. then maybe creating an
an 817 db and creating tablespaces and then exp-imp
way will work as well .. 

Deepak


--- Ed [EMAIL PROTECTED] wrote:
 Yes, I agree 100%, but people here are concerned
 that upgrading will break
 the database, and we have to QUICKLY move everything
 over to 8.1.6. (Long
 story).  What I was really after in my original
 question was: why is the
 upgrade script a better solution than just
 recreating the tablespaces in
 8.1.6 and importing from an export of the old
 database?  Does it just save
 time?  Is there a downside to using export/import
 this way?
 
 Best!
 
 Ed
 
 -Original Message-
 Thapliyal
 Sent: Wednesday, November 21, 2001 12:20 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Ed,
 
 the whole point of compatable is to mimick behaviour
 of an older release .. like optimizer plans etc.
 upgrading the db would be the way to go for this..
 like many have already pointed out
 
 Deepak
 
 --- Ed [EMAIL PROTECTED] wrote:
  A DBA here is trying to upgrade several 8.0.5
  databases to 8.1.6
  by using export/import.  This will probably work,
  but wouldn't it be
  easier to just do a cold backup and open them
 using
  the
  COMPATIBLE parameter in the 8.1.6 environment?  Is
  there
  any downside to using export/import? (ie. will it
  affect snapshots,
  db links, etc...).
 
  I thought the whole point of the compatible
  parameter was that
  it let you open up an older database with no
  questions asked.
  Then you could run any of the upgrade .sql scripts
  at your leisure,
  yes?
 
  Best,
 
  Ed
 
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Ed
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051 
 FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 


  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be
 removed
  from).  You may
  also send the HELP command for other information
  (like subscribing).
 
 
 __
 Do You Yahoo!?
 Yahoo! GeoCities - quick and easy web site hosting,
 just $8.95/month.
 http://geocities.yahoo.com/ps/info1
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Deepak Thapliyal
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an

RE: ftp tools

2001-11-21 Thread Jamadagni, Rajendra


If you are using TOAD, there is one in there ...

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

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



*1

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

*1

RE: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Barbara Baker


Ed:
If you track down the 8i migration manual, here's a comparison chart that 
shows the benefits of export/import versus migration (using the u 
scripts).

It depends on your database configuration, but yes, the main benefit in 
using migration is speed.  If your database is relatively small, exp/imp 
should be no problem.  If it's large, the difference betwen exp/imp and 
migration will be significant.

HTH.

Barb


From: Ed [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Upgrade 8.0.5 to 8.1.6
Date: Wed, 21 Nov 2001 13:15:20 -0800

Yes, I agree 100%, but people here are concerned that upgrading will 
break
the database, and we have to QUICKLY move everything over to 8.1.6. (Long
story).  What I was really after in my original question was: why is the
upgrade script a better solution than just recreating the tablespaces in
8.1.6 and importing from an export of the old database?  Does it just save
time?  Is there a downside to using export/import this way?

Best!

Ed

-Original Message-
Thapliyal
Sent: Wednesday, November 21, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Ed,

the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out

Deepak

--- Ed [EMAIL PROTECTED] wrote:
  A DBA here is trying to upgrade several 8.0.5
  databases to 8.1.6
  by using export/import.  This will probably work,
  but wouldn't it be
  easier to just do a cold backup and open them using
  the
  COMPATIBLE parameter in the 8.1.6 environment?  Is
  there
  any downside to using export/import? (ie. will it
  affect snapshots,
  db links, etc...).
 
  I thought the whole point of the compatible
  parameter was that
  it let you open up an older database with no
  questions asked.
  Then you could run any of the upgrade .sql scripts
  at your leisure,
  yes?
 
  Best,
 
  Ed
 
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Ed
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 

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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
   INET: [EMAIL PROTECTED]

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

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

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

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


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

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

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

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

2001-11-21 Thread Bill Conner


At 02:10 PM 11/21/2001 -0800, you wrote:
not free, but ipswitch's ftp is nice and cheap ~$400.
very easy to admin.

http://www.ipswitch.com/

www.cuteftp.com   only $35


gene

  [EMAIL PROTECTED] 11/21/01 16:55 PM 
Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

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


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

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

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

2001-11-21 Thread Ed


Thanks all.

Ed


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

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

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

2001-11-21 Thread Jeremiah Wilton


Correct me if I am wrong, but you don't migrate from 8.0 to 8.1.  You
just start up on the new binaries and run u080005.sql or something.
The migration utility is for 7.x to 8.x.  Read the manual.
Re-creating the database, then exporting and importing will take much
longer than just running a couple scripts.

If it is reverting that you are worried about, take an online backup
before you upgrade.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 21 Nov 2001, Barbara Baker wrote:

 If you track down the 8i migration manual, here's a comparison chart that
 shows the benefits of export/import versus migration (using the u
 scripts).

 It depends on your database configuration, but yes, the main benefit in
 using migration is speed.  If your database is relatively small, exp/imp
 should be no problem.  If it's large, the difference betwen exp/imp and
 migration will be significant.

 From: Ed [EMAIL PROTECTED]
 
 Yes, I agree 100%, but people here are concerned that upgrading will
 break
 the database, and we have to QUICKLY move everything over to 8.1.6. (Long
 story).  What I was really after in my original question was: why is the
 upgrade script a better solution than just recreating the tablespaces in
 8.1.6 and importing from an export of the old database?  Does it just save
 time?  Is there a downside to using export/import this way?

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

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

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

Re: OT: X Win client

2001-11-21 Thread C.S.Venkata Subramanian


 Try xwin32 from starnet
--

On Wed, 21 Nov 2001 10:15:25  
 Jared Still wrote:

Yes, Xfree86.

Just do a search on google.  I use it to run Oracle
installs, so it works well enough.

Jared

On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
 Hi all!

 Is there any free (important: free) X client software for NT?

 Regards,
 Vladimir Barac


Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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



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

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

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

RE: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Barbara Baker


Ed:
If you choose to upgrade your database from 8.0.5 to 8.1.6, there's a 
potential difficulty you need to know about.

If you're not aware of the dictionary corruption problem, be sure you read 
the metalink alert (96117.1).  This has something to do with block checking 
enabled in 8.1.6   Essentially, you need to analyze all your system tables 
to insure no corruption has been introduced.

If you have any problem finding the info on metalink, take a look at the Tim 
Gorman's web site (www.evdbt.com).  He has some info about it under 
downloads.

Barb




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

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

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

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

2001-11-21 Thread Jared Still



Yes, Oracle actually calls it an upgrade.

I think the point everyone wanted to make though was
it's not a good idea to just start your database
with the 8.1 binaries.

Jared

On Wednesday 21 November 2001 16:40, Jeremiah Wilton wrote:
 Correct me if I am wrong, but you don't migrate from 8.0 to 8.1.  You
 just start up on the new binaries and run u080005.sql or something.
 The migration utility is for 7.x to 8.x.  Read the manual.
 Re-creating the database, then exporting and importing will take much
 longer than just running a couple scripts.

 If it is reverting that you are worried about, take an online backup
 before you upgrade.

 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton

 On Wed, 21 Nov 2001, Barbara Baker wrote:
  If you track down the 8i migration manual, here's a comparison chart that
  shows the benefits of export/import versus migration (using the u
  scripts).
 
  It depends on your database configuration, but yes, the main benefit in
  using migration is speed.  If your database is relatively small, exp/imp
  should be no problem.  If it's large, the difference betwen exp/imp and
  migration will be significant.
 
  From: Ed [EMAIL PROTECTED]
  
  Yes, I agree 100%, but people here are concerned that upgrading will
  break
  the database, and we have to QUICKLY move everything over to 8.1.6.
   (Long story).  What I was really after in my original question was: why
   is the upgrade script a better solution than just recreating the
   tablespaces in 8.1.6 and importing from an export of the old database? 
   Does it just save time?  Is there a downside to using export/import
   this way?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re[2]: Odd Listener.ora Stanza

2001-11-21 Thread Jonathan Gennick


Wednesday, November 21, 2001, 10:56:45 AM, you wrote:
DK Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75,
DK 85-86 in particular.

Yeah, but I don't have any experience with the GIOP
presentation. Like Srini pointed out earlier, it allows the
listener to handle the protocol used for CORBA connections.

Now I just have to ask. Is anyone here supporting CORBA
connections in a production environment?

Best regards,

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

-- 
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: TNS Listener service question

2001-11-21 Thread Jonathan Gennick


If I understand you correctly, you are shutting down a
listener on your NT box, and then, from your NT box, you are
connecting to a remote database using SQL*Plus. Am I
understanding you correctly?

You shouldn't need to have a listener running on your NT box
to connect to a remote database, so that fact that SQL*Plus
can connect doesn't surprise me. I don't understand why your
GUI tools wouldn't connect, though I may also be
misunderstanding your original note.

Best regards,

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

Wednesday, November 21, 2001, 10:05:20 AM, you wrote:
BPJ I noticed that if I leave the TNS Listener service stopped on my NT
BPJ workstation, I can't access anything using the GUI tools.

BPJ But my script that runs command line can successfully login to the remote
BPJ databases to verify that they are accessible.  It uses
BPJ c:\oracle\ora81\bin\sqlplus.exe.

BPJ Do the command-line utilities bypass the NT TNSListener service?

BPJ Just curious, I am leaving the service up now...

-- 
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: applying patch 2032040 to Oracle Purchasing

2001-11-21 Thread Molina, Gerardo


There is a good article in Select Magazine (IOUG) Q4 2001 on Oracle Apps
patching.  Worth checking out.
 
Gerardo

-Original Message-
Sent: Tuesday, November 20, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L



After applying the c.drv portion of the patch, 
I'm attempting to apply the d.drv portion of patch 
the patch above and adwork1 is failing applying the d.drv file. 

In the adwork1.log file I see, 
jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail 
-thin -user USERNAME/PASSSWORD@host:port:SID
/opt/oracle/testappl/admin/test/out/p01ldjva.jar 

followed by a ton of 
ORA-03115 unsupported network/data/type or representation 
and 
ORA-29509 incorrectly formed Java binary class definition 
errors. 

I suspect that the file 
/opt/oracle/testappl/admin/test/out/p01ldjva.jar 
was taken from new xmlparserv2.zip file that is present in 
the patch. 

Being the relative newcomer at this, my question is 
what do I do now?  It's already got part way through 
applying the d.drv file, which means (if i understand this 
correctly) that I cannot un-patch.  I have to recover from the 
backup.  What can I do to try to move this forward rather 
than recovering and starting over? 

 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
Doing linear scans over an associative array is like 
trying to club someone to death with a loaded Uzi. 
- Larry Wall (creator of Perl) 

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

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

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

2001-11-21 Thread Steven Lembark




-- Hallas John [EMAIL PROTECTED]

 Top Man Rich.

 Works well and a satisfied user for the first time in my career!!
 Nice bit of coding, especially the line formatting bit

 DCL is a nice language to work in I always found. Once you know what
 lexicals are available it is amazing what you can do with them.


 Much appreciated

Check the Big Grey Wall for the lexical func's in DCL
(f$foo). They are processed in the second -- lexical --
phase of DCL processing and give you access to most of
the guts of VMS.

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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


I knew I'd forget something :)  thanks Kirti!


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 And while making sure those tablespaces exist, I would also make sure
 that
 the user running the script has sufficient quota on those
 tablespaces.
 
 - Kirti 
 
  -Original Message-
  From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
  Sent:   Tuesday, November 20, 2001 3:16 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Index File Name
  
  yep, absolutely.
  
  so as long as that tablespace has been created, your script will
 run
  
  if I were you, I'd do a search in that script file for the word
  TABLESPACE and find every tablespace name that is used and make
 sure
  they exist before I ran the script
  
  --- Ken Janusz [EMAIL PROTECTED] wrote:
   Here is a typical piece of code from the DDL SQL script that
 creates
   an
   index.  It appears that the tablespace used for indexes is
   SOS2_TBLSPC.
   Correct?
   
   Ken
   
   
   CREATE INDEX FK_AR_ACCESSRIGHTID ON 
 ACCESS_RIGHT(ACCESS_RIGHT_ID) 
 TABLESPACE SOS2_TBLSPC PCTFREE 10  STORAGE(INITIAL 122880 NEXT
   106496
   PCTINCREASE 0 ) 
   
   
-Original Message-
   Sent: Tuesday, November 20, 2001 2:01 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  Re: Index File Name
   
   If you don't specify an index tablespace the index will occupy
 the
   same
   tablespace as the Table...
   It's probably best to have a tablespace for indexes and one for
 the
   tables
   If you create an index tablespace,  a good name might be
   'User_Indexes' ?
   
   
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Tuesday, November 20, 2001 7:25 PM
   
   
   I am creating a database from a DDL SQL script.  I have created
 the
   primary
   and temp tablespaces because their names were referenced in the
 code.
   However, there is no name reference anywhere that I can find for
 the
   index
   tablespace.  Do I need to create one, or will Oracle take care of
   that for
   me?  If I have to create on, what name do I give it, or does it
   matter?
   
   Thanks,
   Ken Janusz, CPIM
   Database Conversion Lead
   Sufficient System, Inc.
   Minneapolis, MN
   
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Ken Janusz
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
   San Diego, California-- Public Internet access / Mailing
   Lists
  
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You
 may
   also send the HELP command for other information (like
 subscribing).
   
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: Alistair Orchard
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
   San Diego, California-- Public Internet access / Mailing
   Lists
  
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (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: Ken Janusz
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
   San Diego, California-- Public Internet access / Mailing
   Lists
  
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You
 may
   also send the HELP command for other information (like
 subscribing).
  
  
  __
  Do You Yahoo!?
  Yahoo! GeoCities - quick and easy web site hosting, just
 $8.95/month.
  http://geocities.yahoo.com/ps/info1
  -- 
  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]

OT: X Win client

2001-11-21 Thread Vladimir Barac - posao





Hi all!

Is there any free (important: free) X client 
software for NT?

Regards,
Vladimir 
Barac

RE: Index File Name

2001-11-21 Thread Mark Leith


And just to add to that - make sure that the user has the appropriate
privileges on the system, such as CREATE TABLE / INDEX, or the role RESOURCE
or whatever.. :)

Just to nitpick :)

-Original Message-
Carmichael
Sent: 21 November 2001 09:35
To: Multiple recipients of list ORACLE-L


I knew I'd forget something :)  thanks Kirti!


--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 And while making sure those tablespaces exist, I would also make sure
 that
 the user running the script has sufficient quota on those
 tablespaces.

 - Kirti

  -Original Message-
  From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
  Sent:   Tuesday, November 20, 2001 3:16 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Index File Name
 
  yep, absolutely.
 
  so as long as that tablespace has been created, your script will
 run
 
  if I were you, I'd do a search in that script file for the word
  TABLESPACE and find every tablespace name that is used and make
 sure
  they exist before I ran the script
 
  --- Ken Janusz [EMAIL PROTECTED] wrote:
   Here is a typical piece of code from the DDL SQL script that
 creates
   an
   index.  It appears that the tablespace used for indexes is
   SOS2_TBLSPC.
   Correct?
  
   Ken
  
  
   CREATE INDEX FK_AR_ACCESSRIGHTID ON
 ACCESS_RIGHT(ACCESS_RIGHT_ID)
 TABLESPACE SOS2_TBLSPC PCTFREE 10  STORAGE(INITIAL 122880 NEXT
   106496
   PCTINCREASE 0 )
  
  
-Original Message-
   Sent: Tuesday, November 20, 2001 2:01 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  Re: Index File Name
  
   If you don't specify an index tablespace the index will occupy
 the
   same
   tablespace as the Table...
   It's probably best to have a tablespace for indexes and one for
 the
   tables
   If you create an index tablespace,  a good name might be
   'User_Indexes' ?
  
  
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Tuesday, November 20, 2001 7:25 PM
  
  
   I am creating a database from a DDL SQL script.  I have created
 the
   primary
   and temp tablespaces because their names were referenced in the
 code.
   However, there is no name reference anywhere that I can find for
 the
   index
   tablespace.  Do I need to create one, or will Oracle take care of
   that for
   me?  If I have to create on, what name do I give it, or does it
   matter?
  
   Thanks,
   Ken Janusz, CPIM
   Database Conversion Lead
   Sufficient System, Inc.
   Minneapolis, MN
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Ken Janusz
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
   San Diego, California-- Public Internet access / Mailing
   Lists
  
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You
 may
   also send the HELP command for other information (like
 subscribing).
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Alistair Orchard
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
   San Diego, California-- Public Internet access / Mailing
   Lists
  
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (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: Ken Janusz
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
   San Diego, California-- Public Internet access / Mailing
   Lists
  
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You
 may
   also send the HELP command for other information (like
 subscribing).
 
 
  __
  Do You Yahoo!?
  Yahoo! GeoCities - quick and easy web site hosting, just
 $8.95/month.
  http://geocities.yahoo.com/ps/info1
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858)

Re: PL/SQL package to emulate MySQL functions?

2001-11-21 Thread Tim Bunce


On Mon, Nov 19, 2001 at 11:50:20AM -0800, [EMAIL PROTECTED] wrote:
 I do know that when I used Migration Workbench to migrate an Access database
 to Oracle, it created Oracle PL/SQL functions to emulate Access builtins
 that Oracle doesn't duplicate - (ANDN, CCUR, CDBL, CINT, DATEADD, EQN, ERIC,
 LEFT, RIGHT, TRIM, etc.)
 
 Maybe the MySql version of Migration Workbench would do the same thing.

The MySql Migration Workbench docs that I've seen didn't mention that
so I assumed it didn't (since it's obviously worth mentioning if it does :)
I'll download them and investigate some more. Thanks.

Tim.

 Dave
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: Friday, November 16, 2001 12:05 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: PL/SQL package to emulate MySQL functions?
  
  
  
  Tim,
  
  Have you looked at the MySql migration workbench?
  
  I don't know if it has what you're looking for, but you never know.
  
  http://otn.oracle.com/software/tech/migration/workbench/htdocs
  /utilsoft.html
  
  Jared
  
  
  


  Tim Bunce 

  Tim.Bunce@pob   To: Multiple 
  recipients of list ORACLE-L [EMAIL PROTECTED]
  ox.com  cc:  

  Sent by: Subject: PL/SQL 
  package to emulate MySQL functions?
  [EMAIL PROTECTED]

  om





  11/16/01 05:35

  AM

  Please respond

  to ORACLE-L   





  
  
  
  
  Does anyone know of a PL/SQL package that defines functions to
  emulate MySQL builtins?  That is, MySQL functions like:
  
 substring_index(...)
 unix_timestamp(...)
 find_in_set(...)
  
  If not I guess I may be writing one myself...
  
  Tim.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Tim Bunce
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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

Re: Index File Name

2001-11-21 Thread Stephane Faroult


Mark Leith wrote:
 
 And just to add to that - make sure that the user has the appropriate
 privileges on the system, such as CREATE TABLE / INDEX, or the role RESOURCE
 or whatever.. :)
 
 Just to nitpick :)
 

NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
cannot grant it to a role, usually - but Oracle 5 compatibility has its
reasons ...). Not that I am paranoid, but the idea of users being able
to create their tables in SYSTEM makes me nervous.
 I know, someone should tell to the Oracle folks who prepare demo
scripts ...
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools  Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Reliable alerting system that is not so costly??

2001-11-21 Thread Kumanan Balasundaram


Hi  there,

Any of you using or have come across a reliable alert system that can also
escalate 
to different persons based on criteria such as how important that system is?

We are looking to invest in such a software.

Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409

 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road,
 London W6 9EJ
 Registered in England No 3430894 VAT number - GB 701 8915 43
 
 The information transmitted is intended only for the person or entity to
 which it is addressed and may contain confidential and/or privileged
 material.  Any review, retransmission, dissemination or other use of, or
 taking of any action in reliance upon, this information by persons or
 entities other than the intended recipient is prohibited.   If you
 received  this in error, please contact the sender and delete the material
 from any computer
 


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

This footnote also confirms that this email message has been swept by
MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses.

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

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

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

RE: Metalink gone to sleep ?????


OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.  I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 -- no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 20, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Metalink gone to sleep ?

I can't get in.




Farnsworth,

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

@Ashleyfurnitcc:

ure.com Subject: RE: Metalink
gone to sleep ? 
Sent by: root





11/20/2001

10:00 AM

Please

respond to

ORACLE-L









I just connected with no problems.

-Original Message-
Sent: Tuesday, November 20, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can't log in to Metalink today either...am getting the opening
page but
gives the
'Page temporarily unavailable' after that..anybody else sharing
the
same
problem 

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018




___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented
are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have
received
this
email in error and that any use, dissemination, forwarding,
printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.

___

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

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

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

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

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


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

Re: OT: X Win client

2001-11-21 Thread Jan Pruner


X client? Don't know, but there are some free X servers for NT on the I-net. 
:-))

But this is Oracle maillist.
JP


On Wed 21. November 2001 10:40, you wrote:
 Hi all!

 Is there any free (important: free) X client software for NT?

 Regards,
 Vladimir Barac


Content-Type: text/html; charset=iso-8859-1; name=Pøíloha: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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

RE: Metalink gone to sleep ?????

2001-11-21 Thread JDuhart


To all:

I have IE 6.0 and NT Workstation 4.0 SP6 on my PC. My metalink entry is bookmarked. I click it, the log in screen comes up immediately and I'm in!

I did a search on rollback and it returned the result very quickly.I also tried the attempt with Netscape Navigator 4.0.8. I tried: 

http://www.oracle.com/support/

clicked the metalink link

logged in with no problem.

ran the same query, and got the same fast results.


Location of attempt: Richmond, Virginia, USA.

Hope this information is of help to someone

John






Boivin, Patrice J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/21/01 07:10 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Metalink gone to sleep ?

OK, Let's do a poll. Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in. I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 -- no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, November 20, 2001 3:35 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Metalink gone to sleep ?

 I can't get in.


 

   Farnsworth,

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

   @Ashleyfurnitcc:

   ure.com   Subject:   RE: Metalink
gone to sleep ?   
   Sent by: root

 

 

   11/20/2001

   10:00 AM

   Please

   respond to

   ORACLE-L

 

 





 I just connected with no problems.

 -Original Message-
 Sent: Tuesday, November 20, 2001 8:45 AM
 To: Multiple recipients of list ORACLE-L


 Can't log in to Metalink today either...am getting the opening
page but
 gives the
 'Page temporarily unavailable' after that..anybody else sharing
the
 same
 problem 

 Samir Sarkar
 Oracle DBA - Lennon Team
 SchlumbergerSema
 Email : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 Phone : +44 (0) 115 - 95 76217
 EPABX : +44 (0) 115 - 957 6418 Ext. 76217
 Fax : +44 (0) 115 - 957 6018



 
___
 This email is confidential and intended solely for the use of the
 individual to whom it is addressed. Any views or opinions presented
are
 solely those of the author and do not necessarily represent those of
 SchlumbergerSema.
 If you are not the intended recipient, be advised that you have
received
 this
 email in error and that any use, dissemination, forwarding,
printing, or
 copying of this email is strictly prohibited.

 If you have received this email in error please notify the
SchlumbergerSema
 Helpdesk by telephone on +44 (0) 121 627 5600.
 
___

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

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

 Fat City Network Services  -- (858) 538-5051 FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')

Re: Reliable alerting system that is not so costly??

2001-11-21 Thread Steve . Parker



Have a look at Categoric Xalerts.

It is a general purpose Alerting system, not just for DBA and SYSADMs.

Their new Java based system is just out.

www.categoric.com

Steve Parker
Technical Consultant
LIS

 --
Logistics  Internet Systems Ltd.
E Mail: [EMAIL PROTECTED]
 --



   
  
Kumanan Balasundaram   
  
kumanan.balasundara   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
[EMAIL PROTECTED] cc: 
  
Sent by:   Subject: Reliable alerting system 
that is not so costly?? 
[EMAIL PROTECTED]   
  
   
  
   
  
21/11/2001 11:50   
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Hi  there,

Any of you using or have come across a reliable alert system that can also
escalate
to different persons based on criteria such as how important that system
is?

We are looking to invest in such a software.

Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409

 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge
Road,
 London W6 9EJ
 Registered in England No 3430894 VAT number - GB 701 8915 43

 The information transmitted is intended only for the person or entity to
 which it is addressed and may contain confidential and/or privileged
 material.  Any review, retransmission, dissemination or other use of, or
 taking of any action in reliance upon, this information by persons or
 entities other than the intended recipient is prohibited.   If you
 received  this in error, please contact the sender and delete the
material
 from any computer



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

This footnote also confirms that this email message has been swept by
MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer
viruses.

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

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

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

MetaLink Access: Solved (for me at least)


OK, I think I figured it out - had to clear the Internet Cache for IE.

After I did that, I could access MetaLink.

Don't know why though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

tablespace

2001-11-21 Thread Mouka Otakar


 Hello
I need a help with one problem. In the Oracle version 8.1.7 I´ve deleted
a tablespace in the Linux, but before this I did´t use a function 
Drop.
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop tablespace and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

RE: Metalink gone to sleep ?????

2001-11-21 Thread G . Plivna



NT 4.0 SP 6 with both IE 5.5 SP 1 and Netscape 4.73

Working...

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



   
   
Boivin, Patrice   
   
J  To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
[EMAIL PROTECTED]   cc:
   
mpo.gc.ca  Subject: RE: Metalink gone to sleep 
? 
Sent by:   
   
[EMAIL PROTECTED]   
   
   
   
   
   
2001.11.21 14:10   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.  I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 -- no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN
Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

   -Original Message-
   From:  [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
   Sent:  Tuesday, November 20, 2001 3:35 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:   RE: Metalink gone to sleep ?

   I can't get in.




   Farnsworth,

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

   @Ashleyfurnitcc:

   ure.com Subject: RE:
Metalink
gone to sleep ?
   Sent by: root





   11/20/2001

   10:00 AM

   Please

   respond to

   ORACLE-L









   I just connected with no problems.

   -Original Message-
   Sent: Tuesday, November 20, 2001 8:45 AM
   To: Multiple recipients of list ORACLE-L


   Can't log in to Metalink today either...am getting the
opening
page but
   gives the
   'Page temporarily unavailable' after that..anybody else
sharing
the
   same
   problem 

   Samir Sarkar
   Oracle DBA - Lennon Team
   SchlumbergerSema
   Email :  [EMAIL PROTECTED]
   [EMAIL PROTECTED]
   Phone : +44 (0) 115 - 95 76217
   EPABX : +44 (0) 115 - 957 6418 Ext. 76217
   Fax : +44 (0) 115 - 957 6018




___
   This email is confidential and intended solely for the use of
the
   individual to whom it is addressed. Any views or opinions
presented
are
   solely those of the author and do not necessarily represent
those of
   SchlumbergerSema.
   If you are not the intended recipient, be advised that you have
received
   this
   email in error and that any use, dissemination, forwarding,
printing, or
   copying of this email is strictly prohibited.

   If you have received this email in error please notify the
SchlumbergerSema
   Helpdesk by telephone on +44 (0) 121 627 5600.

___

   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Adams, Matthew (GEA, 088130)

Title: RE: Upgrade 8.0.5 to 8.1.6





Ed,


 There's more to it than just setting the 
COMPATIBLE parameter. The basic steps 
are


1) install new 8.1.6 executables
2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
 making whatever modifications are necessary due to 
 new or obsoleted parameters
3) startup database
4) run u0800050.sql as sys. This modifies internal Oracle objects
to new forms needed by 8.1.6 software. Once this is done, NEVER
open the database using the old version, as it can corrupt the database.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl) 


 -Original Message-
 From: Ed [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 20, 2001 6:00 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Upgrade 8.0.5 to 8.1.6
 
 
 A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
 by using export/import. This will probably work, but wouldn't it be
 easier to just do a cold backup and open them using the
 COMPATIBLE parameter in the 8.1.6 environment? Is there
 any downside to using export/import? (ie. will it affect snapshots,
 db links, etc...). 
 
 I thought the whole point of the compatible parameter was that
 it let you open up an older database with no questions asked.
 Then you could run any of the upgrade .sql scripts at your leisure,
 yes?
 
 Best,
 
 Ed
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ed
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
 San Diego, California -- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from). You may
 also send the HELP command for other information (like subscribing).

RE: Metalink gone to sleep ?????

2001-11-21 Thread Valuthur, Srikanth


I tried to login thru metalink.oracle.com and logged in immediately.  I was
able to query and results were faster.  I tried looking for RMan and it came
up immediately.  


Srikanth,
Saint louis, MO

-Original Message-
Sent: Wednesday, November 21, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L


Thanks John.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Metalink gone to sleep ?


To all: 

I have IE 6.0 and NT Workstation 4.0 SP6 on my PC.  My metalink
entry is bookmarked.  I click it, the log in screen comes up immediately and
I'm in! 

I did a search on rollback and it returned the result very
quickly.I also tried the attempt with Netscape Navigator 4.0.8.  I
tried:   

http://www.oracle.com/support/ 

clicked the metalink link 

logged in with no problem. 

ran the same query, and got the same fast results. 


Location of attempt:  Richmond, Virginia, USA. 

Hope this information is of help to someone 

John 



Boivin, Patrice J [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 

11/21/01 07:10 AM 
Please respond to ORACLE-L 

To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] 
cc: 
Subject:RE: Metalink gone to sleep ?


OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.
I am
going to try from one of the servers (IE 5.0) to see what the result
is.

[...]

IE 5.0 SP2 -- no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support
IE6.

Late last week I could access MetaLink, but I don't know if the LAN
Services
people here suddenly decided to push IE 6.0 on my workstation
without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001
3:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Metalink gone to sleep
?

I can't get in.




Farnsworth,

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

@Ashleyfurnitcc:

ure.com Subject:
RE: Metalink
gone to sleep ? 
Sent by: root





11/20/2001

10:00 AM

Please

respond to

ORACLE-L









I just connected with no problems.

-Original Message-
Sent: Tuesday, November 20, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can't log in to Metalink today either...am
getting the opening
page but
gives the
'Page temporarily unavailable' after
that..anybody else sharing
the
same
problem 

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018

RE: applying patch 2032040 to Oracle Purchasing

2001-11-21 Thread Adams, Matthew (GEA, 088130)

Title: RE: applying patch 2032040 to Oracle Purchasing





I looked in metalink and maybe I'm just blind, 
but I don't find a 'Maintaining Oracle 
Applications' manual.


URLs would be greatly apprecieated.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl) 


 -Original Message-
 From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 20, 2001 7:45 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: applying patch 2032040 to Oracle Purchasing
 
 
 Matt,
 
 I think you should get to read the 'Maintaining Oracle 
 Applications' manual
 - all the ad utilities are described therein. My 
 understanding is that the
 install progress is recorded in the FND_INSTALL table and a 
 restart will
 look up this and decipher what else needs to be done. As far 
 as your error
 goes, the solution is to open an iTar and sit back until you 
 get called...
 As I said before, Patching is the bane of an Apps DBA!
 
 John Kanagaraj
 Oracle Applications DBA
 DBSoft Inc
 (W): 408-970-7002
 
 Kill your killer-commute! Listen to great commercial-free 
 christian music
 24x7 (details at www.klove.com)
 
 ** The opinions and statements above are entirely my own and not
 those of my employer or clients **
 
 
 -Original Message-
 Sent: Tuesday, November 20, 2001 6:00 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 After applying the c.drv portion of the patch, 
 I'm attempting to apply the d.drv portion of patch 
 the patch above and adwork1 is failing applying the d.drv file. 
 
 In the adwork1.log file I see, 
 jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail 
 -thin -user USERNAME/PASSSWORD@host:port:SID
 /opt/oracle/testappl/admin/test/out/p01ldjva.jar 
 
 followed by a ton of 
 ORA-03115 unsupported network/data/type or representation 
 and 
 ORA-29509 incorrectly formed Java binary class definition 
 errors. 
 
 I suspect that the file 
 /opt/oracle/testappl/admin/test/out/p01ldjva.jar 
 was taken from new xmlparserv2.zip file that is present in 
 the patch. 
 
 Being the relative newcomer at this, my question is 
 what do I do now? It's already got part way through 
 applying the d.drv file, which means (if i understand this 
 correctly) that I cannot un-patch. I have to recover from the 
 backup. What can I do to try to move this forward rather 
 than recovering and starting over? 
 
  
 Matt Adams - GE Appliances - [EMAIL PROTECTED] 
 Doing linear scans over an associative array is like 
 trying to club someone to death with a loaded Uzi. 
 - Larry Wall (creator of Perl) 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: John Kanagaraj
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
 San Diego, California -- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from). You may
 also send the HELP command for other information (like subscribing).

Re: Metalink gone to sleep ?????

2001-11-21 Thread Thater, William


[EMAIL PROTECTED] wrote:

NT 4.0 SP 6 with both IE 5.5 SP 1 and Netscape 4.73

works fine with IE6 and Netscape 6.2 on Win2K.


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

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Study = NoFail NoStudy = Fail .. Study + NoStudy = Fail + No Fail Study(1 
+ No) = Fail(1 + No) ergo, Study = Fail 




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

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

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

RE: Fixing a DB

2001-11-21 Thread Koniszewski, Mike

Why not just create the tablespace and move the indexes? alter index rebuild
with new storage parameters.

 -Original Message-
 From: Ken Janusz [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, November 21, 2001 8:26 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Fixing a DB

 We have a DB that is currently in more-or-less development mode for a
 state
 government client.  The DB has been created (11,300 lines of SQL*Plus
 code)
 with the tables and indexes stored in the permanent tablespace
 (SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
 currently holds test data.  I think the process to correct this would be:

 1. Determine the size, etc. of the INDEX tablespace, write the script and
 then run it to create the tablespace.

 2. Go through the DDL SQL script for OKSOS (state gov. office name
 abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
 tablespace name.

 3. Then run the DDL SQL script to create the new DB.

 4. Then do and Export of the data from the old DB and Import it into the
 new
 DB.

 5. Then I think I have to regenerate your indexes.  I'm not clear on this
 point. Will the Export/Import process may take care of this?

 Is there anything I have missed?  I'm sure there is.

 Thanks,

 Ken Janusz, CPIM 
 Database Conversion Lead 
 Sufficient System, Inc.  
 Minneapolis, MN

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

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

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

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

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

RE: Metalink gone to sleep ?????

2001-11-21 Thread SARKAR, Samir


This is strange..I could not log into Metalink using the 
link metalink.oracle.com.
But I could log in using the link oracle.com/support/metalink.

Whats happening here, guysn and gals ??

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 21 November 2001 12:10
To: Multiple recipients of list ORACLE-L


OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.  I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 -- no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 20, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Metalink gone to sleep ?

I can't get in.




Farnsworth,

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

@Ashleyfurnitcc:

ure.com Subject: RE: Metalink
gone to sleep ? 
Sent by: root





11/20/2001

10:00 AM

Please

respond to

ORACLE-L









I just connected with no problems.

-Original Message-
Sent: Tuesday, November 20, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can't log in to Metalink today either...am getting the opening
page but
gives the
'Page temporarily unavailable' after that..anybody else sharing
the
same
problem 

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018




___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented
are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have
received
this
email in error and that any use, dissemination, forwarding,
printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.

___

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

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

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

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

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

RE: MetaLink Access: Solved (for me at least)

2001-11-21 Thread Jesse, Rich


There's an easier fix:

http://www.opera.com

:)

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

-Original Message-
Sent: Wednesday, November 21, 2001 06:25
To: Multiple recipients of list ORACLE-L


OK, I think I figured it out - had to clear the Internet Cache for IE.

After I did that, I could access MetaLink.

Don't know why though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Index File Name

2001-11-21 Thread Koivu, Lisa

Title: RE: Index File Name





Alistair I think you'll find that packages don't get stored in a tablespace per se... like you are describing below. They are stored in the data dictionary. So you don't need to allocate specific storage for them (other than the system tablespace) and for the most part this is negligible. 

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117




-Original Message-
From: Alistair Orchard [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 4:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Fw: Index File Name


Sorry for the assumption... :o)
I do find it best to specify the tablespace of the index to be different than the table, personally I use have a method of leaving:

DB Object code i.e. packages in the users default tablespace, Tables in one tablespace (i.e. Users_Tables) and indexes in another (User_indexes) over several disks to reduce disk contention. Schemas will require a Temporary Tablespace and you of course will need the rollback tablespace as a non system tablespace cannot use the system rollback... a few public rollback segments, named in the init(SID).ora so they start up automatically with the instance

etc etc.
 
 


- Original Message - 
From: Koivu, Lisa mailto:[EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 20, 2001 8:20 PM
Subject: RE: Index File Name



Alistair, 


The  index will be created in the default tablespace of the user, not in the tablespace of the table.  Try it and check the results.  

If you create the index in the same sql statement as the table (like the primary key) then yes it may end up in the same ts as the table.

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117 



-Original Message-
From:   Alistair Orchard [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 20, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: Index File Name 


If you don't specify an index tablespace the index will occupy the same
tablespace as the Table...
It's probably best to have a tablespace for indexes and one for the tables
If you create an index tablespace,  a good name might be 'User_Indexes' ? 



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 7:25 PM 



I am creating a database from a DDL SQL script.  I have created the primary
and temp tablespaces because their names were referenced in the code.
However, there is no name reference anywhere that I can find for the index
tablespace.  Do I need to create one, or will Oracle take care of that for
me?  If I have to create on, what name do I give it, or does it matter? 


Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN 


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


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

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


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


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

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



Ken,
I don't think you will need steps 2 thru 5. After step 1, just write sql
that will spool out alter index blah rebuild tablespace new_tablspace
 run the resulting sql.
Will that work ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc




Ken Janusz [EMAIL PROTECTED]@fatcity.com on 11/21/2001 08:25:34 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



We have a DB that is currently in more-or-less development mode for a state
government client.  The DB has been created (11,300 lines of SQL*Plus code)
with the tables and indexes stored in the permanent tablespace
(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
currently holds test data.  I think the process to correct this would be:

1. Determine the size, etc. of the INDEX tablespace, write the script and
then run it to create the tablespace.

2. Go through the DDL SQL script for OKSOS (state gov. office name
abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
tablespace name.

3. Then run the DDL SQL script to create the new DB.

4. Then do and Export of the data from the old DB and Import it into the
new
DB.

5. Then I think I have to regenerate your indexes.  I'm not clear on this
point. Will the Export/Import process may take care of this?

Is there anything I have missed?  I'm sure there is.

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN


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

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

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



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

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

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

RE: applying patch 2032040 to Oracle Purchasing



Try clicking Technical Libraries, then Applications Install  Upgrade
under ERP Applications, then click Documentation link and viola !
HTH
Srini Chavali
Oracle DBA
Cummins Inc




Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]@fatcity.com on
11/21/2001 08:30:24 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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





I looked in metalink and maybe I'm just blind,
but I don't find a 'Maintaining Oracle
Applications' manual.

URLs would be greatly apprecieated.


Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
    - Larry Wall (creator of Perl)

 -Original Message-
 From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 20, 2001 7:45 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: applying patch 2032040 to Oracle Purchasing


 Matt,

 I think you should get to read the 'Maintaining Oracle
 Applications' manual
 - all the ad utilities are described therein. My
 understanding is that the
 install progress is recorded in the FND_INSTALL table and a
 restart will
 look up this and decipher what else needs to be done. As far
 as your error
 goes, the solution is to open an iTar and sit back until you
 get called...
 As I said before, Patching is the bane of an Apps DBA!

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

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

 ** The opinions and statements above are entirely my own and not
 those of my employer or clients **


 -Original Message-
 Sent: Tuesday, November 20, 2001 6:00 AM
 To: Multiple recipients of list ORACLE-L



 After applying the c.drv portion of the patch,
 I'm attempting to apply the d.drv portion of patch
 the patch above and adwork1 is failing applying the d.drv file.

 In the adwork1.log file I see,
 jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail
 -thin -user USERNAME/PASSSWORD@host:port:SID
 /opt/oracle/testappl/admin/test/out/p01ldjva.jar

 followed by a ton of
 ORA-03115 unsupported network/data/type or representation
 and
 ORA-29509 incorrectly formed Java binary class definition
 errors.

 I suspect that the file
 /opt/oracle/testappl/admin/test/out/p01ldjva.jar
 was taken from new xmlparserv2.zip file that is present in
 the patch.

 Being the relative newcomer at this, my question is
 what do I do now?  It's already got part way through
 applying the d.drv file, which means (if i understand this
 correctly) that I cannot un-patch.  I have to recover from the
 backup.  What can I do to try to move this forward rather
 than recovering and starting over?

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Doing linear scans over an associative array is like
 trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)

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

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





--
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: Backup strategy

2001-11-21 Thread Ron Rogers


Bing,
 Please explain your reasoning for backing up the archivelogs when you backup the 
readonly tablespaces. One reason you change a tablespace to read only is to reduce the 
backup needed. After a tablespace is in read only mode no changes are made to the data 
and you only need to back it up once and store the tape. If restoral is needed du to a 
disk failure then the backed up read only tablespace can be restored successfully. If 
you change the tablespace to read write at a future time then you need to perform a 
backup of the tablespace to reflect the change that is noted in the controlfile.
If you backup controlfile to trace with a tablespace in read only and then with the 
tablespace in read write you will see the differences that the controlfile tracks.
ROR mª¿ªm

 [EMAIL PROTECTED] 11/20/01 02:25PM 
When you backup the read-only tablespace, you must backup the archive logs
(if any) as well.



-Original Message-
Sent: Tuesday, November 20, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Ya but you don't normally backup a read-only tablespace.  The
whole reason I make them read-only is to ensure that I finish
the backup this century.  

-Original Message-
Sent: Tuesday, November 20, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


My hot backup is to put one tablespace in backup mode one at a time and copy
that data file to disk and alter it back online.  No problem

Bing


-Original Message-
Sent: Tuesday, November 20, 2001 10:28 AM
To: Multiple recipients of list ORACLE-L


My fault, I should have said copy.  Climbing night last night so I am 
dead tired.

Thanks for the input.

-Original Message-
Sent: Tuesday, November 20, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L


Kimberly,
 You can change a tablespace to read only with no problems and you should
take a backup to capture the change. Your last paragraph stated you wanted
to move the datafile to the disk that the tape backup picks
That will cause you problems if you move the datafile. You should copy the
datafile because the Oracle knows that it is located at disk-1 not disk-2.
Your users can still select from the tablespace as usual and if I remember
correctly they can truncate if they have the priviledge but not delete from.
I use the same method every 6 months. Archive older data to a read only
tablespace that contains my archive tables. 
Remember, all of the tablespaces in the datafile have to be read only.
ROR mª¿ªm

 [EMAIL PROTECTED] 11/20/01 11:40AM 
Just throwing something out cause I am not sure if I am thinking correctly.
I have a database that is not using partitioning so we split each month out
into seperate tables/indexes by month and store them in their own
tablespaces.  These are kinda big so we occasionally put a tablespace into
read-only mode, shutdown the database, perform a cold backup right to tape.


Problem is, we are putting this database into ServiceGuard.  Its kind of a
big pain in the butt to shutdown a database that is running in ServiceGuard
yet still have the disks available.  So I will now have to start handling
this will the hot backup.  NOTE: not using RMAN and really don't want to.
Its not that I don't trust it, just not worth it in this environment.  

I am thinking that everything will be ok if I put the tablespace into
read-only, move the datafile to the disk that the tape backup picks up
during the OS backup along with a backup control file.  I should then be
able to recover this with no issues.  

Sound logical?


Kimberly Smith
GMD Fujitsu
Database Administrator
(503) 669-6050

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

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

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

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

Re: Fixing a DB

2001-11-21 Thread Sunny Verghese


Sorry forgot the command in my earlier email

To recap, here are the steps

1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
  alter index index_owner.index_name rebuild online tablespace 
new_tablespace;


From: Ken Janusz [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Fixing a DB
Date: Wed, 21 Nov 2001 05:25:34 -0800

We have a DB that is currently in more-or-less development mode for a state
government client.  The DB has been created (11,300 lines of SQL*Plus code)
with the tables and indexes stored in the permanent tablespace
(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
currently holds test data.  I think the process to correct this would be:

1. Determine the size, etc. of the INDEX tablespace, write the script and
then run it to create the tablespace.

2. Go through the DDL SQL script for OKSOS (state gov. office name
abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
tablespace name.

3. Then run the DDL SQL script to create the new DB.

4. Then do and Export of the data from the old DB and Import it into the 
new
DB.

5. Then I think I have to regenerate your indexes.  I'm not clear on this
point. Will the Export/Import process may take care of this?

Is there anything I have missed?  I'm sure there is.

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN


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

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

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


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

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

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

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

2001-11-21 Thread Mr. Clark


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the compatible parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

 Ed,

   There's more to it than just setting the
 COMPATIBLE parameter.  The basic steps
 are

 1) install new 8.1.6 executables
 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
   making whatever modifications are necessary due to
   new or obsoleted parameters
 3) startup database
 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
 to new forms needed by 8.1.6 software.  Once this is done, NEVER
 open the database using the old version, as it can corrupt the database.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Doing linear scans over an associative array is like
 trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)

  -Original Message-
  From: Ed [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, November 20, 2001 6:00 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Upgrade 8.0.5 to 8.1.6
 
 
  A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
  by using export/import.  This will probably work, but wouldn't it be
  easier to just do a cold backup and open them using the
  COMPATIBLE parameter in the 8.1.6 environment?  Is there
  any downside to using export/import? (ie. will it affect snapshots,
  db links, etc...).
 
  I thought the whole point of the compatible parameter was that
  it let you open up an older database with no questions asked.
  Then you could run any of the upgrade .sql scripts at your leisure,
  yes?
 
  Best,
 
  Ed
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Ed
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Mr. Clark
  INET: [EMAIL PROTECTED]

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

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

2001-11-21 Thread HAWKINS, JAMES W [IT/1000]


Sepi,

Just a guess - are all three instances listed in your /etc/oratab file?  I'm
pretty sure OEM looks at that to determine what instances the Agent should
monitor.  I could be wrong on this though - it's been a while since I've
looked at OEM.

JIm

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

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

[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, November 20, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a problem with Enterprise Manager.

I am trying to refresh a node in order to get information of all instances 
on that machine. I am able to see two of three instances. Why I cannot see 
all of them. Setting up the preferences are ok, I have tested all user-id's 
and passwords.

TIA,

Sepi



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

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

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

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

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

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

RE: Metalink gone to sleep ?????

2001-11-21 Thread Richard Ji


I have no problem accessing metalink in NYC.  Could this be a local DNS, network 
issues to certain locations?

 [EMAIL PROTECTED] 11/21/01 08:35AM 
This is strange..I could not log into Metalink using the 
link metalink.oracle.com.
But I could log in using the link oracle.com/support/metalink.

Whats happening here, guysn and gals ??

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED] 
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 21 November 2001 12:10
To: Multiple recipients of list ORACLE-L


OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.  I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 -- no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
Sent:   Tuesday, November 20, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Metalink gone to sleep ?

I can't get in.




Farnsworth,

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

@Ashleyfurnitcc:

ure.com Subject: RE: Metalink
gone to sleep ? 
Sent by: root





11/20/2001

10:00 AM

Please

respond to

ORACLE-L









I just connected with no problems.

-Original Message-
Sent: Tuesday, November 20, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can't log in to Metalink today either...am getting the opening
page but
gives the
'Page temporarily unavailable' after that..anybody else sharing
the
same
problem 

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED] 
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018




___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented
are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have
received
this
email in error and that any use, dissemination, forwarding,
printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.

___

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY,

RE: MetaLink Access: Solved (for me at least)


LOL!

*yes* !!

-Original Message-
Sent: Wednesday, November 21, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L


There's an easier fix:

http://www.opera.com

:)

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

-Original Message-
Sent: Wednesday, November 21, 2001 06:25
To: Multiple recipients of list ORACLE-L


OK, I think I figured it out - had to clear the Internet Cache for IE.

After I did that, I could access MetaLink.

Don't know why though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

TNS Listener service question


I noticed that if I leave the TNS Listener service stopped on my NT
workstation, I can't access anything using the GUI tools.

But my script that runs command line can successfully login to the remote
databases to verify that they are accessible.  It uses
c:\oracle\ora81\bin\sqlplus.exe.

Do the command-line utilities bypass the NT TNSListener service?

Just curious, I am leaving the service up now...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

RE: Index File Name

2001-11-21 Thread Mark Leith


Yeah but for a tightly controlled schema *owner* - what's the problem?
Wouldn't you *want* to have unlimited tablespace for the schema owner -
which the users *should not* have access to anyway?

(no this is not rhetorical - I have no production experience)

Thanks

Mark

-Original Message-
Faroult
Sent: 21 November 2001 11:40
To: Multiple recipients of list ORACLE-L


Mark Leith wrote:

 And just to add to that - make sure that the user has the appropriate
 privileges on the system, such as CREATE TABLE / INDEX, or the role
RESOURCE
 or whatever.. :)

 Just to nitpick :)


NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
cannot grant it to a role, usually - but Oracle 5 compatibility has its
reasons ...). Not that I am paranoid, but the idea of users being able
to create their tables in SYSTEM makes me nervous.
 I know, someone should tell to the Oracle folks who prepare demo
scripts ...
--
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269
Fax:+44  (0) 7050-696-449
Performance Tools  Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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


The only thing I don't like about Opera is the ads.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Jesse, Rich [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: MetaLink Access: Solved (for me at least)

There's an easier fix:

http://www.opera.com

:)

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

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

Re: TNS Listener service question



Patrice,
SqlPlus uses the Bequeath protocol to access local databases if the @ is
omitted in the connect string. If the @ is present (i.e. connect
scott/tiger@db) then it uses Net8. See Note 118381.1 on Metalink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc




Boivin, Patrice J [EMAIL PROTECTED]@fatcity.com on 11/21/2001
10:05:21 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



I noticed that if I leave the TNS Listener service stopped on my NT
workstation, I can't access anything using the GUI tools.

But my script that runs command line can successfully login to the remote
databases to verify that they are accessible.  It uses
c:\oracle\ora81\bin\sqlplus.exe.

Do the command-line utilities bypass the NT TNSListener service?

Just curious, I am leaving the service up now...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

RE: MetaLink Access: Solved (for me at least)

2001-11-21 Thread Mark Leith


It certainly does!!

I run IE6, Netscape 6  Opera 5.12 on a Win2K box. Opera is pretty cool!
Though I sometimes have problems with things like DHTML in it.. Has anybody
else seen this problem?

Mark

-Original Message-
Gramolini
Sent: 21 November 2001 15:10
To: Multiple recipients of list ORACLE-L


Does this run on NT?

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 9:40 AM


 There's an easier fix:

 http://www.opera.com

 :)

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

 -Original Message-
 Sent: Wednesday, November 21, 2001 06:25
 To: Multiple recipients of list ORACLE-L


 OK, I think I figured it out - had to clear the Internet Cache for IE.

 After I did that, I could access MetaLink.

 Don't know why though.

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

RE: MetaLink Access: Solved (for me at least)


YES, it is a standard browser...follows all the rules. 

and so.


any special tweaks that IE has given you over Netscape or over the browser
standardare not supported..

Try it!  My experience with it was very positive. 

-Original Message-
Sent: Wednesday, November 21, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L


Does this run on NT?

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 9:40 AM


 There's an easier fix:

 http://www.opera.com

 :)

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

 -Original Message-
 Sent: Wednesday, November 21, 2001 06:25
 To: Multiple recipients of list ORACLE-L


 OK, I think I figured it out - had to clear the Internet Cache for IE.

 After I did that, I could access MetaLink.

 Don't know why though.

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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

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

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

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

RE:


cascade?  probably more abject ignorance on my part, but wasn't it
including contents?

-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace tablespace_name cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= [EMAIL PROTECTED]
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a tablespace in the Linux, but before this I did't use a function 
Drop.
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop tablespace and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Henry Poras


Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment.

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the compatible parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

 Ed,

   There's more to it than just setting the
 COMPATIBLE parameter.  The basic steps
 are

 1) install new 8.1.6 executables
 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
   making whatever modifications are necessary due to
   new or obsoleted parameters
 3) startup database
 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
 to new forms needed by 8.1.6 software.  Once this is done, NEVER
 open the database using the old version, as it can corrupt the database.

 
 Matt Adams - GE Appliances - [EMAIL PROTECTED]
 Doing linear scans over an associative array is like
 trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)

  -Original Message-
  From: Ed [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, November 20, 2001 6:00 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Upgrade 8.0.5 to 8.1.6
 
 
  A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
  by using export/import.  This will probably work, but wouldn't it be
  easier to just do a cold backup and open them using the
  COMPATIBLE parameter in the 8.1.6 environment?  Is there
  any downside to using export/import? (ie. will it affect snapshots,
  db links, etc...).
 
  I thought the whole point of the compatible parameter was that
  it let you open up an older database with no questions asked.
  Then you could run any of the upgrade .sql scripts at your leisure,
  yes?
 
  Best,
 
  Ed
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Ed
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Mr. Clark
  INET: [EMAIL PROTECTED]

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

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

2001-11-21 Thread Cherie_Machler



OEM does autodiscover based on what method of networking you
told it to used when you configured autodiscovery:   Names Server,
tnsnames.ora, or directory server.   We use tnsnames.ora and
OEM looks to see what the SID names are in tnsnames.ora for
sure.   It may do this in conjunction with the oratab file as well.

What method did you tell OEM you were using for networking?
The OEM documentation has a fairly comprehensive section
on autodiscovery in the section on setting up the Console.

Cherie Machler
Oracle DBA
Gelco Information Network


   
 
HAWKINS, JAMES W  
 
[IT/1000]  To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED] 
james.w.hawkins@phar   cc:
 
macia.com  Subject: RE: Oracle 9i and OEM 
 
Sent by:   
 
[EMAIL PROTECTED]   
 
   
 
   
 
11/21/01 08:25 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Sepi,

Just a guess - are all three instances listed in your /etc/oratab file?
I'm
pretty sure OEM looks at that to determine what instances the Agent should
monitor.  I could be wrong on this though - it's been a while since I've
looked at OEM.

JIm

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

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

[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, November 20, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a problem with Enterprise Manager.

I am trying to refresh a node in order to get information of all instances
on that machine. I am able to see two of three instances. Why I cannot see
all of them. Setting up the preferences are ok, I have tested all user-id's

and passwords.

TIA,

Sepi



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

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

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

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

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

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




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

RE: Odd Listener.ora Stanza


Never mind, this is an IIOP operability hook. 


-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the newfangled features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Index File Name


standard create user script for a user who will own objects:

create user xyz identifed by abc
default tablespace default
temporary tablespace temp
quota unlimited on default
/
grant connect, resource to xyz
/
revoke unlimited tablespace from xyz
/


I've gotten this drilled into my people's heads... and I check up
on it :)
--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Mark Leith wrote:
  
  And just to add to that - make sure that the user has the
 appropriate
  privileges on the system, such as CREATE TABLE / INDEX, or the role
 RESOURCE
  or whatever.. :)
  
  Just to nitpick :)
  
 
 NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
 cannot grant it to a role, usually - but Oracle 5 compatibility has
 its
 reasons ...). Not that I am paranoid, but the idea of users being
 able
 to create their tables in SYSTEM makes me nervous.
  I know, someone should tell to the Oracle folks who prepare demo
 scripts ...
 -- 
 Regards,
 
 Stephane Faroult
 Oriole Corporation
 Voice:  +44  (0) 7050-696-269 
 Fax:+44  (0) 7050-696-449 
 Performance Tools  Free Scripts
 --
 http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
 --
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Stephane Faroult
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
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:RE:

2001-11-21 Thread dgoulet


OOPS! sorry, your right

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   11/21/2001 7:40 AM

cascade?  probably more abject ignorance on my part, but wasn't it
including contents?

-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace tablespace_name cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= [EMAIL PROTECTED]
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a tablespace in the Linux, but before this I did't use a function 
Drop.
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop tablespace and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

Re: Index File Name

2001-11-21 Thread Stephane Faroult


Mark Leith wrote:
 
 Yeah but for a tightly controlled schema *owner* - what's the problem?
 Wouldn't you *want* to have unlimited tablespace for the schema owner -
 which the users *should not* have access to anyway?
 
 (no this is not rhetorical - I have no production experience)
 
 Thanks
 
 Mark

End-users are not the ones to fear. Developers are. Assume you control
as tightly as you want, we all have our bad days and forget someday to
do something we should have - and know we should have. Just imagine a
user with UNLIMITED TABLESPACE for which you forgot to change the
default tablespace from SYSTEM. I am ready to bet that before long
you'll find unique indexes named (good case) TABLENAME_PK or (bad case)
SYS_C12345 in SYSTEM. Don't give people any right they do not need.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools  Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Re[2]: Index File Name

2001-11-21 Thread dgoulet


Rachel,

I create a role called 'developer' in each instance at create time.  Make it
look something like resource, but without the unlimited tablespace priv, and use
it in place of resource.  saves a step.

Dick Goulet

Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date:   11/21/2001 7:45 AM

standard create user script for a user who will own objects:

create user xyz identifed by abc
default tablespace default
temporary tablespace temp
quota unlimited on default
/
grant connect, resource to xyz
/
revoke unlimited tablespace from xyz
/


I've gotten this drilled into my people's heads... and I check up
on it :)
--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Mark Leith wrote:
  
  And just to add to that - make sure that the user has the
 appropriate
  privileges on the system, such as CREATE TABLE / INDEX, or the role
 RESOURCE
  or whatever.. :)
  
  Just to nitpick :)
  
 
 NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
 cannot grant it to a role, usually - but Oracle 5 compatibility has
 its
 reasons ...). Not that I am paranoid, but the idea of users being
 able
 to create their tables in SYSTEM makes me nervous.
  I know, someone should tell to the Oracle folks who prepare demo
 scripts ...
 -- 
 Regards,
 
 Stephane Faroult
 Oriole Corporation
 Voice:  +44  (0) 7050-696-269 
 Fax:+44  (0) 7050-696-449 
 Performance Tools  Free Scripts
 --
 http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
 --
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Stephane Faroult
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-11-21 Thread Henry Poras


Ross,

fecality? Is that the F in RTFM? Well, things are pretty slow here (who am I
kidding. They have been, no wait. It has been pretty slow here for months)
so I grabbed my Net8 book. Not that this makes a lot of sense, but this is
what it says.

PRESENTATIONIdentifies the presentation layer
Default TTC
Values  TTC|GIOP

TTC Two-task Common
GIOP IIOP clients require GIOP. It is an alias for
either oracle.aurora.server.SGiopServer or
 oracle.aurora.server.GiopServer using TCP/IP or
TCP/IP with SSL

SESSION Identifies the session layer (oh)
Default NS
Values  NS|RAW

IIOP clients require no session layer (RAW)
Typical Net8 clients use a session layer of
Transparent Network Substrate (TNS) Network Session (NS).

For all this means to me I might as well post it on the OT list.

HB

Henry



-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the newfangled features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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


Jaysus, note the date and time. It's a freaking miracle. 

;-)

-Original Message-
Sent: Wednesday, November 21, 2001 10:54 AM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


OOPS! sorry, your right

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   11/21/2001 7:40 AM

cascade?  probably more abject ignorance on my part, but wasn't it
including contents?

-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace tablespace_name cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= [EMAIL PROTECTED]
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a tablespace in the Linux, but before this I did't use a function 
Drop.
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop tablespace and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Oracle and MQ

2001-11-21 Thread YTTRI Lisa

Title: RE: Oracle and MQ

Tony -

Do you
have error handling built in to your VB program, or do you just load it into
Oracle and then cleanse/validate the data there?

Do you
think it would also be possible to access MQ viaexternal stored
procedures?

-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 20, 2001 4:02
PMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: Oracle and MQ
I believe Oracle sells an MQ-to-AQ bridge that just moves
messages between queuing systems. We use VB to pull messages out of MQ
and issue SQL to get it into the database.
HTH Tony Aponte
-Original Message- From: YTTRI
Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Subject: OT: Oracle and MQ
Hi -
Does anyone have experience with using MQ w/Oracle. We
have an application that is using MQ to get data from
the mainframe into Oracle. We are trying to
determine what our options are for retrieving the data from the MQ
queues.
We know one option is to write a Pro*C program to handle this,
but this means creating all our own error logic,
etc. Does AQ fit into this scenario at all, or
is that primarily for non-middleware queues?
Any information / insight would be greatly appreciated.

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

SQL question

2001-11-21 Thread Malik, Fawzia



Hi,

Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??

Any advice/hints would be greatly appreciated

Rgds

Fawzia 


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

2001-11-21 Thread Deshpande, Kirti


Something to do with external procedure calls, Java support, GIOP support in
8.0.x versions (  8i)   

Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75,
85-86 in particular. 

Cheers!

- Kirti

 -Original Message-
 From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, November 21, 2001 9:15 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Odd Listener.ora Stanza
 
 Anyone seen this fecality in their listener.ora?  It's a new one on me, 
 but then again, what with all the newfangled features in this here 
 product, I am probably just losing track..
 
 
 
 (DESCRIPTION =
   (PROTOCOL_STACK =
 (PRESENTATION = GIOP)
 (SESSION = RAW)
   )
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: MetaLink Access: Solved (for me at least)


huh?

Did you buy it, or just trial it?

there are no ads in the regular version, AFAIK

-Original Message-
Sent: Wednesday, November 21, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


The only thing I don't like about Opera is the ads.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Jesse, Rich [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: MetaLink Access: Solved (for me at least)

There's an easier fix:

http://www.opera.com

:)

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

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

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

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

Re: Odd Listener.ora Stanza