Platform: Oracle 10.2.0.2.0 on HP-UX B.11.11
This began just recently.  While logged on to the sever with the
'oracle' account, I noticed my command line history returning a bunch
of stuff I hadn't entered.  This is a very small shop, so I have a

  I had the error message"ORA-03001: unimplemented feature" when
running the following query in Oracle 10g:
  SELECT /*+ USE_HASH(m,t) */
    m.household_id

I apologize for cross-posting, but I need some help w/o too many
advices RTFM :). After Oracle and MySQL, this becomes the third
product that I need to learn to some degree, and I need a few links
which would provide a 'quick tutorial' especially for folks with

I programed  with OCI base C Language.
OCIServerAttach( srvhp,errhp,(OraText *) "192.10.10.1:1521:ora9i",
                         (sb4) strlen((char *)cstring), OCI_DEFAULT))
But, I can't connect oracle server.

I work for an ISV that acquired several applications last year from
another firm (call it "foobar") which wanted to concentrate on its "core
competencies". One of those applications is designed to work with either
Oracle or MS SQL Server.

10g:
Say I have EMPLOYEES table with column Skills as varchar2
I need to convert Skills to NCLOB, this is the "right way" to do it ?
alter table EMPLOYEES add skills_clob nclob ;

I'm getting this error doing an SQL insert:
java.sql.SQLException: ORA-01745: invalid host/bind variable name
I know there's no invalid names in the insert because I can insert
data into the table by hand over sqlplus.

Hi. I have the following query:
SELECT /*+ INDEX (w myindex) */
    COUNT(*)
FROM

An experienced Microsoft Dynamics NAV Consultant is required in our
implementation team to assist with the successful implementation and
maintenance of our client's Microsoft Dynamics NAV based ERP systems.
This is a varied and demanding role involving all aspects off

We are attempting to improve performance of a Windows app that
performs a fair amount of networking, loading up grids and tables,
opening data sources, etc. The database resides in Calgary, Canada,
while the app is based in Toronto, 2000 miles away. The responsiveness

we have a database that stores addresses.  the address number is stored in
a field called MY_NUMBER.  Now if the address has two numbers i.e. 12-345,
then the 12 will be in a field called MY_PREFIX.  I need to come up with 1
SQL statement (and it can't be PL/SQL) that will check ...

  I'm trying to identify the bottleneck of our Orcle8.1.7 server
running on HP-UX 11i.
  The  server has 20CPU and 16GB DRAM, HP XP1024 disk array is
attached as storage.

I'm an Oracle8 certified DBA looking to upgrade to 10g.  I have to
take the 8 to 8i upgrade exam first, but the class is no longer
available.  If anyone has the Oracle Education and/or Self Test
Software for exam 1Z0-020: Oracle8i: New Features for Administrators,

I have a visual basic application that uses a sql query that uses bind
variables to extract a result.  I have noticed that i can't use bind
variables in a from clause.  Is there anyway to pull the max of one
column and then another column in the table that corrsponds to that

Does anyone know how I can change an RMAN tag?
list backup summary;
13477   B  F  A DISK        30-JUL-07       1       1       NO
TAG20070730T122457