Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: adding datafile

Re: adding datafile

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 31 Mar 2001 10:44:27 +0100
Message-ID: <3ac72c9b$0$15024$cc9e4d1f@news.dial.pipex.com>

I must confess to not having used Oracle on win95 but the file name you give doesn't look like a valid file name , I'd have expected a drive letter. Also check that you do have the space and that the directories referred to exist.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<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 Sat Mar 31 2001 - 03:44:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US