Oracle User, table space creation, deletion, and expansion

Create user MCC identified by manager; Note here that the password should not be extended with single quotes.

1. Drop  user  mcc  cascade; Direct Delete user

2. Create user MCC identified by manager D Efault tablespace mcc01 temporary tablespace tmp; Create a user and make a default table space.

3. Create tablespace mcc01 datafile '/data/gps01.dbf ' size 200M uniform size 128k; Create tablespace

4. A Lter user  MCC default  tablespace mcc01; change users ' tablespace.

5. Drop tablespace mcc01  including contents and datafiles; erase tablespace

6. ALTER DATABASE DATAF Ile '/data/gps01.dbf ' autoextend on; change user table space to auto-expand.
   

7. Select  *  from  dba_data_files  where  tablespace_name= ' mcc01 ';

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

   
   

This article is from the "Common Documents" blog, so be sure to keep this source http://yujianglei.blog.51cto.com/7215578/1560539

Oracle User, table space creation, deletion, and expansion