moving a datafile ....

From: Giuseppe <dedonno_at_ariadne.it>
Date: Tue, 12 May 1998 12:52:58 +0200
Message-ID: <35582A0A.B58D438_at_ariadne.it>

Hi,
I want to move a datafile dati.dat from
/export/opt/app/oracle/product/7.3.2/dbs to
/export/opt/app/oracle/tablespace/users.

I done the following procedure:
1) alter tablespace users offline
[Quoted] 2) cp /export/opt/app/oracle/product/7.3.2/dbs/dati.dat

        /export/opt/app/oracle/tablespace/users/dati.dat 3) alter tablespace users rename datafile

        'export/opt/app/oracle/product/7.3.2/dbs/dati.dat' to
        '/export/opt/app/oracle/tablespace/users/dati.dat'

but now I had the error:
ORA-01525: error in renaming data files
ORA-01522: file 'dati.dat' to be renamed does not exist

???
The file dati.dat is in the path
/export/opt/app/oracle/product/7.3.2/dbs/ !!!!

How can I move the file?

Thank, best regards......Giuseppe Received on Tue May 12 1998 - 12:52:58 CEST