create
temporary
tablespace zyj_temp
tempfile
'D:\app2\user\virtual\oradata\orcl\zyj_temp.dbf'
size
50m
autoextend
on
next
50m maxsize 20480m
extent management
local
;
create
tablespace zyj_data
logging
datafile
'D:\app2\user\virtual\oradata\orcl\zyj_data.dbf'
size
50m
autoextend
on
next
50m maxsize 20480m
extent management
local
;
create
user
c##zyj identified
by
1234
default
tablespace zyj_data
temporary
tablespace zyj_temp;
GRANT
CREATE
ANY
VIEW
,
DROP
ANY
VIEW
,
CONNECT
,RESOURCE,
CREATE
SESSION,DBA
TO
c##zyj;
drop
user
c##zyj
cascade
;
DROP
TABLESPACE zyj_data INCLUDING CONTENTS
AND
DATAFILES;
drop
tablespace tablespace_name;
drop
tablespace tablespace_name including contents;
drop
tablespace tablespace_name including datafiles;
drop
tablespace tablespace_name including contents
and
datafiles;
drop
tablespace tablespace_name including contents
and
datafiles
CASCADE
CONSTRAINTS;
select
tablespace_name
from
DBA_tablespaces;