Re: Oracle 8.1.7 for linux. missing tablespace

Lamar Williams <lamar_at_moOFus.com> wrote:
> I create a tablespace using the following:
>
> CREATE TABLESPACE ep3
> DATAFILE '/u/u02/oradata/noisy/ep3tb1.dbf'
> SIZE 100M;
>
> 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 would guess that it's not showing up in that particular query because there aren't actually any tables in it yet.

How about:

   select name from V$TABLESPACE

miguel Received on Fri Dec 01 2000 - 18:39:20 CET