关于oracle的基础

Question

 怎么知道我当前使用的数据表是属于哪个数据库中的 。。oracle；

Answer 1

你有没有用oracle的一些工具!如:TOAD, PL/SQL DEVELOPER!
这些工具一登陆就要让你选用户!

Answer 2

就比如我现在用scott用户登陆，查询一个表的数据select * from table.现在我想知道找个表他所在的数据库是哪个
懂了吗

Answer 3

如果是想知道表属于那个实例的话可以这样看：
在SQL/PLUS中：
conn / as  sysdba;
select INSTANCE_NAME from v$instance;

Answer 4

SQL> conn scott/zy
已连接。
SQL> select INSTANCE_NAME from v$instance;INSTANCE_NAME
----------------
zy
还是看不懂，zy是一个数据库实例？

Answer 5

show parameter v$instance_name;--查看实例名

Answer 6

php连接oracle的时候
$sql="select * from login where userName='".$_POST['txtName']."'and usePwd='".$_POST['txtPwd']."'";
$user = 'scott';
$pass = 'oracle';
$conn =ocilogon($user, $pass,'orcl');//连接oracle数据库这里的ocilogon的第三个参数是些数据库的实例名吗？

Answer 7

你用PLSQL DEV登录的时候，下边不是有选择数据库的选项么？看看是哪个就是哪个

Answer 8

Not logged onSQL> connect cvbom/******@oamis as sysdba
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 
Connected as SYSSQL> 
SQL> select *
  2    from sys.obj$
  3   where name = 'DEPT'
  4     and type# = 2
  5  ;      OBJ#   DATAOBJ#     OWNER# NAME                            NAMESPACE SUBNAME                             TYPE# CTIME       MTIME       STIME           STATUS REMOTEOWNER                    LINKNAME                                                                              FLAGS OID$                                 SPARE1     SPARE2     SPARE3 SPARE4                                                                           SPARE5                                                                           SPARE6
---------- ---------- ---------- ------------------------------ ---------- ------------------------------ ---------- ----------- ----------- ----------- ---------- ------------------------------ -------------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------
     30137      30137         59 DEPT                                    1                                         2 2002-5-12 2 2002-5-12 2 2002-5-12 2          1                                                                                                                          0                                           6          1                                                                                                                                                                              
     30308      30308         61 DEPT                                    1                                         2 2009-3-13 1 2009-3-13 1 2009-3-13 1          1                                                                                                                          0                                           6          1                                                                                                                                                                              SQL> 
SQL> select *
  2    from (select *
  3            from sys.obj$
  4           where name = 'DEPT'
  5             and type# = 2) obj,
  6         sys.user$ usr
  7   where obj.owner# = usr.user#
  8     and usr.name = 'CVBOM';      OBJ#   DATAOBJ#     OWNER# NAME                            NAMESPACE SUBNAME                             TYPE# CTIME       MTIME       STIME           STATUS REMOTEOWNER                    LINKNAME                                                                              FLAGS OID$                                 SPARE1     SPARE2     SPARE3 SPARE4                                                                           SPARE5                                                                           SPARE6           USER# NAME                                TYPE# PASSWORD                          DATATS#    TEMPTS# CTIME       PTIME       EXPTIME     LTIME        RESOURCE$ AUDIT$                                    DEFROLE    DEFGRP# DEFGRP_SEQ#    ASTATUS     LCOUNT DEFSCHCLASS                    EXT_USERNAME                                                                         SPARE1     SPARE2     SPARE3 SPARE4                                                                           SPARE5                                                                           SPARE6
---------- ---------- ---------- ------------------------------ ---------- ------------------------------ ---------- ----------- ----------- ----------- ---------- ------------------------------ -------------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------- ---------- ------------------------------ ---------- ------------------------------ ---------- ---------- ----------- ----------- ----------- ----------- ---------- -------------------------------------- ---------- ---------- ----------- ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------
     30308      30308         61 DEPT                                    1                                         2 2009-3-13 1 2009-3-13 1 2009-3-13 1          1                                                                                                                          0                                           6          1                                                                                                                                                                                                  61 CVBOM                                   1 A15041D3AB216019                       12          2 2009-3-13 9 2009-3-13 9                                  0                                                 1                                 0          0 DEFAULT_CONSUMER_GROUP                                                                                                                                                                                                                                                                                             SQL> 
SQL> disconnect
Not logged onSQL>