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.

Thanks in Advance

soiled_cheetah wrote:
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;

Without any error messages, I can only guess as to the problem. So here
is my guess:

If you renamed the file on the OS level, you will have to tell the
database that you renamed the file with the following command:

ALTER DATABASE RENAME '/directory/old_fn' TO '/directory/new_fn';

If the database is open then you'll want to take the tablespace offline
before performing the rename. So rename the file back to its old
extension, take the tablespace offline, rename the file to its new
extension, issue the ALTER DATABASE command above, then bring the
tablespace back online.

HTH,
Brian


--
================================================== =================

Brian Peasland
oracle_dba (AT) nospam (DOT) 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

Sorry Guys,
I rebuilt the indexes and now the users are working ok. The error came
from the Application Code itself and not from the Database. Pheew
Thanks alot buddies for your Help.

Byeeee
Sam

This is why error messages are important....from the database or the
application. My guess was way off base because I had nothing to go on.
Appropriate error messages might have saved me, and you, some time.

Cheers,
Brian

--
================================================== =================

Brian Peasland
oracle_dba (AT) nospam (DOT) 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