In Oracle 9i we can create primary key constraint for views.
I am writing a PL/SQL script to retrieve the primary key columns from
Oracle data dictionaries. I can successfully do that with tables, but
with views it is not possible with the same script, because the primary

I'm looking for a few pointers. Basically we have a requirement to have
2 Oracle clients running on a Win XP workstation. At the moment I'm not
sure what versions both clients are but one is for Oracle ADI and the
other is for a legacy application.

I have following questions, appreciate your response:
1. I have Ocale Enterprise Dition license, If I used dbms_obfusaction i
Oracle 9i R2, does it require advnaced security option lcesne I do not
thn so.

i already have oracle 9i on my system and i loaded 10g and get above
error in sqlplus. something is conflicting. when i set oracle home to
9i i get sqlplus in 9i working but when i set the home to 10g i get tns
protocol adapter error. also  tnsping gives no listener.

Can any body explain me on how to obtain connectivity between oracle
and progress database. The progress database already exists and i need
to use it in oracle. And hence need to obtain a connection between
Oracle and Progress database.

I've a strange (for me at last) performance problem.
I've two very similar tables FORM_TROUBLETICKET_9 and FORM_SERVICETICKET_4.
Because of this similarity I have somtimes to query the data in one of
the two tables, somtimes I have to query the data in both tables. So I

I have just installed a 10G database server on Windows 2003. Now, to
get the Enterprise Manager tool that I am familiar with from earlier
versions, should I install the Client (Administrator or Custom) or
should I do a 10G Enterprise Manager Grid Control install?

I have this error: ( in listener.log )
System parameter file is D:\Orant\network\admin\listener.ora
Log messages written to D:\Orant\network\log\listener.log
Trace information written to D:\Orant\network\trace\listener.trc

I have a table like this :
table_a (id1,id2) : ( 1,2)
                         (1,3)
                         (5,7)

I had oracle 9i loaded on my windows xp, now i loaded oracle
application server 10g and get this messsage as when i start sqlplus.
Do I change ports for listeners for oracle 9i and 10 or both can start
at 1521. Earlier I was able to connect to sqlplus in oracle 9i now it

                Can someone please tell me some link or some documents
reagarding the challenges faced in RAC when migrating from Oracle 9i to
10g?
Any help would be appreciated

Hi ng,
the following trigger produces sometimes an error "Too many open
cursors".
I do not have any explaination and it was impossible for me to find out

I have a simple table
create table sstest1 (act  char(10) not null);
It has 3 values
insert into sstest1 values ('9');

I would like to know if there is a way to include text from inside a
document in the data yielded by an Oracle Text CONTAINS query. I've got
a table with the fields: id, item (in which 'item' is a blob including
word docs and pdf files), in which case I could execute this query:

My app has several tablespaces dedicated to b-tree indexes, nothing
else. I'm curious to know how I might best configure these T/Ss for
good performance. I've read Burleson's articles in which he proves a
reduction in logical reads by using larger blocksizes - and I'm going