ORACLE 笔记

1、创建临时表空间

CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE '/u01/app/oracle/oradata/ORCL/mpr_temp_01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

2、创建表空间

CREATE TABLESPACE test_data
LOGGING
DATAFILE '/u01/app/oracle/oradata/ORCL/mpr_data_01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

3、创建用户

create user mpr_mcrs_dev
  identified by mpr_mcrs_dev
default tablespace mpr_data_01 temporary tablespace mpr_temp_01;

4、给权限

grant connect,resource,create any table,drop any table,create sequence,
      select any table, create any index, drop any index,
      alter any trigger, create any trigger, drop any trigger,
      alter any type, create any type, drop any type,debug connect session,debug any procedure,
      create any view, drop any view, create any directory,
      create procedure, query rewrite, create session to mpr_mcrs_dev;

5、