Steve,
Oracle will allow you to create a datafile on a network drive. They just won't
support you unless you have it on a supported storage system (like a NetApp
Filer) and appriopriately configured (read that as meaning a dedicated TCP/IP
cable).
Dick Goulet
Steve Perry [EMAIL PROTECTED] wrote
They are correct that they don't want you to do it.
The only approved NAS solution by Oracle is Network Appliance's product.
Other NFS, shared drive etc aren't good idea to put Oracle database files.
-Original Message-
Sent: Friday, January 31, 2003 6:16 PM
To: Multiple recipients of list
Thanks for correcting me Richard.
I had tried that in the past and Oracle had said it couldn't be done nor
would they want me doing it.
I agreed after thinking about it.
steve
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 30,
Guys,
the env. is 8.1.6/win2k.
SQL alter tablespace test add datafile
'\\192.168.17.111\shared\test.dbf' size 100m;
ORA-01119: error in creating database file
'\\192.168.0.111\shared\test.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: cannot open file.
O/S-Error: (OS
I don't think Oracle supports shares on Windows.
It has to be a permanent drive (i.e. local, attached storage like EMC).
Imagine all the support calls they'd get because of unannounced network
errors, people pulling the wrong plug...
steve
- Original Message -
To: Multiple recipients
Check out this metalink note:
Note:211532.1
-Original Message-
Sent: Thursday, January 30, 2003 9:59 PM
To: Multiple recipients of list ORACLE-L
Guys,
the env. is 8.1.6/win2k.
SQL alter tablespace test add datafile
'\\192.168.17.111\shared\test.dbf' size 100m;
ORA-01119: error in
]
mail.comcc:
Sent by: Subject: how to create datafile in
shared network drive ??
[EMAIL PROTECTED