Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02236
Hi,
You can create additional tablespaces. Your problem lies in either the name you picked or the way you specified in your create statement. Use the datafile clause that follows as a model and be sure to include the single quotes.
DATAFILE '/dbs/01/ora_data/new_space_file_one' SIZE 500M
regards
Jerry Gitomer
tssr_at_my-deja.com wrote in message
<7pc014$4v1$1_at_nnrp1.deja.com>...
>I am getting this error ORA-02236 when I am trying to create a
>tablespace. It says invalid file name. I had used the default
option to
>install the oracle8i with the starter database coming with the
>installer. Can I create other tablespaces when using the default
>database option.
>Any suggestions
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Aug 17 1999 - 11:42:03 CDT