ADO+ORACLE´óÏÀÇë½ø
ÎÒÏÖÔÚÏëʵÏÖÒ»¸öÅжÏORACLEÖÐÒ»¸öÊÓͼÊÇ·ñ´æÔÚ£¬Èç¹û´æÔÚ¾Íɾ³ý¡£
ÔÚ³ÌÐòÖÐÎÒÕâÑùдµÄ:
try
{
#pragma region [ɾµôÀϵÄÊÓͼ]
csSqlText.Format("SELECT COUNT(*) AS ÊÓͼ¼ÆÊý from SYS.ALL_VIEWS WHERE VIEW_NAME='%s';",csViewName);
if (!dbcontroler.Connect_to((_bstr_t)m_csOracleConnectionText)) return;
if (!dbcontroler.OpenRecordSet(csSqlText)) return;
if ( dbcontroler.p_RecordSet->ADOEOF) return;
dbcontroler.p_RecordSet->MoveFirst();
iViewCounter = dbcontroler.p_RecordSet->GetCollect("ÊÓͼ¼ÆÊý");
if (iViewCounter > 0)
{
csSqlText.Format("DROP VIEW %s",csViewName);
dbcontroler.UpDataDB(csSqlText);
}
dbcontroler.p_RecordSet->Close();
dbcontroler.p_Connection->Close();
}
catch(_com_error e)
{
CString errorString;
errorString.Format(_T("´ò¿ªÊý¾Ý¿â±í·¢ÉùÒì³£ £¬´íÎóÐÅÏ¢£º%s"),e.ErrorMessage());
AfxMessageBox(errorString);
return ;
}
×ÜÊÇÌáʾÊÓͼ²»´æÔÚ¡£
µ«ÊÇ£¬ÎÒÖ±½ÓÔÚoracleÖÐÖ´ÐÐSELECT COUNT(*) AS ÊÓͼ¼ÆÊý from SYS.ALL_VIEWS WHERE VIEW_NAME='È¥Äê²úÁ¿';ÊÇ¿ÉÒԵġ£
ÕâʱΪʲô£¿ÈçºÎ²ÅÄÜÔÚ³ÌÐòÀïÃæÊµÏÖÊÓͼµÄɾ³ýÄØ£¿
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚ¿ªÊ¼Ö®Ç°£¬ÎÒÃÇÏÈÀ´Ë¼¿¼¼¸¸öÎÊÌ⣿
1. ora-01555´íÎóµÄÊÇÔõô²úÉúµÄ£¿ÓÐʲô°ì·¨½â¾ö£¿
¸ÃÎÊÌ⣬²Î¿¼ÎÒµÄBlog£º Oracle ORA-01555¿ìÕÕ¹ý¾É
http://blog.csdn.net/tianlesoftware/archive/2009/10/31/4745898.aspx
2. »Ø¹ö¶Î(»Ø¹ö ......
ÔÎĵØÖ·£ºhttp://blog.csdn.net/cnham/archive/2009/08/30/4500928.aspx
oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÍ¨¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ ......
OracleµÄ9¸ö_name
2008-07-17 23:47
1¡¢db_name Êý¾Ý¿âÃû
¡¡¡¡SQL> connect xys/manager as sysdba
¡¡¡¡ÒÑÁ¬½Ó¡£
¡¡¡¡SQL> show user
¡¡¡¡USER Ϊ "SYS"
¡¡¡¡SQL> show parameter db_name
¡¡¡¡NAME TYPE VALUE
¡¡¡¡---- -------- ------------
¡¡¡¡db_name string test1
¡¡¡¡db_nameÊÇÊý¾Ý¿âµÄÃû×Ö£¬or ......
ÀûÓÃÐòÁвúÉúÖ÷¼üÖµ¡£
ÐòÁУ¨Sequence£©ÊÇÒ»ÖÖ¿ÉÒÔ±»¶à¸öÓû§Ê¹ÓõÄÓÃÓÚ²úÉúһϵÁÐΨһÊý×ÖµÄÊý¾Ý¿â¶ÔÏó¡£ÐòÁж¨Òå´æ´¢ÔÚÊý¾Ý×ÖµäÖУ¬Í¨¹ýÌṩΨһÊýÖµµÄ˳Ðò±íÀ´¼ò»¯³ÌÐòÉè¼Æ¹¤×÷£¬¿ÉÒÔʹÓÃÐòÁÐ×Ô¶¯²úÉúÖ÷¼üµÄ¼üÖµ¡£µ±Ò»¸öÐòÁеÚÒ»´Î±»²éѯµ÷ÓÃʱ£¬Ëü½«·µ»ØÒ»¸öÔ¤¶¨Öµ¡£ÔÚËæºóµÄÿ´Î²éѯÖУ¬ÐòÁн«²úÉúÒ»¸ö°´Ö¸¶¨µÄÔöÁ¿Ô ......