zhouying23 发表于 2018-9-24 08:34:08

ORACLE学习第一站:安装ORACLE-IT

USER SYS>   USER SYSTEM>
  LOGFILE GROUP 1 ('/opt/u01/app/oracle/oradata/$SID/redo01.log')>
  GROUP 2 ('/opt/u01/app/oracle/oradata/$SID/redo02.log')>
  GROUP 3 ('/opt/u01/app/oracle/oradata/$SID/redo03.log')>  MAXLOGFILES 5
  MAXLOGMEMBERS 5
  MAXLOGHISTORY 1
  MAXDATAFILES 100
  MAXINSTANCES 1
  CHARACTER SET AL32UTF8
  NATIONAL CHARACTER SET AL16UTF16

  DATAFILE '/opt/u01/app/oracle/oradata/$SID/system01.dbf'>  EXTENT MANAGEMENT LOCAL

  SYSAUX DATAFILE '/opt/u01/app/oracle/oradata/$SID/sysaux01.dbf'>
  DEFAULT TABLESPACE usertbs DATAFILE '/u01/app/oracle/oradata/$SID/usertbs.dbf'>  DEFAULT TEMPORARY TABLESPACE tempts1
  TEMPFILE '/opt/u01/app/oracle/oradata/$SID/temp01.dbf'

  >  UNDO TABLESPACE undotbs
  DATAFILE '/opt/u01/app/oracle/oradata/$SID/undotbs01.dbf'

  >
页: [1]
查看完整版本: ORACLE学习第一站:安装ORACLE-IT