473,396 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

ORA-00604 ORA-04031 while issuing a DROP USER USER_NAME CASCADE statement

Hello,

I received this error message when I issue the drop statement. We are
using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users
within the same session, but this particular user is causing problems.
I flushed the shared pool, but I still received the same error
message. Thank you in advance for your assistance.

drop user DW_031000 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","state objects")
shared_pool_size 20971520

Total System Global Area 53216888 bytes
Fixed Size 730744 bytes
Variable Size 50331648 bytes
Database Buffers 819200 bytes
Redo Buffers 1335296 bytes
Jul 19 '05 #1
1 10411
bl******@yahoo.com (Brett Baloun) wrote in message news:<a4**************************@posting.google. com>...
Hello,

I received this error message when I issue the drop statement. We are
using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users
within the same session, but this particular user is causing problems.
I flushed the shared pool, but I still received the same error
message. Thank you in advance for your assistance.

drop user DW_031000 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","state objects")
shared_pool_size 20971520

Total System Global Area 53216888 bytes
Fixed Size 730744 bytes
Variable Size 50331648 bytes
Database Buffers 819200 bytes
Redo Buffers 1335296 bytes

Hi,

You can try flushing sharedPool . If that doesn't help, you can even
try bouncing the db once.

Keep us posted.

Thanks.
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: red | last post by:
I know this is probably a faq but it is hard to search for this exact problem. When I put this on a php page: <? $link = mysql_connect("localhost", "cardini", "password") or die("Could not...
2
by: frank_lupo | last post by:
I have create user PIPPO: CREATE USER PIPPO; I have create a table: create table aa (id int4); Change owner of table to user PIPPO. alter table aa owner pippo; I drop user PIPPO. Who is...
2
by: memHog | last post by:
I am trying to create a windows application that will perform drag and drop between a usercontrol on a toolbar and a "user document". As the user control is being dragged accross the user...
1
by: Thomas Chille | last post by:
Hello! I have a Problem. A table with a ForeignKeyRef exits. The Name of the field with this FK-Constraint is 'id_employee' because it is referencing the field 'id_employee' in...
6
by: Vivek Khera | last post by:
I have a database which started on Pg 7.1, moved to 7.2 via pg_dump/restore, and ultimately to Pg 7.4 likewise. While it was in 7.2, I added one user and granted access to various tables. After...
2
by: Jan Doggen | last post by:
Hi How can I remove all tables UserName.TblNam1 UserName.TblNam2 UserName.TblNam3 etc with one SQL statement?
1
by: Dawoodmm | last post by:
Hi i have a sight problem with detecting the mouse up in a drag-drop outside a form what i have on my hands is an mdi form with 2 child forms: form1 and form2, both containing a label each. i also...
3
by: sonia.sardana | last post by:
Que-What is the use of CASCADE CONSTRAINTS? Ans-When this clause is used with the DROP command, a parent table can be dropped even when a child table exists. Example create table...
1
by: Brett Baloun | last post by:
Hello, I received this error message when I issue the drop statement. We are using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users within the same session, but this particular...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.