Creating Tablespace with multiple Datafiles.

From: Jigar Parsana <jigarparsana_at_yahoo.com>
Date: 9 Dec 2002 08:13:57 -0800
Message-ID: <a079a49c.0212090813.4e845e2d@posting.google.com>

Hi ,

I am trying to create a tablespace with multiple data files.here is the statement i am using

CREATE TABLESPACE RBSP
DATAFILE 'D:\oracle\oradata\epidb\rbsp01.dbf' SIZE 500M, DATAFILE 'D:\oracle\oradata\epidb\rbsp02.dbf' SIZE 100M AUTOEXTEND ON NEXT 5120K MAXSIZE 500M
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS 200 OPTIMAL 15M); this statement is actully a part of the database creation script that was prepared by our dba. apparantly everytime i try to execute this script the above statement gives an error saying "invalid file name" for the second datafile. I dont know what is going wrong here....any help will be highly appreciated.

thanx in advance,

jigar Received on Mon Dec 09 2002 - 10:13:57 CST