ora-00379
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-00379

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    ora-00379

    i am trying to drop a user

    drop user user1 cascade

    i get the following error

    ora-00604 :error occured at recursive SQL level1
    ora-00379: no free buffers available in buffer pool default for blocksize 16k

    how do i correct this??

    i have version 9i and default block size is 8k but some tblspaces are 16k

    pls help
    Last edited by prodadmin; 10-05-2005 at 02:02 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    do you have a 16k cache configured (and is it big enough)

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    if the cache is configured.. then use alter system checkpoint..
    ~KD.DBA~

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