Unfortunately the partitions are far too big as well.
-FS
>From: "Koivu, Lisa" <lkoivu_at_qode.com>
>To: "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com>,
>"'fred_Fred_1_at_hotmail.com'" <fred_Fred_1_at_hotmail.com>
>Subject: RE: Recovery of table from hot-backup - HELP
>Date: Wed, 10 Jan 2001 15:06:02 -0500
>
>Fred, can you export a partition at a time? Or are the partitions even too
>big?
>
>
>-----Original Message-----
>From: Fred Smith [mailto:fred_fred_1_at_hotmail.com]
>Sent: Wednesday, January 10, 2001 2:36 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Recovery of table from hot-backup - HELP
>
>
>DBAs, (I'm usually just a reader of this list, but here's a go at being a
>poster for once!!!)
>
> I have a question for you DBAs out there that run VLDBs and have some
>good experiences with them. I have hit my max on db_files and maxdatafiles
>and need to free up some files by deleting a few tables. (I can not
>shutdown the database to recreate the controlfile to increase these
>values).
>
> I want to delete a large table I have that spans 10 partitions that are
>each in their own datafile (thus freeing up 10 files). I have a full
>backup
>
>from the first of the month. I want to truncate and drop the table as well
>as each of the OS files making up each partition. MY QUESTION IS: If I
>need emergency access to this table again at a later date is there any way
>that I can pull it from this full backup?? (The table is too large to
>export)
>
>I would assume there is no way since dropping the table would update the
>control file to reflect this change and would eliminate the ability to
>"restore" any object. Is this also true had the table been in read-only
>mode??
>
>Thanks a lot,
> -Fred Smith
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Fred Smith
> INET: fred_fred_1_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
Get your FREE download of MSN Explorer at
http://explorer.msn.com
Received on Wed Jan 10 2001 - 14:48:02 CST
