Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Tablespace READ-ONLY - permit dropping objects
On a read-only tablespace, tables can be dropped and purged. There should be a better status, for my understanding when something is in read-only mode, every actions should be permitted.
Regards, Martin
Comments
-
Can you clarify :
>en something is in read-only mode, every actions should be permitted.
It seems to me that you do NOT want to permit DROP commands.
Hemant K Chitale
-
Can you clarify :
>en something is in read-only mode, every actions should be permitted.
It seems to me that you do NOT want to permit DROP commands.
Hemant K Chitale
I would vote up if this was about to FORBID dropping objects in a read only TBS. Can't test what is currently possible however.
@martin.berger please clarify. Is it maybe a translation error? Permit = Allow = Erlauben (German)
-
I would vote up if this was about to FORBID dropping objects in a read only TBS. Can't test what is currently possible however.
@martin.berger please clarify. Is it maybe a translation error? Permit = Allow = Erlauben (German)
It is currently possible to drop objects in a Read-Only Tablespace.
I assume that this request is to disallow DROP if the Tablespace is Read-Only.
Hemant K Chitale
-
Hi what do you mean by "every actions should be permitted". Does this mean you want to perform all the activities on read only tablespace? then what is the significance of "read only" status ?
