ora-0323 error - help please
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-0323 error - help please

  1. #1
    Join Date
    Sep 2000
    Posts
    23
    Alright lads,

    I have a user getting an ora-03233 error.

    I checked this on OTN and the error means that is unable to allocate an extent of string blocks from tablespace string.

    Can anyone expand on this?

    Also to fix it, it says to increase the value of NEXT for the tablespace, or decrease the value of HASH_MULTIBLOCK_IO_COUNT. Is this all I have to do? What problems shoud I expect?

    Were running 8.1.6 on Solaris.

    Cheers
    Dougie

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Oracle Corporation does not recommend that you set or change the value of this parameter.

    [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch158.htm#3004[/url]

  3. #3
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    Are you sure of the error number.

    For ORA-03233 it says:

    ORA-03233 unable to extend table string.string subpartition string by string in tablespace string

    Cause: Failed to allocate an extent for table subpartition segment in tablespace.

    Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

    HTH

    tycho

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