| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> unsubscribe
unsubscribe
FreeLists Mailing List Manager wrote:
oracle-l Digest Thu, 07 Apr 2005 Volume: 02 Issue: 095 In This Issue: Get
windows domain user in a web application RE: Get windows domain user in a
webapplication Re: rman duplicate fails to identify file Index on status
field? Re: Index on status field? Re: Index on status field? RE: rman
duplicate fails to identify file Clone to new box Re: 10g Clusterware
(OracleCRS) documentation ? Query capture RTFM: Oracle 10g OS-specific
default values Re: Query capture Re: Query capture RE: Index on status
field?Re: RTFM: Oracle 10g OS-specific default values Re: Clone to new box
Re: RTFM: Oracle 10g OS-specific default values Re: Clone to new box Re:
RTFM: Oracle 10g OS-specific default values Re: mysql Re: Query capture Re:
RTFM: Oracle 10g OS-specific default values Re: Query capture Transparent
Gateway for MSSQL not working Re: Clone to new box RE: mysql - OT Re: RTFM:
Oracle 10g OS-specific default values RE: Transparent Gateway for MSSQL not
working Re: ANSI join syntax Re: mysql RE: rman duplicate fails to identify
file 9i Rac config RE: Any way to run more than listener on the same port?
Re: Oracle on EMC Clarion CX500 Re: anyone use java EJBs? Multiple installed
versions of Oracle RE: library cache lock Re: Re: A SQL solution possible?
RE: Any way to run more than listener on the same port? Re: Query capture
Re:Query capture Oracle Application 11.5.4 cloning OPIRIP: Uncaught Error
10gRe: Query capture Re: OPIRIP: Uncaught Error 10g Re: Query capture Re:
Query capture Re: Query capture RE: ANSI join syntax Re: Query capture Re:
Query capture Re: Clone to new box RE: Oracle Application 11.5.4 cloning RE:
Multiple installed versions of Oracle RE: Transparent Gateway for MSSQL not
working (solved) Changing the SSL Port in 10 GAS Release 2 RE: Changing the
SSL Port in 10 GAS Release 2
------------------------------ Subject: RE: Get windows domain user in a webapplication Date: Thu, 7 Apr 2005 13:48:32 +0300 From: "Ciocoiu Adrian" <adrian.ciocoiu_at_siemens.com>[2] Thank you for quick answer. I'm quite new in oracle technology and maybe this is the reason that I do not understand exactly what you are saying. In table V$SESSION are stored database users, amI right? In my application all database operations are done by the same user, configured in dad file. What I need is the user who make a request to web server. This a windows domain user and he has no rights to database. He only can access the web application. I hope now is more clear what I want.
regards, Adrian Ciocoiu ________________________________ From: StephaneFaroult [mailto:sfaroult_at_roughsea.com[3]] Sent: Thursday, April 07, 2005 2:14PM To: Ciocoiu Adrian Subject: Re: Get windows domain user in a web application Adrian, Check in V$SESSION. If you don't find here the information you want, it is probably possible to set in (on the application side) using the DBMS_APPLICATION_INFO package. Check the 'Supplied PL/SQL packages' manual. HTH, Stephane Faroult RoughSea Ltd http://www.roughsea.com[4]On Thu, 7 Apr 2005 12:50 , 'Ciocoiu Adrian' <adrian.ciocoiu_at_siemens.com>[5] sent: Hello, I have an web application hostedon Oracle application server writen in plsql(unix machine). In our company we have IE as standard browser. How can I get windows domain user on server ? Thank you very much -- http://www.freelists.org/webpage/oracle-l[6]
------------------------------ Subject: Re: rman duplicate fails to identifyfile Date: Thu, 7 Apr 2005 09:13:09 -0400 From: "Slava Zayarny" <Slava.Zayarny_at_sas.com>[7] Tricia, One sure thing that will cause duplicationto fail (especially when = going off tape media manager layer, which is not the case here) is difference = in file ownership. For instance, you backed up source database as user ORAPRD. On the = auxiliary (duplicate) node you are restoring these files as user ORADEV. Two other things to consider are: difference in Oracle versions and OS=20 versions between sourceand auxiliary nodes. Cheers, Slava Zayarny Oracle DBA
----------------------------------------------------------------- From:Tricia McKellar <tricia_mckellar_at_ncsu.edu>[8] Subject: rman duplicate fails to identify file Date: Wed, 6 Apr 2005 17:38:44 -0400 Hello, I'm having trouble duplicating a db to another host with a different=20 path structure (oracle 9.2.0.6 on solaris). I'm able to connect to=20 both db's and the filerename parameters in the initDUP.ora seem to be=20 working--rman seems toknow to rename /prod/oradata/vsid/ifs_lobs01.dbf TO /dup/oradata/vsid5/ifs_lobs01.dbf but rman seems to get stuck on the backup pieces. The backup files do=20 exist. I've been rman'ing to disk only (not tape). I've tried copying=20 the backup pieces to the dup host, but it still gets stuck. Ideas? ### ... restoring datafile 00034 to /dup/oradata/vsid5/ifs_lobs13.dbf restoring datafile 00035 to /dup/oradata/vsid5/ifs_lobs14.dbf RMAN-00571: =
------------------------------ Date: Thu, 7 Apr 2005 06:26:39 -0700 (PDT)From: Martic Zoran <zoran_martic_at_yahoo.com>[9] Subject: Index on status field? The index is on the simple status field on the huge partitioned table per day. Initially it is populated with value 0. When the record is processedI am thinking to put the value to NULL so removing entries from the index and making the index more compact (in opposed to 1). The idea is simple, but not sure about the drawbacks? If you have 1M rows of status fieldwith 0 and 400M with NULL. Then you insert another many millions into the table every day, then put them back to NULL after they are processed. Howis Oracle choosing where to place the new 0 in the index? What is going tohappened to the index in simple manner? Is it going to grow or as we all know old blocks will be reused? I should think of this myself or even try it,but too busy at the moment. Also, my brain is not working nicely at the
moment. Thanks in advance. Regards, Zoran __________________________________Yahoo! Messenger Show us what our next emoticon should look like. Join the fun. http://www.advision.webevents.yahoo.com/emoticontest[10]
------------------------------ Date: Thu, 7 Apr 2005 09:48:38 -0400 From:rjamya <rjamya_at_gmail.com>[11] Subject: Re: Index on status field? how about using a FBI so you index only those rows with status <>0? Raj On Apr 7, 2005 9:26 AM, Martic Zoran <zoran_martic_at_yahoo.com>[12] wrote: The index is on thesimple status field on the huge partitioned table per day. Initially it ispopulated with value 0. When the record is processed I am thinking to put the value to NULL so removing entries from the index and making the index more compact (in opposed to 1). The idea is simple, but not sure about the drawbacks? If you have 1M rows of status field with 0 and 400M with NULL. Then you insert another many millions into the table every day, then put themback to NULL after they are processed. How is Oracle choosing where to place the new 0 in the index? What is going to happened to the index in simple manner? Is it going to grow or as we all know old blocks will be reused? I should think of this myself or even try it, but too busy at the moment. Also, my brain is not working nicely at the moment. Thanks in
advance. Regards, Zoran __________________________________ Yahoo! MessengerShow us what our next emoticon should look like. Join the fun. http://www.advision.webevents.yahoo.com/emoticontest[13] -- http://www.freelists.org/webpage/oracle-l[14]
 |
 |