oracle创建表的过程

《oracle创建表的过程》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、1.远程：training2.1234563.orcl34.本地：sys5.tiger6.sysdba7.8.9.10.以管理员的形式创建一个普通用户表，用户名是sys，密码是tiger;11.右键点击创建一个表12.13.新建一个sql的窗口1.grantcreatetabletotransformer;grantcreateviewtotransformer;grantcreatesequencetotransformer;//防止登录失败grantcreatesessiontotransformer;//给用户表空间进行授权alterusertransformerquotaunlim

2、itedonusers;2.登录3.createtablephoto_albums(albumidnumber(10)notnullprimarykey,albumnamevarchar2(100)notnull,descriptionvarchar2(600),builddatedatenotnull)createtablephoto_photos(photoidnumber(10)notnullprimarykey,photonamevarchar2(100)notnull,albumidnumber(10)notnull,screendatedatenotnull,descripti

3、onvarchar2(600),phototypevarchar2(100)notnull,foreignkey(photoid)referencesphoto_albums(albumid))createtabletraining_users(useridnumber(10)notnullprimarykey,usernamevarchar2(50)notnull,passwordvarchar2(100)notnull,realnamevarchar2(50))4.5.右键-编辑-1.讲photoid的值改成albumid;2.创建序列3.createsequenceseq_photo

4、_albumsincrementby1startwith1nomaxvaluenominvaluenocachecreatesequenceseq_photo_photosincrementby1startwith1nomaxvaluenominvaluenocache1.insertintotraining_usersvalues(1,'admin','11','zt');2.insertintophoto_albums(albumid,albumname,description,builddate)values(seq_photo_albums.nextval,'moon2','898

5、9757336',sysdate);3.insertintophoto_photosvalues(seq_photo_photos.nextval,'moon',1,sysdate,'1111111','image/gif');4.select*fromphoto_albums;select*fromphoto_photos;数据库的配置信息