ORACLE 常用操作

来源：互联网发布：淘宝如何办理假学生证编辑：程序博客网时间：2024/06/03 15:42

1.无需密码，以系统管理员身份登录

2.创建用户以及表空间：

create user zhang identified by zhang;grant create session, connect,resource ,dba,EXP_FULL_DATABASE to zhang;create temporary tablespace clear_temptempfile 'D:/oraclexe/oradata/zhang/zhang_temp.dbf'size 32 mautoextend onnext 32 m maxsize 4048mextent management local;create tablespace clear_dataloggingdatafile 'D:/oraclexe/oradata/zhang/zhang_data.dbf'size 32 mautoextend onnext 32 m maxsize 4048mextent management local;alter  user zhangdefault tablespace clear_datatemporary tablespace clear_temp;

3.修改oracle http端口

SQL> exec dbms_xdb.sethttpport(8088);

4.创建用并授予指定表名的部分权限

create user zhang identified by zhang;grant create session,connect,resorce,dba to zhang;alter user kanck identified by zhang;//修改密码//锁定或者解锁用户alter user  account lock/unlock Create user union_input identified by tltgd;SQL> grant select,insert,delete,update on gd_union_merchant to union_input; Grant succeeded SQL> grant select,insert,delete,update on union_terminal to union_input; Grant succeeded SQL> grant create session to union_input;grant create sequence to union_input; Grant succeeded

5.创建触发器

create or replace trigger dectuser_tb_tribefore insert on dectuser /*触发条件：当向表dectuser执行插入操作时触发此触发器*/for each row /*对每一行都检测是否触发*/begin /*触发器开始*/select dectuser_tb_seq.nextval into :new.userid from dual; /*触发器主题内容，即触发后执行的动作，在此是取得序列dectuser_tb_seq的下一个值插入到表dectuser中的userid字段中*/end;

6.创建存储过程