Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÖú 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Êý¾Ý¿â±¸·Ý¹ý³Ì

OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
 
1.ʹÓþßÓн¨Á¢±í¿Õ¼äºÍÓû§È¨ÏÞµÄÓû§µÇ¼Oracle£»
2.½¨Á¢ÐèÒªµÄ±í¿Õ¼ä£»
3.½¨Á¢ÐèÒªµÄÓû§£¨Óû§Ãû£¬ÃÜÂ룬ĬÈϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä£¬È¨ÏÞ£©
4.´ò¿ªDOS´°¿Ú£¬ÔÚÃüÁîÐÐÖÐÊäÈëIMP£»
5.ÓõÚÈý²½Öн¨Á¢ºÃµÄÓû§µÇ¼Êý¾Ý¿â£»
6.ÊäÈëDICÎļþµÄÍêȫ·¾¶£¬°´ÕÕÌáʾѡ ......

Oracle IOÎÊÌâ½âÎö

Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔ­Òò¡£ÔÚÕâÆªÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖÆµÄ»ù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......

oracle ÏÂÔØµØÖ·

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


ORACLE EXPDP/IMPDP
2010-01-22 17:07
µ÷ÓÃEXPDP
ʹÓÃEXPDP¹¤¾ßʱ,Æäת´¢ÎļþÖ»Äܱ»´æ·ÅÔÚDIRECTORY¶ÔÏó¶ÔÓ¦µÄOSĿ¼ÖÐ,¶ø
²»ÄÜÖ±½ÓÖ¸¶¨×ª´¢ÎļþËùÔÚµÄOSĿ¼.Òò´Ë,ʹÓÃEXPDP¹¤¾ßʱ,±ØÐëÊ×ÏȽ¨Á¢DIRECTORY¶ÔÏó.²¢ÇÒÐèҪΪÊý¾Ý¿âÓû§ÊÚÓèʹÓÃ
DIRECTORY¶ÔÏóȨÏÞ.
CREATE DIRECTORY dump dir AS ‘DUMP’; ......

Oracle ×ÔÔö³¤×Ö¶Î

½¨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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ