First thing first... be very carefull!!! you are login into that database like "sa" in the SQL Server world.
Objects in Oracle have a composite name schema_name.object_name
Find out the schema_name that owns the tables you need to target then do...
where table_owner = 'schema_name';
That would gave you a list of the tables.
if tables are not very large you may want to create a query to write the data out as svc... plenty of examples on the net.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.