ÇóÖú oracle 10g Á¬²»ÉÏ ÄÄλÅóÓѰïæ½â¾öÒ»ÏÂ
Ï£Íû¸ßÊÖ¿ÉÒÔ°ïæһÏ ²»Ê¤¸Ð¼¤
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on ÐÇÆÚËÄ 5ÔÂ 20 17:23:05 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn system/manager as sysdba;
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£
SQL> conn scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
¾¯¸æ: Äú²»ÔÙÁ¬½Óµ½ ORACLE¡£
SQL>
Ïà¹ØÎĵµ£º
OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
1.ʹÓþßÓн¨Á¢±í¿Õ¼äºÍÓû§È¨ÏÞµÄÓû§µÇ¼Oracle£»
2.½¨Á¢ÐèÒªµÄ±í¿Õ¼ä£»
3.½¨Á¢ÐèÒªµÄÓû§£¨Óû§Ãû£¬ÃÜÂ룬ĬÈϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä£¬È¨ÏÞ£©
4.´ò¿ªDOS´°¿Ú£¬ÔÚÃüÁîÐÐÖÐÊäÈëIMP£»
5.ÓõÚÈý²½Öн¨Á¢ºÃµÄÓû§µÇ¼Êý¾Ý¿â£»
6.ÊäÈëDICÎļþµÄÍêȫ·¾¶£¬°´ÕÕÌáʾѡ ......
Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔÒò¡£ÔÚÕâÆªÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖÆµÄ»ù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......
oracle 9i
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
oracle 9i ÔÚÏßÎĵµ
http://download.oracle.com/docs/cd/B10501_01/nav/docindex.htm
oracle 10g/11g ÏÂÔØ
http://www.oracle.com/technology/software/products/database/index.html ......
ORACLE EXPDP/IMPDP
2010-01-22 17:07
µ÷ÓÃEXPDP
ʹÓÃEXPDP¹¤¾ßʱ,Æäת´¢ÎļþÖ»Äܱ»´æ·ÅÔÚDIRECTORY¶ÔÏó¶ÔÓ¦µÄOSĿ¼ÖÐ,¶ø
²»ÄÜÖ±½ÓÖ¸¶¨×ª´¢ÎļþËùÔÚµÄOSĿ¼.Òò´Ë,ʹÓÃEXPDP¹¤¾ßʱ,±ØÐëÊ×ÏȽ¨Á¢DIRECTORY¶ÔÏó.²¢ÇÒÐèҪΪÊý¾Ý¿âÓû§ÊÚÓèʹÓÃ
DIRECTORY¶ÔÏóȨÏÞ.
CREATE DIRECTORY dump dir AS ‘DUMP’; ......
½¨SEQUENCEÐòÁÐ
CREATE SEQUENCE ÐòÁÐÃû×Ö£¨ÀýÈ磺"URLIMAGE_SEQ"£© MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER NOCYCLE ;
½¨trigger ´¥·¢Æ÷
create or replace trigger ´¥·¢Æ÷Ãû×Ö£¨ÀýÈ磺URLIMAGE_TRI £©
before ins ......