Re: Cannot add data file!?

Kenneth C Stahl wrote:

> 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?

Yes. Oracle does have the permission, and I give the complete name including the path.

Actually, not only Oracle 805 for linux, now my Oracle 8.0.4 for NT also has the same problem.

Any idea? Thanks a lot! Received on Tue Aug 31 1999 - 11:32:38 CDT