SEARCHDATABASE.COM | Database Administrator Tips July 17, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Attention Mainframe DBAs! - Quest Central(tm) http://searchDatabase.com/r/0,,4397,00.htm?Quest =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Full text search in T-SQL stored procedures - Oracle: Copy data from one database (SID) to another database - Oracle: Display a number in words - Oracle: Enable all disabled constraints - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free Webcast: Using Oracle9i RAC for continuous availability - Ask the Experts: You tough database questions answered - Featured Topic: Java - DB2 tips wanted! ___________________________________________________________________ ********** Attention Mainframe DBAs! - Quest Central(tm) ********** Ever wish you could be cloned just to get your work done? Now you don't have to! Get Quest Central(tm) for DB2 - complete, integrated database management tools for mainframe and distributed environments-and watch your productivity skyrocket! Download your FREE trial today at http://searchDatabase.com/r/0,,4397,00.htm?Quest ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: IMPLEMENTING FULL TEXT SEARCH IN T-SQL STORED PROCEDURES | Eli Leiba 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835737,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= COPY DATA FROM ONE DATABASE (SID) TO ANOTHER DATABASE | Hemant Bhatt 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837802,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DISPLAY A NUMBER IN WORDS | Srinivas Chittimalla 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci838274,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ENABLE ALL DISABLED CONSTRAINTS | Michael Nazareth 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci838271,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CHECKING THE SYSTEM DRIVE SPACE THRESHOLD | Satish Gopi http://www.searchDatabase.com/tip/1,289483,sid13_gci834312,00.html Here is how to check the system drive space threshold in SQL Server. As the tip details, you first create a stored procedure called System_DriveSpace then execute it as a job with specified paramters. FINDING PATHS IN A MS PROJECT FILE USING PL/SQL | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci820924,00.html Microsoft Project 98 saves a network of defined activities, called a project, in an MPP file. You can save the whole project into an Oracle database and all 38 tables supporting the project definition will be created. Here's how. REMOVING DUPLICATE TUPLES | Ravi Gulati http://www.searchDatabase.com/tip/1,289483,sid13_gci832441,00.html The author presents a table that contains duplicate tuples, which is undesirable. This quick tip removes such duplicate tuples from the relation uing the DELETE command in Oracle SQL*PLUS. SCRIPT TO RECOMMEND VALUES FOR THE SIZE CLAUSE OF THE TWO MAIN DATA DICTIONARY CLUSTERS | Shailesh Yagnik http://www.searchDatabase.com/tip/1,289483,sid13_gci832443,00.html This large Oracle script recommends values for the SIZE clause of the two main data dictionary clusters. Unless this value is customized, there is a significant risk of cluster block chaining in these clusters. TWO WAYS TO DETERMINE THE SIZE OF THE DATABASE | Mohsin Jamil Qureshi http://www.searchDatabase.com/tip/1,289483,sid13_gci823238,00.html Two quick ways to determine the size of your Oracle database. 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 Who: Don Burleson When: July 23, 2002 at 2:00 PM EST (18:00 GMT) Join a world-renowned Oracle guru in this presentation about the latest technologies to ensure high availability for your Oracle systems. >> CLICK: http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL: AVG() function on a date field http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid480442_tax285649,00.html Oracle: When will 8i certification be retired? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid480543_tax289342,00.html DB2: Running instances of a batch program in parallel on partioned tablespace http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479542_tax285651,00.html SQL Server: "Max connections reached" error http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479535_tax285648,00.html Oracle: Restoring data from a .dmp file using the imp command http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479418_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JAVA | SearchDatabase Featured Topic Java continues to build momentum as an enterprise database development language, with Oracle and DB2 coders leading the way. Want to learn more? We have scads of Java, J2EE, JDBC, XML and SQLJ resources inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci790305,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. Unsubscribe from 'Database Administrator Tips' - Simply Reply to this Email with REMOVE 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. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."