select object_id from user_objects where object_type = 'TABLE'
and object_name = '表名';

------解决方案--------------------
SQL code
select object_id from user_objects where object_name='infos'

------解决方案--------------------
探讨

SQL code
select object_id from user_objects where object_type = 'TABLE'
and object_name = '表名';


------解决方案--------------------

SQL> select t.object_name,t.object_id from user_objects t where t.object_name='TB2';
  
OBJECT_NAME                                                                       OBJECT_ID
-------------------------------------------- ----------
TB2                                                                                   51332
  
SQL> alter table tb2 rename to tb3;
  
Table altered
  
SQL> select t.object_name,t.object_id from user_objects t where t.object_name='TB2';
  
OBJECT_NAME                                                                       OBJECT_ID
-------------------------------------------- ----------
  
SQL> select t.object_name,t.object_id from user_objects t where t.object_name='TB3';
  
OBJECT_NAME                                                                       OBJECT_ID
-------------------------------------------- ----------
TB3                                                                                   51332
  
SQL>

------解决方案--------------------
探讨

SQL> select t.object_name,t.object_id from user_objects t where t.object_name='TB2';
 
OBJECT_NAME OBJECT_ID
-------------------------------------------- -------……


------解决方案--------------------
最好的方法就是自己去试验一把！