(Brian Peasland) At present I have a strange problem with RMAN. I recently upgraded a database from 9i to 10g. My RMAN is also 10g. When I do a full backup, at the end of the backup I get an ORA-600 error. However when I do the recovery drill it works fine. I am pretty confused — any pointers? (R
Other News
Regular Expressions Make Pattern Matching And Data Extraction Easier
(David Banister) Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are
ADO.NET vNext Part 3: Querying with LINQ
(Thiru Thangarathinam) The previous article in this series introduced the core concepts of Object Services Layer, including the steps to perform CRUD (Create, Read, Update and Delete) operations against the Entity Data Model (EDM). With that foundation, this installment focuses on using LINQ to quer
Use Apache Derby to develop Eclipse plug-ins
(Ilya Platonov, Artem Papkov, Jim Smith and Terry Finch) Eclipse is a powerful IDE platform that supports numerous frameworks used for the creation of GUI components (such as SWT or JFaces) or for working with data (such as the Eclipse Modeling Framework). One of the most exciting features of Eclips
DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL
(K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Özcan, H. Pirahesh, N. Seemann, A. Singh, T. Truong, R. C. Van der Linden, B. Vickery, C. Zhang, and G. Zhang) Comprehensive and efficient support for XML data management is a rapidly increasi
Creating an Oracle driver for the Radicore Development Infrastructure
(Tony Marston) The software that I write is not intended for just one customer who is locked into a single RDBMS. Instead it can be used by virtually any customer using the RDBMS of their choice. How is this possible? I deliberately designed and built my infrastructure around the 3 Tier Architecture
Quickly clone a database
(David) I really like DB2s ability to quickly restore a backed up database into a new database with a different name in a different location. Just like in SQL Server and easier to do then Oracle.
Convert databases to different platforms using RMAN
(Bob Watkins) The transportable tablespace feature—copying datafiles directly between Oracle instances instead of unloading and loading data—was introduced in Oracle 8i and has grown in functionality ever since. At first, the tablespace to be moved had to have the same block size as the destination
Exploring the Header in the WSE 2.0 SoapEnvelope Class
(Jayaram Krishnaswamy) This article, the second of two parts, continues our exploration of the SoapEnvelope class in WSE2.0 by examining some of its properties and methods. In particular, we focus on manipulating the SoapHeader.
Off-Site DBAs – Alive and Well
(James F. Koopmann) Do you Do remote DBA? I have often wondered about the current status of off-site remote work. I currently am doing full-time work remotely and often joke with my friends about wearing my bunny slippers all day long.