Does anyone know of a good wiki by and for Oracle DBAs?
The closest thing I know of is The Oracle (tm) Users' Co-Operative FAQ,
but that's not quite the same.  You have to be ready to produce the
entire, authoritative answer to a question, and produce it all at once,

I have a ticket system which need a random (act as a password) string
generated. But this string also act as a key (need to be unique).
The approach of the former dev does not suites me.
He was generating a random string, doing a select key where key = ... To

Our application uses a dblink to connect to a different database
(Oracle 9i). We have been facing issues with the dblink going down due
to firewall/networking issues. Hence I am trying to include a
functionality of checking if the dblink is working fine.

Hi SQL Gurus,
I have a simple looking update criterion where I need to update a
column of a table depending on its rownum given a particular order by
clause.

What is the standard way in Oracle to have an autoincrementing integer type
primary key data type? Does Oracle offer a built-in data type for this? Or
should I use triggers?

Oracle 9iR2 Enterprise edition on Tru64 5.1B
We currently have a database application that creates RTF-documents on
an UNIX-directory. For Windows-clients to read those documents, we have
to transfer these files, either by ftp or, as I currently do, by HTTP

While I run following scripts
--------------------------------------------------------
Declare
  myFile         sys.utl_file.File_type;

First of all I have to say that I completely new to Oracle so this is a
"noob" question.
I cannot get logged onto my newly created database. When I open SQL*Plus I
am presented with a login box saying User Name, Password and Host String.

I have a SQL script that creates tables, sequences, indices and even
inserts some data.  Typically it is run by copy/paste into TOAD.  A need
has arisen to create a few triggers.  If I put the trigger code in this
script, all code following the trigger gets interpretted as being ...

sorry to bug you, but I've got a (hopefully) simple question:
We have a client in South-Korea running an Oracle Database. They are
using Oracle 8 on some sort of Unix (I guess it's Linux), and they are
using a characterset KO16KSC5601

I'm trying to solve an update, and simply can't find a way. It updates
1 table, that has a 3 column PK. See it here:
update
( select

I have a problem when trying to duplicate a database using rman. Ora
8.1.7.4 on Win2000.
- took a full backup of the original database (noarchivelog)
- create the new instance with oradim

Where can I found information about Oracle User
The user is "scot" - logedin to NT domain
User send sql query to Oracle server
Wher in Oracle server can I found information thet user "scot" send query to

How can I avoid ORA-12899, value too large for column error? I have a
database and program which are not made by me. I have sources, so I
could make changes, but I will not if it can be avoided. The program
reads a file and stores it to the database. Reading a file can take

I have a table with 2 columns(varchar)  end_time & start_time.
I have to write a query to find the correct diffrence of end_time &
start_time
eg.