date:20020610

Title: RE: Complex Integrity Checking






Sorry for the delayed reply (I type with 2 fingers.) The section starts on page 685.



 rip 

Database Changes

Now, this is were things get interesting - database changes. Here, things can get a little murky. Database changes made, but not yet committed by a parent transaction are not visible to the autonomous transactions. Changes made, and already committed by the parent transaction, are always visible to the child transaction. Changes made by the autonomous transaction may or may not be visible to the parent depending on its isolation level.

I said before though, that this is were things get murky. I was pretty clear above in saying that changes made by the parent transaction are not visible to the child but that's not 100 percent of the story. A cursor opened by the child autonomous transaction will not see uncommitted changes, but a cursor opened by the parent and fetched from the child will. The following case shows how this works. We will recreate our EMP ..

 end rip 


The rest of the section demonstrates the voodoo magic. I confess that we didn't go this route and used the global array in a PL/SQL package, and the author discourages the use of autonomous transactions to get around mutating table errors. But it might be just right for someone's need.

Regards,


Tony Aponte




-Original Message-

From: Khedr, Waleed [mailto: 

Sent: Thursday, June 06, 2002 12:08 PM

To: Multiple recipients of list ORACLE-L

Subject: RE: Complex Integrity Checking



I could not find this and do not know how it could happen! 


If you can post here what you read, it will be appreciated.


Waleed


-Original Message-

To: [EMAIL PROTECTED]

Cc: [EMAIL PROTECTED]

Sent: 6/6/02 9:26 AM


Waleed,



The chapter on Autonomous transactions demonstrates how to give the

child transaction the ability to see uncommitted changes made by the

parent transaction.



Regards,



Tony Aponte


-Original Message-

Sent: Wednesday, June 05, 2002 9:03 PM

To: Multiple recipients of list ORACLE-L



The problem with this solution is the Autonomous Transactions will not

be able to see any changes done within the current transaction only the

committed one. So no way to enforce business logic during the context of

the transaction. 



This is why I asked before how frequently commit happens.



Regards,



Waleed


-Original Message-

Sent: Wednesday, June 05, 2002 6:33 PM

To: Multiple recipients of list ORACLE-L




With the introduction of Autonomous Transactions this is no longer

entirely true. If you call an autonomous transaction procedure, it is

executed in a separate transaction context. This gives you the ability

to probe the mutating table without inducing the error. A good

explanation can be found in Tom Kyte's Export One-on-one Oracle book in

the chapter on Autonomous Transactions.


HTH 

Tony Aponte 


-Original Message- 

mailto:[EMAIL PROTECTED] ] 

Sent: Wednesday, June 05, 2002 9:24 AM 

To: Multiple recipients of list ORACLE-L 



no matter what you do, if you access table A inside a trigger on table

A, 

oracle will give you mutating table error. What you could (and I really

mean 

you have to consider your business logic here) is go ahead and insert

the 

rows with a temp flag. As soon as you commit, fire up a procedure that

will 

do the scan on the table and delete appropriate rows which have the temp


status. 



BTW how big is this table? What is the frequency of inserts and updates?



Raj 

__ 

Rajendra Jamadagni MIS, ESPN Inc. 

Rajendra dot Jamadagni at ESPN dot com 

Any opinion expressed here is personal and doesn't reflect that of ESPN

Inc. 


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


-- 

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

-- 

Author: Khedr, Waleed

 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051

San Diego, California -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(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: set command

2002-06-10 Thread Weaver, Walt

Title: RE: set command




How 
about set linesize?

--Walt 
Weaver
 
Bozeman, Montana

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 
  7:58 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: set command
  Guys, 
  Building scripts from SQL generating SQL in Oracle on 
  Unix. I know that there are set commands so that Oracle does not put CR 
  or LF in the middle of a long command. Does anyone know these off the 
  top of their head?
  Thanks, Paula 
  set array...? set maxdata...?

RE: Large enqueue waits.

2002-06-10 Thread Freeman, Robert


Did you look to see if you had any blocking locks occurring at this time?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's covered in third degree burns, and your foot's caught in a bear
trap, you tend to start talkin' crazy.



-Original Message-
Sent: Monday, June 10, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L


Hi to you all,

High enqueue locks.
This morning before I got to work there were a group of users who
appeared to be hanging at times when they should have been performing
updates to certain tables.
I tracked it down to what I suspect is high enqueue lock times. [details are
below. I don't normally see enqueue high in v$session_event or
v$system_event].
I've used Steve's scripts enqueue_locks.sql and enqueue_stats.sql but they
don't tell me anything that I can understand  :-(
By now the sessions that were affected have logged out or been
terminated, so I can't put a 10046 level 8 trace on them. 

Can I see what the enqueue waits were referring to?

Thanks in advance,
Mike.

Details of findings:

  1  select event, s.username , time_waited/100,total_waits, total_timeouts

  2  from v$session_event e, v$session s

  3  where s.sid= e.sid

  4  and time_waited  100

  5  and event like '%enq%'

  6* order by time_waited desc  ;
  Total 
Event  USERNAME   TIME_WAITED/100 Waits Timeout 
-- -- --- - --- 
enqueueA 5498.45  17871787

enqueueB  3505.52  11401140

enqueueC  3303.44  10781071

enqueueD209.8969  69

enqueueE  63.2921
21 
enqueueF  16.1714
4 
6 rows selected.


and using Steve's resource_waiters script:
SQL @resource_waiters
Event name [buffer busy waits] enqueue
 SID PROGRAMTIME_WAITED AVERAGE_WAIT
 -- --- 
 All Disconnected Sessions  7720431   306.021346
  78 f45run@scc-corp01 (TNS V1-V2)2098920989
ARC0 oracle@scc-corp01 (ARC0) 2  .25


 1  select * from v$system_event
 2  where time_waited  0
 3* order by time_waited desc ;
  Total  Time Waitd
Average 
Event Waits Timeout   In Hndrds
Time 
- - --- ---
--- 
SQL*Net message from client   #   0  3271701695
30.397 
rdbms ipc message   1875169  819790   422614554
225.374 
slave wait  2213312 ###   167923522
75.870 
pipe get 260819  249480   126637278
485.537 
pmon timer   277326  27729385337384
307.715 
smon timer 2783277685322173
30658.345 
enqueue   25297   25128 7741422
306.021 
db file sequential read48265252   0 5125270
.106 
io done  820132   22440 2847667
3.472 
db file scattered read  1677976   0 1585987
.945 
log file parallel write  575601   2 1276956
2.218 
log file sync3474011089  922192
2.655 


Mike Jenner
Database Administrator

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail

Re: Large enqueue waits.

2002-06-10 Thread Jared Still



Mike,

Enqueues are locks on database objects.

When it happens again, you can check to see
what objects are being waited on.

select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.wait_time,
e.seconds_in_wait,
e.state
from v$session s, v$session_wait e
where s.username is not null
and s.sid = e.sid
-- skip sqlnet idle session messages
and e.event not like '%message from client'
order by s.username, upper(e.event)
/

Jared



On Monday 10 June 2002 07:43, Jenner Mike wrote:
 Hi to you all,

 High enqueue locks.
   This morning before I got to work there were a group of users who
 appeared to be hanging at times when they should have been performing
 updates to certain tables.
 I tracked it down to what I suspect is high enqueue lock times. [details
 are below. I don't normally see enqueue high in v$session_event or
 v$system_event].
 I've used Steve's scripts enqueue_locks.sql and enqueue_stats.sql but they
 don't tell me anything that I can understand  :-(
   By now the sessions that were affected have logged out or been
 terminated, so I can't put a 10046 level 8 trace on them.

 Can I see what the enqueue waits were referring to?

 Thanks in advance,
 Mike.

 Details of findings:

   1  select event, s.username , time_waited/100,total_waits, total_timeouts

   2  from v$session_event e, v$session s

   3  where s.sid= e.sid

   4  and time_waited  100

   5  and event like '%enq%'

   6* order by time_waited desc  ;
   Total
 Event  USERNAME   TIME_WAITED/100 Waits Timeout
 -- -- --- - ---
 enqueueA   5498.45  17871787

 enqueueB  3505.52  11401140

 enqueueC  3303.44  10781071

 enqueueD209.8969 
 69

 enqueueE  63.2921
 21
 enqueueF  16.1714
 4
 6 rows selected.


 and using Steve's resource_waiters script:
 SQL @resource_waiters
 Event name [buffer busy waits] enqueue
  SID PROGRAMTIME_WAITED AVERAGE_WAIT
  -- --- 
  All Disconnected Sessions  7720431   306.021346
   78 f45run@scc-corp01 (TNS V1-V2)2098920989
 ARC0 oracle@scc-corp01 (ARC0) 2  .25


  1  select * from v$system_event
  2  where time_waited  0
  3* order by time_waited desc ;
   Total  Time Waitd
 Average
 Event Waits Timeout   In Hndrds
 Time
 - - --- ---
 ---
 SQL*Net message from client   #   0  3271701695
 30.397
 rdbms ipc message   1875169  819790   422614554
 225.374
 slave wait  2213312 ###   167923522
 75.870
 pipe get 260819  249480   126637278
 485.537
 pmon timer   277326  27729385337384
 307.715
 smon timer 2783277685322173
 30658.345
 enqueue   25297   25128 7741422
 306.021
 db file sequential read48265252   0 5125270
 .106
 io done  820132   22440 2847667
 3.472
 db file scattered read  1677976   0 1585987
 .945
 log file parallel write  575601   2 1276956
 2.218
 log file sync3474011089  922192
 2.655


 Mike Jenner
 Database Administrator
-- 
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).

SHARED SERVERS

2002-06-10 Thread Seema Singh


Hi
I am wondering one of my database shared server process is taking much 
CPU.Let me know what could be reasons please?I added 2 more shared servers 
but still first shared server process is taking upto 25% of CPU?
Any suggestion for prevention would be great.
Thx
-Seema



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

9iR1 to 9iR2 Upgrade Bug

2002-06-10 Thread Freeman, Robert


All,

I've been away for a week or so. I don't see this mentioned here, if it has
been please forgive the repeat.

If you migrated a database from 8i to 9iR1, and are now looking at migrating
to 9iR2, you need to review note 197737.1 on Metalink for a nasty bug that
might be waiting
for you. If you are using multiple freelist groups, this bug will impact
you.
Basically, there is a patch you need to apply to the RDBMS before you
begin to do your upgrade.

RF


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's covered in third degree burns, and your foot's caught in a bear
trap, you tend to start talkin' crazy.



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

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

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

Title: RE: Complex Integrity Checking



I once 
had an instructor that said "a test is worth a thousand pages of 
documentation." If you have access to the book, give the sample a 
try. 

Regards,

Tony 
Aponte

  -Original Message-From: Khedr, Waleed 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 11:29 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Complex Integrity Checking
  Again I do not 
  see anything here saying that the child session (Autonomous TX) will see the 
  changes made by the parent TX.
  
  If you implied 
  this in your message, then we are in agreement.
  
  regards,
  
  Waleed
  
-Original Message-From: Aponte, Tony 
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 10:16 
AMTo: [EMAIL PROTECTED]Cc: 
[EMAIL PROTECTED]Subject: RE: Complex Integrity 
Checking
Sorry for the delayed reply (I type with 2 fingers.) 
The section starts on page 685. 
 rip  Database Changes Now, this is were things get 
interesting - database changes. Here, things can get a little 
murky. Database changes made, but not yet committed by a parent 
transaction are not visible to the autonomous transactions. Changes 
made, and already committed by the parent transaction, are always visible to 
the child transaction. Changes made by the autonomous transaction may 
or may not be visible to the parent depending on its isolation 
level.
I said before though, that this is were things get 
murky. I was pretty clear above in saying that changes made by the 
parent transaction are not visible to the child but that's not 100 percent 
of the story. A cursor opened by the child autonomous transaction will 
not see uncommitted changes, but a cursor opened by the parent and fetched 
from the child will. The following case shows how this works. We 
will recreate our EMP ..
 end rip  
The rest of the section demonstrates the voodoo magic. 
I confess that we didn't go this route and used the global array in a PL/SQL 
package, and the author discourages the use of autonomous transactions to 
get around mutating table errors. But it might be just right for 
someone's need.
Regards, 
Tony Aponte 
-Original Message- From: 
Khedr, Waleed [mailto: Sent: 
Thursday, June 06, 2002 12:08 PM To: Multiple 
recipients of list ORACLE-L Subject: RE: Complex 
Integrity Checking 
I could not find this and do not know how it could happen! 

If you can post here what you read, it will be 
appreciated. 
Waleed 
-Original Message- To: 
[EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 
Sent: 6/6/02 9:26 AM 
Waleed,  The chapter on Autonomous transactions demonstrates how to give 
the child transaction the ability to see uncommitted 
changes made by the parent transaction. 
 Regards,  Tony Aponte 
-Original Message- Sent: 
Wednesday, June 05, 2002 9:03 PM To: Multiple 
recipients of list ORACLE-L 
The problem with this solution is the Autonomous 
Transactions will not be able to see any 
changes done within the current transaction only the committed one. So no way to enforce business logic during the context 
of the transaction.  This is why I asked before how 
frequently commit happens.  Regards,  Waleed 
-Original Message- Sent: 
Wednesday, June 05, 2002 6:33 PM To: Multiple 
recipients of list ORACLE-L 
With the introduction of Autonomous Transactions this is no 
longer entirely true. If you call an 
autonomous transaction procedure, it is executed in 
a separate transaction context. This gives you the ability 
to probe the mutating table without inducing the 
error. A good explanation can be found in Tom 
Kyte's Export One-on-one Oracle book in the chapter 
on Autonomous Transactions. 
HTH Tony Aponte 
-Original Message- mailto:[EMAIL PROTECTED] 
] Sent: Wednesday, June 05, 2002 9:24 AM 
To: Multiple recipients of list ORACLE-L 

no matter what you do, if you access table A inside a 
trigger on table A, oracle 
will give you mutating table error. What you could (and I really 
mean you have to consider your 
business logic here) is go ahead and insert the 
rows with a temp flag. As soon as you commit, fire 
up a procedure that will do 
the scan on the table and delete appropriate rows which have the temp 

status. 
BTW how big is this table? What is the frequency of inserts 
and updates? 
Raj __ 
Rajendra 
Jamadagni 
MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot 
com Any opinion expressed here is personal and 
doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an 
art! 
-- Please see the official

RE: Wrong Results Bug in Oracle 8.1.7.1

Title: RE: Wrong Results Bug in Oracle 8.1.7.1






We had a similar issue, although it always resulted in an ORA-600. It was with descending indexes as defined in the Peopletools repository. We had to set _IGNORE_DESC_IN_INDEX=TRUE (and _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply with the Certification Requirements) and recreate the development databases. For Production, PS Support gave the OK to recreate the indexes without having to redo the upgrade.

HTH

Tony Aponte


-Original Message-

From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]

Sent: Monday, June 10, 2002 1:48 AM

To: Multiple recipients of list ORACLE-L

Subject: RE: Wrong Results Bug in Oracle 8.1.7.1



Accounts payable. But this is not a Peoplesoft problem, but an Oracle one. I tried the same query against another Peoplesoft instance, and it ran fine. So there's something more than the view involved here. It's in Oracle Support's court now.

I must be living right. It's failing in development and working in production.


Ian


-Original Message-

Sent: Sunday, June 09, 2002 7:13 PM

To: Multiple recipients of list ORACLE-L



what modules, if you dont mind me asking, i'm at a site where we're 

going to implement HR, Financials And EPM soon.


thanks, joe



MacGregor, Ian A. wrote:


Yep sure is. 



Ian





-Original Message-

Sent: Sunday, June 09, 2002 5:43 AM

To: Multiple recipients of list ORACLE-L





Ian, is that peopleslop?



joe





MacGregor, Ian A. wrote:



SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM  10;



VOUCHER_



3394

3395

3396

3397

3398

3399

3400

3401

3402





set feedback on



 1 SELECT VOUCHER_ID FROM PS_VCHR_MM_VW

 2* WHERE VOUCHER_ID = '3394'

SQL /

VOUCHER_







1 row selected.

--

Zounds !!! Select dump(voucher_id) shows that Oracle is returning a null here.



Here a function is used to force the query to do full tablescans



1 SELECT VOUCHER_ID FROM PS_VCHR_MM_VW

 2* WHERE CONCAT(VOUCHER_ID,'A') = CONCAT('3394', 'A')

SQL /



VOUCHER_



3394

-

I get the expected results if I force full table scans.



I looked at the explain plan for the failing query and rebuilt the ps_voucher index. This 

did not change its erroneous results. I rebuilt the view itself again to no avail. A check on Metalink revealed bug 1852163. Although this bug's conditions were different from the one above, their were some similarities. One workaround for bug 1852163



alter session set _complex_view_merging = true;



I tried this and the original query still gave improper results.

---

All queries against the component tables of the view work fine.

--

The view text is



CREATE VIEW SYSADM.PS_VCHR_MM_VW

AS

SELECT DISTINCT A.BUSINESS_UNIT, A.VOUCHER_ID, A.INVOICE_ID,

A.INVOICE_DT, A.PROCESS_INSTANCE, A.ENTRY_STATUS, A.POST_STATUS_AP,

A.MATCH_ACTION, C.PPV_POST_FLG, C.ERV_POST_FLG, A.ORIGIN FROM

SYSADM.PS_VOUCHER A, SYSADM.PS_PO_LINE_MATCHED C WHERE A.BUSINESS_UNIT =

C.BUSINESS_UNIT_AP AND A.VOUCHER_ID = C.VOUCHER_ID AND

A.MATCH_ACTION IN ('Y', 'E')

-

If I run the select statement outside of the view and tack on the 'voucher_id = ' clause 

SELECT DISTINCT A.BUSINESS_UNIT, A.VOUCHER_ID, A.INVOICE_ID,

A.INVOICE_DT, A.PROCESS_INSTANCE, A.ENTRY_STATUS, A.POST_STATUS_AP,

A.MATCH_ACTION, C.PPV_POST_FLG, C.ERV_POST_FLG, A.ORIGIN FROM

SYSADM.PS_VOUCHER A, SYSADM.PS_PO_LINE_MATCHED C WHERE A.BUSINESS_UNIT =

C.BUSINESS_UNIT_AP AND A.VOUCHER_ID = C.VOUCHER_ID AND

A.MATCH_ACTION IN ('Y', 'E')

and a.voucher_id = '3394'

/



I get the expected results. The query plan matches the one for the failing statement.

--

If I select more than voucher_id from the view with the 'voucher_id = ' predicate

the other fields are projected correctly, but returns voucher_id as null.

===



Ian MacGregor

Stanford Linear Accelerator Center

[EMAIL PROTECTED]













-- 

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

-- 

Author: Joe Testa

 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051

San Diego, California -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an

RE: Install: 9i on 2000, TNS Listener service not installed


I've got 9.0.1 on my WinTuke WS SP2 box and the listener service installed
correctly.

Not that it helps you any, but I thought you should know that it worked for
someone.

GL!

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


 -Original Message-
 From: Robert Monical [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, June 08, 2002 5:33 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Install: 9i on 2000, TNS Listener service not installed
 
 
 Starting to play around with 9i.
 Downloaded and installed on Windows 2000 Workstation.
 So far so good except no TNS Listener service
 lsnrctl start from the command line creates a listener.
 
 This may be a side effect of installing on Workstation 
 instead of Server.
 Anyone have any insight?
 
 Anyone know how to create the listener service after the install?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: set command

2002-06-10 Thread Alexandre Gorbatchev

Title: RE: set command



Oracle doesn't place anything. SQL*Plus 
does.
If you generate scripts from SQL*Plus:
set linesize ...

-- 
Alexandre

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, June 10, 2002 3:58 PM
  Subject: RE: set command
  
  Guys, 
  Building scripts from SQL generating SQL in Oracle on 
  Unix. I know that there are set commands so that Oracle does not put CR 
  or LF in the middle of a long command. Does anyone know these off the 
  top of their head?
  Thanks, Paula 
  set array...? set maxdata...?

RMAN

2002-06-10 Thread Surendra . Tirumala


Hello All,

I have been working on a strategy to implement a RMAN based backup and
recovery strategy.
Can anyone please suggest me if there is a way to force the RMAN to write
the backups to a machine other than the one on which target database is
present?

Thanks for your help.

Surendra

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

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

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

how to you stop an export?

2002-06-10 Thread Magaliff, Bill


how do you stop an command-line export?  press CTL-C countless times and
ususally just stops the current table . . . usually end up killing the
entire session.

was hoping there's a different way?

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

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

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

Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago






Netbackup has a repository that keeps track of what files are on which tapes, dates, sizes, volumes, serial number, etc. Depending on how you are restoring the files, Netbackup gets a request to get a file name (as it is know on tape) and checks it's catalog for the entry. The bprestore process (or whatever it's called on your platform) sends a request in a proprietary format to the media manager host. You (or your SA) can look at the Netbackup logs or use bpmon to view the details for the request, including the tape label.

The hang you are seeing is actually controlled by a timeout setting. Once the request is made for loading of a tape, the restore process is at the mercy of whatever mounter is used on the media manager host (robot, tape jockey, etc.) The timer expires, signals the bprestore and lets it exit gracefully returning an exit code in the process. Use this exit code to determine what the caused timeout; it's in the Veritas Netbackup manual. I bet the error code is for media not found and timer expired or something like that since the request isn't failing right away (which would mean that the tape was explicitly expired and the catalog entries updated to reflect the changes.) 

HTH

Tony Aponte


-Original Message-

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

Sent: Monday, June 10, 2002 4:18 AM

To: Multiple recipients of list ORACLE-L

Subject: RMAN NETBACKUP recovering from say 6 MONTHS ago



I want to alternate host my database to 6 months ago: The media manager

only keeps 2 months of data online and when i recover until etc.. the job

hangs and then finally gives up, obviously as the tape is not inside:

My question is how does Netbackup know which tape to load, or how do I know

which tape to put in the media manager or which range of tapes:

Anybody an help with this


Thanks


Sam




-- 

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

2002-06-10 Thread Paula_Stankus

Title: RE: set command



set 
linesize alone doesn't help - but will try it with set 
trimspool

  -Original Message-From: Alexandre Gorbatchev 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 
  2002 12:48 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: set command
  Oracle doesn't place anything. SQL*Plus 
  does.
  If you generate scripts from 
  SQL*Plus:
  set linesize ...
  
  -- 
  Alexandre
  
- Original Message - 
From: 
[EMAIL PROTECTED] 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, June 10, 2002 3:58 
PM
Subject: RE: set command

Guys, 
Building scripts from SQL generating SQL in Oracle on 
Unix. I know that there are set commands so that Oracle does not put 
CR or LF in the middle of a long command. Does anyone know these off 
the top of their head?
Thanks, Paula 
set array...? set maxdata...?

RE: RMAN


Surendra
The criteria I recall for RMAN to write to disk is whether you can
create an Oracle tablespace on that device. For example, NFS-mounting a disk
on another machine should work if you configure NFS correctly. Of course,
you need to be aware of how large the network pipe is to the other system to
ensure your speed is adequate. Another thing to consider is what else shares
the LAN with your NFS connection so you don't overwhelm whatever you're
sharing the link with. I'm sorry that I can't speak from experience. I plan
to test this just as soon as I can work it in among all the developer
requests.
Dennis Williams 20% OCP
DBA
Lifetouch, Inc.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L


Hello All,

I have been working on a strategy to implement a RMAN based backup and
recovery strategy.
Can anyone please suggest me if there is a way to force the RMAN to write
the backups to a machine other than the one on which target database is
present?

Thanks for your help.

Surendra

-- 
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: 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: how to you stop an export?

2002-06-10 Thread claudio cutelli


Hi,
by my experience, press CTL-C is enougth.
:-) Ciao


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 7:08 PM


 how do you stop an command-line export?  press CTL-C countless times and
 ususally just stops the current table . . . usually end up killing the
 entire session.
 
 was hoping there's a different way?
 
 thx
 bill
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Magaliff, Bill
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

2002-06-10 Thread Khedr, Waleed

Title: RE: Complex Integrity Checking

I
would not be happy to have such instructor!

-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 12:08
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Complex Integrity Checking
I
once had an instructor that said "a test is worth a thousand pages of
documentation." If you have access to the book, give the sample a
try.

Regards,

Tony
Aponte

-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 11:29
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Complex Integrity Checking
Again I do
not see anything here saying that the child session (Autonomous TX) will see
the changes made by the parent TX.

If you
implied this in your message, then we are in agreement.

regards,

Waleed

-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 10:16
AMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: Complex Integrity
Checking
Sorry for the delayed reply (I type with 2 fingers.)
The section starts on page 685.
rip Database Changes Now, this is were things
get interesting - database changes. Here, things can get a little
murky. Database changes made, but not yet committed by a parent
transaction are not visible to the autonomous transactions. Changes
made, and already committed by the parent transaction, are always visible
to the child transaction. Changes made by the autonomous transaction
may or may not be visible to the parent depending on its isolation
level.
I said before though, that this is were things get
murky. I was pretty clear above in saying that changes made by the
parent transaction are not visible to the child but that's not 100 percent
of the story. A cursor opened by the child autonomous transaction
will not see uncommitted changes, but a cursor opened by the parent and
fetched from the child will. The following case shows how this
works. We will recreate our EMP ..
end rip
The rest of the section demonstrates the voodoo
magic. I confess that we didn't go this route and used the global
array in a PL/SQL package, and the author discourages the use of
autonomous transactions to get around mutating table errors. But it
might be just right for someone's need.
Regards,
Tony Aponte
-Original Message- From:
Khedr, Waleed [mailto: Sent:
Thursday, June 06, 2002 12:08 PM To: Multiple
recipients of list ORACLE-L Subject: RE: Complex
Integrity Checking
I could not find this and do not know how it could happen!

If you can post here what you read, it will be
appreciated.
Waleed
-Original Message- To:
[EMAIL PROTECTED] Cc:
[EMAIL PROTECTED] Sent: 6/6/02 9:26 AM

Waleed, The chapter on Autonomous transactions demonstrates how to give
the child transaction the ability to see
uncommitted changes made by the parent
transaction. Regards, Tony Aponte
-Original Message- Sent:
Wednesday, June 05, 2002 9:03 PM To: Multiple
recipients of list ORACLE-L
The problem with this solution is the Autonomous
Transactions will not be able to see any
changes done within the current transaction only the committed one. So no way to enforce business logic during the
context of the transaction. This is why I asked before how
frequently commit happens. Regards, Waleed
-Original Message- Sent:
Wednesday, June 05, 2002 6:33 PM To: Multiple
recipients of list ORACLE-L
With the introduction of Autonomous Transactions this is
no longer entirely true. If you call an
autonomous transaction procedure, it is executed
in a separate transaction context. This gives you the ability
to probe the mutating table without inducing the
error. A good explanation can be found in
Tom Kyte's Export One-on-one Oracle book in the
chapter on Autonomous Transactions.
HTH Tony Aponte
-Original Message- mailto:[EMAIL PROTECTED]
] Sent: Wednesday, June 05, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L

RE: how to you stop an export?

2002-06-10 Thread Sherman, Paul R.


Hello,

On HP-UNIX (11.0), a CTL-\ will generate a core dump, that effectively kills
the export. Then all you need to do is remember to remove the core dump (rm
core) and the aborted export .dmp file.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Monday, June 10, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L


how do you stop an command-line export?  press CTL-C countless times and
ususally just stops the current table . . . usually end up killing the
entire session.

was hoping there's a different way?

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

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

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

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

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

Re: RMAN

2002-06-10 Thread claudio cutelli


Hi.
you must share the remote filesystem or make RMAN able to write on DLT.

:-) Ciao
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 6:53 PM


 Hello All,
 
 I have been working on a strategy to implement a RMAN based backup and
 recovery strategy.
 Can anyone please suggest me if there is a way to force the RMAN to write
 the backups to a machine other than the one on which target database is
 present?
 
 Thanks for your help.
 
 Surendra
 
 --
 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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

2002-06-10 Thread Surendra . Tirumala


Dennis,

Thanks for your quick reply.  
Thanks for your suggestions. 
Yes, a while ago I am also forced to conclude that properly configured NFS
is
the only option. But I am not sure when I would be able to do that.
For the time being I have decided to use the extra space avaialble on my
target machine.

Thanks again.
Surendra

-Original Message-
Sent: Monday, June 10, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


Surendra
The criteria I recall for RMAN to write to disk is whether you can
create an Oracle tablespace on that device. For example, NFS-mounting a disk
on another machine should work if you configure NFS correctly. Of course,
you need to be aware of how large the network pipe is to the other system to
ensure your speed is adequate. Another thing to consider is what else shares
the LAN with your NFS connection so you don't overwhelm whatever you're
sharing the link with. I'm sorry that I can't speak from experience. I plan
to test this just as soon as I can work it in among all the developer
requests.
Dennis Williams 20% OCP
DBA
Lifetouch, Inc.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L


Hello All,

I have been working on a strategy to implement a RMAN based backup and
recovery strategy.
Can anyone please suggest me if there is a way to force the RMAN to write
the backups to a machine other than the one on which target database is
present?

Thanks for your help.

Surendra

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

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

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

Job Scheduler in 9i

2002-06-10 Thread Freeman, Robert


Anyone run into any problems with the job scheduler in 9iR1 not kicking
off jobs when they are scheduled?

We have a situation where a given job (runs every 4 hours or so) will be
kicked
of successfully 2-3 times, and then on the 4th time the scheduler does not
kick
it off, next_date is not incremented... it's like the job just gets lost in 
space...This same scheduled job ran fine in 8i. (this is an 8i to 9i
migrated
database)

Any thoughts on this?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's covered in third degree burns, and your foot's caught in a bear
trap, you tend to start talkin' crazy.

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

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

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

2002-06-10 Thread Robert Monical


Thanks

In my 9i Install, the tool to create the service was Net Manager
and it was under Configuration and Management Tools.


At 08:33 AM 6/10/2002 -0800, you wrote:
I've got 9.0.1 on my WinTuke WS SP2 box and
the listener service installed
correctly.

Not that it helps you any, but I thought you should know that it worked
for
someone.

GL!

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


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

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

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

2002-06-10 Thread Fink, Dan

Title: RE: set command



Paula,
 TRIMSPOOL will only remove the trailing characters in an 
output file. Normally, the output is padded withblanksup to the 
length defined by LINESIZE. I don't think TRIMSPOOL will help, but I could be 
wrong.

 How long is the command you are trying to output? What is 
the setting for WRAP?

Daniel W. 
Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 
  11:28 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: set command
  set 
  linesize alone doesn't help - but will try it with set 
  trimspool
  
-Original Message-From: Alexandre Gorbatchev 
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 
2002 12:48 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: set command
Oracle doesn't place anything. SQL*Plus 
does.
If you generate scripts from 
SQL*Plus:
set linesize ...

-- 
Alexandre

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, June 10, 2002 3:58 
  PM
  Subject: RE: set command
  
  Guys, 
  Building scripts from SQL generating SQL in Oracle on 
  Unix. I know that there are set commands so that Oracle does not put 
  CR or LF in the middle of a long command. Does anyone know these off 
  the top of their head?
  Thanks, Paula 
  set array...? set 
  maxdata...?

RE: how to you stop an export?

2002-06-10 Thread Deshpande, Kirti


CTL-\ 
rm core

- Kirti 


-Original Message-
Sent: Monday, June 10, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


Hi,
by my experience, press CTL-C is enougth.
:-) Ciao


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 7:08 PM


 how do you stop an command-line export?  press CTL-C countless times and
 ususally just stops the current table . . . usually end up killing the
 entire session.
 
 was hoping there's a different way?
 
 thx
 bill
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Magaliff, Bill
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: how to you stop an export?

2002-06-10 Thread Muqthar Ahmed


Hi,

If you are running from a UNIX server, kill the job by PID number.

Muqthar Ahmed
DBA

-Original Message-
Sent: Monday, June 10, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


Hi,
by my experience, press CTL-C is enougth.
:-) Ciao


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 7:08 PM


 how do you stop an command-line export?  press CTL-C countless times and
 ususally just stops the current table . . . usually end up killing the
 entire session.
 
 was hoping there's a different way?
 
 thx
 bill
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Magaliff, Bill
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

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

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

2002-06-10 Thread Rachel Carmichael


set pagesize 0 as well, that stops the heading lines from breaking up
your output


--- [EMAIL PROTECTED] wrote:
 set linesize alone doesn't help - but will try it with set trimspool
 
 -Original Message-
 Sent: Monday, June 10, 2002 12:48 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle doesn't place anything. SQL*Plus does.
 If you generate scripts from SQL*Plus:
 set linesize ...
  
 -- 
 Alexandre
 
 - Original Message - 
 To: Multiple  mailto:[EMAIL PROTECTED] recipients of list
 ORACLE-L 
 Sent: Monday, June 10, 2002 3:58 PM
 
 
 Guys, 
 
 Building scripts from SQL generating SQL in Oracle on Unix.  I know
 that
 there are set commands so that Oracle does not put CR or LF in the
 middle of
 a long command.  Does anyone know these off the top of their head?
 
 Thanks, 
 Paula 
 
 set array...? 
 set maxdata...? 
 
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: Any tool available for identifying junk code?

2002-06-10 Thread paquette stephane


I like the then use coffee-machine information part.

 
 --- Stephane Faroult [EMAIL PROTECTED] a écrit :
 Sandeep Kurliye wrote:
  
  Hi Guys,
  
  Sorry, if this sounds bit awkward or unrelated to
 this mailing list.
  
  Can any one of you please let me know whether
 there is any tool available to identify junk code in
 an application. My applications are written in
 Oracle Forms and VB. Backend is Oracle.
  
  I am in the process of tuning these applications.
 I can see lots of poorly written SQLs. These can be
 tuned from backend as well as changing SQLs in
 forms.  But what about poorly written logic?
  
  As such, I am going thr' each and every line of
 code and tuning it wherever necessary, but plenty of
 time will require to complete this process. If there
 is any tool available which identify the problem,
 then I've to directly go to the application/code and
 modify it.
  
  If I've to rewrite whole application, then its
 massive task.
  
  Please help.
  
  TIA,
  
  Regards,
  Sandeep.
  
 
 Sandeep,
 
Glad to see somebody worrying about logic. But
 it's a mountain to
 climb. IMHO, try to concentrate on 'problem' code -
 check V$SQLAREA at
 regular intervals to see the top 'buffer_gets'
 queries, you do not only
 have individual queries, you will also see
 (command_type = 47) stored
 PL/SQL procedures, and they may point you to bad
 logic; listen to users
 to. Fortunately there is a lot of terrible code that
 nobody really
 worries about.
 The first thing I would do in your case would be to
 put calls to
 dbms_application_info everywhere, setting 'module'
 and 'action' to
 identify 'atomic business processes' (if such a
 thing exists), then use
 coffee-machine information and a bit of monitoring
 to check what really
 hurts and concentrate on that. Otherwise you risk
 spending a lot of time
 on improvements that nobody will ever notice.
 
 -- 
 HTH,
 
 Stephane Faroult
 Oriole Software
 -- 
 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). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

Nologging index tablespaces?


Have any of you changed your index tablespaces to NOLOGGING? Offhand it
seems like a possible performance increase and less redo, but at the expense
of having to remember to rebuild the indexes in a recovery. And I don't like
to have special things to remember in a crisis.
Dennis Williams 20% OCP 
DBA 
Lifetouch, Inc. 

-- 
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: RMAN[2]

2002-06-10 Thread claudio cutelli


sorry ...
there is another way 

install RMAN on the remote machine and connect to the remote database with
sql*net


;-)  Ciao



- Original Message -
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 6:29 PM


 Hi.
 you must share the remote filesystem or make RMAN able to write on DLT.

 :-) Ciao
 - Original Message -
 From: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, June 10, 2002 6:53 PM
 Subject: RMAN


  Hello All,
 
  I have been working on a strategy to implement a RMAN based backup and
  recovery strategy.
  Can anyone please suggest me if there is a way to force the RMAN to
write
  the backups to a machine other than the one on which target database is
  present?
 
  Thanks for your help.
 
  Surendra
 
  --
  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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

2002-06-10 Thread Jamadagni, Rajendra


We had the same situation and then we use cron that never fails. Now, we
don't trust dbms_job ... I had a TAR open on that, but can't access it now.

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

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


-Original Message-
Sent: Monday, June 10, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


Anyone run into any problems with the job scheduler in 9iR1 not kicking
off jobs when they are scheduled?

We have a situation where a given job (runs every 4 hours or so) will be
kicked
of successfully 2-3 times, and then on the 4th time the scheduler does not
kick
it off, next_date is not incremented... it's like the job just gets lost in 
space...This same scheduled job ran fine in 8i. (this is an 8i to 9i
migrated
database)

Any thoughts on this?


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

RE: Asinine security in Oracle, Part Deux

2002-06-10 Thread Jamadagni, Rajendra


Yes ...

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920
/a96521/audit.htm#13622

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

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


-Original Message-
Sent: Monday, June 10, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L


So, there I am, following up on past MetaLink forum articles, when I noticed
one about auditing DBA actions.  This, of course, is not supported by
Oracle.  Why would anyone want to audit a DBA?  After all, a DBA never makes
mistakes, right?  ;)

The answer from Oracle was that auditing SYS would be available in 9.2.  Can
anyone confirm?


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

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-10 Thread Peter Barnett


We had this same problem last year.  The answer was to
upgrade to 8.1.7.2 which came with its own set of bugs
which required we go to 8.1.7.3.

We had run for months in production before we ran into
the bug.  Once we hit it, there was no way to avoid
it.  The only option was to upgrade.

I don't recall all of the specifics any more, but if
it is important, I can check with the developer.  In
our environment, the same query run with SQL Navigator
and run through a batch job returned a different
result set.




--- Aponte, Tony [EMAIL PROTECTED] wrote:
 We had a similar issue, although it always resulted
 in an ORA-600.  It was with descending indexes as
 defined in the Peopletools repository.  We had to
 set _IGNORE_DESC_IN_INDEX=TRUE (and
 _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply
 with the Certification Requirements) and recreate
 the development databases.  For Production, PS
 Support gave the OK to recreate the indexes without
 having to redo the upgrade.
 
 HTH
 Tony Aponte
 
 -Original Message-
 Sent: Monday, June 10, 2002 1:48 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Accounts payable.  But this is not a Peoplesoft
 problem, but an Oracle one.  I tried the same query
 against another Peoplesoft instance, and it ran
 fine.  So there's something more than the view
 involved here.  It's in Oracle Support's court now.
 
 I must be living right.  It's failing in development
 and working in production.
 
 Ian
 
 -Original Message-
 Sent: Sunday, June 09, 2002 7:13 PM
 To: Multiple recipients of list ORACLE-L
 
 
 what modules, if you dont mind me asking, i'm at a
 site where we're 
 going to implement HR, Financials And EPM soon.
 
 thanks, joe
 
 
 MacGregor, Ian A. wrote:
 
 Yep sure is.  
 
 Ian
 
 
 -Original Message-
 Sent: Sunday, June 09, 2002 5:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ian, is that peopleslop?
 
 joe
 
 
 MacGregor, Ian A. wrote:
 
 SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE
 ROWNUM  10;
 
 VOUCHER_
 
 3394
 3395
 3396
 3397
 3398
 3399
 3400
 3401
 3402
 


 set feedback on
 
  1  SELECT VOUCHER_ID FROM PS_VCHR_MM_VW
  2* WHERE VOUCHER_ID  = '3394'
 SQL /
 VOUCHER_
 
 
 
 1 row selected.

--
 Zounds !!!  Select dump(voucher_id) shows that
 Oracle is returning a null here.
 
 Here a function is used to force the query to do
 full tablescans
 
 1  SELECT VOUCHER_ID FROM PS_VCHR_MM_VW
  2* WHERE CONCAT(VOUCHER_ID,'A') =
 CONCAT('3394', 'A')
 SQL /
 
 VOUCHER_
 
 3394

-
 I get the expected results  if I force full table
 scans.
 
 I looked at the explain plan for the failing query
 and rebuilt the ps_voucher index.  This 
 did not change its erroneous results.  I rebuilt
 the view itself again to no avail.  A check on
 Metalink revealed bug 1852163.  Although this bug's
 conditions were different  from the one above, their
 were some similarities.  One workaround for bug
 1852163
 
 alter session set _complex_view_merging = true;
 
 I tried this and the  original query still gave
 improper results.

---
 All queries against the component tables of the
 view work fine.

--
 The view text is
 
 CREATE VIEW SYSADM.PS_VCHR_MM_VW
 AS
 SELECT DISTINCT  A.BUSINESS_UNIT,  A.VOUCHER_ID, 
 A.INVOICE_ID,
 A.INVOICE_DT,  A.PROCESS_INSTANCE, 
 A.ENTRY_STATUS,  A.POST_STATUS_AP,
 A.MATCH_ACTION,  C.PPV_POST_FLG,  C.ERV_POST_FLG, 
 A.ORIGIN  FROM
 SYSADM.PS_VOUCHER A,  SYSADM.PS_PO_LINE_MATCHED C 
 WHERE  A.BUSINESS_UNIT =
 C.BUSINESS_UNIT_AP AND  A.VOUCHER_ID =
 C.VOUCHER_ID AND
 A.MATCH_ACTION IN ('Y', 'E')

-
 If I run  the select statement outside of the view
 and tack on the 'voucher_id = ' clause 
 SELECT DISTINCT  A.BUSINESS_UNIT,  A.VOUCHER_ID, 
 A.INVOICE_ID,
 A.INVOICE_DT,  A.PROCESS_INSTANCE, 
 A.ENTRY_STATUS,  A.POST_STATUS_AP,
 A.MATCH_ACTION,  C.PPV_POST_FLG,  C.ERV_POST_FLG, 
 A.ORIGIN  FROM
 SYSADM.PS_VOUCHER A,  SYSADM.PS_PO_LINE_MATCHED C 
 WHERE  A.BUSINESS_UNIT =
 C.BUSINESS_UNIT_AP AND  A.VOUCHER_ID =
 C.VOUCHER_ID AND
 A.MATCH_ACTION IN ('Y', 'E')
 and a.voucher_id = '3394'
 /
 
 I get the expected results.  The query plan
 matches the one for the failing statement.

--
 If I  select more than voucher_id from the view
 with the 'voucher_id  = ' predicate
 the other fields are projected correctly, but
 returns voucher_id as null.

Asinine security in Oracle, Part Deux


So, there I am, following up on past MetaLink forum articles, when I noticed
one about auditing DBA actions.  This, of course, is not supported by
Oracle.  Why would anyone want to audit a DBA?  After all, a DBA never makes
mistakes, right?  ;)

The answer from Oracle was that auditing SYS would be available in 9.2.  Can
anyone confirm?

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: set command

2002-06-10 Thread Kevin Lange


You can also add 
  set feedback off 
This will stop any row counts from appearing at the end of the query.

Plus you can
  set sqlprompt ''
This will change the standard SQL prompt to nothing.  This way the SQL
that returns at the end of the query .   Its anoying .



-Original Message-
Sent: Monday, June 10, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L


set pagesize 0 as well, that stops the heading lines from breaking up
your output


--- [EMAIL PROTECTED] wrote:
 set linesize alone doesn't help - but will try it with set trimspool
 
 -Original Message-
 Sent: Monday, June 10, 2002 12:48 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle doesn't place anything. SQL*Plus does.
 If you generate scripts from SQL*Plus:
 set linesize ...
  
 -- 
 Alexandre
 
 - Original Message - 
 To: Multiple  mailto:[EMAIL PROTECTED] recipients of list
 ORACLE-L 
 Sent: Monday, June 10, 2002 3:58 PM
 
 
 Guys, 
 
 Building scripts from SQL generating SQL in Oracle on Unix.  I know
 that
 there are set commands so that Oracle does not put CR or LF in the
 middle of
 a long command.  Does anyone know these off the top of their head?
 
 Thanks, 
 Paula 
 
 set array...? 
 set maxdata...? 
 
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

2002-06-10 Thread Cherie_Machler



Dennis,

We have set particular indexes to nologging when building them.   These are
indexes that we drop every night for our warehouse load.

It is a hassle because whenever we clone this database to our QA box, those
nologged indexes get corrupt and we have to rebuild them.   Takes us three
hours to do.   We have recovered the database too and did have to rebuild
the indexes after.I guess you have to balance the regular time-savings
in building/rebuilding indexes with the time cost in mean-time-to-recover.

I've never changed an entire index tablespace to nologging.

Cherie Machler
Oracle DBA
Gelco Information Network


   
   
DENNIS WILLIAMS
   
DWILLIAMS@LIFE   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
TOUCH.COMcc:  
   
Sent by:  Subject: Nologging index tablespaces?
   
[EMAIL PROTECTED]
   
m  
   
   
   
   
   
06/10/02 01:33 
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Have any of you changed your index tablespaces to NOLOGGING? Offhand it
seems like a possible performance increase and less redo, but at the
expense
of having to remember to rebuild the indexes in a recovery. And I don't
like
to have special things to remember in a crisis.
Dennis Williams 20% OCP
DBA
Lifetouch, Inc.

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

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

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

2002-06-10 Thread Paul Vallee


These types of problems can sometimes be resolved with an index rebuild,
btw.

hth,
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.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 2:43 PM


We had this same problem last year.  The answer was to
upgrade to 8.1.7.2 which came with its own set of bugs
which required we go to 8.1.7.3.

We had run for months in production before we ran into
the bug.  Once we hit it, there was no way to avoid
it.  The only option was to upgrade.

I don't recall all of the specifics any more, but if
it is important, I can check with the developer.  In
our environment, the same query run with SQL Navigator
and run through a batch job returned a different
result set.




--- Aponte, Tony [EMAIL PROTECTED] wrote:
 We had a similar issue, although it always resulted
 in an ORA-600.  It was with descending indexes as
 defined in the Peopletools repository.  We had to
 set _IGNORE_DESC_IN_INDEX=TRUE (and
 _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply
 with the Certification Requirements) and recreate
 the development databases.  For Production, PS
 Support gave the OK to recreate the indexes without
 having to redo the upgrade.

 HTH
 Tony Aponte

 -Original Message-
 Sent: Monday, June 10, 2002 1:48 AM
 To: Multiple recipients of list ORACLE-L


 Accounts payable.  But this is not a Peoplesoft
 problem, but an Oracle one.  I tried the same query
 against another Peoplesoft instance, and it ran
 fine.  So there's something more than the view
 involved here.  It's in Oracle Support's court now.

 I must be living right.  It's failing in development
 and working in production.

 Ian

 -Original Message-
 Sent: Sunday, June 09, 2002 7:13 PM
 To: Multiple recipients of list ORACLE-L


 what modules, if you dont mind me asking, i'm at a
 site where we're
 going to implement HR, Financials And EPM soon.

 thanks, joe


 MacGregor, Ian A. wrote:

 Yep sure is.
 
 Ian
 
 
 -Original Message-
 Sent: Sunday, June 09, 2002 5:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ian, is that peopleslop?
 
 joe
 
 
 MacGregor, Ian A. wrote:
 
 SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE
 ROWNUM  10;
 
 VOUCHER_
 
 3394
 3395
 3396
 3397
 3398
 3399
 3400
 3401
 3402
 


 set feedback on
 
  1  SELECT VOUCHER_ID FROM PS_VCHR_MM_VW
  2* WHERE VOUCHER_ID  = '3394'
 SQL /
 VOUCHER_
 
 
 
 1 row selected.

--

 Zounds !!!  Select dump(voucher_id) shows that
 Oracle is returning a null here.
 
 Here a function is used to force the query to do
 full tablescans
 
 1  SELECT VOUCHER_ID FROM PS_VCHR_MM_VW
  2* WHERE CONCAT(VOUCHER_ID,'A') =
 CONCAT('3394', 'A')
 SQL /
 
 VOUCHER_
 
 3394

--
---
 I get the expected results  if I force full table
 scans.
 
 I looked at the explain plan for the failing query
 and rebuilt the ps_voucher index.  This
 did not change its erroneous results.  I rebuilt
 the view itself again to no avail.  A check on
 Metalink revealed bug 1852163.  Although this bug's
 conditions were different  from the one above, their
 were some similarities.  One workaround for bug
 1852163
 
 alter session set _complex_view_merging = true;
 
 I tried this and the  original query still gave
 improper results.

--
-
 All queries against the component tables of the
 view work fine.

--

 The view text is
 
 CREATE VIEW SYSADM.PS_VCHR_MM_VW
 AS
 SELECT DISTINCT  A.BUSINESS_UNIT,  A.VOUCHER_ID,
 A.INVOICE_ID,
 A.INVOICE_DT,  A.PROCESS_INSTANCE,
 A.ENTRY_STATUS,  A.POST_STATUS_AP,
 A.MATCH_ACTION,  C.PPV_POST_FLG,  C.ERV_POST_FLG,
 A.ORIGIN  FROM
 SYSADM.PS_VOUCHER A,  SYSADM.PS_PO_LINE_MATCHED C
 WHERE  A.BUSINESS_UNIT =
 C.BUSINESS_UNIT_AP AND  A.VOUCHER_ID =
 C.VOUCHER_ID AND
 A.MATCH_ACTION IN ('Y', 'E')

--
---
 If I run  the select statement outside of the view
 and tack on the 'voucher_id = ' clause
 SELECT DISTINCT  A.BUSINESS_UNIT,  A.VOUCHER_ID,
 A.INVOICE_ID,
 A.INVOICE_DT,  A.PROCESS_INSTANCE,
 A.ENTRY_STATUS,  A.POST_STATUS_AP,
 A.MATCH_ACTION,  C.PPV_POST_FLG,  C.ERV_POST_FLG,
 A.ORIGIN  FROM
 SYSADM.PS_VOUCHER A,  SYSADM.PS_PO_LINE_MATCHED C
 WHERE  A.BUSINESS_UNIT =
 C.BUSINESS_UNIT_AP AND  A.VOUCHER_ID =
 C.VOUCHER_ID AND

RE: Asinine security in Oracle, Part Deux


Yay!  Thanks!  :)

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


 -Original Message-
 From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 2:13 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Asinine security in Oracle, Part Deux
 
 
 Yes ...
 
 http://otn.oracle.com/docs/products/oracle9i/doc_library/relea
 se2/server.920/a96521/audit.htm#13622
 
 Raj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re:RE: Job Scheduler in 9i

2002-06-10 Thread dgoulet


Raj,

WARNING: Cron has been known to fail around here leaving one heck of a mess
behind.  The primary culprit is when you have a power failure.  In our case the
power failure lasted more than 8 hours.  When the computer restarted the cron
job's time had passed  it would not start for another week by itself.  On the
other hand a dbms_job that should have started at about the same time did.  We
use both, but you have to understand the weaknesses of both.

Dick Goulet

Reply Separator
Author: Jamadagni; Rajendra [EMAIL PROTECTED]
Date:   6/10/2002 10:38 AM

We had the same situation and then we use cron that never fails. Now, we
don't trust dbms_job ... I had a TAR open on that, but can't access it now.

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

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


-Original Message-
Sent: Monday, June 10, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


Anyone run into any problems with the job scheduler in 9iR1 not kicking
off jobs when they are scheduled?

We have a situation where a given job (runs every 4 hours or so) will be
kicked
of successfully 2-3 times, and then on the 4th time the scheduler does not
kick
it off, next_date is not incremented... it's like the job just gets lost in 
space...This same scheduled job ran fine in 8i. (this is an 8i to 9i
migrated
database)

Any thoughts on this?

 

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

RE: I/O bound on tablespace for one partition

2002-06-10 Thread VIVEK_SHARMA

Title: Message




What 
OS Stripe Width would you Consider Ideal for respective Types (OLTP  Batch) 
of Applications ?
What 
is your nature of Application ?
Any 
Good Docs Links on the Same ?

Thanks
-Original 
Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 
12:54 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: I/O bound on tablespace for one partition

  

  
  
  Okay 
  guys,
  
  We are using OS 
  striping. However, for reasons of partition elimination, etc. I 
  broke up 80 years of data into separate years. Now one of the 
  tablespaces is being hit 70% of the time. Given OS striping and that 
  I can't really stripe manually (very ltd.) is it worth moving partitions 
  into multiple tablespaces?

RE: RE: Job Scheduler in 9i

2002-06-10 Thread Jamadagni, Rajendra


Dick,

Thanks, and yes I understand both, but we had really bad luck with dbms_job
which would stop working without any errors. OWS was unable to give a quick
fix, and eventually it turned out that one of the parameters (I think
job_queue_processes) was getting reset or something like that. We applied
the patch but never used dbms_job again.

Our Unix guys are pretty good at this, so that part I really never worry
about. The scenario you mentioned is perfectly valid and I think we have
some steps outlined in case of disaster recovery. My experience about cron
is on AIX, DG-UX and Solaris.

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

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


-Original Message-
Sent: Monday, June 10, 2002 2:31 PM
To: Jamadagni; Rajendra; Multiple recipients of list ORACLE-L


Raj,

WARNING: Cron has been known to fail around here leaving one heck of a
mess
behind.  The primary culprit is when you have a power failure.  In our case
the
power failure lasted more than 8 hours.  When the computer restarted the
cron
job's time had passed  it would not start for another week by itself.  On
the
other hand a dbms_job that should have started at about the same time did.
We
use both, but you have to understand the weaknesses of both.

Dick Goulet


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

RE: set command

2002-06-10 Thread Toepke, Kevin M

Title: RE: set command



Here 
is what I use. It wraps at the 32768th character.

SET 
PAUSE OFFSET TRIMSPOOL ONSET TRIMOUT ONSET 
TERMOUT OFFSET PAGESIZE 5SET LINESIZE 
32767

  -Original Message-From: Fink, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 2:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  set command
  Paula,
   TRIMSPOOL will only remove the trailing characters in an 
  output file. Normally, the output is padded withblanksup to the 
  length defined by LINESIZE. I don't think TRIMSPOOL will help, but I could be 
  wrong.
  
   How long is the command you are trying to output? What is 
  the setting for WRAP?
  
  Daniel W. 
  Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 
11:28 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: set command
set linesize alone doesn't help - but will try it 
with set trimspool

  -Original Message-From: Alexandre Gorbatchev 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 
  2002 12:48 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: set command
  Oracle doesn't place anything. SQL*Plus 
  does.
  If you generate scripts from 
  SQL*Plus:
  set linesize ...
  
  -- 
  Alexandre
  
- Original Message - 
From: 
[EMAIL PROTECTED] 

To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, June 10, 2002 3:58 
PM
Subject: RE: set command

Guys, 
Building scripts from SQL generating SQL in Oracle on 
Unix. I know that there are set commands so that Oracle does not 
put CR or LF in the middle of a long command. Does anyone know 
these off the top of their head?
Thanks, Paula 
set array...? set 
maxdata...?

auditing sys

2002-06-10 Thread JOE TESTA




according to the docs its in there.

Sys Accountability: Heightened user accountability and database 
security are now possible with the capability to audit all operations done by 
user SYS(including all as SYSDBA and SUSOPER connections).

This is from the 9ir2 new features guide.

Haven't tried it yet, just currently beating up on logminer new 
enhancements and later this week hopefully logical standby.

joe

RE: set command

2002-06-10 Thread Fink, Dan


Setting SQLPROMPT to '' is very handy, but there is one caveat. After the
query executes, SQL*Plus 'appears' to hang because there is no prompt to
indicate where the next command is to be entered(like SET PAUSE ON and
forgetting about it...d'oh). 

I spooled as much as 10,000 characters on a single line without problem.
However, there is a limit of 2500 characters for the command line and the
LINESIZE is platform dependent. 

Do you have an example we could chew on?

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Monday, June 10, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


You can also add 
  set feedback off 
This will stop any row counts from appearing at the end of the query.

Plus you can
  set sqlprompt ''
This will change the standard SQL prompt to nothing.  This way the SQL
that returns at the end of the query .   Its anoying .



-Original Message-
Sent: Monday, June 10, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L


set pagesize 0 as well, that stops the heading lines from breaking up
your output


--- [EMAIL PROTECTED] wrote:
 set linesize alone doesn't help - but will try it with set trimspool
 
 -Original Message-
 Sent: Monday, June 10, 2002 12:48 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle doesn't place anything. SQL*Plus does.
 If you generate scripts from SQL*Plus:
 set linesize ...
  
 -- 
 Alexandre
 
 - Original Message - 
 To: Multiple  mailto:[EMAIL PROTECTED] recipients of list
 ORACLE-L 
 Sent: Monday, June 10, 2002 3:58 PM
 
 
 Guys, 
 
 Building scripts from SQL generating SQL in Oracle on Unix.  I know
 that
 there are set commands so that Oracle does not put CR or LF in the
 middle of
 a long command.  Does anyone know these off the top of their head?
 
 Thanks, 
 Paula 
 
 set array...? 
 set maxdata...? 
 
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: set command

2002-06-10 Thread Paula_Stankus

Title: RE: set command





That was it Thanks Rachel.


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: set command



set pagesize 0 as well, that stops the heading lines from breaking up
your output



--- [EMAIL PROTECTED] wrote:
 set linesize alone doesn't help - but will try it with set trimspool
 
 -Original Message-
 Sent: Monday, June 10, 2002 12:48 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle doesn't place anything. SQL*Plus does.
 If you generate scripts from SQL*Plus:
 set linesize ...
 
 -- 
 Alexandre
 
 - Original Message - 
 To: Multiple mailto:[EMAIL PROTECTED] recipients of list
 ORACLE-L 
 Sent: Monday, June 10, 2002 3:58 PM
 
 
 Guys, 
 
 Building scripts from SQL generating SQL in Oracle on Unix. I know
 that
 there are set commands so that Oracle does not put CR or LF in the
 middle of
 a long command. Does anyone know these off the top of their head?
 
 Thanks, 
 Paula 
 
 set array...? 
 set maxdata...? 
 
 



__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]


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

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

RE: Asinine security in Oracle, Part Deux

2002-06-10 Thread Toepke, Kevin M


You might want to check out 9iR2.

-Original Message-
Sent: Monday, June 10, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L


So, there I am, following up on past MetaLink forum articles, when I noticed
one about auditing DBA actions.  This, of course, is not supported by
Oracle.  Why would anyone want to audit a DBA?  After all, a DBA never makes
mistakes, right?  ;)

The answer from Oracle was that auditing SYS would be available in 9.2.  Can
anyone confirm?

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Oracle one-off Patch Install util


I've d/ld new versions of RDA and it is much better than it used to be.  I
got a clean run on Solaris the 1st try!

Now to beat them up over the invalid HTML that it creates.  There can't be
any H3 tags in a PRE block!  Of course every browser but Opera overlooks
this...

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

 -Original Message-
 From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 07, 2002 9:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle one-off Patch Install util
 
 
 RDA was written (or at least managed) by Anita Bardeen who used to
 spend a good deal of time on this list...she'll be happy to know you
 like it!
 
 Rachel
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-10 Thread Fink, Dan


I recall a similar situation with Oracle 7.3 and parallel index creations
where the row source and output would get reversed. Index scans would return
now rows (The developer called with 'I just created and index and now the
data is all gone'). If a FTS works, but not the index, that tells me that
the contents of the index are toast. If a rebuild does not work, sounds like
a bug...

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Monday, June 10, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L


These types of problems can sometimes be resolved with an index rebuild,
btw.

hth,
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.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 2:43 PM


We had this same problem last year.  The answer was to
upgrade to 8.1.7.2 which came with its own set of bugs
which required we go to 8.1.7.3.

We had run for months in production before we ran into
the bug.  Once we hit it, there was no way to avoid
it.  The only option was to upgrade.

I don't recall all of the specifics any more, but if
it is important, I can check with the developer.  In
our environment, the same query run with SQL Navigator
and run through a batch job returned a different
result set.




--- Aponte, Tony [EMAIL PROTECTED] wrote:
 We had a similar issue, although it always resulted
 in an ORA-600.  It was with descending indexes as
 defined in the Peopletools repository.  We had to
 set _IGNORE_DESC_IN_INDEX=TRUE (and
 _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply
 with the Certification Requirements) and recreate
 the development databases.  For Production, PS
 Support gave the OK to recreate the indexes without
 having to redo the upgrade.

 HTH
 Tony Aponte

 -Original Message-
 Sent: Monday, June 10, 2002 1:48 AM
 To: Multiple recipients of list ORACLE-L


 Accounts payable.  But this is not a Peoplesoft
 problem, but an Oracle one.  I tried the same query
 against another Peoplesoft instance, and it ran
 fine.  So there's something more than the view
 involved here.  It's in Oracle Support's court now.

 I must be living right.  It's failing in development
 and working in production.

 Ian

 -Original Message-
 Sent: Sunday, June 09, 2002 7:13 PM
 To: Multiple recipients of list ORACLE-L


 what modules, if you dont mind me asking, i'm at a
 site where we're
 going to implement HR, Financials And EPM soon.

 thanks, joe


 MacGregor, Ian A. wrote:

 Yep sure is.
 
 Ian
 
 
 -Original Message-
 Sent: Sunday, June 09, 2002 5:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ian, is that peopleslop?
 
 joe
 
 
 MacGregor, Ian A. wrote:
 
 SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE
 ROWNUM  10;
 
 VOUCHER_
 
 3394
 3395
 3396
 3397
 3398
 3399
 3400
 3401
 3402
 


 set feedback on
 
  1  SELECT VOUCHER_ID FROM PS_VCHR_MM_VW
  2* WHERE VOUCHER_ID  = '3394'
 SQL /
 VOUCHER_
 
 
 
 1 row selected.

--

 Zounds !!!  Select dump(voucher_id) shows that
 Oracle is returning a null here.
 
 Here a function is used to force the query to do
 full tablescans
 
 1  SELECT VOUCHER_ID FROM PS_VCHR_MM_VW
  2* WHERE CONCAT(VOUCHER_ID,'A') =
 CONCAT('3394', 'A')
 SQL /
 
 VOUCHER_
 
 3394

--
---
 I get the expected results  if I force full table
 scans.
 
 I looked at the explain plan for the failing query
 and rebuilt the ps_voucher index.  This
 did not change its erroneous results.  I rebuilt
 the view itself again to no avail.  A check on
 Metalink revealed bug 1852163.  Although this bug's
 conditions were different  from the one above, their
 were some similarities.  One workaround for bug
 1852163
 
 alter session set _complex_view_merging = true;
 
 I tried this and the  original query still gave
 improper results.

--
-
 All queries against the component tables of the
 view work fine.

--

 The view text is
 
 CREATE VIEW SYSADM.PS_VCHR_MM_VW
 AS
 SELECT DISTINCT  A.BUSINESS_UNIT,  A.VOUCHER_ID,
 A.INVOICE_ID,
 A.INVOICE_DT,  A.PROCESS_INSTANCE,
 A.ENTRY_STATUS,  A.POST_STATUS_AP,
 A.MATCH_ACTION,  C.PPV_POST_FLG,  C.ERV_POST_FLG,
 A.ORIGIN  FROM
 SYSADM.PS_VOUCHER A,  SYSADM.PS_PO_LINE_MATCHED C
 WHERE  A.BUSINESS_UNIT =
 C.BUSINESS_UNIT_AP AND  A.VOUCHER_ID =
 C.VOUCHER_ID AND

RE: Job Scheduler in 9i

2002-06-10 Thread Brian McGraw


Just out of curiosity, are the jobs showing up in dba_jobs_running?  I'm
wondering if they ever report back as having completed.

Brian

-Original Message-
Robert
Sent: Monday, June 10, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L

Anyone run into any problems with the job scheduler in 9iR1 not kicking
off jobs when they are scheduled?

We have a situation where a given job (runs every 4 hours or so) will be
kicked
of successfully 2-3 times, and then on the 4th time the scheduler does
not
kick
it off, next_date is not incremented... it's like the job just gets lost
in 
space...This same scheduled job ran fine in 8i. (this is an 8i to 9i
migrated
database)

Any thoughts on this?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's covered in third degree burns, and your foot's caught in a bear
trap, you tend to start talkin' crazy.

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

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

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

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

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

2002-06-10 Thread Rachel Carmichael


trimspool will remove the trailing blanks and get rid of the padding


--- Fink, Dan [EMAIL PROTECTED] wrote:
 Paula,
 TRIMSPOOL will only remove the trailing characters in an output
 file.
 Normally, the output is padded with blanks up to the length defined
 by
 LINESIZE. I don't think TRIMSPOOL will help, but I could be wrong.
  
 How long is the command you are trying to output? What is the
 setting
 for WRAP?
  
 Daniel W. Fink 
 Sr. Oracle DBA 
 MICROMEDEX 
 303.486.6456 
 
 -Original Message-
 Sent: Monday, June 10, 2002 11:28 AM
 To: Multiple recipients of list ORACLE-L
 
 
 set linesize alone doesn't help - but will try it with set trimspool
 
 -Original Message-
 Sent: Monday, June 10, 2002 12:48 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle doesn't place anything. SQL*Plus does.
 If you generate scripts from SQL*Plus:
 set linesize ...
  
 -- 
 Alexandre
 
 - Original Message - 
 To: Multiple recipients of list  mailto:[EMAIL PROTECTED]
 ORACLE-L 
 Sent: Monday, June 10, 2002 3:58 PM
 
 
 Guys, 
 
 Building scripts from SQL generating SQL in Oracle on Unix.  I know
 that
 there are set commands so that Oracle does not put CR or LF in the
 middle of
 a long command.  Does anyone know these off the top of their head?
 
 Thanks, 
 Paula 
 
 set array...? 
 set maxdata...? 
 
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: RMAN[2]

2002-06-10 Thread Surendra . Tirumala


I have been doing this only. Still it is trying to write on target machine.

Thanks,
Surendra

-Original Message-
Sent: Monday, June 10, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


sorry ...
there is another way 

install RMAN on the remote machine and connect to the remote database with
sql*net


;-)  Ciao



- Original Message -
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 6:29 PM


 Hi.
 you must share the remote filesystem or make RMAN able to write on DLT.

 :-) Ciao
 - Original Message -
 From: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, June 10, 2002 6:53 PM
 Subject: RMAN


  Hello All,
 
  I have been working on a strategy to implement a RMAN based backup and
  recovery strategy.
  Can anyone please suggest me if there is a way to force the RMAN to
write
  the backups to a machine other than the one on which target database is
  present?
 
  Thanks for your help.
 
  Surendra
 
  --
  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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

2002-06-10 Thread Boivin, Patrice J


I am working on notes re. how to secure iAS on Win32 for us here.  Pete
Finnigan is working with SANS (and Oracle) to put an Oracle security
step-by-step guide together.

I asked Oracle Canada if, when they talk about Unbreakable Oracle, this
includes iAS on NT.  No response from the Oracle contact people.  Meanwhile
the MetaLink techs declined to provide guidelines as well, they said they
can only answer specific questions, one issue per TAR.  Now I see Oracle is
talking about unbreakable LINUX, perhaps because they may have more control
over OS configuration(?). 

If anyone has more info / suggestions / warnings on how to secure iAS on NT,
please bring them up.

Re. securing NT, for fun I tried the trial version of InfoStat scanner
(single user trial license) on my NT workstation here, to see the result
after having patched Windows NT workstation to the latest patchset and
windows update.  It found less than five critical vulnerabilities, but a
total of 108 vulnerabilities in all.  This includes the critical ones.  Most
of them do not appear to be major, it all depends on how high you want to
raise the bar I suppose.

C|Net e-mailed me a notice that their little application now scans for
vulnerabilities, it found nine on my workstation.

I am also doing searches on the 'net for info on how to secure Apache for
win32, not obvious since the apache group's focus is mostly LINUX and UNIX.

I am not endorsing one OS or the other but am a little frustrated with the
lack of info out there.  It's a bit of a cat and mouse game I think.  I also
find it hard to balance the opinions of people who like to see particular
vendors flounder on the one hand, and posturing and bravado on the part of
software and OS vendors on the other.

I like things to be cut and dry and this doesn't appear to be one of those
things.

Comments would be appreciated.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

Analyze running twice as long after upgrade to 8.1.7.2

2002-06-10 Thread Cherie_Machler



We just upgraded our data warehouse from version 8.0.4 to version 8.1.7.2
of Oracle.   We run on Sun Solaris 2.6 vith Veritas Quick I/O.

We do an analyze compute nightly with a 10% estimate of our large, main
fact table.   Before the upgrade, the analyze ran for 45 minutes.   Since
the upgrade, it's run three times at a consistent 90 minutes.

I am trying to research on Metalink but have not had much success.   Why
would this analyze suddenly run longer?   I wouldn't think that analyze
code is being modified much in new releases.   All the effort would go into
new packages like DBMS_STATS.   Is anyone aware of analyze changing in 8i.

Our analyze was of a partitioned table and was single-threaded, not
parallel.   I can see that it is still single-threaded.

We really didn't change much during the upgrade.   I added another datafile
to the SYSTEM tablespace (on the same file system as the previous file).

I also changed parallel_threads_per_cpu from 2 to 0.   However, since we
never did the analyze in parallel, I don't think it was an issue.

Any other ideas?   I'd like to be able to give our application owners some
explanation.

Thanks,

Cherie

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

OEM

2002-06-10 Thread Seema Singh



Hi
Does somone tell me how to check price information about Oracle enterprise 
manager product?
Is OEM available on Unix box also?
How to setup email with OEM?
Thx
-Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

grant access to another user's objects?

2002-06-10 Thread Jack Silvey


All,

We have a new info security group that is going to do
all the object grants on our warehouse. I don't want
them to login as schema owners to do this.

Until this time, I have been granting access to other
user's object by logging in as a dba, creating a
procedure in the owner's schema with the EXECUTE
immediate statement, and passing it the 'grant select
on table a' statement for execution. That way, the
grant actually executes as the object owner, but can
be issued from a DBA account. 

Short of having a custom SP in each user's schema for
this type of grant, can anyone think of another way?

thx,

jack silvey

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

Re: OEM

2002-06-10 Thread Tim Gorman


I think basic functionality of OEM comes with either EE or SE database
purchase;  I've never used OEM so I don't know what basic means.
Additional packs for OEM can be purchased additionally, including
diagnostics pack, tuning pack, change management pack, and mgmt pack
for SAP R/3, and I'm pretty sure that there is a mgmt pack for OraApps,
too...

Go to http://oraclestore.oracle.com and click on the tab for Database at
the top of the page.  You'll see info for the different OEM packs about
middle of page...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 2:44 PM



 Hi
 Does somone tell me how to check price information about Oracle enterprise
 manager product?
 Is OEM available on Unix box also?
 How to setup email with OEM?
 Thx
 -Seema


 _
 Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

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

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

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

RE: OEM

2002-06-10 Thread Arun Chakrapani


it is free which comes along with ur enterprise edition

-Original Message-
Sent: Monday, June 10, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L



Hi
Does somone tell me how to check price information about Oracle enterprise 
manager product?
Is OEM available on Unix box also?
How to setup email with OEM?
Thx
-Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

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

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

2002-06-10 Thread Charlie Mengler


9i R2 allows DBA's to do GRANTS on objects in other schemas.

Jack Silvey wrote:
 
 All,
 
 We have a new info security group that is going to do
 all the object grants on our warehouse. I don't want
 them to login as schema owners to do this.
 
 Until this time, I have been granting access to other
 user's object by logging in as a dba, creating a
 procedure in the owner's schema with the EXECUTE
 immediate statement, and passing it the 'grant select
 on table a' statement for execution. That way, the
 grant actually executes as the object owner, but can
 be issued from a DBA account.
 
 Short of having a custom SP in each user's schema for
 this type of grant, can anyone think of another way?
 
 thx,
 
 jack silvey
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jack Silvey
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
-- 
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: Oracle one-off Patch Install util

2002-06-10 Thread Peter Gram


Hi Rich 

Could you please inform me where you downloaded the RDA from ?
Metalink or OTN


Jesse, Rich wrote:

I've d/ld new versions of RDA and it is much better than it used to be.  I
got a clean run on Solaris the 1st try!

Now to beat them up over the invalid HTML that it creates.  There can't be
any H3 tags in a PRE block!  Of course every browser but Opera overlooks
this...

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

  

-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 9:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle one-off Patch Install util


RDA was written (or at least managed) by Anita Bardeen who used to
spend a good deal of time on this list...she'll be happy to know you
like it!

Rachel



-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk

/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like 
composing poetry or music

Donald Knuth
*/ 





smime.p7s
Description: application/pkcs7-signature

RE: Patch a Patch

2002-06-10 Thread VIVEK_SHARMA


Gogala , List

QUESTION IN CAPITALS BELOW 

THANKS

-Original Message-
Sent: Thursday, June 06, 2002 5:23 AM
To: Multiple recipients of list ORACLE-L


No. First of all, you cannot uninstall patch 8.1.7.3 because oracle 
hasn't provided
uninstall in any of the recent patch sets. You should just install 
over the existing
8.1.7.4. The ONLY uninstall is the full, cold backup. 

DO YOU MEAN RE-EXTRACTION OF THE COLD BACKUP TAKEN PRIOR TO APPLICATION 
OF THE PATCH ?

If you decide 
that the patch set
is not for you after, let's say, a week, you are stuck. Your only 
option is to ask oracle
for one off patch for your particular bug.

QUESTION - STUCK = SINCE COLD BACKUPS TAKEN BEFORE PATCH APPLICATION WILL NOT EXIST ?

That is, generally, why I do not recommend plunging, head first, into 
the new patchset as
soon as it appears. While waiting for two or three months, I monitor 
RDBMS forums on the
metablink and released one off patches. Only when I am reasonably 
sure that everything
is going to be hunky dory will I request my boss to authorize the 
upgrade. 



On 2002.06.05 18:18 david hill wrote:
 I was just wondering if I'm allowed to apply a new patch after I have
 already installed patch. Say from 8.1.7.3 to 8.1.7.4.
 Do I have to uninstall the .3 patch and then install the .4 or what?
 
 Thanks
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: david hill
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

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

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

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

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

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

OTN discount code.

2002-06-10 Thread Sunil_Nookala


List,
someone pl.. tell me the new OTN discount code for OCP exam??
she is such a pig_headed, insists on the code...damn..

Thanks,
Sunil Nookala.
-- 
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: grant access to another user's objects?

2002-06-10 Thread Stephane Faroult


Jack Silvey wrote:
 
 All,
 
 We have a new info security group that is going to do
 all the object grants on our warehouse. I don't want
 them to login as schema owners to do this.
 
 Until this time, I have been granting access to other
 user's object by logging in as a dba, creating a
 procedure in the owner's schema with the EXECUTE
 immediate statement, and passing it the 'grant select
 on table a' statement for execution. That way, the
 grant actually executes as the object owner, but can
 be issued from a DBA account.
 
 Short of having a custom SP in each user's schema for
 this type of grant, can anyone think of another way?
 
 thx,
 
 jack silvey
 

Yup. Save SCOTT's encrypted password (DBA_USERS), change it to
yaddayadda, CONNECT SCOTT/YADDAYADDA, ALTER USER SCOTT IDENTIFIED BY
VALUES 'encrypted thing' and nobody has noticed anything; then, being
SCOTT, you grant whatever you want. There is a become.sql on the Oriole
site which does it, and I have seen very similar versions elsewhere. In
fact this is the old way to do it ...
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
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: grant access to another user's objects?

2002-06-10 Thread Kevin Lange


If you are not up to 9i R2, you can always resort to the brute force method
that we always had to use.

As part of our initial DB Creates for a new project at a previous job, I
used to log have to log on as the object owner and perform grants to our
DBA's with the Grant option.   We used to do this before any application was
allowed out to public.  This way we could do the grants from any of our
DBA's accounts.  (Of course, this sucks when you have to change the grants
if your DBAs change, since you can't do the Grant Option to a role)  It was
a pain, but we had it down to an automated script that was used to build a
script that did the grants made it as painless as possible.

-Original Message-
Sent: Monday, June 10, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L


9i R2 allows DBA's to do GRANTS on objects in other schemas.

Jack Silvey wrote:
 
 All,
 
 We have a new info security group that is going to do
 all the object grants on our warehouse. I don't want
 them to login as schema owners to do this.
 
 Until this time, I have been granting access to other
 user's object by logging in as a dba, creating a
 procedure in the owner's schema with the EXECUTE
 immediate statement, and passing it the 'grant select
 on table a' statement for execution. That way, the
 grant actually executes as the object owner, but can
 be issued from a DBA account.
 
 Short of having a custom SP in each user's schema for
 this type of grant, can anyone think of another way?
 
 thx,
 
 jack silvey
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jack Silvey
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
-- 
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: Kevin Lange
  INET: [EMAIL PROTECTED]

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

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

Off Topic, slightly - Crystal Reports internal format


List,

I have an 'opportunity' to make some points with end users, if possible.

I'm booting the crystal reports users off of my production databases ( 
including
SAP, can you believe that? ). 

There reports will now run against a reporting server with snapshotted 
tables.

Their reports have been written with Crystal Reports 8 via ODBC.

2 problems:

1) When originally setup, the ODBC DSN matched the name of the database.
Not smart I know, but I inherited it.  Changing the data source in Crystal 
basically
forces you to rewrite the report.

2) The username has changed.  Production is CIMUSER, reporting is CIM_MV.
The table names have '_MV' suffix in the reporting database.

Any reasonable tool would allow you to change these items without too much 
fuss.

Either CR8 is not reasonable, or I have just not found out how to do it 
yet.  Without
reconstructing the report that is.

Any tips, resources, what have you are welcome.

If you know of any documentation detailing the *.rpt file format, that 
would be most
appreciated, as I could just modify their reports from the command line or 
with a
hex editor.

Thanks,

Jared


-- 
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: grant access to another user's objects?

2002-06-10 Thread Rachel Carmichael


Kevin Loney wrote about it as become_another_user.sql starting in the
7.3 DBA Handbook.

the problem is, if you use and enforce password history, you can't make
the changes because the saved off password won't be allowed to be
reused unless you cycle through a bunch of passwords (as many as you
keep history for)

Rachel

--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Jack Silvey wrote:
  
  All,
  
  We have a new info security group that is going to do
  all the object grants on our warehouse. I don't want
  them to login as schema owners to do this.
  
  Until this time, I have been granting access to other
  user's object by logging in as a dba, creating a
  procedure in the owner's schema with the EXECUTE
  immediate statement, and passing it the 'grant select
  on table a' statement for execution. That way, the
  grant actually executes as the object owner, but can
  be issued from a DBA account.
  
  Short of having a custom SP in each user's schema for
  this type of grant, can anyone think of another way?
  
  thx,
  
  jack silvey
  
 
 Yup. Save SCOTT's encrypted password (DBA_USERS), change it to
 yaddayadda, CONNECT SCOTT/YADDAYADDA, ALTER USER SCOTT IDENTIFIED BY
 VALUES 'encrypted thing' and nobody has noticed anything; then, being
 SCOTT, you grant whatever you want. There is a become.sql on the
 Oriole
 site which does it, and I have seen very similar versions elsewhere.
 In
 fact this is the old way to do it ...
 -- 
 Regards,
 
 Stephane Faroult
 Oriole Software
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Stephane Faroult
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-10 Thread MacGregor, Ian A.

Title: RE: Wrong Results Bug in Oracle 8.1.7.1



That's 
it. The init.ora parameter, IGNORE_IN_INDEX had been 
set to TRUE, but the indexes had not been rebuilt

Ian 
MacGregor
Stanford Linear Accelerator Center
ian@SLAC.Stanford.edu

  -Original Message-From: Aponte, Tony 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 9:18 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Wrong Results Bug in Oracle 8.1.7.1
  We had a similar issue, although it always resulted in an 
  ORA-600. It was with descending indexes as defined in the Peopletools 
  repository. We had to set _IGNORE_DESC_IN_INDEX=TRUE (and 
  _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply with the Certification 
  Requirements) and recreate the development databases. For Production, PS 
  Support gave the OK to recreate the indexes without having to redo the 
  upgrade.
  HTH Tony Aponte 
  -Original Message- From: 
  MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, June 10, 2002 1:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Wrong Results Bug in Oracle 8.1.7.1 
  Accounts payable. But this is not a Peoplesoft problem, 
  but an Oracle one. I tried the same query against another Peoplesoft 
  instance, and it ran fine. So there's something more than the view 
  involved here. It's in Oracle Support's court now.
  I must be living right. It's failing in development and 
  working in production. 
  Ian 
  -Original Message- Sent: 
  Sunday, June 09, 2002 7:13 PM To: Multiple recipients 
  of list ORACLE-L 
  what modules, if you dont mind me asking, i'm at a site where 
  we're going to implement HR, Financials And EPM 
  soon. 
  thanks, joe 
  MacGregor, Ian A. wrote: 
  Yep sure is.  
  Ian   -Original Message- 
  Sent: Sunday, June 09, 2002 5:43 AM To: Multiple recipients of list ORACLE-L   Ian, is 
  that peopleslop?  joe   MacGregor, Ian A. wrote: 
   SQL SELECT 
  VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM  10;  VOUCHER_  3394 
  3395 3396 3397 
  3398 3399 3400 
  3401 3402   
  set feedback on   1 SELECT VOUCHER_ID 
  FROM PS_VCHR_MM_VW  2* WHERE VOUCHER_ID 
  = '3394' SQL / VOUCHER_  
1 row selected. -- 
  Zounds !!! Select dump(voucher_id) shows that 
  Oracle is returning a null here.  
  Here a function is used to force the query to do full 
  tablescans  1 SELECT VOUCHER_ID FROM PS_VCHR_MM_VW  2* WHERE CONCAT(VOUCHER_ID,'A') = CONCAT('3394', 
  'A') SQL /  VOUCHER_  3394 
  - 
  I get the expected results if I force full 
  table scans.  I looked at the explain plan for the failing query and rebuilt 
  the ps_voucher index. This did not 
  change its erroneous results. I rebuilt the view itself again to no 
  avail. A check on Metalink revealed bug 1852163. Although this 
  bug's conditions were different from the one above, their were some 
  similarities. One workaround for bug 1852163
   alter session set 
  "_complex_view_merging" = true;  
  I tried this and the original query still gave 
  improper results. --- 
  All queries against the component tables of the view 
  work fine. -- 
  The view text is  CREATE VIEW 
  SYSADM.PS_VCHR_MM_VW AS SELECT DISTINCT A.BUSINESS_UNIT, 
  A.VOUCHER_ID, A.INVOICE_ID, A.INVOICE_DT, A.PROCESS_INSTANCE, 
  A.ENTRY_STATUS, A.POST_STATUS_AP, A.MATCH_ACTION, C.PPV_POST_FLG, 
  C.ERV_POST_FLG, A.ORIGIN FROM SYSADM.PS_VOUCHER A, SYSADM.PS_PO_LINE_MATCHED C 
  WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT_AP AND A.VOUCHER_ID = C.VOUCHER_ID 
  AND A.MATCH_ACTION IN ('Y', 'E') 
  - 
  If I run the select statement outside of the 
  view and tack on the 'voucher_id = ' clause SELECT DISTINCT A.BUSINESS_UNIT, 
  A.VOUCHER_ID, A.INVOICE_ID, A.INVOICE_DT, A.PROCESS_INSTANCE, 
  A.ENTRY_STATUS, A.POST_STATUS_AP, A.MATCH_ACTION, C.PPV_POST_FLG, 
  C.ERV_POST_FLG, A.ORIGIN FROM SYSADM.PS_VOUCHER A, SYSADM.PS_PO_LINE_MATCHED C 
  WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT_AP AND A.VOUCHER_ID = C.VOUCHER_ID 
  AND A.MATCH_ACTION IN ('Y', 'E') 
  and a.voucher_id = '3394' /  I get the expected results. The query plan matches the 
  one for the failing statement. -- 
  If I select more than voucher_id from the view 
  with the 'voucher_id = ' predicate the 
  other fields are projected correctly, but returns voucher_id as null.

Re: Off Topic, slightly - Crystal Reports internal format

2002-06-10 Thread Jeff Herrick



Jared

1) for the dbname...why not just change the SID in TNSNAMES
   that the ODBC DSN is using to point to the snap-shotted(?)
   instance

2) I think private synonyms would be the way to go for the
   table naming problem. Why did they not just use the same
   names on the snapshot sitebeen there done that, got the
   T-shirt

HTH...or maybe I didn't understand your requirement =8-)

Jeff Herrick
Jeff Herrick  Associates

On Mon, 10 Jun 2002 [EMAIL PROTECTED] wrote:

 List,

 I have an 'opportunity' to make some points with end users, if possible.

 I'm booting the crystal reports users off of my production databases (
 including
 SAP, can you believe that? ).

 There reports will now run against a reporting server with snapshotted
 tables.

 Their reports have been written with Crystal Reports 8 via ODBC.

 2 problems:

 1) When originally setup, the ODBC DSN matched the name of the database.
 Not smart I know, but I inherited it.  Changing the data source in Crystal
 basically
 forces you to rewrite the report.

 2) The username has changed.  Production is CIMUSER, reporting is CIM_MV.
 The table names have '_MV' suffix in the reporting database.

 Any reasonable tool would allow you to change these items without too much
 fuss.

 Either CR8 is not reasonable, or I have just not found out how to do it
 yet.  Without
 reconstructing the report that is.

 Any tips, resources, what have you are welcome.

 If you know of any documentation detailing the *.rpt file format, that
 would be most
 appreciated, as I could just modify their reports from the command line or
 with a
 hex editor.

 Thanks,

 Jared


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

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

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

2002-06-10 Thread Mohammad Rafiq


It used to be 'OTN20' a while ago but not finding anymore on Oracle 
sites.(old one was 'S36').

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 10 Jun 2002 13:33:58 -0800

List,
someone pl.. tell me the new OTN discount code for OCP exam??
she is such a pig_headed, insists on the code...damn..

Thanks,
Sunil Nookala.
--
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).




_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Limit on length of decode arguments??

2002-06-10 Thread Bob Metelsky


Hello all

In an effort to clean up data as I'm importing, I need to pass
the bad data to decode. It seems onece I pass  250 chars the code fails
with 
SQL*Loader-350: Syntax error at line 93.
Token longer than max allowable length of 258 chars

The articles on metalink hint on problems with the control file, I think
it's the *length* of argunets passed to decode

(:DEV_DATE 'No Mass'),
TO_DATE('06/11/1958','mm/dd/'),TRIM('12/31/200312/31/2003'),TO_DATE(
'12/31/2003', 'mm/dd/'),'02/30/2003',TO_DATE('2/28/2003',
'mm/dd/')


As soon as I add another comparison the code fails

Is their a length on decode statement??

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

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

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


REALLY?!??!  FINALLY!  Perhaps OraCorp has been listening to my rants on
this list and on MetaLink feedback?

9iR2 would seem to calm my ire on two security points:

1)  DBA is god  (Note the small g -- No need to mess w/The Big Guy)
2)  Even gods deserve to get audited.

Yay!  Yay!  Yay!  Who at Oracle do I owe a beer for this?   :)  :)

My Wife will have no idea why I'll be so happy tonite.  Man, that's sad.  ;)


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

 -Original Message-
 From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 4:09 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: grant access to another user's objects?
 
 
 9i R2 allows DBA's to do GRANTS on objects in other schemas.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: OEM


I think that you get a basic OEM with Oracle, but the add-on packs only
work if you have Enterprise Edition.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, June 10, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L


I think basic functionality of OEM comes with either EE or SE database
purchase;  I've never used OEM so I don't know what basic means.
Additional packs for OEM can be purchased additionally, including
diagnostics pack, tuning pack, change management pack, and mgmt pack
for SAP R/3, and I'm pretty sure that there is a mgmt pack for OraApps,
too...

Go to http://oraclestore.oracle.com and click on the tab for Database at
the top of the page.  You'll see info for the different OEM packs about
middle of page...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 2:44 PM



 Hi
 Does somone tell me how to check price information about Oracle enterprise
 manager product?
 Is OEM available on Unix box also?
 How to setup email with OEM?
 Thx
 -Seema


 _
 Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

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

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

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

2002-06-10 Thread Scott . Shafer


http://www.oracle.com

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 3:44 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  OEM
 
 
 Hi
 Does somone tell me how to check price information about Oracle enterprise
 
 manager product?
 Is OEM available on Unix box also?
 How to setup email with OEM?
 Thx
 -Seema
 
-- 
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 one-off Patch Install util


A simple search in MetaLink of RDA download will bring up links for RDA on
OpenVMS, Linux/Unix, Windohs, and even OracleRdb.

And, yes, the tool is much improved from when I first used it.  :)

GL!  HTH!

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

 -Original Message-
 From: Peter Gram [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 4:20 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Oracle one-off Patch Install util
 
 
 Hi Rich 
 
 Could you please inform me where you downloaded the RDA from ?
 Metalink or OTN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Asinine security in Oracle, Part Deux

2002-06-10 Thread Robert Monical


There are a ton of things I like about NT. Especially the
Win2K incarnation.
Production Internet server is not one of them.

I get a critical update notice about every week to 10 days.
These almost always require a reboot of the server.
Some of the vulnerabilities are pretty significant.

As nice as NT is for ease of use and hardware compatibility, it appears
to be very difficult to secure.
Not just an Oracle 9iAS problem: appears that Microsoft has trouble
getting it secure as well.

Given the evolving state of the Microsift distributed computing
architecture, and how diverse features like Internet Explorer are an
integral part of the operating system I'm not confident that
the future holds a lot of promise for NT security. NT keeps changing far
too rapidly, it is too big, and the components are too tightly
coupled..


At 12:19 PM 6/10/2002 -0800, Boivin, Patrice J wrote:
I am working on notes re. how to secure iAS on
Win32 for us here. Pete
Finnigan is working with SANS (and Oracle) to put an Oracle 
security
step-by-step guide together.

I asked Oracle Canada if, when they talk about Unbreakable
Oracle, this
includes iAS on NT. No response from the Oracle contact
people. Meanwhile
the MetaLink techs declined to provide guidelines as well, they said
they
can only answer specific questions, one issue per TAR. Now I see
Oracle is
talking about unbreakable LINUX, perhaps because they may have more
control
over OS configuration(?). 

If anyone has more info / suggestions / warnings on how to secure iAS on
NT,
please bring them up.

Re. securing NT, for fun I tried the trial version of InfoStat
scanner
(single user trial license) on my NT workstation here, to see the
result
after having patched Windows NT workstation to the latest patchset
and
windows update. It found less than five critical vulnerabilities,
but a
total of 108 vulnerabilities in all. This includes the critical
ones. Most
of them do not appear to be major, it all depends on how high you want
to
raise the bar I suppose.

C|Net e-mailed me a notice that their little application now scans
for
vulnerabilities, it found nine on my workstation.

I am also doing searches on the 'net for info on how to secure Apache
for
win32, not obvious since the apache group's focus is mostly LINUX and
UNIX.

I am not endorsing one OS or the other but am a little frustrated with
the
lack of info out there. It's a bit of a cat and mouse game I
think. I also
find it hard to balance the opinions of people who like to see
particular
vendors flounder on the one hand, and posturing and bravado on the part
of
software and OS vendors on the other.

I like things to be cut and dry and this doesn't appear to be one of
those
things.

Comments would be appreciated.

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

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

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


Surendra - That is inherent in RMAN. RMAN only writes on the target system.
I do believe that one is on the exam.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L


I have been doing this only. Still it is trying to write on target machine.

Thanks,
Surendra

-Original Message-
Sent: Monday, June 10, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


sorry ...
there is another way 

install RMAN on the remote machine and connect to the remote database with
sql*net


;-)  Ciao



- Original Message -
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 6:29 PM


 Hi.
 you must share the remote filesystem or make RMAN able to write on DLT.

 :-) Ciao
 - Original Message -
 From: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, June 10, 2002 6:53 PM
 Subject: RMAN


  Hello All,
 
  I have been working on a strategy to implement a RMAN based backup and
  recovery strategy.
  Can anyone please suggest me if there is a way to force the RMAN to
write
  the backups to a machine other than the one on which target database is
  present?
 
  Thanks for your help.
 
  Surendra
 
  --
  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: claudio cutelli
  INET: [EMAIL PROTECTED]

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

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

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

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


Jesse - Does the DBA have access to the audit tables? If so, just edit
yourself back out. I was reading a book about someone that tracks down
hackers on the Internet. One of his security methods is to copy the system
logs over to another system every few minutes. He checks to see if the log
ever gets smaller, which would mean that a hacker erased his/her tracks.
Dennis Williams 
DBA 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Monday, June 10, 2002 5:17 PM
To: Multiple recipients of list ORACLE-L


REALLY?!??!  FINALLY!  Perhaps OraCorp has been listening to my rants on
this list and on MetaLink feedback?

9iR2 would seem to calm my ire on two security points:

1)  DBA is god  (Note the small g -- No need to mess w/The Big Guy)
2)  Even gods deserve to get audited.

Yay!  Yay!  Yay!  Who at Oracle do I owe a beer for this?   :)  :)

My Wife will have no idea why I'll be so happy tonite.  Man, that's sad.  ;)


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

 -Original Message-
 From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 4:09 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: grant access to another user's objects?
 
 
 9i R2 allows DBA's to do GRANTS on objects in other schemas.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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


Cherie 
Thanks for the input. This would be an OLTP database, with continual
inserts/updates/deletes. I guess that CREATE INDEX NOLOGGING would save
something in the redo logs. I'm not convinced that having a tablespace
containing only indexes set to NOLOGGING would save redo. Since redo is
usually created by SQL statements (as I understand it), there wouldn't be
any redo against the index, unless you do an ALTER INDEX REBUILD. The
downside of this would be that in a recovery you would have to remember to
rebuild the indexes in that tablespace. If there isn't much benefit, then I
don't like even a small cost.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, June 10, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L



Dennis,

We have set particular indexes to nologging when building them.   These are
indexes that we drop every night for our warehouse load.

It is a hassle because whenever we clone this database to our QA box, those
nologged indexes get corrupt and we have to rebuild them.   Takes us three
hours to do.   We have recovered the database too and did have to rebuild
the indexes after.I guess you have to balance the regular time-savings
in building/rebuilding indexes with the time cost in mean-time-to-recover.

I've never changed an entire index tablespace to nologging.

Cherie Machler
Oracle DBA
Gelco Information Network


 

DENNIS WILLIAMS

DWILLIAMS@LIFE   To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED] 
TOUCH.COMcc:

Sent by:  Subject: Nologging index
tablespaces?   
[EMAIL PROTECTED]

m

 

 

06/10/02 01:33

PM

Please respond

to ORACLE-L

 

 





Have any of you changed your index tablespaces to NOLOGGING? Offhand it
seems like a possible performance increase and less redo, but at the
expense
of having to remember to rebuild the indexes in a recovery. And I don't
like
to have special things to remember in a crisis.
Dennis Williams 20% OCP
DBA
Lifetouch, Inc.

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

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

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


1) for the dbname...why not just change the SID in TNSNAMES
   that the ODBC DSN is using to point to the snap-shotted(?)
   instance

I'm eliminating tnsnames.ora files on the desktop, so that is out.

2) I think private synonyms would be the way to go for the
   table naming problem. Why did they not just use the same
   names on the snapshot sitebeen there done that, got the
   T-shirt

Private synonyms will either:
* not work
* confuse the user.

'They' is me. The table names reflect the fact that the
tables are materialized views.  FWIW there are public 
synonyms for the tables, but Crystal doesn't use them.

Jared

-- 
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: grant access to another user's objects?

2002-06-10 Thread Ron Thomas



Pulled this off the other list a long time ago.  It was posted by Raj Mithal.
---
Try this:-

Becoming a User with Password Expiry enabled

In Oracle 7.x you could become a user by storing the encrypted password,
changing the password and then reinserting the old password,
e.g.: SELECT username, password FROM dba_users;
(this shows the encrypted password)

username Password (encrypted)
GP 09HJKLK
Temporarily modify the password:
ALTER USER GP IDENTIFIED BY GP;
connect GP/GP
-- Restore the original password
ALTER USER GP IDENTIFIED BY VALUES '09HJKLK';

From Oracle8.x onwards, if you are using new password expiry features, as
soon as you change the password (alter user ... identified by ...), the
expiry date of the user is shifted further as defined by the DBA.
So a work around is :

Oracle creates the encrypted password based on username and supplied
password.

Create another user by same name but make sure oracle stores in lower case.

CREATE USER gp IDENTIFIED BY abc123;
SELECT username, password FROM dba_users;

username password
GP 09HJKLK
gp I0989J
-- This creates the encrypted version of the abc123
-- password for user GP.

Fill in the encrypted password corresponding to lowercase username,gp into
user GP:
ALTER USER GP IDENTIFIED BY VALUES 'I0989J';
CONNECT GP/abc123;

Afterwards drop user gp; (make sure u enclose in , to force oracle to
drop the lower case user)

Restore the original password for GP:
ALTER USER GP IDENTIFIED BY VALUES '09HJKLK';

That is it, u have become the other user.


Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.  
--William Butler
Yeats.


   

  wisernet100@yahoo

  .com To:   [EMAIL PROTECTED]  

  Sent by: cc: 

  [EMAIL PROTECTED] Subject:  Re: grant access to another 
user's objects?   
   

   

  06/10/02 02:55 PM

  Please respond to

  ORACLE-L 

   

   





Kevin Loney wrote about it as become_another_user.sql starting in the
7.3 DBA Handbook.

the problem is, if you use and enforce password history, you can't make
the changes because the saved off password won't be allowed to be
reused unless you cycle through a bunch of passwords (as many as you
keep history for)

Rachel

--- Stephane Faroult [EMAIL PROTECTED] wrote:
 Jack Silvey wrote:
 
  All,
 
  We have a new info security group that is going to do
  all the object grants on our warehouse. I don't want
  them to login as schema owners to do this.
 
  Until this time, I have been granting access to other
  user's object by logging in as a dba, creating a
  procedure in the owner's schema with the EXECUTE
  immediate statement, and passing it the 'grant select
  on table a' statement for execution. That way, the
  grant actually executes as the object owner, but can
  be issued from a DBA account.
 
  Short of having a custom SP in each user's schema for
  this type of grant, can anyone think of another way?
 
  thx,
 
  jack silvey
 

 Yup. Save SCOTT's encrypted password (DBA_USERS), change it to
 yaddayadda, CONNECT SCOTT/YADDAYADDA, ALTER USER SCOTT IDENTIFIED BY
 VALUES 'encrypted thing' and nobody has noticed anything; then, being
 SCOTT, you grant whatever you want. There is a become.sql on the
 Oriole
 site which does it, and I have seen very similar versions elsewhere.
 In
 fact this is the old way to do it ...
 --
 Regards,

 Stephane Faroult
 Oriole Software
 --
 Please see the official ORACLE-L FAQ:

RE: grant access to another user's objects?


I'm after the audits as a point of tracking my DDL/DCL as SYSDBA more than
for intrusion detection.  As you've eluded to, the truly paranoid would add
more layers of protection and monitoring via triggers, audit opts,
DBMS_JOB/cron jobs, etc. to provide increased accountability and tracking.
Since I only have time to be somewhat paranoid, I've only implemented a few
of these.  :)

And Oracle Support asked me why I would want to audit SYS.  ;)

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


 -Original Message-
 From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 5:34 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: grant access to another user's objects?
 
 
 Jesse - Does the DBA have access to the audit tables? If so, just edit
 yourself back out. I was reading a book about someone that tracks down
 hackers on the Internet. One of his security methods is to 
 copy the system
 logs over to another system every few minutes. He checks to 
 see if the log
 ever gets smaller, which would mean that a hacker erased 
 his/her tracks.
 Dennis Williams 
 DBA 20% OCP
 Lifetouch, Inc.
 [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: grant access to another user's objects?


Jesse - On another list today someone mentioned that auditors were upset
that the DBA had access to the application tables (like payroll tables, for
example). I was just curious whether this new feature would eliminate the
autitors' concern. I trust you, but man, those auditors are tough.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Monday, June 10, 2002 6:01 PM
To: Multiple recipients of list ORACLE-L


I'm after the audits as a point of tracking my DDL/DCL as SYSDBA more than
for intrusion detection.  As you've eluded to, the truly paranoid would add
more layers of protection and monitoring via triggers, audit opts,
DBMS_JOB/cron jobs, etc. to provide increased accountability and tracking.
Since I only have time to be somewhat paranoid, I've only implemented a few
of these.  :)

And Oracle Support asked me why I would want to audit SYS.  ;)

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


 -Original Message-
 From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 5:34 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: grant access to another user's objects?
 
 
 Jesse - Does the DBA have access to the audit tables? If so, just edit
 yourself back out. I was reading a book about someone that tracks down
 hackers on the Internet. One of his security methods is to 
 copy the system
 logs over to another system every few minutes. He checks to 
 see if the log
 ever gets smaller, which would mean that a hacker erased 
 his/her tracks.
 Dennis Williams 
 DBA 20% OCP
 Lifetouch, Inc.
 [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

2002-06-10 Thread Jahan Shanai


It is still 'OTN20'.

Regards


Jahan

-Original Message-
Sent: Tuesday, 11 June 2002 10:03
To: Multiple recipients of list ORACLE-L


It used to be 'OTN20' a while ago but not finding anymore on Oracle 
sites.(old one was 'S36').

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 10 Jun 2002 13:33:58 -0800

List,
someone pl.. tell me the new OTN discount code for OCP exam??
she is such a pig_headed, insists on the code...damn..

Thanks,
Sunil Nookala.
--
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).




_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

Attention: 
=
This e-mail message and accompanying data may contain information that is 
confidential and subject to legal privilege. If you are not the intended 
recipient, you are notified that any use, dissemination, or copying of any 
part of this e-mail message and accompanying data, is prohibited. If you 
have received this e-mail message in error, please notify us immediately 
and delete this e-mail message from your computer.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jahan Shanai
  INET: [EMAIL PROTECTED]

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

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

Re: Off Topic, slightly - Crystal Reports internal format

2002-06-10 Thread Jeff Herrick




On Mon, 10 Jun 2002 [EMAIL PROTECTED] wrote:

 1) for the dbname...why not just change the SID in TNSNAMES
that the ODBC DSN is using to point to the snap-shotted(?)
instance

 I'm eliminating tnsnames.ora files on the desktop, so that is out.


Sorry...I haven't used onames or OID yet; but does it not still provide
the same level of abstraction as TNSNAMES without the file? The ODBC
DSN is still separate and will have to resolve whether it is doing so
through names or whatever. I still think you would change the logical
side (service_name) to point at a different physical db and Bill's
fine ODBC software won't care. The risk is that they use the same DSN for
updating; then you would have a problem.

 2) I think private synonyms would be the way to go for the
table naming problem. Why did they not just use the same
names on the snapshot sitebeen there done that, got the
T-shirt

 Private synonyms will either:
 * not work
 * confuse the user.

 'They' is me. The table names reflect the fact that the
 tables are materialized views.  FWIW there are public
 synonyms for the tables, but Crystal doesn't use them.

 Jared

'Crystal doesn't use them'??? then the schema must be encoded
in the SQR SQL statements. If this is true then you have
another problem because you want to rename the schema. If you don't
want to modify/recompile the SQR then why not create the schema
that SQR expects and front the MV tables with synonyms.

Oh...and when did we start caring if the user was confused? =8-) j/k

Cheers

Jeff H.


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

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

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


What part of *DATABASE* Administrator don't they understand?

Jared





DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/10/2002 04:14 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: grant access to another user's objects?


Jesse - On another list today someone mentioned that auditors were upset
that the DBA had access to the application tables (like payroll tables, 
for
example). I was just curious whether this new feature would eliminate the
autitors' concern. I trust you, but man, those auditors are tough.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Monday, June 10, 2002 6:01 PM
To: Multiple recipients of list ORACLE-L


I'm after the audits as a point of tracking my DDL/DCL as SYSDBA more than
for intrusion detection.  As you've eluded to, the truly paranoid would 
add
more layers of protection and monitoring via triggers, audit opts,
DBMS_JOB/cron jobs, etc. to provide increased accountability and tracking.
Since I only have time to be somewhat paranoid, I've only implemented a 
few
of these.  :)

And Oracle Support asked me why I would want to audit SYS.  ;)

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


 -Original Message-
 From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 5:34 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: grant access to another user's objects?
 
 
 Jesse - Does the DBA have access to the audit tables? If so, just edit
 yourself back out. I was reading a book about someone that tracks down
 hackers on the Internet. One of his security methods is to 
 copy the system
 logs over to another system every few minutes. He checks to 
 see if the log
 ever gets smaller, which would mean that a hacker erased 
 his/her tracks.
 Dennis Williams 
 DBA 20% OCP
 Lifetouch, Inc.
 [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Off Topic, slightly - Crystal Reports internal format