I know this was discussed recently, but I am still uncertain and would very
much appreciate an answer.
I have a vendor that needed a db created for his product.  I created an
instance on 9i (Solaris) and gave him the sys and system passwords.  From

Does anybody know what Oracle error 15500 is? It appears to be
undocumented but we have a customer running an Oracle database saying
that this error has been returned to the application. Can anybody help
please?

We run an Oracle database Version 8.1.7.2.0 on a unix machine.
For some jobs to run we use DBMS_JOBS.SUBMIT ...
Now sometimes, special for short running programs, it will be started a
second time,

I'm struggling with trying to get OEM to work in a clustered
environment.
I have 2 oracle servers running under Veritas Cluster Server.  I've
managed to get the Intelligent Agent binding to the virtual IP address

Does anyone know how expensive it is (what additional work needs to be
done by Oracle) if you add compute statistics in the 'create index'
call? I'm sure it's less than a separate analyze, just wondering how
much of the index creation it can leverage to gather the stats.

in MS SQL Server we have a command DBCC SHRINKFILE ( myDB,
truncateonly) which causes any unused space in the data files to be
released to the operating system and shrinks the file to the last
allocated extent, reducing the file size without moving any data.

I did an installation of Oracle 10gR2 database Enterprise Edition on
Windows XP.  This is really the first time I play around 10g.  So I
installed all components including "Oracle Enterprise Manager Console
DB".  However, I can't find the Enterprise Manager console in the

I have 2 sql statements S1 and S2.  S1 never actually finishes at least
it exceeds our time slot so I never wiat for it to finish which is 30
minutes.  S2 runs in under a second usually in the area of .2 ish.  So
the problem has been overcome but I was wondering why.  Why was it a

Could anyone tell me whether you have to install the complete Client (ver
9.2) in order to install the driver
I have an application that only requires the Oracle driver to communicate by
spreadsheet add-in

I am new to databases and today is the first that I'm working with
ORACLE.
I am switching for MySQL to ORACLE and trying to decide which template
to use for my DB.

How many times have you seen a subject like that :)
If I want to remove all superfluous spaces from a string, can I do it in
one statement?
e.g. if to convert

I have index on varchar2 column. NLS_SORT is set as Polish and NLS_COMP
is ANSI. But characters like '.', '?', '-' are not indexed (it seems
that only digits, letters and space are indexed). How can I make server
to index those characters? Server is 0racle 10.2.0.

Two questions(9iR2):
what become the SQL in the shared pool when user
logoff, does it stay in and
can be reused by other session, or does it is

This one works...
FROM From.Timelog, From.Cmo_Worker WHERE ( Timelog.Case_Manager (+)=
Cmo_Worker.Portalid )
but I needed the opposite joins..so I did...

Oracle XE is a smaller version of Oracle 10g Database. Basically
designed as a database for embedded systems and for ISVs (Independent
Software Vendors). Its 100% FREE to download and distribute.
Oracle XE support single Instance with database size upto 4GB. Can