Please Solve this Issue

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
kamran.it
Posts: 34
Joined: Tue Aug 01, 2006 7:43 am
Location: Pakistan

Please Solve this Issue

Post by kamran.it »

Please open this link and read and help

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

best regards
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

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

Who is online

Users browsing this forum: No registered users and 1 guest