(1)以SYS身份登陆
conn sys/sysem_pwd as sysdba;
(2)创建amly用户
create user amly identified by 9imly;
(3)创建表空间
create tablespace ts_amly datafile 'd:/amlyfile/test.dbf' size 100M;
(4)将表空间分配给用户
alter user amly default tablespace ts_amly;
(5)给用户授权
grant create session,create table,create view,unlimited tablespace to amly;
(6)以amly身份登陆创建表(执行SQL脚本)
create table tt_amly(in number(10));
@e:/test.sql;