Get list of table names in different schema of an Oracle database

Question

Possible Duplicate:
Oracle: get list of all tables?
How do I list all tables in a schema in Oracle SQL?

I want to list all table in another schema.

connect hr/hr; 
select table_name from user_tables;

but I want to skip the "connect" command. I want to run query from another schema. Is that possible to do?

[This looks like a dup](http://stackoverflow.com/questions/2247310/how-do-i-list-all-tables-in-a-schema-in-oracle-sql) — EvilTeach, Dec 10 '11 at 14:16

score 21 · Accepted Answer · answered Dec 10 '11 at 12:56

21

SELECT TABLE_NAME 
FROM ALL_TABLES 
WHERE OWNER='OTHER-SCHEMA'

answered Dec 10 '11 at 12:56

EvilTeach

1 Answers1