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

oracle impʱ±¨IMP 00032£¬IMP 00008½â¾ö°ì·¨

oracle impʱ±¨£º
       IMP-00032: SQL statement exceeded buffer length
       IMP-00008: unrecognized statement in the export file
½â¾ö°ì·¨:
   ½«impÓï¾äÓÉ
         imp username/userpass@oraSID file=userdb_20100325.dmp full=y
   ¸ü¸ÄΪ£º 
         imp username/userpass@oraSID file=userdb_20100325.dmp full=y buffer=5400000


Ïà¹ØÎĵµ£º

ÀûÓÃoracle¿ìÕÕdblink½â¾öÊý¾Ý¿â±íͬ²½ÎÊÌâ

±¾ÊµÀýÒÑÍêȫͨ¹ý²âÊÔ,µ¥Ïò,Ë«Ïòͬ²½¶¼¿ÉʹÓÃ.
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
            Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
ǰ6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink ......

oracle ´æ´¢¹ý³ÌʵÏÖ·ÖÒ³

  ÓÃoracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÏÖ·µ»Ø½á¹û¼¯²¢ÊµÏÖ·ÖÒ³µÄ¹¦ÄÜ¡£
Óû§´«Èë²ÎÊý
Ò»ÏÂÊÇת±ðÈ˵ĴúÂë
--°üÉùÃ÷
create or replace package p_page is
  -- Author  : PHARAOHS
  -- Created : 2006-4-30 14:14:14
  -- Purpose : ·ÖÒ³¹ý³Ì
  TYPE type_cur IS REF CURSOR;  &n ......

oracle»ù±¾²Ù×÷±¸Íü


1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M; 
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING C ......

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî(»ù´¡µÄ¼ÇÒä) 
¿ªÊ¼Ñ§Ï°ORACLEÓï¾äÓÅ»¯,´ÓÖ´Ðмƻ®¿ªÊ¼,ÏÈÊìϤÕâЩÃû´ÊÒÔ¼°»ù±¾º¬Òå,¼ÇÒäÔÚÎÒÄÔ×ÓÀï,2010-04-10
Rowid£ºÏµÍ³¸øoracleÊý¾ÝµÄÿÐи½¼ÓµÄÒ»¸öαÁУ¬°üº¬Êý¾Ý±íÃû³Æ£¬Êý¾Ý¿âid£¬´æ´¢Êý¾Ý¿âidÒÔ¼°Ò»¸öÁ÷Ë®ºÅµÈÐÅÏ¢£¬rowidÔÚÐеÄÉúÃüÖÜÆÚÄÚΨһ¡£
Recursive sql£ºÎªÁËÖ´ÐÐÓû§Óï¾ ......

Oracle·ÖÒ³ÌÖÂÛ

oracle·ÖÒ³£¿£¿£¿
ÔÚmysqlÖÐÖ»Òªlimit x,y¾Í¿ÉÒÔ·ÖÒ³³É¹¦£¬ÄÇoracle ÖÐÊÇÔõô×öµÄÄØ£¿
=================================================
·½·¨Ò»£º
SELECT   id,rown  
      from   (SELECT   id,   ROWNUM   rown  
          &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ