I'm trying to configure sql apply standby database with XE !
As i can see all needed is there, except data guard automatism of redo
log shipping to standby! That is possible manually.
Did anybody succeeded it and is it possible?

a OCA question!!!
A system tablespace can have a dictionary management or a local management.
is it true that in case of a local management of the SYSTEM tablespace the
creation of a temporary tablespace is mandatory?

I have a problem with schema validation on table with xmltype
column.
I have very simple schema: "X" root element with one of the "A" or "B"
child.

Anyone can recommend some links, some books?
We support about two dozen Oracle dbs, and seems like we'll be getting
a few SQL Servers to look into, and are just not read to hire a SQL
DBA yet, but we'll look into outsourcing some stuff initially (and

I'm trying to do a restore/recover to a point in time from a hot
backup in 10.2. When I opened (reset log) the database, it complained
that datafile 1 was fuzzy. What view can I use to check which datafile
has a different checkpoint scn or what the issue is?

Its been a slow day at work, and I had a thought to write a bit of sql
to return the list of indexes, last time analyzed, and num_rows for a
given cursor.
I initially thought about using the join and split pl/sql functions

I am trying to left outer join to a table with mismatched results...
let me explain
Table: first_names
id     first

the query below waits a lot of time on
"SQL*Net message to client" (20/30 min)
and after on "latch free "
do you know why ?

How should I be comparing a DATE column with "one minute ago"?
I do this:
   select sysdate, sysdate- interval '1' minute from dual;
and get just what I need, the time a minute ago:

Is there are an existing monitor in Grid that would alert us of that?
Thnx.
.......
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)

I was just wondering if anyone had any alternatives to this situation
I have in my oracle app.
My application is given tasks to perform which cause data in the
remote oracle database to change. Depending on the task completed,

Using Oracle 9.2.0.8 on Windows XP.
I am loading a file into an external table then dropping the table and
trying to move the file used to create the external table to another
folder.  A lock is maintained on the file even after droppping the

How do I set the SSM to auto for the SYSTEM tablespace (EXTENT
MANAGEMENT LOCAL) when creating a new database in 10.2.0.3?

I've posted this in the perl group also, but not really sure which
group would be better to get an answer from. Is it possible to use
dbms_application_info.set_session_longops for 10.2.0.2 in a code loop
of a perl script? I've only seen it used in pl/sql loops and I'm

Oracle used to have a CASE tool named "Oracle Designer 2000". Does
anybody know what has happened to that tool? Was it discontinued?
If it wasn't, what is the name of the follow-on product?