.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 Îļþ£¬Ë«»÷ÔËÐм´¿ÉÆô¶¯£¬Í£Ö¹Êý¾Ý¿â·þÎñ
Ïà¹ØÎĵµ£º
ʹÓÃunrecoverable´´½¨±í
create table new_emp as select * from emp unrecoverable;
create table new_emp as select * from emp nologging;
ÍÆ¼öʹÓÃlogging»òÕßnologging.
½«±íÒÆ¶¯µ½ÐµÄÊý¾Ý¶Î»òеıí¿Õ¼ä
ͨ¹ýÒÆ¶¯À´ÊµÏÖ´æ´¢²ÎÊýµÄÐÞ¸Ä
alter table emp move storage(initial 1m next 512k mimexte ......
http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......
µ¼Èë/µ¼³öÊÇORACLEÐÒ´æµÄ×î¹ÅÀϵÄÁ½¸öÃüÁîÐй¤¾ß£¬ÆäʵÎÒ´ÓÀ´²»ÈÏΪExp/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......
Oracle ×Ö¶ÎÀàÐÍ
×Ö¶ÎÀàÐÍ
ÃèÊö
×ֶγ¤¶È¼°Æäȱʡֵ
CHAR (size )
ÓÃÓÚ±£´æ¶¨³¤(size)×Ö½ÚµÄ×Ö·û´®Êý¾Ý¡£
ÿÐж¨³¤£¨²»×㲿·Ö²¹Îª¿Õ¸ñ£©£»×î´ó³¤¶ÈΪÿÐÐ2000×Ö½Ú£¬È±Ê¡ÖµÎªÃ¿ÐÐ1×Ö½Ú¡£ÉèÖó¤¶È(size)ǰÐ迼ÂÇ×Ö·û¼¯Îªµ¥×Ö½Ú»ò¶à×Ö½Ú¡£
VARCHAR2 (size )
ÓÃÓÚ±£´æ±ä³¤µÄ×Ö·û´®Êý¾Ý¡£ÆäÖÐ×î´ó×Ö½Ú³¤ ......
½ñÌìÁ˽âÁËһϿªÔ´dspaceÈí¼þ£¬ÏÖ½«°²×°¹ý³Ì×ܽáÈçÏ£º
1¡¢»·¾³ÉèÖÃ
1.1 ÏÂÔØjdk1.6.x²¢°²×°,°²×°Ê±Ñ¡ÔñĬÈϰ²×°Â·¾¶¼´¿É
Ò»°ãΪ C:\Program Files\Java\jdk1.6.0_10
ÉèÖÃJAVA_HOME,ÉèÖÃCLASSPATHºÍPATH
2¡¢×é¼þ×¼±¸
......