Re: dedicated tablespaces

You may want to create several tablespaces for other reasons such as for backup purposes. A tablespace can be placed in backup mode (basically offline during the backup operation) which will leave the database up and running for the other tables in the other tablespaces.

You may also consider placing the archive tables in their own tablespace and make the tablespace read-only so that users cannot enter or change the data placed into the tables in that tablespace. If you want to enter data into the archive tablespace, you can change the tablespace to normal, add the new archive data, and then change back to read-only.

Another reason to create several tablespaces is to segregate the tables by size of extents. This could be useful for storage management or similar reasons. Received on Tue Apr 20 1999 - 20:10:15 CDT