RE: Error in creating tablespace

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Wed, 19 Sep 2001 05:05:39 -0700
Message-ID: <F001.00392557.20010919034021@fatcity.com>

Is there sufficient space on the C: drive. How big is the file that has been created. If it is less than 10M that may be your problem

John

-----Original Message-----
From: ASHRAF SALAYMEH [mailto:ashraf_salaymeh_at_yahoo.com] Sent: 19 September 01 11:15
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).




**********************************************************************
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**********************************************************************

Received on Wed Sep 19 2001 - 07:05:39 CDT