ORacle数据库 更新表名

1. alter table t_biz_file rename to t_biz_file_test;

2. CREATE TABLE t_biz_file AS SELECT * FROM t_biz_file_test;
   drop table t_biz_file_test;

查询数据库的某一类表
select * from user_tab_comments where table_name like
‘T_BIZ_FILE%’;

查询数据库的所有表
select * from user_tab_comments;