Background: I created a brand new (from scratch) 10gR1 instance using
ASM on Solaris 2.9 back in 07/15/2005.  I then upgraded the instance to
10gR2 (10.2.0.1) about 4 months later (on 11/11/2005).
I have recently noticed that I am receiving "Thread 1 cannot allocate"

Can someone translate this MS SQL Server statement into Oracle PL/SQL?
The purpose is:
Table DTATemp initially has structure and content:
(actually, there are more fields, but these are two relevant ones)

I'm trying to do fine grain auditing, and using scripts based off the
rows taken from these tables.  Here's two fields I'm particularly
interested in:
SQLTEXT                       VARCHAR2(4000)

I'am using ORACLE Server + Client 9.2.0.4.0.
While creating triggers  within SQLPlus* I get the message:
Warning: Trigger was created with compilation errors
If I executer 'show errors' I get : No errors.

block, and whenever we try to read that block it checks for the Commit
status of that transaction ID in the undo segments, so if it is
committed it reads from the block, else it reads the undo data ( by

how can I recognize if a Database is running in ACHIVELOG - Mode,
and what is the procedure to switch between [NO]ACHIVELOG ? [Oracle 9i]
Thanks
Joachim

I have a problem with a function:
function getOrder (in numberOfOrders) return refCursor
(
select  sequence.nextval into tag; -- we get number value from sequence

What is the real description for this column? The documentation is not
clear about this one.
Even after a physical backup and no subsequent updates,
backed_up='N' for all tables according to my tests. The same after a

I'm going to work with Oracle 10g database with up to 60 mln records in one
table. The number of tables will be in range 20 - 50. All records are small
(about 200 bytes). There are no relations between tables. What hardware
architecture would you recommend?

I'm working with Oracle 7.3.4 and I have to use "exp" to export the
database for data backup.
As limited by operating system, the dump file cannot be larger than 2G.
However, I need to perform a full export (full=y). Therefore, the

Is there any possibility to Change the Path of the REDOLOG File . If so
what is the command to do so
Thanks
NP.

Does anyone know what additional benefits Zend Core for Oracle does?
Thanks
.......
We run Oracle 9.2.0.6 on RH4 AMD

Anybody else see anything strange at
http://www.oracle.com/search/advsearch.html ?
I'm seeing "Welcome Andrea Wendland."  Found in a search for a
technical term on the oracle.com site, listed in results with a date

Is free sqlnet software for Unix Sun Solaris out there I can download
for personal use only?
Please give me a pointer.
Thanks

I'm trying to install Oracle 10g linux client
(10201_client_linux32.zip). The target machine is an Intel Pentium III
machine running CentOS 4.2. I am attempting to install over an ssh Xorg
forwarded session from my desktop (a FreeBSD box running Xorg/fluxbox).