将sql数据类型转换为oracle数据类型 [英] to convert a sql datatype to oracle datatype

问题描述

我可以使用varchar(8000)使其与Oracle 9i兼容吗?
我尝试使用具有varchar(8000)的长但IVE个以上的cols，因此dLong不起作用，我什至尝试使用clob，但它给了我这个错误

 [执行SQL任务]错误:执行查询
创建表" PH_TxnReview(""ReviewId" VARCHAR2(100)非空，"PoornataId" VARCHAR2(100)非空，年份" VARCHAR2(50)，"ReviewType" VARCHAR2(10)非空，"SendDate" VARCHAR2 100)，"SendMail" NUMBER(1,0)，"IsApprove" NUMBER(1,0)，"ApprovedBy" VARCHAR2(100)，"ApprovedDate" VARCHAR2(100)，"OverallEmpComments" CLOB，"OverallMgrComments" CLOB，"StrengthExhibited" CLOB，"ImprovementOpportunity" CLOB，"SupportRequired" CLOB，"CreatedBy" VARCHAR2(100)，"CreatedDate" VARCHAR2(100)，"ModifiedBy" VARCHAR2(100)，"ModifiedDate" VARCHAR2(100)，"SendNotificationToMgrDate" (100))失败，出现以下错误:" ORA-01658:无法为表空间USERS中的段创建INITIAL范围.可能的失败原因:查询问题，"ResultSet"属性未正确设置，参数未正确设置或连接未正确建立. 

请帮忙，在此先谢谢!!!!!

解决方案

VARCHAR2在Oracle 9i上最多可以存储4000个字符:http://ss64.com/ora/syntax-datatypes.html [ http://www.dba-oracle.com/sf_ora_01658_unable_to_create_initial_extent_for_segment_in_tablespace_string.htm [

what can i use for varchar(8000) to make it compatible in Oracle 9i
i tried using long but ive more than one cols having varchar(8000) so dLong does not work i even tried clob but its giving me this error

[Execute SQL Task] Error: Executing the query 
"CREATE TABLE "PH_TxnReview" ( "ReviewId" VARCHAR2(100) NOT NULL, "PoornataId" VARCHAR2(100) NOT NULL, "Year" VARCHAR2(50), "ReviewType" VARCHAR2(10) NOT NULL, "SendDate" VARCHAR2(100), "SendMail" NUMBER(1,0), "IsApprove" NUMBER(1,0), "ApprovedBy" VARCHAR2(100), "ApprovedDate" VARCHAR2(100), "OverallEmpComments" CLOB, "OverallMgrComments" CLOB, "StrengthExhibited" CLOB, "ImprovementOpportunity" CLOB, "SupportRequired" CLOB, "CreatedBy" VARCHAR2(100), "CreatedDate" VARCHAR2(100), "ModifiedBy" VARCHAR2(100), "ModifiedDate" VARCHAR2(100), "SendNotificationToMgrDate" VARCHAR2(100) ) " failed with the following error: "ORA-01658: unable to create INITIAL extent for segment in tablespace USERS ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. 

please help , Thanks in Advance !!!!!

解决方案

VARCHAR2 on Oracle 9i can store up to 4000 chars : http://ss64.com/ora/syntax-datatypes.html[^]

So you should be fine with that otherwise you should use CLOB.

The error ORA-01658 refers to the lack of space in the storage files : http://www.dba-oracle.com/sf_ora_01658_unable_to_create_initial_extent_for_segment_in_tablespace_string.htm[^]

这篇关于将sql数据类型转换为oracle数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！