DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: table rebuild in different tablespace

  1. #1
    Join Date
    Apr 2001
    Ludhiana (Punjab) India


    Hello friends

    I amGurpreet singh sethi a Jr. Dba . I have used the oracle 8i command :

    Alter Table Table_name Move Tablespace

    The user was having unlimited tablespace access to new tablespace but when i connect with that user at sql plus it show me every thing that this table isnow in new tablespace but when i start my program by connecting with taht user it didn't run.

    Please share your valuable exp.

    Gurpreet Singh Sethi

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Probably you have sam indexes on that table that are now in invalid state because of the TABLE MOVE operation. Rebuild those indexes.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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