Oracle 8.1.7 for linux. missing tablespace

Hello all,

I create a tablespace using the following:

CREATE TABLESPACE ep3
DATAFILE '/u/u02/oradata/noisy/ep3tb1.dbf' SIZE 100M; This succeeds OK.

Then I run the following command:

select unique tablespace_name from all_tables ; // I tried as every user.

and "EP3" does not show up. My programs can't find it either. I've done this before and it worked. What am I missing?

I can drop the tablespace:

drop tablespace EP3;

This works OK.

Thanks

Lamar Received on Fri Dec 01 2000 - 08:36:06 CET