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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error in creating tablespace

Re: Error in creating tablespace

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 20 Sep 2001 05:32:41 -0700
Message-ID: <F001.00393716.20010920052017@fatcity.com>

Ashraf,
I know that it sounds far fetched but do you have contigous free space to write the 2 K block that Oracle will try to write on the "C" drive. Do you have any virus protection turned on that prevents you from writing in the "root" directory? Try the same command in a sub directory.
Please post the findings when you get an answer. Thanks,
Ron
ROR mm

>>> ashraf_salaymeh_at_yahoo.com 09/20/01 05:10AM >>> Hi List,

I tryed to create the tablespace from svrmgr30 as satar naghshineh told me.
But i still face the same error...

    CREATE TABLESPACE PAYROLL
    DATAFILE 'C:\PAYROL.ORA' SIZE 10M
    SQL> /
ERROR at line 1:
> > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > range of the file
> > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is

Any one can tell me what I have to do?

Regards,
Ashraf
--- satar naghshineh <satarnag_at_yahoo.com> wrote:
> Salaam Ashraf Jon,
>
> It appears that Oracle has a problem writing to the
> C
> drive to create the datafile on the very first
> block.
> This error is usually the result of a size issue
> over
> 4gb for the datafile or a file that has been
> autoextended. In your case, it appears it doesn't
> like
> the command (maybe some character is being passed
> through the command?).
>
> Delete the file and re-try it again. try doing this
> in
> svrmgrl80 and put a ; at the end.
>
> Good Luck,
> Satar Naghshineh
>
>
>
> --- ASHRAF SALAYMEH <ashraf_salaymeh_at_yahoo.com>
> wrote:
> > Hello list,
> >
> > I'm using Personal Oracle8 Database and Win98
> > Platform
> >
> > I issued this command from Sqlplus8.0 :
> >
> > CREATE TABLESPACE PAYROLL
> > DATAFILE 'C:\PAYROL.ORA' SIZE 10M
> > SQL> /
> >
> > I am trying to create new tablespace Payroll but I
> > have got this error!
> >
> >
> > CREATE TABLESPACE PAYROLL
> > *
> > ERROR at line 1:
> > ORA-19502: write error on file "C:\PAYROL.ORA",
> > blockno 1 (blocksize=2048)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the
> > range of the file
> > OSD-04026: Invalid parameter passed.
> > O/S-Error: (OS 64) The specified network name is
> no
> > longer available.
> >
> >
> > The strange is you can see the PAYROLL.ORA under
> C:\
> > Directory
> > After the error is displayed.
> >
> > But when you query :
> >
> > SQL> select tablespace_name
> > from dba_data_files;
> >
> > you can find nothing, no tablespace is created at
> > all...
> >
> > I wish someone can help me to solve this problem.
> >
> > Best Regards,
> > Ashraf Salaymeh
> >
>
>
> __________________________________________________
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
>
http://dailynews.yahoo.com/fc/US/Emergency_Information/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: satar naghshineh
> INET: satarnag_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>



> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).


Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: ASHRAF SALAYMEH
  INET: ashraf_salaymeh_at_yahoo.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Sep 20 2001 - 07:32:41 CDT

Original text of this message

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