create from oracle,oracle之create用法

create  database  --创建数据库

create database test

controlfile reuse

datafile 'd:\data\system1.dbf' size 100m  autoextend on next 100m maxsize unlimited

sysaux datafile 'd:\data\sysaux1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited

default temporary tablespace temp1

tempfile 'd:\data\temp1.dbf' size 100m reuse  autoextend on next 100m  maxsize unlimited

undo tablespace UNDOTBS1

datafile 'd:\data\undo1.dbf' size 100m reuse  autoextend on next 100m  maxsize unlimited

default tablespace user1

datafile 'd:\data\user1.dbf' size 100m reuse  autoextend on next 100m  maxsize unlimited

extent management local autoallocate

logfile group 1 'd:\data\redo1.log' size 100m reuse,

group 2 'd:\data\redo2.log' size 100m reuse,

group 3 'd:\data\redo3.log' size 100m reuse

character set al32utf8

user sys identified by oracle

user system identified by oracle

;

create user  --创建数据库用户

create user   yangdaliang  identified   by ydltest default  tablespace  test_ticket

create  tablespace --创建表空间

create tablespace test_account

logging

datafile 'D:\oracle\ora92\oradata\test_account.dbf'

size 32m

autoextend on

next 32m maxsize 2048m

extent management local;

create table  --创建数据表

create  table ydl_test

(sno number(5) primary key,

sname varchar(20),

saddrvarchar(100)

);

create index  --创建索引