What is the best way to model this: Assume I have two objects: Agency
and Publisher, and both have a 1-to-n relationship to Employee. This is
a true 1-to-n relationship, as each Employee can only work for one
Agency or one Publisher. Let's assume further that I cannot introduce a

Hi, i have advised one of our client to put zero for both these
parameters in a test instance. Since it is a test instance it doesn't
ran any queue or jobs.
But the customer claims that after changing these 2 parameters they are

I've been looking around in metalink without luck. If such thing
exist, would someone point me to the right direction please.
Thanks and regards

My table:
CREATE TABLE Tab1 ( ....,
pole1 NUMBER,
pole2 DATE,

Hi does anyone know where I can find beginner Oracle tutorial website.
With explanation of how to create tables etc so I can use real examples?
Must be very basic since I just started.
Also is there an Oracle 9i with iSQL for win me I can download  or a

When I run a PLSQL procedure and I run into the foll. error:
ERROR at line 1:
ORA-29400: data cartridge error
ORA-04030: out of process memory when trying to allocate 65548 bytes

I believe one of our application has set conn.AutoCommit=true, and the
session commit too often, because I often got 01555 errors when running long
query.
Is there any way I can tell which session commit too often and get some hard

Does anyone know how in 10g (10.1) xmldb I can query the resource_view
by path and return the found document as an XmlType?  What I want is to
obtain the document as a Java W3C Document; XmlType has a getDOM method
which would save me having to parse the character stream as below, ...

I have a problem, would appriciate you if your help makes me resolve
this issue. I have created two users in the same database and when i
run a query in these two users, one user executes it in a minute, while
other takes more than 10 minutes. Query to be run has mixture of views

We have a table which we want to extend with new columns,
by doing so we will get the SQLException "Not enough values"
when the existing code execute an INSERT statement without
the new columns values.

One of my friends, Scott, is a consultant who doesn't currently have
newsgroup access so I am asking these questions for him. I'll be telling him
how to monitor the answers via Google Newsgroup searches.
Scott has heard a lot of hype about DB2 and Oracle and is trying to

Server: Windows 2000 SP4, P3 1266 Mhz, 1Gb RAM
I installed 9i client (92010) without any problem and right after that
I tried to install the 92060 patch. However, the OUI won't appear after
running setup.exe. I also ran setup.exe in the install directory but

Our goal is to increase performance. We have data on one platform which
is replicated to a second using custom software.
We know the data on master is always correct as there is referential
constraints on the Master copy. I.E. Foreign and Primary Key constraints.

I had a n00b question about Oracle. When people say that they are
learning (or know) Oracle 8i or 9i or whatever, what exactly do they
mean? From what I can gather isn't Oracle just a DB server? So isn't
knowing SQL, sufficient? I guess you might have to pick-up some Oracle

Is it available anywhere?
Thanks,
Steve