create or replace trigger tri_create_user
after create on xxx.schema --以后就用xxx这个帐户去建别的帐户
declare
v_sql varchar2(200);
v_sql2 varchar2(200);
begin
if ora_dict_obj_type='USER' then
v_sql:='create view v_test as select ... from ...';
v_sql2:=...........
execute immediate v_sql;
execute immediate v_sql2;
end if;
end;
/