RE: Import Table from Full Backup
That was exactly what I said, :) Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Enviado el: Wednesday, December 04, 2002 7:34 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: Import Table from Full Backup In order to use rman to restore a single table you have to restore the tablespace to a clone and then export the table you need and import it to the 'real' database. So yes, it can be done! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 6:53 AM I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 12:39 AM > Hi Listers, > Is it true that I can do an import of a table from a full backup that was > done with RMAN? > That was a comment I heard today and doesn't make sense to me, > any comments? > > Saludos, > Veronica Levin Enriquez > Compañía Cervecera de Nicaragua > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Veronica Levin > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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).
RE: Import Table from Full Backup
Title: RE: Import Table from Full Backup > From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] > > > I'd agree that you can achieve the same result. I think I'd > argue that it's > not a feature of RMAN though. > I can also take that restored table, spool it a text file and > edit it using > MS Word but I wouldn't claim that RMAN can generate Word files. *roll eyes* > Mind you, this is probably word class pedantry on my part =) As the question was can it be done, not is it a feature of, I'd say, yes indeed ;-)
RE: Import Table from Full Backup
The 9i RMAN method is nicer, as the DUPLICATE TARGET DATABASE command now has a SKIP TABLESPACES clause... > Both RMAN and manual methods exist but they're > tacky...Basically you create a new database, recover > just the appropriate datafiles, export the data and > then do what you want with it... > > hth > connor > > --- "Hately, Mike (NESL-IT)" > <[EMAIL PROTECTED]> wrote: > Hi, > > you can recover a tablespace to a point in time. > > That's the only option you > > would have using RMAN. > > > > Regards, > > Mike Hately > > > > -Original Message- > > Sent: 04 December 2002 11:54 > > To: Multiple recipients of list ORACLE-L > > > > > > I think that SQLBackTrack from Precise can restore a > > table from a backup. > > Of course you will need to backup with it, not Rman. > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > Sent: Saturday, November 30, 2002 12:39 AM > > > > > > > Hi Listers, > > > Is it true that I can do an import of a table from > > a full backup that was > > > done with RMAN? > > > That was a comment I heard today and doesn't make > > sense to me, > > > any comments? > > > > > > Saludos, > > > Veronica Levin Enriquez > > > Compañía Cervecera de Nicaragua > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Veronica Levin > > > 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). > > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Yechiel Adar > > 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). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Hately, Mike (NESL-IT) > > 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). > > > > > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "GIVE a man a fish and he will eat for a day. But TEACH > him how to fish, and...he will sit in a boat and drink > beer all day" > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com -- > Author: > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 fro
Re: Import Table from Full Backup
Sorry, as Kirti pointed to me the product belong to BMC. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 1:53 PM > I think that SQLBackTrack from Precise can restore a table from a backup. > Of course you will need to backup with it, not Rman. > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Saturday, November 30, 2002 12:39 AM > > > > Hi Listers, > > Is it true that I can do an import of a table from a full backup that was > > done with RMAN? > > That was a comment I heard today and doesn't make sense to me, > > any comments? > > > > Saludos, > > Veronica Levin Enriquez > > Compañía Cervecera de Nicaragua > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Veronica Levin > > 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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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).
RE: Import Table from Full Backup
I'd agree that you can achieve the same result. I think I'd argue that it's not a feature of RMAN though. I can also take that restored table, spool it a text file and edit it using MS Word but I wouldn't claim that RMAN can generate Word files. Mind you, this is probably word class pedantry on my part =) Cheers, Mike -Original Message- Sent: 04 December 2002 13:34 To: Multiple recipients of list ORACLE-L In order to use rman to restore a single table you have to restore the tablespace to a clone and then export the table you need and import it to the 'real' database. So yes, it can be done! Ruth - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 12:39 AM > Hi Listers, > Is it true that I can do an import of a table from a full backup that was > done with RMAN? > That was a comment I heard today and doesn't make sense to me, > any comments? > > Saludos, > Veronica Levin Enriquez > Compañía Cervecera de Nicaragua > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) 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).
RE: Import Table from Full Backup
Both RMAN and manual methods exist but they're tacky...Basically you create a new database, recover just the appropriate datafiles, export the data and then do what you want with it... hth connor --- "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> wrote: > Hi, > you can recover a tablespace to a point in time. > That's the only option you > would have using RMAN. > > Regards, > Mike Hately > > -Original Message- > Sent: 04 December 2002 11:54 > To: Multiple recipients of list ORACLE-L > > > I think that SQLBackTrack from Precise can restore a > table from a backup. > Of course you will need to backup with it, not Rman. > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Sent: Saturday, November 30, 2002 12:39 AM > > > > Hi Listers, > > Is it true that I can do an import of a table from > a full backup that was > > done with RMAN? > > That was a comment I heard today and doesn't make > sense to me, > > any comments? > > > > Saludos, > > Veronica Levin Enriquez > > Compañía Cervecera de Nicaragua > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Veronica Levin > > 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). > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Yechiel Adar > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hately, Mike (NESL-IT) > 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). > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Re: Import Table from Full Backup
In order to use rman to restore a single table you have to restore the tablespace to a clone and then export the table you need and import it to the 'real' database. So yes, it can be done! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 6:53 AM I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 12:39 AM > Hi Listers, > Is it true that I can do an import of a table from a full backup that was > done with RMAN? > That was a comment I heard today and doesn't make sense to me, > any comments? > > Saludos, > Veronica Levin Enriquez > Compañía Cervecera de Nicaragua > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Veronica Levin > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
RE: Import Table from Full Backup
Hi, you can recover a tablespace to a point in time. That's the only option you would have using RMAN. Regards, Mike Hately -Original Message- Sent: 04 December 2002 11:54 To: Multiple recipients of list ORACLE-L I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 12:39 AM > Hi Listers, > Is it true that I can do an import of a table from a full backup that was > done with RMAN? > That was a comment I heard today and doesn't make sense to me, > any comments? > > Saludos, > Veronica Levin Enriquez > Compañía Cervecera de Nicaragua > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Veronica Levin > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) 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).
Re: Import Table from Full Backup
I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 12:39 AM > Hi Listers, > Is it true that I can do an import of a table from a full backup that was > done with RMAN? > That was a comment I heard today and doesn't make sense to me, > any comments? > > Saludos, > Veronica Levin Enriquez > Compañía Cervecera de Nicaragua > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Veronica Levin > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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).
RE: Import Table from Full Backup
Hi listers, Thanks for the comments to Dennis and Ron; I knew there was something wrong with that comment, but decided to ckeck it out with the list just in case :) thanks for your time! Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Ron Yount [mailto:[EMAIL PROTECTED]] Enviado el: Friday, November 29, 2002 6:54 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: Import Table from Full Backup Veronica, Ah, rumors are a wonderful thing, especially if they turn out to be true in our favor. :-) Not unless it happens to be the only segment in a given tablespace. A tablespace is as granular as an RMAN restore/backup can be set. Even then, if you were to restore the tablespace to a previous point in time, the database would not be happy since it would be different than the control file scn. HTH, -Ron- -Original Message- Levin Sent: Friday, November 29, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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).
RE: Import Table from Full Backup
Veronica, Ah, rumors are a wonderful thing, especially if they turn out to be true in our favor. :-) Not unless it happens to be the only segment in a given tablespace. A tablespace is as granular as an RMAN restore/backup can be set. Even then, if you were to restore the tablespace to a previous point in time, the database would not be happy since it would be different than the control file scn. HTH, -Ron- -Original Message- Levin Sent: Friday, November 29, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount 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).
RE: Import Table from Full Backup
Veronica - No RMAN uses its own format, so only RMAN can do anything with the files it creates. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 29, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Import Table from Full Backup
Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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).