I have a number of tables which I wany to delete rows based on a condition.
However, one or two of the tables may have multiple rows.
eg DELETE TABLE1 TABLE2 TABLE3 TABLE4
   WHERE EMPID = 'ABCD1234'

Oracle: 9.2.0.4
OS: Linux
when starting a ctxsrv process, getting the following errors in the
logfile.

I''m converting a sql-statement with a 'group by' to Oracle 8i .
Select Tab1.f1, Tab1.fk,
   (select field from Tab2 where tab2.pk=Tab1.fk) as description,
   count(*)

something strange happens here and I don't know why:
I want to export a Oracle 8.1 Database as I do often from another pc in
the network.
Starting the export with user SYSTEM, Oracle starts to export all, but

I am facing an odd problem:
I have an HP-UX machine and I have created several instances on it. All
but one cannot started, while trying to start it machine hangs and that
specific start process will eat almost 99 percent of cpu...

All,
Does Oracle address dual pathing to disks in any way?
E.g. Veritas, has something called vxdmp which automatically fails IO
over to a different path, if path 1 fails

Greetings all. For lack of knowing a "proper" place to post this, I am
posting this message here...
A couple of weeks back, I requested help from this group regarding a
daylight savings time issue I was having. I have been working on this

My BEFORE INSERT trigger checks for invalid quantities.
If QTY <= 0, a raise_application_error is issued and outputs a message to
the user. I was also expecting the error to roll back the insert but the
record is still inserted into the table.

I'm using Oracle 10 XP client with oracle 9 server.
Listener is up, according to tnsping.
But I keep seeing 12505 or 12514 errors when I try sqlplus via VPN.
tnsnames.ora:

okay...apparently, no way to bulk insert data from file using a SQL
statement. I must use sql*loader. But sql*loader uses a control file
where is written the target table and I need to make target table
variable.

This is a question to all you DBAs out there.
Let me start by saying that I am no DBA.
I know that someone with a lot of DBA experience is always prefered to
one who just has an Oracle DBA OCP certificate. 10g DBA OCP just came

Is this possible? Should be backwards compatible right?
Currently seeing "could not resolve the connect identifier specified".
DBA said I should use this in my tnsnames and I do:
mydev.world =

I'm absolutely new to Oracle and I'm no DBA also, so my apologies if
the questions will sound stupid.
I'm trying to create a link from DATABASE1.mycompany.com  to
DATABASE2.mycompany.com  (i.e. I want to connect from Database1 to

hi........
i have installed oracle 9i, i need to fine a table name..
I think there should be table for that also..
Problem is this....

I am monitoring the database 8i on solaris sparc (SunOS 5.8) by query
rows from v$sysstat, usually the "user call" is larger than "execute
count", because the "user all" include parse call, fetch call and
execute call, but some times I found the "execute count" much larger