Home » SQL & PL/SQL » SQL & PL/SQL » External table creation
External table creation [message #323899] Fri, 30 May 2008 00:04 Go to next message
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?

Re: External table creation [message #323903 is a reply to message #323899] Fri, 30 May 2008 00:19 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-30656: column type not supported on external organized table

Cause: Attempt to create an external organized table with a column of type LONG, LOB, BFILE, ADT, or VARRAY.

Action: These column types are not supported, change the DDL.
Re: External table creation [message #324088 is a reply to message #323899] Fri, 30 May 2008 14:36 Go to previous message
Barbara Boehmer
Messages: 8621
Registered: November 2002
Location: California, USA
Senior Member
You can use SQL*Loader instead of an external table:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/ldr_loading.htm#i1006803
Previous Topic: Oracle PL/SQL Collection
Next Topic: collections and Records VARRAY
Goto Forum:
  


Current Time: Fri Dec 02 18:25:23 CST 2016

Total time taken to generate the page: 0.12547 seconds