Oracle creates user-specified tablespace delete user-deleted tablespace

--  Create a data table space  Create  Tablespace ciciloggingdatafile  '  /Usr/lib/Oracle/Xe/oradata/Cici. DBF  '  Size 32 mautoextend  On  Extent management local;  --  Create a user and specify a tablespace  Create   User Cici identified By Ciciprofile  Default  Default  Tablespace ciciaccount unlock;  Grant Connect, Resource To  Cici;  Grant   Create Session To Cici;

 

 

-- Log on to Oracle

# Sqlplus

SQL> conn system/System

-- Create a temporary data table space

Create temporary tablespace cicitemp
Tempfile 'd: \ oraclexe \ app \ oracle \ oradata \ Cici \ cicitemp. dbf'
Size 32 m
Autoextend on
Extent management local;

-- Create a data table space
Create tablespace Cici
Logging
Datafile 'd: \ oraclexe \ app \ oracle \ oradata \ Cici. dbf'
Size 32 m
Autoextend on

 

Extent management local;

-- Create a user and specify a tablespace

Create user Cici identified by Cici
Profile default
Default tablespace Cici
Temporary tablespace cicitemp
Account unlock;

Grant connect, resource to Cici;
Grant create session to Cici;

-- Cascading deletion of all objects under a user

Drop user dzysc cascade;

-- Delete a tablespace

Drop tablespace Cici including contents and datafiles;