I have 2 tables and I want to make sure that a value from tableb is
included in tablea before it is entered.
tables defined as:
create tablea as

I have the following problem:
in a Master snapshot replication environment, which starts each 5 secs,
regardless the number of DML (which is quite small), a huge quantity of
redo logs are produced during a day.

I suspect this isn´t the right newsgroup (but it´s the best match i
could find) if so, please point me to the right one. Thanks.
Well, my problem is related to the "a table may be outer joined to at
most one other table" problem . I searched for solutions but couldn´t

Dear DBA,
You are cordially invited to test and review our 100%
pure Java Oracle 10g Monitoring Applet (OMLET). As
the leading expert in your field, your opinion and

What is the order of costliness with regards to: a.) redo activity,
potential lock escalation, etc:
inserts, updates, or deletes?
Thanks, TFD

I am running Oracle 9i Release 9.0.1 on Windows 2000 Server. Last
night, I started getting the error ORA-12500: TNS:listener failed to
start a dedicated server process. I have gone through the postings in
the groups for this error, however I could not find a solution to fix

Dear Sir,
Kraftware Inc.
Software Engineers required for USA
We are a leading software consulting company based in Nebraska (Omaha)

Win2k,  Personal Oracle Database 10g Release 10.1.0.2.0
First of all I am not a Oracle techie so please excuse the lack of
technical knowledge.  I have the following problem.
A disk was running low on space to I did a check of file sizes.  The

We are currently testing running Oracle 9.2.0.6 on Redhat 4.0 AMD x64.
We are using Veritas File System, and ODM..
We have linked odm.so files into $oracle-home/lib
On solaris, I believe OS calls should've been ODM, or at least kaio

I've a Oracle 9i db installed on a server elsewhere.
I've a program that runs a query using ODBC.
I installed oracle 8i (OraHome8i ODBC) on my machine and run the
program - works fine.

I know that there is a lot of way to increase performance of an application.
But could you tell me some I could not think of ?
I'm a totally lame on that part.
I have a big query, searching results trougth 12/15 tables, the time cost of

This may seems dummy but scenario is:
I have one schema called [B]user1[/B].I have created another user called [B]
user2[/B] that I want to have select,insert,update,delete privileges on
tables of user2.

Today I found myself in a strange mood.
As a joke, I renamed the datafile for the system tablespace from
SYSTEM01.DBF to SYSTEMO1.DBF on a colleague's laptop (replacing a zero
with an OH).

Does anyone know a Business Intelligence / Oracle consultant in the
Perth Area? I am starting a new "venture" and would require to get a
few people on our books in order to respond to our client demand.
We specialise in BI Strategy management and Technical Project

I have a directory defined in the DB with what i believe to be all the proper
permissions at the unix level that the directory in the DB points to.
however, i have users complaining that their application can't write to the
directory.