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

Thread: table rebuild in different tablespace

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

    Exclamation

    Hello friends

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

    Alter Table Table_name Move Tablespace
    Tablespace_name;

    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.

    Thanks
    Gurpreet Singh Sethi

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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