I'm not quite getting it. It compiles with errors, and won't run.
It contains nested cursors, with the inner one (cursor2) using values from
the outer one (cursor1).  Probably the cursor2 should be declared outside
the first FOR...LOOP?

I have a table with 4e9 rows, size about 80 bytes/row, partitioned by
time slices (daily), each slice containing about 10e6 rows.  One column
has a local bitmap index.  There are typically 10-1000 rows matching a
given column value in each partition.

I really only need the bare minimum - but I need to find out what that is.
I'm creating a couple of apps (VB/Windows) that can hit databases - but I'd
like them to be able to hit Oracle DBs, but I don't have the slightest idea
on what the minimum stuff I need - - like drivers - a ...

I need a script to perform a clean oracle shutdown every time that windows
going to shutdown.I need this to be sure that there wont be  any instance
recovery every time I startup the oracle(Mostly I fear from header
inconsistency and ...).

I have a few questions about the two-phase commit protocol in action -
specifically, design help/pointers for how to respond to failure. If
you have any URLs with relevant design/technical help, they'd also be
appreciated...

I am about to waste an entire weekend going through kernel parameters
with a fine toothcombe, Solaris patch levels, reinstalling Oracle 9.2
on a Blade 1000 with 2Gb RAM running Solaris 2.8, etc, etc.
However before I do this can anyone tell me why the following occurs?

I need to increase the tablespace size for SYSTEM/TEMP and user defined
tablesspaces. I have 2 options
1) Adding one more datafile to tablespace with ALTER TABLESPACE command
2) Increasing size of existing database file size with ALTER DATABASE

Get lots of crazy erros on server reboot. Running 9.0.2, this is a
backend for a mission critical spatial database. Unfortunately, there
is no budget for a bona fide DBMS admin....
I'm kinda desparate here, we have rough backups of the raw data, but

My Oracle database version is 9.2.0.1.0 on windows 2003 server. I am
facing performance issue when user logs in to the application or any
write operation in oracle database. The avg disc queue write length on
windows server goes very high and it takes few minutes to login into

I'm playing around with tunneling sqlnet over ssh. I set up a tunnel on
the client that forwards port 9521 to 1521 on the database server and
can connect to the listener on local port 9521. I also know that once
the connection is established by the listener, the connection gets

I did most of my work on Oracle 8i using rollback segments.  I just
took a new job where they didn't have a DBA before and are using Oracle
9i and 10g.  They have Undo tablespaces instead of rollback segments.
Does undo tablespaces work like rollback segements?  Can someone point

I'm trying to create a materialized view with with query rewrite but
this fails. (Oracle 9.2, enterprise edition)
CREATE MATERIALIZED VIEW my_matview
 ENABLE QUERY REWRITE

I currently confused.
My test database (9.2.0.1 on XP-PRO) stopped suddenly running with ORA12560.
I tried to create a new database, but this did not help. Same error during
the installation.

I've checked the docs, but the only limitation I can find about
FKs is related to clustering.
From the SQL Syntax doc, I figured the below should be possible:
alter table scott.child

I am currently working on a program on AIX.
Before, I include the Pro*C libraries, the size of my
program is only about 100KB. However, after I include
database access codes, the program grew to 12MB.