Oracle 基本操作笔记

1）创建数据库

CREATE DATABASE myOraDB
  USER SYS IDENTIFIED BY SYSPWD
  USER SYSTEM IDENTIFIED BY SYSTEMPWD
  CONTROLFILE REUSE
  LOGFILE GROUP 1 ('redo01.log ') SIZE 10M,
                GROUP 2 ('redo02.log ') SIZE 10M,
  MAXLOGFILES 10
  MAXLOGMEMBERS 10
  MAXDATAFILES 100
  MAXINSTANCES 1
  CHARACTER SET US7ASCII
  DATAFILE 'sys01.dbf ' SIZE 100M REUSE
  EXTENT MANAGEMENT LOCAL
  DEFAULT TABLESPACE tbs_1
  DEFAULT TEMPORARY TABLESPACE tempts1
  TEMPFILE 'temp01.dbf ' SIZE 10M REUSE;