DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: statspack

  1. #1
    Join Date
    Feb 2001
    Posts
    107
    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

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  4. #4
    Join Date
    Feb 2001
    Posts
    107
    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
  •  


Click Here to Expand Forum to Full Width