| How to protect object from ddl and dml commands [message #396271] |
Sun, 05 April 2009 23:52  |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
Hi Friends
I Wold like to know how can i protect my table from dml and ddl commands. To do that i was created one tablespace move that table to that perticular tablespace and then do that tablespace read only. however the tablespace readonly the table can drop. is there any way to protect object from dml and ddl command even owner cant do it.
Chintan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to protect object from ddl and dml commands [message #396323 is a reply to message #396289] |
Mon, 06 April 2009 02:18  |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
now i m facing one more problem is that before dropping my table i was query on dba_segments where tablespace='HISTORYDATA' it gives me belowe result
SEGMENT_NAME SEGMENT_TYPE
------------- ------------
RMSCL122005 TABLE
After droped this table the same query from dba_segments where tablespace_name='HOSTORYDATA'
it gives me below result
SEGMENT_NAME SEGMENT_TYPE
------------- ------------
16.6577 TEMPORARY
Actually i like to know the difference between two results.
however drop this table its occupy the diskspace or not.
Chintan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
