数据库对象管理.doc

Oracle创建和管理数据库对象 create table alter table alter table tablename add (column_name column_type) alter table tablename drop column column_name alter table tablename drop (col_name1,col_name2...) alter table tablename modify col_name column_type alter table table_old_name rename to table_new_name alter table tablename read only alter table tablename read write alter table tablename modify colname not null alter table tablename add constraint constraintname primary key(colname[,colname]) unique(colname) foreign key(colname) references primarytable(colname) create table .. disable alter table tablename disable constraint constraintname alter table tablename enable constraint constraintname alter table drop constraint constraintname create index inname on tablename(colname) --B tree create bitmap index inname on tablename(colname) ---bitmap create index inname on tablename(colname) reverse --reverse alter index inname rebulid reverse create index inname on tablename(function(colname)) alter index inname coalesce deallocate unused alter index inname rebuild drop index inname select index_name,index_type from dba_indexes where owner=SCOTT; select column_name,column_length from user_ind_columns where index_name=; select column_express from user_ind_expressions where index_name=; create or replace view viewname[(alias,alias)] as select ... with check option with read only desc user_views alter view viewname compile drop view viewname create sequence seqname start with n increment by n minvalue n|nominvalue maxvalue n|nomaxvalue cache n|nocache cycle|nocycle order|order nextval currval seqname.currval seqname.nextval alter sequence start with --can not change drop sequence desc user_sequences create public synonym syname for scott.dept drop public synonym syname create synonym syname for tablename/indexname/viewname drop synonym syname 用户模式表 用户和模式 Oracle用户是用连接数据库和访问数据库对象的。（用户是用来连接数据库访问数据库） 模式是数据库对象的集合。模式对象是数据库数据的逻辑结构。 （把数据库对象用模式分开成不同的逻辑结构）。 用户是用来连接数据库对象。而模式用是用创建管理对象的。模式跟用户