IOTN :: Field Book :: Tibero

ȸ¿ø°¡ÀÔ

java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword

ÃÖ±æÈ£ [LIST]   2016-08-25 17:25:16, Á¶È¸ : 3,384 ./migrator.sh PROPERTY_FILE=sh.sales ================== [E0]1472112816414 - STARTED java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword SQL Trace SELECT T.ROWID,T.PROD_ID,T.CUST_ID,T.TIME_ID,T.CHANNEL_ID,T.PROMO_ID,T.QUANTITY_SOLD,T.AMOUNT_SOLD ROM SH.SALES T PARTITION (SALES_Q4_2003) >> ORA-00924: missing BY keyword SELECT ROWID,PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD FROM SH.SALES PARTITION (SALES_Q4_2003); no rows selected SELECT ROWID,PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD FROM SH.SALES    t     PARTITION (SALES_Q4_2003); ORA-00924: missing BY keyword table_migrator ( PARTITION TABLE ) bug version 18.232.179.37

LIST

CategoryAdminBackup and RecoveryTroubleshootScriptTool	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Troubleshoot	ERROR: bind error (port=8200) [Address already in use]	ÃÖ±æÈ£	2022/02/18	166
Admin	Tibero 5 , SP1, patch, downgrad ¸Þ¸ð	ÃÖ±æÈ£	2021/02/10	2148
Admin	tibero jdbc driver version È®ÀÎ	ÃÖ±æÈ£	2021/02/01	542
Admin	rename db name / TB_SID	ÃÖ±æÈ£	2021/02/01	958
Troubleshoot	T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'	ÃÖ±æÈ£	2021/02/01	5310
Backup and Recovery	alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N	ÃÖ±æÈ£	2021/01/29	407
Troubleshoot	interal dd update failed!! [ patch ÇÊ¿ä ]	ÃÖ±æÈ£	2020/12/20	69859
Backup and Recovery	TBR-1024 : Database needs media recovery	ÃÖ±æÈ£	2020/12/20	2587
Troubleshoot	* Cannot get semaphore:errno=28	ÃÖ±æÈ£	2019/03/06	4298
Backup and Recovery	tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused	ÃÖ±æÈ£	2019/02/15	3704
Troubleshoot	TBR-8033: Specified schema object was not found.	ÃÖ±æÈ£	2018/07/11	157338
Admin	tibero6 ¼öµ¿ ¼³Ä¡	ÃÖ±æÈ£	2018/07/11	25930
Backup and Recovery	TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted	ÃÖ±æÈ£	2017/11/26	2931
Admin	Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]	ÃÖ±æÈ£	2017/09/06	16183
Admin	Tibero ¸ð´ÏÅ͸µ °¡À̵å - TechNet	ÃÖ±æÈ£	2017/09/05	16252
Troubleshoot	java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword	ÃÖ±æÈ£	2016/08/25	3384
Troubleshoot	Oracle dblink Tibero UTF8 DB ÇѱÛó¸®	ÃÖ±æÈ£	2015/09/08	10914

¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö

1 [2]

Copyright 1999-2023 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)