In Oracle 9i R2 on Solaris 8 I have a table (LOCATION) that has data.
I want to create a Foreign Key (FK) and base it on an existing field
(location_key) in this table.  I am not 100% sure the values are unique
(which is required to make it a FK for a child table).

can someone tell me how to setup this parameter in listener.ora :
direct_handoff?
any samples would be great !

I am using oracle 9.2.0.5 on HP UNIX 11i.
I had to do a full import of database from a full export done on same
database. However, after full import  STATSPACK package under PEFSTAT
has become invalid.

our dba is out for sometime and we're a little stuck.  We currently use
Oracle 9i, there is a table with a field which is of type CLOB, is
there any way to see it's content when quering it?  We're using the
enterprise manager console's Sql Scratchpad, but it doesn't display it,

is there any way to do that;
i have 2 tables
This is table1;
code1 code2 code3

I'm trying to select records in a table where the multiple occurances
of data in one field are not matched by data in another. Difficult to
explain (or bad explaination), I guess thats why I'm struggling to
write the sql.

I should make a .Net Windows Service that should work in different
installations with OracleDataAdapter versions 10.1.0.4 and 10.2.0.?
I can imagine that I have to compile two versions of my service other
referncing the 10.1.0.4 and the other referencing to 10.2.0.?

Hi Friends,
Hi,
In this case "set autot on" is telling false plan with binding.
Can you put some light on this ...

I want to know how exactly 'select sysdate from dual' works. From where
Oracle brings in sysdate if the init parameter fixed_date do not have
any value set against it. I know it brings the server machine date time
and if it does then exactly how is sysdate pointed to bring in server

I'm posting this under a new subject, as I had posted this info to an
earlier thread with a different subject ("Can I safely get rid of the
EXAMPLE tablespace?"), and I'm hoping you all just missed the latest
posts.

So I'm playing with Oracle's new feature in 10g datapump.  I'm having
an issue moving a particular table.  For whatever reason the process
hangs.  The only thing I can come up with is that this table contains a
blob column.  What's interesting is that I have other tables with blob

hi all  please help..
linux version 9 rh and oracle 9.2...
i start up windowz and directly launch sql*plus tool... it just asks
for the username and password..and then i am good to go ,because the

I was wondering, what interface do you use to administer your database?
Command line? Or enterprise manager?
I use both, but for different tasks.
For all monitoring tasks, I use EM. (cute graphics, easy to use...)

I have just started using oracle and currently working on the
concurrency issues in it.
For this I want to take the sql trace of various queries that are
encountered by server along with transaction id (or session id) and

I would like to run a bunch of queries and redirect the output to a
file. The queries would be run against an Oracle database. I know I can
create a simple procedure/package to do this, but not clear how to get
the output redirected to a file.