create tablespace PARTY_BUILDING --表空间名
logging
datafile ‘C:\app\Administrator\oradata/PARTY_BUILDING.dbf’ --物理空间
size 50m --大小
autoextend on
next 50m
extent management local;
create user PARTY_BUILDING identified by root default tablespace PARTY_BUILDING; --账号,密码(账号:PARTY_BUILDING 密码:root)
grant connect,resource to PARTY_BUILDING; --权限(cPARTY_BUILDING ky)
grant dba to PARTY_BUILDING; --dba权限 PARTY_BUILDING