oracleÒÆÖ²
ÎÊϸßÊÖ:ÔÚoracleÒÆÖ²¹ý³ÌÖÐ ÈôÏë°ÑÊý¾Ý¿âµÄ²¿·Ö±í,ÊÓͼÒÔ¼°Êý¾Ý´Óһ̨·þÎñÆ÷ÒÆµ½Áíһ̨ ÓÃimpÃüÁî,,µ«ÊDZí¿Õ¼ä²»Í¬ÔõôÉèÖÃÄØ?Ï£Íû¸ßÊÖÖ¸µãÏÂ........
Ä㽨һ¸öÏàͬµÄ±í¿Õ¼ä²»¾ÍºÃÁËÂð£¿
²»ºÃÒâ˼¿ÉÄÜÎÒû˵Çå³þ...Á½¸öoracleµÄ±í¿Õ¼ä²»Ò»Ñù,ÎÒÔÚеÄoracleÐèÒª½¨Ðµıí¿Õ¼ä,,µ«ÊÇÎÒÒѾ½¨ÁË....Ϊʲôµ¼ÈëµÄʱºòµ¼²»½øÄØ?
imp report/report@sup file=report_tables.dmp log=imp_report_tables.log TABLESPACES=KRM_REPORT_DATA ignore=y
ÄÇÄãµ¼ÈëµÄʱºò£¬Ö»µ¼ÈëÊý¾Ý¼Ç¼ºÃÁË£¬²»µ¼Èë´æ´¢¿Õ¼ä´æ´¢Î»Öðɣ¡ È»ºó ignore=y¸ÄΪ ignore=nÊÔÊÔ°É¡£
??????ÐèÒªµÄÊý¾ÝÒÔ¼°±í¶ÔÏóÒѾ±¸·ÝºÃÁË...±íÓÐÉϰٸö..Êý¾Ý´ó¸ÅÓÐ20G..²»»áÒ»¸öÒ»¸öµÄ½¨±íÔÚµ¼Èë°É?
»¹ÓоÍÊǵ¼ÈëÁ˲¿·Ö...ÔÚPLSQL²é¿´±í¿Õ¼äµÄʱºòÊÇUSERS ²»Ö»ÎªÊ²Ã´???
Â¥Ö÷µÄϵͳӦ¸ÃÓÐ×Ô¼º¶ÀÁ¢µÄ±í¿Õ¼ä£¬ËùÒÔÂ¥Ö÷Ö»Ðè°´±í¿Õ¼äÀ´µ¼¾Í¿ÉÒÔÁË£¬¼øÓÚÊý¾ÝÁ¿½Ï´ó£¬½¨ÒéÓ÷þÎñ¶ËµÄÊý¾Ý±ÃÀ´£¬Õâ±È´«Í³µÄexp/imp ЧÂʸß4-5 ±¶¡£
SQL code:
µ¼³ö±í¿Õ¼ä
Expdp system/manager DIRECTORY=dump_dir DUMPFILE=tablespace.dmp TABLESPACES=user01,user02 logfile=/exp.log;
µ¼Èë±í¿Õ¼ä
Impdp system/manager DIREC
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
×î½ü¿ªÊ¼ÏëѧϰOracleÊý¾Ý¿â£¬¿ÉÊǰ汾ºÜ¶à°¡£¬11G¡¢10G£¬µÈµÈ£¬ÎÒ²»ÖªµÀ¶ÔÓÚÎÒÕâ¸ö³õѧÕßÀ´ËµÑ¡Ôñʲô°æ±¾½øÐÐÈëÃŵ½»ù±¾ÕÆÎÕµÄѧϰ×îºÃ¡£
Òò´Ë£¬ÇëÇóÒ»¸öºÏÊʵİ汾ºÍ½Ì²Ä£¬×îºÃÌṩһ¸öÏÂÔØ¸ÃOracle°æ±¾µÄµØÖ· ......
ÔÚÍøÂçÉÏÓÐһ̨ORACLE·þÎñÆ÷£¨windows2003£¬ORACLE 10G£©
¿Í»§»úʹÓÃXP£¬°²×°ORACLE8I¿Í»§¶Ë
ʹÓÃSQLPLUS¿ÉÒÔÔ¶³ÌÁ¬½Óµ½ORACLE·þÎñÆ÷£¨ÒÔSYSDBAÉí·Ý£©
ͨ¹ýÃüÁîshutdown immediate¹Ø±ÕÊý¾Ý¿âºó£¬ÎÞ·¨Ê¹ÓÃst ......
PowerDesigerµ¼³öµÄsql¿ÉÒÔɾ³ý±í¿Õ¼ä
ûÓб¸·Ý±í¿Õ¼äÈçºÎ»Ö¸´?
±ð³Á°¡
ÒýÓÃ
²»ÖªµÀ£¬°ïÄã¶¥£¬»¹ÓУ¬ÄãÎÊ´íµØ·½ÁË£¬µ½oracleÇøÈ¥ÎÊ,itpubÒ²ÊǸöºÃÑ¡Ôñ¡£
......