unusable indexes - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: unusable indexes

  1. #11
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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?

  2. #12
    Join Date
    Nov 2000
    Posts
    344
    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
  •  



Click Here to Expand Forum to Full Width