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

oracle imp\exp Óï·¨¼ò½é3

1¡¢Êý¾Ý¿âµ¼³öÃüÁî
exp wesoftwcp/wesoft@oradb file=f:\backup\%date:~0,10%.dmp log=f:\backup\%date:~0,10%.log
compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000  grants=y record=y indexes=y triggers=y rows=y
 
2¡¢Êý¾Ý¿âµ¼ÈëÃüÁî
set UserName=wesoftwcp
set Passwd=wesoft
set DBName=@oradb
#set LogName=%UserName%gz.log
set fromUser=wesoftwcp
set ToUser=wesoftwcp
set FileName=F:\backup\2009-12-03.dmp
imp %UserName%/%Passwd%%DBName% fromuser=%fromUser% touser=%ToUser% file=%FileName%
pause


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

2008 ÖйúÊ×½ìOracleÊý¾Ý¿â¾«Ó¢¹¤³ÌʦÆÀÑ¡µç×ÓÊÔÌâ

2008 ÖйúÊ×½ìOracleÊý¾Ý¿â¾«Ó¢¹¤³ÌʦÆÀÑ¡µç×ÓÊÔÌ⠺ʹð°¸(2008Äê9ÔÂ3ÈÕ)
===========================================================
2008 ÖйúÊ×½ìOracleÊý¾Ý¿â¾«Ó¢¹¤³ÌʦÆÀÑ¡µç×ÓÊÔÌ⠺ʹð°¸(2008Äê9ÔÂ3ÈÕ)
×÷Õß: zhulch(http://zhulch.itpub.net)
·¢±íÓÚ: 2008.09.02 16:12
·ÖÀà: ERP(Oracle/SAP)
³ö´¦: ht ......

Oracle ϵͳ±í´óÈ«

Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum(b ......

oracleÊý¾Ý¿â——½¨¿â

ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃæ¹¤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle - OraDb10g_home1”&mdash ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ