fied domain accounts.
>
>I can't recall if the default value is true or false, but
>try setting it explicitly.
>
>Jared
>
>On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote:
> > Hi All,
> >
> > The client machine is an NT machine and it belongs
r false, but
>try setting it explicitly.
>
>Jared
>
>On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote:
> > Hi All,
> >
> > The client machine is an NT machine and it belongs to a domain "GALAXY"
> > Oracle Db server is on Solaris.
> >
> >
Hi All,
The client machine is an NT machine and it belongs to a domain "GALAXY"
Oracle Db server is on Solaris.
client sqlnet.ora has the following setting:
NAMES.DIRECTORY_PATH= (TNSNAMES)
LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log
USE_DEDICATED_SERVER=ON
SQLNET_AUTHENTICATION_SER
Hi All,
I need some basic understanding of heap structure and its operation.
Can anybody give me some useful links in this respect?
Thank You
Regards,
B S Pradhan
sorry, the second query uses equality operator..
WHERE UPPER(col1) = 'xyz';
index hint is not helping.
regards,
B S Pradhan
--
On Thu, 08 Jan 2004 zions swordfish wrote :
>hi, pradhan,
>I don't see any kind of differences with your two queries, but
>I suggest you to use h
Hi All,
I have the query like:
SELECT *
FROM tab1
WHERE UPPER(col1) <> 'abc';
Obviously, the function based index i have is not hetting used because of the
ineqality.
When using
SELECT *
FROM tab1
WHERE UPPER(col1) <> 'abc';
index is getting used.
How can I possibly use index in the 1st ca
Hi All
Happy New Year
In my plsql program i am connecting to two remote DBs and using db_links
sequentially.
Sometimes if the first remote db is not available or there is some network problem
then it stays there for quite some time and then throws an error (which is captured in
exception sect
d not work.
> >> Good luck.
> >>
> >>"Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> >>
> >>You answered your own question.
> >>
> >>ta.c3 is a nonindexed column, this means that the only way to
> >>sat
You answered your own question.
>>
>> ta.c3 is a nonindexed column, this means that the only way to
>> satisfy the
>> predicate is to perform a full table scan. Since this predicate
>> condition forces
>> a full table scan on ta, which will retri
Hi,
Nice example and it should behave similarly in my case also. I have to research more..
Regards,
B S Pradhan
---
On Wed, 24 Dec 2003 zhu chao wrote :
>Hi,
> It cound be possible that without Hint, oracle will choose FTS for second SQL,
> because with col3 clause, if usi
Hi All,
Merry Christmas to all.
I have this interesting problem..
For this query index ind1 on (c1,c2) columns is getting used.
SELECT 'x'
FROM tab ta
WHERE ta.c1='val1';
(gives index ind1 range scan)
But for
SELECT 'x'
FROM tab ta
WHERE ta.c1='val1'
AND ta.c3 = 'val2';
(gives FTS)
index in
Hi All
What is the location for InstallActions.log ?
Thanks and Regards
B S Pradhan
Yes
Thanks a lot
regards
b s pradhan
On Sat, 13 Dec 2003 David Hau wrote :
>The method you need is: OracleDatabaseMetaData.getDriverVersion()
>
>Write a small Java program to call this method, or take a look at Metalink note
>94091.1 or 73629.1 for sample code to get JDBC driver version.
Hi All
How can I findout what is the version of the jdbc driver installed with oracle client
install.
Thanks and Regards
B S Pradhan
Yes. It worked..
Thanks a lot
regards
b s pradhan
---
On Wed, 03 Dec 2003 Tanel Poder wrote :
>Try archive log stop; and archive log start; after setting the parameters..
>
>Tanel.
>
> > Hi All,
> >
> > When I set log_archive_dest_2 to a valid local destination
> > Dyn
Hi All,
When I set log_archive_dest_2 to a valid local destination Dynamically on 8.1.7.0 it
is not generating the archive files..
It is generating the archive files on on log_archive_dest_1
I even tried with the following settings ..
1] both log_archive_dest_1 and log_archive_dest_2 made MANDA
Hi All
I have a few basic questions:
1] How Oracle knows that media recovery is needed
during STARTUP ? Is it based on mismatch of SCN or
ckpt# or anything else ? I understand, if the datafile
is missing then in Mount stage it throws error. Is
there any other situation where it throws media
reco
Thanks for the information. The thumb rule and all will definitely help me in
modelling.
Thanks a Lot
Best Regards
B S Pradhan
On Wed, 22 Oct 2003 Michael Milligan wrote :
>Hi Again,
>
>What I do when a model is going to change is try to make it
Thank you all for all the help/suggestion/links and information about data modelling.
Regards
B S Pradhan
---
On Tue, 21 Oct 2003 [EMAIL PROTECTED] wrote :
>ive been told 'data modelling for mere mortals' is a good place to start.
> >
> > From: &q
Hey Michael
I enjoyed your write-up.. especially a few db guys telling 'its relational because
they are related'... I have also heard about it and the fact is that SQL the language
for all the RDBMA is based on relational algebra and relational calcus and there in
maths a rwo-column structure
Hi All
I have not done data modelling as a major task so far. Would like to know from where
can I make a good start. I have basic(conceptual) knowledge of ER-Diagram and
Normalization. But if anybody can give me some case studies/links etc.,
I see the responsibilities would include modelling a
when the table is
1] frequently accessed
2] relatively small
Regards
B S Pradhan
On Tue, 21 Oct 2003 Gunnar Berglund wrote :
>Hi all,
>
>when you would consider to put a table a cache...
>
>rgds
>
>gb
>
>
>Want to chat in
Try this:
A shell script calling sql env to ANALYZE certain table. kill the process running the
shell script before it is done. You might get ora-00600 with argumrnt[1113]
Thanks
Pradhan
On Wed, 08 Oct 2003 Sinardy Xing wrote :
>ora-600 may result your db do
Hi
consistent gets are when the SQL needs the data in consistent mode i.e not the current
data. SELECT statements contribute to consistent gets (read from the RBS). DML
normally contribute to db block gets, but say an UPDATE based on a search criterion --
will contribute to consistent gets.
T
LE-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).
_______
Art meets Anesthesia; Shefali Weds Dr. Raman.
Rediff Matchmaker strikes a
g).
___
Art meets Anesthesia; Shefali Weds Dr. Raman.
Rediff Matchmaker strikes another interesting match !!
Visit http://matchmaker.rediff.com?1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [E
he OS
>level. The
>investigation should continue on the server.
>
>--
>Mladen Gogala
>Oracle DBA
>
>
>
> > -----Original Message-
> > From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 12, 2003 5:46 PM
> > To: Mladen G
process was killed, I was able to start the listener.
>FYI, the
>process was picld, an O/S process that is known to have a memory
>leak.
>
>Hope that helps...
>
>Alan
>
>
>Alan Aschenbrenner
>Oracle DBA
>IHS Group
>[EMAIL PROTECTED]
>
>
>
>
>
p://www.orafaq.net
--
Author: bhabani s pradhan
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
process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space
Regards
--
On Sat, 13 Sep 2003 bhabani s pradhan
> -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>On
> > Behalf Of bhabani s pradhan
> > Sent: Friday, September 12, 2003 5:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Bus Error (Urgent)
> >
> >
&
___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City
f 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
pped
>across multiple platters. You may want to look into the stripe
>size
>depending on the number of users who will be concurrently
>accessing the
>database. Basic rule-of-thumb, the more concurrent users the
>larger the
>stripe size.
>
>
>
>
>
;Download the hottest & happening ringtones here!
>OR SMS: Top tone to 7333
>Click here now:
>http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: bhabani s pradhan
> INET: [EMAIL
your valuable input.
> >
> > Regards
> >
> >
> > ___
> > Download the hottest & happening ringtones here!
> > OR SMS: Top tone to 7333
> > Click here now:
> > http://sms.rediff.com/cgi-bin/ringtone/ri
he only option.
> >
> > Thanks for your valuable input.
> >
> > Regards
> >
> >
> > ___
> > Download the hottest & happening ringtones here!
> > OR SMS: Top tone to 7333
> > Click here now:
&
here!
OR SMS: Top tone to 7333
Click here now:
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San D
http://www.orafaq.net
--
Author: bhabani s pradhan
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
& happening ringtones here!
OR SMS: Top tone to 7333
Click here now:
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To R
41 matches
Mail list logo
