ÐÂÊÖÇóд¸öoracleÊý¾Ý¿âµÄµ¼³ö - Oracle / ·Ç¼¼ÊõÇø
µ¼ÈëÃüÁîimp system/123@ORCL file=e:\db.dmp fromuser=mapuser touser=system ÀïÃæÓд洢¹ý³ÌʲôµÄ£¬ÎÒÏë°ÑËüµ¼³ö£¬¶ÔÓ¦µÄÃüÁîÔõÃ´Ð´ÄØ£¿
Ϊʲô°Ñ¿â½¨ÔÚsystemÏ£¬¶ø²»µ¥¶À´´½¨Óû§ÄØ£¿²»½â¡£ÄãÕâÑùµ¼³ö²»±¨´í£¿ ÊÇ¡¾ÄãÕâÑùµ¼Èë²»±¨´í£¿¡¿Ð´´íÁË¡£ÒýÓà ÊÇ¡¾ÄãÕâÑùµ¼Èë²»±¨´í£¿¡¿Ð´´íÁË¡£ ûÓб¨´íµÄ£¬Á¬¾¯¸æ¶¼Ã»ÓУ¬ºÜ˳ÀûµÄµ¼ÈëÁË ÄǾÍÖ±½Óµ¼³öÕâ¸öÓû§Êý¾Ý°É¡£ exp system/123@ORCL file=e:\db.dmp log=e:\log.log ¾ßÌå²ÎÊý²é¿´ cmd exp help=y Ò²¿ÉÒÔÊÖ¹¤µ¼³öºó£¬ÔÚplsqlÀïÃæÖ´ÐÐ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ 1,2,3,4 ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û 1 2 3 4 ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö??? ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó SQL code: wi ......