Oracle9i手工建库
来源:互联网 发布:免费的淘宝客软件下载 编辑:程序博客网 时间:2024/04/28 07:55
/*创建Oracle文件目录*/
C>mkdir C:oracleadmingdqybdump
C>mkdir C:oracleadmingdqycdump
C>mkdir C:oracleadmingdqycreate
C>mkdir C:oracleadmingdqypfile
C>mkdir C:oracleadmingdqyudump
C>mkdir C:oracleadmingdqycdump
C>mkdir C:oracleadmingdqycreate
C>mkdir C:oracleadmingdqypfile
C>mkdir C:oracleadmingdqyudump
/*创建数据库文件目录*/
C>mkdir C:oracleoradatagdqy
/*定义新的oracle实例*/
C>C:oracleora92binoradim.exe -new -sid gdqy -startmode m
C>C:oracleora92binoradim.exe -edit -sid gdqy -startmode a
C>C:oracleora92binoradim.exe -edit -sid gdqy -startmode a
/*定义oracle密码文件*/
C:oracleora92binorapwd file=C:oracleora92databasePWDgdqy.ora password=change_on_install entries=5
/* 启动实例,创建数据库*/
/*以sys登录sql*plus*/
C>C:oracleora92binsqlplus /nolog
SQL>
SQL>conn sys/orac1 as sysdba
SQL>set echo on
--SQL>spool C:oracleora92assistantsdbcalogsCreateDB.log
/*启动实例*/
--SQL>startup nomount pfile="C:oracleadmingdqyscriptsinit.ora";
SQL>startup nomount pfile="c:oracleadmingdqypfileinit.ora";
ORACLE 例程已经启动。
(startup nomount为非安装启动,这种方式启动下可执行:重建控制文件、重建数据库。读取init.ora文件,启动instance,即启动SGA和后台进程,这种启动只需要init.ora文件。
startup pfile=参数文件名,带初始化参数文件的启动方式。先读取参数文件,再按参数文件中的设置启动数据库。)
Total System Global Area 131144544 bytes
Fixed Size 453472 bytes
Variable Size 109051904 bytes
Database Buffers 20971520 bytes
Redo Buffers 667648 bytes
/*创建数据库*/
SQL>CREATE DATABASE gdqy
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'C:oracleoradatagdqysystem01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:oracleoradatagdqytemp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:oracleoradatagdqyundotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('C:oracleoradatagdqyredo01.log') SIZE 102400K,
GROUP 2 ('C:oracleoradatagdqyredo02.log') SIZE 102400K,
GROUP 3 ('C:oracleoradatagdqyredo03.log') SIZE 102400K
数据库已创建。
--SQL>spool off
SQL>
----------------------------------------------------------------------
SQL>exit;
SQL>connect SYS/orac1 as SYSDBA
SQL>create spfile='C:oracleora92databasespfilegdqy.ora' FROM pfile='C:oracleadmingdqypfileinit.ora';
SQL>shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE例程已经关闭。
SQL>startup
ORACLE例程已经启动。
----------------------------------------------------------------------
C>C:oracleora92binsqlplus /nolog
SQL>
SQL>conn sys/orac1 as sysdba
SQL>set echo on
--SQL>spool C:oracleora92assistantsdbcalogsCreateDB.log
/*启动实例*/
--SQL>startup nomount pfile="C:oracleadmingdqyscriptsinit.ora";
SQL>startup nomount pfile="c:oracleadmingdqypfileinit.ora";
ORACLE 例程已经启动。
(startup nomount为非安装启动,这种方式启动下可执行:重建控制文件、重建数据库。读取init.ora文件,启动instance,即启动SGA和后台进程,这种启动只需要init.ora文件。
startup pfile=参数文件名,带初始化参数文件的启动方式。先读取参数文件,再按参数文件中的设置启动数据库。)
Total System Global Area 131144544 bytes
Fixed Size 453472 bytes
Variable Size 109051904 bytes
Database Buffers 20971520 bytes
Redo Buffers 667648 bytes
/*创建数据库*/
SQL>CREATE DATABASE gdqy
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'C:oracleoradatagdqysystem01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:oracleoradatagdqytemp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:oracleoradatagdqyundotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('C:oracleoradatagdqyredo01.log') SIZE 102400K,
GROUP 2 ('C:oracleoradatagdqyredo02.log') SIZE 102400K,
GROUP 3 ('C:oracleoradatagdqyredo03.log') SIZE 102400K
数据库已创建。
--SQL>spool off
SQL>
----------------------------------------------------------------------
SQL>exit;
SQL>connect SYS/orac1 as SYSDBA
SQL>create spfile='C:oracleora92databasespfilegdqy.ora' FROM pfile='C:oracleadmingdqypfileinit.ora';
SQL>shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE例程已经关闭。
SQL>startup
ORACLE例程已经启动。
----------------------------------------------------------------------
/*创建各个表空间*/
CREATE TABLESPACE RBS
DATAFILE 'c:oracleoradatagdqyrbs01.dbf' SIZE 256M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE
(INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
CREATE TABLESPACE USERS
DATAFILE 'c:oracleoradatagdqyusers01.dbf' SIZE 128M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE
(INITIAL 128K NEXT 128K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
CREATE TABLESPACE TEMP
DATAFILE 'c:oracleoradatagdqytemp01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE
(INITIAL 64K NEXT 64K MINEXTENTS 1
MAXEXTENTS UNLIMITED PCTINCREASE 0)
TEMPORARY;
CREATE TABLESPACE TOOLS
DATAFILE 'c:oracleoradatagdqytools01.dbf' SIZE 64M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE
(INITIAL 32K NEXT 32K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
CREATE TABLESPACE INDEX
DATAFILE 'c:oracleoradatagdqyindex01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE
(INITIAL 1282K NEXT 128K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
DATAFILE 'c:oracleoradatagdqyrbs01.dbf' SIZE 256M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE
(INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
CREATE TABLESPACE USERS
DATAFILE 'c:oracleoradatagdqyusers01.dbf' SIZE 128M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE
(INITIAL 128K NEXT 128K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
CREATE TABLESPACE TEMP
DATAFILE 'c:oracleoradatagdqytemp01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE
(INITIAL 64K NEXT 64K MINEXTENTS 1
MAXEXTENTS UNLIMITED PCTINCREASE 0)
TEMPORARY;
CREATE TABLESPACE TOOLS
DATAFILE 'c:oracleoradatagdqytools01.dbf' SIZE 64M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE
(INITIAL 32K NEXT 32K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
CREATE TABLESPACE INDEX
DATAFILE 'c:oracleoradatagdqyindex01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE
(INITIAL 1282K NEXT 128K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
创建系统视图
- Oracle9i手工建库
- 手工创建Oracle9i数据库
- 手工将oracle9i升到11g
- RAC 手工建库
- oracle手工建库
- 一、手工建库
- ORACLE手工建库
- 手工建库
- Oracle手工建库
- Oracle 手工建库
- Oracle手工建库
- oracle 手工建库
- oracle手工建库
- Oracle手工建库
- 手工建库
- 手工建库
- oralce手工建库
- 手工建库方法
- URL Helper v2.7
- [转]MySQL的优化
- 计算出k的阶乘k!全部有效数字。
- Microsoft Small Business Server SBS 2003: A Clear and Concise Administrator's Reference and How-To
- 烦琐的一天
- Oracle9i手工建库
- 建议IT管理人员读的书?
- 算法讲义(1) - 序言
- 利用c#的反射机制得到类的信息
- 如何编写异常安全的C++代码
- 如何使用FindControl查找内容页上的某个控件
- Overriding与Overloading
- 菜鸟学Python(6):在Linux下用C扩展Python要注意的一个问题
- 口才训练计划- -