moving tables from system tablespace
Date: Tue, 29 Apr 2008 21:25:39 GMT
Message-ID: <nnMRj.3224$XI1.2691@edtnps91>
Checking out a new vendor installed database I see that there are
several tables residing in the system tablespace, non have any LOB or
BLOB columns. There is also a few indexes that have somehow ended up in
the same tablespace. Having never had to use "alter table move" before,
I am thinking this is the best way to move said tables to a proper
tablespace, but from what I understand the indexes with these
tablespaces will be rendered useless and have to be rebuilt as well.
This is also one of the first databases I look after to be installed on 10GR2 - and I thought that perhaps the re-org option in EM might allow me to do all in one fell swoop, but the GUI has no provision for switching tablespaces.
Is just issuing an "alter table move <new tablespace>" then rebuilding all the indexes one at a time the best way to go about this?
thanks Received on Tue Apr 29 2008 - 16:25:39 CDT