Am trying to learn Oracle at home (between jobs!).
Log on as scott/tiger.
set linesize 10000
set pause on

My company is going to spring for some Oracle training courses for me.  I'm
wondering how much difference there is in the product between 9i and 10g.
The application we're using currently runs on 9i.  But I would have a larger
choice in course locations if I could consider 10g ...

I am not clear about the the redo logs, undo logs and in general what
happens to an Update statement.
from what i have read when a data is modified the modified data is
stored in the undo log. If it is not comitted then other users read the

I've read somewhere, that Oracle offers a feature, that I can create a
table as a index.
i.e. I've a table with key1,key2,key3,key4,value
where key1,key2,key3,key4 represents a unique index.

I am currently running Oracle materalized-view replication and slave
nodes suffered constant problem after a few hours. I can see two
identical 12170 errors in the master's sqlnet.log:
Fatal NI connect error 12170.

What is the difference between LONG RAW and RAW?  It seems that both
represents unstructured large binary data.

Recently I read a database book, one chapter is about ODL (Object
Definition Language) and OQL (Object Query Language). I still dont
really get it :
1) Can I use ODL / OQL on Oracle ?

Platform: Oracle 9iR2
For the following, please don't tell me to 'change my design' - I just
want to know whether there is a way of coding the select such that it
won't return an error.....

DB version:9.2.0.4
OS: Linux
i am truncating a table but it hangs for a long time.
sid=40(for example)

We have a unique opportunity to compare Linux with Windows running an
Oracle 9.2 server. We have setup two 100% identical servers DL380 G4:
one with windows 2000 adv server and the other with RedHat 3.4. Both
are running the same applications in parallele.

I get the following errors when I call a stored procedure as SYS
Note the version Of Oracle is:
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option

Hello people!
I need to export our production Oracle database (8.1.7.4) on AIX (5.2)
and import it into our preproduction environment. This is the statement
I am planning to use for the export:

This might be a silly question of experience oracle developers but..
I want to know the the CPU speed and the amount of RAM become an issue
for SQL queries.
For example when we run a query which has to do a lot of sorting and if

Just installed Oracle 10.1.0.2 on my laptop, using WINXP.
Installation appeared to be very clean.  In Oracle 9i there was a utility
called Migration Workbench.  Can's seem to find it in Oracle 10, or any
reference to it in the docs.  Does version 10 call it something else, and if

someone know as possible force refresh of MV by script?
I want to refresh when my trigger is on fire.
Thanks
Alen