failed create tablespace command

[anthony...@my-deja.com]

I am a novice on Oracle DBA, can anyone tell me
why the command below fails, thanks.

SQL> create tablespace Portal datafile portal.dbf
size 50M;
create tablespace Portal datafile portal.dbf size
50M
*
ERROR at line 1:
ORA-02236: invalid file name

Sent via Deja.com http://www.deja.com/
Before you buy.

[Yannick KERMABON]

Hi

Use single quote to enclose your file name and try to specify the entire
path :

create tablespace portal datafile '/database/portal.dbf' size 50M;
for unix

create tablespace portal datafile 'd:\database\portal.dbf' size 50M;
for NT

Hth

Yannick

anthony...@my-deja.com a écrit :

[Howard J. Rogers]

<anthony...@my-deja.com> wrote in message
news:8moea0$hdc$1...@nnrp1.deja.com...

> I am a novice on Oracle DBA, can anyone tell me
> why the command below fails, thanks.
>
>
> SQL> create tablespace Portal datafile portal.dbf
> size 50M;
> create tablespace Portal datafile portal.dbf size
> 50M

The correct syntax is:
create tablespace X datafile 'path/filename' size xM;

IE, it appears that you are missing some single quotes around the path and
filename bit. Stick a couple around 'portal.dbf' and you might be in
business -though it sounds dodgy to me to be creating files without a
fully-qualified path in front of them.

Regards
HJR