I have been messing with this for a week and have asked a few questions here
and read a bunch - I think I am almost there.
What I have:  Both are Oracle 9i Old server W2K c:\oracle\...  New server
win 2003 d:\oracle\... backups using RMAN nocatalog (using controlfiles)

I have installed OEM grid agent on Tru64 cluster server and evrything
was ok but last time I can't start OEM grid Agent on one of three
nodes.
When I have starting agent on this node I have something like that:

10g.
How can one tell which table a field in a query comes from? For
example a join between tables A and B contains 10 fields (F1 to F10),
5 from A and 5 from B. How would one tell if field F1 is from A or B?

I'm attempting to get the SOAP server access to stored procedures
working, however I'm not having alot of success.
I've defined a Test function in the Test Schema
CREATE FUNCTION Test (tid    IN     NUMBER,

I am transitioning to Oracle from SQL Server using a poorly documented
application that uses Oracle 9 as its back end.
SQL Server has a command that dumps the names of all Fields in all
Tables.

Is a cluster file system a prerequisite for RAC files or will OCRS
handle this task for CRS control files as well as database data/control
files?
Thanks

I have installed OEM grid agent on Tru64 cluster server and evrything
was ok but last time I can't start OEM grid Agent on one of three
nodes.
When I have starting agent on this node I have something like that:

We have a table T with the following structure:
Name                          Null?    Type
----------------------------- -------- --------------------
USER_I                        NOT NULL VARCHAR2(30)

I'm on O v 9.2.0.8, W2003.
Given a local date, time, and country, is there a way to determine EST/EDT,
the critical factor here being daylight savings time aware?
Don't I need a country to Oracle Time Zone Region table to be able to use

Sorry for my english, i'll try to explain my problem
I'm working with Crystal Report X and i call a oracle stored
procedure.
One of the parameter (ListOfPoint) of crystal is a multi value (id of

When to use Index Organized Tables (IOT) and on what type of tables?

is it possible to use a 'pointer' like reference to a table?
i want to write a function that should select from a table that is not
known at compile time (but referenced in argument list)
like:

hi, we have Oracle 10g db on Solaris. All of a sudden the developers
are unable to edit the procedures in the db. Nothing is changed and I
restarted the db and still the same. So I shutdown, then in mount
stage I issued alter database open read write. But still the

*** 2007-08-10 15:27:04.440
*** SESSION ID:(26.789) 2007-08-10 15:27:04.439
DEADLOCK DETECTED ( ORA-00060 )
The following deadlock is not an ORACLE error. It is a

I am pretty newbie to OCI layer. I was trying to make a connection to
oracle, and was trying to fetch timestamp datatype by binding
timpstamp datatype.
This datatype shows different behavior for different sub second