Hi Guys,
This is a small thing. But may be useful.
When we move tables and indexes to another tablespace, what all needs to be done (Oracle queries are used).
1) move the table.
alter table tablename move tablespace tablespacename;
2) now the indexes are of no use. You have to rebuild them in the new table space.
alter index indexname rebuild tablespacename;
3) Finally the packages need to be recompile. There is no need for explicit compilation as during execution it will be recompiled.
alter package packagename compile package;
Thats it!!
Friday, November 2, 2007
Subscribe to:
Post Comments (Atom)
Hmmm... Thats very useful to know.Could you tell me in what situations we would want to move into a different tablespace?
ReplyDeletesee, when you are on a development environment.. there could be lack of space in the current tablespace... or for reasons of standardization you made a new tablespace
ReplyDelete