I have a user requirement to do Oracle on-line (hot) schema backups and
restores from within my Java application.  What is the best strategy to
use and what are the pros and cons?
Thanks.

I am setting up an Oracle Management Server (9i on Win2K) to test the
functionality.  This has worked OK but I find that when I try to import
a DMP database I get the message VNI-2015.
I followed the instructions that were displayed and entered the id of a

I'm using the 9.2 Windows client software and would like to upgrate
to the 9.2.0.65 ODBC driver (currently using 9.2.0.54). Now, does
anyone know how to install the driver update? The problem is that the
Oracle Installer that came with the 9.2 client (OUI version 2.2)

I am wondering if anyone can tell me how I can read (select) data from
a synonym. I am getting the synonym list and want to be able to use
orcale SQL to read/select it.
Thank you in advance,

I have a table in tablespace A with uncommitted transaction and when I
logged in to a different session and tried to alter another tablespace,
B to read only, the session just hung waiting on enqueue wait. I don't
understand why the session has to wait on enqueue when the tablespace ...

Is there a SYS table which indicates whether a
session is primary or non primary? I tried using
the v$session table, but none of the columns seem to
indicate whether a session is primary or non-primary.

We are planning to set up a 2-node 9iR2 RAC on machines running HPUX11i
v1. We now have to choose between RAW and file system.
Q1. Is it true that if we would like to get a file system for storage
of oracle files, we would need to purchase a third party CFS ... eg.

I have created the following XMLType table based on a local
schema using the following syntax.
BEGIN
DBMS_XMLSCHEMA.registerURI('http://localhost:8080/public/contact_simple.xsd','/public/contact_simple.xsd',LOCAL=>TRUE,

  I am running our product on OC4j installed on Linux Red Hat 3.
I start OC4j with the following args
-XX:MaxPermSize=128M -Xms512M -Xmx512M
Our product requires 512MB to run smoothly.

Oracle 9.2.0.6 on Windows or Unix:
When I read a file by means of a external table, the fullstop is
interpreted as the decimal character. How do I change that to a comma,
for this external table file only?

I have ora 10 client installed on my XP laptop and it works fine. I
don't want to uninstall it.
Now trying to install ora9i server but the silly installer is behaving
strange. It comes up with default destination name and path of this:

Oracle's Password Transform
Goals:
- Authentication information ("encrypted password") shall be portable
  between machines with different character sets (ebcdic and ascii).

Now, after running the orginal view, i will have records with same
db_tran_id and those may have different a.ADUIT_DATE.
But, I want to make them have the min a.AUDIT_DATE for all records with
same_tran_id when select from the view:

We have a puzzling situation where doing a series of Inserts will block. The
user has a transaction consisting of 4 inserts then has to confirm and we
commit. If a second user starts the same sequence, the 4th insert will block
until the first user commits. Our database people felt ...

I am installing Oracle 10g 10.2.01 on Windows Server 2003 SP1 32-bit edition
but for some strange reason the overall performance of the disks on the
server decreases after it is installed.  I know this because I am using
SiSoft SANDRA Pro to do a File System Benchmark before and ...