一、 Oracle的安装
二、进入数据库后,进行创建用户
(1)创建用户名和密码
create user zl(用户名) identified by zl123(密码);
(2)分配表空间大小
create tablespace gbcT datafile 'e:\gzl_data.dbf' size 200M;
(3)修改用户表空间默认格式为gbct
alter user zl default tablespace gbcT;
(4)授权表空间
grant create session,create table,create view,create sequence,unlimited tablespace to zl;
(5)创建表
**创建表格式**
create table t_customer(
cust_id int primary key,
cust_name varchar2(30),
cust_gendev char(2),create user c##zl identified by zl123;
cust_phone varchar2(15),
cust_addres varchar2(30),
cust_birthday date,
cust_note varchar2(60)
);
**查看创建的表的信息是否已经创建成功**
select * from t_customer;