Çó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
ѧϰ
ÎÊÌâÒѽâ¾ö£¬ÏÖÔÚ½áÌù¡£
лл´ó¼Ò²ÎÓë¡£
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......