RE: Error in creating tablespace

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:ashraf_salaymeh_at_yahoo.com]
> 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: 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: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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