(Bob Watkins) Oracle’s export and import utilities have historically used a disk file as intermediate storage when unloading or reloading the database. For large databases, this “dump file” was an issue because operating system limits on file size could be exceeded, making export impossible.
Author: SSWUG Research
Oracle 10.2 Migrations – Account LOCKED(TIMED) and FAILED_LOGIN_ATTEMPTS
(Alex Gorbachev) Recently we’ve had quite a few migrations to 10g Release 2 and several times been hit by one issue – some users consistently get locked with status LOCKED(TIMED). One good example is with the DBSNMP and SYSMAN users, but more important are locked production accounts.
Who Dictates The Future of XML?
(Adam Scheinberg) We are on the brink of a very exciting time. The buzzword-friendly “Web 2.0” is here, and it’s most punctuated by three terms: social networking, AJAX, and RSS. Nothing about these things is inherently new – AJAX existed as an ActiveX control present in Microsoft’s Outlook Web Acce
Processing references to inaccessible documents: Constructing identifiers with Relax NG and XSLT
(Matthijs Breebaart) An increasing amount of information is published for free on the internet. It is tempting for customers of commercial publishers to try to leverage this free information. However, there is no such thing as a free lunch. Knowledge workers continue to rely on the specialized bits
Asked & Answered
(Uri Lifshitz) In a DB2 for z/OS system that comprises tens of thousands of tables (and even more indexes), how can I find out which database tables require maintenance without running a lot of reports?
Understanding Adapter Pattern Using .NET
(David Simmonds) This article examines the usage of Adapter pattern using Visual Basic .NET 2003 with the help of a sample application.
Token Replacement in ASP.NET
(Damon Armstrong) As a web developer, you will encounter situations that call for an effective token replacement scheme. Token replacement is really just a technologically-savvy way of saying string replacement, and involves substituting a “real” value for a “token” value in a string. This article p
Web Control Enhancements in ASP.NET 2.0
(Miguel A. Castro) I’m sure by now you’ve read more than your share of books and articles describing new ASP.NET 2.0 features. Master pages, themes, providers, etc., are all great, but have you read anything regarding what’s changed with custom Web control development? Well that’s what I’m here to t
Set the current working path with VB.NET
(Irina Medvinskaya) An ability to set the current working path often comes in handy if a developer wants to be able to use relative paths instead of absolute paths in the code. In this tip, I explain how to set the current working path using VB.NET.
Exploit XML indexes for XML query performance in DB2 9
(Matthias Nicola) DB2 9 provides pureXML storage and offers XQuery and SQL/XML as query languages. XML indexes are essential for high query performance, but their usage for query evaluation depends on how query predicates are formulated. This article presents a set of guidelines for writing XML quer