I have form with one data block. It shows all records from database table. I
want to let user filter these data. Does anyone know how to do that?
I was searching in google and news groups but I hadn't found any tips or
tutorials.

We have a 10.1.0.3 database that is used as RMAN catalog for a whole
bunch of 9.2.0.x and 10.1.0.x databases.
Lets say i have a 9.2.0.4 database that i have just upgraded to
10.1.0.3.  I understand that I need to run "upgrade catalog" in RMAN

Hi, I have Oracle 9i, IAS 9.0.4, and I use Web PL/SQL. I have a only
connect user from database and a role with permissions to object
access.
For users accessing I can't use default roles (except connect) and I

I a using 10.1.0.4 on HUP UNIX 11i.
In Oracle 10G, Oracle added a new init.ora parameter db_unique_name. I
have read its documentation, but I am still not clear its role in Data
Guard as well as in  RMAN backup/recovery.

My application needs to upload some thousands of records into a
database. Each record insertion involves some validation process and
more than one insert operation into the database. Each record is
independent of each other so if one insertion fails, process can go on

we encountered a strange behaviour or miracle with Oracle 8.1.7 under
AIX 5.2
We got an corrupted datafile (this was not the miracle):
ORA-01578: ORACLE data block corrupted (file # 3, block # 89918)

It seems the datafile resize action actually slow down/block
transactions, if those transactions are hitting the file being resized.
Could someone tell me the details mechanism behind datafile resize
process?

As I know, Automatic Segment-Space management can not be used for
tablespaces witch will contain LOBs.
This is what I've done and I got something else:
C:\Documents and Settings\Administrator>sqlplus "sys@testDb as sysdba"

is possible to use a member procedure of a object like a TRIGGER for the
Object Table ?? for example:
CREATE OR REPLACE TYPE Perc_obj AS OBJECT
(

Could anyone describe me about difference between utlxplp.sql and
utlxpls.sql scripts.
Thanks in Advance,
Rajkumar.K

My database is Oracle 9.2 on Window 2000 Server.  I am trying to use
RMAN to backup a database to a disk on another server.  The disk is
mounted using window's Net Use command.  But somehow I receive error
message about failing to create the Backup files.  I need to do so as

I was hoping someone might be able to help me with this one:
  I tried to:
    alter table "sapr3"."b0000153001" modify partition
"SAPR3"."/BIC/B00001530010000000003" storage ( next 20480k);

Welcome to Jurassic Park!
Oracle released so called "Project Raptor"  which is a Java version of an
intuitive, graphic SQL IDE. It looks extremely good and is surprisingly
fast. Check it up on:

I just downloaded the Oracle 9i 64-bit version (filenames:
92021Win64_Disk1.zip and 92021Win64_Disk2.zip) and when I extract both
of these files, and attempt to run the setup program, I get the the
error message saying:

During Oracle 10g AS Infrastructure installation we got this error when the
installer was creating Metadata Repository in a new db:
ORA-01503 Create control file failed.
ORA-01219 database not open: queries allowed on fixed tables/views only