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

Thread: ora-00379

  1. 10-05-2005, 01:57 PM #1
    prodadmin
    prodadmin is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 10-05-2005, 05:47 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    do you have a 16k cache configured (and is it big enough)
    Reply With Quote Reply With Quote
  3. 10-07-2005, 06:13 AM #3
    dhar_kiran
    dhar_kiran is offline Junior Member
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    if the cache is configured.. then use alter system checkpoint..
    ~KD.DBA~
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width