move tablespace (ORACLE)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: move tablespace (ORACLE)

  1. #1
    Join Date
    Apr 2005
    Posts
    3

    move tablespace (ORACLE)

    i moved a table (itemmaster) from system tablespace to 'ourdata' tablespace.
    now when i try to read data from the table it says
    index PK_ITEMMASTERID or partition of such index is in unusable state
    Last edited by wpcperera; 04-21-2005 at 06:17 AM. Reason: spelling mistaken

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Have you tried rebuilding the index?

    alter index '<NAME>' REBUILD;
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center