I have the next select:
SELECT
    cu.IMP_FRA_MES
    cump.COD_CUENTA_CABLE,

I'm trying to use the TABLE operator in a pl/sql block with a
pl/sql nested table of objects.
I've succeeded using CASTING, TABLE and MULTISET with a table of
dates.

"multiple listeners on multiple nodes can be configured to handle
client connection requests for the same database service. In the
following example, sales.us.acme.com can connect to sales.us.acme.com
using listeners on either sales1-server or

We're running on 8i (Solaris64) (I know, I know, upgrade :-P) with
dedicated server.
Question is: Running against an application server which uses its own
connection pooling, can we benefit from prespawning servers on Oracle,

Hello again;
thank to all the great advice I got in my initial
request to the group, I am now better informed.
It appears that I am suffering from

Our Unix admin must upgrade our Oracle 9 RAC cluster (AIX 5.1 , HACMP
4.5) to AIX 5.2 and HACMP 5.1.
They tell us that the only way to do this is to switch off one system,
upgrade it, upgrade the other and then recombine them to a cluster.

When I try to extract the pubs database from Sql Server into omwb's
repository I face an strange error (I  think internal error):
"Failed to load source model.ORA-01400:can not insert NULL into
SS2K_SYSREFERENCES.FORKEYS"

I have applicalion, that use OCI v7.
It work very good with Oracle 8.1.7.4.
I install Oracle 10g and rebuild (re-link) my application with
new oracle librarys.

Anyone knows of a shell script to call statspack's spreport which can
keep track of the spapshots done?

I am using a C++ application that connects to Oracle Database using
EasySoft ODBC driver.
I face a strange problem when freeing the memory after i fetch the CLOB
data from the Oracle table.

I'm out of my league here, perhaps someone can give me a boost.
We're seeing (to us) mysterious intermittant slow downs (query which
normally takes say a few seconds , no change of data, run during
"slowdown" time takes a minute and a half.

I just installed Oracle 8i and am having a tough time just logging into
SQL*Plus. I've given scott for the User Name and tiger for the
Password. But heck, what do I give in as the host string?

I just installed Oracle 8i and am having a tough time just logging into
SQL*Plus. I've given scott for the User Name and tiger for the
Password. But heck, what do I give in as the host string?

  Is there a quick way to create an empty table having the same
structure as an existing partitioned table (minus the data):
i.e sort of do this
CREATE TABLE BCK_A_PART AS SELECT * FROM A_PART

Hello evry body
I have a very strange problem, the following query
raise an exception when executed from Java (JDBC) but is successfully
executed within TOAD.