I have a query with 3 full table scans (each table has 360000 rows). I
tried to create indexes,add hints and removed the FTS,but cost was 100
times more than FTS and ran slower. Could anybody help me to tune the
statement? Thanks.

Hallo I'm trying to install oracle 10.2 on SUSE 9.3-Prof. and i have the
follow problem.
 ./runInstaller
Starting Oracle Universal Installer...

how can i "translate" this query from Postgresql SQL in Oracle SQL ??
SELECT DISTINCT ON (rif_calcolo)
    descr,validita,imp,rif_calcolo
    FROM indennita WHERE societa=1 AND

Dear netters,
We are trying to build a piped export/import of specific tables on
Oracle 10g (AIX).
I have followed the general recommendation of creating a FIFO pipe on

just a quick question,
how can i check what version of Cobol and C its instaled in my AIX 4.3
os?
Thanks in advance.

I want to know Oracle 10 G , it must to run the
$ORACLE_HOME/RDBMS/ADMIN/initplsj.sql script manually as a SYS ? and it
must to load plsql.jar file ? because I can not find these file in
Oracle 10 G.

All,
I'm new to Oracle and I would like to find a way to create a script that
will loop through a list of users (the output of a select query from the
users system table) and remove each one of them.

1. What happens if the limit option is not specified in the bulk
collect? Are all the records fetched at once?
2. Is there a limitation in terms of maximum number of records that can
be fetched in this way?

im a beginner oracle user and i have been asked to figure out a way to
save an entire schema that we have residing on an oracle server to
cd/disk.  how can this be accomplished?  thanks!
rick

 I am running oracle 8.1.7.4 (32 bit) on 64 bit solaris 2.9 platform.
I am running statpack every 15 minutes.( to collect information like
execute statspack.snap)
I have a question, what is the best way to maintain the size of the

RDBMS Version: 10.1.0.2.0
Operating System and Version: Windows 2000 SP4
We are facing lot of redo generation which create archive file of 50 MB
each for 10-20 minutes, this doesn't happen in normal usage. When we

I am looking for a best way of modifying the column data types.
I use the Oracle 9.i
For example I have the table:
   CREATE TABLE testtable (

oracle 10g rac dumps a lot of files in the $ORACLE_HOME/dbs directory.
The files name is like c-252182375-20060111-01. Does anyone know what
is that file?
Thanks in advance.

RDBMS Version: 8.1.7.4.1
Operating System and Version: Windows 2000 Advanced Server
All OS and Server version details are mentioned above, although single
instance can take 2GB of memory on Windows, when Oracle.exe reaches

This question is a bit tricky and to the compilance of sox. Thanks.
I created a procedure under x schema in database A and want to execute
it from database B under y schema.
How to work it out without grant execute to public?