Re: Cannot delete system02.dbf file

Captain wrote:
> Hi all gurus,
>
> I have personal oracle 8i on Win Xp. starting to learn oracle 8i.
>
> By error created an extra system02.dbf file in personal oracle 8i
> using dba studio.
> Tried to delete system02.dbf using dba studio and it does allows to
> delete.
>
> I'm stuck and it is consuming lots of space in my computer. Please
> help me to remove system02.dbf file.
>
> nat
>

Oracle 8i is not supported on Windows XP. Look at using a supported version.

You cannot drop a datafile from a tablespace. Since this datafile is for the SYSTEM tablespace, you will have to recreate the database to resolve this issue.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com