on 03-28-2008 10:24 AM
Hi all,
We have SAP IDES installed on Windows Server 2003 with oracle database. Now we want to move the one datafiles to different drive as the current drive almost full. How do i go about this?
Help me solve this problem.
Thanks in advance
Regards,
Sowmya
Hai,
Use BRTOOLS if you got the latest version or else use SAPDBA for older versions.
You can move the Datafiles fromone location to other.But make sure to take the proper backup before doing.
Thanks and Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The safest way is to use Brtools if you are not comfortable with DB.
Start brtools,
Choose
2 - Space management
then
6 - Move data file
then specify
3 ~ Tablespace names (tablespace) .. -<-- Mention the tablespace name
4 ~ Data file names (file) ......... -<- Mention /oracle/<SID>/sapdata2/temp_1/temp.data1
next specify the new location and continue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Somya,
You can move the datafile using brtools (database in mount state) :
2 - Space management
6 - Move data file
-> Media Library
-> General
-> SAP Database Guide: Oracle
-> Section: 4.2.2.6 - Moving a Data File with BR*Tools
Regards
Ariyanto
Edited by: Ariyanto Hong on Apr 2, 2008 10:48 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sowmya,
Apply the steps below, in order to move one or more datafiles to a new location.
1) Shutdown your database
2) Copy datafile to the new location
3) STARTUP MOUNT
4) ALTER DATABASE RENAME FILE
'/OLD_LOCATION/AND_DATAFILE_NAME.DBF'
TO
'/NEW_LOCATION/AND_DATAFILE_NAME.DBF';
5) ALTER DATABASE OPEN;
You can check whether the data file is altered correctly, by using following sql statement;
SELECT * FROM V$DBFILE;
Best regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.