oracledatabaseusersql
oracle服务软件里面装了三个数据库,三个数据库服务都启动了,在登录数据库的时候没有指定数据库名称,所以现在登录到哪个数据库里面自己都不知道。
这三个数据库里面都有test_user用户,且密码都一样,在各自的数据库中也都拥有相同的权限,是以test_user用户登录的。
那么我该用什么命令查看当前是登录了哪个数据库(三个数据库服务都启动着呢)呢?
我知道切换到sys后用下面的命令可以查看当前数据库的名称
sql>show parameter db_name;
或
sql>select name from v$database;
或
sql>select instance_name form v$instance;
但是我不知道sys的密码,数据库是以密码方式验证登录的,不是已系统验证方式登录的!那么我该怎么查看登录的数据库名称呢?
上面的两个数据字典表,v$database和v$instance在test_user用户下是没有权限查看的的!(是数据字典表还是视图呢,刚刚接触oracle里面的概念还不清楚呢)
(附:test_user的权限和scott相同)
说的更直接点,我远程登录别人的oracle,但是他的机器上装了多个数据库,都有我这个用户,我在登录的时候没有指定数据库名称,我该怎么查看我登录的是那个数据库呢?
希望知道的朋友指点,万分感谢!
<iframe id="iframeu1636200_0" src="http://pos.baidu.com/nclm?rdid=1636200&dc=2&di=u1636200&dri=0&dis=0&dai=2&ps=1439x385&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1465805203295&ti=oracle%E4%B8%AD%E6%99%AE%E9%80%9A%E7%94%A8%E6%88%B7%E5%A6%82%E4%BD%95%E6%9F%A5%E7%9C%8B%E8%87%AA%E5%B7%B1%E7%99%BB%E5%BD%95%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%E7%A7%B0%3F%E8%BF%99%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8Escott%E6%9D%83%E9%99%90%E7%9B%B8%E5%90%8C%EF%BC%8C%E6%97%A0%E6%B3%95%E5%88%87%E6%8D%A2%E5%88%B0sys%E4%B8%8B%E9%9D%A2!%E6%B2%A1%E6%9C%89%E6%9D%83%E9%99%90%E6%9F%A5%E7%9C%8Bv%24&ari=1&dbv=2&drs=3&pcs=1349x643&pss=1349x5699&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1465805203&ltu=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390394925%2F&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DUilOoBQ1IbzN0rG1YwOeufV3zo8CdUbR8AaOu8k2qRSHXnCbkptC2aqzwQFMqvUC%26wd%3D%26eqid%3Df0b08f810008a5aa00000003575e6a69&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=true&cmi=6&col=zh-CN&cdo=-1&tcn=1465805203&qn=c394006cde36cf83&tt=1465805203272.29.265.268" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;"></iframe>
<iframe id="iframeu1636201_0" src="http://pos.baidu.com/nclm?rdid=1636201&dc=2&di=u1636201&dri=0&dis=0&dai=3&ps=1439x639&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1465805203295&ti=oracle%E4%B8%AD%E6%99%AE%E9%80%9A%E7%94%A8%E6%88%B7%E5%A6%82%E4%BD%95%E6%9F%A5%E7%9C%8B%E8%87%AA%E5%B7%B1%E7%99%BB%E5%BD%95%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%E7%A7%B0%3F%E8%BF%99%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8Escott%E6%9D%83%E9%99%90%E7%9B%B8%E5%90%8C%EF%BC%8C%E6%97%A0%E6%B3%95%E5%88%87%E6%8D%A2%E5%88%B0sys%E4%B8%8B%E9%9D%A2!%E6%B2%A1%E6%9C%89%E6%9D%83%E9%99%90%E6%9F%A5%E7%9C%8Bv%24&ari=1&dbv=2&drs=3&pcs=1349x643&pss=1349x5699&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1465805203&ltu=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390394925%2F&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DUilOoBQ1IbzN0rG1YwOeufV3zo8CdUbR8AaOu8k2qRSHXnCbkptC2aqzwQFMqvUC%26wd%3D%26eqid%3Df0b08f810008a5aa00000003575e6a69&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=true&cmi=6&col=zh-CN&cdo=-1&tcn=1465805203&qn=fc2ca59bae1d5073&tt=1465805203272.30.276.277" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;"></iframe>
<iframe id="iframeu1636204_0" src="http://pos.baidu.com/nclm?rdid=1636204&dc=2&di=u1636204&dri=0&dis=0&dai=4&ps=1439x893&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1465805203295&ti=oracle%E4%B8%AD%E6%99%AE%E9%80%9A%E7%94%A8%E6%88%B7%E5%A6%82%E4%BD%95%E6%9F%A5%E7%9C%8B%E8%87%AA%E5%B7%B1%E7%99%BB%E5%BD%95%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%E7%A7%B0%3F%E8%BF%99%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8Escott%E6%9D%83%E9%99%90%E7%9B%B8%E5%90%8C%EF%BC%8C%E6%97%A0%E6%B3%95%E5%88%87%E6%8D%A2%E5%88%B0sys%E4%B8%8B%E9%9D%A2!%E6%B2%A1%E6%9C%89%E6%9D%83%E9%99%90%E6%9F%A5%E7%9C%8Bv%24&ari=1&dbv=2&drs=3&pcs=1349x643&pss=1349x5699&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1465805203&ltu=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390394925%2F&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DUilOoBQ1IbzN0rG1YwOeufV3zo8CdUbR8AaOu8k2qRSHXnCbkptC2aqzwQFMqvUC%26wd%3D%26eqid%3Df0b08f810008a5aa00000003575e6a69&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=true&cmi=6&col=zh-CN&cdo=-1&tcn=1465805203&qn=52a05821c6cd0785&tt=1465805203272.32.279.280" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;"></iframe>
对我有用[0] 丢个板砖[0] 引用 | 举报 | 管理
回复次数:9