Error in creating tablespace

From: ASHRAF SALAYMEH <ashraf_salaymeh_at_yahoo.com>
Date: Wed, 19 Sep 2001 03:01:49 -0700
Message-ID: <F001.00392456.20010919021517@fatcity.com>

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). Received on Wed Sep 19 2001 - 05:01:49 CDT