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

oracle µÄÀ䱸·Ý»¹Ô­ÎÊÌâ

ÎÒÓõÄÊÇ oracle 10g XE °æ±¾
Ò»¸ö²Ù×÷ϵͳÊÇWIN2000 Ò»¸ö²Ù×÷ϵͳÊÇWINXP
ÏÖÔÚÎÒÏë°ÑWIN2000ÖеÄORACLEÊý¾Ý¿â×ªÒÆµ½WINXPÖУ¬ÎÒÔÚXPÖа´ÕÕ2000µÄ·¾¶¡¢Óû§È¨ÏÞʲôµÄ¶¼×ö³ÉÒ»Ñù£¬ÏÖÔÚ°Ñ2000ÖеÄÎļþ¸´ÖƵ½XPÏàÓ¦µÄĿ¼ÏÂÃæ£¬ÌáʾORA-01113 Îļþ5ÐèÒª½éÖÊÎļþ¡£ÌáʾORA-01110£ºÎļþÊý¾Ý¡°DATA_SPC.DBF¡±
DATA_SPC.DBFÊÇÎÒËùʹÓÃÊý¾Ý´æ·ÅµÄ±í¿Õ¼ä¡£
Çë¸÷λ°ïæָµãÒÔÏ£»
ϵͳ¿ÉÒÔʹÓ㬵«ÊǾÍÊÇû°ì·¨Ê¹ÓÃÎÒҪʹÓõÄÄÇЩÊý¾Ý
ÔÚ²Ù×÷ϵͳ»·¾³²»Í¬µÄÇé¿öÏ£¬½¨ÒéʹÓÃÂß¼­±¸·ÝºÍ»¹Ô­£¬¿ÉÒÔʹÓÃexpºÍimpÃüÁî¡£

IMPÎÒÊÇ»¹Ô­¹ý£¬µ«ÊÇ200M×óÓÒµÄÊý¾Ý¸ãÁË2¸ö¶àСʱ»¹Ã»Íê³ÉÄØ

ÒýÓÃ
IMPÎÒÊÇ»¹Ô­¹ý£¬µ«ÊÇ200M×óÓÒµÄÊý¾Ý¸ãÁË2¸ö¶àСʱ»¹Ã»Íê³ÉÄØ


²»»á°É£¬ÎÒµÄ9GµÄ imp²Å»¨ÁË3¸öСʱ¡£

ÄãµÄ200M 2Сʱ¾ø¶Ô¿ÉÒÔ×öÍêµÄÀ²£¡

¾ÍÊǰ¡£¬ËæÒâÎÒ¾õµÃÊDz»ÊÇÄÄÀï²»¶Ô°¡


ÎÒÖ»ÓùýÈȱ¸£¬À䱸Âé·³²»ÔõôÓã¬Ò²Óò»µ½£»

ÄãÈ·¶¨¿ØÖÆÎļþÕýÈ·¸²¸ÇÁËÂð£¿


ÒýÓÃ
Èç¹ûλÖö¼Ò»ÑùµÄ»°£¬ÔÚwin2000ÖйØÕý³£¹Ø±ÕÊý¾Ý¿â£¬°Ñwin2000ÖÐÊý¾Ý¿âĿ¼ÉϵÄËùÓÐÎļþÈ«²¿¸´ÖÆÕ³Ìùµ½win xpÖÐÈ¥£¬Ó¦ÊÔ¿ÉÒÔÓõ쬵«ÔËÐÐЧÂʲ»ºÃ˵


¶Ô¼ÈÈ»ÊÇÀ䱸·Ý£¬ÊÇÐèÒªÏÈÕý³£¹Ø±ÕʵÀý£¬ÔÙ±¸·ÝµÄ¡£


,µ¼³ö±í
Expdp scott/tiger DIRECTORY=dump_dir DUMPFILE=tab.dmp TABLES=dept,emp logfile=exp.log;

2,µ¼³ö·½°¸
Expdp scott/tiger DIRECTORY=dump_dir DUMPFILE=schema.dmp SCHEMAS=system,scott logfile=/exp.log;

3.µ¼³ö±í¿Õ¼ä
Expdp sy


Ïà¹ØÎÊ´ð£º

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ