例：1、创建数据库 create database database-name 希望详细点

Question

如题所述

Answer 1

这是oracle建立数据库的完整语法，其中数据库名和文件的路径可以自行修改。 CREATE DATABASE test_db
USER SYS IDENTIFIED BY oracleUSER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 (’/oracle/app/oracle/oradata/ocmdb/lfile/redo01.log’) SIZE 100M,
GROUP 2 (’/oracle/app/oracle/oradata/ocmdb/lfile/redo02.log’) SIZE 100M,
GROUP 3 (’/oracle/app/oracle/oradata/ocmdb/lfile/redo03.log’) SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/system01.dbf’ SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/sysaux01.dbf’ SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1 datafile ‘/oracle/app/oracle/oradata/ocmdb/dfile/tbs_1.dbf’ size 50m
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/temp01.dbf’
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Answer 2

create table AccessoryFile (
AccessoryId number not null,
FileId number,
AccessoryName varchar2(50),
constraint PK_ACCESSORYFILE primary key (AccessoryId)
); 这是 Oracle 建数据库 列名 Accessoryid 类型number 不允许为空 主见为 AccessoryId