Re: moving a datafile ....

From: Jeremy Russell <jeremyr_at_techie.com>
Date: Tue, 12 May 1998 14:03:58 GMT
Message-ID: <35585692.48680003_at_news.dircon.co.uk>


Did you miss the first "/" out on statement 3)

Should it read as below?

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'


Giuseppe <dedonno_at_ariadne.it> wrote:

>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
>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 - 16:03:58 CEST

Original text of this message