I'm new in dynamic SQL query and I have a problem need help.
For example: I have a SQL query like this:
select hw.family,hw.id where hw.id="1234567";
and I have a txt file holding more than ten thousands id.

i have had to install 8.1.7 on Redhat Enteprise 3.  That was a feat by
itself but i finally got it to run the listener and the instance, i have
a database and all that seems to be running fine.  my problem now is i
need to import a dump file into this instance and as you know, i ...

OS:  SunOS 5.8 Generic_117350-07 sun4u sparc SUNW,Ultra-Enterprise
Oracle 9i
This is probably obvious but I just have an uneasy feeling about it.
I have a stored procedure where I fetch my cursor into 3 pl/sql tables

We're almost ready to give up on DB2 v8 and consider migration to
Oracle (the reason is DB2 v8 being unstable). The main question is -
how good and stable properly configured Oracle is under heavy OLTP load
(10M+ transactions/day)? DB2 v7 handles such loads nicely, but v8 even

The following 2 queries are different only w/ or w/o "as 'test'".
Oracle server and client info:
SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 20 10:44:37 2005
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Just a question/curiosity
I have a database with many TS/datafile. For ONE TS there is ONE datafile.
Can i get an old datafile for this TableSpace and start the DB (stop DB,
delete current datafile, and copy old datafile) ?

How can I completely and cleanly uninstall Oracle 10g from a RHEL 3 AS
server?
Thanks,
Yasaswi

We have a Oracle Database version 9.2.  When we tried to shutdown
immediate the database we got the message
SQL> ORA-01013: user requested cancel of current operation
SQL> ORA-01081: cannot start already-running ORACLE - shut it down

  I want to know the root cause, which is making rollback per
transaction% to 99.57.
  Also i noticed user rollbacks per transaction is 1. (i have attached
the part of the statspack below)

Is there any way to force the result set to behave as if the SQL
contained DISTINCT directive, when the SQL DID NOT actually contain the
"distinct" keyword? I am looking for ideas, so please feel free to
suggest different ways (stored procedures, views, etc etc).

first of all, my apologies if this is off-topic. If so, please tell me
where should I post it...
then, my problem
I have a COM+ written in VB6 which has to access an Oracle database

I have to generate some reportviews.
The report shall show one row for each
day since day X. Since the tables where
I get the information from don't have

i have had to install 8.1.7 on Redhat Enteprise 3.  That was a feat by
itself but i finally got it to run the listener and the instance, i have
a database and all that seems to be running fine.  my problem now is i
need to import a dump file into this instance and as you know, i ...

I use 10.1.0.3  on  Proliant DL380  on Redhat AS 4
what is the best configuration,
hyperthread enabled or disabled ?
Nothing usefull on google and metalink ...

OK, I'll admit I'm confused.
1. In Oracle, is there a difference between Rollback segment(s) vs Redo
Log(s) ?
2. If the Rollback segment and Redo Log are 2 different entities, is a