Home » RDBMS Server » Server Administration » Increase the size of datafile
Increase the size of datafile [message #60882] Thu, 11 March 2004 19:21 Go to next message
Ram Shabad
Messages: 2
Registered: March 2004
Junior Member
SQL> create table aaaa as select * from reading_detail;
create table aaaa as select * from reading_detail
*
ERROR at line 1:
ORA-19502: write error on file "D:PSEBDATAPSEBAREA.ORA", blockno 524247 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.

after it we have tried to increase the size of datafile to 8GB from 4GB,however it also give the error as "unable to write the header" in the datafile , when we added another datafile then it also given the error in the first datafile.
Re: Increase the size of datafile [message #60899 is a reply to message #60882] Fri, 12 March 2004 05:15 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Check your filesystem space(ie D: ) . It looks like your disk is full . Try creating the datafile in a different filesystem.
Re: Increase the size of datafile [message #60977 is a reply to message #60882] Wed, 17 March 2004 11:45 Go to previous messageGo to next message
www.sidibe.net
Messages: 9
Registered: March 2004
Junior Member
most of the time, this problem is due to the fact that you do not have necessary rights !
see the right on the filesystems.
Re: Increase the size of datafile [message #60979 is a reply to message #60899] Wed, 17 March 2004 18:17 Go to previous message
Ram Shabad
Messages: 2
Registered: March 2004
Junior Member
thanx for the support , the problem has been and it is working perfectly .

regards,
Previous Topic: synronize support db
Next Topic: to build a database manually
Goto Forum:
  


Current Time: Fri Sep 20 12:42:27 CDT 2024