创建表空间、用户

SQL>  select 'create tablespace '||tablespace_name||' datafile '||''''||file_name||''''||' size ' ||TRUNC(bytes/1024/2024)||'M;' from dba_data_files;

'CREATETABLESPACE'||TABLESPACE_NAME||'DATAFILE'||''''||FILE_NAME||''''||'SIZE'||TRUNC(BYTES/1024/2024)||'M'
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
create tablespace USERS datafile 'E:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF' size 104M;

SQL> select 'create user ' ||username||' identified by xxx ' ||' default_tablespace '||default_tablespace ||';' from dba_users;

'CREATEUSER'||USERNAME||'IDENTIFIED BY  XXX'||'DEFAULT_TABLESPACE'||DEFAULT_TABLESPACE
---------------------------------------------------------------------------------------------------------------
create user SYS identified by xxx  default_tablespace SYSTEM;
create user SYSTEM identified by xxx  default_tablespace SYSTEM;