Problem

get the list of tables for a specified tablespace .

Solution

First find if the required tablespace exists Then logon as user e.g sqlplus rpuser/rpuser set pause on select table_name from user_tables;

.

-- SujataPatil - 01 Jun 2006