hi
i have created two tablespaces t1 and t2 respectively as
create tablespace ts1 datafile 'f:\oracle\oradata\data1\ts1.dbf'size 5m autoextend on;
and
create tablespace ts2 datafile 'f:\oracle\oradata\data1\ts2.dbf'size 5m autoextend on;
i have created two tables namely college and school as follows.
create table college (name varchar(20), location varchar(20)) tablespace ts1;
create table school (name varchar(20), location varchar(20)) tablespace ts2;
in the both tables, i have made insertions(5 in each)
i want to know in which tablespace my tables are existing.
previously, i have tried the following command
select tablespace_name from dba_tables where table_name='college';
the result of my query is
no rows selected
also i have tried this query too
select owner,table_name, tablespace_name from dba_tables where table_name='college';
here too the same results comes
how can i find it?