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

/etc/init.d/init.crs start crs_stat -t 增加表字段 alter table 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 GROUP BY 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，即可解除LOCKalter system kill session 738,1429; 修改字段长度 alter table 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 服务端监听文件配置 /opt/oracle/10gR2/db/network/admin/listener.ora listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.148)(PORT = 1521)) ) ) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=zhangrui) (ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1) (SID_NAME=orcl) ) ) oracle 客户端连接配置 /opt/oracle/10gR2/db/network/admin/tnsnames.ora ZHANGRUI = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.148)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zhangrui) ) ) sqlnet.ora配置文件 //sqlnet.ora //NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) CREATE SEQUENCE zrseq INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE 系统权限 grant create session to test; grant create table to te