Re: adding datafile

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 2 Apr 2001 11:07:16 +0100
Message-ID: <986206053.14301.0.nnrp-09.c30bdde2@news.demon.co.uk>

He should specify a drive letter as well, ie, a fully qualified filename.

It's never going to be a good idea to use relative pathnames in Oracle...

eg. 'c:\orawin95\database\frft1.ora'

"Myron Wintonyk" <Myron.Wintonyk_at_UAlberta.ca> wrote in message news:9a6tj4$dqj$1_at_kraken.itc.gu.edu.au...
> Looks like you forgot the initial \
> i.e. datafile '\orawin95\database\frft1.ora'
>
> <hanton32_at_hotmail.com> wrote in message
news:9a2f87$8rf$1_at_news.netmar.com...
> > I am using Oracle 7 on Windows 95 and am trying to add a datafile but
I'm
> > getting errors, any help ?
> > 1 Alter
> > 2 tablespace user_data add datafile 'orawin95\database\frft1.ora'
> > 3* size 10M autoextend off
> > SQL> /
> > Alter
> > *
> > ERROR at line 1:
> > ORA-01119: error in creating database file 'orawin95\database\frft1.ora'
> > ORA-09200: sfccf: error creating file
> > OSD-04002: unable to open file (OS 3)
> >
> >
> > thanks
> >
> > ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb -----
> > http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
> > NewsOne.Net prohibits users from posting spam. If this or other
posts
> > made through NewsOne.Net violate posting guidelines, email
> abuse_at_newsone.net
>
>
Received on Mon Apr 02 2001 - 05:07:16 CDT