Oracle创建用户和表空间

在system下创建表空间：

create tablespace CASETABLE
datafile 'D:\app\CASETABLE.dbf' size 1024M --存储地址 初始大小1G
autoextend on next 1024M maxsize unlimited   --每次扩展1G，无限制扩展
EXTENT MANAGEMENT local  autoallocate
segment space management auto;

在system下创建用户

-- 创建用户
  create user ONECASE
  default tablespace CASETABLE
  temporary tablespace TEMP
  IDENTIFIED BY 123
  profile DEFAULT;

-- 给用户授权
-- Grant/Revoke role privileges
  grant connect to ONECASE;
  grant dba to ONECASE;
-- Grant/Revoke system privileges
   grant create database link to ONECASE;
   grant unlimited tablespace to ONECASE;

在ONECASE用户下创建用户信息表

-- Create table
create table case_user
(
  username VARCHAR2(32) not null,
  password  VARCHAR2(32) not null
)
tablespace CASETABLE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table
comment on table case_user
  is '用户登入信息表';
-- Add comments to the columns
comment on column case_user.username
  is '用户名';
comment on column case_user.password
  is '密码';
-- Create/Recreate primary, unique and foreign key constraints
alter table case_user
  add constraint PK_LAS_CAMERABARCODE primary key (username)
  using index
  tablespace CASETABLE
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );