Hi I'm looking for a DBA type query that will list every connection to
the RAC database and tell me which instance its on.  In other words we
connect  system/manager@db1
When you do a   select instance_name from V$instance;

I have two tables, both with same 2 fields for primary key and total
four fields.
Table-names : t11, t22
fields : mydate varchar2(16) not null, mytime varchar2(16) not null,

I want to do some Pro*C at home (personal use only).
I downloaded the free Oracle 10  Express Edition and
it seems to only support OCI.   Is there a way to
get Pro*C for Oracle 10? Is there a free or inexpensive way to get

Running 9.2.0.5 in OEM. If you look at a table on the statistics tab it
lists out 'Empty Blocks:' and 'No. of Freelist Blks:'. What is the
difference in these two values? I've got a table with 9795 empty blocks
but only 5 freelist blocks.

Fellow Oracle users,
I am trying to figure out whether the use of JInitiator is *required*
with Oracle EBS.
I found all kinds of matrices what versions of JInitiator is certified

   I am new to Oracle - I may be asking a very dumb question - Can I
create the recovery catalog database on the same machine as I am
running the target database on Oracle 9i? I want practise some RMAN
commands on a PC using Recovery Catalog.

I have a table containing blob column.
There are some records in the table and the blob column contains .jpg,
.gif, .doc files.
I dont have filename stored in database which has the extension.

I got a few question to here, and I am new to oracle and plsql.
1. will you be able to create varray in oracle trigger or stored
procedure?
   something like

I am working on Cognos Decision Stream. I need to run a job stream on a
daily basis which contains fact builds.  I do not have much knowledge
of pl/sql. In decision stream I have a sysdate function.  I want to run
this job stream every day whenever the sys date changes.

My primary db (10g R2 Soalris)  has a tablespace created by transported
it from other database  (using oracle transportable tablespace ). it
has two datafiles (aa01 and bb02.dbf).  The tablespace is read
writeable.

Is it possible to login as specified user by plsql statement?

We have been doing a full refresh of a huge table
it takes around 4 hours usually. we truncate the table and recreate the
indexes
Now, we are planning to go for an incremental refresh of the table

On one database table I got this strange error (Oracle 9.2.0.4 Linux)
ORA-01801: Datumsformat zu lang f³r internen Puffer
I found out that in a date column and in some rows the datevalue is
"corrupted"

I'm not e good trigger programmer but
I want to make a trigger that when I update or insert one record in
table, the trigger check the values of a field, and if it is
equal at one prefixed vales, the trigger update another field.

I am new to this field. I have been working in Mainframes for a while.
I just wanted to know, whether Oracle has the power and capability to
replicate mainframes in future.
Thanks.