| strange issue ....!!! [message #146466] |
Thu, 10 November 2005 11:52  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
we need to drop the user.
while doing so , we get the errors as follows
i could not able to drop the users
SQL> drop user mobile_admin1 cascade;
drop user mobile_admin1 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
db-->9i
os-->linux
Plz help out...!!
regards
bala
|
|
|
|
|
|
|
|
|
|
| Re: strange issue ....!!! [message #146691 is a reply to message #146667] |
Sat, 12 November 2005 07:24  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
The alert log is clear with no errors indicating.
I have enabled sql trace and analysed the trace file which contains error after trying to drop the user as follows.
ora-00604,ora-00942,ora-06512
table SDO_GEOM_METADATA_TABLE does n't exist and i also crosschecked that the object is not there...
how to fix the issue..?
Metalink says to raise an iTAR as my account is not having the rights to raise TAR.
so plz help it out...
|
|
|
|
|
|
|
|
|
|
| Re: strange issue ....!!! [message #146815 is a reply to message #146786] |
Mon, 14 November 2005 01:14 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
there is no user like MDSYS exists...
SQL> drop user mdsys cascade;
drop user mdsys cascade
*
ERROR at line 1:
ORA-01918: user 'MDSYS' does not exist
how to proceed further...?
plz guide..
|
|
|
|
| Re: strange issue ....!!! [message #146832 is a reply to message #146815] |
Mon, 14 November 2005 02:00 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
the spatial objects are installed in SYS.
how to remove those objects..?
It could not be dropped when attempted..!
How to remove spatial options from sys...?
Plz help out..!!
|
|
|
|
| Re: strange issue ....!!! [message #146877 is a reply to message #146832] |
Mon, 14 November 2005 06:59 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
seems someone was playing around with spatial data options.
and
>>the spatial objects are installed in SYS
How can you say that?
Post what you have did.
Take a complete backup.
create a new tablespace of permanent type (LMT)
Move all the spatial objects to new tablespace.
try to do your business ( dropping mobile user).
if it fails,
rerun catmd.sql
and try again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
