unable to move data files using brtools

[Former Member]

while i am trying to move data files from one drive to another drive i am facing following error

BR0202I Copying E:\ORACLE\TC1\SAPDATA1\TC1_1\TC1.DATA1

BR0203I to G:\oracle\TC1\sapdata1\tc1_1\tc1.data1 ...

BR0252E Function spawnlp() failed for '( copy E:\ORACLE\TC1\SAPDATA1\TC11\TC1.

DATA1 G:\oracle\TC1\sapdata1\tc1_1\tc1.data1 ) > F:\oracle\TC1\sapreorg\.sdveaev

w.000 2>&1' at location BrProgStart-4

BR0253E errno 13: Permission denied

BR0267E Asynchronous execution of program failed

BR0222E Copying E:\ORACLE\TC1\SAPDATA1\TC1_1\TC1.DATA1 to/from G:\oracle\TC1\sap

data1\tc1_1\tc1.data1 failed due to previous errors

waiting for your suggestions

[Former Member]

Hi,

First loginto SQLPLUS, findout on which tablespace TC1.DATA1 belongs then make that tablespace offline

SQL>alter tablespace <tablespace name> offline;

then create a directory TC1_1 in G:\oracle\TC1\sapdata1\, copy the datafile E:\ORACLE\TC1\SAPDATA1\TC1_1\TC1.DATA1 to G:\ORACLE\TC1\SAPDATA1\TC1_1\TC1.DATA1

then

SQL>Alter tablwspace <tablespace name> rename datafile 'E:\ORACLE\TC1\SAPDATA1\TC1_1\TC1.DATA1' to 'G:\ORACLE\TC1\SAPDATA1\TC1_1\TC1.DATA1' ;

SQL>Alter tablespace <tablespace name> online;

Thats it..

regards

Umesh K

[Former Member]

Your oracle should be down for moving the datafiles from one location to another. also you can get more detailed log in oracle alertSID.log. and check whether you have access to G:\ drive and subfolders.

Cheers,

-Sunil