I am using Oracle 9i
I need to extract records from a table where certain criteria is met
and then compare 4 fields from those records to 4 fields in another
table.  Where the records don't match I need them extracted into

I need to access MS SQL Server tables (SQL Server 2000 on Windows 2000)
from applications running on Oracle 9i on a Solaris 8 (Sparc) server. I
think I am in the same situation as the person in
<e70fc892.0209031332.6045a661@posting.google.com> (which is from 2002).

Is there a way to find out whether a Table was modified in certain
period(E.g.Between 16-Apr-2005,10 am and 17-Apr-2005,9 am)? We could
see that there are records added/modified in a Table. But, we would
like to confirm whether there was any change in the Table in a certain

I read the book and manual on oracle's jdbc driver, and it SEEMS to suggest
that oracle's driver has some extra limitations.  However, the description
is not clear enough so I just want to double check here.
I am using Oracle 9i R2.

I am a freelance writer for a computer magazine, and my current
assignment is to interview "network professionals" who write
interesting blogs. (I'm perfectly willing to reveal the name of the
magazine once I've made contact with a good subject. I'm sure all

We are trying to migrate or DB from RH 2.1 to SUSE 9,
need to do it with no downtime (we have a standby).
Can we re-create standby on SUSE platform and switch to it
(e.g. will the redo logs generated by RedHat ASE 2.1

I have what should be a fairly simple date problem, but I am just not having
any luck getting it to work...
I have a table with a column of DATE type. This column is called CLSDDATE, and
all values in there are GMT based.

Let's say I have the fallowing table:
tbl 1
col1 col2 col3 val
1    2    s    45

how do i define an escape character in awk. i am using awk at the unix
command line.
cat a.list |awk 'BEGIN {} {a=a"'"$1"',"} END{print a }'
                              ^

Basic architectural question here:
I have a normal index against 4 columns of a 18.8M row table. The types
of the 4 indexed columns are 3x NUMBER(10) and a DATE.
By my math, with a DATE being max 7 bytes, this adds up to 37 bytes of

I want to set a condition in the where clause of the select statement
which eliminates any table (or index) access or atleast minimizes the
time needed to execute statement.
To be more specific:

I have 2 Sparc e250 boxes running Oracle 8.1.7.4. Both Oracle
installations are identical and each box has 1GB RAM and an identical
setup.
One box is running Solaris 7 and the other Solaris 9. When running

I have a query returning the following error message:
ORA-04031: unable to allocate 8388608 bytes of shared memory ("shared
pool","unknown object","hash-join subh","QERHJ Hash Table Entries")
What I really would like to know, is if an attempt to allocate "8388608

This is a phenomenal bug in Oracle 9i:
SQL> select version  from v$instance;
VERSION
-----------------

Hi
We use Oracle 8.1.7.4 on Solaris 8 Sparc
When the database is under heavy load i.e. 10s of thousands of record
are being inserted I get a lot of 'undo header contention'.