Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02236

Re: ORA-02236

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 17 Aug 1999 12:42:03 -0400
Message-ID: <7pc3ds$bd2$2@autumn.news.rcn.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US