oracle创建表空间并分配用户

create tablespace  hbly    logging datafile 'D:\oradata\kfdlwy\hbly.ora'   size 200m autoextend on next 200m maxsize 20480m extent management local;

create user hbly  identified byhbly  default tablespacehbly temporary tablespace temp;

grant connect,dba,resource,create session,create table,create view to   hbly;

修改表空间名称  ALTER TABLESPACE hnly RENAME TO hnly_149;

修改表空间让其自动增长 alter database datafile 'D:\oracleXE\oradata\XE\system_01.dbf' autoextend on;

删除表空间 DROP TABLESPACE SDE INCLUDING CONTENTS AND DATAFILES;

删除用户名 DROP USER SDE CASCADE

查看oracle用户：select username,created,password from dba_users