´´½¨ºÍɾ³ýOracleÊý¾Ý¿âÓû§¡¢±í¿Õ¼ä

1. ´´½¨ÆÕͨÓû§
  >create user username identified by username;
  >grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
    2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
  >create temporary tablespace DB_TEMP
   tempfile '/opt/oracle/oradata/mydb/ts_db_temp01.dbf'
   size 200M
   autoextend on
   next 50M maxsize unlimited
   extent management local;
    2.2 ´´½¨Êý¾Ý±í¿Õ¼ä
  >create tablespace DB_TABLESPACE
   logging
   datafile '/opt/oracle/oradata/mydb/ts_db_data01.dbf'
   size 500M 
   autoextend on 
   next 50M  maxsize unlimited
   extent management local;
    2.3 ´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
  >create user username identified by password
   default tablespace DB_TABLESPACE
   temporary tablespace DB_TEMP;
    2.4 ¸øÓû§ÊÚÓèȨÏÞ
  >grant connect,resource to username;
3. ɾ³ýOracleÊý¾Ý¿âÓû§ºÍ±í¿Õ¼ä
    3.1 ɾ³ýOracleÊý¾Ý¿âÓû§
  >drop user user cascade;
    3.2 ɾ³ýOracleÊý¾Ý¿â¿Õ¼ä
  >drop tablespace tsname including contents and datafiles;