Íæ×ª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ɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷·½°¸£¬±¾ÎÄÖ÷ÒªÊÇÒÔÏà¹ØÊµ¼ÊÓ¦ÓôúÂëµÄ·½Ê½À´Òý³öÆäʵ¼ÊµÄ²Ù×÷²½Ö裬ÒÔϾÍÊÇÎÄÕµľßÌåÄÚÈÝÃèÊö£¬ÍûÄãÔÚä¯ÀÀÖ®ºó»áÓÐËùÊÕ»ñ¡£
1.
select 'Drop table '||table_name||';' from all_tables where owner='Ҫɾ³ýµÄÓû§Ãû£¨×¢ÒâÒª´óд£©';
2.Oracleɾ³ýÓû§±í ÒÔÓ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp
u
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱Óë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µ¼Èëµ¼³ö¹Ù·½¶¨Òå
ÈçºÎ²é¿´ImpºÍExpÃüÁ
ǰÌ᣺°²×°OracleÊý¾Ý¿â»òÕ߿ͻ§¶Ë¡£
Ò»¡¢ IMPÃüÁî
1. ´ò¿ªÃüÁîÌáʾ·û¡£ÀýÈ磬£¨Windows XP£© ......
OracleÖ±·½Í¼½âÎö
Ò»¡¢ ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......