You are currently browsing the Database Management and Programing Article weblog archives for April, 2007.
You are currently browsing the Database Management and Programing Article weblog archives for April, 2007.
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..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..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..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..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..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..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..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..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..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..