Archive for April, 2007

Damage to the operating system, Oracle 10g database restore the entire process

Monday, April 30th, 2007 Posted in ORACLE | No Comments »

  Environment: oracle10g, OS 5.2    The database system in rootvg / oracle file system    The data file in datavg / oradata file system    ... Read more..

On the largest availability of Oracle database architecture

Monday, April 30th, 2007 Posted in DATABASE BASIC | No Comments »

  The largest availability architecture (Maximum Availability Architecture, referred to MAA) is based on the design blueprint has been proven Oracle high-availability technologies, MAA's proposal to provide the optimal ... Read more..

How to identify prospects are issued by the sql statement

Monday, April 30th, 2007 Posted in DATABASE BASIC | No Comments »

  Q: How can we identify prospects are issued by the sql statements »    A: The concrete steps are as follows:    Software environment:    ... Read more..

How to build and SQL Server in the form of UDF

Monday, April 30th, 2007 Posted in DATABASE BASIC | No Comments »

  In SQL Server 2000 and 2005, UDF (user-defined functions) is my favorite form of one of the characteristics.    If you have not used them, you can try, ... Read more..

Oracle database quickly master the use of the cursor (1)

Monday, April 30th, 2007 Posted in DATABASE BASIC | No Comments »

  Explicit cursor    When the results of queries over his party back to when it needs an explicit pointer, then the user can not use select into ... Read more..

Database reported ora-00603 ora-ora27504

Monday, April 30th, 2007 Posted in DATABASE BASIC | No Comments »

  Our database the day before yesterday reported a sudden ora-00603 error, I now on this issue the order by:    My environment is:    OS: AIX ... Read more..

Oracle Qiao Qiao from the designated use of records and related enquiries

Monday, April 30th, 2007 Posted in ORACLE | No Comments »

  This paper in the form of examples to solve specific records from Oracle and Qiao Qiao associated with the issue of enquiries.    How do I get ... Read more..

ORACLE part of the contents

Monday, April 30th, 2007 Posted in ORACLE | No Comments »

  1 to view the implementation plan:    sql> set autotrace traceonly explain;    sql> select * from v $ tablesapce;    Plan of Implementation of ... Read more..

Oracle database used in the process of regular storage division table

Monday, April 30th, 2007 Posted in ORACLE | No Comments »

  Oracle database storing a wide variety of data, some of which data tables will as time goes by, more and more.    Works such as chat logs, send ... Read more..

"User Guide to the management of backup and recovery," read the note (2)

Monday, April 30th, 2007 Posted in ORACLE | No Comments »

  5.    Making user-managed backups in SUSPEND mode    About suspend / resume: the use of third-party tools will be a group of disk mirroring or logic ... Read more..