sqlÖеÄDBO
DBOÊÇÿ¸öÊý¾Ý¿âµÄĬÈÏÓû§£¬¾ßÓÐËùÓÐÕßȨÏÞ£¬¼´DbOwner
ͨ¹ýÓÃDBO×÷ΪËùÓÐÕßÀ´¶¨Òå¶ÔÏó£¬Äܹ»Ê¹Êý¾Ý¿âÖеÄÈκÎÓû§ÒýÓöø²»±ØÌṩËùÓÐÕßÃû³Æ¡£
±ÈÈ磺ÄãÒÔUser1µÇ¼½øÈ¥²¢½¨±íTable£¬¶øÎ´Ö¸¶¨DBO£¬
µ±Óû§User2µÇ½øÈ¥Ïë·ÃÎÊTableʱ¾ÍµÃÖªµÀÕâ¸öTableÊÇÄãUser1½¨Á¢µÄ£¬ÒªÐ´ÉÏUser1.Table£¬Èç¹ûËû²»ÖªµÀÊÇÄ㽨µÄ£¬Ôò·ÃÎÊ»áÓÐÎÊÌâ¡£
Èç¹ûÄ㽨±íʱ°ÑËùÓÐÕßÖ¸¸øÁËDbo£¬Ôò±ðµÄÓû§½øÀ´Ê±Ð´ÉÏDbo.Table¾ÍÐÐÁË£¬²»±ØÖªµÀUser1¡£
²»¹â±íÊÇÈç´Ë£¬ÊÓͼµÈµÈÊý¾Ý¿â¶ÔÏó½¨Á¢Ê±Ò²ÒªÈç´Ë²ÅËãÊǺá£
½¨±í¡¢´æ´¢¹ý³Ì¡¢ÊÓͼµÈÊý¾Ý¿â¶ÔÏóʱ£¬Æä¶ÔÓ¦µÄËùÓÐÕßÊÇ´´½¨ËüµÄÓû§¡£Ôò³ýÁ˸ÃÓû§ÆäËûµÇ¼Óû§ÒªÒýÓÃÕâЩ¶«¶«Ê±£¬¶¼Òª¼ÓÉÏǰ׺£¬ºÜÊÇÂé·³¡£¶øÇÒ£¬³ÌÐòÒò´ËÒ׳ö´í£¬Äã²éÀ´²éÈ¥ÎÊÌâÈ·³öÔÚÕ⣬ÀË·ÑÄãʱ¼ä¡£
Ïà¹ØÎĵµ£º
ǰ¼¸Ìì×öÒ»¸ö¹ØÓÚÊý¾Ý±íÓÅ»¯µÄ³ÌÐò£¬ÓÉÓÚÊý¾Ý¿âÀïÃæµÄ×ֶεĹØÏµ·Ç³£¸´ÔÓ£¬²Ù×÷ÆðÀ´±È½ÏÂé·³£¬¸ÕÓõÄʱºò»¹ºÃ£¬ÔËÐÐʱ¼äÒ»³¤£¬Éú³ÉµÄÊÂÎñÈÕÖ¾ºÜ´ó£¬Õ¼ÓÃÁË10¼¸G£¬´ÅÅ̶¼¿ìÓÃÍêÁË¡£
µ½ÍøÉÏËÑÁËһϣ¬·½·¨ÏÂÃæÁ½ÖÖ£º
1.·ÖÀëÊý¾Ý¿â£¬Ö±½Óɾ³ýÊÂÎñÈÕÖ¾Îļþ£¬ÔÙ¸½¼ÓÊý¾Ý¿â£¬ÏµÍ³ ......
¡¡¡¡Êý¾Ý¿â¿ª·¢ÈËÔ±»òÊý¾Ý¿â¹ÜÀíÔ±(DBA)ΪÁË·¢²¼Êý¾Ý¿â»ò±¸·ÝÊý¾Ý¿â¶ÔÏ󣬳£ÐèÒªÉú³ÉT-SQL½Å±¾¡£±ÊÕßÔÚÕâÀï¶Ô³£Ó÷½·¨½øÐÐÁË×ܽᣬ¹©ÅóÓÑÃDzο¼¡£
¡¡¡¡·½·¨Ò»£ºÊ¹ÓÃÆóÒµ¹ÜÀíÆ÷
¡¡¡¡½øÈë“ÆóÒµ¹ÜÀíÆ÷”£¬ÓÒ»÷Êý¾Ý¿â£¬Ñ¡Ôñ“ËùÓÐÈÎÎñ→Éú³ÉSQL½Å±¾”¼´¿É¡£
¡¡¡¡·½·¨ÆÀ¼Û£ºÓŵãÊÇ·½±ã£¬ÇÒ²Ù×÷¼òµ¥¡ ......
д·¨Ò»£º
set xact_abort on
begin tran
DECLARE @SQL VARCHAR(99)
DECLARE CUR_FK CURSOR LOCAL FOR
SELECT 'alter table '+ OBJECT_NAME(FKEYID) + ' drop constraint ' + OBJECT_NAME(CONSTID) from SYSREFERENCES
--ɾ³ýËùÓÐÍâ¼ü
OPEN CUR_FK
FETCH CUR_FK INTO @SQL
WHILE @@FETCH_STATUS =0
BEGIN
......
1.ϵͳ±äÁ¿º¯Êý
£¨1£©SYSDATE
¸Ãº¯Êý·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä¡£·µ»ØµÄÊÇOracle·þÎñÆ÷µÄµ±Ç°ÈÕÆÚºÍʱ¼ä¡£
select sysdate from dual;
insert into purchase values
(‘Small Widget’,’SH’,sysdate, 10);
insert into purchase values
(‘Meduem Wodget’,’SH’, ......