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

ÇóoracleÊý¾Ý¿â±¸·ÝÃüÁî

ÈçÌ⣺
ÇóÒ»±¸·ÝoracleÊý¾Ý¿âµÄÍêÕûÃüÁÐèÒªÕû¿â±¸·Ý¡£Ð»Ð»
±¸·ÝÃüÁî,¾ÍÊǵ¼³öÊý¾Ý!LIUNXÏ¿ÉÒÔд½Å±¾,¶¨Ê±±¸·Ý!ÉÏÍø²éÒ»ÏÂ,ºÜ¶àÀý×Ó!

exp USERNAME/PASSWORD@Êý¾Ý¿âÁ¬½Ó·û full=y file='Ä㱸·ÝÎļþ´æ·ÅµÄ·¾¶'

exp scott/scott@orcl full=y file='/oracle/oracle10g/backup/allbackup_scott_20090917.bmp';

Â¥ÉϵÄÕý½â

²»Óöà˵ÁË

cmd ÏÂ
exp uid/pwd@sid file=d:\orcl.dmp owner=(uid1,uid2...)

¸÷λ´óÏÀ£º
ÎÒÔÚpl/sqlÖÐÊäÈëµÄÃüÁîÊÇ£º
exp xcom_test/xcom_test@rasdb file='e:\orc.dmp';
ÎÒµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇ£º
<property name="url"> <value>jdbc:oracle:thin:@**.**.**.**:1521:rasdb </value>
</property>
<property name="user">
<value>xcom_test </value>
</property>
<property name="password">
<value>xcom_test </value>
</property>

ÎÒÖ´ÐÐÃüÁ´í£ºORA-00900: invalid SQL statement

ѧϰ

ÎÊÌâÒѽâ¾ö£¬ÏÖÔÚ½áÌù¡£
  лл´ó¼Ò²ÎÓë¡£


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔ­Àí£¿

sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
    conn system/oracle£¨ÃÜÂ룩

Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔ­ÀíÉÏ£©

Èç¹ûÓÐË­¶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ