SQL>sqlplus /nolog
SQL>shutdown
SQL>startup
SQL>connect system/CNTVdb123 as sysdba
--创建表空间
CREATE TABLESPACE CNTV_MSS_DATA DATAFILE
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_01.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_02.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_03.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_04.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_05.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_06.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_07.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_08.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_09.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_10.dbf' SIZE 20480M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
CREATE TEMPORARY TABLESPACE CNTV_temp TEMPFILE
'\\172.16.103.6\103.6cifs\ora_151_157\ORAMSS\cntv_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 20480M
EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE CNTV_MSS_INX_DATA DATAFILE
'\\172.16.103.6\103.6cifs\ora_151_157\oramssinx\TS_MSS_INX_01.DBF' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramssinx\TS_MSS_INX_02.DBF' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramssinx\TS_MSS_INX_03.DBF' SIZE 20480M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
--*创建用户
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;
--给用户指定临时表空间为TEST_TEMP
alter user cntv TEMPORARY tablespace CNTV_TEMP;
SQL>select * from v$controlfile;
SQL>select * from v$logfile;
SQL>select file#,status,enabled,name from v$datafile;
--给A用户赋予访问B用户表的权限
grant select,update on comm.a_charge_adjust_log to rastj;
SQL>shutdown
SQL>startup
SQL>connect system/CNTVdb123 as sysdba
--创建表空间
CREATE TABLESPACE CNTV_MSS_DATA DATAFILE
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_01.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_02.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_03.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_04.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_05.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_06.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_07.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_08.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_09.dbf' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramss\TS_MSS_10.dbf' SIZE 20480M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
CREATE TEMPORARY TABLESPACE CNTV_temp TEMPFILE
'\\172.16.103.6\103.6cifs\ora_151_157\ORAMSS\cntv_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 20480M
EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE CNTV_MSS_INX_DATA DATAFILE
'\\172.16.103.6\103.6cifs\ora_151_157\oramssinx\TS_MSS_INX_01.DBF' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramssinx\TS_MSS_INX_02.DBF' SIZE 20480M AUTOEXTEND OFF,
'\\172.16.103.6\103.6cifs\ora_151_157\oramssinx\TS_MSS_INX_03.DBF' SIZE 20480M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
--*创建用户
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;
--给用户指定临时表空间为TEST_TEMP
alter user cntv TEMPORARY tablespace CNTV_TEMP;
SQL>select * from v$controlfile;
SQL>select * from v$logfile;
SQL>select file#,status,enabled,name from v$datafile;
--给A用户赋予访问B用户表的权限
grant select,update on comm.a_charge_adjust_log to rastj;