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 <[EMAIL PROTECTED]> 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: [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).
