Ora-01119
Hi,
I am having problem creating tablespace on the 1 logical RAW partion.
Whereas on 2nd partion, it works. I guess the first one is Extended and second is Linux. What is the reason ?
My layout is as follows:
# fdisk -l /dev/sdc
Disk /dev/sdc: 106 MB, 106954752 bytes
64 heads, 32 sectors/track, 102 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes
Device Boot Start End Blocks Id System
/dev/sdc1 1 30 30704 5 Extended
/dev/sdc2 31 41 11264 83 Linux
[root@localhost dev]#
SQL> create tablespace Dat01 datafile '/dev/sdc1';
create tablespace Dat01 datafile '/dev/sdc1'
*
ERROR at line 1:
ORA-01119: error in creating database file '/dev/sdc1'
ORA-27044: unable to write the header block of file
Additional information: 7
SQL> create tablespace Dat02 datafile '/dev/sdc2';
Tablespace created.
SQL>
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway