oracle数据库表空间操作

oracle数据库表空间操作

/*

*新建表空间语句

*/

 

create tablespace myspace 

file 'd:\oracle\data\mydata01.dbf'

size 300M

autoextend on

next 30M

extent management local;

 

create temporary tablespace mytemp

file 'd:\oracle\data\temp01.dbf'

size 200M

autoextend on

next 20M

extent management local;

 

/*

*更改默认表空间

*/

 

alter user xq default tablespace myspace;

 

alter user xq temporary tablespace mytemp;

 

/*

*修改表空间

*/

 

alter tablespace xqspace add datafile 'd:\oracle\data\myspace01.dbf';  --为表空间添加数据文件

alter tablespace xqspace drop datafile 'd:\oracle\data\myspace01.dbf';  --为表空间删除数据文件

 

 

 

/*

*查看用户表空间情况

*/

 

select * from user_users;

select username,default_tablespace,temporary_tablespace from user_users;

 

select * from user_tablespaces;

select * from dba_tablespaces;

select * from dba_data_files;