Re: Adding Another Datafile

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.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