Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dropping the Tablespaces & Deleting the archive files.

244352Jul 22 2003 — edited Jul 23 2003

Hi,

I'm running out of space in my DB machine. As a temporary solution I thought of dropping unwanted tablespaces. Could you ppl tell me in the following TBspaces which one is unnecessary for the DB operations.

drsys01.dbf
example01.dbf
indx01.dbf
odm01.dbf
system01.dbf
temp01.dbf
tools01.dbf
undotbs01.dbf
users01.dbf
xdb01.dbf

Also I'm planning to delete the archives, as I don't have space in the machine to move them. Will it affect the DB operations ?

Pls forgive me if the questions doesn't make any sense, as I'm not a DBA.

Regards

MS

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2003

Added on Jul 22 2003

#general-database-discussions

3 comments

489 views