很久没有使用sqlplus创建表空间和用户了，需要的时候竟然忘记了密码，试了好多次都没连接上，进而用户也被锁定，在网上找了一些资料，问题解决了，希望对和我一样情况的朋友们有所帮助。
1.安装时选择的自动安装，忘了用户名和密码导致现在试了几个默认的用户名密码後（表格中附带默认用户名及密码），都提示无效的用户名、密码，
|
Username |
Password |
Description |
See Also |
|
CTXSYS |
CTXSYS |
The oracle Text account |
Oracle Text Reference |
|
DBSNMP |
DBSNMP |
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database |
Oracle Enterprise Manager Grid Control Installation and Basic Configuration |
|
LBACSYS |
LBACSYS |
The Oracle Label Security administrator account |
Oracle Label Security Administrator's Guide |
|
MDDATA |
MDDATA |
The schema used by Oracle Spatial for storing Geocoder and router da |
Oracle Spatial User's Guide and Reference |
|
MDSYS |
MDSYS |
The Oracle Spatial and Oracle interMedia Locator administrator account |
Oracle Spatial User's Guide and Reference |
|
DMSYS |
DMSYS |
The Oracle Da |
Oracle Da Oracle Da |
|
OLAPSYS |
MANAGER |
The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite). |
Oracle OLAP Application Developer's Guide |
|
ORDPLUGINS |
ORDPLUGINS |
The Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema. |
Oracle interMedia User's Guide |
|
ORDSYS |
ORDSYS |
The Oracle interMedia administrator account |
Oracle interMedia User's Guide |
|
OUTLN |
OUTLN |
The account that supports plan stability. Plan stability enables you to maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines. |
Oracle中使用alter table来增加,删除,修改列
oracle中使用SQL语句修改字段类型-oracle修
使用低权限Oracle数据库账户得到管理员权限
Oracle对user的访问控制
查看所有0条评论>>