Shulou(Shulou.com)06/01 Report--

Create user mcc identified by manager;, be careful not to use single quotation marks to enlarge passwords.

Drop user mcc cascade; delete users directly

Create user mcc identified by manager default tablespace mcc01 temporary tablespace tmp; creates users and sets default tablespaces.

Create tablespace mcc01 datafile'/ data/gps01.dbf' size 200m uniform size 128k; create tablespaces only

Alter user mcc default tablespace mcc01; changes the user's tablespace.

Drop tablespace mcc01 including contents and datafiles; deletes tablespaces

Alter database datafile'/ data/gps01.dbf' autoextend on; changes the user tablespace to auto-extend.

Select * from dba_data_files where tablespace_name='mcc01'

Alter tablespace MCC01 add datafile'/ data/gps02.dbf' size 100m autoextend on next 5m maxsize 200m

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.