Databases Reference
In-Depth Information
As always, be careful when executing
NOLOGGING
operations. To avoid possible data loss, plan this
operation with the database backup administrators.
In step 4, we have queried the status of indexes on the moved table. As seen in the following
screenshot, all the indexes on the
CUSTOMERS
table are showing the
UNUSABLE
status, so
they need to be rebuilt:
In step 5, we rebuild the indexes, obtaining the following output:
From step 6 onwards, we follow a different strategy—adding a data file to an existing
tablespace and storing it on a different disk. In step 6, we add the new data file to the
EXAMPLE
tablespace.
In step 7, we allocate an extent for the
COUNTRIES
table of the
SH
schema, on the newly
created data file. From now onwards, the data in the
COUNTRIES
table will be stored on a
different disk.