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
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