Re: creating table spaces

Yes, you can drop the datafiles.

To determine if a datafile is part of the database, perform the following SQL Statment, while logged in as System or Sys.

Select name from v$datafile;

The result will give you all the physical files associated to your DB...With the exception
of the Redo Log, Control Files, and Init.Ora.

Greg

news:3AD654C3.EB6A7E34_at_savvion.com...
> Hi,
>
> I just created 2 tables, let's call them X and Y by using "create
> tablespace" command. each created 1 file let's call them X.ORA and
> Y.ORA.
>
> NOW... I dropped both table spaces by "drop tablespace" and I commited
> my
> transaction. Strange thing is that, the tablespaces where dropped from
> the dba_tablespaces table but the .ORA files were not removed. can I
> removed these files manually? (knowing that no user is using those
> tablespaces)
>
> -maz
>
>
> --
> ---------------------Use e-mail. It saves trees----------------------
> Maz Mohammadi Senior Member of the Technical Staff
> mailto:maz_at_savvion.com (408)330-3101
> http://www.savvion.com Savvion Inc.
>
> "Ask not what your programmer can do for the company! Ask what the
> company can do for your programmer."
>
> -- Yours Truely
Received on Fri Apr 13 2001 - 09:46:05 CDT