首页 | 控制面板 | 资源中心 | IT民工镇镇长Oracle Database常用语法汇总 Posted by sulee under [ORACLE技术文章（收藏）][ (0) 评论 ] | [ (1) 引用 ]GeneralSystem PrivilegesALTER DATABASETo specify the RECOVER clause requires SYSDBA privileges Create DatabaseSyntaxCREATE DATABASE <database_name>USER SYS IDENTIFIED BY <password>USER SYSTEM IDENTIFIED BY <password>CONTROLFILE REUSEMAXDATAFILES <integer>MAXINSTANCES <integer>CHARACTER SET <character_set_name>NATIONAL CHARACTER SET <character_set_name>SET DEFAULT <BIGFILE | SMALLFILE> TABLESPACELOGFILE GROUP <integer> <file_specification>,[GROUP <integer> <file_specification>,][GROUP <integer> <file_specification>]MAXLOGFILES <integer>MAXLOGMEMBERS <integer>MAXLOGHISTORY <integer><ARCHIVELOG | NOARCHIVELOG>[FORCE LOGGING]EXTENT MANAGEMENT LOCALDATAFILE <system_file_specification>SYSAUX DATAFILE <file_specification>DEFAULT TABLESPACE <tablespace_name>DATAFILE <file_specification>EXTENT MANAGEMENT LOCALUNIFORM SIZE <integer><M | G | T><BIGFILE | SMALLFILE> DEFAULT TEMPORARY TABLESPACE<tablespace_name>TEMPFILE <file_specification>EXTENT MANAGEMENT LOCALUNIFORM SIZE SIZE <integer><M | G | T><BIGFILE | SMALLFILE> UNDO TABLESPACE <tablespace_name>DATAFILE <file_specification>
SET TIME_ZONE = <time_zone_region>;Typical Create 10g Database On Linux / UNIX# su - oracle
$ .sqlplus
SQL> conn / AS SYSDBA
SQL> spool $HOME/CreateDB.log
startup nomount
pfile="/u01/oracle/product/admin/orabase/pfile/init.ora";
CREATE DATABASE "oragrid"
MAXINSTANCES 8
MAXLOGHISTORY 226
MAXLOGFILES 16
MAXLOGMEMBERS 4
MAXDATAFILES 1022
DATAFILE '/u02/oracle/oragrid/system01.dbf'
SIZE 540M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u03/oracle/oragrid/sysaux01.dbf'
SIZE 350M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u04/oracle/oragrid/temp01.dbf'
SIZE 25M REUSE
AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/u05/oracle/oragrid/undotbs01.dbf'
SIZE 100M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('/u05/app/oragrid/redo01a.log',
'/u06/app/oragrid/redo01b.log') SIZE 20M,
GROUP 2 ('/u05/app/oragrid/redo02a.log',
'/u06/app/oragrid/redo02b.log') SIZE 20M,
GROUP 3 ('/u05/app/oragrid/redo03a.log',
'/u06/app/oragrid/redo03b.log') SIZE 20M
USER SYS IDENTIFIED BY "&&sysPassword"
USER SYSTEM IDENTIFIED BY "&&systemPassword";
ALTER DATABASE OPEN RESETLOGS;
GRANT select ON v_$reserved_words TO PUBLIC;
spool offTypical Create 10g Database On Windowsconnect SYS/&&sysPa