Thanks to all who responded.
As I was driving in to work this am, I realized that in my table and index creations
I had in fact placed each partition on it's own tablespace and I could make the
tablespace READ ONLY and that would make the partition READ ONLY.
I must have been really tired when I posted the question. It has taken me the most of
2 weeks to configure the datafiles, tablespaces, and tables correctly to eliminate
fragmentation and size them correctly. Not easy to take a 70 GIG database and bring it
over to a 2 disk test server.
Now I have to try and get the hardware to do backups....
Thanks Again.
ROR m���m
>>> [EMAIL PROTECTED] 06/08/01 06:25AM >>>
Another alternative - as each partition has its "own datafile", how about
giving each partition its own tablespace? all you need then is a simple
alter tablespace <tablespace> read only;
Not sure if this is applicable to your situation, but I would consider it..
Mark
-----Original Message-----
Alex
Sent: Thursday, June 07, 2001 11:09
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
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: 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).
