-
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?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|