is raw data type obsolete and is it recommended for storing small amounts of
binary data? (max. 20 bytes).
what is it's perfomance gains/lost?

On advice last week, I have downloaded the "Project Lockdown" document
and begun reviewing it.  I get a very uneasy feeling about his
suggestion to remove the SUID bit from the Oracle executables.
Searching through this ng I find a lot of issues stemming from not

I think that there are 4 papers in OCP
1.    1Z0-007: Introduction to Oracle: SQL
2.    1Z0-031: Oracle9i Database: Fundamentals I
3.    1Z0-032: Oracle9i Database: Fundamentals II

Planning to migrate our systems to a new data center env in next couple
of months. Currently on 9iR2 - thought was to go to 10g but should we go
straight to 11g instead? General approach is to be one release behind
the latest so that we know the platform is solid as a rock.

what is the SQL equivalent of 'continue' and 'break' in C ?
like can I do this...
for counter in 1..10
 if(something something)

I have a general Oracle SQL question. I often come across a problem
when trying to select more than a single column of row that is the
result of a MIN or MAX. Suppose I have a table T with the following
columns:

I have 2 oracle 9i databases. One is on hpux 11.23 PA-RISC and another
is on hpux 11.23 Itanium. Can I clone the database from  Itanium to PA-
RISC? Thanks

Here is a thread I posted elsewhere that I wonder if someone here
could shed some light on...
The original question I had:
--- BEGIN ---

Oracle 10.2.0.2 64 bit, Solaris 10.
Here's the select? Occasionally we get an ORA-1410 on it but 99.9% of
the time it works fine. It's coming from a web based application that
uses a product called hibernate to access to the database.

As a temporary measure I need to install Oracle 10G onto the same
Solaris server as an existing 9i Instance (the server is powerful
enough to handle this load).
I've never actually done this before but I propose to install into a

I'm trying to install a 10g R2 database on a debian host. I chose to
install on Debian as I know that distributions for many years now and
Oracle is more then enough new stuff for me.
The installation process was okay, the only problem was a reproducible

Oracle 10.2.0.3 , Windows 2003 Server
I've been reading the Oracle documentation on database links.  Using the
information below,
have I understood what I've read correctly?

for some management works i've truncate a table with reuse storage
option and next i run "insert"  for repopulating table with the same
original data. In this case, is useful to rebuild indexes of the table
or not?

I am trying to restore my DB.
Is there any way to come out of error "ORA-01153: an incompatible
media recovery is active" without requiring to shutdown the DB and put
it in mount state ?

Oracle Applications 11i Technical
Vennela Technologies Pvt. Ltd. is a Leader in ERP Training and
Projects in India Vennela Technologies has been in Training from last
4 years. Vennela trained more than 4000 users in Oracle Applications