Re: Cannot add data file!?

Jack Zhu wrote:

> Linux 8.0.5 on Red Hat Linux 6.0.
>
> When I try to add a datafile in 'svrmgrl', I issue:
>
> alter tablespace <tablespace name> add datafile '<file name>';
>
> The error message is:
>
> ORA-01119: error in creating database file '<file name>'
> ORA-27037: unable to obtain file status
> Linux error: 2 No such file or directory
> Additional information: 3
>
> I use the 'oerr' to check the error, it said related to available space.
> But I'm pretty sure that I have enough space to create this file. And
> the directory which I used to create the file does exist.

Are you giving the complete file name? Does Oracle have permissions to create a file in the directory that you specify? Received on Tue Aug 31 1999 - 11:56:34 CDT