【Oracle】实验三 Oracle数据库逻辑存储结构管理

-- 1 
create tablespace booktbs1 datafile 'E:\Oracle\Oracle11gapp\admin\booksales\booktbs1.dbf' size 50m;
-- 2
create tablespace booktbs2 datafile 'E:\Oracle\Oracle11gapp\admin\booksales\booktbs2.dbf' size 50m
extent management local  uniform size 1m segment  space management manual;
-- 3
create temporary tablespace temp02 tempfile 'E:\Oracle\Oracle11gapp\admin\booksales\temp02.dbf' size 20m
extent management local uniform size 15m;
-- 4
alter tablespace temp  tablespace group tempgroup;
alter tablespace temp tablespace group tempgroup