Re: data files moved ?

On Thu, 20 Aug 1998 21:37:47 GMT, moros_at_hcal.com (Mike) wrote:

>this sounds a little crazy, but i don't know what really happened so
>it may be ok...
>
>oracle data files (specifically the .dbf files for an application's
>tablespaces) are not where they are supposed to be.
>
>the file was: /database/oradata/DEV/rcrrun1.dbf
>
>now it is:
>/apps/app/oracle/product/7.3.2/dbs/databaseoradataDEVrcrrun1.dbf
>
>I don't know if UNIX moved this, or oracle moved this...the database
>is up and running with all data intact, all necessary files are ok and
>active, users can connect, shut-down and start-up works ok and the
>control file trace shows that the instance knows about these files.
>
>any ideas ?????????????????
>
>ps: Oracle 7.3.2, Solaris 2.5, Sun UNIX

I strongly suspect that the file has always been where it is now. If the tablespace was created by a script, and something (e.g. an incorrect global replace) wiped out the / characters before the script was run, you would get exactly what you have got, i.e. a file with a long name in the default location ($ORACLE_HOME/dbs).

Regards,

Eric Received on Fri Sep 04 1998 - 00:00:00 CDT