1、创建用户
create user ljdb identified by ljdb;
2、创建表空间和设置文件路径
Create tablespace ljdb datafile 'd:\ORA_DATABASE\ljdb.dbf' size 10m;
alter database datafile 'd:\ORA_DATABASE\ljdb.dbf' autoextend on;
3、将表空间分配给用户
alter user ljdb default tablespace ljdb;
4、授权
grant create session,create table,unlimited tablespace,dba to ljdb;
--设置自动扩展
alter database datafile 'D:\app\Administrator\oradata\RWDB\RWDB.DBF' autoextend off;
--查询自动扩展
select a.FILE_NAME,a.AUTOEXTENSIBLE,a.MAXBYTES,a.INCREMENT_BY from dba_data_files a;
--修改表空间大小
alter database datafile 'D:\app\Administrator\oradata\RWDB\RWDB.DBF' resize 20000M;