You Asked

I just want to exp and imp,but when I imp the dmp file to another database,the failer message occured below:
ORA-14692: STORE AS clause is not allowed for extended character type column.
what should I do?

and Connor said...

Can we see the DDL for the table concerned? For example, I can replicate the error

SQL> create table t ( x varchar2(32000))
  2    lob(x) store as securefile;
  lob(x) store as securefile
      *
ERROR at line 2:
ORA-14692: STORE AS clause is not allowed for extended character type column

but obviously import should not be generating such a DDL.

Try imp indexfile=xyz.sql

and then peruse through the file to see what DDL is being created for the table in question

Rating

(1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

same issue

hana, February 21, 2020 - 7:02 pm UTC

we migrated from AWS rds 12c to 19c and changed parameter group to set "max_string_size=extended", now when export a table having column varchar2(6000) and imp, i get error message at imp as follows

"IMP-00003: ORACLE error 14692 encountered
ORA-14692: STORE AS clause is not allowed for extended character type column
IMP-00034: Warning: FromUser "EI3IT" not found in export file
Import terminated successfully with warnings.
"

any idea?

February 25, 2020 - 8:16 am UTC

Same advice applies here.

Use 'sqlfile' parameter with data pump import to see the DDL in question.

(Please post it back here - because it sounds like a bug)

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.

Breadcrumb

Question and Answer