-
Hi,
I try to install statpack for our Oracle 8.1.6 database
3 times. So far, no luck.
Anyone have successfully installed it?
Thanks,
-
Yes ,
I Installed and tested it in a NT / 8.1.6 environment . Any specific problems? What is the error message
Santhoshkumar
Certified Oracle DBA - 8i
-
Here is the error message (Note I log on as sys):
SQL> @?/rdbms/admin/statscre
... Installing Required Packages
Package created.
Grant succeeded.
View created.
Package body created.
Package created.
Synonym dropped.
Synonym created.
Grant succeeded.
create view X_$KCBFWAIT as select * from X$KCBFWAIT
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
-
Hi,
The indications are that the objects already exist and the script disconnects.You can copy
the $ORACLE_HOME/rdbms/admin/statscre.sql file to another name and REM's out the create statements for those views that the script
was erroring out on since these statements were creating views that already existed. Try this.....
Muthu
[QUOTE][i]Originally posted by sysdba [/i]
[B]Here is the error message (Note I log on as sys):
SQL> @?/rdbms/admin/statscre
... Installing Required Packages
Package created.
Grant succeeded.
View created.
Package body created.
Package created.
Synonym dropped.
Synonym created.
Grant succeeded.
create view X_$KCBFWAIT as select * from X$KCBFWAIT
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production [/B][/QUOTE]
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
|