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

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


Ïà¹ØÎĵµ£º

oracle ÐÞ¸Ä×Ö¶ÎÀàÐ͵ķ½·¨

½ñÌ칫˾ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter   table  tb_test  modify permile  number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set  ......

oracle Ŀ¼½á¹¹

Oracle 10g×î¼ÑÁé»îÌåϵ½á¹¹£¨Optimal Flexible Architecture£¬¼òдΪOFA£©£¬ÊÇÖ¸OracleÈí¼þºÍÊý¾Ý¿âÎļþ¼°Ä¿Â¼µÄÃüÃûÔ¼¶¨ºÍ´æ´¢Î»ÖùæÔò£¬¿ÉÒÔ½«ËüÏëÏñΪһ×éºÃµÄϰ¹ß£¬ËüʹÓû§¿ÉÒÔºÜÈÝÒ×µØÕÒµ½ÓëOracleÊý¾Ý¿âÏà¹ØµÄÎļþ¼¯ºÏ¡£
 
ʹÓÃ×î¼ÑÁé»îÌåϵ½á¹¹£¬Äܹ»¼ò»¯Êý¾Ý¿âϵͳµÄ¹ÜÀí¹¤×÷£¬Ê¹Êý¾Ý¿â¹ÜÀíÔ±¸ü¼ÓÈÝÒ׵ض¨ ......

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......

DELPHI 2007ÖÐʹÓÃADOµ÷ÓÃORACLEÓзµ»ØÓαêµÄ´æ´¢¹ý³Ì


ADO ʹÓà ORACLE provider FOR  OLE DB Çý¶¯Ê±
µ÷Óô洢¹ý³ÌÐèÒª·µ»ØÓαêʱ£¬ÔÚÁ¬½Ó×Ö·û´®ÖÐÔö¼Ó
PLSQLRSet=1 ²ÎÊý¡£
´æ´¢¹ý³ÌÖеÄÓα겻ÐèÒª¸¶³õʼֵ
 
Èç:
  sp1: TADOStoredProc;
 
 
 sp1.Close;
 sp1.ProcedureName := 'pkg_ScanList_By_JobNo.sp_GetScanList';& ......

Oracle¶ÔĿ¼Îļþ(directory)µÄ¶Áд²Ù×÷

Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ