Trying to change tablespace and datafile properties on the fly [message #520335] |
Sun, 21 August 2011 23:22 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
G'day,
Long time, no post.
This facility has one last 10g database and a very problematic tablespace and last datafile associated with it.
The tablespace was set up with INITIAL_EXTENT of 131,072 (128K) instead of the more 'normal' 4,194,304 (4M) and NEXT_EXTENT of 262,144 (256K) instead of 4,194,304 (4M).
More worryingly, the datafile has INCREMENT_BY set to 1 (8K) instead of 1,280 (10M) or 2,048 (16M).
Has anyone ever updated sys.ts$.dflinit and sys.ts$.dflincr to modify the INITIAL_EXTENT and NEXT_EXTENT, and sys.file$.inc to modify the INCREMENT_BY?
David
|
|
|
|
|
|
|
|
|
|