/etc/init
d/init
crs start crs_stat -t 增加表字段 altertable ICC_TERMINAL_CONF add GC_TYPE char(1); SELECT T
GI_SERIAL_NUM,(MAX(T
GROW_WEIGHT )-MIN(T
VEHICLE_WEIGHT)) ABC FROM ICC_GI_TRANS T WHERE T
GI_SERIAL_NUM='000001' GROUPBY T
GI_SERIAL_NUM 1
查看被锁的表 SELECT p
spid, a
serial#, c
object_name, b
session_id, b
oracle_username, b
os_user_name FROM v$process p, v$session a, v$locked_object b, all_objects c WHERE p
addr = a
paddr AND a
process = b
process AND c
object_id = b
object_id 查看锁表进程SQL 语句2： select * from v$session t1, v$locked_object t2 where t1
sid = t2
SESSION_ID; 杀掉锁表进程： 如有記錄則表示有lock，記錄下 SID 和 serial# ，將記錄的ID 替換下面的738,1429，即可解除 LOCK alter system kill session '738,1429'; 修改字段长度 altertable ICC_GC_TRANS modify SOURCE_CODE char(9); 查表结构 select COLUMN_NAME,DATA_TYPE fro
