Folks,
I installed Oracle 10g R1 on Solaris 10, and also created (using DBCA) a
database.  Then I deleted all the files in the oradata directory.  Now, when
I run DBCA, I am still presented with the option to delete a database, and

I am new to this group and my friends gave a great feedback. I need
help in writing  Insert
triggers that would insert a record on a table, whenever a specific
record is deleted from another table. I am using Oracle 10g.

I want to create a job in Oracle 10g. The job contains just a stored
procedure that would be used to populate the table(s) in Oracle. Later
I would be scheduling the job on a regular interval.
How to go about that? Or is there a better way to achieve this?

Hy,
i just want to test standby DB and dataguard with 10G enterprise edition
on 2 w2k boxes.
must i install  the grid management or not ?

I want to configure my very active 20 gig UNDO tablespace across 4
disks.  I want to balance the IO as much possible, using the most
efficient layout.  I'm trying to determine it it would be better to
create 20 each 1 gig data files and assign them round-robin to the UNDO

DB2 DBA professionals needed for CMMi Level 5
skills : Oracle DBA
exp : 3+
location : Chennai

We currently run Oracle Applications 10.7, Oracle 8 db.  We are
upgrading to Oracle Applications 11.5.10 with new hardware.  We plan on
running Oracle db on Red Hat Linux.  My problem is with the hardware
that our hardware vendor is recommending we purchase.

How to check whether my database link is working or not through any sql
query.
TIA
Niraj

for the web-application we're developing, we need to transform points
in Oracle spatial to circles with a given radius in Oracle spatial.
Can anyone tell me how to do this?
all help will be greatly appreciated.

My application is doing a select a a view.
I have a Bash script which run Sqlplus using a .sql file.  the query is
done in this file.
I don't know how the view has been created, how it compute the rows...

I am looking for a rules engine, based on Oracle, that is as generic as
possible. I don't even know if such a beast exists.
The application area is saturated by nested ifs, else and lookup in
various tables. I want to try and consolidate all of that and hope that

Is anyone using Oracle 10g on AIX with filesystems mounted for concurrent
i/o (instead of the default cached i/o) ? Just wanted to know if there are
any known disadvantages. Apparently concurrent i/o has nearly the
performance of raw devices.

Hi, has anyone had any experiance using the Oracle database, express
edition.  I've downloaded it, and installed it, however it does not run.  It
comes up with an error message telling me I can't access the ftp sever.
I've loaded it on to a stand alone laptop.  Any Ideas ?

PLease what is the function of the new services as ultrasearch and
sqplus ports that are assigned at the installation step ?
Regards
Paul

I have an oracle database 10.2.0.1.0 running on Solaris 5.8 which I
imported the data from a different version 10.1.0.4.0, the Import was
done fromuser=test touser=test, after I tried to export the same data
out and I keep getting these error messages