SEARCHDATABASE.COM | Database Administrator Tips August 28, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Master today's most popular database and put yourself in demand! http://searchDatabase.com/r/0,,5243,00.htm?OracleProfLibrary =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Craig Mullins answers your database administration questions - Oracle: Login without knowing password - Oracle: Last DDL time by tablespace - SQL Server: Stored procedure to export/import images - DB2: Delete records to improve performance -- Take 2 - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: 500 free DBMS tips and scripts - Send us your SQL Server tips, win a prize! ___________________________________________________________________ ******************** Sponsored by Doubleday *********************** The Oracle 9i Professional Library -- a 3-volume, 1-CD-ROM set -- a $169.97 value -- can be yours for $9.99, with membership in Computer Books Direct! This insider's library will give you the most up-to-date security tips for your Oracle database as well as the latest information on the newest Oracle 9i tools! Click for details! http://searchDatabase.com/r/0,,5243,00.htm?OracleProfLibrary ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: CRAIG MULLINS ANSWERS YOUR DATABASE ADMINISTRATION QUESTIONS On August 16, 2002, data management expert and author Craig Mullins gave an excellent Webcast on SearchDatabase titled Database Administration 101. Here are answers to audience questions that Craig didn't have time to address. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci846889,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LOGIN WITHOUT KNOWING PASSWORD | Srini Madhamshetty Here's how to log into a user's account to make a change without knowing the password of that user. For Oracle DBAs only! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845037,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LAST DDL TIME BY TABLESPACE | Database Person There are times when one may need to know when the last DDL was performed on a particular Oracle tablespace. Here's how to find out. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci820930,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= STORED PROCEDURE TO EXPORT/IMPORT IMAGES TO SQL SERVER | Eli Leiba This stored procedure serves as an interface to the TextCopy utility that exports and imports images and documents to SQL Server. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835742,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GET RID OF DELETED RECORDS AND IMPROVE PERFORMANCE -- TAKE 2 Here is a follow-up, with important clarifications and additions, to John Kohan's recent tip about how to remove deleted files to increase the performance of DB2 on AS/400. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci847122,00.html >> Here's the original tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci838011,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USING JAVA STORED PROCEDURES: AOL INSTANT MESSAGING FROM ORACLE http://www.searchDatabase.com/tip/1,289483,sid13_gci845712,00.html By Bradley D. Brown. Have you been wondering how you might use Java stored procedures instead of Oracle's native PL/SQL stored procedures? This article discusses the pros and cons of Java stored procedures, guidelines on how to build them, database vs. app server Java, performance considerations, troubleshooting, and rollout/security aspects. The final section of this paper includes a Java stored procedure example that allows you to send instant messages from the database. Very cool! FIND TABLESPACES IN BACKUP MODE | Kavita Mital http://www.searchDatabase.com/tip/1,289483,sid13_gci845236,00.html Often in Oracle, backups fail if one or more of the tablespaces is already in backup mode. The following script can be used to determine if any of the tablespaces are in backup mode and then you can use the 'alter tablespace end backup' command to bring those tablespaces out of backup mode. DATABASE LINK WITHOUT SQL*NET STRING | Syed Ali http://www.searchDatabase.com/tip/1,289483,sid13_gci845230,00.html You can create an Oracle database link without having a SQL*NET string in your tnsnames.ora file. Here's how. RETRIEVING THE ROW FOR THE NTH LARGEST PARAMETRIC COLUMN IN A PARAMETRIC TABLE | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci832440,00.html This SQL Server code returns the row corresponding to the Nth largest value for a given column name in a given table. EXTRACT DATA FROM DB2 ON MVS FROM WITHIN DB2 UDB | Rich Graff http://www.searchDatabase.com/tip/1,289483,sid13_gci845207,00.html Use this script to extract data from DB2 on MVS from within DB2 UDB on AIX. DELETE RECORDS AND IMPROVE DB2 PERFORMANCE | John Kohan http://www.searchDatabase.com/tip/1,289483,sid13_gci838011,00.html how to remove deleted files to increase the performance of DB2 on AS/400. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a SonicBlue MP3 Player: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz843445_cts843442,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL Server: Setting an unlimited size for a column http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487559_tax285648,00.html Oracle: Handling time data formats in conversion from DB2 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487548_tax285650,00.html SQL: Outer join with three or more tables http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487072_tax289340,00.html DB2: Preventing CICS transaction update from rolling back if stored procedure fails http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487067_tax285651,00.html Oracle: Foreign keys across database instances http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487537_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 500 DBMS TIPS AND SCRIPTS | SearchDatabase Featured Topic Looking for that perfect script that will make your life as a DBA or database developer just a tad easier? Well, you've come to the right place. We offer over 500 Oracle, DB2, SQL Server and SQL tips, free for the taking. Enjoy! >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci846574,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER TIPS NEEDED | SearchDatabase Tip of the Month Contest Attention SQL Server DBAs and developers! Share your knowledge, help your peers -- submit a time-saving SQL Server tech tip or script. The highest-rated tip in August will win a SONICblue Rio 600 MP3 Player, worth $115! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz843445_cts843442,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
