Just to remember this password

..... don't forget to flush buffer cache:

alter system flush buffer_cache;

Oracle Data Guard platform compatibility

There is two interesting MOS notes about Oracle's DR solution (DG).
- Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]
and
- Data Guard Support for Heterogeneous Primary and Logical Standbys in Same Data Guard Configuration [ID 1085687.1]
It seems that we have not so much opportunities to implement heterogeneous DR configurations.

How to disable reference constraint(s) for particular table(s)

Anonymous PL/SQL block for single table:


declare
alter_tbl varchar2(4000) := '';
begin
SELECT 'ALTER TABLE '||table_name||' DISABLE CONSTRAINT '||constraint_name INTO alter_tbl FROM user_constraints WHERE r_constraint_name IN (SELECT constraint_name FROM user_constraints WHERE table_name='TABLE_NAME' AND constraint_type <> 'R') AND status = 'ENABLED';
--dbms_output.put_line(alter_tbl);
execute immediate alter_tbl;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
dbms_output.put_line('Table does not have any (enabled) reference constraints!');
end;
/


And for two (or more) tables:


declare
cnt number;
begin
SELECT count(table_name) INTO cnt FROM user_constraints WHERE r_constraint_name IN (SELECT constraint_name FROM user_constraints WHERE table_name IN ('1_TABLE_NAME', '2_TABLE_NAME') AND constraint_type <> 'R') AND status = 'ENABLED';
IF cnt = 0 THEN
dbms_output.put_line('Table does not have any (enabled) reference constraints!');
ELSE
FOR alter_tbl IN (
SELECT 'ALTER TABLE '||table_name||' DISABLE CONSTRAINT '||constraint_name AS tbl FROM user_constraints WHERE r_constraint_name IN (SELECT constraint_name FROM user_constraints WHERE table_name IN ('1_TABLE_NAME', '2_TABLE_NAME') AND constraint_type <> 'R') AND status = 'ENABLED'
) LOOP
-- dbms_output.put_line(alter_tbl.tbl);
execute immediate alter_tbl.tbl;
END LOOP;
END IF;
END;
/


Oracle's OTN and wget (HOWTO)

Как качать файлы с otn.oracle.com wget'ом, например Linux_x86_64_Grid_Control_full_102030_disk1.zip - Oracle Enterprise Manager 10g Grid Control for Linux x86-64?
Да вот так! (см. http://forums.oracle.com/forums/thread.jspa?messageID=2666987)

usd@blackhole:~> wget -v -c --post-data="remoteIp=myIP>&globalId=&redirectUrl=\
http:%2F%2Fdownload-llnw.oracle.com:80\
%2Fotn%2Flinux%2Foem%2F10203%2F\
Linux_x86_64_Grid_Control_full_102030_disk1.zip\
&username=myOTNusername>\
&password=mypasswd>\
&submit=Continue" \
https://profile.oracle.com/jsp/reg/loginHandler.jsp