Creating tablespace in raw partition [message #563841] |
Fri, 17 August 2012 07:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/754ffdec6c924a1a5ade13e42cd4ea5c?s=64&d=mm&r=g) |
swaorclser
Messages: 56 Registered: August 2011
|
Member |
|
|
Hello Experts,
i want to create tablespace in raw partion on windows.
I have added a hard disk and added extended partition to it. Then created 4 logical partitions of 256 MB with diskpart.exe.
I have assigned a drive letter to one of them as X:
However, I am having trouble in creating tablespace on it. I referred to http://docs.oracle.com/cd/B28359_01/win.111/b32010/ap_raw.htm
I get following error,
C:\Users\Administrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 17 15:32:17 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: SYSTEM
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing opti
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 100;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 100
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 502;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 502
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 20
2 ;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 20
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 502;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 502
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 602;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 602
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 702;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 702
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:\accounting_1' size 999;
create tablespace exampletb datafile '\\.\X:\accounting_1' size 999
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\\.\X:accounting_1' size 100000;
create tablespace exampletb datafile '\\.\X:accounting_1' size 100000
*
ERROR at line 1:
ORA-01119: error in creating database file '\\.\X:accounting_1'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Please help me , in getting rid of these errors.
Thanks for your inpus and time !
Regards,
swaorclser
|
|
|
Re: Creating tablespace in raw partition [message #563845 is a reply to message #563841] |
Fri, 17 August 2012 08:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
1. The default unit for file size is bytes.
2. Since you gave the partition a drive letter, that is what you must specify. You can't add '\accounting_1' to it, there is no file system on a raw partition.
3. Raw devices will be desupported in relase 12.
4. No DBA has used raw devices for decades, unless there was absolutely no alternative.
|
|
|