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

.batÆô¶¯Êý¾Ý¿â·þÎñ(MSSQL,Oracle)

 @echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo  Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ     
echo.
echo [1]Æô¶¯Sql Server2005   [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i         [4]¹Ø±ÕOracle9i
echo.
echo             ÆäËü¼üÍ˳ö±¾³ÌÐò
echo.
set /P CHS= ÇëÑ¡Ôñ·þÎñ: [1],[2],[3],[4]
if /I "%CHS%"=="1" (
goto aaaa
)
if /I "%CHS%"=="2" (
goto bbbb
)
if /I "%CHS%"=="3" (
goto cccc
)
if /I "%CHS%"=="4" (
goto dddd
)
goto close
:aaaa
REM Æô¶¯Sql Server2005
net start MSSQLSERVER
pause
cls
goto dosmenu
:bbbb
REM ¹Ø±ÕSql Server2005
net stop MSSQLSERVER
pause
cls
goto dosmenu
:cccc
REM Æô¶¯Oracle9I
net start "OracleServiceHOPE"
net start "OracleOraHome92TNSListener"
pause
cls
goto dosmenu
:dddd
REM Æô¶¯Oracle9I
net stop "OracleOraHome92TNSListener"
net stop "OracleServiceHOPE"
pause
cls
goto dosmenu
:close
REM Í˳ö
exit
-----------------------------------
      ¿½±´ÉÏÃæµÄÄÚÈÝ£¬ÃüÃûΪ.bat Îļþ£¬Ë«»÷ÔËÐм´¿ÉÆô¶¯£¬Í£Ö¹Êý¾Ý¿â·þÎñ


Ïà¹ØÎĵµ£º

Linux(Centos5.4)Éϰ²×°oracle10gR2(10.2.1)

http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......

Oracle expÏê½â

 µ¼Èë/µ¼³öÊÇORACLEÐÒ´æµÄ×î¹ÅÀϵÄÁ½¸öÃüÁîÐй¤¾ß£¬ÆäʵÎÒ´ÓÀ´²»ÈÏΪExp/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼­ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼­¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......

oracle ÎïÀíÊý¾Ý¿â½á¹¹

ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃϰ¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
   1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
   2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......

oracleÊý¾Ý¿âÖв鿴ËùÓбíSQL

select   table_name   from   user_tables;     //µ±Ç°Óû§µÄ±í  
   
  select   table_name   from   all_tables;     //ËùÓÐÓû§µÄ±í  
   
  select   table_name   from   dba_tables;   &n ......

SybaseÊý¾Ý¿âºÍoracleÊý¾Ý¿âÓ÷¨


1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:daochu.dmpÖÐ
    exp system/manager@TEST file=d:daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
    exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ