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

Oracle Êý¾Ý¿â°²È«»ù´¡ÖªÊ¶

Ëæ×żÆËã»úµÄÆÕ¼°ÒÔ¼°ÍøÂçµÄ·¢Õ¹£¬Êý¾Ý¿âÒѾ­²»ÔÙ½ö½öÊÇÄÇЩ³ÌÐòÔ±ËùרÓеϰÌâ¡£¶øOracleÊý¾Ý¿â¸üÊÇÆ¾½èÆäÐÔÄÜ׿Խ£¬²Ù×÷·½±ãÁé»îµÄÌØµã£¬ÔÚÊý¾Ý¿âµÄÊг¡ÖÐÒѾ­Õ¼¾ÝÁËһϯ֮µØ¡£µ«ÊÇͬÑùËæ×ÅÍøÂç¼¼ÊõµÄ²»¶Ï½ø²½£¬Êý¾ÝÐÅÏ¢µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý°²È«ÒѾ­²»ÔÙÊÇÒÔǰµÄ“ÀÏÉú³¤Ì¸”£¬Ò²¸ü²»ÊÇÒÔǰÊé±¾ÉÏÄÇЩ“¿ÉÍû²»¿É¼°”µÄÌõÌõ¿ò¿ò¡£
    »òÐíºÜ¾ÃÒÔǰ£¬´ó¼Ò¶¼¾õµÃOracleÊý¾Ý¿âµÄ°²È«²¢²»´æÔÚÒþ»¼£¬ÒòΪOracle¹«Ë¾ÔÚÈ¥Äê11Ô·ݿªÊ¼´ÙÏúÆäÊý¾Ý¿âÈí¼þʱÌá³öµÄ¿ÚºÅÊǓֻÓÐOracle9iÄܹ»×öµ½¾ø¶Ô°²È«”¡£µ«ÊDz»¹ÜËüÕâô˵ÊÇΪÁË´ÙÏú£¬»¹ÊÇΪÁËÀ©´óÖªÃû¶È£¬×ÜÖ®°éÈ¥Äê12 Ô·ݣ¬Ó¢¹úµÄ°²È«×¨¼Ò David Litchfield ·¢ÏÖµÄ9iAS ÖдæÔڵijÌÐò´íÎóµ¼ÖµĻº³åÒç³ö©¶´ÒÔ¼°ºóÀ´£¬PenTest Limited ºÍ eEye Digital Security ¸÷×ÔÌá³öÁËÒ»¸öСµÄ©¶´£¬ËùÓÐʹÓÃOracle¹«Ë¾²úÆ·µÄÈ˶¼²»ÓɵؽôÕÅÁËÔ­±¾ËɳڵĴóÄÔ--Õâ¸ö¶ÔÓÚÓû§À´Ëµ£¬±Ï¾¹¹ØÏµµ½ÁË×Ô¼ºµÄ“Éí¼ÒÐÔÃü”¡£
    ÏÂÃæ±ÊÕß½«´ø×Å´ó¼Ò×ß½øOracleÊý¾Ý°²È«µÄÊÀ½ç¡£ÓÉÓÚ±ÊÕßˮƽÓÐÏÞ£¬ËùÒÔ²»×ãÖ®´¦ÔÚËùÄÑÃ⣬Íû´ó¼Ò²»Áߴͽ̡£
    (Ò»)OracleÊý¾Ý¿âµÄһЩ»ù±¾³£Ê¶
    ÕâÀï½ö½öÊÇΪÁËÒÔºóµÄ°²È«µì¶¨Ò»Ð©»ù´¡£¬ÒòΪÎÒÃǺóÃæÒªÓõ½ËüÃÇ¡£
    1.OracleËù°üº¬µÄ×é¼þ:
    ÔÚ Oracle£¬Êý¾Ý¿âÊÇÖ¸Õû¸ö Oracle RDBMS »·¾³£¬Ëü°üÀ¨ÒÔÏÂ×é¼þ:
    ·Oracle Êý¾Ý¿â½ø³ÌºÍ»º³å(ʵÀý)¡£
    ·SYSTEM ±í¿Õ¼ä°üº¬Ò»¸ö¼¯ÖÐϵͳÀàÄ¿£¬Ëü¿ÉÒÔÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ¹¹³É¡£
    ·ÆäËüÓÉÊý¾Ý¿â¹ÜÀíÔ± (DBA)(¿ÉÑ¡)¶¨ÒåµÄ±í¿Õ¼ä£¬Ã¿¸ö¶¼ÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ¹¹³É¡£
    ·Á½¸öÒÔÉϵÄÁª»ú»Ö¸´ÈÕÖ¾¡£
    ·¹éµµ»Ö¸´ÈÕÖ¾(¿ÉÑ¡)¡£
    ·ÆäËüÎļþ(¿ØÖÆÎļþ¡¢Init.ora¡¢Config.ora µÈ)¡£
    ÿ¸ö Oracle Êý¾Ý¿â¶¼ÔÚÒ»¸öÖÐÑëϵͳÀàÄ¿ºÍÊý¾Ý×ÖµäÉÏÔËÐУ¬ËüλÓÚSYSTEM ±í¿Õ¼ä¡£
    2.¹ØÓÚ“ÈÕÖ¾”
    OracleÊý¾Ý¿âʹÓü¸ÖֽṹÀ´±£»¤Êý¾Ý:Êý¾Ý¿âºó±¸¡¢ÈÕÖ¾¡¢»Ø¹ö¶ÎºÍ¿ØÖÆÎļþ¡£ÏÂÃæÎÒÃǽ«´óÌåÉÏÁ˽âÒ»ÏÂ×÷ΪÖ÷Òª½á¹¹Ö®Ò»µÄ“ÈÕÖ¾”:
    ÿһ¸öOracleÊý¾Ý¿âʵÀý¶¼Ìṩ


Ïà¹ØÎĵµ£º

oracle ¹éµµÓë²»¹éµµ

oracle ¹éµµÓë²»¹éµµ
1. ²é¿´Êý¾Ý¿âµÄ¹éµµÄ£Ê½
£¨1£©Ê¹ÓÃÃüÁ
-------------------------------------------------
    SQL> archive log list
Êý¾Ý¿âÈÕ־ģʽ ´æµµÄ£Ê½
×Ô¶¯´æµµ ÆôÓÃ
´æµµÖÕµã f:\oradata\dblearn\arch
×îÔçµÄ¸ÅÒªÈÕÖ¾ÐòÁÐ 14
ÏÂÒ»¸ö´æµµÈÕÖ¾ÐòÁÐ 16
µ±Ç°ÈÕÖ¾ÐòÁÐ 16
--- ......

Ôö¶àoracle¹²ÏíÄÚ´æ´¢Æ÷

ÈçÆä·¢ÏÖoracle¹²ÏíÄÚ´æ²»×㣬ÕÐÖÂÊý¾Ý¿âû·¨Ò»°ãÊ©Óã¬Ø½Ðè½øÕ¹ÄÚ´æ´¢Æ÷²ÎÊýÅú¸Ä£¬·½·¨Èç´Î£º
Ò»¡¢µÇ½Êý¾Ý¿â,²é¿´Ä¿Ç°Êý¾Ý¿âÔËÓõÄÊÇpfileÈÔÊÇspfile£¬Õý³£Çé¿ö϶¼ÊÇÔËÓÃspfileÆð¶¯.
¶þ¡¢´´Ôìpfile Ê©ÓÃcreate pfile from spfileÏÂÁÁ¢£¬×¥ºÃ±¸·Ý¡£
Èý¡¢Í¸¹ýeditplusµÈÎı¾¹¤¾ß´ò¿ª×ÊÁÏ,ÕûºÏ¾ßÌåµÄ²ÎÊý.Èç¹ûÔÚsolar ......

OracleÖÐÌÞ³ý±í,ÌÞ³ýÊý¾ÝÒÔ¼°»Ø¸´Êý¾Ý

Ò».ÌÞ³ý±íÖÐÊý¾ÝÁ½ÖÖ²½Öè
a. delete * from My_Table;
b. truncate table My_Table;
¶þ.ÌÞ³ýÕû¸ö±í
drop table My_Table;
ºÎÒԻظ´²»Ð¡ÐÄ Drop µôµÄ±íÄØ,ʵÔò Oracle ÖÐÒ²ÓÐÏà·ÂµÄ "»ØÊÕÕ¾"
ÀýÈ粻СÐÄÌÞ³ýÁ˱í My_Table
drop table My_Table;
Õâ¸öʱ·ÖÔÙÓÃSELECT»°Óï²éѯ´Ë±íʱ£¬½«»áÌáÐѱí»òÊÓͼ²»´æÔÚ.
µ«¿ÉÒÔÓ ......

ORACLE Schema µÄÀí½â

¿´À´ÓеÄÈË»¹ÊǶÔschemaµÄÕæÕýº¬Ò岻̫Àí½â£¬ÏÖÔÚÎÒÔÙ´ÎÕûÀíÁËһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵ͍Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in ......

oracleÖÐimpÃüÁîÏê½â

À´Ô´£ºhttp://www.bokee.net/bloggermodule/blog_viewblog.do?id=465310
OracleµÄµ¼ÈëʵÓóÌÐò(Import utility)ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£impʹÓõĻù±¾¸ñʽ£ºimp[username[/password[@service]]]£¬ÒÔÏÂÀý¾Ùimp³£ÓÃÓ÷¨¡£
1. »ñÈ¡°ïÖú
imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
imp system/mana ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ