1. 首先以管理员的身份登录到oracle系统中
进入到命令行:
sqlplus sys/admin as sysdba;
2.创建用户aqb,密码为aqb
create user aqb identified by aqb;
3.创建表空间,在D盘下建立50m的表空间data_aqb
create tablespace aqb_tablespace datafile 'E:\data_aqb' size 50m;
4.为用户分配表空间
alter user aqb identified by aqb default tablespace aqb_tablespace;
5.给用户授权
grant create session, create procedure, create trigger, create type, create table, create view, create sequence, unlimited tablespace to aqb;
6.aqb/aqb登录
conn aqb/aqb;
7.导入SQL语句,导入创建好的表
@E:\AQB.sql;