SEARCHDATABASE.COM | Database Administrator Tips July 24, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
July Training Special: XML Bundle http://learn.serebra.com?s=33&I=7061&m=dbxml2701nl&p=c =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Linking SQL Server 2000 to Oracle 8i - SQL Server: Decrypt encrypted stored procedures - Oracle: Log switches per day/hour - Oracle: Metadata API in Oracle 9i - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Webcast: Using Oracle9i RAC for continuous availability - Ask the Experts: You tough database questions answered - Featured Topic: Achieving high availability - DB2 tips wanted! ___________________________________________________________________ *************** July Training Special: XML Bundle ***************** Learn and save more than 80% on this XML training bundle, which combines both the basic and advanced XML courses onto one CD-ROM. Get the course here: http://learn.serebra.com?s=33&I=7061&m=dbxml2701nl&p=c ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: LINKING SQL SERVER 2000 TO ORACLE 8I | Carl Lim Six quick steps to create a Linked Server from SQL Server 2000 to Oracle 8i. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci840247,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= STORED PROCEDURE TO DECRPYT ENCRYPTED STORED PROCEDURES | Eli Leiba This SQL Server code presents a stored procedure called sp_decrypt_sp that is used to decrypt T-SQL stored procedures compiled with the ENCRYPTION option. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837799,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LOG SWITCHES PER DAY/HOUR | Jaco van den Berg Here is an Oracle script that will allow you to view the amount of archived redo logs per day and hour. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835738,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= METADATA API IN ORACLE 9I | Srinivas Chittimalla Users know how difficult it is to get metadata out of Oracle 8i and earlier versions. Fortunately, a new package was introduced in Oracle 9i: DBMS_METADATA. Here are three examples of how to use it. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837903,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IMPLEMENTING FULL TEXT SEARCH IN T-SQL STORED PROCEDURES | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci835737,00.html Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager, but is still worthwhile. Here are the T-SQL steps to take in order to implement FTS in T-SQL. COPY DATA FROM ONE DATABASE (SID) TO ANOTHER DATABASE | Hemant Bhatt http://www.searchDatabase.com/tip/1,289483,sid13_gci837802,00.html It is often very difficult to copy all Oracle tables with data from one SID to another or append all data of one SID to another table of another SID. This can be used, for example, when moving data from a production environment to a test environment, or vice versa. This following command will help. DISPLAY A NUMBER IN WORDS | Srinivas Chittimalla http://www.searchDatabase.com/tip/1,289483,sid13_gci838274,00.html Here's a cool feature in Oracle -- displaying a number in words. It's available from v. 7.3.4.5.0 onward. It works for both small and large numbers. Here are a few examples. ENABLE ALL DISABLED CONSTRAINTS | Michael Nazareth http://www.searchDatabase.com/tip/1,289483,sid13_gci838271,00.html The following short Oracle script enables all disabled constraints. It must be run by Oracle user SYSTEM and has been tested on Oracle 7.3 onwards. 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 GARMIN ETREX GPS: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz836949_cts836948,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE WEBCAST | Using Oracle9i RAC & TAF for continuous availability Don Burleson, a world-renowned Oracle guru and author, gave this excellent presentation on Tuesday about the latest Oracle technologies to ensure high availability for your Oracle systems. Check out this audio streaming webcast, complete with slides and answers to audience questions. >> CLICK: http://searchdatabase.techtarget.com/webcastsTranscriptSecurity/1,289693,sid13_gci833977,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Data warehousing: Rating ETL tools http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid481727_tax288369,00.html DB2: Pulling data from multiple tables, eliminating duplicates http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid481305_tax285651,00.html SQL: Result set row count along with query results http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid480948_tax285649,00.html DB2: Pros and cons of the FLOAT datatype http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid481978_tax285651,00.html SQL: Restricting cyclical references in trees http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid482064_tax289340,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ACHIEVING HIGH AVAILABILITY | SearchDatabase Featured Topic In today's enterprise, databases are mission-critical. Achieving high availability is thus a key goal for DBAs. If you haven't yet reached the "five nines" (99.999% uptime), you'll need these tips, tutorials, and news anaylses... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci839738,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 TIPS NEEDED | SearchDatabase Tip of the Month Contest Attention DB2 DBAs and developers! Share your knowledge, help your peers -- submit a time-saving DB2 tech tip or script. The highest-rated tip in June will win a set of GARMIN ETREX GLOBAL POSITIONING SYSTEM, worth $115! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz836949_cts836948,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."
