Does anybody out there have had these experience in performing such an
installation ... does anybody have a how-to ... or some hints ... ???
Please help me with this issue. || So many thanks in advance, looking
forward to hear from you guys .. !!

I'm not sure why this doesn't work:
insert into courses (CCode, Title, SCode)
select distinct CCode, Title, SCode
from TMPT05

I'm running 10.1.0.3 RAC Std Edition on Redhat 3.0 update 4 OS. After some
trial and error configs with ASM I finally got a test database running.
However, I had some failed attempts using dbca and when trying to recreate a
database with the same name, I got more errors. I've had ...

I'm using the ojdbc14.zip JDBC driver againts an oracle 10g database.
I'm getting one crazy result from a select.
select ...,nvl(attr,'') as attr, ...
from .... where ...

  Our oracle server crash but still i have all the required control
files and data files in my secondary storage can u please suggest how
to restore the database by them please mention the steps.

Good day.
What's the best way to see what sqlplus commands were executed in a
script output? I've tried ECHO ON and SET SERVEROUTPUT ON  in my POSIX
script, but neither show me the commands executed as they are

I tried to install Oracle server after downloading 10g_win32_db.zip.
I have a 2.4GHz processor and 256MB RAM and Windows XP.
There were problems after installation because PC was always writing disk
(not enough RAM I suppose).

Is there a way to do multi-variable regression on a Oracle table. I
want to  eliminate use of SPSS from one of my applications to run
regression on a table of almost 400,000 rows with 7 independent
variables. Any help would be greatly appreciated.

We now use RMAN to back up.  We will keep one full week on disk, and 2
weeks on tape.
I was searching the net for some commands to automate the cleanup of
the recovery catalog.

I have just install oracle 10g Enterprise Edition in winXp and my character
set on the db server is
SQL*Plus: Release 10.1.0.2.0 - Production on Sat May 7 07:12:17 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

 I am not able to get the return value of a PL-SQL block called from
within the shell script. Here is my block of code in shell script:
-----
typeset v_result_1=`sqlplus   -s  system/manager <<TT

I have responsibility for a database which I've inherited.  I've discovered
some peculiar settings for some storage parameters.  (An application
recently crashed because a very small table had the next_extent set to
1024MB, in a 500MB tablespace)

Good Day:
Product: Oracle Enterprise Manager for iAS  - Application Server
Control
Product Version:   10.1.2.0.0

We have an oracle 10g Installation of  a database calles backup.
I used for creation of the tablespaces the graphical interface of
enterprisemanager (web) because I have only webaccess to this server.
The database files look like this after running for a long time. Everything

I need to set up automatic load of data from files, would appreciate some
advice.
Lots of tools in the arsenal:
SQL*Plus