You can put all partitions that you would like to be read only in the read
only tablespaces.
Alex Hillman
-----Original Message-----
Sent: Thursday, June 07, 2001 5:14 PM
To: Multiple recipients of list ORACLE-L
List,
I have implemented Local Managed Tablespaces and Partitioned my data and
indexes by date ranges. The data contains dates from 06-1993 to present and
is about 20 GIG in size.
The question I have is: Can some of the partitions of a table be made "READ
ONLY" and some made "READ WRITE"? Each partition is contained in it's own
datafile. I would like to back up the database and not have to backup the
older data if I can.
I have read the confusing manuals and the cryptic options available list
for the create tablespace, table commands and can't grasp the
LMT,Partitions, Read Only command context.
Any Ideas appreciated.
ROR m���m
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
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: [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: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [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).
