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  --创建索引