Re: Drop file from SYSTEM tablespace

Hi,

>To drop this file from SYSTEM tablespace I must
>turn SYSTEM tablespace OFFLINE, but this tablespace
>must always be ONLINE.

>How to do this operation?
>How to ensure that this file doesn't contain any important
>information and file dropping will not impact to the database?

Since nobody has answered your question so far and you might be in trouble this weekend, I'll try to give you some hints. Then the pro's can overrule this when they have time ;-)

Maybe you should shut down your database, start the server manager and only start the instance (so, not the startup open command but the startup nomount I guess). From there I guess it must be possible to manipulate the system tablespace. But before that I guess you have to arrange the objects that have been placed on the datafile. For now, I don't know how to check that.

Well, it wasn't much, but maybe it has helped you.....

• Martin (mje_at_telebot.com)

  ---