I´m currently thinking about how to make use of a NetApp NAS Filer
with Oracle EE 10r2 in a non-RAC environment. I see two ways for
connecting it and several ways to make use of it.
Connecting:

Using 9.2.0.4
=============
SQL> create table t as select * from dba_objects;
Table created.

Are there any known "show-stopper" issues to running 8i and 10g
databases concurrently on the same AIX server? Both would be 64-bit
versions on AIX 5.3L.

I'm doing some development work in Oracle Personal, under the Trial
license.
Now, I think I'm far enough along, and committed, that I want to buy.
I went to Oracle's site and saw that a one year license is $80US, but I

I am trying to break a long running query by hitting ctrl+c.
It works fine giving me a ora-1013.
I am using a long running insert (inserting about 100000 records)
before I hit ctrl + c. I do this just to make sure I have enough

Dear group readers,
at first the system:
Database: Oracle 10g (10.1.0.4)
2-Processor machine HP/UX 11.11 64 bit

I have been attempting to created a materialized view that I need to
refresh when 1 of the underlying tables is updated. The view is as
follows:
CREATE MATERIALIZED VIEW DAT_V_QUERIES

I would like to do an Oracle Patch on a 9i database on linux.  To minimize
the downtime, I first take a hot backup of database.  Now I need to take a
backup of Oracle_HOME.
Do I have to shutdown the database to do that?

I'm new to using Oracle. I've got 3 servers each setup identically
running win 2000 professional and I'm trying to install Oracle 8i
Client Software on each of them. However I'm having difficulty actually
installing them when the cd is inserted it autoplays but when the

I run 9i on unix aix with NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1. I
generated data for use with SQL Loader from access database using oracle
workbench migration. The .dat files looks good on windows but when I
transfer them to unix host using ftp there are junk characters. This ...

when I try to connect to an Oracle 9.2 database using the Oracle 10g R1
JDBC thin driver, everything is working fine, but when I use the Oracle
10g R2 (thin) driver I get the following error:
ORA-00604: error occurred at recursive SQL level 1

If anyone's interested, I've just released a new scripting language with
Oracle integration - makes it really easy to manipulate data from Oracle
databases.
the language is called qore and has been released under an LGPL license...

I want to check what "component" and "version" is installed on a
particular instance.  I use dba_registry in 9i but it's not available
in 8i.  I tried v$version on 8i it does show version but doesn't show
any component like JAVAVM, XML etc.  Anyone can help?  Thanks.

PL/SQL: ORA-00920: invalid relational operator" Error ---  :confused:
Please Tell me if you can resolve this "PL/SQL: ORA-00920: invali
relational operator" Error in the :- code :-
DECLARE

What is the difference in following two approaches -
1) Two databases having separate oracle instance (hence separate
schema) on the same Solaris machine
2) Two databases sharing an instance but having separate schema on a