-
SQL> define default_tablespace='tools'
SQL> define temporary_tablespace='temp'
SQL> !ll statscre*
-rw-r--r-- 1 oracle users 843 Dec 7 1999 statscre.sql
SQL> @statscre.sql
... Installing Required Packages
Package created.
Grant succeeded.
View created.
Package body created.
Package created.
Synonym dropped.
Synonym created.
Grant succeeded.
View created.
create public synonym X$KCBFWAIT for X_$KCBFWAIT
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
-
And you problem is?
Lots of Oracle scripts show this error when run. It just means the object already exists. If it wass necessary to drop it the script would have done an explicit drop. As long as the public synonym is pointing to the correct object you've got nothing to worry about. You can check this using DBA_SYNONYMS.
Cheers
-
Yes, but the problem is because they have set sqlplus to exit when it encounters an error. I edited the script and took out the WHEN SQLERR EXIT statement.
Jeff Hunter
-
Thanks guy's when I realized what was happening, I went in and edit the script as Jeff Hunter suggested
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|