File Striping across disks - Exercise

This exercise is worth a total of 10 points. To receive full credit, you must correctly write the CTAS syntax required by the scenario below. Once you complete your answer, submit your answer.

You must take a very large order table and move it into a new tablespace, making sure that it is evenly striped across 5 physical disks. A new tablespace must be created and the CTAS syntax written to copy the order table into its new home.

You must give the create tablespace syntax and formulate a CTAS command that will copy the order table into its new home while splitting the customer table into 100 megabyte chunks.

Create table new_order
Tablespace new_order_tablespace
As
Select * from order
Storage (????);