I am running Oracle 9.2.0.5 on Win2003 and having a problem deleting
badfile created by load from external table. I get ORA-29291 and if I
try to delete if manually, then I am getting an OS error: "cannot
delete... being used by another program...".

I'm trying to help a friend with question on Oracle Databases.
Basically shes trying to create a user interface that allows the users
to login to a
canvas, where they can insert data and query it.

We have recently moved our RMAN hot backups to Data Protector. The hot
backups are working successfully. Restoring works fine. Cloning a
database from one instance to another -- on the same host -- works
fine. I'm using an RMAN script with the appropriate Data Protector

Hey All,
Can anyone please share how you set the Oracle /etc/system settings on
a Solaris 10 system?
Solaris 10 is fundamentally different and uses a tool (prctl) to set

 We need a mapping of "set rowcount" of Sql server in Oracle.
 any pointers or suggastions are welcome

Hi, we have C++ product - ReportSmith. It could translate Oracle
DATETIME types to formatted string.
Where I can find description of the internal structure of TIMESTAMPs
types so I could add new parts to translated data?

Dear DBA,
You are cordially invited to test and review our windows native and
100% pure Java Oracle 10g Monitoring & Security Application (Xg).
Xg is  the Ultimate Visual Real Time Oracle Monitoring Tool. As the

I have posted a page to the internet with a bit of a puzzle (to put it
mildly): http://www.psoug.org/sudoku.html
This is hardly a finished work of art ... in fact it is only about 3
hours or so worth of any work at all.

My company decides to migrate Oracle 8i database(about 10 databases)
this year.
I've collected several comments from ISV and other DBA peers as below
1. 8i will be desupported at the end of 2006.

Dear Oracle Experts,
I'm using Oracle 10gR2 on Windows XP SP2.
Since the last boot of my mashine I have a problem with my isql*plus
service.

This may be another horrible idea.
** Is There any way to auto update columns of database table.
==============================================================
Suppose I'm managing a database for school children.

My previous mail in another group was left unanswered. May be someone
here can help -
I am trying to do something pretty simple as follows -
1. Create a C/C++ export method in a Windows DLL that returns a string

Oracle10g R2 10.2.0.1.0 (64 bit)

SESSIONS specifies the maximum number of sessions that can be created
in the system. Because every login requires a session, this parameter

I'm trying to help a friend with question on Oracle Databases.
Basically shes trying to create a user interface that allows the users
to login to a
canvas, where they can insert data and query it.

I am working on 24 X 7 database. I cann't shutdown my database. I have
multiplexing of Control files on 5 places. Any How one Control File is
deleted or corrupted. How can I come to know about that. Information is
not in V$CONTROLFILE, V$CONTROLFILE_RECORD_SECTION, Alert File,