一、创建表空间
create tablespace ORACLE --表空间名
datafile 'D:\app\Becauseofyou\oradata\myorcl.dbf' --你的dbf文件地址
size 1024m
autoextend on next 32m maxsize 2048m
二、创建用户
create user admin identified by admin profile default default tablespace czpt account unlock;
三、授权
grant connect,resource to admin;
grant create session to admin