!Create a 1MB file
/eacom/ectest9i/data>qiomkfile -s 1m test01.dbf
/eacom/ectest9i/data>ls -l
total 2048032
-rw-r-----   1 oracle   dba      1048584192 Feb 23 22:12 catalog01.dbf
lrwxrwxrwx   1 oracle   dba           23 Feb 23 22:26 test01.dbf -> .test01.dbf::cdev:vxfs:
/eacom/ectest9i/data>ls -l .test01.dbf::cdev:vxfs:
crw-r--r--   1 oracle   dba      205,  1 Feb 23 22:26 .test01.dbf::cdev:vxfs:

!What's this major device? Not sure what fdd stands for
/eacom/ectest9i/data>grep 205 /etc/name_to_major
fdd 205
/eacom/ectest9i/data>sqlplus

SQL*Plus: Release 9.2.0.3.0 - Production on Mon Feb 23 22:28:34 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

!Can't create a 1MB Oracle datafile
SQL> create tablespace test datafile '/eacom/ectest9i/data/test01.dbf' size 1m reuse extent management local uniform size 32k;
create tablespace test datafile '/eacom/ectest9i/data/test01.dbf' size 1m reuse extent management local uniform size 32k
*
ERROR at line 1:
ORA-01119: error in creating database file '/eacom/ectest9i/data/test01.dbf'
ORA-27042: not enough space on raw partition to fullfill request
Additional information: 2


SQL> show parameter db_block_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_size                        integer     8192

!But creating 1M-db_block_size=1016K datafile works.
SQL> create tablespace test datafile '/eacom/ectest9i/data/test01.dbf' size 1016k reuse extent management local uniform size 32k;

Tablespace created.

SQL> create table yongtest tablespace test as select 1 mycol from dual;

Table created.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

!As with other Oracle datafiles (or even those on raw disks), `strings` output
!shows database name on 2nd line (may be preceded by ? on Windows), and
!tablespace name on 3rd line. (Don't rely on this finding if the tablespace
!was read-only and the database was cloned; DB name may be shown as the old name
!in that case.)
/eacom/ectest9i/data>strings test01.dbf | more
Z[\]
ECTEST9I
TEST
/eacom/ectest9i/data>sqlplus

SQL*Plus: Release 9.2.0.3.0 - Production on Mon Feb 23 22:32:15 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

SQL> drop tablespace test including contents and datafiles;

Tablespace dropped.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
/eacom/ectest9i/data>ls -l
total 2048032
-rw-r-----   1 oracle   dba      1048584192 Feb 23 22:12 catalog01.dbf
lrwxrwxrwx   1 oracle   dba           23 Feb 23 22:26 test01.dbf -> .test01.dbf::cdev:vxfs:
/eacom/ectest9i/data>ls -la
total 2050082
drwxr-xr-x   2 oracle   dba           96 Feb 23 22:26 .
drwxr-xr-x  11 oracle   dba         1024 Nov  1 00:52 ..
-rw-r--r--   1 oracle   dba      1048576 Feb 23 22:32 .test01.dbf
-rw-r-----   1 oracle   dba      1048584192 Feb 23 22:12 catalog01.dbf
lrwxrwxrwx   1 oracle   dba           23 Feb 23 22:26 test01.dbf -> .test01.dbf::cdev:vxfs:
/eacom/ectest9i/data>date
Mon Feb 23 22:32:55 GMT 2004
/eacom/ectest9i/data>fuser *
catalog01.dbf:    17285o   17283o   17281o   17279o
test01.dbf:

/opt/oracle>df -k .
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/vx/dsk/rootdg/voloptora
                     17681408 11389856 5898332    66%    /opt/oracle
/opt/oracle>mkdir yong
/opt/oracle>cd yong
/opt/oracle/yong>qiomkfile -s 20m test01.dbf
/opt/oracle/yong>ls -la
total 40962
drwxr-xr-x   2 oracle   dba           96 Feb 23 22:49 .
drwxr-xr-x  11 oracle   dba         1024 Feb 23 22:49 ..
-rw-r--r--   1 oracle   dba      20971520 Feb 23 22:49 .test01.dbf
lrwxrwxrwx   1 oracle   dba           23 Feb 23 22:49 test01.dbf -> .test01.dbf::cdev:vxfs:
/opt/oracle/yong>df -k .
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/vx/dsk/rootdg/voloptora
                     17681408 11410344 5879124    66%    /opt/oracle
/opt/oracle/yong>mount -v | fgrep /opt/oracle
/dev/vx/dsk/rootdg/voloptora on /opt/oracle type vxfs read/write/setuid/delaylog/largefiles/qio/ioerror=mwdisable/dev=3280005 on Fri Feb 13 22:02:40 2004
/opt/oracle/yong>whence qiomkfile
/opt/VRTS/bin/qiomkfile