Partition a table across 2 disks
772740May 14 2010 — edited May 14 2010Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
======================================================
Hi,
When creating a partitioned table, I go into enterprise manager, create seperate tablespaces and corresponding data files and then reference these when creating the partitioned table.
However, I want to attempt splitting the partitions across two different disks, I figured when createding a table space I could simply create the datafile specifying the different hard disk in the directort field. Then when creating the partitioned table reference this table space..
Oracle will not allow me to create a tablespace/datasfile on my other hard disk I get the following error:
"Failed to commit: ORA-01119: error in creating database file 'f:\APP\STEVE\ORADATA\ORCL\wc2a' ORA-27040: file create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) The system cannot find the path specified. "
Any ideas how I would go about splitting table partitions onto my F drive, ... oracle is currently installed on my C drive...
I cant seem to find any documentation or guides to help me do this...
Any help would be appriciated