Re: Help

From: Vinay Joshi <vjoshi_at_pinnacle.co.uk>
Date: Thu, 26 Nov 1998 18:31:21 -0000
Message-ID: <912105297.17592.0.nnrp-09.9e980b2b@news.demon.co.uk>

Hi,
Could it be that you are running out of space in the Operating system = dir
'/local1/oracle/oradata/dev99' ?

Because in the next statement you have used a different dir
'/usr/local/o1/oradata/dev2k'

use the df -iv command to see how much space you have on your disks.

    Paul Nguyen wrote in message <365D347C.4628E585_at_netexplorer.com>...     I was attempting to create a database, as my normal duty. After = creating the database, I issue this command

    in svrmgrl:
    create tablespace usertbs
    datafile
    '/local1/oracle/oradata/dev99/usertbs01.dbf' size 80M reuse     default storage (

     initial 50K 
     next 50K 
     minextents 1 
     maxextents 50 
     pctincrease 0 

    );
    The message I got was "unable to add file or unfound directcreate = tablespace usertbs

    But.. when I change to this:
    create tablespace usertbs
    datafile
    '/usr/local/o1/oradata/dev2k/usrtbs01.dbf' size 30M reuse     default storage (

     initial 1M 
     next 1M 
     minextents 2 
     maxextents 50 
     pctincrease 0 

    );
    and everything okay..the command successfully executed in svmgrl.     Can someone explain to me what is going on ?       

    Thanks in advance Received on Thu Nov 26 1998 - 12:31:21 CST