视窗
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同号) |  濠电姷鏁告慨鐑藉极閹间礁纾块柟瀵稿Х缁€濠囨煃瑜滈崜姘跺Φ閸曨垰鍗抽柛鈩冾殔椤忣亪鏌涘▎蹇曠闁哄矉缍侀獮鍥敋閸涱喗鐦滈梻浣呵归鍡涘箲閸ヮ剚鍋樻い鏇楀亾鐎规洖缍婇、娆撳矗閵壯勶紡婵犵數濮烽弫鍛婃叏椤撱垹纾婚柟鍓х帛閻撴洟鏌曟径瀣仴闁兼椿鍨伴埢鎾活敃閵忊晜瀵岄梺闈涚墕濡瑩藟閸℃ǜ浜滈柡鍌氬皡閸旂喖鏌熼獮鍨伈闁轰焦鎹囬弫鎾绘晸閿燂拷

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

客服电话: