oracle用户表空间创建

SQL> create tablespace deeptest datafile 'deeptest.dbf' size 5M

        --extent management local

       AUTOEXTEND ON NEXT 5M

        segment space management auto;

      

 

 

SQL> create temporary tablespace deep_temp tempfile 'deep_temp.dbf' size 200M autoextend on;

 

 

SQL> create user zhlg identified by orcl

        default tablespace users

temporary tablespace temp

        quota unlimited on users;

 

grant create session to zhlg;

grant create table,create view,create sequence,create procedure,create trigger to zhlg;

grant imp_full_database,exp_full_database to zhlg;

grant dba to zhlg;

grant select any table to zhlg;

 

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

 

Total System Global Area  483728236 bytes

Fixed Size                   453484 bytes

Variable Size             268435456 bytes

Database Buffers          213647360 bytes

Redo Buffers                1191936 bytes

Database mounted.

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

 

System altered.

 

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

 

System altered.

 

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

 

System altered.

 

SQL> ALTER DATABASE OPEN;

 

SQL> alter database character set INTERNAL_USE zhs16gbk;

 

 

Ecology oracle 数据库的编码为：

SQL> col value format a20;

SQL> select * from nls_database_parameters;

 

PARAMETER                      VALUE

------------------------------ --------------------

NLS_LANGUAGE                   AMERICAN

NLS_TERRITORY                  AMERICA

NLS_CURRENCY                   $

NLS_ISO_CURRENCY               AMERICA

NLS_NUMERIC_CHARACTERS         .,

NLS_CHARACTERSET               ZHS16GBK

NLS_CALENDAR                   GREGORIAN

NLS_DATE_FORMAT                DD-MON-RR

NLS_DATE_LANGUAGE              AMERICAN

NLS_SORT                       BINARY

NLS_TIME_FORMAT                HH.MI.SSXFF AM

 

PARAMETER                      VALUE

------------------------------ --------------------

NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXF

                                F AM

 

NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXF

                               F AM TZR

 

NLS_DUAL_CURRENCY              $

NLS_COMP                       BINARY

NLS_LENGTH_SEMANTICS            BYTE

NLS_NCHAR_CONV_EXCP            FALSE

 

PARAMETER                      VALUE

------------------------------ --------------------

NLS_NCHAR_CHARACTERSET         AL16UTF16

NLS_RDBMS_VERSION              9.2.0.1.0

 

已选择 20 行。

 

SQL> select userenv('language') from dual;

 

USERENV('LANGUAGE')

----------------------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK