Question: A DBA wants to convert a segmented table space into a partition - by - growth table space. The DBA executes the following ALTER statement:

A DBA wants to convert a segmented table space into a partition-by-growth table space. The DBA executes the following ALTER statement:
ALTER TABLESPACE DB1.TS1 MAXPARTITIONS 5;
What is the next step the DBA should take to complete the process?
Question 19Select one:
A.
REBUILD all of the indexes on the table space
B.
Drop the segmented table space
C.
REORG the table space
D.
COPY the table space

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!