Oracle中创建表空间

create tablespace myschool
datafile 'd:\Oracledb\myschool.dbf'
size 20m
autoextend on
maxsize unlimited


alter tablespace myschool
add datafile 'd:\Oracledb\myschoo2.db'
size 40m


drop tablespace myschool
including contents and datafiles
cascade constraints


desc dba_tablespaces
select tablespace_name from dba_tablespaces