====== Get Objects From Current Schema ====== ===== List tables ===== select table_name from user_tables; ===== List indexes ===== select index_name, table_name from user_indexes;
select table_name from user_tables;
select index_name, table_name from user_indexes;