oracleÊý¾Ý¿âµ¼ÈëÎÊÌâ Çó½â - Oracle / ¿ª·¢
oracle10g°æ±¾10.0.2µÄµ¼³öµÄdmpÎļþ µ¼Èëµ½oracle11gÊý¾Ý¿âÖгö´í
µ¼ÈëÌύʧ°Ü
¶ÁÈ¡µ¼ÈëÎļþ ORA-39143: ת´¢Îļþ "g:\database\20100525.DMP" ¿ÉÄÜÊÇÔʼµÄµ¼³öת´¢Îļþ ʱ³öÏÖÎÊÌâ¡£
¶ÁÈ¡µ¼ÈëÎļþ ORA-39143: ת´¢Îļþ "g:\database\20100525.DMP" ¿ÉÄÜÊÇÔʼµÄµ¼³öת´¢Îļþ ʱ³öÏÖÎÊÌâ
- µ¼³öÊÇ·ñ³É¹¦£¬Èç¹û˵µ¼³ö¾ÍÊÇʧ°ÜµÄ£¬¿Ï¶¨Êǵ¼Èë²»ÁË.
ÕâÀïÊǵ¼³öʱµÄÈÕÖ¾
Export started on 2010-05-25 11:06:03
D:\oracle\product\10.2.0\db\bin\exp.exe parfile=C:\WINDOWS\TEMP\plsexp.par
Á¬½Óµ½: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Òѵ¼³ö ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯
×¢: ½«²»µ¼³ö¶Ô±í/ÊÓͼ/ÐòÁÐ/½ÇÉ«µÄÊÚȨ
×¢: ½«²»µ¼³ö±íµÄË÷Òý
¼´½«µ¼³öÖ¸¶¨µÄ±íͨ¹ý³£¹æÂ·¾¶...
. . ÕýÔÚµ¼³ö±í T_IPRµ¼³öÁË 7 ÐÐ
. . ÕýÔÚµ¼³ö±í T_OFFERµ¼³öÁË 0 ÐÐ
. . ÕýÔÚµ¼³ö±í T_OFFER_ID_SEQUENCEµ¼³öÁË 0 ÐÐ
. . ÕýÔÚµ¼³ö±í T_OFFER_SOURCEµ¼³öÁË 5 ÐÐ
. . ÕýÔÚµ¼³ö±í T_PERSONµ¼³öÁË 0 ÐÐ
. . ÕýÔÚµ¼³ö±í T_PERSON_EDUCATIONµ¼³öÁË 4 ÐÐ
. . ÕýÔÚµ¼³ö±í T_PERSON_FIELDµ¼³öÁË 1132 ÐÐ
. . ÕýÔÚµ¼³ö±í T_PERSON_ID_SEQUENCEµ¼³öÁË 0 ÐÐ
. . ÕýÔÚµ¼³ö±í T_PERSON_PAPERµ¼³öÁË
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......