ORACLE notes_2

SQL>sqlplus /nolog
SQL>shutdown
SQL>startup
SQL>connect system/ORCLdb123 as sysdba




--创建表空间
CREATE TABLESPACE CNTV_MSS_DATA DATAFILE 
  'D:\oracle10g\oradata\ORCL\TS_MSS_1.dbf' SIZE 2048M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;




--创建临时表空间
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'D:\oracle10g\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL;




--DEFAULT TABLESPACE CNTV_MSS_DATA;    //指定默认表空间为CNTV_MSS_DATA
alter user system default tablespace CNTV_MSS_DATA;


--TEMPORARY TABLESPACE TEST_TEMP;      //指定临时表空间为TEST_TEMP
alter user system TEMPORARY tablespace TEST_TEMP;










--*创建用户
create user cntv identified by cntv123;
grant create session to cntv;--授予cntv用户创建session的权限，即登陆权限 
grant connect,resource to cntv;--给用户授予权限(角色)
grant create table,create sequence,create view,create procedure to cntv;--授予cntv用户创建表的权限
--给用户指定表空间
alter user cntv default tablespace CNTV_MSS_DATA;








SQL>select * from v$controlfile;
SQL>select * from v$logfile;
SQL>select file#,status,enabled,name from v$datafile;