Please open this link and read and help
http://forums.oracle.com/forums/thread. ... 0&tstart=0
best regards
Please Solve this Issue
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.
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.
Who is online
Users browsing this forum: No registered users and 1 guest