后山遊子

oracle TNS 字串設定,SID的定義

EBS3 = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.XXX)(PORT=152X))
                (CONNECT_DATA=(SID=EBS3))
            )

 

查詢SID的語法

select * from v$instance;

查TABLE物件

SELECT * FROM DBA_OBJECTS A
  WHERE A.OBJECT_TYPE = 'TABLE'
 

 

 

文章簽名檔