| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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
-- 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-LReceived on Wed Jan 10 2001 - 14:06:02 CST
(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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Recovery of table from hot-backup - HELP</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Fred, can you export a partition at a time? Or = are the partitions even too big?</FONT> </P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Fred Smith [<A = HREF=3D"mailto:fred_fred_1_at_hotmail.com">mailto:fred_fred_1_at_hotmail.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, January 10, 2001 2:36 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Recovery of table from hot-backup - = HELP</FONT> </P> <BR> <P><FONT SIZE=3D2>DBAs, (I'm usually just a reader of this list, = but here's a go at being a </FONT> <BR><FONT SIZE=3D2>poster for once!!!)</FONT> </P> <P><FONT SIZE=3D2> I have a question for you DBAs out there = that run VLDBs and have some </FONT> <BR><FONT SIZE=3D2>good experiences with them. I have hit my max = on db_files and maxdatafiles </FONT> <BR><FONT SIZE=3D2>and need to free up some files by deleting a few = tables. (I can not </FONT> <BR><FONT SIZE=3D2>shutdown the database to recreate the controlfile to = increase these values). </FONT> <BR><FONT SIZE=3D2> I want to delete a large table I have that = spans 10 partitions that are </FONT> <BR><FONT SIZE=3D2>each in their own datafile (thus freeing up 10 = files). I have a full backup </FONT> <BR><FONT SIZE=3D2>from the first of the month. I want to = truncate and drop the table as well </FONT> <BR><FONT SIZE=3D2>as each of the OS files making up each = partition. MY QUESTION IS: If I </FONT> <BR><FONT SIZE=3D2>need emergency access to this table again at a later = date is there any way </FONT> <BR><FONT SIZE=3D2>that I can pull it from this full backup?? =
(The table is too large to </FONT>
<BR><FONT SIZE=3D2>export)</FONT> </P> <P><FONT SIZE=3D2>I would assume there is no way since dropping the = table would update the </FONT> <BR><FONT SIZE=3D2>control file to reflect this change and would = eliminate the ability to </FONT> <BR><FONT SIZE=3D2>"restore" any object. Is this also = true had the table been in read-only </FONT> <BR><FONT SIZE=3D2>mode??</FONT> </P> <P><FONT SIZE=3D2>Thanks a lot,</FONT> <BR><FONT SIZE=3D2> -Fred Smith</FONT> <BR><FONT = SIZE=3D2>_______________________________________________________________= __</FONT> <BR><FONT SIZE=3D2>Get your FREE download of MSN Explorer at <A = HREF=3D"http://explorer.msn.com" = TARGET=3D"_blank">http://explorer.msn.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Fred Smith</FONT> <BR><FONT SIZE=3D2> INET: fred_fred_1_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |