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

Thread: ora-00379

Threaded View

  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
« 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