在本机安装了Oracle数据库,接下来是创建表空间和用户。
--创建表空间:
create
temporary
tablespace USER_TEMP
tempfile
'D:\oracle\oradata\user_temp.dbf'
size
50m
autoextend
on
next
50m maxsize 20480m
extent management
local
;
create
tablespace USER_DATE
logging
datafile
'D:\oracle\oradata\user_data.dbf'
size
50m
autoextend
on
next
50m maxsize 20480m
extent management
local
;
create
user
root identified
by
root
default
tablespace USER_DATE
temporary
tablespace USER_TEMP;
GRANT
connect
,resource,DBA
TO
root;
--要删除表空间,可以
DROP
TABLESPACE SIMPLE;
drop
tablespace SIMPLE including contents
and
datafiles;
--同时删除其数据库对象和数据文件