Is there any scripting language with the support for array
interface? Perl doesn't have it nor does PHP. What about Python?
Does it support array bind and, if it does, does it cheat like DBI
which breaks the array under the hood and internally performs a

I have an extremely high TXNCOUNT number for the period when
the database is supposed to be mostly inactive. The fine manual
defines the column like this:
TXNCOUNT

I've recently had to restore our database from a (online) tar backup,
and I've had problems connecting via sqlplus since then. Solaris
8/64bit Sparc, Oracle 9.2.0.6.0 was restored but was patched to
9.2.0.7.0 since then.

I had installed Oracle 9i database and while creating the database I
had selected UTF8 for supporting Arabic.   If I try to connect the
database from any client i.e, through SQL*PLUS version 8 (developer
2000 6i) the screen disappears after accepting the username, password

was wondering with 10.2 if there was anyway to allow the root user to
'sqplus / as sysdba' w/o a password like the oracle user can?
I tried added root to the dba group but this seemed to have no effect.
Thx,

I risk sounding like an idiot here, but I'm a database newbie and I
don't know the first thing about Oracle - not a jot!
I'm currently doing a University assignment that requires me to cost
out an Oracle database for a company, along with all its trimmings,

Good evening
I have a really big problem. I'm a student and I have to preper a
application for testing Oracle's efficiency. Could You give me some
sources of this kind of applications, or could you send me some

I am presently reading Expert one-on-one oracle, but have a few
questions:
1. After a DML statement all the required redo is generated. But if i
commit there is a small amount of redo generated. What is this redo ?

I am trying to install oracle 10.2.0 (10g r2 ) on linux 64 bit.
uname -a (show this:)
Linux test2 2.6.8-24.14-smp #1 SMP Tue Mar 29 09:27:43 UTC 2005 x86_64
x86_64 x86_64 GNU/Linux

We are trying to compare two tables of similar structure. In other
words, the missing and the different records are to be determined. The
database is Oracle 9i.
The options being evaluated are

We have created a very simple test case on a new HP RX4640 Itanium
server with 10G.
It runs Redhat 3 update 6 with Oracle 10G
The test case is simple: No I/O, simple query execution plan, small

We are trying to compare the data of two tables of the same structure.
In other words, the missing and the different records have to be
determined. The database being used is Oracle 9i. The options I am
currently evaluating are

I've been taking advantage of the holiday to update many of the entries
in Morgan's Library and decided to build demos of the of the
functionality in the DBMS_SPACE package: Some documented, some
undocumented.

I am trying to work out how using rman I can reuse an old backup once
the global retention period has passed, does anybody know how to do
this??
TIA