oracleɾ³ýËÀËøµÄsession
²é¿´Ëø±í½ø³ÌSQLÓï¾ä1£º
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,
v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid;
ɱµôËø±í½ø³Ì£º
alter system kill session 'sid,serial#';
ÈçÓмǼÔò±íʾÓÐlock£¬¼Ç¼ÏÂSIDºÍserial# £¬½«¶þÕßÁ¬½ÓÆðÀ´£¬¾Í¿ÉÒÔkill¡£ÈçÏ£º
alter system kill session '1458,15829';
Ïà¹ØÎĵµ£º
begin
for item in (select * from user_constraints a where a.constraint_type = 'R') loop
execute immediate 'alter table ' || item.table_name || ' disable constraint ' || item.constraint_name;
end loop;
end;
/ ......
Ê×ÏÈÄãÒªÓÐtomcat,»¹ÒªÓÐoracle jdbcµÄjarµµµÈ»·¾³.
µÚÒ»²½: дJSP
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@(des ......
Ò» ǰÌá
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
񡜧mytable
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......
×î½üæÓÚ¹«Ë¾µÄÏîÄ¿¿ª·¢£¬ºÜ¾ÃûÓÐÀ´csdnÁË¡£½ñÌìÎÞÊ£¬ÉÏÀ´Ð´µã¶«Î÷¡£¹©´ó¼Ò²Î¿¼£¬²»¶ÔµÄµØ·½»¹Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£
Ò»ÏÂÊǶÔoracleÊý¾Ý¿â±íµÄһЩ²Ù×÷Óï¾ä£º
ÒѾ½¨ºÃµÄ±íÌí¼Ó×Ö¶Î
alter table Tablename add(column1&nb ......
ÊÓͼ(view)£¬Ò²³ÆÐé±í, ²»Õ¼ÓÃÎïÀí¿Õ¼ä£¬Õâ¸öÒ²ÊÇÏà¶Ô¸ÅÄÒòΪÊÓͼ±¾ÉíµÄ¶¨ÒåÓï¾ä»¹ÊÇÒª´æ´¢ÔÚÊý¾Ý×ÖµäÀïµÄ¡£ÊÓͼֻÓÐÂß¼¶¨Ò塣ÿ´ÎʹÓõÄʱºò, Ö»ÊÇÖØÐÂÖ´ÐÐSQL.
»¹ÓÐÒ»ÖÖÊÓͼ£ºÎﻯÊÓͼ£¨MATERIALIZED VIEW £©£¬Ò²³ÆÊµÌ廯ÊÓͼ£¬¿ìÕÕ £¨8i ÒÔǰµÄ˵·¨£© £¬ËüÊǺ¬ÓÐÊý¾ÝµÄ£¬Õ¼Óà ......