Re: Adding Another Datafile

soiled_cheetah wrote:
> Hello Guys,
> I am on oracle 8.1.7 version Windows 2000 Server. Using Enterprise
> manager i added another datafile (INDX02.DBF) of 500 MB into existing
> INDX tablespace which already contained one Datafile INDX01.DBF. Upon
> creation of new Datafile Oracle Enterprise Manager gives the extension
> of ".ora" for any newly created Datafile. I changed this ".ora"
> extesion and created the Newly Datafile as INDX02.DBF instead of
> INDX02.ora which would have been the default behaviour of Oracle for
> creation of any new datafile.
> Now all the users are unable to insert the Records. Changing the
> Extension to .DBF instead of .ORA could be the reason for this ?????
> I need you advice on this. If this is so what can i do to over come
> this problem . and yes ofcourse one more thing .. MY Database is in non
> Archivelog mode.

What is the exact error your users are getting?

Also, what is the output of running the following as SYSTEM:

select tablespace_name, file_name
from dba_data_files; Received on Tue Apr 11 2006 - 08:59:36 CDT