12 Replies Latest reply on May 19, 2010 6:06 AM by Ronny Egner

    Tablespace  not able to create datafile in mounted windows folder

    773595
      Hi all,

      I am using Linux RHEL , I have mount a Windows shared folder under /mnt/ntserver.
      I have read/write permissions to this mounted shared folder .

      When i login to SQLPLUS and tries to create a tablespace with a datafile pointing to that mounted folder i get the below error

      Line: -----

      [oracle@localhost ntserver]$ sqlplus /nolog

      SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 18 18:21:17 2010

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

      SQL> conn / as sysdba;
      Connected.
      SQL> create tablespace vv datafile '/mnt/ntserver/vv.dbf' size 100M;
      create tablespace vv datafile '/mnt/ntserver/vv.dbf' size 100M
      *
      ERROR at line 1:
      ORA-19510: failed to set size of 12800 blocks for file "/mnt/ntserver/vv.dbf"
      (blocksize=8192)
      ORA-27045: unable to close the file
      Linux-x86_64 Error: 5: Input/output error
      Additional information: 4

      Line: -----

      I have looked up both the error code but am unable to find the solution...

      Thanks in advance,
      Vanlal