Recent content by Swany

Read the OCI (oracle call interface) developer reference. http://tahiti.oracle.com You will need a free OTN login to access the documentation. . .. Eat, think and be merry . ... ....................... .

What version of the database are you using? Oracle 7/8 has a Context Cartridge Oracle 8i has Intermedia text and 9i has Oracle Text... If you are using 9i you have a couple options. There are three main index types. Context, ctxcat and ctxrule. Context indexes are the most flexible, but...

What are you trying to use the ALTER command to do? Convert LONG columns to CLOB? . .. Eat, think and be merry . ... ....................... .

Please also note that "like '%CONST'" will not use any index on the column. Assuming the date column is a DATE datatype, then you might want to do: [code] SELECT to_char(DATE, 'MON-YY') FROM X WHERE DATE between '01-JAN-2003' and '31-JAN-2003' GROUP BY to_char(DATE, 'MON-YY')...

You probably need to modify your include and library paths to include the current directory. Your library path probably needs to include $ORACLE_HOME/lib . .. Eat, think and be merry . ... ....................... .

Modify the location of the oracle home in /var/opt/oratab I assume you are using /usr/local/bin/oraenv to set up the environment for users of the database, including your oracle user. If you aren't using oraenv, then you will need to modify the login scripts and change the $ORACLE_HOME...

Please note I replied to your other thread as well.. The oracle box could just send a mail to the mail server every x minutes to a "watchdog" account. Have cron check the mtime on the watchdog mailbox and if it isn't modified every x+1 minutes then page. That makes sure sendmail is...

The easiest wasy would be to ssh or rsh to execute the TNSping on a remote machine that has the client and return the result. Another way would be to set up a web server that has the libraries and can contact oracle (the Apache that comes with oracle comes to mind) and use it to test the...

Also verify that the memory parameters in /etc/system haven't been changed. The memory parameters might be somewhere else depending on what OS you are running. . .. Eat, think and be merry . ... ....................... .

is your database listed in /var/opt/oracle/oratab ? . .. Eat, think and be merry . ... ....................... .

SQL*Plus doesn't display the DOS box, only SQL Worksheet. I never use SQL worksheet personally. I just stick to either sqlplus (dos version) or sqlplusw (windows version) of regular SQL*Plus I rarely use SQL*Plus for anything but reporting, or when sitting on a unix shell. For regular SQL...

Do you have a DBA that is killing off long running (apparently) idle sessions? . .. Eat, think and be merry . ... ....................... .

Did you change your init.ora? That will happen if you set LOCK_SGA but your system isn't set up to support it. You can only lock shared memory areas as root, so oracle has to run as the root user, which is a bad thing. . .. Eat, think and be merry . ...

SQL*Plus worksheet works by "hooking" to the SQL*plus dos executable to perform its work. As far as I know, there isn't any way to avoid that, so you are pretty much stuck with the dos box. If it really annoys you, you can get a program from somewhere like Download.com to hide...

Why not just connect to the oracle database from the web server using ADODB (I assume you are using IIS and ASP) and run queries against it? You will need to install the oracle client on the web server and set up your tnsnames file, then you should be able to use ASP to connect to your oracle...