RE: bind variables in VB using OO4O

2004-01-21 Thread Prem Khanna J
Hi John , i have mailed a doc . have a look at it . Regards, Prem. >>-Original Message- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>Does anyone have examples of how to use bind variables in VB >>when using >>OO4O? >> >>John --

RE: Thanx - I cleared the exam

2004-01-19 Thread Prem Khanna J
>>When I was doing my OCP exams, I didn't have Dennis to cheer >>me up, only Heineken.Not that I'm complaining. but Mladen , i can't stop with just one : )) so i better stay away from it during exams. Regards, Prem. -- Please see the official ORACLE-L

RE: Thanx - I cleared the exam

2004-01-19 Thread Prem Khanna J
Hi Dennis , thanx a lot for your encouraging words. my morale being high , let me go ahead with the next exam . Thanks and Regards, Prem. >>-Original Message- >>From: [EMAIL PROTECTED] >> >>Prem - We had no doubt. I always figure when you've studied >&

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

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

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

2004-01-07 Thread Prem Khanna J
er than someone Ryan> else if you have 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 Net

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

2004-01-07 Thread Prem Khanna J
expect. 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-- Mailing

Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Prem Khanna J
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 and web hosting

another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
number of blocks allocated to the table. what will be the choice that you would go for ? - so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( Regards, Prem.

OCP question from Boson practice tests

2004-01-07 Thread Prem Khanna J
t take 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

RE: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Prem Khanna J
Hi Mudhalvan , set feed off ; did u try this ? not sure though : ) Regards, Prem. >>-Original Message- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>Behalf Of Mudhalvan, Moovarkku >> >>Hi, >> I am trying to spool the result

RE: standby database configuration in 9iR2 SE ?

2003-12-16 Thread Prem Khanna J
ing 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:

standby database configuration in 9iR2 SE ?

2003-12-16 Thread Prem Khanna J
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

utl_smtp and japanese characters ?

2003-12-10 Thread Prem Khanna J
(Bwhat's wrong with my code ? Can someone help 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-

RE: dba studio in oracle9.2

2003-12-05 Thread Prem Khanna J
on windows. > > I have perform full installation. > > 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-

RE: Analytic bug in 9.2.0.4

2003-12-04 Thread Prem Khanna J
s 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 D

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

2003-12-02 Thread Prem Khanna J
y improved performance just because the server is changed from dedicatd to MTS mode. but my question is : will it bring down the performance rather ? the set up is oracle 9.2.0.3 / win2k. Thanx once again. Prem. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

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

2003-12-02 Thread Prem Khanna J
"orcl" configured in it's confifguration >(listener.ora) or has anyone registered this kind of service with it. If it >finds the service, it also knows on which ports are the dispatchers or with >which SID should it spawn a new server process. -- Ple

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

2003-12-02 Thread Prem Khanna J
can check views v$mts, v$dispatcher, v$shared_server for >statistics. -- 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.c

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

2003-12-02 Thread Prem Khanna J
for >statistics. -- 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: Finding SID of current session

2003-12-02 Thread Prem Khanna J
ut only want to do it for it's own session so I 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, Califor

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

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
YWMpd0CBEBACH5 BAVkAAgALAAUAA8AAAQSEMlJq7046827/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

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
Perhaps your guess is right Dennis. For odd features like this marketing probably gets a list from support. But Dennis,what is so "odd" in having this feature ? i think,only ORACLE CORP. knows. Thanx & Regards, Jp. 1-11-2003 02:49:30, DENNIS WILLIAMS <[EMAIL PROTECTED]>

Re: RE: How to drop a datafile ?

2003-10-30 Thread Prem Khanna J
file resides. Until you do so, the datafile remains 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 Kha

Re: How to drop a datafile ?

2003-10-29 Thread Prem Khanna J
E-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 yourself from

Re: RE: How to drop a datafile ?

2003-10-29 Thread Prem Khanna J
e is the problem > >Regards -- 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-- Mail

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 Ne

RE: How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
printable Mudhalvan , the "delete datafile" icon in that screen=0D of OEM is not enabled . even if i take the datafile offline,=0D it is not enabled.=0D =0D even in ur screen it looks so ? isn't it ?=0D =0D Jp.=0D ---Original Message---=0D =0D Prem =0D =0D Please ch

RE: How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
quoted-printable Hi Mudhalvan,=0D =0D i don't find any option to drop a datafile using OEM.=0D i would be more intereseted in doing it from sqlplus.=0D =0D Jp.=0D =0D ---Original Message---=0D =0D Prem..=0D =0D Why don't you install Enterprise manager in any one of your=0D client ..

How to drop a datafile ?

2003-10-28 Thread Prem Khanna J
e 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 ser

Re: Passed Net8 OCP Exam

2003-10-16 Thread Prem Khanna J
jKXdAgRAQAh+QQFCgAIACwAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= ------Boundary-00=_4CPVRN00-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Auth

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

2003-10-09 Thread Prem Khanna J
.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 this m

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

2003-10-03 Thread Prem Khanna J
has >theirs by now and >are busily 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

Re: Experiences setting OPEN_CURSORS for Java applications

2003-10-03 Thread Prem Khanna J
he so I am not sure whether it will work or not. I 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 h

Re: exam

2003-10-01 Thread Prem Khanna J
passed my oracle 9i performance tuning 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, Californi

[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: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Prem Khanna J
apache/tomcat/jboss ... 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 Net

Re:Suggestion reg. encryption ??

2003-09-30 Thread Prem Khanna J
With pleasure Ranganath. ..and ur example,sure ,was useful. Kind Regards, Jp. 30-09-2003 17:47:38, "Ranganath K" <[EMAIL PROTECTED]> wrote: >Hi Prem, > > I am also unable to reach it. The sight might be down. However >I hope you would have found the example

Re: RE: Using dimensions

2003-09-30 Thread Prem Khanna J
gt; >> -Original Message- >> From: Prem Khanna J [mailto:[EMAIL PROTECTED] >> Raj, >> >> what does TFM & STFW mean ?!! >> let me also get used to the list's acronyms :) >> >> Jp. -- Please see the official ORACLE-L FAQ: http://www.o

Re: Using dimensions

2003-09-30 Thread Prem Khanna J
ual_ uses > of dimensions ... where does 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]

Re: Suggestion reg. encryption ??

2003-09-29 Thread Prem Khanna J
ity.com/. can u ? 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 S

Suggestion reg. encryption ??

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

Re: RE: "SQL AREA" and "LIBARARY CACHE" size?

2003-09-26 Thread Prem Khanna J
any x$ views, but stich with plain >old 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]

Re: RE: "SQL AREA" and "LIBARARY CACHE" size?

2003-09-26 Thread Prem Khanna J
t chunk. Jp. 26-09-2003 19:19:25, "ManojKr Jha" <[EMAIL PROTECTED]> wrote: >Hi Prem, >I Think you are also doing the same mistake that I have done yesterday, >that was causing so much confusion. >I had earlier calculated the library cache and sql area size from X$ksmsp.

Re: RE: "SQL AREA" and "LIBARARY CACHE" size?

2003-09-26 Thread Prem Khanna J
ain me 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: "SQL AREA" and "LIBARARY CACHE" size?

2003-09-25 Thread Prem Khanna J
Hi Manoj, In my system size of library cache is approx 48 mb and sql area 417 mb 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-- 858

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

2003-09-23 Thread Prem Khanna J
has been shipped >by B & N. It will probably be a big surprise, but my 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://

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 B&N ... ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Autho

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

2003-09-22 Thread Prem Khanna J
>Woo Hoo looks 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 h

Re: RE: download metalink articles - save target as

2003-09-22 Thread Prem Khanna J
des a blank file. 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 Servi

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

2003-09-22 Thread Prem Khanna J
r >there, and it is still listed 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

Re: ORA-03237 with LOB and locally managed tablespace

2003-09-22 Thread Prem Khanna J
xtend size 3 times the >db_block_size, right? >Otherwise 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

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

2003-09-22 Thread Prem Khanna J
Thanx for the info' Ranganath. it's too late now.i have placed my order. that's okay.i will finish it b4 i come there. it will help me a lot ;) Regards, Jp. 22-09-2003 19:59:24, "Ranganath K" <[EMAIL PROTECTED]> wrote: >Hi Prem, > The book should be o

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

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 Ne

Re: Bug in 9.2.0.4

2003-09-22 Thread Prem Khanna J
appen on my instance. Any Details will be appreciated. -- 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, Calif

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

2003-09-22 Thread Prem Khanna J
therefore, doesn't really >matter. -- 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.oraf

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

2003-09-21 Thread Prem Khanna J
Attachments are stripped from 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 N

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

2003-09-21 Thread Prem Khanna J
ks in advance. >Rajuvera -- 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 li

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

Bug in 9.2.0.4 when order by constant desc

2003-09-21 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

Re: RE: RMAN error - can someone help ?

2003-09-17 Thread Prem Khanna J
th look strange and wonder oracle appends that ?? any clues Ruth.just 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: Tuesda

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

2003-09-16 Thread Prem Khanna J
pretty much ready for exam. > > I did my OCP from 7. to 9i without attending and formal course and passed in > first attempt > > Regards > Rafiq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J

RMAN error - can someone help ?

2003-09-16 Thread Prem Khanna J
my recovery action. Question #3: though it is not restore path,why does RMAN's 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 o

RMAN-03015 error during TSPITR

2003-09-16 Thread Prem Khanna J
ere in my recovery action. Question #3: though it is not restore path,why does RMAN's 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

Re: RE: Metalink doc 52576.1 ?

2003-09-12 Thread Prem Khanna J
wardt <[EMAIL 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

Re: Good & small reference !

2003-09-12 Thread Prem Khanna J
e very much useful & >required 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-5

Can i have a copy of metalink doc 52576.1 ?

2003-09-11 Thread Prem Khanna J
Hi List, Sorry to post this again.Hope i will get some replies this time. 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:

Re: quick rman question

2003-09-11 Thread Prem Khanna J
ce ... delete delete >the info 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

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-

OT - how/where to buy oracle test voucher ?

2003-09-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 hostin

Re: Database Link

2003-09-10 Thread Prem Khanna J
searching my disk for *oerr* and no exe or com 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 Di

Re:RMAN backup and recovery scenarios

2003-09-04 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: RE: RMAN backup and recovery scenarios

2003-09-04 Thread Prem Khanna J
e book. 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

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

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

Re: alter system reset

2003-09-02 Thread Prem Khanna J
ce 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 >st

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

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:

Re: alter system reset

2003-09-01 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: 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 Khan

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

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

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,

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

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 Khann

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: RE: Urgent! Is it safe to apply patch Windows2000-KB823980?

2003-08-19 Thread Prem Khanna J
te -- 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
t;long IN list), the 'FIRST_ROWS' hint may help. You can also tell 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 o

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
ion is a huge barrier and convincing them is a HERCULEAN task :(( Let me do that first and get back to u. Thanks 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--

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
nese. 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

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

Re: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
orly written SQL > that reads the same data from 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 Se

Re: RE: quick suggestions for tuning ?

2003-08-14 Thread Prem Khanna J
ance.Need to test it. Thanks 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

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

  1   2   3   >