yes it's relevant, it explains why you can't use a consistent export only to move the data and have to copy the tablespace as well. It also explains why the tablespace has to be in read-only mode.
--- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > That information is not relevant and should be ignored. I would > expect YOU > to know as much! > > -----Original Message----- > Sent: Thursday, October 10, 2002 1:25 PM > To: Multiple recipients of list ORACLE-L > > > ah! transportable tablespaces? you did't SAY that > > > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > It is not the export per se that causes the problem. It is the > > copying of > > the datafile that is the issue. The tablespace must be made read > only > > so > > that the datafile can be copied in a consistent version. I can > > understand > > (and support) no active tx in the tablespace, but why the whole > > (*#(&*$# > > database? If I need to take INVOICE_1999 tablespace and migrate it > to > > an > > ODS, why does it matter if Joe Accountant is adding an expense > report > > in the > > EXPENSE_2002 ts? > > > > In the Oracle doc, it lists the requirements for making a ts read > > only. On > > the next page it states (verbatim from doc) > > > > "You do not have to wait for transactions to complete before > issuing > > the > > ALTER > > TABLESPACE ... READ ONLY statement. When the statement is issued, > the > > target > > tablespace goes into a transitional read-only mode in which no > > further write > > operations (DML statements) are allowed against the tablespace. > > Existing > > transactions that modified the tablespace are allowed to commit or > > rollback. > > Once > > all transactions (in the database) have completed, the tablespace > > becomes > > read-only." > > > > I love how Oracle buries a very important consideration in the very > > last > > line of a paragraph! > > > > We are on 9ir1, so the TABLESPACE parameter is not helpful, but we > do > > have > > other options. The application architecture is such that I am > pretty > > certain > > very bad things would happen if I tried to but the database in > > restricted > > mode. > > > > Dan > > > > -----Original Message----- > > Sent: Thursday, October 10, 2002 5:09 AM > > To: Multiple recipients of list ORACLE-L > > > > > > so if it's waiting for any active transaction, I guess you could > put > > the database in restricted mode until existing transactions > complete. > > Of course, that sort of defeats the purpose of putting it in > > read-only > > so other people can access it. > > > > um, 9ir2 has an export parameter of "tablespace", if you want it > > "read-only" so nothing changes while you export it, how about using > > the > > consistent=y export parameter in conjunction with the tablespace > > export? > > > > > > --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > > > And with that correction, it seems checking for active > transactions > > > (in > > > v$transaction) would address this. > > > > > > However, by the time one gets a 'green' light from v$transaction > > and > > > issues > > > alter tablespace... there is the slight possibility of someone > > > starting a > > > new transaction locally or just selecting over a dblink... > > > > > > Too bad that the new 'transitional read-only' mode does not allow > a > > > graceful > > > exit... Per the Admin Guide one must set compatible to < 8.1.0 to > > > make the > > > command fail... > > > > > > I would be interested in learning how you tackle this issue as I > am > > > also > > > trying to implement TTS in some of my databases. > > > > > > Thanks. > > > > > > - Kirti > > > > > > -----Original Message----- > > > Sent: Wednesday, October 09, 2002 4:34 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Just a slight correction it will wait until any transaction > against > > > the > > > entire database, not just the tablespace is completed. > > > > > > Ian MacGregor > > > Stanford Linear Accelerator Center > > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > -----Original Message----- > > > Sent: Wednesday, October 09, 2002 1:49 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > I am creating a stored proc that will export a tablespace. One > task > > > it needs > > > to perform is to place the tablespace(s) in read only mode to > make > > a > > > copy. > > > Based upon the application and proc logic, there should not be > any > > > transactions against objects in the ts. However, if there are, > the > > > ALTER > > > TABLESPACE command will wait until the transaction is completed. > I > > > would > > > rather have the ALTER TABLESPACE command fail immediately. If I > > > cannot do > > > that, I would like to be able to test for locks on objects in the > > > tablespace > > > (figured that one out, but it is rather kludgy). > > > > > > Is there a method to force an immediate failure of ALTER > TABLESPACE > > > <tsname> > > > READ ONLY if it cannot be immediatly completed? > > > Is there a clean method/proc to determine if the ALTER TABLESPACE > > > command > > > will work? > > > > > > Dan Fink > > > > > > > > > > > > __________________________________________________ > > Do you Yahoo!? > > Faith Hill - Exclusive Performances, Videos & More > > http://faith.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > 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: Fink, Dan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > services > > > --------------------------------------------------------------------- > === message truncated === __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
