We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query redirectio[……]
Category: rdbms
ORACLE – 9i to 10g database Upgrade using DBUA.
Purpose of this document is to show a complete 9i to 10g upgrade of an Oracle database on
AIX 5L using DBUA ( Database Uprgrade Assistant)
3.2 T[……]