Code Snippet

Just another Code Snippet site

Random Post :




[Oracle-Weblogic] RCU Silent Install

/<path/to/oracle/home>/oracle_common/bin/rcu -silent -createRepository -databaseType ORACLE -connectString localhost:1521:oracle12 -dbUser sys -dbRole SYSDBA -schemaPrefix APP1 -component MDS -component IAU -component IAU_APPEND -component IAU_VIEWER -component OPSS -component UCSUMS -component WLS -component ESS -component STB -component SOAINFRA -useSamePasswordForAllSchemaUsers true -selectDependentsForComponents true -f < /tmp/rcu_passwordfile.txt

, ,

[Oracle] Materialized View

Creating a MV :

CREATE MATERIALIZED VIEW <mv_name> 
ENABLE QUERY REWRITE AS
<SQL_query>

Refreshing manualy a MV :

exec DBMS_MVIEW.REFRESH('<mv_name>');

Stats can be calcultated on MV like on table (cf Related Links)

,

Previous Posts Next posts