| sys and system [message #271793] |
Wed, 03 October 2007 00:08  |
oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
|
Senior Member |
|
|
Hi
I have oracle 10g database
unknowingly I ran two script catlog.sql and catproc.sql in system user
I had several problems after that, I could rectify/solve some....
.Now my problem is not able to exp the system or whole database backup ..(export..)
can any help me how can i go about solving
I have sys privileges
1.is it possible to delete system user.. then rerun the two script in SYS.
2.do i need to reinstall the software ...
3.there are lots of objects created in system user ... including dictionary object..
4.how can I delete the unnecessary objects in system user
5. what is the your suggestion on this ...
thanxs
its urgent
|
|
|
|
| Re: sys and system [message #271794 is a reply to message #271793] |
Wed, 03 October 2007 00:19  |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
 
|
|
1. possible but doing so will corrupt your database.
2. Yes, I think. Though, You may have tried to delete objects.
4. Drop.
| Quote: | I ran two script catalog.sql and catproc.sql in system user
|
You have to run these two by connecting database with a user by sysdba privilege.
[Updated on: Wed, 03 October 2007 00:22] Report message to a moderator |
|
|
|
| Re: sys and system [message #271798 is a reply to message #271794] |
Wed, 03 October 2007 00:32 |
oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
|
Senior Member |
|
|
hi
later i ran the script in sys
now my question is too reinstall or drop all the unwannted object in system .. if soo
how can i drop those object (is it one by one ... because i dont know which is vaild and invalid)
|
|
|
|
|
|
|
|
| Re: sys and system [message #272326 is a reply to message #272323] |
Thu, 04 October 2007 10:20 |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello...
| oracle_coorgi wrote | .Now my problem is not able to exp the system or whole database backup ..(export..)
|
What about the data on his database?
Regards,
mson77
|
|
|
|
| Re: sys and system [message #272329 is a reply to message #272326] |
Thu, 04 October 2007 10:33 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
@oracle_coorgi
are you able to export schemas separately...
& also for how long you used this database... If you can have the data reloaded.. then best option.. recreate database..
else try contacting oracle support once.. they may be able to help you
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
