rebuilding a tablespace
From: Mark Aubuchon <aubuchon_at_pangea.Stanford.EDU>
Date: 3 Dec 1994 07:48:10 GMT
Message-ID: <3bp7rq$l6j_at_morrow.stanford.edu>
Date: 3 Dec 1994 07:48:10 GMT
Message-ID: <3bp7rq$l6j_at_morrow.stanford.edu>
Hi There,
I have a tablespace which has grown & grown & grown it must be made up of 17 data files.
And, I must have 20 users with objects in it.
And, many of the tables are fragmented such that some are getting near the 121 extent limit.
I'd like to rebuild the tablespace, but Oracle export only allows me to rebuild the entire database or a single user or a single table.
There MUST be a software package which I can buy (or beg) which will rebuild the tablespace.
Help!
-- Mark AuBuchon ~ Palo Alto, CA ~ email: aubuchon_at_pangea.stanford.edu ~ - The sky's the limit!Received on Sat Dec 03 1994 - 08:48:10 CET