!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