oracle 修改用户和表的默认表空间
ALTER USER TEST DEFAULT TABLESPACE TEST_DATA;
ALTER USER TEST TEMPORARY TABLESPACE TEST_TMP;
SELECT * FROM DBA_USERS A WHERE A.USERNAME='TEST';
SELECT 'ALTER TABLE '||OWNER||'.'|| TABLE_NAME ||' MOVE TABLESPACE TEST_DATA;' FROM DBA_TABLES WHERE OWNER='TEST';