Re: Creating Tablespace with multiple Datafiles.

Hi Jigar,

Any reason for not using just one datafile of 600M? The name of the tablespace *suggests* it is meant to contain rollback segments. IF that's the case I think you should alter your default storage clause. Personally I'd prefer equally sized extents in rollback segments (INITIAL=NEXT). Many threads are dedicated to using OPTIMAL. I never do.

regards,
Peter

"Jigar Parsana" <jigarparsana_at_yahoo.com> schreef in bericht news:a079a49c.0212090813.4e845e2d_at_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 Tue Dec 10 2002 - 00:41:06 CST