ITPub博客

首页 > 数据库 > Oracle > oracle手动建库脚本

oracle手动建库脚本

原创 Oracle 作者:east0323 时间:2007-02-12 20:24:31 0 删除 编辑

oradim -new -sid east -intpwd oracle -startmode manual -pfile 'd:oracleora92databaseinitEAST.ora'

set oracle_home=d:oracleora92
set oracle_sid=east

sqlplus/nolog
--操作系统验证
connect / as sysdba;
--或者
connect SID/password as sysdba;
connect east/oracle as sysdba;

CREATE DATABASE "EAST"
CONTROLFILE REUSE
LOGFILE GROUP 1
('d:oracleoradataEASTredo0101.log',
'd:oracleoradataEASTredo0102.log') SIZE 5M REUSE,
GROUP 2
('d:oracleoradataEASTredo0201.log',
'd:oracleoradataEASTredo0202.log') SIZE 5M REUSE
MAXLOGFILES 4
MAXLOGMEMBERS 2
MAXLOGHISTORY 0
MAXDATAFILES 254
MAXINSTANCES 1
NOARCHIVELOG
CHARACTER SET "US7ASCII"
NATIONAL CHARACTER SET "AL16UTF16"
DATAFILE 'd:oracleoradataEASTsystem01.dbf' SIZE 80M
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS
DATAFILE 'd:oracleoradataEASTundo01.dbf' SIZE 35M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'd:oracleoradataEASTtemp01.dbf' SIZE 20M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M;

--建立数据字典:
@%ORACLE_HOME%rdbmsadmincatalog.sql;
@%ORACLE_HOME%rdbmsadmincatproc.sql;
$ORACLE_HOME/rdbms/admin/catexp.sql

初始化参数文件和建库脚本如下:

initEAST.ora

create_database_sql.txt

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/250684/viewspace-899324/,如需转载,请注明出处,否则将追究法律责任。

上一篇: test
请登录后发表评论 登录
全部评论

注册时间:2010-05-02

  • 博文量
    3
  • 访问量
    3046