Message-Id: <10737.126324@fatcity.com> From: "Koivu, Lisa" Date: Wed, 10 Jan 2001 15:06:02 -0500 Subject: RE: Recovery of table from hot-backup - HELP This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07B40.C6AE1156 Content-Type: text/plain 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@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@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@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). ------_=_NextPart_001_01C07B40.C6AE1156 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Recovery of table from hot-backup - HELP

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@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@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@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 =