Re: Error in creating tablespace

From: satar naghshineh <satarnag_at_yahoo.com>
Date: Thu, 20 Sep 2001 16:01:16 -0700
Message-ID: <F001.003943E4.20010920160018@fatcity.com>

Ashraf Jan,

Create a directory within the C drive labled "ORADATA". Then in svrmgr30, login as system, then type:

CREATE TABLESPACE PAYROLL DATAFILE
'C:\ORADATA\PAYROL.ORA' SIZE 10M; make sure to use the semicolon, not the /. I know it sounds stupid, but just do it please.

Please let me know what happens. For some reason, Oracle is having a problem writing to the FIRST block, which indicates that something is preventing writes to the root directory.

Regards,
Satar Naghshineh

• ASHRAF SALAYMEH <ashraf_salaymeh_at_yahoo.com> wrote:
  > Hi List,
  >
  > I tryed to create the tablespace from svrmgr30
  > as satar naghshineh told me.
  > But i still face the same error...
  > CREATE TABLESPACE PAYROLL
  > DATAFILE 'C:\PAYROL.ORA' SIZE 10M
  > SQL> /
  > 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
  >
  > Any one can tell me what I have to do?
  >
  > Regards,
  > Ashraf
  

  ---

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 Thu Sep 20 2001 - 18:01:16 CDT