Re: Error in creating tablespace

From: satar naghshineh <satarnag_at_yahoo.com>
Date: Wed, 19 Sep 2001 15:16:16 -0700
Message-ID: <F001.003931D1.20010919152020@fatcity.com>

Salaam Ashraf Jon,

It appears that Oracle has a problem writing to the C drive to create the datafile on the very first block. This error is usually the result of a size issue over 4gb for the datafile or a file that has been autoextended. In your case, it appears it doesn't like the command (maybe some character is being passed through the command?).

Delete the file and re-try it again. try doing this in svrmgrl80 and put a ; at the end.

Good Luck,
Satar Naghshineh

• ASHRAF SALAYMEH <ashraf_salaymeh_at_yahoo.com> wrote:
  > 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: satar naghshineh
  INET: satarnag_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 - 17:16:16 CDT