| SYSTEM User droped [message #172601] |
Wed, 17 May 2006 05:37  |
a.bilal.shah
Messages: 10
Registered: June 2005
|
Junior Member |
|
|
I have mistakenly drop 'SYSTEM' user. after that i have import another 'system' schema on the database, but still i am facing the following problem.
When i try to drop any user i.e. 'Scott'
then following error appears.
ORA-00604 error occured at recursive SQL level 1
ORA-00942 table or view does not exist
Tell me what can i do to remove this problem.
Ahmed Bilal
|
|
|
|
| Re: SYSTEM User droped [message #172642 is a reply to message #172601] |
Wed, 17 May 2006 08:09  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
My guess is there is no way. I have to admit, this is the first time I ever heard of that happening, so I have no precedent for what I would do other than to rebuild the database.
Importing another SYSTEM schema? That's a good one. Ha! That schema will have metadata about that other database, which is of no good. Might produce some funny results.
I would have to say that your only option is to restore a backup. I wouldn't even think an import would work since it requires SYSTEM tables.
Where was the PL/SQL part of this question?
|
|
|
|
|
|
| Re: SYSTEM User droped [message #172845 is a reply to message #172642] |
Thu, 18 May 2006 05:46 |
a.bilal.shah
Messages: 10
Registered: June 2005
|
Junior Member |
|
|
Many thanks for your reply.
Sir I haven't any cold backup at the moment. I have only dmp of entire database.
Also i can't afford reinstallation.
Pl tell me about the scripts which i can run to remove this problem.
Regards
Ahmed Bilal
|
|
|
|
|
|
| Re: SYSTEM User droped [message #173394 is a reply to message #172889] |
Mon, 22 May 2006 05:02 |
a.bilal.shah
Messages: 10
Registered: June 2005
|
Junior Member |
|
|
I havn't any user data in System schema, but I have many diffrent tablespaces, in which diffrent users data exists.
When I import dmp in new database. it will not create tablespaces autometically and many errors are coming. Due to that all data is not imported. Help Me...
A.B.
|
|
|
|
| Re: SYSTEM User droped [message #173398 is a reply to message #173394] |
Mon, 22 May 2006 05:12 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>it will not create tablespaces autometically
It will, as long as you have the same path for the datfiles (as before). Import will try to recreate the datafiles/tablespace in the same directory locations. If it has any problems with it, your tablespaces will not be created.
Just create a new database.
Install each schema using fromuser/touser clause.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
