Home » RDBMS Server » Server Administration » UNIQUE row in SYS.AUD$
UNIQUE row in SYS.AUD$ [message #204501] Tue, 21 November 2006 00:47 Go to next message
suvv
Messages: 17
Registered: October 2006
Junior Member
hi Gurus,

What column or combination of columns in SYS.AUD$ define a UNIQUE row in the
table.

Some one told me
"the combination of sessionid and timestamp# is guaranteed to be unique."

I do not believe this an accurate or true statement.

I've just performed the following:

select count(*)
from sys.aud$;

124299


select sessionid, timestamp#, count(*)
from sys.aud$
group by sessionid, timestamp#
having count(*) > 1;

20407 rows returned

Based on these results, "sessionid and timestamp# is guaranteed to be unique"
appears to be an untrue.
Re: UNIQUE row in SYS.AUD$ [message #204527 is a reply to message #204501] Tue, 21 November 2006 03:07 Go to previous message
suvv
Messages: 17
Registered: October 2006
Junior Member
For our business requirement we are to attempting to 'link' to this table,for that we must know what combination uniquely identifies a row in SYS.AUD$(9.2.0.7).
Previous Topic: Create Database - Error
Next Topic: deleted backupset
Goto Forum:
  


Current Time: Sat Dec 03 22:35:31 CST 2016

Total time taken to generate the page: 0.14676 seconds