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)","sta te objects")
shared_pool_siz e 20971520
Total System Global Area 53216888 bytes
Fixed Size 730744 bytes
Variable Size 50331648 bytes
Database Buffers 819200 bytes
Redo Buffers 1335296 bytes
1  10470  bl******@yahoo. com (Brett Baloun) wrote in message news:<a4******* *************** ****@posting.go ogle.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)","sta te objects")
shared_pool_siz e 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 connect : " . mysql_error());
echo "Connected successfully\n";
mysql_select_db("articles") or die("Could not select database");
|
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 the owner of the table?
|
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 document, I would like the image of
the user document to be displayed.
The behavior of the dragged item needs to be not unlike that of the cards in
solitare. I can do the standard drag & drop stuff but don't know how to
change the dragged items shape...
|
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 'public.sd_employee'. I drop this column of the
table with cascade in a script:
ALTER TABLE public.sd_messaging_participant DROP COLUMN id_employee CASCADE;
|
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 the 7.4 migration, that user was no longer needed, so
was removed via "dropuser" command line tool.
Now, when I pg_dump that db using the version 7.4.5 tools, I cannot
restore because there are still grants in there for this phantom user:
| | |
by: Jan Doggen |
last post by:
Hi
How can I remove all tables
UserName.TblNam1
UserName.TblNam2
UserName.TblNam3
etc
with one SQL statement?
|
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 have a separate class (global vars) contining static members to pass data between forms.:
MDI parent:
. form1
. form2
. globalvars
form1:
|
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 primary1(roll int primary key,name varchar)
insert into primary1 values(1,'A')
insert into primary1 values(2,'B')
select * from primary1
|
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 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
*
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
