moving tables from system tablespace

From: GS <>
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

Original text of this message