Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Swany

  1. Swany

    Linking Libraries Oracle 9i HP UX 11

    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 . ... ....................... .
  2. Swany

    googl.com style keyword search

    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...
  3. Swany

    Application Server vs Enterprise Edition

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

    SUBSTR Question

    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')...
  5. Swany

    Oci Help on compiling files.

    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 . ... ....................... .
  6. Swany

    Moving Oracle Binaries

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

    Standalone TNSPING without Oracle components

    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...
  8. Swany

    Checking that DB up from remote Unix box

    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...
  9. Swany

    When trying to start a 9i database,

    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 . ... ....................... .
  10. Swany

    When trying to start a 9i database,

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

    SQL*Plus Worksheet & DOS Shell Window

    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...
  12. Swany

    DB lost connection ?

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

    When trying to start a 9i database,

    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 . ...
  14. Swany

    SQL*Plus Worksheet & DOS Shell Window

    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...
  15. Swany

    Replicating Oracle with SQL

    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...
See more

Part and Inventory Search

Back
Top