OracleÊý¾Ý¿â¡°Ghost¡±
1¡¢Í¨¹ýToad½«Êý¾Ý¿É½á¹¹Éú³ÉSQL£¨×¢ÒâÓû§£©¡£
[DataBase] [Export] [GenerateSchmaScript]
2¡¢´´½¨DBLink.
DROP PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM";
CREATE PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM"
CONNECT TO SISAL_SH
IDENTIFIED BY <PWD>
USING 'root';
alter system set globe_space = false
3¡¢Êý¾ÝµÄµ¼³ö¡¢µ¼Èë
select * from user_tables;
select 'INSERT INTO '||table_name||' select * from '||table_name||'@root;' from user_tables where table_name like 'C_%';
Ïà¹ØÎĵµ£º
×î½üÔÚÒ»¸öÂÛ̳ÖкÍÈËÌÖÂÛÁËһͨ¹ØÓÚORACLEѧϰµÄÎÊÌ⣬½áºÏÎÒÒ²ËãÓÐ10ÄêµÄORALCE ʹÓÃѧϰµÄ¾Àú¸ø´ó¼ÒÒ»µã½¨Òé°É¡£
1¡¢ORACLEÊý¾Ý¿âÊÇÒ»¸ö·Ç³£ÅӴ󣬷dz£¾«ÉîµÄϵͳ£¬ÒªÓг¤ÆÚ¿¹Õ½µÄ×¼±¸£¬ÄãÖ¸ÍûÄÜÔÚÒ»¸öÔÂÄÚѧ»áÈëÃÅÄÇÊÇ¿ÉÒԵ쬵«ÊÇÄãÒªÂò±¾24Ì쾫ͨORACLEÊý¾Ý¿âÕâÑù²»¸ºÔðÔðÈεÄÊ飬²¢Ïëͨ¹ýËûÀ´ÕÆÎÕORACLE£¬Ö»ÄÜÊÇ³Õ ......
¸ü¸Äoracle Listener ÅäÖãºD:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN Ŀ¼֮Ï£ºListener.oraÎļþ½øÐÐÅäÖãº
# listener.ora Network Configuration File: d:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SI ......
1¡¢´´½¨±í£º
create table stud(
sid int,
sname varchar2(50)
)
²¢²åÈëÒ»ÌõÊý¾Ý
&n ......
PL/SQL-FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð
url:http://hi.baidu.com/1413/blog/item/a521251f7e5993c4a686696b.html
Êý¾Ý¿â oracle for update of ºÍ for updateÇø±ð
select * from TTable1 for update Ëø¶¨±íµÄËùÓÐÐУ¬Ö»ÄܶÁ²»ÄÜд
2 select * from TTable1 wher ......
Ò» ǰÌá
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
񡜧mytable
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......