EXTERNAL TABLES ON ACFS 11.2 WINDOWS
hi
I use Windows 2008R2 Std. and Oracle 11gR2 RAC Std.
I have successfully mounted ACFS share
----
ASMCMD> volinfo -a
Diskgroup Name: SHARED
Volume Name: SHARED_ACFS
Volume Device: \\.\asm-shared_acfs-106
State: ENABLED
Size (MB): 8192
Resize Unit (MB): 256
Redundancy: UNPROT
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: C:\SHARED
----
I have created directory in Oracle mapped onto ACFS share
and granted read,write access on it to my user
Then I created external table with success BUT...
though I see metadata
----
ADM@proton22> desc t111;
Name Null? Type
NAME VARCHAR2(4000)
VALUE VARCHAR2(4000)
----
I use Windows 2008R2 Std. and Oracle 11gR2 RAC Std.
I have successfully mounted ACFS share
----
ASMCMD> volinfo -a
Diskgroup Name: SHARED
Volume Name: SHARED_ACFS
Volume Device: \\.\asm-shared_acfs-106
State: ENABLED
Size (MB): 8192
Resize Unit (MB): 256
Redundancy: UNPROT
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: C:\SHARED
----
I have created directory in Oracle mapped onto ACFS share
and granted read,write access on it to my user
Then I created external table with success BUT...
though I see metadata
----
ADM@proton22> desc t111;
Name Null? Type
NAME VARCHAR2(4000)
VALUE VARCHAR2(4000)
----
I got error:
0