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
Last edited by prodadmin; 10-05-2005 at 03:02 PM.
do you have a 16k cache configured (and is it big enough)
if the cache is configured.. then use alter system checkpoint..
Click Here to Expand Forum to Full Width