"Post, Ethan" wrote: > > Or perhaps this... > > Write a program that will manually allocate extents to each object until you > run out of space, then capture error and number of extents and write to a > flat file using UTL_FILE package. Then export object, truncate table and > import to recover the space you allocated during each test. Then use SQL > loader to bring the data from the flat file into the database and write > queries against the X$ constructs to see if you are approaching too many > extents. Use a minimum of 5 .sh scripts and 8 control files to accomplish > this task. From what I have seen this will qualify you for numerous jobs as > a Senior Oracle DBA. > > DISLAIMER: THE ABOVE WAS A JOKE BUT DOES REFLECT THE TYPES OF THINGS I HAVE > SEEN IN THE PAST. > > :)
Reminds me of something which I have seen which basically was a spool to a file of a SELECT * on the various views in the dictionary, wrapped into a shell script and followed by a number of greps ... Why use SELECT when you can grep with regular expressions ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).