| UNIQUE row in SYS.AUD$ [message #204501] |
Tue, 21 November 2006 00:47  |
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  |
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
