Re: tnsnames.ora not working ?

On Tuesday 20 January 2004 11:20 am, Scott Canaan wrote: > Are you using Oracle Services? I've seen this happen before and we > change SERVICE_NAME to SID and everything works fine. That does not work for me either. RDB > -Original Message----- > Reuben D. Budiardj

Re: tnsnames.ora not working ?

username, rather than using the long description. Thanks for any help. RDB > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 20, 2004 10:49 AM > To: Multiple

tnsnames.ora not working ?

Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - "To be a nemesis, you have to actively try to destroy something, don't you?

HELP: HD crashed, oracle get Error ORA-00205

d up becoming a semi production server. And no, we don't have a DBA either, and I'm newbie on that area (I'm supposed to be a web developer). In a way I a sorta hope this incident becomes a lesson for the boss. Thanks a lot for any help. RDB -- Reuben D. Budiardja Departme

Error Log

have to output / catch and send error and SQL statement on the application level. System: ORACLE 9i on Redhat Linux 7.3 Thanks. RDB -- Reuben D. Budiardja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Ne

DB gets really slow

stomizing/learning/optimizing the development database because we needed to start development ASAP, but it's probably time to start learning. Thanks for any help. Reuben D.Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN --

Re: How to tell Oracle the directories of script files

Thanks all. The replies have been really helpful. Reuben D. Budiardja. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

How to tell Oracle the directories of script files

ere to find executables, is there a similar thing for Oracle? Thanks for any help. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /"\ ASCII Ribbon Campaign against HTML \ /

DBA/Programmer GUI tool for Oracle in Linux

that runs in linux would be sufficient. I've tried TOra, it can do more stuff than I can understand right now, but it lacks basic things like dropping and creating table, altering table, etc. Any info will be greatly appreciated. Thanks in Advance Reuben D. Budiardja -- Please see the

Re: Empty String is interpreted as NULL

> > If I do this insert: > > SQL> / > INSERT INTO FRUIT VALUES ('hello', '') > * > ERROR at line 1: > ORA-01400: cannot insert NULL into ("LIGHTCONE"."FRUIT"."APPLE") > > I got an error cannot insert NULL. But, what i

Empty String is interpreted as NULL

; ? Certainly empty string is NOT equal to NULL values. So how do I get around this? Thanks in advance for any help. Reuben D. Budiardja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Servic