" While in the test machines without RM COBOL, the error is simple, i.e.
"Object does not exist" We came to know this when at one machine, when we
dropped one table, it started dropping all tables one bye one. Same happened
in another machine."
When you say: you dropped one table then Oracle starts dropping all
tables...!!!? how..
Check that there NO TRIGGER created which has AFTER DROP ON SCHEMA ...
Chech recent created trigger by date...very strange !!!
select created, last_ddl_time, object_name, owner from all_objects where
object_type='TRIGGER' order by 1 desc;
Regis
-----Original Message-----
From: The Champ [mailto:[Email Address Removed]
Sent: 31 March 2004 14:06
To: LazyDBA.com Discussion
Subject: Immediate help required!!!
I'm facing a terrible situation, which is turning into a crisis.
Our environment is Oracle 8.1.7 running on Linux 7.2. The Oracle had been
running very smoothly in each Server.
Now, for ATM operations, we had to install RM Cobol 7.5 and the operations
still continued running smoothly.
Now, on almost every machine , we are facing a very strange error:
If we drop any table, and then try to describe it , we get the error :
"Segmentation fault".
While in the test machines without RM COBOL, the error is simple, i.e.
"Object does not exist" We came to know this when at one machine, when we
dropped one table, it started dropping all tables one bye one. Same happened
in another machine.
The ALERT files and the TRACE files do not show anything new... Every thing
looks normal.
Can someone plz tell me ASAP wuts going on..? Is it due to the installation
of RM cobol??
_________________________________________________________________
Check out MSN PC Safety & Security to help ensure your PC is protected and
safe. http://specials.msn.com/msn/security.asp
--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************
Oracle LazyDBA home page