This content has been marked as final. Show 6 replies
Osama_mustafa wrote:No. user's do not "belong" to tablespaces. There is no relationship between users and tablespaces. Users are assigned a default tablespace, but that's all it is -- a default. To be used on segment creation when a TS is not explicitly specified.
why you want to do this , check this
Tables ----> belong -----> Schema ( User) -----> belong ----> tablespace .
Users can have objects in multiple tablespaces.
Tablespaces can have objects from multiple users.
Because of this Threshold should be on tablespace not Table :)
What is your intention? To find out who is doing it?
It would be easier to turn on the auditing for INSERT, UPDATE on this table because then you have an idea who/what is doing it as opposed to just knowing when the table size increased.
How to turn on DML auditing?
Plenty of information floating around - these are just some of the links:
Configuring and Administering Auditing