create or replace trigger create_info
after create on database -- 如果记录某用户则用:after create on user1.scheme
begin
insert into create_log
(session_id,
create_time,
ip_address,
terminal,
object_owner,
object_name,
object_type,
drop_by_user)
values(USERENV('SESSIONID'),
sysdate,
SYS_CONTEXT('USERENV','IP_ADDRESS'),
SYS_CONTEXT('USERENV','TERMINAL'),
sys.dictionary_obj_owner,
sys.dictionary_obj_name,
sys.dictionary_obj_type,
sys.login_user);
end;
/不过这个只能记录创建对象的名字,你可以考虑当object_type='TABLE'时从cols中取出列名放进来
after create on database -- 如果记录某用户则用:after create on user1.scheme
begin
insert into create_log
(session_id,
create_time,
ip_address,
terminal,
object_owner,
object_name,
object_type,
drop_by_user)
values(USERENV('SESSIONID'),
sysdate,
SYS_CONTEXT('USERENV','IP_ADDRESS'),
SYS_CONTEXT('USERENV','TERMINAL'),
sys.dictionary_obj_owner,
sys.dictionary_obj_name,
sys.dictionary_obj_type,
sys.login_user);
end;
/不过这个只能记录创建对象的名字,你可以考虑当object_type='TABLE'时从cols中取出列名放进来
解决方案 »
- 求助:主键和索引的调用问题
- 怎么把表中的一个字段的全部值当成另一个表的每一列
- 问个问题,如何优化ORACLE数据库呢>?我现在一万条查询ORACLE数据时就比较慢?请问有什么方法吗>?
- oracle触发器的问题
- pro c 在ora10g的$ORACLE_HOME/lib中找不到 -lwtc9
- Trigger中调用存储过程的问题
- Oracle学习,求大神指点
- 请问做JAVAWEB开发时,哪些ORACLE服务可以停掉?
- ORA-01002: fetch out of sequence(请帮忙,高分)
- 毛病,安装oracle8.1.6的奇怪问题,ORA-27102:out of memory
- insert into与select连用的问题
- 请问Oracle中system的密码怎么修改????
before create on username.schema -- 在username用戶上創建審計create的觸發器
begin
if sys.dictionary_obj_type='TABLE' then
insert into create_log
(session_id,
drop_time,
ip_address,
object_owner,
object_name,
object_type,
drop_by_user)
values(USERENV('SESSIONID'),
sysdate,
SYS_CONTEXT('USERENV','IP_ADDRESS'),
sys.dictionary_obj_owner,
sys.dictionary_obj_name,
sys.dictionary_obj_type,
sys.login_user);
end if;
end;
sql>create table b as select c1,c2,c3 from a;
或
sql>create table b as select * from a; 然后删除不必要的列。