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

oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨


oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨 
 
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾ­ÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾Êǰ´ÈÕÆÚ¼Ç¼µÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS  where to_char(START_TIMES,'yyyy-mm-dd hh:mi:ss') <'2008-08-01 00:00:00';
ʱ¼ä»á·Ç³£³¤£¬²»ÖªµÀ¶àÉÙÌìÄÜÅÜÍ꣬·´ÕýÒ»¸öÍíÉÏûÅÜÍ꣬UNDO»áÔö³¤µ½Ò»¸ö¿ÉŵÄÊý×Ö
Õâ¸ö˼·ÊDz»ÐеÄ
Ñо¿ÁËһϣ¬·¢ÏÖ´ó¶àÊýÈ˵Ä˼·ÊÇ×ö¸öÑ­»·£¬Ã¿5000Ìõ×óÓÒÌá½»Ò»´Î£¬×öÁ˸ö²âÊÔÓï¾äÊÔÁËһϣ¬Ã¿Ð¡Ê±ÄÜɾ³ý80£­90ÍòÌõ£¬Ôε¹ÐèҪɾ³ýµÄÊý¾ÝÊÇ2700ÍòÌõ£¬ºïÄêÂíÔ²ÅÄÜÍê³É¡£
ѯÎʿͻ§£¬·¢ÏÖÕâ¸öÒµÎñÈÕÖ¾±í²»ÊÇʲôʱºò¶¼ÒªÐ´µÄ£¬Ã¿ÌìÍíÉÏ10µãµ½µÚ¶þÌìÔçÉÏ6µãÊÇûÓÐÈË»áʹÓõģ¬ºÜºÃ£¬ÎÒÁ¢¿Ì¿¼ÂÇÁËÒ»ÖÖ·½·¨£¬Ë¼Â·Êǽ«ÐèÒªµÄÊý¾ÝÌáÈ¡³öÀ´µ½Ò»¸öÐÂµÄ±í£¬È»ºó½«Ô­±íɾ³ý£¬½«Õâ¸öÌáÈ¡³öÀ´µÄ±íÖØÃüÃûΪ¾ÉµÄÈÕÖ¾±íÃû¡£
ºÇºÇ£¬ÊÔÒ»ÏÂÕâÖÖ·½·¨µÄÍþÁ¦£¬Éú³ÉеÄÊý¾ÝÕû¸ö¹ý³ÌÖ»ÓÃÁË172S£¬Ò²¾ÍÊÇ3·ÖÖÓ×óÓÒ£¬±íÊÇÉú³ÉÁË£¬µ«ÊÇûÓÐË÷Òý£¬ÄǾÍÕÕ³­Ô­±íµÄË÷Òý°É£¬ºÇºÇ×îºó»¨ÁË18·Ö21Ãë¸ã¶¨ÁË£¬ÆäʵԭÀí¾ÍÊÇÖ»´¦Àí±ØÐë±£ÁôµÄÊý¾ÝÕâЩÊý¾ÝԶԶСÓÚҪɾµôµÄÊý¾Ý£¬Ìø¹ý²»ÐèÒªµÄÊý¾Ý£¬²ÉÓÃCREAT SELECT AS¿ÉÒÔ³ä·ÖʹÓÃË÷Òý£¬¶øÇÒ²»»áÉú´æUNDO,Òò´ËËÙ¶È´ó´ó¼Ó¿ì£¬¸Ã·½·¨µÄ±×¶ËÊÇ£¬±ØÐëÒªÓÐÒ»µãʱ¼ä£¬Ã»ÓÐÈËʹÓÃÕâ¸ö±í²ÅÐС£
ÓÚÊÇÎÒдÁËÒ»¸öSQL£¬½«Õâ¸ö·Åµ½Ã¿ÔµÄ×Ô¶¯Ö´Ðмƻ®ÀﶨÆÚÖ´ÐУ¬¶¨ÆÚά»¤Õâ¸ö±í£¬±ÜÃâ±íÒì³£Åò´ó£¬ËµÁËÔ­Àí£¬¾Í¸ÃÉÏSQLÁË¡£
drop table new_log_temp;
create table new_log_temp as select * from NTLS_log  where timestamp > to_date(to_char(SYSDATE-90,'yyyy-mm-dd'),'yyyy-mm-dd');
drop NTLS_LOG;
alter  table new_log_temp rename to NTLS_LOG;
create index IDX_NTLS_LOG on NTLS_LOG (RECORD)
  tablespace INDEXES
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
create index IDX_NTLS_LOG_OPERATE_ID on NTLS_LOG (OPERATE)
  tablespace INDEXES
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (


Ïà¹ØÎĵµ£º

Oracle Split¹¦Äܺ¯Êý

ÔÚpl/sqlʱ¾­³£»áÅöµ½½«Ä³Ð©Ìض¨µÄ·ûºÅת»»³ÉÐÐ,Õ⹦ÄÜÏ൱ÓÚsplit.ÒÔǰÔÚÍøÉÏÊÕ¼¯µÄsplitº¯ÊýÈçÏÂ:
CREATE OR REPLACE TYPE DJ_STR_SPLIT IS TABLE OF VARCHAR2 (4000);
CREATE OR REPLACE PACKAGE Dj_Function_API IS
module_  CONSTANT VARCHAR2(25) := 'FNDBAS';
lu_name_ CONSTANT VARCHAR2(25) := 'DjFuncti ......

txtÎļþµ¼Èëoracle·½·¨

ÔÚʵ¼Ê¹¤×÷ÖУ¬¾­³£Òª´ÓÊý¾Ý¿âÖе¼³öÊý¾Ý»òÍùÊý¾Ý¿âÖе¼ÈëÊý¾Ý¡£µ±Óöµ½Êý¾ÝÁ¿½Ï´óʱ£¬¾ÍÐèÒªµ¼ÈëÎı¾¸ñʽµÄÊý¾Ý£¬Ò»°ãµ¼ÈëµÄÊý¾Ý¸ñʽÓÐtxt£¬csvµÈ¡£ÒÔÏÂÖ÷Òª½éÉÜÎÒÔÚʵ¼Ê¹¤×÷ÖÐÏòoracleÖе¼ÈëÊý¾ÝµÄÁ½¸öʵÀý¡£
1.ʹÓÃPL/SQL DeveloperµÄText Importer
£¨1£©´Ó²Ëµ¥ÖÐѡȡText Importer¹¦ÄÜ¡£
    Tool&mda ......

ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿


ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿ 
 
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨Ô­ÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2  Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......

Oracle¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ

°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
  Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......

OracleÊý¾Ý¿âDBFÎļþÎóɾ³ý½â¾ö·½°¸

·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ