Oracle Create TableSpace,User

select * from v$nls_parameters;
select * from dba_data_files;

--1.创建TABLESPACE
CREATE TABLESPACE haixin_qa
DATAFILE '/u01/db/oracle/10gR2/pink/oradata/pink/haixin_qa01.dbf'
SIZE 100m
AUTOEXTEND ON
NEXT 50m
MAXSIZE 1000m;

--1.1增加 TABLESPACE
ALTER TABLESPACE haixin_qa
ADD DATAFILE '/u01/db/oracle/10gR2/pink/oradata/pink/haixin_qa02.dbf'
SIZE 100m
AUTOEXTEND ON
NEXT 50m
MAXSIZE 1000m;

--2.创建user
CREATE USER haixin
IDENTIFIED BY haixin
DEFAULT TABLESPACE haixin_qa
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;

--3.为用户赋权限
GRANT CONNECT,RESOURCE,DBA TO haixin;

drop user haixin cascade;

select * from v$session
where username='HAIXIN'

--在目标机器上设置字符集
export NLS_LANG=AMERICAN_AMERICA.WE8DEC
本地:SIMPLIFIED CHINESE_CHINA.ZHS16GBK

select userenv('language') from dual;
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';