Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.comReceived on Mon Aug 20 2007 - 09:11:08 CDT
![]() |
![]() |