Is there enough space on C:? Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -----Ursprüngliche Nachricht----- Von: ASHRAF SALAYMEH [mailto:[EMAIL PROTECTED]] 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: [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: Schoen Volker 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).