FANHAOM的博客

删除数据库时报错，有外键关联提示查看关联外键所在表select * from dba_constraints where constraint_name=‘提示的外键’ and constraint_type = ‘R’;table_name是关联表的表名

测试环境Oracle帐户密码忘记多次尝试导致帐户被锁，进入数据库所在服务器：su - oraclesqlplus / as sysdbaselect username,lock_date,account_status from dba_users;可以看到有两个帐户被锁了ALTER USER CMAQK ACCOUNT UNLOCK;ALTER USER CMAQK IDENTIFIE...