on 01-15-2010 12:42 PM
Hi.
During th einstallation of solution manager, the table REPOSRC had the primary index not created because of duplicate keys (unknown reason)
Following Note 23237 we try to execute this select for identifying the duplicate keys, but the error SP2-0678 occurs.
Does anybody know how to solve it?
SQL> select alldata.rowid, alldata.*
2 from REPOSRC alldata,
3 (select PROGNAME, R3STATE
4 from REPOSRC
5 GROUP BY PROGNAME, R3STATE
6 HAVING COUNT(*) > 1) keydata
7 where alldata.PROGNAME=keydata.PROGNAME
8 and alldata.R3STATE=keydata.R3STATE;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
SQL>
Kind regards
Dino
Hello Dino,
> SP2-0678: Column or attribute type can not be displayed by SQL*Plus
Let's take a look at the table definition
SQL> desc SAPSR3.REPOSRC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PROGNAME NOT NULL VARCHAR2(120)
R3STATE NOT NULL VARCHAR2(3)
...
...
MAXLINELN NOT NULL NUMBER(5)
DATA BLOB
The problem in your case is that the table REPOSRC has a BLOB column. In this case you get an SP2-0678 by running a query with "alldata.*".
To solve this issue just select the key columns with data type VARCHAR2 (or any other column but not DATA) and it should work:
SQL> select alldata.rowid, alldata.PROGNAME, alldata.R3STATE
from REPOSRC alldata,
(select PROGNAME, R3STATE
from REPOSRC
GROUP BY PROGNAME, R3STATE
HAVING COUNT(*) > 1) keydata
where alldata.PROGNAME=keydata.PROGNAME
and alldata.R3STATE=keydata.R3STATE;
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.