SVRMGR> desc sapr3.dbtablog;
Column Name Null? Type
------------------------------ -------- ----
LOGDATE NOT NULL VARCHAR2(8)
LOGTIME NOT NULL VARCHAR2(6)
LOGID NOT NULL VARCHAR2(18)
TABNAME NOT NULL VARCHAR2(30)
LOGKEY NOT NULL VARCHAR2(250)
HOSTNAME NOT NULL VARCHAR2(20)
USERNAME NOT NULL VARCHAR2(12)
TCODE NOT NULL VARCHAR2(20)
PROGNAME NOT NULL VARCHAR2(40)
OPTYPE NOT NULL VARCHAR2(1)
DATALN NOT NULL NUMBER(5)
LOGDATA LONG RAW
SVRMGR> select * from sapr3.dbtablog where tabname like '%T028%';
ORA-00932: inconsistent datatypes

however, if i specify column instead of a *, there is no error of 932. Please advise.