I am just charged with beginning some research and I am trying to get a
basic idea of the best replication solution for the following type of
situation:
A reporting application wants to use our main DB to do reporting as of

I tried to show a friend that pl/sql cursors are in fact pointers and
do not retrive all rows when you open them. So I made this very simple
test case, but I don't understand the output. I think the answer comes
from the multiversioning side, but I 'd like to understand clearly this

I'm investigating a strange problem on one of our Windows 2000 application
servers.
We have a web application which connects to Oracle 8.1.7.4 on AIX.
Technology used is VB, ADO and OLE DB (MDAC 2.8 with the Microsoft OLE DB

i encounter a problem.
i do a SQL request, next i fetch all my records (do my code) but after my
first fetch out i need to restart this fetch. How do ?
like this :

Hi guys, I'm running Oracle 9.2.0.6 on Sun. I have this rather huge
(Siebel-generated) query which goes along the line of:
select
   T14.CONFLICT_ID,

I'm an user, not IS guy, and i'm not sure whether i'm on topic. I have an
Access / Oracle problem, where Access people couldn't help.
Until recently, several branches of our department either had their own
8.1.7 Oracle server, or they had separated instances (SIDs) on a bigger

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?
Question relates to both Windows and Unix server.
Assume latest version of Oracle.

We are seeing the following issues after switching from a workgroup to
domain:
SQL> connect fra@sejour
Enter password:

I don't know if such a function/command exists in Oracle SQL, but if
there is a better way for me to do what I show below, I'd like to know.
In the Oracle database we use here at work, there is a column in a
table where each character in a field of 108 characters represent a

I am making a copy of a 8.1.7 database to test an upgrade on. I
installed oracle 8.1.7 on the new server, created a shell database,
created my tablespaces, then did a full import from the source
database. Do I need to worry about any SYSTEM table rows that DID or

After devoting a great deal of effort to tune a particular batch process
some physical changes were made to our environment.  The result is that our
batch job now takes twice the amount of time to execute (7 hours instead of
3.5!)..

Ok I have this simple query..
SELECT id, name
FROM people
where id in (176, 181, 22, 61);

  RAC is still not good at multi-node write model, how about just open
one node in read-write mode, keeping other nodes in read-only mode, is
it possible? I just want to force a one-write-multi-read model.
  thanks.

We have an old 8.0.6.3 database running on HPUX 11 that currently
contains our Oracle Applications 11.0.3 instance (both database and
APPL_TOP) as well as a data warehouse schema.  We are beginning to run
out of physical room and plan on moving the data whse schema over to a

I have a update query that is not running, and is giving me a strange
error:
ORA-00933: SQL Command not properly ended
The Update Query is based on two tables, and that is what is causing