I have been scouring the web on RAC docs like most when trying to learn
this.  On a LINUX RH Enterprise 4 (or CentOS 4) system can I create a
RAC test environment on one system, in other  words, two instances on
the same box using the same database?

One thing we'd like to do during an upgrade is reduce the scale and
precision of a couple columns. There are 2 tables that make up 90% of the
data, both of which have a column of number (12,7), which is much greater
than required. If I precreate these tables with a column of ...

Greetings;
I am installing Oracle 10g on a Windows XP that will be my database
server - not as a local instance but so I can access the database from
my development machine over the LAN.  I am not using a DNS for the LAN,

I have a little database problem, and I can't figure out if there's
a solution in Oracle:
I have a database of articles:
ident        number

I've implemented a basic security policy: all tables of schema SSSS
contain
an AREA column numbered from 1 to 19. The app logins are of the form
ASSS_01,

Is a ref cursor in a stored procedure the only way to return a record
set in Oracle 9i/10g?
In SQL Server you can simply put "select * from table" in a stored proc
and you are good to go.  It appears that in Oracle you cannot do this.

Can anyone point to a useful resource on tuning IO for Oracle on
Windows?
I've never dealt with Oracle on Windows before, but someone asked to
help them out with IO performance problems (they can get the dell

I will be upgrading an 8i database to 10gR2 soon. The documentation says
you must be at 8.1.7.4 to directly upgrade to 10gR2, but I'm planning an
export/import, which should eliminate that requirement. I see they don't
"officially" support even that, but it seems that they just ...

Did Mr. Adams get hit by the proverbial beer truck or is he just incredibly
busy? I've been trying to get posting rights on Oracle-l for a few weeks
now. Zero response.

i am new to oracle and this group. i am trying to install oracle on
SLES 9 + FP3. I have 64 bit hardware at home and i have home network
through router which allows us to share internet. how can i install
oracle in this setup. i am not sure if i can assign static IP to linux

I've been an Oracle Developer for the last four years or so, developing
against an 8i database in PL/SQL and Forms & Reports 6i.  My current
employer wants to move our product to a 9i database with a 10g front end.
As well as doing this, there is a need for me to learn to administer ...

Is there any other way to get Oracle Patches (Oracle 9i) appart from
metalink ?
Is there any Sample Patch with Oracle installables or ORACLE_HOME ??
Thanks

Hey All,
This place is finally taking the step to go to 10g.  I'm trying to find
a page on Oracle's site which has a list of some of the new features,
along with some of the changed or desupported features from 9i.......

My customer use an application write in C++ with
OCCI interface for oracle
access, they use a connection pool of four
connections and before each sql request

After adding several audit policies using dbms_fga.add_policy(), how do
I then simply look at all the policies made for the entire instance or
particular object?
I am using 9.2.0.6.