Re: Error in creating tablespace

From: ASHRAF SALAYMEH <ashraf_salaymeh_at_yahoo.com>
Date: Thu, 20 Sep 2001 01:08:41 -0700
Message-ID: <F001.0039346C.20010920011028@fatcity.com>

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).

Received on Thu Sep 20 2001 - 03:08:41 CDT