oracle dumpÎļþ - Oracle / »ù´¡ºÍ¹ÜÀí
ÇëÎʺó׺ΪdumpµÄÎļþºÍºó׺ΪdmpµÄÎļþÊÇÒ»ÑùµÄÂð£¬windowsϵͳÉϵÄoracleÄÜÓÃdumpºó׺µÄÎļþ×öimpÂð£¿
DMPÊÇOracleϵͳÖеÄת´¢Îļþ¡£ dmp ÊÇÂß¼±¸·ÝµÄµ¼³öÎļþ.. ûÓÐdump¸ñʽµÄÎļþ oracleÖÐimp/expµ¼ÈëºÍµ¼³ö¶¼Ö§³Ödmp¸ñʽµÄÎļþÒýÓà ÇëÎʺó׺ΪdumpµÄÎļþºÍºó׺ΪdmpµÄÎļþÊÇÒ»ÑùµÄÂð£¬windowsϵͳÉϵÄoracleÄÜÓÃdumpºó׺µÄÎļþ×öimpÂ𣿠ÔÝʱûÓмû¹ýoracle²Ù×÷ÖеÄdumpÎļþ£¬Æ½³£ÓÃimport¡¢export¡¢Êý¾Ý±Ã»òÕßrmanµÄʱºò£¬¶¼ÊÇdmpÎļþ¡£ Îļþ¸ñʽ¿ÉÒÔ×Ô¶¨Ò壬ÆäʵÄÚÈݶ¼ÊÇÒ»ÑùµÄ DMPÊÇOracleÖеĶþ½øÖÆ×ª´¢Îļþ£¡
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
oracleº¯ÊýÈçÏ£º create or replace function P_WEB_GETCITYID ( p_mobileNumber in VARCHAR2, p_cityid out NUMBER ) Return NUMBER IS p_areacode varc ......