Get list of table names in different schema of an Oracle database [duplicate]

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?

Answer 1

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