Home » RDBMS Server » Server Administration » Creating tablespace in raw partition (oracle 11 g r2)
Creating tablespace in raw partition [message #563841] Fri, 17 August 2012 07:39 Go to next message
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
John Watson
Messages: 8919
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.

Previous Topic: Using ASM first time
Next Topic: ASM Diskgroup resize
Goto Forum:
  


Current Time: Tue Mar 19 02:30:59 CDT 2024