创建ORACLE数据库 win 10g的方法



  1.create and start services

  oradim - -sid wwj -startmode manual

  2.create database

   ORACLE_SID=wwj

  C:\Documents and Settings\Administrator>sqlplus /nolog

  SQL> conn /as sysdba

  已连接到空闲例程

  SQL> startup nomount pfile='D:\oracle\wwj\pfile\initwwj.ora';

  CREATE DATABASE wwj

  USER SYS IDENTIFIED BY sys

  USER SYSTEM IDENTIFIED BY sys

  MAXLOGFILES 5

  MAXLOGMEMBERS 5

  MAXLOGHISTORY 1

  MAXDATAFILES 100

  MAXINSTANCES 1

  DATAFILE 'D:\oracle\wwj\datafile1\system01.dbf' SIZE 325M

  REUSE AUTOEXTEND _disibledevent=>   4.create the database objects

  CONNECT SYS/password AS SYSDBA

  $ORACLE_HOME/rdbms/admin/

  @ catalog.sql

  @ catblock.sql

  @ catproc.sql

  @ catoctk.sql

  @ owminst.plb

  system/

  @ $ORACLE_HOME/sqlplus/admin/pupbld.sql

  @ $ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql

  grant select _disibledevent=>
Tags: 

延伸阅读

最新评论

发表评论