is it possible to enable disable/enable all triggers and foreign key
constrainst defined on a table.
I've tried:
 alter table BLA disable all trigger.

hi friends,
i am working as DBA.i started a new group called "innovative_dba" in
yahoo groups.
this is for people who wann to get good job n also who r facing probs

Everything in this book is covered in a step by step manner by first
building reader's concept using analogies, real world examples and
then taking him/her to the steps of design implementation. The examples
are based on MS Access 2003 and Oracle 9i/10g but the concepts are

dn: cn=testuser,cn=Users,dc=mycompany,dc=com
userpassword: testuser123
objectclass: top
objectclass: person

Is it possible to get the index utilisation ratio for the oracle
instance (9i) ?
Thanks

hi friends,
i am working as DBA.i started a new group called "innovative_dba" in
yahoo groups.
this is for people who wann to get good job n also who r facing probs

Dear HP-UX sysadmins,
Has anyone experienced Oracle IAS connection dropping unexpectingly?
Our customer works with a 'complicated' environment:
PC <-> Citrix-farm <-> HP9000 (HP-UX 11.x) with Oracle IAS <-> HP9000

can you call a procedure from trigger in Pl/Sql

Anybody actually get Oracle Enterprise manager to go to work on any
PDA?
Specifically a blackberry... but any PDA would be nice.
We infer that the link is the same as the regular EM link but then just

I have installed 10g with the default options and the hard drive is now
continually chugging away in my ear even when no database transactions are
active - which is getting on my nerves.
I had set the DB up previously and I had turned off rollback segments or

Can any body give silution to restrict the no. of rows returned by
select query in oracle
like "Set rowcount" In SQL server

I did a new 10g R2 install, and created a database using OMF.
When I attempt to use OEM to create a new tablespace, I get an error
message, unless I supply a datafile name.  Perhaps I am
misunderstanding OMF, but I thought that datafiles would be created

Dan:
I figured this question might be of generic-enough interest to include
as a group post rather than a private email.
I'm in the process of attempting to register for the upcoming RAC

I am getting the following error when i try to run the installer for
Oracle 9i
i am installing in on Suse 10
Initializing Java Virtual Machine from

We have recently moved our RMAN hot backups to Data Protector. The hot
backups are working successfully. Restoring works fine. Cloning a
database from one instance to another -- on the same host -- works
fine. I'm using an RMAN script with the appropriate Data Protector