to convert a sql datatype to oracle datatype

See more:

SQL

Oracle

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 !!!!!