oracle ÔöÁ¿±¸·Ý»Ö¸´²ßÂÔ(»ù´¡ÖªÊ¶)
EXPºÍIMPÊÇOracleÌṩµÄÒ»ÖÖÂß¼±¸·Ý¹¤¾ß¡£Âß¼±¸·Ý´´½¨Êý¾Ý¿â¶ÔÏóµÄÂß¼¿½±´²¢´æÈëÒ»
¸ö¶þ½øÖÆ×ª´¢Îļþ¡£ÕâÖÖÂß¼±¸·ÝÐèÒªÔÚÊý¾Ý¿âÆô¶¯µÄÇé¿öÏÂʹÓÃ,
Æäµ¼³öʵÖʾÍÊǶÁȡһ¸öÊý¾Ý¿â¼Ç¼¼¯£¨ÉõÖÁ¿ÉÒÔ°üÀ¨Êý¾Ý×ֵ䣩²¢½«Õâ¸ö¼Ç¼¼¯Ð´ÈëÒ»¸öÎļþ,ÕâЩ¼Ç¼µÄµ¼³öÓëÆäÎïÀíλÖÃÎ޹أ¬µ¼ÈëʵÖʾÍÊǶÁȡת´¢Îļþ²¢
Ö´ÐÐÆäÖеÄÃüÁî¡£´Ë±¸·Ý·½Ê½ÊÇͨ¹ýOracleµÄʵÓù¤¾ßexportºÍimportÀ´ÊµÊ©µÄ£¬
exportÊǰÑÊý¾Ý¿âÖеÄÊý¾Ýµ¼³ö£¬importÊǰÑexportж³öµÄÊý¾Ýµ¼ÈëÊý¾Ý¿âÖС£Í¨¹ý´Ë¹¤¾ß¿ÉÒÔÑÜÉú³ö¶àÖÖ¹¦ÄÜ,
±ÈÈçÕû¸öÊý¾Ý¿âµÄ±¸·Ý¡¢±í½á¹¹Öؽ¨¡¢Êý¾ÝµÄ´«Êä¡¢Óû§µÄ¸Ä±äµÈµÈ¡£
Oracle Export/Import¹¤¾ßÌṩÁËÁé»î¶àÑùµÄ¹¦Äܺ͵¼³ö/µ¼Èëģʽ£¬×ʹÓõÄÈýÖÖģʽÊÇUser¡¢tableºÍfull database¡£³ý´ËÒÔÍ⣬»¹¿ÉÒÔÔÚµ¼³ö/µ¼Èëʱ¾ö¶¨ÊÇ·ñ°üº¬Óë¶ÔÏóÓйصÄÊý¾Ý×ÖµäÐÅÏ¢£¬ÈçË÷Òý¡¢Ô¼Êø¡¢È¨Ï޵ȵȡ£
×¢Ò⣺ͨ¹ýÂß¼±¸·Ý¿ÉÒÔ±¸·ÝÕû¸öÊý¾Ý¿â, »ò½ö±¸·Ý²¿·ÖÖØÒªÊý¾Ý¡£ÒòΪÊÇÂß¼Éϵı¸·Ý,¹ÊÖ»ÄÜÓÃÓÚÂß¼µÄ»Ö¸´Êý¾Ý, Ò»µ©Êý¾Ý¿â±»ÎïÀíËð»µ, µ¼Ö²»ÄÜÆô¶¯,Âß¼±¸·ÝµÄÊý¾Ý²»ÄܰïÖú»Ö¸´Êý¾Ý¿â¡£
1. Export/ImportµÄʹÓþÙÀý£º£¨ÒÔϲÙ×÷¾ùΪÔÚ
(1). ½«Ò»¸öÓû§µÄ¶ÔÏóµ¼Èëµ½ÁíÒ»¸öÓû§Ä£Ê½ÖУº
°ÑÊý¾Ý¿âÖÐÔÓеÄÓû§ExportÖÁÒ»¸ödmpÎļþ£¨Èç°ÑÓû§olduserµÄ¶ÔÏóµ¼³öµ½Îļþolduser0701.dmpÖУ©£º
$ exp sys/password file= olduser0701 owner=olduser grant=N indexes=Y rows=Y
´ÓdmpÎļþÖаÑÒ»¸öÓû§µÄ¶ÔÏóimportÖÁÒ»¸öÓû§µÄģʽÖУ¨´Óolduser0701.dmpÖУ¬°ÑÓû§olduserµÄ¶ÔÏóµ¼Èëµ½Óû§newuserÖУ©£º
$imp sys/password file=olduser0701 fromuser=olduser touser=newuser indexes=Y rows=Y
(2). µ¼Èëʱ±ÜÃâ³öÏÖORA-00942(±í»òÊÇͼ²»´æÔÚ)´íÎó:
ÒòΪ£¬µ¼³öÊǰ´ÕÕÔÚÊý¾Ý¿âÖжÔÏó½¨Á¢µÄ˳Ðò½øÐе쬴ӶøÔÚµ¼Èëʱ£¬Êý¾Ý¿â¶ÔÏóÖ®¼äµÄÒÀÀµÐÔ»áÒýÆðijЩÏȵ¼Èë¶ÔÏóÕÒ²»µ½ÆäÒÀÀµ¶ÔÏó£¨Èçview¡¢
procedureµÈµÈ£©£¬¾Í»áÒýÆðORA-00942(±í»òÊÇͼ²»´æÔÚ)´íÎó¡£Í¨³£½â¾öÕâÖÖÎÊÌâµÄ·½·¨ÊÇ£¬×öÁ½´Îµ¼È빤×÷£¬µÚÒ»±éµ¼ÈëʱÉèÖÃÈçÏ£º
$ imp sys/password file=demo0701 full=Y commit=y rows=Y
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ORACLEµÄËø»úÖÆ
×òÌìÈ¥Ò»¸ö¹«Ë¾ÃæÊÔ£¬Îʵ½OracleµÄ·âËø»úÖÆ£¬ºÇºÇ£¬ÀíÂÛÉϵÄÎÊÌâºÃ¾Ã¶¼Ã»ÓÐѧϰÁË£¬Êé±¾µÄ¶«Î÷Ò²²î²»¶à¶¼»¹¸øÁË´óѧµÄÀÏʦ¡£»ØÀ´·ÁËÒ»ÏÂÊé±¾£¬ÕÒµ½Á˹ØÓÚÕⲿ·Ö֪ʶµÄ˵Ã÷£¬Ìù³öÀ´¹©´óѧ²Î¿¼¡££¨ÏÖÔڵĹ«Ë¾£¬ ......
1.¼¯ºÏ²Ù×÷
ѧϰoracleÖм¯ºÏ²Ù×÷µÄÓйØÓï¾ä£¬ÕÆÎÕunion,union all,minus,interestµÄʹÓÃ,Äܹ»ÃèÊö½áºÏÔËË㣬²¢ÇÒÄܹ»½«¶à¸ö²éѯ×éºÏµ½Ò»¸ö²éѯÖÐÈ¥£¬Äܹ»¿ØÖÆÐзµ»ØµÄ˳Ðò¡£
°üº¬¼¯ºÏÔËËãµÄ²éѯ³ÆÎª¸´ºÏ²éѯ¡£¼û±í¸ñ1-1
±í1-1
Operator Returns   ......
ÔÚoracleÖе÷ÓÃjava³ÌÐò,×¢Òâ:java·½·¨±ØÐëÊÇstaticÀàÐ͵Ä,Èç¹ûÏëÔÚJAVAÖÐʹÓÃsystem.out/errÊä³ölog.
ÐèÒªÔÚoracle ÖÐÖ´ÐÐ"call dbms_java.set_output(5000);".
Ò»¡¢helloWord
1 ±àдJAVA³ÌÐò,Ò²ÊÇÔÚSQL/PLUSÖÐд,²¢Ö´ÐÐ.
create or replace and compile java source named hello as
public ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING ......