OracleÊý¾Ý¿â±¸·Ýµ¼Èëµ¼³ö
1. ½«Êý¾Ý¿âÍêÈ«µ¼³ö
Óû§Ãûsystem ÃÜÂësystem µ¼³öµ½OracleÓû§Ä¿Â¼ÏµÄtestdb20100522.dmpÎļþÖÐ
#exp system/system@testdb file=testdb20100522.dmp full=y
2. ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
#exp system/system@testdb file= testdb20100522.dmp owner=(system,sys)
3. ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_staff_relatµ¼³ö
#exp aichannel/aichannel@testdb file= testdb20100522.dmp tables=(inner_notify,notify_staff_relat)
4. ½«Êý¾Ý¿âÖеıítable1ÖеÄ×Ö¶Îfiled1ÒÔ"00"´òÍ·µÄÊý¾Ýµ¼³ö
#exp system/manager@TEST file= testdb20100522.dmp tables=(table1) query=" where filed1 like '00%'"
ÉÏÃæÊdz£Óõĵ¼³ö£¬ÓÃÃüÁî¿ÉÒÔ°ÑdmpÎļþ¿ÉÒԺܺõÄѹËõ£¬Ò²¿ÉÒÔÔÚÉÏÃæÃüÁîºóÃæ ¼ÓÉÏ compress=y À´ÊµÏÖ¡£
5. ½«testdb20100522.dmp ÖеÄÊý¾Ýµ¼ÈësdpdbÊý¾Ý¿âÖÐ
#imp system/system@testdb file=testdb20100522.dmp
#imp system/system@testdb full=y file= testdb20100522.dmp ignore=y
ÉÏÃæ¿ÉÄÜÓеãÎÊÌ⣬ÒòΪÓеıíÒѾ´æÔÚ£¬È»ºóËü¾Í±¨´í£¬¶Ô¸Ã±í¾Í²»½øÐе¼È룬ÔÚºóÃæ¼ÓÉÏ ignore=y ¾Í¿ÉÒÔÁË¡£
6. ½«testdb20100522.dmpÖеıítable1 µ¼Èë
#imp system/system@testdb file=testdb20100522.dmp tables=(table1)
»ù±¾ÉÏÉÏÃæµÄµ¼Èëµ¼³ö¹»ÓÃÁË¡£²»ÉÙÇé¿öÒªÏÈÊǽ«±í³¹µ×ɾ³ý£¬È»ºóµ¼Èë¡£
Ïà¹ØÎĵµ£º
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......
ÔÚwindows ÏÂÅäÖÃPHPʹÓÃORACLEÊý¾Ý¿âÒªµã
ÔÚwindowÏ£¬¾³£ÓÃapache + PHP À´×öÓ¦ÓÃƽ̨£¬µ«ÊÇÈç¹ûʹÓÃoracle×öºǫ́Êý¾Ý¿â£¬µ«ÓÖûÓа²×°ÓÐoracle¿Í»§¶Ë£¬ÏÂÃæµÄÅäÖÿÉÒԲο¼
1¡¢ÔÚûÓа²×°oracleµÄ»úÆ÷ÉÏ£¬PHPÎÞ·¨¼ÓÔØphp_oci8.dllÄ£¿é£¬ÔÒòÊÇphp_oci8.dllÒÀÀµµÄÏà¹Ø×é¼þûÓÐÕÒµ½¡£
ÄãÕýÈ·ÉèÖÃÁË ......
insert into dts_auction_comments (id,auction_id,user_id,user_nick,comments,gmt_create,gmt_modified,status,comm_type)
values(409,127380, ......
1. ´´½¨ÆÕͨÓû§
>create user username identified by username;
>grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
>create temporary tablespace DB_TEMP
tempfile '/opt/oracle/oradata/mydb/t ......