The answer is yes & no. First off tablespace data_small will go offline as soon as Oracle realizes that the datafile is gone. At this point any insert, update, or delete that involves a table and/or index in data_small will fail. Therefore there will be no inconsistencies.
Dick Goulet ____________________Reply Separator____________________ Author: "BigP" <[EMAIL PROTECTED]> Date: 1/16/2003 9:29 AM Just wondering what will happen in this condition . supposse I have two tablespaces data_large and data_small . with datafiles data_large01.dbf and data_small01.dbf . some transactions affects tables in both tablespaces . Now one day I lost data_small01.dbf data files . I thought of recovering that data file from one day old backup . when I recover this data data file , will oracle maintain transactio consistency for all transaction happened today . becuase data_large01.dbf is up to date . but data_small01.dbf is one day old . will oracle keep this in mind while applying archived logs at the time of recovery . <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <SCRIPT>function SetDomain(d) { document.domain = d; }</SCRIPT> <META content="MSHTML 6.00.2600.0" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Just wondering what will happen in this condition .</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>supposse I have two tablespaces data_large and data_small . with datafiles data_large01.dbf and data_small01.dbf . some transactions affects tables in both tablespaces . Now one day I lost data_small01.dbf data files . I thought of recovering that data file from one day old backup . </FONT></DIV> <DIV><FONT face=Arial size=2>when I recover this data data file , will oracle maintain transactio consistency for all transaction happened today . becuase data_large01.dbf is up to date . but data_small01.dbf is one day old . will oracle keep this in mind while applying archived logs at the time of recovery .</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).