常用操作
新建表空间及用户
create temporary tablespace aibs_temp
tempfile '/u02/oradata/temp/aibs_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create tablespace aibs
logging
datafile '/u02/oradata/aibs.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user abs identified by abs
default tablespace aibs
temporary tablespace aibs_temp;
grant connect,resource,dba to abs;
修改表空间自动扩展
select * from dba_data_files where tablespace_name = 'aibs';
alter database datafile '/u02/oradata/aibs.dbf' autoextend on;
修改表的空间
alter table TABLE_NAME move tablespace TABLESPACENAME
查询当前用户下的所有表
select 'alter table '|| table_name ||' move tablespace tablespacename;' from user_tables;
修改表的索引的空间
alter index INDEX_NAME rebuild tablespace TABLESPACENAME
查询当前用户下的所有索引
select 'alter index '|| index_name ||' rebuild tablespace tablespacename;' from user_indexes;