Oracle ORA 01110´íÎó½â¾ö·½·¨
ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬½¨Á¢ÁËÒ»¸öÓû§test£¬È»ºóʹÓÃÃüÁîdrop user test cascadeɾ³ýÁËÓû§£¬½Ó×ÅҲɾ³ýÁËÕâ¸öÓû§µÄÊý¾ÝÎļþ/opt/oracle/oradata/test/testdata.dbf¡£µ±ÔڵǼÊý¾Ý¿âʱ£¬Äܹ»Æô¶¯ÊµÀý£¬µ«ÊÇ´ò²»¿ªÊý¾Ý¿â£¬ÏµÍ³±¨´í£º
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/opt/oracle/oradata/test/testdata.dbf'
ÏÂÃæ²Î¿¼ÍøÉϵÄÃèÊö¸ø³ö½â¾ö·½·¨£ºhttp://topic.csdn.net/u/20090209/16/cdf830ad-72fb-44e5-92b3-690779e10d9a.html
½â¾ö²½ÖèÊÇ£ºÖØд´½¨Ò»¸öÊý¾ÝÎļþ£¬È»ºórecover¹ýÀ´¾Í¿ÉÒÔÁË£¬²»¹ýÇ°ÌáÊÇÈÕÖ¾Îļþ»¹ÔÚ¡£
1. startup mount
2. alter database create datafile '/opt/oracle/oradata/test/testdata.dbf';
3. set autorecovery on;
4. recover datafile '/opt/oracle/oradata/test/testdata.dbf';
5. alter database datafile '/opt/oracle/oradata/test/testdata.dbf' online;
6. alter database open;
Ïà¹ØÎĵµ£º
·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *
from (SELECT AA.*, ROWNUM RN ......
ÔÚJ2EEÓ¦ÓóÌÐò¿ª·¢ÖУ¬Ó¦ÓóÌÐòÓëÊý¾Ý¿âÁ¬½ÓµÄ½¨Á¢ÊÇÎÒÃǾ³£Óöµ½µÄÎÊÌâÖ®Ò»¡£ÔÚÕâÀïÎÒÖ÷Ҫ̸̸ÔÚ±¾µØÓ¦ÓóÌÐòÖÐͨ¹ýOCI·½Ê½¡¢thin·½Ê½ºÍJdbcOdbcÇÅ·½Ê½Á¬½ÓOracleÊý¾Ý¿â£¬ÔÚiPlanet Application Server 6.5ºÍSun Java System Application Server 7ÖжÔOracleÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖÃÒÔ¼°Ó¦ÓÃÖÐÈçºÎ´ÓÁ¬½Ó³ØÖлñµÃÁ¬½Ó
Ò»¡¢±¾µ ......
ת×Ô£º http://blog.csdn.net/kongqz/archive/2009/05/15/4184415.aspx
¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩеıí
²Ù×÷²½ÖèÈçÏ£º
1¡¢µÇ¼linux£¬ÒÔoracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓà su - oracleÃüÁîÇл»³ÉoracleÓû§£©
2¡¢ÒÔsysdba·½Ê½À´´ò¿ªsqlplus£¬ÃüÁîÈçÏ£º s ......
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí ......