Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Íæ×ªOracle£¨2£©

sql*plus ÃüÁî
//Ö´Ðнű¾
@ºÍstart d:/a.txt;
//Ð޸Ľű¾
edit d:/a.txt;
//½«ÄÚÈÝÊäÈëµ½Îı¾ÖÐ
sloop d:/a.txt;  //¿ªÊ¼¼Ç¼ÆÁÄ»ÄÚÈÝ
sloop off;  //¼Ç¼½áÊø
//Á´½ÓµÇ¼Êý¾Ý¿â
connect system/919959 as sysdba/sysoper;  //ȨÏÞ×î´ódba
connect sys/919959;
connect scott/tiger;
//´´½¨Óû§
create user valen identified by 919959;  //´´½¨Íê³Éºó²¢²»Äܹ»µÇ¼£¬ÐèÒªÊÚȨ
//µ±Ç°Óû§
show user;
//ɾ³ýÓû§
drop user valen;
//ÊÚȨ
grant connect to valen;  //µÇ¼µÄȨÏÞ
grant resource to valen; //½¨±íµÄȨÏÞ
grant select on emp to valen; //½«¶ÔÏó²Ù×÷ȨÏÞ¸øÓèijһ¸öÓû§£¬¼ÙÉ赱ǰÓû§Îªscott£¬½«scottµÄemp±íµÄselectȨÏÞ¸³¸øvalen
grant update on emp  //¸üÐÂȨÏÞ
grant inset on emp  //Ìí¼ÓȨÏÞ
grant delete on emp  //ɾ³ýȨÏÞ
grant all on emp  //µ±Ç°±íµÄËùÓÐȨÏÞ
//ÊÕ»ØÈ¨ÏÞ
revoke select on emp from valen; //´ÓvalenÓû§ÊջضÔemp±íµÄselectȨÏÞ
//²éѯÆäËûÓû§µÄ±íµÄȨÏÞ
select * from scott.emp  //²éѯscottÓû§ÏÂemp±í
//ȨÏÞµÄά»¤
//¶ÔÏóȨÏÞ
scott½«È¨ÏÞ´«¸øÁËvalen£¬²¢Ï£Íûvalen½«¸ÃÑ¡Ïß¼ÌÐø´«µÝ¸øÏÂÒ»¸öÓû§
grant select on emp to valen with grant option //Èç¹ûÊǶÔÏóȨÏ޾ͼÓÈëwith grant option
//ϵͳȨÏÞ
grant connect to valen with admin option //Èç¹ûÊÇϵͳȨÏ޾ͼÓÈëwith admin option
Èç¹ûscottÊÕ»ØÁËvalenµÄȨÏÞ£¬ÔòvalenÊÚȨ¸øtomµÄȨÏÞÒ²±»ÊÕ»ØÁË
//ʹÓÃprofile¹ÜÀíÓû§¿ÚÁî
´´½¨profileÎļþ
create profile lock_account //´´½¨¹æÔòlock_account
limit    //¹Ø¼ü×Ö
failed_login_attempts 3  //¸øÓè3´ÎµÇ¼»ú»á
password_lock_time 2;  //Ëø¶¨2Ìì
//¸ü¸ÄÓû§×ñÑ­´Ë¹æÔò
alter user tom profile lock_account;
//¸øÕË»§½â·â
alter user tom account unlock; //¸øÖ¸¶¨Óû§½â·â
//ÖÕÖ¹¿ÚÁî
create profile myprofile //´´½¨¹æÔòmyprofile
limit
password_life_time 10  //ÿ10ÌìÐ޸ĵǼÃÜÂë
password_grace_time 2  //¿íÏÞÆÚΪ2Ìì
password_reuse_time 10  //Ö¸¶¨¿ÚÁî¿ÉÖØÓÃʱ¼ä¼´10Ììºó¾Í¿ÉÒÔÖØÓÃ
//


Ïà¹ØÎĵµ£º

Oracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷Ó¦ÓÃ

ÒÔϵÄÎÄÕÂÖ÷Òª½²ÊöµÄÊÇOracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷·½°¸£¬±¾ÎÄÖ÷ÒªÊÇÒÔÏà¹ØÊµ¼ÊÓ¦ÓôúÂëµÄ·½Ê½À´Òý³öÆäʵ¼ÊµÄ²Ù×÷²½Ö裬ÒÔϾÍÊÇÎÄÕµľßÌåÄÚÈÝÃèÊö£¬ÍûÄãÔÚä¯ÀÀÖ®ºó»áÓÐËùÊÕ»ñ¡£
1.
select 'Drop table '||table_name||';' from all_tables where owner='Ҫɾ³ýµÄÓû§Ãû£¨×¢ÒâÒª´óд£©';

2.Oracleɾ³ýÓû§±í ÒÔÓ ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp

¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£
 
      ´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô­£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£ OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó ......

ÓÃOracle²éѯÓï¾äÓ¦Óþ­Ñé×ܽá


ÓÃOracle²éѯÓï¾äÓ¦Óþ­Ñé×ܽá
¡¡ÒÔϵÄÎÄÕÂÖ÷ÒªÊǽéÉÜOracle²éѯÓï¾äµÄʵ¼ÊÓ¦Óõľ­Ñé×ܽᣬÄãÈç¹û¶ÔOracle²éѯÓï¾äµÄʵ¼ÊÓ¦ÓøÐÐËȤµÄ»°Äã¾Í¿ÉÒÔµã»÷ÒÔϵÄÎÄÕ½øÐйۿ´ÁË¡£ Ï£Íû»á¸øÄã´øÀ´Ò»Ð©°ïÖúÔÚ´Ë·½Ãæ¡£
¡¡¡¡1. select * from table_name where rownum>begin and rownum< end
¡¡¡¡2.sql = "select * fr ......

OracleÊý¾Ý¿âµ¼Èëµ¼³ö£¨1£©

OracleÊý¾Ý¿âµ¼Èëµ¼³ö£¨1£©
 
Oracleµ¼Èëµ¼³ö¹Ù·½¶¨Òå
 
ÈçºÎ²é¿´ImpºÍExpÃüÁ
ǰÌ᣺°²×°OracleÊý¾Ý¿â»òÕ߿ͻ§¶Ë¡£
Ò»¡¢             IMPÃüÁî
1.         ´ò¿ªÃüÁîÌáʾ·û¡£ÀýÈ磬£¨Windows XP£© ......

OracleÖ±·½Í¼µÄÏêϸ½âÎö

OracleÖ±·½Í¼½âÎö
Ò»¡¢    ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»­³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ