Home » SQL & PL/SQL » SQL & PL/SQL » User Errors (oracle 8i , windows 200 server)
User Errors [message #292854] Thu, 10 January 2008 01:10 Go to next message
jagadeeshg
Messages: 14
Registered: December 2007
Location: BLR
Junior Member

Dear All

I have a problem. One process which ran 2 days before created 2 records due to system errors( might be like locked table or locked record in other tables) in that. I can rectify this bug of creating records by imposing constraints or through triggers. I want to know which system error caused. is there any way to find system errors in database by means of v$tables or system tables.

Thank in advance

with regards

Jagadeesh



Re: User Errors [message #292867 is a reply to message #292854] Thu, 10 January 2008 01:34 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Title is "user error" then you talked about "system error", which one is it?

Quote:

One process which ran 2 days before created 2 records due to system errors

System errors does not create rows, only application/user ones.

Quote:

is there any way to find system errors in database by means of v$tables or system tables.

There is no table for system errors.

Regards
Michel
Previous Topic: Date manipulation
Next Topic: SQL Query Help
Goto Forum:
  


Current Time: Thu Dec 08 04:19:53 CST 2016

Total time taken to generate the page: 0.07415 seconds