RE: Disk space utilization

[Former Member]

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

[Former Member]

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,

[Former Member]

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

[Former Member]

hi Somya,

You can move the datafile using brtools (database in mount state) :

2 - Space management

6 - Move data file

http://service.sap.com/dbaora

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

[Former Member]

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,