OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
1.ʹÓþßÓн¨Á¢±í¿Õ¼äºÍÓû§È¨ÏÞµÄÓû§µÇ¼Oracle£»
2.½¨Á¢ÐèÒªµÄ±í¿Õ¼ä£»
3.½¨Á¢ÐèÒªµÄÓû§£¨Óû§Ãû£¬ÃÜÂ룬ĬÈϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä£¬È¨ÏÞ£©
4.´ò¿ªDOS´°¿Ú£¬ÔÚÃüÁîÐÐÖÐÊäÈëIMP£»
5.ÓõÚÈý²½Öн¨Á¢ºÃµÄÓû§µÇ¼Êý¾Ý¿â£»
6.ÊäÈëDICÎļþµÄÍêȫ·¾¶£¬°´ÕÕÌáʾѡÔñ£¬¼´¿Éµ¼Èë¡£
Ïà¹ØÎĵµ£º
1¡¢»Ö¸´½á¹¹Óë½ø³Ì
ÔÚ½éÖÊʧ°Üºó£¬¸ù¾ÝÊÜËðÎļþµÄÀàÐÍ£¬´æÔÚ²»Í¬µÄ»Ö¸´·½·¨¡£Êý¾Ý¿âÓÉ¿ØÖÆÎļþ¡¢Áª»úÖØ×öÈÕÖ¾ÎļþÒÔ¼°Êý¾ÝÎļþ×é³É¡£Èç¹û¸´ÓÃÁË¿ØÖÆÎļþ»òÁª»úÖØ×öÈÕÖ¾Îļþ£¬ÄÇô»Ö¸´ÊÜËðµÄÕâЩÎļþÊ®·ÖÈÝÒס£
¶ÔÓÚÊÜËðµÄ¿ØÖÆÎļþ£¬¿ÉÒÔ½«ÆäÌæ»»ÎªÄ³¸ö¸´Óø±±¾£¬Ò²¿ÉÒÔʹÓÃCREATE CONTROLFILEÃüÁîÖØ½¨¡£
ÊÜËðµÄÁª»úÖØ×öÈ ......
---´´½¨±í¿Õ¼ä
create tablespace ±í¿Õ¼äÃû×Ö datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss01.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss02.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\w ......
1¡¢ ´ò¿ªpl/sql ÖÐtools-preferences£¬ÉèÖÃConnectionÖеÄOracle HomeΪoracle9£¬OCI libraryΪoracle9 Èçͼ
2¡¢
½«oralce10Ŀ¼ÏµÄtnsnames.oraÎļþÀïÃæµÄËùÒªµ¼³öµÄoralce10µÄ·þÎñÅäÖà ¸´ÖƵ½oracle9Ŀ¼ÏµÄtnsnames.oraÎļþÀïÃæ
ORCL =
(DESCRIP ......
oracleµ±¶à±íunionʱÓöµ½nvarchar2ÀàÐÍʱ±¨´í ×Ö·û¼¯²»Æ¥Åä
¶ÔʹÓÃnvarcharµÄµØ·½£¬¼ÓÉÏ to_char( nvarchar µÄ±äÁ¿»ò×Ö¶Î )
È磺
select to_char(name),price from aa
union all
select to_char(name),price from bb
3Õűíaa,bb,cc¶¼ÓÐ name price ×Ö¶Î ²éѯ¼Û¸ñ×î¸ßµÄǰ3λÐÕÃû
select * from(select to_ch ......