I'm having a problem with an Oracle Web Application written using the
PL/SQL cartridge (mod_pl) and Oracle 9i as a backend. As part of the
application, we are uploading files into the database. For handling
upload and download of files, we are using the Oracle package:

Can you pls tell me how to select where a TIMESTAMP date is N hours
ago?
select * from <table> where job_date ... ?
thanks

I use a Oracle 9.2.0.1.0 server
I have a view which is a join of few table :
CREATE VIEW SE_SEARCH AS
SELECT ... FROM ITEMS

Has someone managed to install and run Oracle 9i and 10g on the same
Linux host (RHEL4 x86_64)?
I intend to install them into
 /opt/oracle/9.2.0.4

What do you think can be the consequences of spending your
time adding fields to existing tables ?
We have several apps here where developers regularly send
requests to modify tables structures, kind of:

I'm trying using TOAD to import a DB, I select
Import Utility Wizard
Import DataBase
Orginal schema and Do not permorm incremental

RDBMS version: Oracle 8i Enterprise 8.1.5.0.0 (Yes, I know it's old and
unsupported.)
Platform: Solaris 2.6
HW: Sun Enterprise 450, 1 processor, 1 gig memory.

anyone faced or cleared out this
...SEVERE: Abnormal program termination. An internal error has occured.
Please provide the following files to Oracle Support
Exception java.lang.NullPointerException occurred..

I'm having a problem with an Oracle Web Application written using the
PL/SQL cartridge (mod_pl) and Oracle 9i as a backend. As part of the
application, we are uploading files into the database. For handling
upload and download of files, we are using the Oracle package:

Hello out there,
I am using Oracle 10.0 OCI calling interface. When running the example
of the bulk loading, I come across an Oracle error
ORA-28547.

I have just migrated from Oracle 8i to Oracle 10g on a Windows 2003
server. The server is of higher processing power. Several SQL Queries,
some complex ones are very slow.
Some SQL Queries run faster and some queries run slower.

I have just migrated from Oracle 8i to Oracle 10g on a Windows 2003
server. The server is of higher processing power. Several SQL Queries,
some complex ones are very slow.
Some SQL Queries run faster and some queries run slower.

i still have a problem with building standby database with standard edition
oracle,
I am DBA beginner, i think very beginer...
could anyone help me?

Hi NG,
Oracle decided to desupport Oracle Names in 10g. Willing or not, we're
required to move to LDAP.
We're running here 100s of oracle instances named by the following

Hey all,
  For some reason the create database option is grayed out in dbca.. I
thought it may be an oraInventory problem but that seems ok.  There is
one other database in this oracle home and dbca can see it.