RE: 11g READ ONLY table
- From: <Paul.Baumgartel@xxxxxxx>
- To: <oralrnr@xxxxxxxxx>, <mwf@xxxxxxxx>
- Date: Mon, 12 Jul 2010 15:38:51 -0400
I doubt it's that complicated. DBA_TABLES now includes a READ_ONLY
column.
Paul Baumgartel
UBS AG
IB Accounting Solutions
400 Atlantic Street
Stamford, CT 06904
203.719.4368
paul.baumgartel@xxxxxxx
www.ubs.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Orlando L
Sent: Monday, July 12, 2010 3:32 PM
To: Mark W. Farnham
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: 11g READ ONLY table
THanks Mark, Connor and Rock. I was not looking for the syntax.
I was looking for an explantion or maybe a paper on the internal details
on how a read write table gets converted to read only. If table has
extents all over a tablespace does Oracle mark the extent headers of the
table as READ ONLY which prevents future updates?
If it was a simple task I wonder why Oracle did not have this feature in
older versions.
I am also checking to see if people have used this feature in their
envorinments. If so i want to see how efficient it is or any lessons
learned type of things.
On Fri, Jul 9, 2010 at 12:38 PM, Mark W. Farnham <mwf@xxxxxxxx> wrote:
... is what is confusing you. They are just different things.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark W. Farnham
Sent: Friday, July 09, 2010 1:33 PM
To: oralrnr@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: 11g READ ONLY table
Ric and Connor gave you the mechanics of this. But I suspect
from the way you phrased your question that the difference between a
table that Oracle is protecting from changes (READ ONLY table) and a
tablespace that you don't have to back up any more.
mwf
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Orlando L
Sent: Wednesday, July 07, 2010 11:20 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 11g READ ONLY table
List
Does anyone know how 11g is able to convert read write tables to
READ ONLY and back when the extents are all over mixed in with other
tables in a tablespace?
Orlando.
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
Other related posts:
