Oracle11g安装过程

转载

技术员小攀 2020-10-04 12:20:39 博主文章分类：数据库

程序安装过程一、数据库创建 CREATE TABLESPACE nnc_DATA01 DATAFILE 'd:\app\ncdata\nnc_data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE nnc_DATA02 DATAFILE 'd:\app\ncdata\nnc_data02.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE nnc_DATA03 DATAFILE 'd:\app\ncdata\nnc_data03.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;

CREATE TABLESPACE nnc_INDEX01 DATAFILE 'd:\app\ncdata\nnc_index01.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE nnc_INDEX02 DATAFILE 'd:\app\ncdata\nnc_index02.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE nnc_INDEX03 DATAFILE 'd:\app\ncdata\nnc_index03.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

创建用户示例参考 CREATE USER hpp IDENTIFIED BY orcle DEFAULT TABLESPACE nnc_DATA02 TEMPORARY TABLESPACE temp; GRANT connect,dba to hpp;

CREATE USER px IDENTIFIED BY px DEFAULT TABLESPACE nnc_DATA01 TEMPORARY TABLESPACE temp; GRANT connect,dba to px; NC57用户 CREATE USER NC57 IDENTIFIED BY NC613 DEFAULT TABLESPACE nnc_DATA01 TEMPORARY TABLESPACEtemp; GRANT connect,dba to NC57;