Defrag the darn thing
Date: Mon, 23 Nov 1992 19:15:13 GMT
Message-ID: <1992Nov23.191513.16204_at_infonode.ingr.com>
Had a (flawed) strategy to defrag a tablespace in the db.
The problem was in step (2) - dropping a 300MB tablespace (non-empty)
generated so many transactions that I got the infamous "snapshot too
old" error. I have 10 rollback seg's in their own (20MB) tablespace. The
whole deal is on raw files.
I also read here about another strategy - create a table whose "initial"
parm is equal to the sum of all freespace extents in the db - the idea
was that the db would "collect the smaller extents into one big one",
and then you would drop the table. I tried this idea without success -
came back with "unable to allocate extent of size XXX" where XXX was
the sum of all freespace in the tablespace.
Any ideas?? Should the second strategy work??
JJ
^^^^^^^^^ Jack Jolly _at_ jjolly_at_jjolly.b24a.ingr.com
(| 0 - |)
| * | Intergraph Corporation, Huntsville AL
\_______/ AEC Project Management Support
Received on Mon Nov 23 1992 - 20:15:13 CET