oracle赋权限查表空间,oracle创建数据库、表空间、用户、赋权限等基本操作

/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 from USER_TAB_COLS where TABLE_NAME='ICC_DC_TRANS'

查看表

select * from user_tables;

查表表结构

select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns where table_name='ICC_GI_TRANS'

oracle 启动

sqlplus "/as sysdba"

startup

shutdown immediate

lsnrctl start

oracle 服务端监听文件配置