ORACLEÊý¾Ýµ¼Èë
ÔÚÀûÓÃNETWORK_LINK·½Ê½µ¼³öµÄʱºò£¬³öÏÖÁËÕâ¸ö´íÎó¡£
Ïêϸ´íÎóÐÅÏ¢ÈçÏ£º
bash-3.00$ expdp yangtk/yangtk directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_org
Export: Release11.1.0.6.0 - 64bit Production onÐÇÆÚ¶þ, 16 9ÔÂ, 2008 17:08:22
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Á¬½Óµ½: Oracle Database11gEnterprise Edition Release11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631:ÐèҪȨÏÞ
ORA-39149:ÎÞ·¨½«ÊÚȨÓû§Á´½Óµ½·ÇÊÚȨÓû§
¼ì²éOracleµÄ´íÎóÊֲ᣺
ORA-39149: cannot link privileged user to non-privileged user
Cause: A Data Pump job initiated be a user with EXPORT_FULL_DATABASE/IMPORT_FULL_DATABASE roles specified a network link that did not correspond to a user with equivalent roles on the remote database.
Action: Specify a network link that maps users to identically privileged users in the remote database.
´íÎóÃèÊöµÄ±È½ÏÇå³þ£¬²»¹ýÕâ¸ö´íÎóºÜÄÑÀí½â£¬ÄѵÀÒ»¸öȨÏÞ´óµÄÓû§²»ÄÜͨ¹ýÊý¾Ý¿âÁ´µ¼³öÒ»¸öȨÏÞСµÄÓû§¡£
µ±È»£¬Á˽âÁËÕâ¸ö´íÎóµÄÔÒò£¬ÆäʵÎÊÌâºÜÈÝÒ×½â¾ö¡£ÔÚ±¾µØ´´½¨Ò»¸öÐÂÓû§£¬²»ÒªÊÚȨEXP_FULL_DATABASE/IMP_FULL_DATABASE½ÇÉ«£¬¾Í¿ÉÒÔµ¼³ö£º
bash-3.00$ sqlplus "/ as sysdba"
SQL*Plus: Release11.1.0.6.0 - Production onÐÇÆÚ¶þ9ÔÂ16 16:53:48 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Á¬½Óµ½:
Oracle Database11gEnterprise Edition Release11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> col grantee format a15
SQL> col granted_role format a15
SQL> select grantee, granted_role from dba_role_privs
2 where grantee = 'YANGTK';
GRANTEE GRANTED_ROLE
--------------- ---------------
YANGTK CONNECT
YANGTK RESOURCE
YANGTK DBA
SQL> drop user test cascade;
Óû§Ò
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄLEXERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄLEXERÊôÐÔÓÃÓÚ´¦Àí¸÷ÖÖ²»Í¬µÄÓïÑÔ¡£×î»ù±¾µÄÓ¢ÎÄʹÓÃBASE_FILTER£¬¶øÈç¹ûÐèҪʹÓÃÖÐÎÄÔò¿ÉÒÔʹÓÃCHINESE_VGRAM_LEXER»òCHINESE_LEXER¡£
ÕâÆªÎÄÕ¼òµ¥ËµÃ÷BASIC_LEXERÊôÐÔ¡£BASIC_LEXERÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲ ......
È«ÎÄË÷ÒýÍ£ÓôʵÄÉèÖÃÔÚÇ°ÃæµÄÎÄÕÂÖÐÒѾ½éÉܹýÁË£¬ÕâÀï¼òµ¥ËµÃ÷¼Ç¼һÏÂÍ£ÓôÊÔÚ²éѯʱºòÐèҪעÒâµÄµØ·½¡£
Oracle10gÖУ¬Èç¹û°²×°ÓïÑÔΪÖÐÎÄ£¬Ä¬ÈϵÄLEXERΪCHINESE_VGRAM_LEXER£¬Ä¬ÈϵÄÍ£ÓôÊÓïÑÔҲΪÖÐÎÄ¡£ÕâÆªÍ¨¹ý¶Ô±ÈÖÐÎÄ»·¾³ºÍÓ¢ÎÄ»·¾³À´ËµÃ÷Í£ÓôʲéѯµÄÒ»Ð©ÌØµã¡£
SQL> show user
USER is "MYUSER" ......
ÔÚ´ò°üoralce¿Í»§¶Ëºó£¬¾³£»áÓöµ½Õâ¸öÎÊÌâ“specified class not registered in registry”
½â¾ö°ì·¨£º
ÕâÊÇÒòΪÓм¸¸öÁ´½Ó¿âdll»òocxûע²áµÄÔÒò£¬¾±¾È˲âÊÔΪÒÔÏÂ5¸öÎļþ£º
......
Ŀ¼
1. °²×°×¼±¸
1.1. ÉèÖÃÓû§
1.2. ´´½¨Ä¿Â¼ºÍÉèÖÃȨÏÞ
1.3. ¸ü¸ÄÅäÖÃ
1.4. °²×°
1.5. Æô¶¯/Í£Ö¹Oracle
1. °²×°×¼±¸
°²×°¿ªÊ¼Ç°£¬È·ÈÏÄãµÄϵͳ·ûºÏOracleµÄ×îС°²×°ÒªÇó:
* 500 MB ÄÚ´æ
......