alter table ALI_TPCRM_ACCESS_AREA modify SCOPE VARCHAR2(4000);
alter table ALI_TPCRM_ACCESS_AREA modify SCOPE VARCHAR2(4000)
*
ERROR at line 1:
ORA-00904: : invalid identifier
跟踪文件如下：
WAIT #1: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117315834718
WAIT #1: nam='SQL*Net message from client' ela= 220 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117315848916
=====================
PARSING IN CURSOR #3 len=52 dep=0 uid=28 ct=47 lid=28 tim=1294117315849030 hv=1029988163 ad='7efced68' sqlid='9babjv8yq8ru3'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #3:c=0,e=54,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1294117315849026
BINDS #3:
Bind#0
oacdty=123 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=4000 ff=0
kxsbbbfp=2a97077338 bln=4000 avl=00 flg=15
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=2a970786d8 bln=22 avl=22 flg=05
value=###
An invalid number has been seen.Memory contents are :
Dump of memory from 0x0000002A970786D8 to 0x0000002A970786EE
2A970786D0 000102C2 00000000 [........]
2A970786E0 00000000 00000000 00000000 00000000 [................]
WAIT #3: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117315849492
EXEC #3:c=0,e=380,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1294117315849529
*** 2011-01-04 13:02:01.410
WAIT #3: nam='SQL*Net message from client' ela= 5561255 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321410848
CLOSE #1:c=0,e=13,dep=0,type=1,tim=1294117321410997
CLOSE #3:c=0,e=24,dep=0,type=3,tim=1294117321411042
=====================
PARSE ERROR #1:len=61 dep=0 uid=28 ct=15 lid=28 tim=1294117321411384 err=904
alter table ALI_TPCRM_ACCESS_AREA modify SCOPE varchar2(4000)
WAIT #1: nam='SQL*Net break/reset to client' ela= 33 driver id=1650815232 break?=1 p3=0 obj#=-1 tim=1294117321411510
WAIT #1: nam='SQL*Net break/reset to client' ela= 90 driver id=1650815232 break?=0 p3=0 obj#=-1 tim=1294117321411617
WAIT #1: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321411636
WAIT #1: nam='SQL*Net message from client' ela= 154 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321411834
=====================
PARSING IN CURSOR #3 len=52 dep=0 uid=28 ct=47 lid=28 tim=1294117321411911 hv=1029988163 ad='7efced68' sqlid='9babjv8yq8ru3'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #3:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1294117321411909
BINDS #3:
Bind#0
oacdty=123 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=4000 ff=0
kxsbbbfp=2a970737e8 bln=4000 avl=00 flg=15
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=2a970782c0 bln=22 avl=22 flg=05
value=###
An invalid number has been seen.Memory contents are :
Dump of memory from 0x0000002A970782C0 to 0x0000002A970782D6
2A970782C0 000102C2 00000000 00000000 00000000 [................]
2A970782D0 00000000 00000000 [........]
WAIT #3: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321412355
EXEC #3:c=0,e=358,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1294117321412395
*** 2011-01-04 13:02:13.406
WAIT #3: nam='SQL*Net message from client' ela= 11993637 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117333406087
CLOSE #1:c=0,e=36,dep=0,type=0,tim=1294117333406259
CLOSE #3:c=0,e=28,dep=0,type=3,tim=1294117333406303
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=28 ct=42 lid=28 tim=1294117333406523 hv=2217940283 ad='0' sqlid='06nvwn223659v'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=168,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1294117333406521
EXEC #1:c=1000,e=350,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1294117333406925
alter table ALI_TPCRM_ACCESS_AREA modify SCOPE VARCHAR2(4000)
*
ERROR at line 1:
ORA-00904: : invalid identifier
跟踪文件如下：
WAIT #1: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117315834718
WAIT #1: nam='SQL*Net message from client' ela= 220 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117315848916
=====================
PARSING IN CURSOR #3 len=52 dep=0 uid=28 ct=47 lid=28 tim=1294117315849030 hv=1029988163 ad='7efced68' sqlid='9babjv8yq8ru3'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #3:c=0,e=54,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1294117315849026
BINDS #3:
Bind#0
oacdty=123 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=4000 ff=0
kxsbbbfp=2a97077338 bln=4000 avl=00 flg=15
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=2a970786d8 bln=22 avl=22 flg=05
value=###
An invalid number has been seen.Memory contents are :
Dump of memory from 0x0000002A970786D8 to 0x0000002A970786EE
2A970786D0 000102C2 00000000 [........]
2A970786E0 00000000 00000000 00000000 00000000 [................]
WAIT #3: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117315849492
EXEC #3:c=0,e=380,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1294117315849529
*** 2011-01-04 13:02:01.410
WAIT #3: nam='SQL*Net message from client' ela= 5561255 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321410848
CLOSE #1:c=0,e=13,dep=0,type=1,tim=1294117321410997
CLOSE #3:c=0,e=24,dep=0,type=3,tim=1294117321411042
=====================
PARSE ERROR #1:len=61 dep=0 uid=28 ct=15 lid=28 tim=1294117321411384 err=904
alter table ALI_TPCRM_ACCESS_AREA modify SCOPE varchar2(4000)
WAIT #1: nam='SQL*Net break/reset to client' ela= 33 driver id=1650815232 break?=1 p3=0 obj#=-1 tim=1294117321411510
WAIT #1: nam='SQL*Net break/reset to client' ela= 90 driver id=1650815232 break?=0 p3=0 obj#=-1 tim=1294117321411617
WAIT #1: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321411636
WAIT #1: nam='SQL*Net message from client' ela= 154 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321411834
=====================
PARSING IN CURSOR #3 len=52 dep=0 uid=28 ct=47 lid=28 tim=1294117321411911 hv=1029988163 ad='7efced68' sqlid='9babjv8yq8ru3'
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
END OF STMT
PARSE #3:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1294117321411909
BINDS #3:
Bind#0
oacdty=123 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=4000 ff=0
kxsbbbfp=2a970737e8 bln=4000 avl=00 flg=15
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 ff=0
kxsbbbfp=2a970782c0 bln=22 avl=22 flg=05
value=###
An invalid number has been seen.Memory contents are :
Dump of memory from 0x0000002A970782C0 to 0x0000002A970782D6
2A970782C0 000102C2 00000000 00000000 00000000 [................]
2A970782D0 00000000 00000000 [........]
WAIT #3: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117321412355
EXEC #3:c=0,e=358,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1294117321412395
*** 2011-01-04 13:02:13.406
WAIT #3: nam='SQL*Net message from client' ela= 11993637 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1294117333406087
CLOSE #1:c=0,e=36,dep=0,type=0,tim=1294117333406259
CLOSE #3:c=0,e=28,dep=0,type=3,tim=1294117333406303
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=28 ct=42 lid=28 tim=1294117333406523 hv=2217940283 ad='0' sqlid='06nvwn223659v'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=168,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1294117333406521
EXEC #1:c=1000,e=350,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1294117333406925
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22034023/viewspace-683240/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORA-01442，又遭遇疑难杂症
下一篇：
连接条件字符类型不一样。
请登录后发表评论
登录
全部评论
