Re: creating table spaces

You have got this request so mixed up I'm not sure where to start.

A table is NOT a tablespace. They are two entirely different things and neither has anything to do with COMMITS.

And I presume by .ORA files you mean that you named your tablespaces something.ora and if that is the case a drop tablespace does not, and should not, delete the file. File deletion must be done in the operating system as a separate activity.

If that isn't what you did then you haven't explained things well ... and it strikes me that you need to get a good beginners book and find someone with some expertise to approve what you do before you do it as otherwise you are going to trash the system.

Daniel A. Morgan

maz wrote:

> 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 Thu Apr 12 2001 - 22:50:38 CDT