Oracle 创建表空间

--解锁被锁定的scott用户，用sys用户登录
alter user scott account unlock;
commit;
    
    
--创建永久表空间
create tablespace "azhe_tbs" 
datafile 'd:\oracle\product\10.2.0\oradata\orcl\azhe_tbs.dbf' 
size 1024m 
autoextend on next 512m
maxsize 10240m  
extent management local;  
--创建临时表空间
create temporary tablespace "azhe_temp_tbs"
tempfile  'c:\azhe_temp_tbs.dbf'
size 1024m
autoextend on next 512m
maxsize 10240m  
extent management local;  
--查看表空间名称、id，文件存储位置,初始大小
select tablespace_name,file_id,file_name,bytes
from dba_data_files
order by file_id;
select tablespace_name,file_id,file_name,autoextensible,
round(bytes/1024/1024/1024,3) "used(G)",round(maxbytes/1024/1024/1024,3) "size(G)" 
from dba_data_files order by file_id;
--修改表空间大小
alter database
datafile 'd:\oracle\product\10.2.0\oradata\orcl\azhe_tbs.dbf' 
resize 512m;
--修改表空间大小:增加数据文件
alter tablespace "azhe_tbs"
add datafile 'd:\oracle\product\10.2.0\oradata\orcl\azhe_tbs2.dbf' 
size 512M;
--删除表空间
drop tablespace "azhe_tbs";
--创建用户
create user azhe identified by azhe
default tablespace "azhe_tbs"
temporary tablespace "azhe_temp_tbs";
--授权，grant dba to username; 这种是赋系统管理员的权限
grant connect,resource,dba to azhe;