oracle 安装脚本位置,oracle安装脚本

1.安装数据库，配置监听

修改tns文件 siwebyh

2.创建表空间

//创建数据表空间

create tablespace DATA

datafile 'F:Toolsoracle11goradatazwydata001.dbf'

size 20480M

autoextend on

next 256m

extent management local;

create tablespace DATA

datafile 'C:oracleproduct10.2.0oradatastjcdata001.dbf'

size 20480M

autoextend on

next 256m

extent management local;

create tablespace ts_ylfwzb

datafile 'h:oracledatafileTS_YLFWZB.dbf' size 4096m;

create tablespace tsi_ylfwzb

datafile 'h:oracledatafiletsi_ylfwzb.dbf' size 4096m;

// 增加数据文件

alter tablespace DATA add datafile 'F:Toolsoracle11goradatazwydata002.dbf'

size 30720M

autoextend on

next 256m

MAXSIZE UNLIMITED;

alter tablespace USERS add datafile 'F:Toolsoracle11goradatazwydata003.dbf'

size 10240M

autoextend on

next 256m

MAXSIZE UNLIMITED;

alter tablespace DATA add datafile 'F:oradata31data01.dbf'

size 10240M

autoextend on

next 256m

MAXSIZE UNLIMITED;

//创建书索引表空间

create tablespace INDX

datafile 'D:oracleproduct10.2.0oradatawebdataindx01.dbf'

size 1024M

autoextend on

next 256m

extent management local;

//创建临时表空间

create temporary tablespace temp1

tempfile 'D:oracleproduct10.2.0oradatawebdatatemp02.dbf'

size 1024M

autoextend on

next 256M maxsize 2048M

extent management local;

3.创建用户指定表空间，授权

//创建用户并指定表空间

create user ezjmyb identified by jmyb default tablespace data temporary tablespace temp;

create user xnsi identified by xnsi default tablespace data temporary tablespace temp;

create user ezsi identified by ezsi default tablespace data temporary tablespace temp;

create user stjc identified by stjc default tablespace data temporary tablespace temp;

create user mxjh_002 identified by mxjh_002 default tablespace data temporary tablespace temp;

create user ylfwjk identified by ylfwjk default tablespace data ;

create user ylfwzb identified by ylfwzb default tablespace data ;

//给用户授予权限

grant connect,resource,dba to ezjmyb;

grant connect,resource,dba to xnsi;

grant connect,resource,dba to stjc;

grant connect,resource,dba to ylfwjk;

grant connect,resource,dba to ylfwzb;

grant connect,resource,dba to mxjh_002;

4.导入数据，并检查

imp webdata/hbsbwebdata fromuser=webdata touser=webdata buffer=1024000 file=E:20081216.dmp log=d:imp.log ignore=y

5.创建DBLINK

create database link SI_LINK

connect to SI2008 identified by HBSBSI2008

using 'SISERVER';

6.创建同义词

DROP

CREATE

7.刷新视图

8.刷新后台