Database Reference
In-Depth Information
Figure 9-8: Add a data file to already existing tablespace.
To add a Datafile to already existing tablespace, first select that
tablespace as shown in the Figure 9-6 and then from the drop
down menu select the Add Datafile option and finally click the
“Go” button. Once done, you will be on Add Datafile page as
shown in Figure 9-8. Moreover, you can change the state of a
tablespace from Read Write to Read Only or Offline using the
Edit button as shown in Figure 9-7.
Selecting “Make Locally Managed” item from the drop down list
as shown in Figure 9-7 helps you to make your tablespace
locally managed in case it is dictionary managed (before Oracle
9i versions). All locally managed tablespaces' storage is
managed by Oracle Instance automatically at the extent and
block level.
Search WWH ::
Custom Search