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

oracle ±íÖвåÈë¶àÐÐ

·½·¨Ò»£º
SQL>create table aa(a number);
´´½¨³É¹¦¡£
SQL> select * from aa;
A
--------
2
SQL>
SQL> insert all
2 into aa values(1)
3 into aa values(2)
4 select * from dual;
ÒÑ´´½¨2ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> select * from aa;
A
----------
2
1
2
·½·¨¶þ£º
SQL>create table a(a number);
´´½¨³É¹¦¡£
SQL>desc a;
Ãû³Æ ÊÇ·ñΪ¿Õ ÀàÐÍ
----------- -------------- ----------
SQL>insert into a values(&a);
ÊäÈëaµÄÖµ£º1 (»Ø³µ)
//Ô­Öµ 1£ºinsert into a values(&a)
//ÐÂÖµ 1£ºinsert into a values(1)
ÒÑ´´½¨1ÐС£
SQL>/
ÊäÈëaµÄÖµ£º1 (»Ø³µ)
Ô­Öµ 1£ºinsert into a values(&a)
ÐÂÖµ 1£ºinsert into a values(2)
ÒÑ´´½¨1ÐС£
SQL>select * from a;
A
--------
1
2


Ïà¹ØÎĵµ£º

ÈçºÎÔÚoracleÖе¼Èëµ¼³ödmpÎļþ[ת]

¡¡¡¡OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓÃ……
 
¡¡¡¡OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏàµ±Ó ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......

ά»¤Oracle³£ÓÃSQLÓï¾ä

       ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES ......

OracleÊý¾Ý¿âÖ÷»úÃûÖØ¹¹£¨For Windows£©

ÔÚNet Manager¹¤¾ßÖУ¬  
  ½«¼àÌý³ÌÐòµÄ¼àÌýλÖõÄÖ÷»úÃû¸ÄΪ  лúÃû  
  ½«·þÎñÃûÖжÔÓ¦Êý¾Ý¿âµÄÖ÷»úÃû¸ÄΪ  лúÃû  
   
  ¸ÄÁ˼àÌý³ÌÐòºó£¬ÔÚMS-DOSÖÐÔËÐР 
  lsnrctl   stop  
  lsnr ......

oracle¶¨Ê±ÈÎÎñ£¨dbms_job£©

½ñÌì×ܽáÏÂoracleµÄÈÎÎñ¶ÓÁйÜÀíÆ÷(job queue ),ÒÔºóÒ²·½±ã²éѯ.
 ÎÒÃÇÒª×ö¶¨Ê±ÈÎÎñʱ,ÓÐÁ½ÖÖ°ì·¨
Ò»ÖÖÊÇ: ²Ù×÷ϵͳµÄ¶¨Ê±,winµÄ¶¨Ê±ÈÎÎñ,unixµÄcrontab
Ò»ÖÖÊÇ: Êý¾Ý¿â¼¶µÄ¶¨Ê±,ËýµÄЧÂʸü¸ß,
ÔÙÓдóÁ¿µÄ±í¼¶²Ù×÷ʱ,½¨ÒéÓÃÊý¾Ý¿â±¾ÉíµÄjob queue,ÕâÑù·½±ã,ЧÂʸß;Èç¹ûÓÃϵͳ¼¶¶¨Ê±,
»áÔö¼ÓºÜ¶à±à³Ì¹¤×÷,³É±¾Ôö¼Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ