
366 13.3 Transportation Methods
Note: The CREATE TABLESPACE and DROP TABLESPACE statements
require CREATE TABLESPACE and DROP TABLESPACE system privi-
leges, respectively. Also, recreating the tablespace without deleting the data-
file from the operating system requires replacing the SIZE option with the
REUSE option.
CREATE TABLE trans TABLESPACE trans NOLOGGING AS
SELECT t.dte as transaction_date, o.dte as order_date
,lines.order_amount, lines.transaction_amount
,lines.product_quantity, lines.product_price
,lines.product_date, lines.product, lines.category
,cb.dte as payment_date, cb.text as payment_text
,cb.amount as payment_amount
,c.country, c.state, ...