Home » RDBMS Server » Server Administration » catexp.sql
catexp.sql [message #53442] Thu, 19 September 2002 18:22 Go to next message
Anand
Messages: 161
Registered: August 1999
Senior Member
Hi,
I made the mistake of running catexp.sql when logged in as a user. Now all sysnonms dont work.
If i try saying desc user_tables SQLPLUS shuts down on me and generates an error.
OS : Win200
Oracle : 8i

PLEASE HELP. AM IN TROUBLE

Report message to a moderator

Re: catexp.sql [message #53449 is a reply to message #53442] Fri, 20 September 2002 04:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
run the script again as sys

Report message to a moderator

Re: catexp.sql [message #53488 is a reply to message #53442] Mon, 23 September 2002 14:24 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
c:>set oracle_sid=SID

c:>svrmgrl

svrmgrl>connect internal

svrmgrl>@?rdbmsadmincatexp

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Oracle 9i R2 memory configuration
Next Topic: Redo Log Mismatch
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:31:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.