Re: Oracle 8.1.7 for linux. missing tablespace

Thanks Miguel,

The problem was I created the tables after logging as system/manager, thus the
tables I created where in the system tablespace and there where no tables in
the ep3 tablespace.

Is there a graphical utility that lets me view this kind of information?

I'm an newbie.

Lamar

Miguel Cruz wrote:

> 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 - 19:48:58 CET