OracleµÄschema,user
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵĶ¨Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in the database that can connect to and access objects.
Schemas and users help database administrators manage database security.
´Ó ¶¨ÒåÖÐÎÒÃÇ¿ÉÒÔ¿´³öschemaΪÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ£¬ÎªÁËÇø·Ö¸÷¸ö¼¯ºÏ£¬ÎÒÃÇÐèÒª¸øÕâ¸ö¼¯ºÏÆð¸öÃû×Ö£¬ÕâЩÃû×Ö¾ÍÊÇÎÒÃÇÔÚÆóÒµ¹ÜÀíÆ÷µÄ·½°¸Ï¿´µ½µÄÐí¶àÀà ËÆÓû§ÃûµÄ½Úµã£¬ÕâЩÀàËÆÓû§ÃûµÄ½ÚµãÆäʵ¾ÍÊÇÒ»¸öschema£¬schemaÀïÃæ°üº¬Á˸÷ÖÖ¶ÔÏóÈçtables, views, sequences, stored procedures, synonyms, indexes, clusters, and database links¡£
Ò»¸öÓû§Ò»°ã¶ÔÓ¦Ò»¸öschema,¸ÃÓû§µÄschemaÃûµÈÓÚÓû§Ãû£¬²¢×÷Ϊ¸ÃÓû§È±Ê¡schema¡£ÕâÒ²¾ÍÊÇÎÒÃÇÔÚÆóÒµ ¹ÜÀíÆ÷µÄ·½°¸Ï¿´µ½schemaÃû¶¼ÎªÊý¾Ý¿âÓû§ÃûµÄÔÒò¡£OracleÊý¾Ý¿âÖв»ÄÜд´½¨Ò»¸öschema£¬ÒªÏë´´½¨Ò»¸öschema£¬Ö»ÄÜͨ¹ý´´½¨Ò» ¸öÓû§µÄ·½·¨½â¾ö(OracleÖÐËäÈ»ÓÐcreate schemaÓï¾ä£¬µ«ÊÇËü²¢²»ÊÇÓÃÀ´´´½¨Ò»¸öschemaµÄ)£¬ÔÚ´´½¨Ò»¸öÓû§µÄͬʱΪÕâ¸öÓû§´´½¨Ò»¸öÓëÓû§ÃûͬÃûµÄschem²¢×÷Ϊ¸ÃÓû§µÄȱʡ shcema¡£¼´schemaµÄ¸öÊýͬuserµÄ¸öÊýÏàͬ£¬¶øÇÒschemaÃû×ÖͬuserÃû×ÖÒ»Ò» ¶ÔÓ¦²¢ÇÒÏàͬ£¬ËùÓÐÎÒÃÇ¿ÉÒÔ³ÆschemaΪuserµÄ±ðÃû£¬ËäÈ»ÕâÑù˵²¢²»×¼È·£¬µ«ÊǸüÈÝÒ×Àí½âһЩ¡£
Ò»¸öÓû§ÓÐÒ»¸öȱʡµÄ schema£¬ÆäschemaÃû¾ÍµÈÓÚÓû§Ãû£¬µ±È»Ò»¸öÓû§»¹¿ÉÒÔʹÓÃÆäËûµÄschema¡£Èç¹ûÎÒÃÇ·ÃÎÊÒ»¸ö±íʱ£¬Ã»ÓÐÖ¸Ã÷¸Ã±íÊôÓÚÄÄÒ»¸öschemaÖÐ µÄ£¬ÏµÍ³¾Í»á×Ô¶¯¸øÎÒÃÇÔÚ±íÉϼÓÉÏȱʡµÄshemanÃû¡£±ÈÈçÎÒÃÇÔÚ·ÃÎÊÊý¾Ý¿âʱ£¬·ÃÎÊscottÓû§ÏµÄemp±í£¬Í¨¹ýselect * from emp; Æäʵ£¬ÕâsqlÓï¾äµÄÍêÕûд·¨Îªselect * from scott.emp¡£ÔÚÊý¾Ý¿âÖÐÒ»¸ö¶ÔÏóµÄÍêÕûÃû³ÆΪschema.object£¬¶ø²»Êôuser.object¡£ÀàËÆÈç¹ûÎÒÃÇÔÚ´´½¨¶ÔÏóʱ²»Ö¸¶¨¸Ã¶ÔÏó µÄschema£¬ÔڸöÔÏóµÄschemaΪÓû§µÄȱʡschema¡£Õâ¾ÍÏñÒ»¸öÓû§ÓÐÒ»¸öȱʡµÄ±í¿Õ¼ä£¬µ«ÊǸÃÓû§»¹¿ÉÒÔʹÓÃÆäËûµÄ±í¿Õ¼ä£¬Èç¹ûÎÒÃÇÔÚ´´ ½¨¶ÔÏóʱ²»Ö¸¶¨±í¿Õ¼ä£¬Ôò¶ÔÏó´æ´¢ÔÚȱʡ±í¿Õ¼äÖУ¬ÒªÏëÈöÔÏó´æ´¢ÔÚÆäËû±í¿Õ¼äÖУ¬ÎÒÃÇÐèÒªÔÚ´´½¨¶ÔÏóʱָ¶¨¸Ã¶ÔÏóµÄ±í¿Õ¼ä¡£
oracleÖеÄschema¾ÍÊÇÖ¸Ò»¸öÓû§ÏÂËùÓжÔÏóµÄ¼¯ºÏ£¬schema±¾Éí²»ÄÜÀí½â³ÉÒ»¸ö¶ÔÏó£¬oracle²¢Ã»ÓÐÌṩ´´½¨schemaµÄÓï·¨£¬schemaÎÒ×Ô¼ºÀí½âÒ²²¢²»ÊÇÔ
Ïà¹ØÎĵµ£º
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......
Ç°ÑÔ
ÿһ¸öDBAÔÚ½øÐÐÊý¾Ý¿â¹ÜÀíµÄ¹ý³ÌÖв»¿É±ÜÃâµÄÒªÓöµ½ÐÎÐÎÉ«É«µÄ´íÎó(ORA-1547 ,ORA-904,ORA-1578 ......)¡£ÓÐЩ´íÎóÓÉÓÚƵ·±³öÏÖ¡¢ÔÒò¸´ÔÓ¶ø±» Oracle DBA ÃÇÏ·³Æ֮Ϊ"¾µäµÄ´íÎó"¡£ÆäÖÐORA-3113 "end of file on communication channel" ¾ÍÊÇÕâÑùµÄÒ»¸ö¡£
ÎÒÃÇ¿ÉÒÔ¼òµ¥µÄ°ÑÕâ¸ö´íÎóÀí½âΪOracle¿Í»§¶Ë½ø³ÌºÍÊý¾Ý¿ ......
¸ù¾ÝǰЩÌìΪij´ó·É»ú¹«Ë¾µ¼Èëij´ó·É»úÉú²úÊý¾ÝµÄ¾Àú£¬×¼±¸Ð´Æª¹ØÓÚOracleµ¼³öÎļþDMP¸ñʽµÄ·ÖÎö£¬½á¹ûÔÚ±¾»úµ¼³öÒ»×éÑÝʾÊý¾Ýʱºò£¬³öÏÖÁË´íÎó£¬Ë³±ã½â¾öÏ¡£
±¾»ú×°µÄÊÇOracle 11g 32bit(11.0.6)µÄClient£¬Ö÷ÒªÊÇΪÁËʹÓÃODT.Net 11.0.6.21£¬Ö§³ÖVS2008¡£µ«ÊDzÉÓÃEXPÃüÁîµ¼³öÊý¾Ý¿âµÄʱºò£¬³öÏÖÁËЩ¹îÒìµÄ´íÎó¡£
Ö´Ð ......
¼Ì9Ô·ݹúÄÚijÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ ......
Step 1: log on admin portal
Step 2: select menu 'Services' - 'JDBC' - 'Data Source' and click New button to create a new data source
Step 3 : specify jndi name ad database
Step 4 : click Next button to set transaction properties
Step 5 : define connection properties
Step 6 : test databa ......