Re: Help

I always understood that "REUSE" meant the file had to exist on the Operating system AND it had to be the exact same size as specified. At least that is how it worked the last time I tried it.

--
Babette Turner-Underwood, TMI Communications babettet_at_tmi.ca.NOSPAM (remove appropriate part to e-mail me)

    Vinay Joshi wrote in message =
<912105297.17592.0.nnrp-09.9e980b2b_at_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