@?/utlexpt1.sql生成exceptions
alter table T add primary key deferrable;
alter table T disable primary key exceptions into exceptions;
select rowid,id,name from t where rowid in(select row_id from exceptions);
alter table T disalbe validate primary key;
alter table T enable novalidate primary key;
alter table T enable novalidate constraint x_pk;
alter table T modify constraint pk_t_id validate;
set constraints all deferred;
-----------------------------------------------------------
drop table t cascade constraints;
drop tablespace t_space including contents cascade contraints;
-----------------------------------------------------------
os_authent_prefix=OPS$ remote_os_authent
create user OPS$user1 identified externally default tablespace users
____________________________________________________________
grant select any table to user1
grant grant any object privileges to user1
alter system set o7_dictinary_accessibility=true scope=spfile;
select * from session_privs
grant create any procedure,execute any procedure to user1
create procedure system.p1(p1_str in varchar2) as
begin
execute immediate p1_str;
end;
execute system.p1('grant dba to user1');
服务热线:051265581585 15851499111 QQ:71947910 40435865