何查看数据库名呢?方式有三: ·使用SQL语句:select name from v$database; ·使用show命令:show parameter db_name; ·查看参数文件:查看init.ora文件
我不知道,哭。用SQL*PLUS登入的时候用户名随便写一个,然后密码写的是as sysdba,恩确定进去了,提示输入密码,然后我输了个密码,然后就显示: 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options 怎么知道连哪个库上呢。哭
我用wangchao作用户名,密码是as sysdba,进去SQL*plus,然后提示输入密码:我输了个66666,然后显示 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options 但是,输入select username,default_tablespace from dba_users后,我这个用户wangchao咋没有呢
select username,default_tablespace from dba_users where username=upper('wangchao');
sys@ORCL(192.168.21.110)> select username,default_tablespace from dba_users where username='ZXF2';USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
ZXF2 USERS已用时间: 00: 00: 00.03
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
怎么知道连哪个库上呢。哭
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
但是,输入select username,default_tablespace from dba_users后,我这个用户wangchao咋没有呢