Hi ...
Might be your disk drive currpted, so that oracle unable to create the
datafile on that drive, Try do create with some
other drive. If not contact oracle support.
Nirmal.
> -----Original Message-----
> From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Error in creating tablespace
>
> 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: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
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).
