External table creation [message #323899] |
Fri, 30 May 2008 00:04  |
nagaa
Messages: 33 Registered: August 2007 Location: chennai
|
Member |
|
|
Hi,
I faced the following error when i create a external table
ERROR at line 2:
ORA-30656: column type not supported on external organized table
CREATE TABLE SAMPLE_EXT (
2 field1 CLOB 3 )
4 ORGANIZATION EXTERNAL
5 (
6 TYPE ORACLE_LOADER
7 DEFAULT DIRECTORY UTL_SPOOL_DIR
ACCESS PARAMETERS
8 9 (
10 records delimited by newline
11 badfile DAT_DIR:'SAMPLE_EXT%a_%p.bad'
12 logfile DAT_DIR:'SAMPLE_EXT%a_%p.log'
13 fields LRTRIM REJECT ROWS WITH ALL NULL FIELDS (field1 char(32000))
)
14 15 LOCATION ('stmt_sample.dat')
16 )
17 PARALLEL 10
18 REJECT LIMIT UNLIMITED;
How to fix this?
|
|
|
|
|