oracle用户表空间创建

来源：互联网发布：淘宝客服软件叫什么编辑：程序博客网时间：2024/05/07 19:06

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_temptempfile 'deep_temp.dbf' size 200Mautoextend on;

SQL> create user zhlg identified by orcl

defaulttablespace users

temporary tablespace temp

quotaunlimited on users;

grant create session to zhlg;

grant create table,create view,create sequence,create procedure,createtrigger 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 RESTRICTEDSESSION;

System altered.

SQL> ALTER SYSTEM SETJOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

SQL> alter database character setINTERNAL_USE zhs16gbk;

Ecology oracle数据库的编码为：

SQL> col value format a20;

SQL> select * fromnls_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') fromdual;

USERENV('LANGUAGE')

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

SIMPLIFIED CHINESE_CHINA.ZHS16GBK