摘要:
su - oracle sqlplus / as sysdba 如果是pdb模式,先执行 alter session set container=XXX(服务名); 不确定pdb的服务名的话执行一下 show con_name 解锁用户 alter user XXX account unlock; 阅读全文
摘要:
#解锁用户 alter user XXX account unlock; #修改密码 alter user XXX identified by passwd; #切换pdb容器 alter session set container=xxxpdb; #重启Oracle 服务 shutdown imm 阅读全文
摘要:
#PG drop database XXX;drop user XXX; #SQLServer use [XXX];drop login [XXX]; use [master];drop DATABASE XXX; #Oracle drop tablespace XXXincluding conte 阅读全文
摘要:
#PG alter user XXX with password 'XXX'; #SQLServer alter login XXX with password='XXX' #Oracle alter user XXX identified by XXX; #DM alter user XXX id 阅读全文