Kbase 13650: Move Oracle table/index to diff tablespaces? - schemaholder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Move Oracle table/index to diff tablespaces? - schemaholder
The schemaholder is _NOT_ invalidated by moving tables and indexes to
seperate TABLESPACES. The more devices the better.
Better to put table1 on tablespace t1 and its indexes on tablespace
t2. It is better to seperate the tables from their indexes than tables
from other tables. It is even better if the table and indexes can
reside on different controllers.
Progress Software Technical Support Note # 13650