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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
