ORACLE 常用操作

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

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

create user zhang identified by zhang;
grant create session, connect,resource ,dba,EXP_FULL_DATABASE to zhang;

create temporary tablespace clear_temp
tempfile 'D:/oraclexe/oradata/zhang/zhang_temp.dbf'
size 32 m
autoextend on
next 32 m maxsize 4048m
extent management local;

create tablespace clear_data
logging
datafile 'D:/oraclexe/oradata/zhang/zhang_data.dbf'
size 32 m
autoextend on
next 32 m maxsize 4048m
extent management local;


alter  user zhang
default tablespace clear_data
temporary 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_tri
before 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.创建存储过程