moving tables from system tablespace
- From: GS <GS@xxxxxx>
- Date: Tue, 29 Apr 2008 21:25:39 GMT
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
.
- Prev by Date: Converting a textual day of month using TO_DATE, ORA-01858
- Next by Date: Question about shrinking sga_target.
- Previous by thread: Converting a textual day of month using TO_DATE, ORA-01858
- Next by thread: Question about shrinking sga_target.
- Index(es):
Relevant Pages
|
