RE: bind variables in VB using OO4O

2004-01-21 Thread Prem Khanna J
://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Thanx - I cleared the exam -- another OCP question

2004-01-19 Thread Prem Khanna J
Hi list , thanx a lot to all of you . i cleared the #1Z0-031 exam last week . thanx again for all the support given by you friends. Kind Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services

RE: Thanx - I cleared the exam

2004-01-19 Thread Prem Khanna J
ready to pass the exam. Dennis Williams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Thanx - I cleared the exam

2004-01-19 Thread Prem Khanna J
: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

test mail -- plz. ignore

2004-01-15 Thread Prem Khanna J
test mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

OCP question from Boson practice tests

2004-01-07 Thread Prem Khanna J
no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Prem Khanna J
) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
would expect. /Cary The second answer is the one i mostly fail to find. Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
a nicer resume. I agree . Because resume is the mirror which reflects an individual until the interview happens . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Prem Khanna J
://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

standby database configuration in 9iR2 SE ?

2003-12-16 Thread Prem Khanna J
, will the steps involved be quite different or almost the same ? Your suggestions please . Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: standby database configuration in 9iR2 SE ?

2003-12-16 Thread Prem Khanna J
for manual recovery which is possible in SE. Regards, Jp. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Standby is only for Enterprise Ed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City

utl_smtp and japanese characters ?

2003-12-10 Thread Prem Khanna J
Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: dba studio in oracle9.2

2003-12-05 Thread Prem Khanna J
. But there is no DBA Studio in oracle tools. Any comment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Analytic bug in 9.2.0.4

2003-12-04 Thread Prem Khanna J
on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Finding SID of current session

2003-12-02 Thread Prem Khanna J
need to know this for the where clause ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: shared server or dedicated server -- How to find ?

2003-12-02 Thread Prem Khanna J
ACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting se

Re: shared server or dedicated server -- How to find ?

2003-12-02 Thread Prem Khanna J
(B -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting se

shared server or dedicated server -- How to find ?

2003-12-01 Thread Prem Khanna J
List , I would like to know whether my database is running on shared server (MTS) or dedicated server mode ? How do i find it out ? it's oracle 9.2.0.3 on Win2k. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL

test mail -- plz ignore

2003-11-28 Thread Prem Khanna J
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

test mail ...... plz ignore

2003-11-19 Thread Prem Khanna J
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: ** find whether table or index being accessed

2003-11-18 Thread Prem Khanna J
/2AojmRpnmgEADs= --Boundary-00=_4PUK6RO0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

test mail -- plz ignore

2003-11-12 Thread Prem Khanna J
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re:How to drop a datafile ?

2003-11-01 Thread Prem Khanna J
for a software vendor long ago on a faraway planet, and that vendor certainly wasn't Oracle. Dennis Williams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: RE: How to drop a datafile ?

2003-10-30 Thread Prem Khanna J
in the data dictionary with the status RECOVER or OFFLINE. If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: RE: How to drop a datafile ?

2003-10-29 Thread Prem Khanna J
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: How to drop a datafile ?

2003-10-29 Thread Prem Khanna J
-- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
= --Boundary-00=_FF7IDL51VA40-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --Boundary-00=_ZH8IYHI1VA40-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
doc 111316.1 doesn't mention about using OEM for the same. so i hope it cannot be done with OEM. am i right LIST ? so how do i do it from sqlplus ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network

Re: Passed Net8 OCP Exam

2003-10-16 Thread Prem Khanna J
BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --Boundary-00=_4CPVRN00-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: Find an unprintable character inside a column....

2003-10-09 Thread Prem Khanna J
Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail

Re: Experiences setting OPEN_CURSORS for Java applications

2003-10-03 Thread Prem Khanna J
am definitely interested in helping you to get it working though. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Wooo.....Cary's book -- Out of stock !

2003-10-03 Thread Prem Khanna J
reading. ... I still not have finished Tom Kite Expert one on one Stephane Paquette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

[no subject]

2003-10-01 Thread Prem Khanna J
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: exam

2003-10-01 Thread Prem Khanna J
exam today with good marks. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Using dimensions

2003-09-30 Thread Prem Khanna J
one use them? in SQLs? I have scanned TFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: RE: Using dimensions

2003-09-30 Thread Prem Khanna J
OwwThank God Raj hasn't replied yet :-) Thanx Gints. Jp. 30-09-2003 18:24:28, Gints Plivna [EMAIL PROTECTED] wrote: google gave me for example such an address http://www.gaarde.org/acronyms/ I'm sure one of hundreds or even thousands -Original Message- From: Prem Khanna J

Re:Suggestion reg. encryption ??

2003-09-30 Thread Prem Khanna J
the white paper that you received from iDefense? Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Prem Khanna J
... is it JDK version/app. server specific ? can JDBC Expert for JDK 1.4.1_03/jboss 3.2.1 used for JDK 1.4.1_03/apache 2.0.4 ?? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Suggestion reg. encryption ??

2003-09-29 Thread Prem Khanna J
? hope it's down. thanx for your prompt reply..as u always do :) Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Suggestion reg. encryption ??

2003-09-28 Thread Prem Khanna J
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Prem Khanna J
what is transient chunk recurrent chunk ? Regards, Jp. P.S.Thanx Naveen. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Prem Khanna J
. WHat is difference in both x$ view is little bit confusing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Prem Khanna J
documented ways. That way you'll probably avoid a lot of confusion, especially when database versions might change.. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: SQL AREA and LIBARARY CACHE size?

2003-09-25 Thread Prem Khanna J
Hi Manoj, quoteIn my system size of library cache is approx 48 mb and sql area 417 mb/quote can i know where/how did u get the statistics from ? Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services

Re: RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Prem Khanna J
24-09-2003 00:19:47, Mercadante, Thomas F [EMAIL PROTECTED] wrote: I just read the first chapter on-line. Now I gotta order the book. Where Tom ? is it on Amazon or bookpool or BN ... ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL

Re:Cary's book -- Out of stock !

2003-09-23 Thread Prem Khanna J
recommendation is definitely Barnes Noble. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Prem Khanna J
the list messages. On 2003.09.22 02:24, Prem Khanna J wrote: Hi Raju, Check the doc. i have attached. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Prem Khanna J
Anand, it's the same doc. mentioned by Mladen. i have sent it to your email address ONLY. Jp. 22-09-2003 16:20:21, Anand Kumar [EMAIL PROTECTED] wrote: Prem, Can you mail me the same document -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Prem Khanna J
ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Bug in 9.2.0.4

2003-09-22 Thread Prem Khanna J
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Cary's book -- Out of stock !

2003-09-22 Thread Prem Khanna J
Hi List, I have placed an order for Cary's book @bookpool. Does someone know when it will be in stock ? Can Mr.Cary Millsap let me know that ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network

Re: RE: Bug in 9.2.0.4

2003-09-22 Thread Prem Khanna J
Ohhh ! ...i don't find 3110923 patch fix for Ms-Win :( 22-09-2003 20:39:52, Nigel Bishop [EMAIL PROTECTED] wrote: Ooops - Sorry Monday morning cut paste error - patch number should read 3110923 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET

Re: RE: Cary's book -- Out of stock !

2003-09-22 Thread Prem Khanna J
priced Indian edition of the book should also be out shortly. You could have bought the same when you were in India. You could have saved some $$. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services

Re: ORA-03237 with LOB and locally managed tablespace

2003-09-22 Thread Prem Khanna J
we got ORA-03237. With dictionnary managed tablespace we don't have this problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Cary's book -- Out of stock !

2003-09-22 Thread Prem Khanna J
as to be released and not shipping :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: RE: download metalink articles - save target as

2003-09-22 Thread Prem Khanna J
. What's the easiest way to save these files locally? I want to because sometimes the more useful ones go away. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: RE: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Prem Khanna J
good Cary!! RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Bug in 9.2.0.4 when order by constant desc

2003-09-21 Thread Prem Khanna J
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle 9i new features - by Connor McDonald

2003-09-21 Thread Prem Khanna J
..a paper presented by Connor at OracleWorld 2003 is here. http://tinyurl.com/o6hp ..thought it may be of interest for many on this list. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services

Re: How do we know that an index need to be rebuilt.

2003-09-21 Thread Prem Khanna J
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: RE: RMAN error - can someone help ?

2003-09-17 Thread Prem Khanna J
stuck up here and not able to proceed further. i tried it repeatedly. Thanx once again. Jp. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Tuesday, September 16, 2003 10:35 PM To: Multiple recipients of list ORACLE-L Subject: RMAN

RMAN-03015 error during TSPITR

2003-09-16 Thread Prem Khanna J
Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network

RMAN error - can someone help ?

2003-09-16 Thread Prem Khanna J
append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services

Re: RE: RE: Oracle Press OCP exam guide frustrations

2003-09-16 Thread Prem Khanna J
course and passed in first attempt Regards Rafiq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Can i have a copy of metalink doc 52576.1 ?

2003-09-12 Thread Prem Khanna J
Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail

Re: Good small reference !

2003-09-12 Thread Prem Khanna J
for DBA ) the SQL scripts ,packages and all required views. UTL*.sql , DBMS_* DBA_* V$* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: Metalink doc 52576.1 ?

2003-09-12 Thread Prem Khanna J
PROTECTED] wrote: Prem, You may want to check out Note# 1058332.6 for this. It appears that the reference to Note# 52576.1 is bogus. Good Luck! Faan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: quick rman question

2003-09-11 Thread Prem Khanna J
about a backup piece from a rman catalog only or does it also delete the backup piece itself from the tape? thanks gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Database Link

2003-09-10 Thread Prem Khanna J
file found. Oracle 9.2.0.4 on windows. Yechiel Adar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

OT - how/where to buy oracle test voucher ?

2003-09-10 Thread Prem Khanna J
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Metalink doc 52576.1 ?

2003-09-10 Thread Prem Khanna J
Hi List, I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink. Can someone mail me if u have a copy of the same ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: RE: Oracle on Win2000

2003-09-04 Thread Prem Khanna J
Bala,my reply is also the same as John said. PC Anywhere or the console straightaway Jp. 04-09-2003 17:34:26, Hallas, John, Tech Dev [EMAIL PROTECTED] wrote: PC Anywhere or direct from the console -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J

Re: RE: RMAN backup and recovery scenarios

2003-09-04 Thread Prem Khanna J
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re:RMAN backup and recovery scenarios

2003-09-04 Thread Prem Khanna J
://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RMAN backup and recovery scenarios

2003-09-03 Thread Prem Khanna J
Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: alter system reset

2003-09-02 Thread Prem Khanna J
Arup Bhai, i remember oracle docs saying NOT to open a spfile and that it may even corrupt the file. Is that always true ? Can the spfile be opened ? can you kindly explain me ? Thanks Regards, Prem Khanna J. 02-09-2003 04:14:26, Arup Nanda [EMAIL PROTECTED] wrote: Does the entry even exist

Re: alter system reset

2003-09-02 Thread Prem Khanna J
Arup Bhai, many many thanx for your explanation. Regards, Prem Khanna J. 02-09-2003 12:19:25, Arup Nanda [EMAIL PROTECTED] wrote: Prem, The SPFILE should never be opened to be modified; opening a file to see the contents are acceptable and that's what I said. Sometimes opening the file

Re: alter system reset

2003-09-02 Thread Prem Khanna J
is running, it could fail. As you said,opening spfile is not a problem...but editing IS. Thanx to you both. Regards, Prem Khanna J. 02-09-2003 12:44:26, Mladen Gogala [EMAIL PROTECTED] wrote: Prem, if you want to read the spfile, you can always do something like strings $ORACLE_HOME/dbs/spfile.ora

Re: alter system reset

2003-09-02 Thread Prem Khanna J
.wanted to know how you gurus handle SPFILE. Thanx Mladen. Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: book

2003-09-01 Thread Prem Khanna J
Hi, Oracle8i Internal Services for Waits, Latches, Locks, and Memory by Steve Adams O'Reilly Associates, Paperback, Published October 1999, ISBN 156592598X This is a good one i know. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J

Re: Fw: book

2003-09-01 Thread Prem Khanna J
Hope Steve Adams will give an answer for your question. Jp. 01-09-2003 18:44:26, [EMAIL PROTECTED] wrote: Sorry to repost but forgot to mention, that I needed a book for Oracle 9i -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL

Re: Congratulations Arup (DBA of the Year)

2003-08-29 Thread Prem Khanna J
Let me also join the list in congratulating one of the Oracle Gurus whom i admire. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: OT - Linux books ??

2003-08-27 Thread Prem Khanna J
Thanks Guys. I will go for Linux Administration Handbook. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Query results to .csv

2003-08-26 Thread Prem Khanna J
Imran, Try this script. i have used it often. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Query results to .csv

2003-08-26 Thread Prem Khanna J
Oops...it's Jared's script. i was not knowing till now. Jp. 26-08-2003 11:14:26, Prem Khanna J [EMAIL PROTECTED] wrote: Imran, Try this script. i have used it often. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat

OT - Linux books ??

2003-08-26 Thread Prem Khanna J
- By Evi Nemeth, Garth Snyder, Trent Hein ...any better suggestion Gurus ?? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: Urgent! Is it safe to apply patch Windows2000-KB823980?

2003-08-19 Thread Prem Khanna J
-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: RE: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
the cache, over and over. There papers at hotsos.com that will explain this in detail. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
. Client's vary their attitude varies. Do u agree with me ?! Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
and Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
your developers to review the English irregular verbs, especially 'to send'.Forget about the magical INIT parameter. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network

Re: RE: quick suggestions for tuning ?

2003-08-12 Thread Prem Khanna J
: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

Re: quick suggestions for tuning ?

2003-08-11 Thread Prem Khanna J
- might be able to use that better elsewhere. cheers connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Oracle and Windows 2000 SP4 - any experiences to share

2003-08-08 Thread Prem Khanna J
after installing SP4,even MS-Office troubled me a lot. .came back to SP3 again. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

  1   2   >