Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÐÂÊÖÇóд¸ö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ÀïÃæÖ´ÐÐ


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

OracleÐÐתÁÐ - Oracle / ¸ß¼¶¼¼Êõ

select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó

SQL code:
wi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ