Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
SELECT tablespace_name
FROM dba_tablespaces
WHERE contents ='TEMPORARY';CREATEUSER psoug1
IDENTIFIED BY password123
DEFAULTTABLE data
TEMPORARY TABLESPACE temp;SELECT username, default_tablespace, temporary_tablespace
FROM dba_users
ORDERBY1;