Oracle Database Discussions

Hi ,

I was going to add a datafile to a tablespace in my local win764 bit machine and I have my directory as C:\temp\myOracle11g\oradata\orcl

The name of the datafile is infa_repo_tbspc_01.dbf.

So tried as

CREATE SMALLFILE TABLESPACE infa_repo

     DATAFILE C:/temp/myOracle11g/oradata/orcl/infa_repo_tbspc_01.dbf SIZE 50,

     DATAFILE C:/temp/myOracle11g/oradata/orcl/infa_repo_tbspc_01.dbf SIZE 50

AUTOEXTEND OFF

     BLOCKSIZE 8192

     FORCE LOGGING

     ONLINE

     FLASHBACK OFF;

But it gives error as ora-02236 invalid file name. Tell me where did i go wrong?...