HOWTO View Tables and Indexes in an Oracle Database Posted on July 4, 2006 by Frank Kim To view the user tables. select * from tab; To view the user indexes. select index_name, table_name from user_indexes;
