MOSS2007µÄBDCÁ¬½ÓORACLEÊý¾Ý¿â
×÷ΪÊý¾Ý¼¯³ÉµÄMOSS×é¼þBDC£¬ÔÚMOSS2007°æ±¾Öл¹Óкܶ಻³ÉÊìµÄµØ·½£¬ËäÈ»¿ÉÒÔ´æÈ¡ÆäËûÊý¾Ý¿âÖеÄÊý¾Ý£¬µ«ÅäÖÃȷʵºÜ¸´ÔÓ£¬È±Ê¡µÄ¹¤¾ßÒ²ºÜÈõ£¬ÕâÊÇÔÚÒ»¸öÏîÄ¿ÖÐÓõ½µÄÁ¬½ÓORACLEÊý¾Ý¿âÅäÖÃÎļþ£¬¼Í¼ÔÚ´ÎÒÔ±ãºóÓá£
<?xml version="1.0"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD" Type="Database" Version="1.0.0.0" Name="OracleLOBSystem" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
<Properties>
<Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
<LobSystemInstances>
<LobSystemInstance Name="OracleInstance">
<Properties>
<Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property>
<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
<Property Name="RdbConnection Data Source" Type="System.String">(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = djin-pc)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = umboydb.bingosoft)))</Property>
<Property Name="RdbConnection Pooling" Type="System.String">false</Property>
<Property Name="RdbConnection User ID" Type="System.String">system</Property>
<Property Name="RdbConnection Password" Type="System.String">123456</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String" />
<Property Name="WildcardCharacter" Type="
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
ÈçºÎʹexpµÄ°ïÖúÒÔ²»Í¬µÄ×Ö·û¼¯ÏÔʾ:
ÖÐÎÄÏÔʾ£ºset nls_lang=simplified chinese_china.zhs16gbk
Ó¢ÎÄÏÔʾ£ºset nls_lang=American_america
EXPµÄËùÓвÎÊý£¨À¨ºÅÖÐΪ²ÎÊýµÄĬÈÏÖµ£©£º
USERID Óû§Ãû/¿ÚÁî È磺 USERID=duanl/duanl &nbs ......
ÒÔϾÝ˵ÃüÁî¾ùÖ¸ÔÚPL/SQLÖУ¬ÔÚCommand WindowÖÐÖ´ÐеÄÃüÁî¡£
²»¶ÏËѼ¯ÕûÀí
1¡¢the account is locked"µÄ½â¾ö·½·¨
ÓÃsysÒÔsysdbaµÄÉí·ÝÀ´½øÐеǼ,ÔÚsys״̬ÊÇlockedµÄʱºòÒ²ÊÇÄܵǼµÄ.È»ºóÔÙʹÓÃÃüÁî
alter user sys account unlockÀ´½øÐнâËø ......
--µ±ÇëÇóÖ´Ðкó²»ÄÜ"²é¿´Êä³ö"µÄʱºò±íʾÓнø³ÌËÀËøÁË
--²éÕÒËÀËøµÄ½ø³Ì
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time
--ɾ³ýËÀËøµÄ½ø³Ì£¬É¾³ýµ±ÌìǰµÄ£¬²»ÄÜɾ³ýµ±ÌìµÄ£¬
--alter system kill session 't2.sid,t ......
-- ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)
select c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name
from user_constraints c,user_cons_columns cc,user_cons_columns rcc
where c.owner=' ......