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

oracleÓαê

drop table tmp_lzw_3283_tar;
create table tmp_lzw_3283_tar
(
    servnumber varchar2(11)
)
;
load data
infile 'tar_3283.txt'
insert into table tmp_lzw_3283_tar
fields terminated by '|'
(
servnumber
)
/*
select count(*),count(distinct servnumber) from tmp_lzw_3283_tar;
  COUNT(*) COUNT(DISTINCTSERVNUMBER)
---------- -------------------------
       263                       254
*/
---¹ØÁªÓû§±í
----È¡È«Æ·ÅÆÓû§Æ·ÅÆÊý¾Ý         
drop table tmp_lzw_3278_tmp_tb0 purge;                                                              
create table tmp_lzw_3278_tmp_tb0 nologging as                                                                       
select /*+ parallel(c,16) */                                                                       &


Ïà¹ØÎĵµ£º

oracleǨÒƱí¿Õ¼ä

¿ÉǨÒƱí¿Õ¼ätransport tablespace
¿ÉǨÒƱí¿Õ¼ä
ʹÓÿÉǨÒƱí¿Õ¼ä(Transportable Tablespaces)µÄÌØÐÔÔÚÊý¾Ý¿âÖ®¼äÒƶ¯´óÁ¿Êý¾Ý£¬ÐÔÄܱÈexport/importºÍunload/loadÒª¿ìºÜ¶à£¬ÒòΪËüǨÒƱí¿Õ¼äÖ»ÐèÒª¸´ÖÆÊý¾ÝÎļþºÍ²åÈë±í¿Õ¼äÔªÊý¾Ýµ½Ä¿±êÊý¾Ý¿âÖС£
ǨÒƱí¿Õ¼ä¶ÔÒÔÏÂÓ¦ÓÃÌرðÓÐÓãº
·Ö½×¶Î½«OLTPµÄÊý¾ÝÒÆÈëÊý¾Ý²Ö¿â
¸ ......

ORACLE¼¸¸ö¹ýÂËÌõ¼þµÄÖ´ÐÐ˳Ðò

select distinct id
  from table t
 where rownum < 10
 order by t.id desc;
ÉÏÊöÓï¾äµÄ¹ýÂËÌõ¼þÖ´ÐÐ˳Ðò ÏÈwhere --->order by --->distinct
Èç¹ûÓÐgroup byµÄ»° group by ÔÚorder byÇ°ÃæµÄ ......

oracle 10g¿Í»§¶Ëµ¼³ö11gÓû§µÄÍêÕûÊý¾Ý

     ΪÁË×öÐéÄâ»ú£¬ÐèÒª½«·þÎñÆ÷ÉϵÄ11gµÄÓû§µÄÍêÕûÊý¾Ýµ¼³öÀ´¡£¶øÐéÄâ»úÉϵÄoracle10gµÄ£¬Ö±½Óµ¼³öÀ´£¬ÎÞ·¨µ¼Èëµ½ÐéÄâ»ú¡£
ËùÒÔ£¬ÊÔ×ÅÓÃ10gµÄ¿Í»§¶ËÀ´µ¼³öÊý¾Ý£¬
ÓÃÃüÁî:exp exoa/*****@exoa1 file=20100526.dmp grants=y full=y
Ö´Ðкó£¬ÏµÍ³Ìáʾ£º
  EXP-00008:Óöµ½ ORACLE´íÎó1406
&nb ......

Oracle DBA ±ÊÊÔÌâ

author£ºskate
time£º2010-05-26
Oracle DBA ±ÊÊÔÌâ
£¨´ðÌâʱ¼ä60·ÖÖÓ£©
ÍøÉÏ¿´¼ûһƪDBAµÄÃæÊÔÌ⣬¾õµÃͦʵÓõģ¬¶ø²»ÏñÓеÄÃæÊÔŪµÃºÜÐ飬ºÜÀíÏ뻯¡£
Unix/Linux퉀1¡¢ÈçºÎ²é¿´Ö÷»úcpu£¬ÄÚ´æ¡¢IPºÍ´ÅÅÌ¿Õ¼ä?
2¡¢Äã³£ÓõĽø³Ì¹ÜÀí¡¢Ö÷»úÐÔÄܲ쿴ÃüÁîÓÐÄÄЩ£¿
3¡¢½¨Á¢×édbaºÍ¸Ã×éÏÂÓû§oracle£¬Ä¬ÈÏshellΪbash¡£ ......

oracle Ö÷¼ü \Ë÷Òý


ÔÚoracleÖУ¬ÎÒÃÇ´´½¨Ò»¸öÖ÷¼ü£¬Ôòͬʱ×Ô¶¯´´½¨ÁËÒ»¸öͬÃûµÄΨһË÷Òý£»É¾³ýÖ÷¼ü£¬ÔòÖ÷¼üÔ¼ÊøºÍ¶ÔÓ¦µÄΨһË÷Òý¶¼É¾³ýÁË¡£ÕâÊÇÎÒÃǾ­³£¼ûµ½µÄÏÖÏó¡£
 
·¢³öÒ»¸ö´´½¨Ö÷¼üµÄsql£¬oracleÆäʵִÐÐÁËÁ½²½£º´´½¨Ö÷¼üÔ¼Êø¡¢´´½¨/¹ØÁª ΨһË÷Òý¡£²½ÖèÊÇÕâÑùµÄ£º
´´½¨Ö÷¼üÔ¼Êøʱ£¬¼ì²é¸ÃÖ÷¼ü×Ö¶ÎÉÏÊÇ·ñÒѾ­´æÔÚΨһË÷Òý¡£Èô² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ