Oracle¸ü¸ÄÊý¾ÝÎļþλÖÃ
·½·¨Ò»£ºoffline±í¿Õ¼ä
1¡¢offline±í¿Õ¼ä£ºalter tablespace tablespace_name offline£»
2¡¢¸´ÖÆÊý¾ÝÎļþµ½ÐµÄĿ¼£»
3¡¢renameÐ޸ıí¿Õ¼ä£¬²¢Ð޸ĿØÖÆÎļþ£»
4¡¢online±í¿Õ¼ä£»
1¡¢offline±í¿Õ¼äzerone
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ZERONE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\RMANTS.DBF
ÒÑÑ¡Ôñ7ÐС£
SQL> alter tablespace zerone offline;
±í¿Õ¼äÒѸü¸Ä¡£
2¡¢¸´ÖÆÊý¾ÝÎļþµ½ÐµÄĿ¼
¸´ÖÆÊý¾ÝÎļþC:\ORACLE\PRODUCT\10.2.0\ORADATA\ZERONE01.DBFµ½C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ZERONE01.DBF¡£
3¡¢renameÐ޸ıí¿Õ¼äÊý¾ÝÎļþΪеÄλÖ㬲¢Ð޸ĿØÖÆÎļþ
SQL> alter tablespace zerone rename datafile 'c:\oracle\product\10.2.0\oradata\zerone01.dbf' to 'c:\oracle\product\10.2.0\oradata\orcl\zerone01.dbf';
±í¿Õ¼äÒѸü¸Ä¡£
4¡¢online±í¿Õ¼ä
SQL> alter tablespace zerone online;
±í¿Õ¼äÒѸü¸Ä¡£
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ZERONE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\RMANTS.DBF
ÒÑÑ¡Ôñ7ÐС£
SQL> select file_name,tablespace_name from dba_data_files where tablespace_name='ZERONE';
FILE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------
ZERONE C:\OR
Ïà¹ØÎĵµ£º
µÚÒ»²½£º н¨Îļþ“¶¨Ê±±¸·Ý.bat”£¬ ÎļþÄÚÈÝÈçÏ£º
set tempvalue=databaseName_%date:~0,10%
set directory_temp=d:\BackUp\%tempvalue%
set file_dmp=%directory_temp%\%tempvalue%.dmp
set file_log=%directory_temp%\%tempvalue%.log
set winrarPath="C:\Program Files\WinRAR\WinRAR.exe"
set file ......
ADO ʹÓà ORACLE provider FOR OLE DB Çý¶¯Ê±
µ÷Óô洢¹ý³ÌÐèÒª·µ»ØÓαêʱ£¬ÔÚÁ¬½Ó×Ö·û´®ÖÐÔö¼Ó
PLSQLRSet=1 ²ÎÊý¡£
´æ´¢¹ý³ÌÖеÄÓα겻ÐèÒª¸¶³õʼֵ
Èç:
sp1: TADOStoredProc;
sp1.Close;
sp1.ProcedureName := 'pkg_ScanList_By_JobNo.sp_GetScanList';& ......
Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ ......
1,<>
2,µ¥¶ÀµÄ>,<,(ÓÐʱ»áÓõ½£¬ÓÐʱ²»»á)
3,like "%_" °Ù·ÖºÅÔÚǰ.
4,±íû·ÖÎö.
5,µ¥¶ÀÒýÓø´ºÏË÷ÒýÀï·ÇµÚһλÖõÄË÷ÒýÁÐ.
6,×Ö·ûÐÍ×Ö¶ÎΪÊý×ÖʱÔÚwhereÌõ¼þÀï²»Ìí¼ÓÒýºÅ.
7,¶ÔË÷ÒýÁнøÐÐÔËËã.ÐèÒª½¨Á¢º¯ÊýË÷Òý.
8,not in ,not exist.
9,µ±±äÁ¿²ÉÓõÄÊÇtimes±äÁ¿£¬¶ø±íµÄ×ֶβÉÓõÄÊÇdate±äÁ¿Ê±.»òÏà· ......
¶¨Ò壺
´æ´¢¹ý³Ì£¨Stored Procedure £©ÊÇÒ»×éΪÁËÍê³ÉÌØ¶¨¹¦ÄܵÄSQL Óï¾ä¼¯£¬¾±àÒëºó´æ´¢ÔÚÊý¾Ý¿âÖС£Óû§Í¨¹ýÖ¸¶¨´æ´¢¹ý³ÌµÄÃû×Ö²¢¸ø³ö²ÎÊý£¨Èç¹û¸Ã´æ´¢¹ý³Ì´øÓвÎÊý£©À´Ö´ÐÐËü¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿âÖеÄÒ»¸öÖØÒª¶ÔÏó£¬ÈκÎÒ»¸öÉè¼ÆÁ¼ºÃµÄÊý¾Ý¿âÓ¦ÓóÌÐò¶¼Ó¦¸ÃÓõ½´æ´¢¹ý³Ì¡£ ´æ´¢¹ý³ÌÊÇÓÉÁ÷¿ØÖƺÍSQL Óï¾äÊéдµÄ¹ý ......