Need help on DBA-tasks

A few month ago I started with Oracle. Now I have built up a database which works together with several Delphi applications. I understand now tablespaces, tables, segemnts, as far as I need. There is only one problem in the moment, where I am not sure how to solve.

The installation program of Oracle created a temporary tablespace, which contained only one datafile. A very small datafile. Because I was new with Oracle I used the Oracle tools for Windows (database manager, database expander,..) to expand my database. While the tables became larger I added new datafiles to the temporary tablespace. Now I have five datafiles for this tablespace (1M, 2M, 2M, 5M, 20M) and the last two files were created with real storage parameters.

One book suggested how to kill datafiles.

With

> alter database datafile 'name' offline drop;

I tried to get rid of the small file, but this file was still alive. Now I have one further problem: After a few days running, Oracle produces errors on database activities: Cannot access datafile 'name' ORA...

I inspected the dba_data_files table, but there is everything ok. The file "name' is available.

I interrested in, how to get rid off this small files or how to handle the error.

Many thanks for any answer,

Joerg Zentgraf Received on Wed Jan 10 1996 - 00:00:00 CET