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

Oracle²é¿´Óû§±í

ÔÚOracleÖв鿴ËùÓеıí: 
select * from tab/dba_tables/dba_objects/cat; 
¿´Óû§½¨Á¢µÄ±í   :  
select table_name from user_tables;  //µ±Ç°Óû§µÄ±í   
    
select table_name from all_tables;  //ËùÓÐÓû§µÄ±í   
    
select table_name from dba_tables;  //°üÀ¨ÏµÍ³±í 


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ORACLEÖеÄʱÇø£¨time zone£©

oracle¶ÔʱÇøµÄÖ§³Ö±È½ÏÍêÃÀÁË£¬ÓÐtimestamp with time zoneºÍtimestamp with local time zoneÁ½ÖÖÊý¾ÝÀàÐÍ¡£Ëùνtimestamp with time zone£¬Ò²¾ÍÊÇ°ÑʱÇøÐÅÏ¢±£´æÔÚÁÐÊý¾ÝÖУ¬¶øtimestamp with local time zone£¬»á½«Óû§ÊäÈëµÄʱ¼äת»»ÎªÊý¾Ý¿â·þÎñÆ÷ËùÔÚʱÇøµÄʱ¼ä£¬±£´æÔÚÁÐÖУ¬ÕâÑùÄÜÉÔÉÔ¼õÉÙÒ»µã±£´æµÄÊý¾ÝÁ¿¡£ÒòΪt ......

¡¾×ª¡¿ORACLEµÄÈÕÖ¾¹ÜÀí

ORACLEÊý¾Ý¿âµÄÈÕÖ¾Îļþ$ORACLE_BASE/admin/orasid/bdump/alert_orasid.log¼Ç¼ÁËÖØ×÷ÈÕÖ¾µÄת»»£¬
    Êý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ£¬Êý¾Ý¿â½á¹¹µÄ¸Ä±ä£¬»ØÍ˶εÄÐ޸ģ¬ËÀËø£¬ÄÚ²¿´íÎóµÈÐÅÏ¢.
   
    Êý¾Ý¿â¹ÜÀíÔ±ÐèÒª¼ì²éÕâ¸öÎļþÓÐÎÞORA-´íÎ󲢶¨ÆڵضÔÕâ¸öÈÕÖ¾Îļþ½øÐд浵ÕûÀí ......

C#´¦Àíoracle lobµÄÀý×Ó

  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
      &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ