| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error in creating tablespace
Ashraf,
I know that it sounds far fetched but do you have contigous free space to write the 2
K block that Oracle will try to write on the "C" drive. Do you have any virus
protection turned on that prevents you from writing in the "root" directory? Try the
same command in a sub directory.
Please post the findings when you get an answer.
Thanks,
Ron
ROR mª¿ªm
>>> ashraf_salaymeh_at_yahoo.com 09/20/01 05:10AM >>> 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
--- satar naghshineh <satarnag_at_yahoo.com> wrote:
> 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
>
-- 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: Ron Rogers INET: RROGERS_at_galottery.org 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 - 07:32:41 CDT
 |
 |