Partition recovery question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 21 Feb 2003 06:19:16 -0800
Message-ID: <F001.00554361.20030221061916@fatcity.com>

I lost a data file that contained the tablespace for an empty partition. I dropped the datafile from Oracle, and the table itself seems okay, but I'm wondering what I can do with that partition. Can I simply merge that partition with another partition? Any ideas especially if you've encountered a similar situation would be welcome.  

Oracle 8.1.6
Alpha Tru64
Range partitions  

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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). Received on Fri Feb 21 2003 - 08:19:16 CST