| Running CATALOG.SQL and Catexp.sql [message #346278] |
Mon, 08 September 2008 01:10  |
virmahi
Messages: 266
Registered: April 2008
Location: India
|
Senior Member |
|
|
Hi,
I am new to export and import. I was facing some problem with export option. I looked into google and found that I should run the file catexp.sql and catalog.sql.
I ran the sql catexp.sql but after I executed the file, I realized that the username with which I had logged in didn't had DBA rights. So I saw many messages which alerted that DBA permission is required. And many objects got created and many not due to permission problem. I didn't knew what to do and I closed the window of Sql*Plus.
The problem with export was due to something else and I was able to export. But later in the evening I found that when I reconnected the database I started getting errors like:
ORA-00980 synonym translation is no longer valid
ORA-04063: view "WYETH.V_$OPTION" has errors
There are other databases too on the same server and they all are getting this error.
I don't know what happenend and how to correct this.
Further I looked at the link:
http://www.orafaq.com/wiki/Export
and found that :
| Quote: | To use export utility CATEXP.SQL or CATALOG.SQL (which in turn call CATEXP.SQL) must be run after the database has been created. CATEXP.SQL has to be run only once when the database is created. In case CATEXP.SQL was not called by CATALOG.SQL (due to CATALOG.SQL not finding the file CATEXP.SQL where it needs), you can run CATEXP.SQL as user SYS. Be careful not to run CATALOG.SQL once again as it might destroy your data dictionaries.
|
I am afraid if I had done a blunder mistake.
Please help me in correcting the mistake I have done.
Regards,
Mahi
[Updated on: Mon, 08 September 2008 01:15] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Running CATALOG.SQL and Catexp.sql [message #346285 is a reply to message #346281] |
Mon, 08 September 2008 01:26  |
virmahi
Messages: 266
Registered: April 2008
Location: India
|
Senior Member |
|
|
I thought of restarting the server and rerun the script catalog.sql, catproc.sql and catexp.sql as sysdba.
But do I need to drop the user Wyeth. Is it needed or it can work without dropping the user wyeth because it's a schema which is very important.
|
|
|
|
|
|
| Re: Running CATALOG.SQL and Catexp.sql [message #346332 is a reply to message #346291] |
Mon, 08 September 2008 04:29 |
virmahi
Messages: 266
Registered: April 2008
Location: India
|
Senior Member |
|
|
Hi Michel,
As I told you in my first post that I am new to this and need your help on this. I can't recreate the database. There is little scope of making changes to it.
Thats why I asked you if dopping of the Wyeth user is essential. Also please tell me as why this user needs to be dropped. And if I have to drop it anyway then what should I do after these steps to get wyeth user back :
Drop the user, connect as SYS and rerun the scripts.
I am sorry for asking such questions but please bear with me as I do not want to make any further mistakes and the wyeth user too is needed back in case I drop it.
Regards,
Mahi
|
|
|
|
|
|
|
|
| Re: Running CATALOG.SQL and Catexp.sql [message #349637 is a reply to message #349630] |
Mon, 22 September 2008 08:02 |
 |
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
You have to process by subtraction: assume that all objects that in this schema are not yours shoud be SYS ones in wrong place.
If you don't know what are your objects, you are out of luck.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
