Search:

If you are on the same server you can just set SID and then connect using SQL*Plus.

Host string for what ?

What tool are you using ? SQL*Plus or something else ?

If you want to just read about tablespace, you can start here...

Tablespaces, Datafiles, and Control Files

Another good place to start is Oracle Concepts

Contents

A good place to start : Concepts

Contents

You can start with Oracle Databases here...

Database 11g | Oracle Database 11g | Oracle

Is the database on same server ? If yes, set ORACLE_SID and try to connect again. If not, check TNSNames.

How are you trying to connect ?

Try and use subselect...

Select emp_name from
(select emp_name,dept_no,max(salary) from emp group by emp_name,dept_no);

Where is the database ?

Run this before you execute Statement from SQL*Plus

Select owner,table_name from all_tables where table_name like 'TRG_FARINVC%' ;

Show user

Are you connecting as same user from TOAD and...

SQL> create table testing_tbl1 as select * from testing_tbl;

Table created.

SQL> select table_name from user_tables where table_name like 'TESTING%';

TABLE_NAME...