在PLSQL工具的命令窗口输入:
SQL> select instance_name,status,version,database_status from v$instance;
得到:
INSTANCE_NAME STATUS VERSION DATABASE_STATUS
---------------- ------------ ----------------- -----------------
tobacco OPEN 10.2.0.1.0 ACTIVE
tobacco就是你表所在的实例