Oracle创建用户和表空间

Posted by Simon Dong on 2014-05-26
  1. 创建

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    --创建表空间
    create tablespace <tablespace> datafile '<datafile>' size 50M autoextend on;
    --增加表空间
    alter tablespace <tablespace> add datafile '<datafile>' size <size>;
    --创建用户
    create user <username> identified by <password> default tablespace <tablespace>;
    --授权
    grant dba to <username>;
    --或
    grant resource,connect to <username>;
  2. 删除操作

    1
    2
    3
    4
    --删除表空间
    drop tablespace <tablespace> including contents and datafiles;
    --删除用户
    drop user <username> cascade;