date:20011127


 Thomas Jeff wrote:
 
 We recently had a new website go live.   Since then, I'm seeing
 constant buffer busy waits
 and after a period of time, I see sessions hung on the same block#.
 The SQL query
 is always a COUNT(*) (below).   It's almost as though one session has
 a lock
 of some sort in the buffer cache and other sessions are blocked.
 Although, I've checked and
 there's no DML ongoing, so I'm unsure as to why we would see this.
 Note that v$session shows
 78 and 393 to be INACTIVE, while 159 is ACTIVE.So it's like 159
 can't write to
 the buffer cache because 78 and 393 have a lock there.   Note that
 these are all defined
 as persistent connections, via the Vignette front-end.   I'm sure all
 the clues are there
 but my brain is too fuzzed to piece it together.
 
  SID SQL_TEXT
 O/S User
 - 
 ---
   159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT   FROM BBN.BBN_SRV
 vignette
   159 _PAID_WARR_CLAIM  WHERE CUSTOMER_ID = :b1  AND ENTERPRISE_CD = :
 vignette
   159 b2  AND (CHECK_ID IS NOT NULL   AND CHECK_ID != 'PENDING' )
 vignette
 
  SID EVENT   P1TEXT   P1 P2TEXT  P2
 P3TEXT   P3
 - --  -- --- --
 - --
78 buffer busy waitsfile#  72 block#  109177
 id   130
   393 buffer busy waitsfile#  72 block#  109177
 id   130
   159 db file scattered read   file#  72 block#  109177
 blocks8
 
 
 Jeffery D Thomas
 DBA
 Thomson Information Services
 Thomson multimedia Inc.
 
 Email: [EMAIL PROTECTED]
 DBA Quickplace: http://gkmqp.tce.com/tis_dba
 
 

SELECTs sometimes do some block house-keeping, and thus modify Oracle
buffers even if they are not supposed to. I have also witnessed strange
behaviours with IOTs. What do other queries do? Have you checked
V$SQLAREA to know whether this query is executed very often or not? I
guess that at least CUSTOMER_ID is indexed (BTW it would be interesting
to know whether the busy block is a data or index block. Try this :

select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 72
 and block_id = 109177
  and   109177  block_id + blocks

If the block is a table block, you can fudge the issue by making Oracle
only look into an index storing all referenced columns (which would
probably also mean making CHECK_ID not null, side-effects on your code).
If it's an index block, it's more delicate to handle.

If your query is executed very often, denormalizing might also be an
idea. I am no great fan of denormalisation but a trigger to maintain a
count and a sum would be comparable in overhead cost to an additional
index.

-- 
HTH,

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

Number of Transactions per 24hr period? - Urgent

2001-11-27 Thread Denham Eva

Title: Number of Transactions per 24hr period? - Urgent





Hello List,


Please help, I would like to determine the number of transactions processed by Oracle during a 24 hr period.
Is this possible?


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: ORA - 12560: TNS: protocol adapter error

2001-11-27 Thread kranti pushkarna

Title: How to read trace file



just 
start the oracle service in the control panel

Kranti

  -Original Message-From: Saurabh Sharma 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 27, 2001 3:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  ORA - 12560: TNS: protocol adapter error
  check to see whether 
  listener settings are done on the system.
  check for tnsnames.ora and 
  listener.ora files on home\network\admin folder
  
  cheers.
  
  saurabh
  
- Original Message - 
From: 
S.Jyotinarayan 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, November 12, 2001 3:00 
PM
Subject: ORA - 12560: TNS: protocol 
adapter error


Hi,
I have installed your Oracle 8i EE trial 
software.
When i am trying to connect through SQLPLUS 
with username: SCOTT andpassword: TIGER i am getting the following error 
:- 
"ORA - 12560: TNS: protocol adapter 
error".Could you tell why i am getting this error?

What other information should i provide 
you?Thanx in 
  advanceJyotinarayan

Re: Number of Transactions per 24hr period? - Urgent


 Denham Eva wrote:
 
 Hello List,
 
 Please help, I would like to determine the number of transactions
 processed by Oracle during a 24 hr period.
 Is this possible?
 
 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
 --

This is typically the kind of information you find in V$SYSSTAT. Look at
V$INSTANCE to get the exact time when your instance was started,
V$SYSSTAT holds (mostly) cumulated values.
-- 
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: Re: ACM SIGMOD-papers of interest #1

2001-11-27 Thread Cyril Thankappan



Hi!

 Where can I get a copy of
 Scaling Oracle 8i
  please

 Cyril


On Tue, 27 Nov 2001 Jared Still wrote :
 On Monday 26 November 2001 19:15, Rachel Carmichael 
 wrote:
   For those of you techheads that don't yet have a 
 copy of 'Scaling
   Oracle
   8i',
   it's full of architectural info that will help you 
 understand this
   stuff.
  
   Good bedtime reading.  :)
 
  gotta get you a life Jared :)
 
 
 Huh?  What's that?
 
 -- 
 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: Cyril  Thankappan
  INET: [EMAIL PROTECTED]

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

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

Antwort: RE: Antwort: RE: Buffer Busy Waits -- Sanity check please

2001-11-27 Thread Ivo . Libal



But what if they are aging out, isnt that one of reasons for buffer busy
and they are - if there is a scattered read

From docus:
As buffer busy waits are due to contention for particular blocks then you
cannot take any action until you know which blocks are being competed for
and why. Eliminating the cause of the contention is the best option. Note
that buffer busy waits for data blocks are often due to several processes
repeatedly reading the same blocks (eg: if lots of people scan the same
index) - the first session processes the blocks that are in the buffer
cache quickly but then a block has to be read from disk - the other
sessions (scanning the same index) quickly 'catch up' and want the block
which is currently being read from disk - they wait for the buffer as
someone is already reading the block in.

If the table s not too big, than I would put it to the cache to avoid
reloads from harddisk.
Ivo


Ivo Libal, Bc.

Design  Development, Warehousemanagementsystems Dept.

KNAPP Systemsintegration GmbH
Waltenbachstraße 9
A-8700 Leoben, Austria

Phone: ++43/3842/805-0
e-Mail: [EMAIL PROTECTED]



   
 
Thorns, Malcolm (NESL-IT)
 
Malcolm.Thorns@northern-electAn: Multiple recipients 
of list ORACLE-L [EMAIL PROTECTED]   
ric.co.ukKopie:   
 
Gesendet von: [EMAIL PROTECTED]Thema:  RE: Antwort: RE: 
Buffer Busy Waits --  Sanity check please
   
 
   
 
11/27/2001 11:10 AM
 
Bitte antworten an ORACLE-L
 
   
 
   
 





This will not resolve the 'buffer busy wait' scenario.
The contention is for blocks that are already in the SGA.

Regards,

Malcolm.

-Original Message-
Sent: Tuesday, November 27, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L



Hi
I would try to set the table to cache mode. It seams that the blocks are
aged out from buffer - which is default for FTS.
alter table BBN_SRVvignette cache;
to avoid reloading into cache.
Ivo


Ivo Libal, Bc.

Design  Development, Warehousemanagementsystems Dept.

KNAPP Systemsintegration GmbH
Waltenbachstraße 9
A-8700 Leoben, Austria

Phone: ++43/3842/805-0
e-Mail: [EMAIL PROTECTED]





Thorns, Malcolm (NESL-IT)

Malcolm.Thorns@northern-electAn: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
ric.co.ukKopie:

Gesendet von: [EMAIL PROTECTED]Thema:  RE:
Buffer
Busy Waits --  Sanity check please




11/27/2001 09:25 AM

Bitte antworten an ORACLE-L









Jeff,

The 3 sessions are doing the same (or similar) queries.  In this case
count(*) which is forcing a full table scan of the table in each session.
The 3 sessions are thus trying to access the same blocks from the SGA,  in
the same order.  Only 1 session can access a block in the SGA at a time -
this is the session showing 'db file scattered read'. The other 2 sessions
need to wait for the block (these waits show as 'buffer busy waits' - ie
waiting for the block in the SGA).  You will see the block id (and perhaps
the file id) changing as the FTS's progress.  Thus the sessions are
'chasing' each other through the blocks - holding each other up with SGA
block contention - which shows up as 'buffer busy waits'.  Hope that
explains things.

Regards,

Malcolm

-Original Message-
Sent: Monday, November 26, 2001 11:21 PM
To: Multiple recipients of list ORACLE-L



We recently had a new website go live.   Since then, I'm seeing constant
buffer busy waits
and after a period of time, I see sessions hung on the same block#.The
SQL query
is always a COUNT(*) (below).   It's almost as though one session has a
lock

of some sort in the buffer cache and other

RE: Number of Transactions per 24hr period? - Urgent

2001-11-27 Thread Denham Eva

Title: RE: Number of Transactions per 24hr period? - Urgent





Thanks,


I have followed this line of thought, however, What parameter do I use as a yard stick?
Perhaps execute count, parse(hard), OR parse(total) - This is what I am not sure of:)


Thanks
Denham


-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Number of Transactions per 24hr period? - Urgent



 Denham Eva wrote:
 
 Hello List,
 
 Please help, I would like to determine the number of transactions
 processed by Oracle during a 24 hr period.
 Is this possible?
 
 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
 --


This is typically the kind of information you find in V$SYSSTAT. Look at
V$INSTANCE to get the exact time when your instance was started,
V$SYSSTAT holds (mostly) cumulated values.
-- 
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).




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

RE: Inserstatement

2001-11-27 Thread Iulian . ILIES


You cannot achieve this by one sql statement. 
Instead you should consider use PL/SQL.
Make your own procedure or an anonymous PL/SQL block.
I would like to give you an example but you have to tell more about your
problem, like the update  should be done based on a relation between those 2
tables... and furthermore it's an insert or an update what you were talking
about?
If you want just an insert you can use something like:
INSERT INTO X
  (field_in_X)
  SELECT field_in_P FROM P

Regards
Iulian

-Original Message-
Sent: Tuesday, November 27, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

How can I update one field in table X
from another table, table P. Table P have 5 different fields but only one of
them should be used to update table X.
Give me an example on a sql statement for this.

Sincerely

Roland S




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

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

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


**
The information contained in this communication is confidential and 
may be legally privileged. It is intended solely for the use of the 
individual or entity to whom it is addressed and others authorised to 
receive it. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking action in 
reliance of the contents of this information is strictly prohibited and 
may be unlawful. Mobil Rom is neither liable for the proper, complete 
transmission of the information contained in this communication nor 
any delay in its receipt.
**

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

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

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

Re: Disabling Constraints

2001-11-27 Thread Ruth Gramolini


Here is a script which generates all of the 'alter table' statements to drop
the referential constrains.  Spool if or cut and paste and you should be all
set.

select 'alter table schema.'||table_name||' disable constraint
'||constraint_name||';'
from dba_constraints
where  CONSTRAINT_TYPE in ('R')
and owner='SCHEMA';

HTH,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 26, 2001 5:31 PM


 I need to disable some constraints to load table data for my DB
conversion.
 I cannot find the syntax to do this.  I think it should be ALTER TABLE
 something.

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

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

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

RE: Disabling Constraints


Ruth:

Thanks, I found this to work also.

ALTER TABLE 'TABLE_NAME
DISABLE CONSTRAINGT CONSTRAINT_NAME;

Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 7:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disabling Constraints

Here is a script which generates all of the 'alter table' statements to drop
the referential constrains.  Spool if or cut and paste and you should be all
set.

select 'alter table schema.'||table_name||' disable constraint
'||constraint_name||';'
from dba_constraints
where  CONSTRAINT_TYPE in ('R')
and owner='SCHEMA';

HTH,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 26, 2001 5:31 PM


 I need to disable some constraints to load table data for my DB
conversion.
 I cannot find the syntax to do this.  I think it should be ALTER TABLE
 something.

 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: 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: 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: Fixing a DB


Looks good.  Does fol mean following?

Thanks,

Ken

 -Original Message-
Sent:   Wednesday, November 21, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Fixing a DB

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

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


I hate to disagree but why couldn't you

update x
set field = (select field1
 from p
 where p.join_field = x.join_field)
where conditions

Iain Nicoll

-Original Message-
Sent: Tuesday, November 27, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L


You cannot achieve this by one sql statement. 
Instead you should consider use PL/SQL.
Make your own procedure or an anonymous PL/SQL block.
I would like to give you an example but you have to tell more about your
problem, like the update  should be done based on a relation between those 2
tables... and furthermore it's an insert or an update what you were talking
about?
If you want just an insert you can use something like:
INSERT INTO X
  (field_in_X)
  SELECT field_in_P FROM P

Regards
Iulian

-Original Message-
Sent: Tuesday, November 27, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

How can I update one field in table X
from another table, table P. Table P have 5 different fields but only one of
them should be used to update table X.
Give me an example on a sql statement for this.

Sincerely

Roland S




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

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

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



**
The information contained in this communication is confidential and 
may be legally privileged. It is intended solely for the use of the 
individual or entity to whom it is addressed and others authorised to 
receive it. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking action in 
reliance of the contents of this information is strictly prohibited and 
may be unlawful. Mobil Rom is neither liable for the proper, complete 
transmission of the information contained in this communication nor 
any delay in its receipt.

**

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

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

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

Altering Indexes


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

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

FW: Antwort: RE: Antwort: RE: Buffer Busy Waits -- Sanity check

2001-11-27 Thread Thomas Jeff

Title: FW: Antwort: RE: Antwort: RE: Buffer Busy Waits --  Sanity check please





The table has about 550,000 rows, and will be growing, currently about 
230MB in size. 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Antwort: RE: Antwort: RE: Buffer Busy Waits -- Sanity check
please


But what if they are aging out, isnt that one of reasons for buffer busy
and they are - if there is a scattered read


From docus:
As buffer busy waits are due to contention for particular blocks then you
cannot take any action until you know which blocks are being competed for
and why. Eliminating the cause of the contention is the best option. Note
that buffer busy waits for data blocks are often due to several processes
repeatedly reading the same blocks (eg: if lots of people scan the same
index) - the first session processes the blocks that are in the buffer
cache quickly but then a block has to be read from disk - the other
sessions (scanning the same index) quickly 'catch up' and want the block
which is currently being read from disk - they wait for the buffer as
someone is already reading the block in.


If the table s not too big, than I would put it to the cache to avoid
reloads from harddisk.
Ivo



Ivo Libal, Bc.


Design  Development, Warehousemanagementsystems Dept.


KNAPP Systemsintegration GmbH
Waltenbachstraße 9
A-8700 Leoben, Austria


Phone: ++43/3842/805-0
e-Mail: [EMAIL PROTECTED]




 

 Thorns, Malcolm (NESL-IT) 

 Malcolm.Thorns@northern-elect An: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 

 ric.co.uk Kopie: 

 Gesendet von: [EMAIL PROTECTED] Thema: RE: Antwort: RE: Buffer Busy Waits -- Sanity check please 

 

 

 11/27/2001 11:10 AM 

 Bitte antworten an ORACLE-L 

 

 





This will not resolve the 'buffer busy wait' scenario.
The contention is for blocks that are already in the SGA.


Regards,


Malcolm.


-Original Message-
Sent: Tuesday, November 27, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L




Hi
I would try to set the table to cache mode. It seams that the blocks are
aged out from buffer - which is default for FTS.
alter table BBN_SRVvignette cache;
to avoid reloading into cache.
Ivo



Ivo Libal, Bc.


Design  Development, Warehousemanagementsystems Dept.


KNAPP Systemsintegration GmbH
Waltenbachstraße 9
A-8700 Leoben, Austria


Phone: ++43/3842/805-0
e-Mail: [EMAIL PROTECTED]






 Thorns, Malcolm (NESL-IT)


 Malcolm.Thorns@northern-elect An: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
 ric.co.uk Kopie:


 Gesendet von: [EMAIL PROTECTED] Thema: RE:
Buffer
Busy Waits -- Sanity check please





 11/27/2001 09:25 AM


 Bitte antworten an ORACLE-L










Jeff,


The 3 sessions are doing the same (or similar) queries. In this case
count(*) which is forcing a full table scan of the table in each session.
The 3 sessions are thus trying to access the same blocks from the SGA, in
the same order. Only 1 session can access a block in the SGA at a time -
this is the session showing 'db file scattered read'. The other 2 sessions
need to wait for the block (these waits show as 'buffer busy waits' - ie
waiting for the block in the SGA). You will see the block id (and perhaps
the file id) changing as the FTS's progress. Thus the sessions are
'chasing' each other through the blocks - holding each other up with SGA
block contention - which shows up as 'buffer busy waits'. Hope that
explains things.


Regards,


Malcolm


-Original Message-
Sent: Monday, November 26, 2001 11:21 PM
To: Multiple recipients of list ORACLE-L




We recently had a new website go live. Since then, I'm seeing constant
buffer busy waits
and after a period of time, I see sessions hung on the same block#. The
SQL query
is always a COUNT(*) (below). It's almost as though one session has a
lock


of some sort in the buffer cache and other sessions are blocked.
Although,
I've checked and
there's no DML ongoing, so I'm unsure as to why we would see this. Note
that v$session shows
78 and 393 to be INACTIVE, while 159 is ACTIVE. So it's like 159 can't
write to
the buffer cache because 78 and 393 have a lock there. Note that these
are
all defined
as persistent connections, via the Vignette front-end. I'm sure all the
clues are there
but my brain is too fuzzed to piece it together.


SID SQL_TEXT O/S
User
- 
---
 159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT FROM BBN.BBN_SRV
vignette
 159 _PAID_WARR_CLAIM WHERE CUSTOMER_ID = :b1 AND ENTERPRISE_CD = :
vignette
 159 b2 AND (CHECK_ID IS NOT NULL AND CHECK_ID != 'PENDING' )
vignette


SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT
P3
- --  -- --- --

FW: Buffer Busy Waits -- Sanity check please

2001-11-27 Thread Thomas Jeff

Title: FW: Buffer Busy Waits --  Sanity check please





All: Thanks for the replies!


And yes, it's a data block. The query has been executed over 3,500 times 
since this site went live about 5 days ago. I believe I'll check into 
overindexing just as suggested, either that, go over and shoot the 
programmers responsible for this travesty. I had already noted the problem 
with the CHECK_ID column and was going to suggest making it NOT NULL and 
using a default value. 


BTW, the PK for this table has 7 columns, and CUSTOMER_ID is buried in the 4th 
position.


However, why is it completely stalled? I'm seeing idle times of 10-12 hours,
and as you can see another sessions have joined the fun, but it all is hung
on the same block id. There has been no movement in 10 hours:


259 buffer busy waits file# 72 block# 109177 id 130
303 buffer busy waits file# 72 block# 109177 id 130
327 buffer busy waits file# 72 block# 109177 id 130 
159 db file scattered read file# 72 block# 109177 blocks 8 



-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Buffer Busy Waits -- Sanity check please




 Thomas Jeff wrote:
 
 We recently had a new website go live. Since then, I'm seeing
 constant buffer busy waits
 and after a period of time, I see sessions hung on the same block#.
 The SQL query
 is always a COUNT(*) (below). It's almost as though one session has
 a lock
 of some sort in the buffer cache and other sessions are blocked.
 Although, I've checked and
 there's no DML ongoing, so I'm unsure as to why we would see this.
 Note that v$session shows
 78 and 393 to be INACTIVE, while 159 is ACTIVE. So it's like 159
 can't write to
 the buffer cache because 78 and 393 have a lock there. Note that
 these are all defined
 as persistent connections, via the Vignette front-end. I'm sure all
 the clues are there
 but my brain is too fuzzed to piece it together.
 
 SID SQL_TEXT
 O/S User
 - 
 ---
 159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT FROM BBN.BBN_SRV
 vignette
 159 _PAID_WARR_CLAIM WHERE CUSTOMER_ID = :b1 AND ENTERPRISE_CD = :
 vignette
 159 b2 AND (CHECK_ID IS NOT NULL AND CHECK_ID != 'PENDING' )
 vignette
 
 SID EVENT P1TEXT P1 P2TEXT P2
 P3TEXT P3
 - --  -- --- --
 - --
 78 buffer busy waits file# 72 block# 109177
 id 130
 393 buffer busy waits file# 72 block# 109177
 id 130
 159 db file scattered read file# 72 block# 109177
 blocks 8
 
 
 Jeffery D Thomas
 DBA
 Thomson Information Services
 Thomson multimedia Inc.
 
 Email: [EMAIL PROTECTED]
 DBA Quickplace: http://gkmqp.tce.com/tis_dba
 
 


SELECTs sometimes do some block house-keeping, and thus modify Oracle
buffers even if they are not supposed to. I have also witnessed strange
behaviours with IOTs. What do other queries do? Have you checked
V$SQLAREA to know whether this query is executed very often or not? I
guess that at least CUSTOMER_ID is indexed (BTW it would be interesting
to know whether the busy block is a data or index block. Try this :


select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 72
and block_id = 109177
 and 109177  block_id + blocks


If the block is a table block, you can fudge the issue by making Oracle
only look into an index storing all referenced columns (which would
probably also mean making CHECK_ID not null, side-effects on your code).
If it's an index block, it's more delicate to handle.


If your query is executed very often, denormalizing might also be an
idea. I am no great fan of denormalisation but a trigger to maintain a
count and a sum would be comparable in overhead cost to an additional
index.


-- 
HTH,


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

HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent

2001-11-27 Thread sangeetha


hi list,
   i enrolled in this list jus today and it was
really nice to see the questions and the responses
that were posted.here i've got few doubts.if
possible plz do clear them as soon as possible, as
comming nov 30th is my project presentation.

1)If a tablespace is deleted will the users and tables
created in that tablespace get deleted?,if not in
which tablespace will the users and tables get stored.

2)what is the function of Roll Segment?...is it
necessary to create it every time we create
tablespace?

3)plz do give me the exact difference between oracle8i
and oracle9i,ie., what are the advancements in
Oracle9i not present in oracle 8i.

d) diff between oracle8i and its previous versions.

plz do clear all or any of the above doubts.
awaiting for all u're replies eagerly.

regards
sangeetha

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

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

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

RE: Disabling Constraints

2001-11-27 Thread Ramon Estevez


Ken,

ALTER TABLE mytable DISABLE CONSTRAINT myconstraint.


This should work

Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ken Janusz
Enviado el: Monday, 26 November, 2001 5:31 PM
Para: Multiple recipients of list ORACLE-L
Asunto: Disabling Constraints


I need to disable some constraints to load table data for my DB conversion.
I cannot find the syntax to do this.  I think it should be ALTER TABLE
something.

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

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

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

2001-11-27 Thread Paul . Parker

Title: RE: Number of Transactions per 24hr period? - Urgent

Denham,

Craig
Shallahamer explores this issue in a paper on www.orapub.comabout Response Time
Analysis.

In
essence, one way of calculating the no. of transactions can be from 'user
commits' + 'user rollbacks', but it appears that you also want to calculate the
"response time" for these transactions. A slightly "harder" problem, as
Craig suggests.

Good
luck
Paul

PS. Good to see another South African on the list
:)

-Original Message-From: Denham Eva
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 27, 2001 7:35
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Number of Transactions per 24hr period? - Urgent
Thanks,
I have followed this line of thought, however, What parameter
do I use as a yard stick? Perhaps execute count,
parse(hard), OR parse(total) - This is what I am not sure of:)
Thanks Denham
-Original Message- From:
Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Number of Transactions per 24hr period? - Urgent

Denham Eva wrote:
Hello List,
Please help, I would like to determine the number
of transactions processed by Oracle during a 24
hr period. Is this possible? 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
--

This is typically the kind of information you find in
V$SYSSTAT. Look at V$INSTANCE to get the exact time
when your instance was started, V$SYSSTAT holds
(mostly) cumulated values. -- 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).

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

RE: ACM SIGMOD-papers of interest #1


Henry, this is a great post. All I can add of peripheral
interest is a pointer to a book called Efficient Memory Programming
or something like that. 

Absolutely the best presentation of CPU/cache dependencies i have seen. 

Makes you really think about cache behavior, CPU architecture, and all
these tools that say they crosscompile or run platform independently. 

when resources (time, memory, correctness, etc) are thin, a handcrafted
program by an architecture savvy programmer is often the best thing. 

thanks again, Henry.great stuff..


- Ross

-Original Message-
Sent: Monday, November 26, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L


Well, I'm way behind on my reading so I am just finishing a quick (?) skim
of the May proceedings of the 2001 ACM SIGMOD Conference on Management of
Data. There is some interesting stuff in there so I thought I would try to
review some of the high points I found. ACM SIGMOD is the Special Interest
Group on Management of Data from the Association for Computing Machinery.
You can join for just $20 and get totally swamped with CDs and publications.
(www.acm.org)

There are a few interesting articles. This is installment #1

DBMSs On A Modern Processor: Where Does Time Go?
(http://www-2.cs.cmu.edu/~natassa/papers/vldb99_paper.pdf)
Anastassia Ailamaki, David J. DeWitt, Mark D. Hill, David A. Wood
University of Wisconsin - Madison

from Proceedings of the 25th VLDB Conference, 1999

This paper was actually referenced in a paper from ACM SIGMOD 2001
(Improving Index Performance through Prefetching)

The main point is that even as we concentrate on increasing performance by
tuning IO, the hit from processor cache misses is becoming more important.
The increasing gap between processor speed and DRAM/disk speeds is
accentuating this problem. Most DBMSs focus on caching data in main memory
(buffer cache), but this ignores the caching of main memory in level 1 and
level 2 processor caches. Cache misses can account for 50% of execution
time.

In this paper, the authors examine four commercial (unnamed) DBMSs running
on a 6400 PII Intel Xeon/MT Workstation running Windows NT v4.0. The focus
is on the memory interactions, so to reduce IO effects, a memory resident
database is used (the buffer pool was large enough to hold the datasets for
the queries). Almost half the execution time was spent on stalls. The
breakdown is as follows:
*   90% of the stalls are from:
-second-level cache data misses
-first -level cache instruction misses
*   20% of the stalls are from subtle implemention details (e.g. branch
misdirection)

Analysis was done using simple queries (sequential range, index range,
sequential join). The results were compared to TPC-D (and TPC-C?) benchmarks
which yielded similar results. It thus appears reasonable to scale the
conclusions of this simple methodology to more complex scenarios. 

DETAILS
Query time = computation time + memory stalls + branch misdirection overhead
+ resource related stalls - overlap (some work can be done while waiting for
a stall).

Computation time is usually less than 1/2 of the execution time. Since
memory access times decrease more slowly than processor clock speeds, the
computation time componant will continue to decrease. Most of the workload
is also seen to be latency, not bandwidth bound (latency - how long it
takes.  bandwidth - how much you can do in a given time. If you are latency
bound, adding more processors won't help as the information isn't getting
there fast enough. [summarized from In Search of Clusters. thanks Ross])

Memory stall times vary more across different query types than across
different DBMSs. Memory stall is the most significant one of the three major
stall types. The bulk of the memory stall is from L1-information cache and
L2-data cache. It is possible, however, that tuning for one or two of the
stall types will just shift the bottleneck to the remaining stalls. Memory
stalls are also dependent on increasing record size [locality of data].

Henry


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

Re: Altering Indexes

2001-11-27 Thread Ruth Gramolini


alter index schema.index_name rebuild new_tablespace.

You can create a script to move all of them as follows:

select 'alter index schema.'||index_name||' rebuild tablespace
NEW_TABLESPACE;'
from dba_indexes where owner='SCHEMA';

hth,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 9:25 AM


 I have this large DB (approx. 250 tables) that has the tables and indexes
in
 the same tablespace (not my design).  Is there a way I can move all of the
 indexes to a separate tablespace en-mass?  I know I can move them one at a
 time with the alter index command, but that would be rather time
consuming.

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

svrmgrl and W2k

Title: svrmgrl and W2k





OH MY GOSH this sucks. 


Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and the listener, for that matter) via Terminal Server and it keeps erring out with ORA-12560 protocol adapter error. 

I look on Metalink and it just plain says, Go to the console. WHAT? Are you KIDDING! Here's the note:


fact: Oracle Server - Enterprise Edition 
fact: RDBMS 
fact: MS Windows 2000 
fact: MS Windows NT 
symptom: Cannot connect to SVRMGRL 
symptom: ORA-12560: TNS:protocol adapter error 
symptom: Cannot connect to SVRMGR30 
symptom: ORA-12203: TNS:unable to connect to destination 
cause: Bequeath protocol is not supported with Microsoft Terminal Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on Oracle8i. 

fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is not available using an MS Windows 2000 Terminal Server Client. To startup the instance, use the the Windows 2000 console to connect to the SVRMGRL. 

I can do this with W2k, Terminal Server and Standard Edition. 


Has anyone else seen this ? I am so irked I could scream. (But it could be the hormones). 


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

RE: Altering Indexes

2001-11-27 Thread Mercadante, Thomas F


Ken,

Why not generate the alter index {} rebuild tablespace {} commands using
sql,
break the resulting commands up into several different files, and run them
at the same time?

Probably the easiest (and fastest) way to go.

The generate script would be:

set head off
set pages 1000
spool move_indexes.sql
select 'alter index ' || index_name || ' rebuild tablespace
{new_tablespace_name};'
from user_indexes
spool off

Take the move_indexes.sql script, and break it up into, say 5 files and run
5 sql sessions at once.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 27, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

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

RE: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent


sangeetha,

1) If a tablespace is deleted all of the tables, indexes or rollback
segments that reside in that tablespace will also be deleted. Users are not
stored in a tablespace, except in the SYSTEM tablespace - which you DON'T
want to delete as it is the tablespace that runs the Oracle system.

2) Rollback segments are created to give users a read consistent view. an
example:

Scott wants to update the EMP table:

EMPID  EMPNAME  DEPT
-  ---  -

9567 JonesSALES

and set Jones' department to Support as he's moved jobs. Scott issues:

update emp set dept = 'SUPPORT' where empname = 'JONES';

but he does not COMMIT the change, as he needs to move on and do some other
things..

Frank comes along, and is trying to find out what Jones' department is, and
issues:

select empid, empname, dept from scott.emp where empname = 'JONES';

but scott as still not commited the change that he issued earlier. Frank
will still see:

EMPID  EMPNAME  DEPT
-  ---  -

9567 JonesSALES

When you create your database, you should add at least one non-system
rollback segment to be able to build tablespaces, and tables. When the
database is created there is one rollback sgement created in the SYSTEM
tablespace - but this is supposed to be used explicitly for system
transactions.

3) Exact differences are hard to explain without going in to a new paper or
something.. The major enhancements are Automatic Undo Management or AUM (the
above mentioned rollback segments are handled automagically for you),
flashback query (another addition stemming from AUM), Oracle managed files,
resumable transactions, online schema changes, new datatypes, and new SQL
commands such as MERGE. There is a member of this list - Joes Testa - who is
currently sending out (bi?)weekly emails to the list on the new features of
9i with examples and tests that he has performed. Very good reading!

8i also brought a wealth of new features from 7, such as locally managed
tablespaces, java support, xml,  partitioning, Index organised tables.. the
list could go on for a while... The best bet is to get on to a web site like
http://otn.oracle.com as they have a wealth of New Features, FAQ type
documents..

Welcome to the list!!

HTH

Mark

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


-Original Message-
Sent: 27 November 2001 14:30
To: Multiple recipients of list ORACLE-L
between oracle 8i and 9i, and between oracle 8i and previous versions -
urgent


hi list,
   i enrolled in this list jus today and it was
really nice to see the questions and the responses
that were posted.here i've got few doubts.if
possible plz do clear them as soon as possible, as
comming nov 30th is my project presentation.

1)If a tablespace is deleted will the users and tables
created in that tablespace get deleted?,if not in
which tablespace will the users and tables get stored.

2)what is the function of Roll Segment?...is it
necessary to create it every time we create
tablespace?

3)plz do give me the exact difference between oracle8i
and oracle9i,ie., what are the advancements in
Oracle9i not present in oracle 8i.

d) diff between oracle8i and its previous versions.

plz do clear all or any of the above doubts.
awaiting for all u're replies eagerly.

regards
sangeetha

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

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

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

Re: Altering Indexes

2001-11-27 Thread Jeff Wiegard


Ken,

Try executing the following:

select 'I am rebuilding my index '||index_name||' and putting it in
another tablespace;'
from user_indexes
/

and of course, spool the sucker, set heading off, set pagesize.

Merry Spooling and Happy Selecting 

 [EMAIL PROTECTED] 11/27/01 08:25AM 
I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design).  Is there a way I can move all
of the
indexes to a separate tablespace en-mass?  I know I can move them
one at a
time with the alter index command, but that would be rather time
consuming.

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

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

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

2001-11-27 Thread Kent Wayson



I've never heard of a mass move index utility.  What I did in a similar
situation is script it, with something like this:

SET head OFF feed ON echo OFF verify OFF pagesize 0 linesize 65 trimspool on
--
spool ind_fix.sql
--
select 'alter index '||index_name||' rebuild '
||CHR(10)||' tablespace  ts name here'
||CHR(10)||' storage (storage stuff here);'
from user_indexes
/
--
spool off
--
SET head ON feed ON echo ON verify ON pagesize 50 linesize 200


Then run the generated script.  This was on a database with over 2300
indexes (and 1400 tables).  Most weren't that large, so it didn't take too
long.  I was doing this to put the indexes in a tablespace with uniform
extent sizes, so the storage parameters were the same for every index.


Kent


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

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

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

v$session_wait

2001-11-27 Thread Charlie Mengler


One of the fields is WAIT_TIME   
A non-zero value is the session's last wait time. 
A zero value means the session is currently waiting 

What are the units associated with this number?

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
In life, sometimes you're the windshield; other times you're the bug!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE: Altering Indexes

2001-11-27 Thread Ball, Terry


You can't do it en-mass.  Why not write a script to do this.
select 'alter index '||index_name||' rebuild new_tbsp;'
from user_indexes;
or somthing similar.

Terry

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


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

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

[no subject]

2001-11-27 Thread Michael Netrusov

Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server 
Client do not work. I used PC Anywhere, everything went fine.

HTH, 
Michael

From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

-- Original message --

OH MY GOSH this sucks.  

Is anyone running 8.1.7 EE on W2k?  I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error.  

I look on Metalink and it just plain says, Go to the console.  WHAT?  Are
you KIDDING!  Here's the note:

*   fact: Oracle Server - Enterprise Edition 
*   fact: RDBMS 
*   fact: MS Windows 2000 
*   fact: MS Windows NT 
*   symptom: Cannot connect to SVRMGRL 
*   symptom: ORA-12560: TNS:protocol adapter error 
*   symptom: Cannot connect to SVRMGR30 
*   symptom: ORA-12203: TNS:unable to connect to destination 
*   cause: Bequeath protocol is not supported with Microsoft Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i. 
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL. 

I can do this with W2k, Terminal Server and Standard Edition.  

Has anyone else seen this ? I am so irked I could scream.  (But it could be
the hormones). 

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

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

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

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

2001-11-27 Thread Rachel Carmichael


no way that I know of, you need to move each index on its own


--- Ken Janusz [EMAIL PROTECTED] wrote:
 I have this large DB (approx. 250 tables) that has the tables and
 indexes in
 the same tablespace (not my design).  Is there a way I can move all
 of the
 indexes to a separate tablespace en-mass?  I know I can move them one
 at a
 time with the alter index command, but that would be rather time
 consuming.
 
 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).


__
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: HELP : doubts regarding --- Tablespace ,Roll Segment , dif

2001-11-27 Thread Rao, Maheswara


sangeetha,

1. When a tablespace is deleted, the users do not get dropped.  Users would
still be present.  However, the tables created on the tablespace would be
dropped.  Users and their details are maintained in Oracle dictionary.  If
you have DBA permissions on your database, check the view, dba_users.  You
would see all the users.

2. A rollback segment stores any data that is changed in the database.  But
there are many ramifications for a rollback segment.  Read Oracle concepts
manual for a complete understanding of rollback segments.

3. There are many differences between Oracle 8i and Oracle 9i.  Listing them
here would be very lengthy.  You could create a user account in
http://otn.oracle.com/ .  It is free.  There go to this link --
http://otn.oracle.com/products/oracle9i/content.html . In this you would see
a title - Oracle 9i features.

Rao

-Original Message-
Sent: Tuesday, November 27, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L
between oracle 8i and 9i, and between oracle 8i and previous versions -
urgent


hi list,
   i enrolled in this list jus today and it was
really nice to see the questions and the responses
that were posted.here i've got few doubts.if
possible plz do clear them as soon as possible, as
comming nov 30th is my project presentation.

1)If a tablespace is deleted will the users and tables
created in that tablespace get deleted?,if not in
which tablespace will the users and tables get stored.

2)what is the function of Roll Segment?...is it
necessary to create it every time we create
tablespace?

3)plz do give me the exact difference between oracle8i
and oracle9i,ie., what are the advancements in
Oracle9i not present in oracle 8i.

d) diff between oracle8i and its previous versions.

plz do clear all or any of the above doubts.
awaiting for all u're replies eagerly.

regards
sangeetha

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

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

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

RE: Altering Indexes

2001-11-27 Thread Kent Wayson



maybe even moving the largest tables to their own
tablespace first.

Just remember that if you move a table, all its indexes will be invalid, so
you may want to rebuild the indexes for each table right after the table is
moved.  

If you just move the indexes, only the index being moved is temporarily
unavailable.

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

2001-11-27 Thread Iulian . ILIES


Yeah, Iain, you are right, and I don't hate to recognize.

Iulian

-Original Message-
Sent: Tuesday, November 27, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


I hate to disagree but why couldn't you

update x
set field = (select field1
 from p
 where p.join_field = x.join_field)
where conditions

Iain Nicoll

-Original Message-
Sent: Tuesday, November 27, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L


You cannot achieve this by one sql statement. 
Instead you should consider use PL/SQL.
Make your own procedure or an anonymous PL/SQL block.
I would like to give you an example but you have to tell more about your
problem, like the update  should be done based on a relation between those 2
tables... and furthermore it's an insert or an update what you were talking
about?
If you want just an insert you can use something like:
INSERT INTO X
  (field_in_X)
  SELECT field_in_P FROM P

Regards
Iulian

-Original Message-
Sent: Tuesday, November 27, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

How can I update one field in table X
from another table, table P. Table P have 5 different fields but only one of
them should be used to update table X.
Give me an example on a sql statement for this.

Sincerely

Roland S




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

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

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



**
The information contained in this communication is confidential and 
may be legally privileged. It is intended solely for the use of the 
individual or entity to whom it is addressed and others authorised to 
receive it. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking action in 
reliance of the contents of this information is strictly prohibited and 
may be unlawful. Mobil Rom is neither liable for the proper, complete 
transmission of the information contained in this communication nor 
any delay in its receipt.

**

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

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

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


Dennis:

Thanks for the advice.  Fortunately I am doing a DB conversion from IMS /
Lotus Notes to 8.1.7.  This is being done on a dedicated server which only I
have access to and there is no application software connected to it.  When I
finish the data conversion the data will be exported (for want of a better
word) to the production DB where it will be tested.  So, taking time do
something is not a problem. Currently the only data I have on the system
is a small lookup table.  So, the process would probably go rather quickly.

Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Altering Indexes

Ken - No, there isn't a magic single command. Moving the indexes, even with
alter index, cause a lot of work for Oracle, and can consume quite a bit of
time. As the typical cautious production DBA, I do not like to start a
really large monolithic process that might make my system unavailable to the
users for an unknown period of time. I would recommend that you use SQL to
create a script to alter the indexes. This will allow you to Pareto's rule
to do the many small indexes first, then work up to the larger indexes that
use increasing amounts of time. Also, I would recommend considering several
index tablespaces, maybe even moving the largest tables to their own
tablespace first.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

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

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

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


http://www.amazon.com/exec/obidos/ASIN/0070388687/qid=1006878161/sr=1-2/ref=
sr_1_14_2/002-3320998-2702448

-Original Message-
Sent: Tuesday, November 27, 2001 10:33 AM
To: '[EMAIL PROTECTED]'


Henry, this is a great post. All I can add of peripheral
interest is a pointer to a book called Efficient Memory Programming
or something like that. 

Absolutely the best presentation of CPU/cache dependencies i have seen. 

Makes you really think about cache behavior, CPU architecture, and all
these tools that say they crosscompile or run platform independently. 

when resources (time, memory, correctness, etc) are thin, a handcrafted
program by an architecture savvy programmer is often the best thing. 

thanks again, Henry.great stuff..


- Ross

















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


ok, as much as i think MS could use a major kick in the fundament, 

if you think of terminal server client as rsh client  (please no
niggling
corrections of the rough analogy!:-) then you'll not be so vexed at
the lack of functionality. 

Sad that this doesn't work, true, but...shrug...maybe in XP? YP? ZP?

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


Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not work. I used PC Anywhere, everything went fine.

HTH, 
Michael

From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

-- Original message --

OH MY GOSH this sucks.  

Is anyone running 8.1.7 EE on W2k?  I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error.  

I look on Metalink and it just plain says, Go to the console.  WHAT?  Are
you KIDDING!  Here's the note:

*   fact: Oracle Server - Enterprise Edition 
*   fact: RDBMS 
*   fact: MS Windows 2000 
*   fact: MS Windows NT 
*   symptom: Cannot connect to SVRMGRL 
*   symptom: ORA-12560: TNS:protocol adapter error 
*   symptom: Cannot connect to SVRMGR30 
*   symptom: ORA-12203: TNS:unable to connect to destination 
*   cause: Bequeath protocol is not supported with Microsoft Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i. 
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL. 

I can do this with W2k, Terminal Server and Standard Edition.  

Has anyone else seen this ? I am so irked I could scream.  (But it could be
the hormones). 

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






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

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

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



What will you be wearing?

a short presentation?

h.

I think I detect a level III Shrek alert



-Original Message-

This is a cross-dressing post folks...

so...unfortunately, Susan McClain will not be able to attend OOW, and
it now seems I AM presenting (where the heck did I put that skirt?)...
I will be giving her presentation for her Statspack on Monday (I think
at 11)

Be kind folks, I haven't even SEEN the paper or presentation yet, and I
haven't really worked with statspack much.

This means it will be a short presentation :)

I think they call this a challenge.  

Rachel

__
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: 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: Altering Indexes


Just a question off the wall here - kind of related:

Does anybody know why Oracle does NOT give the option to have a DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example)..
I know, I know it's just another thing to add to your syntax - but it would
be a FAR better way of doing things wouldn't it?

I would much prefer to say:

create user mark identified by beer
default table tablespace USER_DATA
quota 100 M on USER_DATA
default index tablespace USER_IDXS
quota 100 M on USER_IDXS
temporary tablespace TEMP;

as this totally takes away the nightmare of having them all created in one
single tablespace..

Anyone with an in with Oracle know the answer? Anyone care to speculate?
:

Cheers

Mark

-Original Message-
Sent: 27 November 2001 15:20
To: Multiple recipients of list ORACLE-L


You can't do it en-mass.  Why not write a script to do this.
select 'alter index '||index_name||' rebuild new_tbsp;'
from user_indexes;
or somthing similar.

Terry

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


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

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: 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: 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: v$session_wait

2001-11-27 Thread Baker, Barbara


seconds.
see page 32 of Gaja's Oracle Performance Tuning 101
The value of this column is STATE dependent and is measured in
seconds


 --
 From: Charlie Mengler[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Tuesday, November 27, 2001 8:20 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  v$session_wait
 
 One of the fields is WAIT_TIME   
 A non-zero value is the session's last wait time. 
 A zero value means the session is currently waiting 
 
 What are the units associated with this number?
 
 -- 
 Charlie Mengler  Maintenance Warehouse  
 [EMAIL PROTECTED] 10641 Scripps Summit Ct.
 858-831-2229 San Diego, CA 92131
 In life, sometimes you're the windshield; other times you're the bug!
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

RE: v$session_wait

2001-11-27 Thread Farnsworth, Dave


Charlie, 

WAIT_TIME is measured in seconds.  But in order for this to be so, you must
have the TIMED_STATISTICS parameter set to TRUE.

Dave

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


One of the fields is WAIT_TIME   
A non-zero value is the session's last wait time. 
A zero value means the session is currently waiting 

What are the units associated with this number?

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
In life, sometimes you're the windshield; other times you're the bug!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE:

2001-11-27 Thread Kimberly Smith


ControlIT (formally Remotely Possible) also works, regardless
of the fact its a CA product.

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


Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not work. I used PC Anywhere, everything went fine.

HTH, 
Michael

From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

-- Original message --

OH MY GOSH this sucks.  

Is anyone running 8.1.7 EE on W2k?  I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error.  

I look on Metalink and it just plain says, Go to the console.  WHAT?  Are
you KIDDING!  Here's the note:

*   fact: Oracle Server - Enterprise Edition 
*   fact: RDBMS 
*   fact: MS Windows 2000 
*   fact: MS Windows NT 
*   symptom: Cannot connect to SVRMGRL 
*   symptom: ORA-12560: TNS:protocol adapter error 
*   symptom: Cannot connect to SVRMGR30 
*   symptom: ORA-12203: TNS:unable to connect to destination 
*   cause: Bequeath protocol is not supported with Microsoft Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i. 
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL. 

I can do this with W2k, Terminal Server and Standard Edition.  

Has anyone else seen this ? I am so irked I could scream.  (But it could be
the hormones). 

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






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

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

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

2001-11-27 Thread DBarbour



Lisa,

Got bit by this first time out of the box with W2K.  I don't have access to
PCAnywhere, so I had to do the install from the console.  I have however
created a ton of .bat files that perform various functions that I can
execute from Terminal Services.  I found it necessary to use sqlplus with
the 'connect as' string, but it gets me in just fine.  If I don't have the
script do something completely (backup, startup, shutdown, analyze, etc), I
have a generic one that pops up a DOS Prompt screen and puts me at the SQL
prompt with sysdba privileges.  Here's how I've done it (Perl is still on
my list Jared):

First file is login.bat

set ORACLE_SID=SID    These are just for good measure,
Registry and Environment SHOULD suffice, but it's Windoze
set ORACLE_HOME=F:\oracle\ora81
sqlplus /nolog @F:\oracle\admin\system_scripts\sysconnect.sql
exit

Next file is sysconnect.sql

connect sys/password@SID as sysdba



That's it.  Go in through terminal services, run login.bat, and you're home
free.  Everything else follows.

Hope this helps.


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


   
   
Michael
   
Netrusov To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
michael@atelo   cc:   
   
.comSubject:  
   
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
11/27/2001 
   
10:25 AM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not work. I used PC Anywhere, everything went fine.

HTH,
Michael

From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

-- Original message --

OH MY GOSH this sucks.

Is anyone running 8.1.7 EE on W2k?  I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error.

I look on Metalink and it just plain says, Go to the console.  WHAT?  Are
you KIDDING!  Here's the note:

*  fact: Oracle Server - Enterprise Edition
*  fact: RDBMS
*  fact: MS Windows 2000
*  fact: MS Windows NT
*  symptom: Cannot connect to SVRMGRL
*  symptom: ORA-12560: TNS:protocol adapter error
*  symptom: Cannot connect to SVRMGR30
*  symptom: ORA-12203: TNS:unable to connect to destination
*  cause: Bequeath protocol is not supported with Microsoft
Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i.
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL.

I can do this with W2k, Terminal Server and Standard Edition.

Has anyone else seen this ? I am so irked I could scream.  (But it could be
the hormones).

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






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

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

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

RE: guess I'm presenting at OOW


with gas?

-Original Message-

snip

guess i'm just a big mean green DBA.;-)






























-- 
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: guess I'm presenting at OOW

2001-11-27 Thread Thater, William


On Tue, 27 Nov 2001,Mohan, Ross scribbled on the wall in glitter crayon:

-
-What will you be wearing?
-
-a short presentation?
-
-h.
-
-I think I detect a level III Shrek alert

nope, working for a bankrupt company means i don't get to go nowhere or learn
nothing.

guess i'm just a big mean green DBA.;-)


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

The number of UNIX installations has grown to 10, with more expected.  (6/72)


-- 
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: guess I'm presenting at OOW

2001-11-27 Thread Thater, William


On Tue, 27 Nov 2001,Mohan, Ross scribbled on the wall in glitter crayon:

-with gas?
nope, gas costs extra.;-)

-
--Original Message-
-From: Thater, William [mailto:[EMAIL PROTECTED]]
-
-snip
-
-guess i'm just a big mean green DBA.;-)


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

The number of UNIX installations has grown to 10, with more expected.  (6/72)


-- 
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: Altering Indexes

2001-11-27 Thread Taylor, Shirley

Wonderful idea, Mark. We have scores of users who create their own tables,
indexes etc since we are a scientific research institution. It's hard to get
users to put in that extra code to place the index in it's own tablespace.
Shirley

-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 27, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Altering Indexes

Just a question off the wall here - kind of related:

Does anybody know why Oracle does NOT give the option to have a
DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for
example)..
I know, I know it's just another thing to add to your syntax - but
it would
be a FAR better way of doing things wouldn't it?

I would much prefer to say:

create user mark identified by beer
default table tablespace USER_DATA
quota 100 M on USER_DATA
default index tablespace USER_IDXS
quota 100 M on USER_IDXS
temporary tablespace TEMP;

as this totally takes away the nightmare of having them all created
in one
single tablespace..

Anyone with an in with Oracle know the answer? Anyone care to
speculate?
:

Cheers

Mark

-Original Message-
Sent: 27 November 2001 15:20
To: Multiple recipients of list ORACLE-L

You can't do it en-mass.  Why not write a script to do this.
select 'alter index '||index_name||' rebuild new_tbsp;'
from user_indexes;
or somthing similar.

Terry

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

I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design).  Is there a way I can move all
of the
indexes to a separate tablespace en-mass?  I know I can move them
one at a
time with the alter index command, but that would be rather time
consuming.

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of

RE: ACM SIGMOD-papers of interest #1

2001-11-27 Thread Henry Poras


Thanks Ross. By the way, did you ever get The Art of Computer Systems
Performance Analysis?

Henry

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


http://www.amazon.com/exec/obidos/ASIN/0070388687/qid=1006878161/sr=1-2/ref=
sr_1_14_2/002-3320998-2702448

-Original Message-
Sent: Tuesday, November 27, 2001 10:33 AM
To: '[EMAIL PROTECTED]'


Henry, this is a great post. All I can add of peripheral
interest is a pointer to a book called Efficient Memory Programming
or something like that. 

Absolutely the best presentation of CPU/cache dependencies i have seen. 

Makes you really think about cache behavior, CPU architecture, and all
these tools that say they crosscompile or run platform independently. 

when resources (time, memory, correctness, etc) are thin, a handcrafted
program by an architecture savvy programmer is often the best thing. 

thanks again, Henry.great stuff..


- Ross

















-- 
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: checking users's password

2001-11-27 Thread Deborah Weatherspoon


Sorry for the delayed thanks... but things got hecked here.. Thank you
Michael Vergara and Brian...

 On Fri, 9 Nov 2001, Brian McGraw wrote:

 Funny, I wrote a perl script to do this same thing the other day.  It is a
 perl script, runs under UNIX, and not only checks for defaults, but the
 default Oracle passwords as well.
 
 I was kinda proud of it, so I thought I'd pass it along.  Not
 Jared-Still-Perl-Evangelist quality, but I'm happy.
 
 Brian
 
 Deborah Weatherspoon wrote:
 
  Hi Everyone,
 
  Can anyone provide/share with me a script that will check the users
  password against their username.  We are trying to verify that no one is
  using his/her username as the password.
 
  Thanks for any help
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Deborah Weatherspoon
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 --
 --
 | Brian McGraw -- Oracle DBA |
 | Central Alabama Oracle Users Group |
 ||
 | mailto:[EMAIL PROTECTED]  |
 | http://bmcgraw.home.mindspring.com |
 --
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deborah Weatherspoon
  INET: [EMAIL PROTECTED]

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

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

Oracle/UNIX vs. Oracle/NT

2001-11-27 Thread Paul Vallee


Hello everyone,

I'm certain that this is a FAQ, but I thought I would make a request here.

I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.

I wonder if anyone can link to or provide any of the following on this
subject:

* whitepapers
* platform selection papers
* pro/con summaries to management, no matter how informal

Please help in any way you can, thanks in advance,

Paul

---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

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

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

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


Mark Leith wrote:
 
 Just a question off the wall here - kind of related:
 
 Does anybody know why Oracle does NOT give the option to have a DEFAULT
 INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example)..
 I know, I know it's just another thing to add to your syntax - but it would
 be a FAR better way of doing things wouldn't it?
 
 I would much prefer to say:
 
 create user mark identified by beer
 default table tablespace USER_DATA
 quota 100 M on USER_DATA
 default index tablespace USER_IDXS
 quota 100 M on USER_IDXS
 temporary tablespace TEMP;
 
 as this totally takes away the nightmare of having them all created in one
 single tablespace..
 
 Anyone with an in with Oracle know the answer? Anyone care to speculate?
 :
 
 Cheers
 
 Mark
 

Mark,

   Good suggestion. As far as one usually finds more indices in the data
tablespace than the reverse, I have flirted with the idea of making the
tablespace devoted to indices the default one, but it's changing the
problem. But I have something to suggest :
 
 create user mark identified by beer
 default table tablespace SYSTEM
 quota 100 M on USER_DATA
 quota 100 M on USER_IDXS
 temporary tablespace TEMP;

 (assuming of course that you do not have the UNLIMITED TABLESPACE
privilege). My bet is that it won't take long before you remember to
always specify the tablespace, yek, yek, yek. In case using SYSTEM would
make you (understandably) uncomfortable, you can create say a 50K
BARELAND tablespace on which nobody has quotas.

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

Connection question?

2001-11-27 Thread Seema Singh


Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i 
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.

Thanks
Seema

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

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

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

Delete slowing..


Hi list people :)

We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..

Where would you start?

I have a few ideas of my own - like stale stats, small rollback segments
etc. - but am after some of your advice also before I get back to him
tomorrow morning.. Not sure on the Oracle version, OS, or even amount of
rows he is deleting or size of the table (yet, I'll find this out tomorrow),
but there has to be a pretty standard way of diagnosing this..

All help appreciated.

Mark

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


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

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

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

export/import questions

2001-11-27 Thread Seema Singh


Hi
If one of the tablespace in database is TRANSPORT TABLESPACE.I have full 
export with consistent=y and full=y.
Can I full import the database?
If yes then what will happened with transport tablespace?
In case of crash can I restore full database with full export?
The assumption is we don't have any other backup plan.
Thanks
Seema


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

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

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

RE: Delete slowing..

2001-11-27 Thread Mercadante, Thomas F


Mark,

check for foreign key/missing index combinations.  If the table is a parent
table, and it's child's foreign key's column is not indexed, the delete can
take *forever* if the child is a large table.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 27, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L


Hi list people :)

We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..

Where would you start?

I have a few ideas of my own - like stale stats, small rollback segments
etc. - but am after some of your advice also before I get back to him
tomorrow morning.. Not sure on the Oracle version, OS, or even amount of
rows he is deleting or size of the table (yet, I'll find this out tomorrow),
but there has to be a pretty standard way of diagnosing this..

All help appreciated.

Mark

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


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

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

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

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

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

Problem importing objects to different tablespace

2001-11-27 Thread George Hofilena


Guys,

I'd appreciate any help that I could get.

I was trying to import to another tablespace, same user.  I hadn't had a
need to do this in a while but thought this shouldn't be too difficult.  So
I did what the manuals said:

ran a user export
set user's quota on old tablespace to 0
granted unlimited quota to user on new tablespace
revoke resource, unlimited tablespace privs from user
make new tablespace default for user

Then when I ran the import with ignore=y I got the error space quota
exceeded for tablespace old tablespace for all create table commands.
Bottom line is, it didn't import the tables.
Reading the manuals and Metalink docs, the process looked really
straightforward.

Does anybody know of anything that I've missed?

Thanks,

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

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

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

Listers meeting at OOW

2001-11-27 Thread Jeremiah Wilton


To continue the discussion on getting together at Openworld:

How about Tuesday evening, around 7:00?

Someone who knows downtown SF want to suggest a place?  My preference
is not too loud or too smoky.

Call out on the list if you are going to come, so we can keep track of
how many chairs to steal from nearby tables.

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

-- 
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: Connection question?

2001-11-27 Thread Behar, Rivaldi

Title: RE: Connection question?





1. User connect to Oracle through Unix (for example telnet and then SQLPlus from Unix).
2. Client user.


HTH,
Rivaldi


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Connection question?



Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i 
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.


Thanks
Seema


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


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

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

RE: Oracle/UNIX vs. Oracle/NT

2001-11-27 Thread DENNIS WILLIAMS


Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
be more reliable, but there are strong NT shops that seem to keep their NT
reliability up, and would struggle with the odd Unix system. I assume that
you are really talking Windows 2000 at this point.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Hello everyone,

I'm certain that this is a FAQ, but I thought I would make a request here.

I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.

I wonder if anyone can link to or provide any of the following on this
subject:

* whitepapers
* platform selection papers
* pro/con summaries to management, no matter how informal

Please help in any way you can, thanks in advance,

Paul

---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

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

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

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

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

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

Re: Oracle/UNIX vs. Oracle/NT

2001-11-27 Thread Paul Vallee


Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating to NT. It seems like your argument would support sticking with
what they currently have.
Thanks,
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 2:10 PM


Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
be more reliable, but there are strong NT shops that seem to keep their NT
reliability up, and would struggle with the odd Unix system. I assume that
you are really talking Windows 2000 at this point.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Hello everyone,

I'm certain that this is a FAQ, but I thought I would make a request here.

I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.

I wonder if anyone can link to or provide any of the following on this
subject:

* whitepapers
* platform selection papers
* pro/con summaries to management, no matter how informal

Please help in any way you can, thanks in advance,

Paul

---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

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

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

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

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

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




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

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

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


Eric, are you going?

-Original Message-
Sent: Tuesday, November 27, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L


To continue the discussion on getting together at Openworld:

How about Tuesday evening, around 7:00?

Someone who knows downtown SF want to suggest a place?  My preference
is not too loud or too smoky.

Call out on the list if you are going to come, so we can keep track of
how many chairs to steal from nearby tables.

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

-- 
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).
-- 
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: Delete slowing..


Mark Leith wrote:
 
 Hi list people :)
 
 We have a customer who has been running a particular delete statement
 against a table for a while now, which usually ran within minutes. All of a
 sudden this table has suddenly gone from a few minutes right up to 50! He
 wants to diagnose why..
 
 Where would you start?
 
 I have a few ideas of my own - like stale stats, small rollback segments
 etc. - but am after some of your advice also before I get back to him
 tomorrow morning.. Not sure on the Oracle version, OS, or even amount of
 rows he is deleting or size of the table (yet, I'll find this out tomorrow),
 but there has to be a pretty standard way of diagnosing this..
 
 All help appreciated.
 
 Mark
 
 ===
  Mark Leith | T: +44 (0)1905 330 281
  Sales  Marketing  | F: +44 (0)870 127 5283
  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
 ===

'We have done nothing and suddenly it's slow' is a well known tune.
Usual suspects :
1) Stats, computed or deleted
2) Dropped index
3) Newly created trigger
4) Locks. Nobody doing DML on the same table during the delete ?
-- 
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: Checking DB Status in NT env.

2001-11-27 Thread mitchell


Hi

Is there any easy way for our operator to check db status on NT env. any
clue?


Mitchell

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

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

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

2001-11-27 Thread Rodd Holman


Paul,
If they want to save $$$ they could consider migrating to LINUX.  For a
UNIX shop it is a more logical migration than NT/2000.  Or, is their
idea to get rid of higher priced SA's in favor of NT
Admins which they think they should pay less?  In which case the outcome
is decided all ready.

Rodd Holman

On Tue, 2001-11-27 at 13:30, Paul Vallee wrote:
Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating to NT. It seems like your argument would support sticking with
what they currently have.
Thanks,
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 2:10 PM


Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
be more reliable, but there are strong NT shops that seem to keep their NT
reliability up, and would struggle with the odd Unix system. I assume that
you are really talking Windows 2000 at this point.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Hello everyone,

I'm certain that this is a FAQ, but I thought I would make a request here.

I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.

I wonder if anyone can link to or provide any of the following on this
subject:

* whitepapers
* platform selection papers
* pro/con summaries to management, no matter how informal

Please help in any way you can, thanks in advance,

Paul

---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

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

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

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

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

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




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

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

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

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

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

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

Terminal Server / svrmgrl

Title: Terminal Server / svrmgrl





ZP? As in Zip It? 


Just really really frustrating. 


Thanks Ross and Michael


Lisa


-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 


ok, as much as i think MS could use a major kick in the fundament, 


if you think of terminal server client as rsh client (please no
niggling
corrections of the rough analogy!:-) then you'll not be so vexed at
the lack of functionality. 


Sad that this doesn't work, true, but...shrug...maybe in XP? YP? ZP?


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



Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not work. I used PC Anywhere, everything went fine. 


HTH, 
Michael


From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]


-- Original message --


OH MY GOSH this sucks. 


Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error. 


I look on Metalink and it just plain says, Go to the console. WHAT? Are
you KIDDING! Here's the note:


* fact: Oracle Server - Enterprise Edition 
* fact: RDBMS 
* fact: MS Windows 2000 
* fact: MS Windows NT 
* symptom: Cannot connect to SVRMGRL 
* symptom: ORA-12560: TNS:protocol adapter error 
* symptom: Cannot connect to SVRMGR30 
* symptom: ORA-12203: TNS:unable to connect to destination 
* cause: Bequeath protocol is not supported with Microsoft Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i. 
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL. 


I can do this with W2k, Terminal Server and Standard Edition. 


Has anyone else seen this ? I am so irked I could scream. (But it could be
the hormones). 


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







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


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

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


George Hofilena wrote:
 
 Guys,
 
 I'd appreciate any help that I could get.
 
 I was trying to import to another tablespace, same user.  I hadn't had a
 need to do this in a while but thought this shouldn't be too difficult.  So
 I did what the manuals said:
 
 ran a user export
 set user's quota on old tablespace to 0
 granted unlimited quota to user on new tablespace
 revoke resource, unlimited tablespace privs from user
 make new tablespace default for user
 
 Then when I ran the import with ignore=y I got the error space quota
 exceeded for tablespace old tablespace for all create table commands.
 Bottom line is, it didn't import the tables.
 Reading the manuals and Metalink docs, the process looked really
 straightforward.
 
 Does anybody know of anything that I've missed?
 
 Thanks,
 
 George
 

Yes : a user cannot own two objects with the same name. The problem is
with keeping everything in the same schema. You should have dropped all
tables to be moved beforehand. Your message doesn't come from CREATE
commands, but INSERT commands (you are aloso likely to have a number of
duplicate rows if some of your tables had no unique index, PK or
otherwise, defined).

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

Revoke Delete

2001-11-27 Thread Aldi Barco


Hi Listers,

How can we revoke 'delete privilege' from the schema owner of the table and 
also from DBA ?
If it is not possible, can we set through trigger ?
Thanks.

Aldi

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

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

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

2001-11-27 Thread Ron Thomas



Also check for a delete trigger on the table.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]



   
 
[EMAIL PROTECTED] 
 
tate.ny.usTo: [EMAIL PROTECTED] 
 
Sent by:  cc:  
 
[EMAIL PROTECTED]Subject: RE: Delete slowing..
 
om 
 
   
 
   
 
11/27/01 12:30 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Mark,

check for foreign key/missing index combinations.  If the table is a parent
table, and it's child's foreign key's column is not indexed, the delete can
take *forever* if the child is a large table.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 27, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L


Hi list people :)

We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..

Where would you start?

I have a few ideas of my own - like stale stats, small rollback segments
etc. - but am after some of your advice also before I get back to him
tomorrow morning.. Not sure on the Oracle version, OS, or even amount of
rows he is deleting or size of the table (yet, I'll find this out tomorrow),
but there has to be a pretty standard way of diagnosing this..

All help appreciated.

Mark

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


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

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

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

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

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




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

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

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

2001-11-27 Thread MacGregor, Ian A.


The idea is wonderful and also very old.  It was one of the first enhancement requests 
submitted.  As far as I can tell Oracle has never shown an interest in it.  Indeed it 
appears to be going the other way.  Take LOB's for instance.  You can place the LOB 
segment in a separate tablespace from the rest of the table's data, but the lob_index 
is going to go in the same tablespace as the lob_segment.  The documentation states: 

This clause [lob_index] is deprecated as of Oracle8i.  Oracle generates an index for 
each LOB column. Oracle names and manages the LOB indexes internally.  Although it is 
still possible for you to specify this clause, Oracle Corporation strongly recommends 
that you no longer do so.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 27, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


Wonderful idea, Mark. We have scores of users who create their own tables,
indexes etc since we are a scientific research institution. It's hard to get
users to put in that extra code to place the index in it's own tablespace.
Shirley

-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 27, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Altering Indexes

Just a question off the wall here - kind of related:

Does anybody know why Oracle does NOT give the option to have a
DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for
example)..
I know, I know it's just another thing to add to your syntax - but
it would
be a FAR better way of doing things wouldn't it?

I would much prefer to say:

create user mark identified by beer
default table tablespace USER_DATA
quota 100 M on USER_DATA
default index tablespace USER_IDXS
quota 100 M on USER_IDXS
temporary tablespace TEMP;

as this totally takes away the nightmare of having them all created
in one
single tablespace..

Anyone with an in with Oracle know the answer? Anyone care to
speculate?
:

Cheers

Mark

-Original Message-
Sent: 27 November 2001 15:20
To: Multiple recipients of list ORACLE-L


You can't do it en-mass.  Why not write a script to do this.
select 'alter index '||index_name||' rebuild new_tbsp;'
from user_indexes;
or somthing similar.

Terry

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


I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design).  Is there a way I can move all
of the
indexes to a separate tablespace en-mass?  I know I can move them
one at a
time with the alter index command, but that would be rather time
consuming.

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

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

RE: Connection question?

Title: RE: Connection question?





One is LOCAL=YES and one is LOCAL=NO


One is Local, one isn't. 


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



-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Connection question?


Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i 
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.


Thanks
Seema


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


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

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

RE: Altering Indexes


I thought that, given 

disks with 256KB to 4M of ondisk cache
and
disk arrays with another 1M-16M of cache
and
storage boxes like EMC,Hitachi, etc with up to 16 GB of CACHE
and
the UBC
and
the Oracle BC
and
Henry Poras' recent post
that

tables and indexes in the same tspace didn't matter quite as much
as it did when I was a youngster?


Not that it doesn't matter, just that it's not in the Top Three Evildoers
List
anymore. 

- ross

-Original Message-
Sent: Tuesday, November 27, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


The idea is wonderful and also very old.  It was one of the first
enhancement requests submitted.  As far as I can tell Oracle has never shown
an interest in it.  Indeed it appears to be going the other way.  Take LOB's
for instance.  You can place the LOB segment in a separate tablespace from
the rest of the table's data, but the lob_index is going to go in the same
tablespace as the lob_segment.  The documentation states: 

This clause [lob_index] is deprecated as of Oracle8i.  Oracle generates an
index for each LOB column. Oracle names and manages the LOB indexes
internally.  Although it is still possible for you to specify this clause,
Oracle Corporation strongly recommends that you no longer do so.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 27, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


Wonderful idea, Mark. We have scores of users who create their own tables,
indexes etc since we are a scientific research institution. It's hard to get
users to put in that extra code to place the index in it's own tablespace.
Shirley

-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 27, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Altering Indexes

Just a question off the wall here - kind of related:

Does anybody know why Oracle does NOT give the option to have a
DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for
example)..
I know, I know it's just another thing to add to your syntax - but
it would
be a FAR better way of doing things wouldn't it?

I would much prefer to say:

create user mark identified by beer
default table tablespace USER_DATA
quota 100 M on USER_DATA
default index tablespace USER_IDXS
quota 100 M on USER_IDXS
temporary tablespace TEMP;

as this totally takes away the nightmare of having them all created
in one
single tablespace..

Anyone with an in with Oracle know the answer? Anyone care to
speculate?
:

Cheers

Mark

-Original Message-
Sent: 27 November 2001 15:20
To: Multiple recipients of list ORACLE-L


You can't do it en-mass.  Why not write a script to do this.
select 'alter index '||index_name||' rebuild new_tbsp;'
from user_indexes;
or somthing similar.

Terry

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


I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design).  Is there a way I can move all
of the
indexes to a separate tablespace en-mass?  I know I can move them
one at a
time with the alter index command, but that would be rather time
consuming.

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

RE: Listers meeting at OOW

2001-11-27 Thread Molina, Gerardo


Chevy's at Howard and 3rd is a good spot.  I'll probably be attending only
the vendor exhibits but I'll try to make the list get-together.

Gerardo

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


To continue the discussion on getting together at Openworld:

How about Tuesday evening, around 7:00?

Someone who knows downtown SF want to suggest a place?  My preference
is not too loud or too smoky.

Call out on the list if you are going to come, so we can keep track of
how many chairs to steal from nearby tables.

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

-- 
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).
-- 
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: Oracle/UNIX vs. Oracle/NT

2001-11-27 Thread Mercadante, Thomas F


Paul,

I think Dennis makes a great point here.  If your organization thinks that
they can save money by switching hardware, you should point out that all of
the Unix admins will need NT Admin classes as part of the migration to the
new environment.

As I've said in the past, a well-maintained professionally administered NT
platform works just fine for most Oracle OLTP applications.  

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 27, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L


Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating to NT. It seems like your argument would support sticking with
what they currently have.
Thanks,
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 2:10 PM


Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
be more reliable, but there are strong NT shops that seem to keep their NT
reliability up, and would struggle with the odd Unix system. I assume that
you are really talking Windows 2000 at this point.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Hello everyone,

I'm certain that this is a FAQ, but I thought I would make a request here.

I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.

I wonder if anyone can link to or provide any of the following on this
subject:

* whitepapers
* platform selection papers
* pro/con summaries to management, no matter how informal

Please help in any way you can, thanks in advance,

Paul

---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

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

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

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

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

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




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

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

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

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

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

Re: Oracle/UNIX vs. Oracle/NT

2001-11-27 Thread Dennis M. Heisler


If they're currently a unix shop and want to save money, why not suggest
Linux?  It will run on the same hardware as Windows, and they can
leverage their existing unix experience.


Dennis


Paul Vallee wrote:
 
 Actually, Dennis, it's currently a UNIX shop considering saving money by
 migrating to NT. It seems like your argument would support sticking with
 what they currently have.
 Thanks,
 Paul
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, November 27, 2001 2:10 PM
 
 Paul - What is the base of experience in this shop? Is it primarily an NT
 shop and the Unix system is the odd one, or is it primarily a Unix shop and
 the NT conversion would be a first plunge? Everything I hear depends
 primarily on this factor. Most indications are that the Unix systems tend to
 be more reliable, but there are strong NT shops that seem to keep their NT
 reliability up, and would struggle with the odd Unix system. I assume that
 you are really talking Windows 2000 at this point.
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]

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

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

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

Script to Disable Constraint, Change Value, then Enable Constrain

2001-11-27 Thread David Wagoner









Listers,



Does anyone have a script that will do the following:




 Accept
 user input for old data value
 Accept
 user input for new data value
 Disable
 table constraint
 Update
 record with new data value
 Enable
 constraint




A script like this would help ensure that constraints are not left off
after updates, allowing illegal data into the tables. Good user-proof script I would think.





TIA,



david



David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide Inc.

4815 Emperor
Blvd., Suite 110

Durham, NC
27703

Tel. (919)
941-4645

Fax (919)
474-0735

Email mailto:[EMAIL PROTECTED]

Web http://www.arsenaldigital.com/




*** NOTICE ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, 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 the sender at (919) 941-4645 and delete this e-mail message
from your computer. Thank you.

RE: SVRMGRL and W2K

Title: RE: SVRMGRL and W2K





Thanks David!!


Lisa


-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SVRMGRL and W2K



Lisa,


Got bit by this first time out of the box with W2K. I don't have access to
PCAnywhere, so I had to do the install from the console. I have however
created a ton of .bat files that perform various functions that I can
execute from Terminal Services. I found it necessary to use sqlplus with
the 'connect as' string, but it gets me in just fine. If I don't have the
script do something completely (backup, startup, shutdown, analyze, etc), I
have a generic one that pops up a DOS Prompt screen and puts me at the SQL
prompt with sysdba privileges. Here's how I've done it (Perl is still on
my list Jared):


First file is login.bat


set ORACLE_SID=SID  These are just for good measure,
Registry and Environment SHOULD suffice, but it's Windoze
set ORACLE_HOME=F:\oracle\ora81
sqlplus /nolog @F:\oracle\admin\system_scripts\sysconnect.sql
exit


Next file is sysconnect.sql


connect sys/password@SID as sysdba




That's it. Go in through terminal services, run login.bat, and you're home
free. Everything else follows.


Hope this helps.



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



 
 Michael 
 Netrusov To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
 michael@atelo cc: 
 .com Subject: 
 Sent by: 
 [EMAIL PROTECTED] 
 om 
 
 
 11/27/2001 
 10:25 AM 
 Please respond 
 to ORACLE-L 
 
 





Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not work. I used PC Anywhere, everything went fine.


HTH,
Michael


From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]


-- Original message --


OH MY GOSH this sucks.


Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error.


I look on Metalink and it just plain says, Go to the console. WHAT? Are
you KIDDING! Here's the note:


* fact: Oracle Server - Enterprise Edition
* fact: RDBMS
* fact: MS Windows 2000
* fact: MS Windows NT
* symptom: Cannot connect to SVRMGRL
* symptom: ORA-12560: TNS:protocol adapter error
* symptom: Cannot connect to SVRMGR30
* symptom: ORA-12203: TNS:unable to connect to destination
* cause: Bequeath protocol is not supported with Microsoft
Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i.
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL.


I can do this with W2k, Terminal Server and Standard Edition.


Has anyone else seen this ? I am so irked I could scream. (But it could be
the hormones).


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







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


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

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





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


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

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

RE: Oracle/UNIX vs. Oracle/NT

2001-11-27 Thread DENNIS WILLIAMS


Paul - then I would check for a paper from a Unix vendor that discusses
total cost of ownership. A good place to start might be the Sun Web site
since Sun is the major Unix vendor that doesn't offer NT systems. Start
looking at the cost of downtime for your organization. Then there is the
cost of retraining your system administrators to the point that they can
handle NT well. I think that is where most organizations like yours end up
with unhappy NT experiences, they neglect to bring their staff up to
standards, feeling it is just a Windows system, and therefore anyone can
keep it running. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, November 27, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating to NT. It seems like your argument would support sticking with
what they currently have.
Thanks,
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 2:10 PM


Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
be more reliable, but there are strong NT shops that seem to keep their NT
reliability up, and would struggle with the odd Unix system. I assume that
you are really talking Windows 2000 at this point.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Hello everyone,

I'm certain that this is a FAQ, but I thought I would make a request here.

I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.

I wonder if anyone can link to or provide any of the following on this
subject:

* whitepapers
* platform selection papers
* pro/con summaries to management, no matter how informal

Please help in any way you can, thanks in advance,

Paul

---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

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

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

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

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

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




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

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

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

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

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

Re: Revoke Delete

2001-11-27 Thread Paul Baumgartel


You can't revoke the ability to delete from the schema owner.  You
could revoke CREATE SESSION from the schema owner, but that doesn't
solve the problem of DBA-privileged accounts being able to delete.

I'm guessing that this is a perfect opportunity to use an INSTEAD OF
trigger.


--- Aldi Barco [EMAIL PROTECTED] wrote:
 Hi Listers,
 
 How can we revoke 'delete privilege' from the schema owner of the
 table and 
 also from DBA ?
 If it is not possible, can we set through trigger ?
 Thanks.
 
 Aldi
 
 _
 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: Aldi Barco
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

RE: svrmgrl and W2k

2001-11-27 Thread Jack C. Applewhite

Title: svrmgrl and W2k



Lisa,

I'm 
running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time 
via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl 
using internal@test or internal@dev. Works just fine.Am I 
missing part of the problem?

Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Tuesday, November 27, 2001 9:25 AMTo: Multiple recipients of list 
  ORACLE-LSubject: svrmgrl and W2k
  OH MY GOSH this sucks. 
  Is anyone running 8.1.7 EE on W2k? I am trying to 
  start the database (and the listener, for that matter) via Terminal Server and 
  it keeps erring out with ORA-12560 protocol adapter error. 
  I look on Metalink and it just plain says, Go to the 
  console. WHAT? Are you KIDDING! Here's the note: 
  

  fact: Oracle Server - Enterprise Edition 
  
  fact: RDBMS 
  fact: MS Windows 2000 
  fact: MS Windows NT 
  symptom: Cannot connect to SVRMGRL 

  symptom: ORA-12560: TNS:protocol adapter 
  error 
  symptom: Cannot connect to SVRMGR30 
  
  symptom: ORA-12203: TNS:unable to connect 
  to destination 
  cause: Bequeath protocol is not supported 
  with Microsoft Terminal Server Client. ORA-12203 is seen on Oracle 8.0.6. 
  ORA-12560 is seen on Oracle8i. 
  fix: Connecting to SVRMGRL is done by using 
  the BEQUEATH protocol which is not available using an MS Windows 2000 Terminal 
  Server Client. To startup the instance, use the the Windows 2000 console to 
  connect to the SVRMGRL. 
  I can do this with W2k, Terminal Server and Standard 
  Edition. 
  Has anyone else seen this ? I am so irked I could 
  scream. (But it could be the hormones). 
  Lisa Koivu Oracle Database 
  Monkey. Fairfield Resorts, Inc. 954-935-4117

RE: Delete slowing..

Title: RE: Delete slowing..





Mark, how many indexes are on the table? Are there any unindexed foreign keys? 


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



-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Delete slowing..


Hi list people :)


We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..


Where would you start?


I have a few ideas of my own - like stale stats, small rollback segments
etc. - but am after some of your advice also before I get back to him
tomorrow morning.. Not sure on the Oracle version, OS, or even amount of
rows he is deleting or size of the table (yet, I'll find this out tomorrow),
but there has to be a pretty standard way of diagnosing this..


All help appreciated.


Mark


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



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


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

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

RE: Problem importing objects to different tablespace

2001-11-27 Thread Feng, Jun


The default tablespace is only used whenever there is no tablesapce
parameter in the crate and alter table/index statements. Since the export
always have tablespace parameter with the create table/index statement, your
import method definitely will fail. You can change the tablespace for the
segment by creating the segment in the desired tablesapce first, then
import.

Jun

-Original Message-
Sent: Tuesday, November 27, 2001 2:05 PM
To: Multiple recipients of list ORACLE-L


Guys,

I'd appreciate any help that I could get.

I was trying to import to another tablespace, same user.  I hadn't had a
need to do this in a while but thought this shouldn't be too difficult.  So
I did what the manuals said:

ran a user export
set user's quota on old tablespace to 0
granted unlimited quota to user on new tablespace
revoke resource, unlimited tablespace privs from user
make new tablespace default for user

Then when I ran the import with ignore=y I got the error space quota
exceeded for tablespace old tablespace for all create table commands.
Bottom line is, it didn't import the tables.
Reading the manuals and Metalink docs, the process looked really
straightforward.

Does anybody know of anything that I've missed?

Thanks,

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

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

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

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

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


set what, precisely, through a trigger?

Geez, if you have a DBA and/or a schema owner that can't/shouldn't be 
deleting from a table, what you have is NOT a database problem, it's
an HR problem. 

sheesh. 

yea, how about this? an BEFORE DELETE trigger on the table, saving and
repopulating each row the Evil DBA deleted, and logging his Evil Actions
in the Military Audit table, so that the Evildoer can be brought to justice?

Yea, that's the ticket, that's printable in Dilbert. 


In peace, love, data, and triggers, 

- The Evil One


-Original Message-

Hi Listers,

How can we revoke 'delete privilege' from the schema owner of the table and 
also from DBA ?
If it is not possible, can we set through trigger ?
Thanks.

Aldi














-- 
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: Re: ACM SIGMOD-papers of interest #1

2001-11-27 Thread Greg Moore


 Where can I get a copy of
  Scaling Oracle 8i please

It's a book.



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

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

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

2001-11-27 Thread Joe Raube


sqlldr is not a sqlplus command - it needs to be called
from the OS command line.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 5:00 PM


 I am in sql*plus (8.1.7) logged in as sys.  When I try running sqlldr at
 the command prompt I get this error:

 SP2-0042:  unknown command sqlldr - rest of line ignored.

 I'm calling it from my client PC and the DB is located on a separate
server.

 How do I get this to work?
 --
 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: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

RE: Connection question?

2001-11-27 Thread Deepak Thapliyal


hey lisa

Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i thought until now ;)

thoughts ..?

Thx
Deepak
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
 One is LOCAL=YES and one is LOCAL=NO
 
 One is Local, one isn't. 
 
 Lisa Koivu
 Oracle Database Monkey
 Fairfield Resorts, Inc.
 954-935-4117
 
 
  -Original Message-
  From:   Seema Singh [SMTP:[EMAIL PROTECTED]]
  Sent:   Tuesday, November 27, 2001 1:05 PM
  To: Multiple recipients of list ORACLE-L
  Subject:Connection question?
  
  Hi
  WHen I execute ps -ef |grep LOCAL on Solaris
 server the following output i
  
  see in
 
 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
  What is the diffrence between 1 and 2.
  
  Thanks
  Seema
  
 

_
  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: Seema Singh
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


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


__
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: Checking DB Status in NT env.

Title: RE: Checking DB Status in NT env.





Yea. Connect to the database. If you can connect quickly, you can be sure that most everything is OK. 


Lisa Koivu
Oracle Database Monkey Mama with the Big Wide Booty.
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From: mitchell [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 2:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Checking DB Status in NT env.


Hi


Is there any easy way for our operator to check db status on NT env. any
clue?



Mitchell


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


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

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

unzip utility information

2001-11-27 Thread hari babu gottipati



hi
friends if anyone knows about the unzip command in solaris 2.6/2.7 .please mail 
me.ex.OEM204_1.zip file.and i am not getting  unzip command  by using  man pages.can i 
needed to down load any unzip file.
pl. mail command as early
thanking to all
 

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

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

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

2001-11-27 Thread George Hofilena


All the objects are dropped beforehand.  The import is done on a clean
slate.  I just put in the ignore=y because that's what the docs suggested
and I was half hoping it'll drive the space quota exceeded... error away
:)

George

-Original Message-
Sent: Tuesday, November 27, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L


George Hofilena wrote:
 
 Guys,
 
 I'd appreciate any help that I could get.
 
 I was trying to import to another tablespace, same user.  I hadn't had a
 need to do this in a while but thought this shouldn't be too difficult.
So
 I did what the manuals said:
 
 ran a user export
 set user's quota on old tablespace to 0
 granted unlimited quota to user on new tablespace
 revoke resource, unlimited tablespace privs from user
 make new tablespace default for user
 
 Then when I ran the import with ignore=y I got the error space quota
 exceeded for tablespace old tablespace for all create table commands.
 Bottom line is, it didn't import the tables.
 Reading the manuals and Metalink docs, the process looked really
 straightforward.
 
 Does anybody know of anything that I've missed?
 
 Thanks,
 
 George
 

Yes : a user cannot own two objects with the same name. The problem is
with keeping everything in the same schema. You should have dropped all
tables to be moved beforehand. Your message doesn't come from CREATE
commands, but INSERT commands (you are aloso likely to have a number of
duplicate rows if some of your tables had no unique index, PK or
otherwise, defined).

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

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

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

2001-11-27 Thread Connor McDonald


You just open up with:

This is statspack.  You install it with spcreate,
collect stats with a pl/sql call, and report with
spreport.sql.  Then you interpret the myriad the
results - but of course, that is a tuning discussion
not a statspack one...Questions anyone?

:-)

 --- Rachel Carmichael [EMAIL PROTECTED] wrote:
 This is a cross post folks...
 
 so...unfortunately, Susan McClain will not be able
 to attend OOW, and
 it now seems I AM presenting (where the heck did I
 put that skirt?)...
 I will be giving her presentation for her Statspack
 on Monday (I think
 at 11)
 
 Be kind folks, I haven't even SEEN the paper or
 presentation yet, and I
 haven't really worked with statspack much.
 
 This means it will be a short presentation :)
 
 I think they call this a challenge.  
 
 Rachel
 
 __
 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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music 
Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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


I am in sql*plus (8.1.7) logged in as sys.  When I try running sqlldr at
the command prompt I get this error:

SP2-0042:  unknown command sqlldr - rest of line ignored.

I'm calling it from my client PC and the DB is located on a separate server.

How do I get this to work?
-- 
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: Delete slowing..