Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> can't create table with clob datatype?

can't create table with clob datatype?

From: Ron <ronyin_at_tpts5.seed.net.tw>
Date: Sun, 11 Feb 2001 11:10:18 +0800
Message-ID: <964vpa$kon$1@news.seed.net.tw> 






i'm new to oracle.


i installed oracle8.0.5 on IBM SP2.


i created a database with ZHT16BIG5 character set.



I create a table by using SQLPLUS.


username:scott


passwd:tiger


SQL> CREATE TABLE Tbl (col1 clob, col2 clob, col3 clob);
ERROR at line 1:


ORA-22866: default character set is of varying width



i got a error with scott/tiger id.


but i had no problem with system/manager id.
can anyone help me to solve the error ORA-22866.



Ron
Received on Sat Feb 10 2001 - 21:10:18 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US