OracleÊý¾Ýµ¼Èëµ¼³öÏê½â
½«Ò»¸öÊý¾Ý¿âµÄijÓû§µÄËùÓÐ±íµ¼µ½ÁíÍâÊý¾Ý¿âµÄÒ»¸öÓû§ÏÂÃæµÄÀý×Ó¡¡¡¡
exp userid=system/manager owner=username1 file=expfile.dmp
imp userid=system/manager fromuser=username1 touser=username2 ignore=y file=expfile.dmp
ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ´¢É豸¡£
Êý¾Ý¿âÂß¼±¸·Ý·½·¨
ORACLEÊý¾Ý¿âµÄÂß¼±¸·Ý·ÖΪÈýÖÖģʽ£º±í±¸·Ý¡¢Óû§±¸·ÝºÍÍêÈ«±¸·Ý¡£
±íģʽ
±¸·Ýij¸öÓû§Ä£Ê½ÏÂÖ¸¶¨µÄ¶ÔÏó£¨±í£©¡£ÒµÎñÊý¾Ý¿âͨ³£²ÉÓÃÕâÖÖ±¸·Ý·½Ê½¡£
Èô±¸·Ýµ½±¾µØÎļþ£¬Ê¹ÓÃÈçÏÂÃüÁ
exp icdmain/icd rows=y indexes=n compress=n buffer=65536
feedback=100000 volsize=0
file=exp_icdmain_csd_yyyymmdd.dmp
log=exp_icdmain_csd_yyyymmdd.log
tables=icdmain.commoninformation,icdmain.serviceinfo,icdmain.dealinfo
ÈôÖ±½Ó±¸·Ýµ½´Å´øÉ豸£¬Ê¹ÓÃÈçÏÂÃüÁ
exp icdmain/icd rows=y indexes=n compress=n buffer=65536
feedback=100000 volsize=0
file=/dev/rmt0
log=exp_icdmain_csd_yyyymmdd.log
tables=icdmain.commoninformation,icdmain.serviceinfo,icdmain.dealinfo
×¢£ºÔÚ´ÅÅÌ¿Õ¼äÔÊÐíµÄÇé¿öÏ£¬Ó¦Ïȱ¸·Ýµ½±¾µØ·þÎñÆ÷£¬È»ºóÔÙ¿½±´µ½´Å´ø¡£³öÓÚËٶȷ½ÃæµÄ¿¼ÂÇ£¬¾¡Á¿²»ÒªÖ±½Ó±¸·Ýµ½´Å´øÉ豸¡£
Óû§Ä£Ê½
±¸·Ýij¸öÓû§Ä£Ê½ÏµÄËùÓжÔÏó¡£ÒµÎñÊý¾Ý¿âͨ³£²ÉÓÃÕâÖÖ±¸·Ý·½Ê½¡£
Èô±¸·Ýµ½±¾µØÎļþ£¬Ê¹ÓÃÈçÏÂÃüÁ
exp icdmain/icd owner=icdmain rows=y indexes=n compress=n buffer=65536
feedback=100000 volsize=0
file=exp_icdmain_yyyymmdd.dmp
log=exp_icdmain_yyyymmdd.log
ÈôÖ±½Ó±¸·Ýµ½´Å´øÉ豸£¬Ê¹ÓÃÈçÏÂÃüÁ
exp icdmain/icd owner=icdmain rows=y indexes=n compress=n buffer=65536
feedback=100000 volsize=0
file=/dev/rmt0
log=exp_icdmain_yyyymmdd.log
×¢£ºÈç¹û´ÅÅÌÓпռ䣬½¨Ò鱸·Ýµ½´ÅÅÌ£¬È»ºóÔÙ¿½±´µ½´Å´ø¡£Èç¹ûÊý¾Ý¿âÊý¾ÝÁ¿½ÏС£¬¿É²ÉÓÃÕâÖÖ°ì·¨±¸·Ý¡£
Íêȫģʽ
±¸·ÝÍêÕûµÄÊý¾Ý¿â¡£ÒµÎñÊý¾Ý¿â²»²ÉÓÃÕâÖÖ±¸·Ý·½Ê½¡£±¸·ÝÃüÁîΪ£º
exp icdmain/icd rows=y indexes=n comp
Ïà¹ØÎĵµ£º
CREATE OR REPLACE FUNCTION OFFICE.fbill_getbalance (billid NUMBER, total NUMBER)
RETURN NUMBER
IS
paid NUMBER;
balance NUMBER;
BEGIN
balance := total;
--get total paid
SELECT SUM (n_paidamount)
&nb ......
oracle²ÎÊýnls_length_semantics£º
ĬÈÏ£ºbyte
create table test (a varchar(20),b number)
µÈͬÓÚ£º
CREATE TABLE HXG.TESTNLS
(
A VARCHAR2(20 BYTE),
B NUMBER
)
varchar(20)ÓɲÎÊýnls_length_semantics¿ØÖÆ
/////////////////////////////////////////////////////// ......
¸úÆäËûÓïÑԵIJÎÊý²î²»¶à£¬Ê¹ÓÃʱҪ°Ñ°ÑÕæʵÊý¾Ý´«¹ýÈ¥Ìæ´ú
Óŵã¼ÇµÃһЩ£¬Èç¹ûÔÚ²éѯÖÐʹÓÃÖ±½ÓÁ¿£¨³£Á¿£©£¬ÄÇôÿ¸ö²éѯ¶¼½«ÊÇÒ»¸öȫеIJéѯ£¬±ØÐë¶Ô²éѯ½øÐнâÎö¡¢ÏÞ¶¨£¨ÃüÃû½âÎö£©¡¢°²È«ÐÔ¼ì²é¡¢ÓÅ»¯µÈ¼´ÖØÐÂÉú³ÉÖ´Ðмƻ®¡£¶øʹÓÃÁËÒÔºó¾Í¿ÉÒÔÖظ´Ê¹ÓÃ×îÏÈ´´½¨µÄÖ´Ðмƻ®¡£ ......
¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
¿ÉÄÜÄú ÔËÐÐ--sqlplusw ÊÇÄܵÇÉÏÈ¥µÄ ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µ ......
»·¾³£ºÊý¾Ý¿â oracle 64bit ϵͳ win2008 64bit IIS7 ÔÚasp ÍøÒ³ÖÐʹÓÃadoÁ¬½ÓÊý¾Ý¿â ODBCÓõÄÊÇMicrosft ODBC for oracle
Çé¿ö£ºÔÚÍøÒ³µÄ²éѯÓï¾äÖв»º¬ÖÐÎĵĿÉÒÔ£¬Ö»ÒªÓï¾äÖк¬ÓÐÖÐÎľͻ᷵»Ø´íÎó½á¹û¡£
Èç:select 'Ò»¶þÈý' from dual;ÕâÑùµÄÓï¾ä ·µ»Ø»ØÀ´¾ÍÊÇ£¿£¿£¿
»¹ÒªËµÃ÷µÄÊÇoracleµÄ×Ö·û¼¯ÊÇAMERICAN_AMERICA.U ......