–2、查看表空间物理文件的名称及大小
SELECT tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;
CREATE TEMPORARY TABLESPACE DB_TEMP
TEMPFILE ‘/home/oracle/db/oradata/sid2/user_temp01.dbf’
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE DB_DATA
LOGGING
DATAFILE ‘/home/oracle/db/oradata/sid2/user_data01.dbf’
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
CREATE USER user01 IDENTIFIED BY Qwer1012
ACCOUNT UNLOCK
DEFAULT TABLESPACE DB_DATA
TEMPORARY TABLESPACE DB_TEMP;
GRANT CONNECT,RESOURCE TO user01;
GRANT DBA TO NEWUSER;