创建表空间:
create tablespace hr6_Data datafile
'+DATA' size 5000M REUSE
autoextend on next 10M MAXSIZE Unlimited
extent management local autoallocate
permanent
online;
创建临时表空间:
create temporary tablespace hr6_TempData tempfile
'+DATA' size 200M REUSE
autoextend on next 10M MAXSIZE Unlimited
extent management local uniform size 256K;
查看表空间情况:
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
创建用户:
SQL> create user wmwhse6 profile SCEUSER identified by "XXXX"
default tablespace wmwhse6_Data temporary tablespace wmwhse6_TempData;
create tablespace hr6_Data datafile
'+DATA' size 5000M REUSE
autoextend on next 10M MAXSIZE Unlimited
extent management local autoallocate
permanent
online;
创建临时表空间:
create temporary tablespace hr6_TempData tempfile
'+DATA' size 200M REUSE
autoextend on next 10M MAXSIZE Unlimited
extent management local uniform size 256K;
查看表空间情况:
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
创建用户:
SQL> create user wmwhse6 profile SCEUSER identified by "XXXX"
default tablespace wmwhse6_Data temporary tablespace wmwhse6_TempData;