Home » RDBMS Server » Server Administration » sys and system
sys and system [message #271793] Wed, 03 October 2007 00:08 Go to next message
oracle_coorgi
Messages: 185
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
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 #271804 is a reply to message #271798] Wed, 03 October 2007 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop the database and recreate it.

Regards
Michel
Re: sys and system [message #272323 is a reply to message #271804] Thu, 04 October 2007 10:06 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
2.do i need to reinstall the software ...


No need to reinstall software.

Dropping & recreating database will do.


--Girish
Re: sys and system [message #272326 is a reply to message #272323] Thu, 04 October 2007 10:20 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Upgrade 9iR2 to 10gR2 on different platform
Next Topic: Identifying Unused Schema/Tables
Goto Forum:
  


Current Time: Sat Dec 03 09:56:29 CST 2016

Total time taken to generate the page: 0.07375 seconds