Change Access Status
Go Up to Available object actions by DBMS
This action builds and submits a basic ALTER TABLE... READ ONLY/READ WRITE statement. This lets you toggle the table between READ ONLY and READ/WRITE modes.
Platform Availability
- ORCL 11g
To Change Between READ ONLY and READ WRITE Modes for a Table
- Initiate a Change Access Status action against one or more tables. For more information, see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the dialog:
Step | Settings and tasks | |
---|---|---|
Action options |
Select the Read-only check box to generate a ALTER TABLE... READ ONLY statement, putting the table into read-only mode. Deselect the Read-only check box to generate a ALTER TABLE... READ WRITE statement, putting the table into read-write mode. | |
Dependencies |
Lets you review the objects potentially impacted by this action. For more information, see Dependencies. | |
Preview |
Preview the DDL generated for the operation. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.