AW: Error in creating tablespace

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Wed, 19 Sep 2001 04:39:52 -0700
Message-ID: <F001.0039250C.20010919033520@fatcity.com>

Is there enough space on C:?

Volker Schoen
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Ursprüngliche Nachricht-----

Von: ASHRAF SALAYMEH [mailto:ashraf_salaymeh_at_yahoo.com] Gesendet: Mittwoch, 19. September 2001 12:15 An: Multiple recipients of list ORACLE-L Betreff: 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: Schoen Volker
INET: v.schoen_at_inplan.de

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