unusable indexes

[dknight]

Does anyone know the effect on Functions or Procedures that rely on the tables that have been "moved" with the

ALTER TABLE tablename MOVE tablespace

command?

[jdorlon]

After the MOVE command, if you have any objects (procedures, functions, packages, etc) that rely on the table that got MOVEd, the package, procedure, etc will become invalid. You can recompile it if you want with alter...compile
commands, but Oracle will compile them for you when you need to use them as long as there are no errors in the code.