def index_tspace = USERS

CREATE TABLE customers
( cus_id NUMBER(10) CONSTRAINT cus_pk PRIMARY KEY USING INDEX TABLESPACE &&index_tspace
, cus_name VARCHAR2(45) NOT NULL CONSTRAINT cus_uk UNIQUE USING INDEX TABLESPACE &&index_tspace )
/

CREATE TABLE orders
( ord_id NUMBER(10) CONSTRAINT ord_pk PRIMARY KEY USING INDEX TABLESPACE &&index_tspace
, ord_cus_id CONSTRAINT ord_cus_fk REFERENCES customers ON DELETE CASCADE
, ord_date DATE DEFAULT SYSDATE NOT NULL )
/

Moveall.sql
set echo off

column order_col1 noprint
column order_col2 noprint

set heading off
set verify off
set feedback off
set echo off

spool tmp.sql

select decode( segment_type, 'TABLE', 
                       segment_name, table_name ) order_col1,
       decode( segment_type, 'TABLE', 1, 2 ) order_col2,
      'alter ' || segment_type || ' ' || segment_name ||
      decode( segment_type, 'TABLE', ' move ', ' rebuild ' ) || 
      chr(10) ||
      ' tablespace &1 ' || chr(10) ||
      ' storage ( initial ' || initial_extent || ' next ' || 
        next_extent || chr(10) ||
      ' minextents ' || min_extents || ' maxextents ' || 
        max_extents || chr(10) ||
      ' pctincrease ' || pct_increase || ' freelists ' || 
        freelists || ');'
  from user_segments, 
       (select table_name, index_name from user_indexes )
 where segment_type in ( 'TABLE', 'INDEX' )
   and segment_name = index_name (+)
 order by 1, 2
/

spool off

set heading on
set verify on
set feedback on
set echo on

REM UNCOMMENT TO AUTO RUN the generated commands
REM ELSE edit tmp.sql, modify as needed and run it
REM @tmp

 --- eof ----