Oracle 8.1.7 sap 46C
用<SID>adm登录svrmgrlconnect internal/*本句用来,查询一下,是否有此记录。正常情况下,显示: 1 row(s) selected. */select * from sapr3.usr02 where bname='SAP*' and mandt='000';/*删除此记录。防止拼错,最好直接从上一句copy*/delete from sapr3.usr02 where bname='SAP*' and mandt='000';commit;
Oracle 9.2.0 SAP 4.70
<sid>是实例名,如PRD,C11等sqlplus /nologconnect / as sysdba*本句用来,查询一下,是否有此记录。正常情况下,显示: 1 row(s) selected. */select * from sap<sid>.usr02 where bname='SAP*' and mandt='000';/*删除此记录。防止拼错,最好直接从上一句copy*/delete from sap<sid>.usr02 where bname='SAP*' and mandt='000';commit;
db2 => connect to <SID>
db2 => select * from sap<sid>.usr02 where bname='SAP*' and mandt='000'
1 record(s) selected.
db2 => delete from sap<sid>.usr02 where bname='SAP*' and mandt='000'DB20000I
The SQL command completed successfully.
db2 => commitDB20000I
The SQL command completed successfully.