视窗
loading...
您现在的位置:首页 > IT认证 > oracle认证 >

创建Oracle数据库win10g


  1.create and start services

  oradim -new -sid wwj -startmode manual

  2.create database

  set 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 ON NEXT 10240K MAXSIZE 500M

  SYSAUX DATAFILE 'D:\oracle\wwj\datafile1\sysaux01.dbf' SIZE 120M

  REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 500M

  DEFAULT TEMPORARY TABLESPACE temp

  TEMPFILE 'D:\oracle\wwj\datafile1\temp01.dbf' SIZE 200M REUSE EXTENT MANAGEMENT LOCAL

  UNDO TABLESPACE undotbs1

  DATAFILE 'D:\oracle\wwj\datafile1\undotbs01.dbf' SIZE 100M

 CHARACTER SET AL32UTF8

  NATIONAL CHARACTER SET AL16UTF16

  LOGFILE GROUP 1 ('D:\oracle\wwj\onlinelog\redo01a.log',

  'D:\oracle\wwj\onlinelog\redo01b.log') SIZE 50M,

  GROUP 2 ('D:\oracle\wwj\onlinelog\redo02a.log',

  'D:\oracle\wwj\onlinelog\redo02b.log') SIZE 50M,

  GROUP 3 ('D:\oracle\wwj\onlinelog\redo03a.log',

  'D:\oracle\wwj\onlinelog\redo03b.log') SIZE 50M;

  3.create extra tablespaces

  CREATE TABLESPACE tools

  DATAFILE 'D:\oracle\wwj\datafile1\tools01.dbf' SIZE 200M;

  CREATE TABLESPACE users LOGGING

  DATAFILE 'D:\oracle\wwj\datafile1\users01.dbf' SIZE 100M

  orapwd file=D:\oracle\product\10.2.0\db_1\dbs\orapwwj password=sys entries=10

  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 on sys.dba_data_files to system;

  5.

  SQL> create spfile from pfile='D:\oracle\wwj\pfile\initwwj.ora';

銆愬厤璐e0鏄庡拰鐗堟潈璇存槑銆�
鏈珯閮ㄥ垎淇℃伅鏉ユ簮浜庝簰鑱旂綉锛�瀵硅浆杞界殑淇℃伅鎴戜滑鍔涙眰鏍囨槑淇℃伅鐨勫嚭澶勶紝鎴戜滑灏婇噸浣滆€呯殑鐗堟潈钁椾綔鏉冿紝瀵规垜浠浆杞界殑淇℃伅濡傛湁寮傝鎴栨湁渚垫潈鎴栬繚娉曚俊鎭鍙婃椂鑱旂郴鎴戜滑锛屾湰绔欎細绔嬪嵆鍒犻櫎锛�瀵瑰師鍒涘唴瀹规垜浠効鎰忔敮浠橀€傚綋鐨勭ǹ閰紝鑱旂郴鏂瑰紡锛氶偖浠�:webmaster@jscj.com銆€鐢佃瘽锛�4008816886

相关文章

无相关信息
更新时间2022-03-13 10:53:44【至顶部↑】
联系我们 | 邮件: webmaster@jscj.com | 客服热线电话:4008816886(QQ同号) |  濠电姷鏁告慨鐑藉极閸涘﹥鍙忛柣鎴f閺嬩線鏌熼梻瀵割槮缁炬儳娼¢弻鐔衡偓鐢登瑰暩缂備讲鍋撳┑鐘叉处閻撳啰鎲稿⿰鍫濈婵ǹ娉涙闂佸憡娲﹂崹浼村础閹惰姤鐓曢柍鈺佸枤濞堟梹銇勮箛锝勯偗闁哄本绋戦埢搴ょ疀閺囩媭鍟嬮梻浣告惈閻绱炴笟鈧悰顕€宕堕澶嬫櫔闂佸憡渚楅崰妤呮儊濠婂牊鈷掑ù锝呮嚈瑜版帩鏁勯柛鈩冪☉缁犳煡鏌涢妷顔煎闁稿蓱閵囧嫰寮村Δ鈧禍楣冩倵鐟欏嫭绀€缂傚秴锕妴浣糕枎閹惧磭鐓戦梺闈涳紡閸曞墎纭€婵犵數濮烽弫鍛婃叏閻戣棄鏋侀柛娑橈攻閸欏繑銇勯幘鍗炵仼缁炬儳顭烽弻鐔煎礈瑜忕敮娑㈡煟閹惧瓨绀嬮柡灞炬礃瀵板嫮鈧綆浜炴禒鎾⒑閸忓吋銇熼柛銊ゅ嵆閸┿垽骞樺ú缁樻櫇闂侀潧绻嗛弲婊呪偓闈涚焸濮婃椽妫冨☉姘暫濠碘槅鍋呴悷鈺勬"闂佺硶鍓濊彠濞存粍绮撻弻锟犲磼濮橆剛娈归梺鍛婃⒒閸犳牠寮婚悢鑲╁祦闁割煈鍠氭导鍫ユ⒑鏉炴壆鍔嶉柟鐟版喘瀵偊骞樼紒妯绘闂佽法鍣﹂幏锟�

付款方式留言簿投诉中心网站纠错二维码手机版

客服电话: