ERPstuff - Oracle EBS Community

Please open this link and read and help

http://forums.oracle.com/forums/thread. ... 0&tstart=0

best regards

You should migrate to latest version of Oracle else you will face different support issues. Now first how to resolve the issue,

1 - Shutdown the database
2 - Take Backup
3 - login as internal
4 - startup mount
5 - alter datafile 'd:\database\datafile.dbf' offline; << change as your path
6 - select name, status from v$datafile; << check status
7 - alter database open;
8 - create a new tablespace and assign this to your user.
9 - Import the data from the dump file into this user.

Have a nice day.