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';