A quick question from a danish oracle newbie.
I have 2 tables, and i want to update a field in table t1 with the sum
of a field in table t2.
The tables are BIG, so therefore i want the statement to be a

Any idea when Release 2 of Oracle 10g will be available ?
And is it already known which new features will be included ?
Matthias

I'm looking at a 9i database's Top sql with both TOAD and OEM Grid
Control. The grid control shows a different execution plan for the same
sql than TOAD does? What would cause this? Stats are the same for both
and have not changed since the the SQL was first loaded into the shared

I have got RAID10 disks and my system is IO bound.  I thought that RAID
would take away all striping problems, but that is not necessarily the
case, why am I having IO issues despite the RAID hw? WIll ASM help
Thanks for any advice.

i have delete some table using
drop table tablename
but when i use select statement it shows like following
SQL> select * from tab;

Is it possible to create a view or a version of data accessible through
same object name (table or view), which returns different values for
different sessions?
Here is what I am trying to do:

is there a solution to reset a sequence inside a trigger?
I wanted to use this procedure:
####################
CREATE OR REPLACE PROCEDURE reset_sequence (sequencename IN VARCHAR2) as

I can start the Oracle9 WIN2000 with start of the computer but not restart
with the management console: error connection descriptor. What is to do?
Wolfgang

LOS ANGELES - Relational Database Consultants Inc. (RDC) proudly
announces the 5.0 release of the Encryption Wizard for Oracle now
shipping with support for Large Object Binaries, BLOB and CLOB Oracle
data types. The Encryption Wizard for Oracle is a sophisticated

If I do :
    (select       0, c.*
from    table1 c
minus

Is there a way to find out what user has a lock on a record? I am
performing a lock on a record by doing a for update nowait in my select
statement.  I want to get down to the row that is locked in that table.
I have found that I can see what user has a record locked on a table

   Am i the only one crazy enough to try and configure an Oracle 9i
management server (on W2k) and actually run a backup job off a Red Hat
linux server AS3 ?
   Just need to know that it can be done so we stop waisting time.

I am running Oracle Application Server 10g, and I tried to debug some
existing Java Bean files. so,  I used "System.out.print" to debug, but I
couldn't find where it wrote to. Anyone can help?
I tried looking into the  web-based  admin Log search, but couldn't find any

You may say: There is tonn of stuff on the web and in Oracle docs, but
the problem with that it that I get different results with each
one(take SYSTEM ts as an example).
Example 1:  Result: SYSTEM    97.71% (pct_space)

How can I rewrite the syntax for obtaining colC so that I still only
get the record that was most recently added, but I dont have to query
tabB twice?
SELECT colA,