Hello,
I have a problem when renaming the datafile of a tablespace of my local machine to a location server NAS.
Right now, my disk unity is almost full and I want to move that tablespace onto a NAS server.
I'm using oracle version 11.2.0. I don't know if it's possible or if it's recommended to do that.
The steps I execute are:
-
I connect sys as sysdba with sqlplus.
-
I change the status of the tablespace:
ALTER TABLESPACE TEST_TABLESPACE OFFLINE NORMAL.
-
I check if the status of the tablespace is offline.
-
I move the datafile from my local machine to server NAS:
HOST MOVE C:\Oracle11g\app\oracle\oradata\XE\TEST_TABLESPACE_DATA.DBF \\172.16.42.250\oradata\TEST_TABLESPACE_DATA.DBF
-
I rename the new location of the datafile:
ALTER TABLESPACE TEST_TABLESPACE RENAME DATAFILE
'C:\Oracle11g\app\oracle\oradata\XE\TEST_TABLESPACE_DATA.DBF' to '\\172.16.42.250\oradata\TEST_TABLESPACE_DATA.DBF'
And here I get the following error:
ERROR in line 1:
ORA-01525: error in renaming data files
ORA-01141: error renaming data file string - new file '\\172.16.42.250\oradata\TEST_TABLESPACE_DATA.DBF' not found
ORA-01110: datafile 13: 'C:\Oracle11g\app\oracle\oradata\XE\TEST_TABLESPACE_DATA.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: <OS 1326> Logon failure: unknown user name or bad password.
Someone can help me out and explain what is the problem please?
Note: In the server NAS, I don't have installed anything about oracle, I only move the datafiles.
Thank you