创建用户&＃xff1a; create user demo001 identified by demo001;
创建表空间&＃xff1a;
create tablespace data001 datefile &＃39;D:\share\02-Oracle\data001.dbf&＃39; size 100m;
将表空间分配给用户&＃xff1a;
alter user demo001 default tablespace data001;
给用户授权&＃xff1a;
grant create session,create table,unlimited tablespace to demo001;
以demo001登陆建立表tt_test&＃xff1a;
create table tt_test(id number(10));
京公网安备 11010802041100号