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

Thread: Urgent??

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    I keep getting an error message:

    ORA-01688: unable to extend table MYTABLE partition MYPARTITIONby 187500 in tablesp
    ace MYTABLESPACE

    and there is 600M available. Does anyone know what is going on?

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Originally posted by lesstjm
    I keep getting an error message:

    ORA-01688: unable to extend table MYTABLE partition MYPARTITIONby 187500 in tablesp
    ace MYTABLESPACE

    and there is 600M available. Does anyone know what is going on?
    Hi,

    187500 is number of Blocks and if you have block size of 8192 than 187500 * 8192 = 1536000000 which is 1465 MB.

    So, 600M available is not enough. Add more datafiles of atleast total 1465 M.

    Good luck.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

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