08 2016 档案
摘要:imp testwms3/isc@TESTGMMC FILE=C:\ZKGL_201407012334.dmp ignore=y fromuser=GMMCZKGL touser=testwms tables=(GMMCZKGL.t_kdttrcktz)imp testapar/isc@TESTGM
阅读全文
摘要:select MAXSYSACCEPT.nextval from dual; (序列号检索 增1)alter sequence MAXSYSACCEPT increment by 1 cache 20; (序列号设置 增1)alter sequence MAXSYSACCEPT increment
阅读全文
摘要:●sqlplus登陆sqlplus sys/isc@testgmmc as sysdba●创建用户create user testpoi3 IDENTIFIED by iscaccount unlock;grant dba,advisor to testpoi2;●删除用户drop user djc
阅读全文
摘要:查看session:select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao,
阅读全文
摘要:① 增加归档日志空间的大小sqlplus / as sysdba shutdown abort 关闭进程 startup mount 装载数据库 select * from v$recovery_file_dest; 查询归档日志 alter system set db_recovery_file_
阅读全文
摘要:DispatcherServlet -- 前置控制器HandlerMapping接口 -- 处理请求的映射HandlerMapping接口的实现类:DefaultAnnotationHandlerMapping 通过注解,把一个URL映射到Controller类上SimpleUrlHandlerMa
阅读全文