can anyone tell me how can i see all the tables of some other schema in oracle.

i can use 'select * from tab ' for seeing all the tables in my schema but if i want to see all the tables of some say'xyz' schema , how can i do that. what is the sql command for that ?
i do have the priviledge to see the tables of the schema

look at all__tables

u mean 'select * from <schema_name>.all_tables' ????

i need to see all tables of a specific schema.

Please be aware, you will ONLY see those tables that you have privilege to see. Next time when someone says look at a table, at least do a describe of the table.

Select Table_name From All_tables Where Owner = 'specific_schema';

The former suggestions are fine but you may also consider this one

First, It depend on whether your account has select right on other schemas

If it does, then this may work :

SELECT TABLE_NAME, OWNER FROM ALL_TABLES;

OR

SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER IN ('schema1','schema2' ,...)

OR
WHEN LOGGED IN AS SYSDBA
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER IN ('schema1','schema2' ,...)

This statement lists all tables and their owners for you

Hope it works

1. Dredges up a 2 month old post.
2. Adds nothing to the previous posts.
3. advises agaist best practices (do not log in as sysdba to perform such tasks. sysdba is a very special type of user and Oracle can and will behave differently when logged in as sysdba. Only log in as sysdba to perform tasks that only sysdba can perform).
4. Predicate would cause no data to return as Owner column stores data in upper case.

Please read this document:
How to Use the Data Dictionary
The Data Dictionary