Improve company productivity with a Business Account.Sign Up

x
?
Solved

Import Successfull with compilation warnings (???)

Posted on 2004-09-14
1
Medium Priority
?
975 Views
Last Modified: 2013-12-11
Hello,

I created and installed Oracle 9i Database (9.2.0.4) on my Red Hat Enterprise 3 (ES) Linux server.
I typed the following import command:

imp system/manager FILE=/OraHome/080904.dmp FROMUSER=ALCIE TOUSER=ALCIE IGNORE=Y

=====
 ""UNITCOST" NUMBER(11, 4), "UNITPRICE" NUMBER(10, 2), "UOM" VARCHAR2(4), "VB"
 "URDEN" NUMBER(10, 2), "VENDOR" VARCHAR2(6), "VOUCHER" NUMBER(6, 0))  PCTFRE"
 "E 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 368640 NEXT"
 " 114688 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GRO"
 "UPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBDOCTRACK" ("CO" VARCHAR2(3) NOT NULL ENABLE, "PROJECT" NUMB"
 "ER(8, 0) NOT NULL ENABLE, "CTRLNUM" NUMBER(8, 0) NOT NULL ENABLE, "SEQNUM" "
 "NUMBER(3, 0) NOT NULL ENABLE, "LOT" VARCHAR2(16), "CADASTRAL_MOD" VARCHAR2("
 "40), "MUNICIP_FEES" NUMBER(6, 2), "CADAST_FEES" NUMBER(6, 2), "REMARK1" VAR"
 "CHAR2(1000), "REMARK2" VARCHAR2(60), "PLAN_DATE" DATE, "SENTTO_MUNICIP_DATE"
 "1" DATE, "SENTTO_MUNICIP_DATE2" DATE, "SENTTO_MUNICIP_DATE3" DATE, "MUNICIP"
 "_APPRVL_DATE" DATE, "MUNICIP_FILE" VARCHAR2(15), "SENTTO_CADAST_DATE1" DATE"
 ", "SENTTO_CADAST_DATE2" DATE, "SENTTO_CADAST_DATE3" DATE, "CADAST_APPRVL_DA"
 "TE" DATE, "CADAST_FILE" VARCHAR2(15), "CERTIFICATION_DATE" DATE, "MUNICIPAL"
 "_PAID_BY" VARCHAR2(1), "CADASTRAL_PAID_BY" VARCHAR2(1), "DATE_GEL" DATE, "S"
 "ENTTO_CLIENT_TOSIGN" DATE, "RECEIVED_CLIENT_SIGNATURE" DATE, "SENTTO_CLIENT"
 "_CONSENT" DATE, "RECEIVED_CLIENT_CONSENT" DATE)  PCTFREE 10 PCTUSED 40 INIT"
 "RANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 251904 NEXT 126976 MINEXTENTS 1"
 " MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DE"
 "FAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBDOCTRACK2" ("CO" VARCHAR2(3) NOT NULL ENABLE, "PROJECT" NUM"
 "BER(8, 0) NOT NULL ENABLE, "CTRLNUM" NUMBER(8, 0) NOT NULL ENABLE, "SEQNUM""
 " NUMBER(3, 0) NOT NULL ENABLE, "LOT" VARCHAR2(16), "PLAN_DATE" DATE, "CADAS"
 "TRAL_MOD" VARCHAR2(40), "SENTTO_MUNICIP_DATE" DATE, "MUNICIP_APPRVL_DATE" D"
 "ATE, "MUNICIP_FILE" VARCHAR2(15), "SENTTO_CADAST_DATE" DATE, "CADAST_APPRVL"
 "_DATE" DATE, "CADAST_FILE" VARCHAR2(15), "CERTIFICATION_DATE" DATE, "NEWLOT"
 "" VARCHAR2(16), "MUNICIP_FEES" NUMBER(6, 2), "CADAST_FEES" NUMBER(6, 2), "R"
 "EMARK1" VARCHAR2(60), "REMARK2" VARCHAR2(60))  PCTFREE 10 PCTUSED 40 INITRA"
 "NS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 112640 NEXT 55296 MINEXTENTS 1 MA"
 "XEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
 "LT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBEMPLOYEE" ("CO" VARCHAR2(3) NOT NULL ENABLE, "EMPLOYEE" VAR"
 "CHAR2(9) NOT NULL ENABLE, "ADDR1" VARCHAR2(30), "ADDR2" VARCHAR2(10), "CITY"
 "" VARCHAR2(20), "INITIALS" VARCHAR2(3), "NAME" VARCHAR2(30), "PHONE" VARCHA"
 "R2(12), "RATE" NUMBER(9, 4), "SS" VARCHAR2(9), "ST" VARCHAR2(2), "ZIP" VARC"
 "HAR2(10), "ACTIVE" VARCHAR2(1), "SICK" NUMBER, "VACA" NUMBER, "HOLI" NUMBER"
 ", "SICK_REMAINING" NUMBER, "VACA_REMAINING" NUMBER, "HOLI_REMAINIG" NUMBER,"
 " "RENOV_EMP_CODE" VARCHAR2(6))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
 "55 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTIN"
 "CREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)               "
 "        "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBFIELD" ("ORDER_LOG" VARCHAR2(2), "EMPLOYEE" VARCHAR2(9), "P"
 "ARTYCHIEF" VARCHAR2(9), "PROJECT" VARCHAR2(10), "INPROGRESS" VARCHAR2(1), ""
 "COMPLETED" VARCHAR2(1), "REMARKS" VARCHAR2(1000), "TRANSDATE" DATE, "TBFIEL"
 "D_ID" NUMBER(10, 0) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
 "RANS 255 LOGGING STORAGE(INITIAL 98304 NEXT 55296 MINEXTENTS 1 MAXEXTENTS 1"
 "21 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)       "
 "                "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBINV_COMMENTS" ("CO" VARCHAR2(3) NOT NULL ENABLE, "PROJECT" "
 "VARCHAR2(10) NOT NULL ENABLE, "ADV_BILL" VARCHAR2(1), "SERV_COMMENT" VARCHA"
 "R2(40), "SERV_SEQNO" NUMBER(3, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRA"
 "NS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 P"
 "CTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)           "
 "            "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBLINEDES" ("CO" VARCHAR2(3) NOT NULL ENABLE, "LINE_SEQ" NUMB"
 "ER NOT NULL ENABLE, "SEQ" NUMBER NOT NULL ENABLE, "DES" VARCHAR2(40))  PCTF"
 "REE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 20480 NEX"
 "T 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROU"
 "PS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBLOTRELATION" ("CO" VARCHAR2(3) NOT NULL ENABLE, "PROJECT" N"
 "UMBER(8, 0) NOT NULL ENABLE, "CTRLNUM" NUMBER(8, 0) NOT NULL ENABLE, "SEQNU"
 "M" NUMBER(3, 0) NOT NULL ENABLE, "LOT_FROM" VARCHAR2(16) NOT NULL ENABLE, ""
 "LOT_TO" VARCHAR2(16) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
 "TRANS 255 LOGGING STORAGE(INITIAL 247808 NEXT 126976 MINEXTENTS 1 MAXEXTENT"
 "S 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)    "
 "                   "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBLRATE" ("CO" VARCHAR2(3) NOT NULL ENABLE, "RATE" NUMBER(7, "
 "2), "RATE_CODE" VARCHAR2(4))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255"
 " LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCR"
 "EASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                 "
 "      "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBOFFICE" ("CO" VARCHAR2(3) NOT NULL ENABLE, "OFFICE" VARCHAR"
 "2(4) NOT NULL ENABLE, "DES" VARCHAR2(30))  PCTFREE 10 PCTUSED 40 INITRANS 1"
 " MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENT"
 "S 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)    "
 "                   "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBOLDNEWLOT" ("CO" VARCHAR2(3), "PROJECT" NUMBER(8, 0), "CTRL"
 "NUM" NUMBER(8, 0), "SEQNUM" NUMBER(3, 0), "LOT" VARCHAR2(16), "NEWLOT_FROM""
 " VARCHAR2(16), "NEWLOT_TO" VARCHAR2(16), "NEW_CADASTRE" NUMBER(8, 0), "PART"
 "IAL_LOT" VARCHAR2(1), "OLD_CADASTRE" NUMBER(8, 0))  PCTFREE 10 PCTUSED 40 I"
 "NITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 65536 NEXT 36864 MINEXTENTS "
 "1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
 "EFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBPARRPT" ("EMPLOYEE" VARCHAR2(9) NOT NULL ENABLE, "WKCAT" VA"
 "RCHAR2(4) NOT NULL ENABLE, "HOURS" NUMBER(9, 2))  PCTFREE 10 PCTUSED 40 INI"
 "TRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MA"
 "XEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
 "LT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBPERIOD" ("BEGINDATE" DATE NOT NULL ENABLE, "CO" VARCHAR2(3)"
 " NOT NULL ENABLE, "ENDDATE" DATE NOT NULL ENABLE, "PERIOD" NUMBER(2, 0) NOT"
 " NULL ENABLE, "YEAR" NUMBER(4, 0) NOT NULL ENABLE, "CLOSED" VARCHAR2(1), "C"
 "URPERIOD" VARCHAR2(1))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGI"
 "NG STORAGE(INITIAL 20480 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE"
 " 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                     "
 "  "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBPRJSTATUS" ("CODE" VARCHAR2(1), "DESCRIPTION" VARCHAR2(40))"
 "  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 102"
 "4000 NEXT 2048000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 10 FREELISTS 1 FR"
 "EELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBPRJTYP" ("CO" VARCHAR2(3) NOT NULL ENABLE, "AEXP" VARCHAR2("
 "4), "ALAB" VARCHAR2(4), "BCT" VARCHAR2(4), "DEF" VARCHAR2(4), "DEPT" NUMBER"
 "(3, 0), "DES" VARCHAR2(30), "DIV" NUMBER(3, 0), "ECT" VARCHAR2(4), "FBDN" V"
 "ARCHAR2(4), "LCT" VARCHAR2(4), "MBDN" VARCHAR2(4), "PROJ_TYPE" VARCHAR2(4),"
 " "REV" VARCHAR2(4), "SUBLEDGER" VARCHAR2(2), "UNBILLED_WIP" VARCHAR2(4), "V"
 "BDN" VARCHAR2(4), "WIP" VARCHAR2(4))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
 "RANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121"
 " PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)         "
 "              "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBPROJECT" ("CLIENT" VARCHAR2(8) NOT NULL ENABLE, "CO" VARCHA"
 "R2(3) NOT NULL ENABLE, "PROJECT" VARCHAR2(10) NOT NULL ENABLE, "RATECODE" V"
 "ARCHAR2(4) NOT NULL ENABLE, "STARTDATE" DATE NOT NULL ENABLE, "STATUS" VARC"
 "HAR2(1) NOT NULL ENABLE, "TITLE1" VARCHAR2(70), "BU" VARCHAR2(1), "CLOSEDDA"
 "TE" DATE, "CONTACT" VARCHAR2(20), "CONTRACT" NUMBER(11, 2), "CONTRACTNO" VA"
 "RCHAR2(15), "DEPT" NUMBER(3, 0), "DISCOUNT_PCT" NUMBER(4, 2), "DIV" NUMBER("
 "3, 0), "EXPENSE_MARGIN" NUMBER(5, 2), "INVFORMAT" VARCHAR2(2), "INVFREQ" VA"
 "RCHAR2(2), "INVTODATE" NUMBER(11, 2), "LASTINVDATE" DATE, "MANAGER" VARCHAR"
 "2(9), "OFFICE" VARCHAR2(4), "PARENT" VARCHAR2(10), "PHONE" VARCHAR2(12), "P"
 "ROJ_TYPE" VARCHAR2(4), "SIC" VARCHAR2(6), "TITLE2" VARCHAR2(70), "SECURITY_"
 "CODE" VARCHAR2(10), "PRTWRKORD" VARCHAR2(1), "REMARK1" VARCHAR2(220), "FILE"
 "NUM" NUMBER(8, 0), "BILLED" VARCHAR2(1), "CONFIRM" VARCHAR2(1), "MINUTENUM""
 " NUMBER(6, 0), "SURVEYOR" NUMBER(6, 0), "APPT_NUM" VARCHAR2(60), "USE_ORDER"
 "EDBY" VARCHAR2(1), "GENDER" VARCHAR2(1), "ADD_TO_CONFIRMATION" VARCHAR2(100"
 "0), "RENOV_PROJECT" VARCHAR2(16), "RENOV_MANDAT" VARCHAR2(16), "RENOV_NAME""
 " VARCHAR2(80), "INITIAL_CNTR" NUMBER(11, 2))  PCTFREE 10 PCTUSED 40 INITRAN"
 "S 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 4536320 NEXT 1726464 MINEXTENTS 1 "
 "MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
 "AULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBPROJ_TEMP" ("CLIENT" VARCHAR2(8) NOT NULL ENABLE, "CO" VARC"
 "HAR2(3) NOT NULL ENABLE, "PROJECT" VARCHAR2(10) NOT NULL ENABLE, "RATECODE""
 " VARCHAR2(4) NOT NULL ENABLE, "STARTDATE" DATE NOT NULL ENABLE, "STATUS" VA"
 "RCHAR2(1) NOT NULL ENABLE, "TITLE1" VARCHAR2(30) NOT NULL ENABLE, "BU" VARC"
 "HAR2(1), "CLOSEDDATE" DATE, "CONTACT" VARCHAR2(20), "CONTRACT" NUMBER(11, 2"
 "), "CONTRACTNO" VARCHAR2(15), "DEPT" NUMBER(3, 0), "DISCOUNT_PCT" NUMBER(4,"
 " 2), "DIV" NUMBER(3, 0), "EXPENSE_MARGIN" NUMBER(5, 2), "INVFORMAT" VARCHAR"
 "2(2), "INVFREQ" VARCHAR2(2), "INVTODATE" NUMBER(11, 2), "LASTINVDATE" DATE,"
 " "MANAGER" VARCHAR2(9), "OFFICE" VARCHAR2(4), "PARENT" VARCHAR2(10), "PHONE"
 "" VARCHAR2(12), "PROJ_TYPE" VARCHAR2(4), "SIC" VARCHAR2(6), "TITLE2" VARCHA"
 "R2(30), "SECURITY_CODE" VARCHAR2(10), "PRTWRKORD" VARCHAR2(1), "REMARK1" VA"
 "RCHAR2(220), "FILENUM" NUMBER(8, 0), "BILLED" VARCHAR2(1), "CONFIRM" VARCHA"
 "R2(1), "MINUTENUM" NUMBER(6, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS"
 " 255 LOGGING STORAGE(INITIAL 3072000 NEXT 2252800 MINEXTENTS 1 MAXEXTENTS 1"
 "21 PCTINCREASE 10 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)       "
 "                "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBRATECODE" ("CO" VARCHAR2(3) NOT NULL ENABLE, "DES" VARCHAR2"
 "(30) NOT NULL ENABLE, "RATECODE" VARCHAR2(4) NOT NULL ENABLE)  PCTFREE 10 P"
 "CTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MI"
 "NEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFF"
 "ER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBRATES" ("CO" VARCHAR2(3) NOT NULL ENABLE, "EMPLOYEE" VARCHA"
 "R2(9) NOT NULL ENABLE, "RATE" NUMBER(9, 4) NOT NULL ENABLE, "RATECODE" VARC"
 "HAR2(4) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOG"
 "GING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE"
 " 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                     "
 "  "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBSEL" ("CO" VARCHAR2(3) NOT NULL ENABLE, "PROJECT" VARCHAR2("
 "10) NOT NULL ENABLE, "ADV_BILL" VARCHAR2(1), "AMOUNT" NUMBER(10, 2), "CLIEN"
 "T" VARCHAR2(8), "DUEDATE" DATE, "EXP_AMOUNT" NUMBER(10, 2), "INVDATE" DATE,"
 " "INVOICE" VARCHAR2(8), "PRINTED" VARCHAR2(1))  PCTFREE 10 PCTUSED 40 INITR"
 "ANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXE"
 "XTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT"
 ")                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBSTCOPY" ("CO" VARCHAR2(3) NOT NULL ENABLE, "FRMPERIOD" DATE"
 " NOT NULL ENABLE, "TOPERIOD" DATE NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 I"
 "NITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 "
 "MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
 "AULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBSTWKHR" ("CO" VARCHAR2(3) NOT NULL ENABLE, "EMPLOYEE" VARCH"
 "AR2(9) NOT NULL ENABLE, "LASTDATE" DATE NOT NULL ENABLE, "ACCRUALPOST" VARC"
 "HAR2(1), "AMOUNT" NUMBER(8, 2), "STDHRS" NUMBER(6, 2), "WKHRS" NUMBER(6, 2)"
 ")  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 61"
 "44 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIS"
 "T GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBTEMPGL" ("AMOUNT" NUMBER(9, 2), "DEPT" VARCHAR2(3), "DIV" V"
 "ARCHAR2(3), "GL" VARCHAR2(6), "SUB" VARCHAR2(4))  PCTFREE 10 PCTUSED 40 INI"
 "TRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MA"
 "XEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
 "LT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBTRXINP" ("AEXP" VARCHAR2(4) NOT NULL ENABLE, "ALAB" VARCHAR"
 "2(4) NOT NULL ENABLE, "BU" VARCHAR2(1) NOT NULL ENABLE, "CO" VARCHAR2(3) NO"
 "T NULL ENABLE, "ECT" VARCHAR2(4) NOT NULL ENABLE, "ENTEREDDATE" DATE NOT NU"
 "LL ENABLE, "FBDN" VARCHAR2(4) NOT NULL ENABLE, "LCT" VARCHAR2(4) NOT NULL E"
 "NABLE, "MBDN" VARCHAR2(4) NOT NULL ENABLE, "POSTED" VARCHAR2(1) NOT NULL EN"
 "ABLE, "PROJECT" VARCHAR2(10), "REV" VARCHAR2(4) NOT NULL ENABLE, "SEQ" NUMB"
 "ER(12, 0) NOT NULL ENABLE, "TRANSDATE" DATE NOT NULL ENABLE, "UNBILLED_WIP""
 " VARCHAR2(4) NOT NULL ENABLE, "USERID" VARCHAR2(8) NOT NULL ENABLE, "VBDN" "
 "VARCHAR2(4) NOT NULL ENABLE, "WC" VARCHAR2(4) NOT NULL ENABLE, "WIP" VARCHA"
 "R2(4) NOT NULL ENABLE, "AMOUNT" NUMBER(10, 2), "BATCH" NUMBER, "BENEFITEE" "
 "VARCHAR2(9), "BILLED" VARCHAR2(1), "BILLING_INVOICE" NUMBER(6, 0), "BILLRAT"
 "E" NUMBER(7, 2), "BILL_AMOUNT" NUMBER(10, 2), "BURDEN_TYPE" VARCHAR2(6), "C"
 "LOSED" VARCHAR2(1), "COSTRATE" NUMBER(9, 4), "CTDEPT" NUMBER(3, 0), "CTDIV""
 " NUMBER(3, 0), "DES1" VARCHAR2(70), "DES2" VARCHAR2(70), "EMPLOYEE" VARCHAR"
 "2(9), "ENDTIME" VARCHAR2(5), "HOURS" NUMBER(7, 2), "INITIALS" VARCHAR2(3), "
 ""INVDATE" DATE, "INVOICE" VARCHAR2(8), "ITEM" VARCHAR2(15), "MBURDEN" NUMBE"
 "R(10, 2), "OFFICE" VARCHAR2(4), "PO" NUMBER(6, 0), "POLINE" NUMBER(3, 0), ""
 "PO_RELEASE" NUMBER(2, 0), "PREMIUM_HOURS" VARCHAR2(1), "QTY" NUMBER(10, 4),"
 " "REFERENCE" VARCHAR2(6), "SOURCE" VARCHAR2(4), "STARTTIME" VARCHAR2(5), "S"
 "TKLOC" VARCHAR2(3), "TBTRX_TYPE" VARCHAR2(1), "TYPE_ADJUSTMENT" VARCHAR2(1)"
 ", "UD" VARCHAR2(8), "UNITCOST" NUMBER(11, 4), "UNITPRICE" NUMBER(10, 2), "U"
 "OM" VARCHAR2(4), "VENDOR" VARCHAR2(6), "VOUCHER" NUMBER(6, 0), "QUANT" VARC"
 "HAR2(7), "STATUS" VARCHAR2(1), "FACTUREES" VARCHAR2(1), "UNIT_COST" NUMBER("
 "11, 3), "LOG_ORDER" NUMBER, "IN_PROGRESS" VARCHAR2(1), "COMPLETED" VARCHAR2"
 "(1), "REMARKS" VARCHAR2(1000))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
 "55 LOGGING STORAGE(INITIAL 18761728 NEXT 6641664 MINEXTENTS 1 MAXEXTENTS 12"
 "1 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)        "
 "               "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBUNITPRICE" ("CUSTOMER" VARCHAR2(8) NOT NULL ENABLE, "WKCAT""
 " VARCHAR2(4) NOT NULL ENABLE, "UNITPRICE" NUMBER(10, 2) NOT NULL ENABLE)  P"
 "CTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 102400"
 "0 NEXT 2048000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 10 FREELISTS 1 FREEL"
 "IST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBWRKCAT" ("BU" VARCHAR2(1) NOT NULL ENABLE, "CO" VARCHAR2(3)"
 " NOT NULL ENABLE, "DES" VARCHAR2(70) NOT NULL ENABLE, "WKCAT" VARCHAR2(4) N"
 "OT NULL ENABLE, "DESF" VARCHAR2(70), "LANG_CODE" VARCHAR2(1), "DEFAULT_RATE"
 "" NUMBER(10, 3), "FLAG_DOCTRCK" VARCHAR2(1), "FLAG_STAKING" VARCHAR2(1))  P"
 "CTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 10240 "
 "NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST G"
 "ROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TBWRKCDE" ("BU" VARCHAR2(1) NOT NULL ENABLE, "BURDEN_TYPE" VA"
 "RCHAR2(6) NOT NULL ENABLE, "CO" VARCHAR2(3) NOT NULL ENABLE, "WC" VARCHAR2("
 "4) NOT NULL ENABLE, "WKCAT" VARCHAR2(4) NOT NULL ENABLE, "DES" VARCHAR2(50)"
 ", "PROJECT" VARCHAR2(10), "RATECODE" VARCHAR2(4), "RATE_CODE" VARCHAR2(4), "
 ""DESF" VARCHAR2(50), "UNIT_PRICE" NUMBER(8, 2), "DAILY_COST" NUMBER(4, 2), "
 ""RENOV_WORK_CODE" VARCHAR2(6))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
 "55 LOGGING STORAGE(INITIAL 276480 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCT"
 "INCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)             "
 "          "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TEMPSALES" ("CCODE" VARCHAR2(3), "CUSTOMER" VARCHAR2(8), "FTO"
 "TALSALES" NUMBER(12, 2), "ITEM" VARCHAR2(24), "TOTALSALES" NUMBER(12, 2))  "
 "PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 "
 "NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST G"
 "ROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TEMP_BCT_CLOSE" ("BURDAMT" NUMBER(10, 2), "CTDEPT" NUMBER(3, "
 "0), "CTDIV" NUMBER(3, 0), "CTGL" NUMBER(6, 0), "CTSUB" NUMBER(4, 0))  PCTFR"
 "EE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 30720 NEXT"
 " 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROU"
 "PS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TERMS" ("TERMS" VARCHAR2(2) NOT NULL ENABLE, "CO" VARCHAR2(3)"
 ", "DES" VARCHAR2(15), "DISCDAYS" NUMBER(3, 0), "DUEDAYS" NUMBER(3, 0), "EOM"
 "" VARCHAR2(1), "HOLD" VARCHAR2(1), "PERCENT" NUMBER(4, 2))  PCTFREE 10 PCTU"
 "SED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEX"
 "TENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_"
 "POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TERRITORY" ("CO" VARCHAR2(3) NOT NULL ENABLE, "DES" VARCHAR2("
 "15), "TERRITORY" VARCHAR2(3))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
 "5 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINC"
 "REASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                "
 "       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "TRANSMITTAL_FORM" ("CO" VARCHAR2(3) NOT NULL ENABLE, "TRANSMI"
 "TTAL_ID" NUMBER(6, 0) NOT NULL ENABLE, "PROJECT" NUMBER(8, 0) NOT NULL ENAB"
 "LE, "CTRLNUM" NUMBER(8, 0) NOT NULL ENABLE, "SEQNUM" NUMBER(3, 0) NOT NULL "
 "ENABLE, "REGARDING1" VARCHAR2(40), "REGARDING2" VARCHAR2(40), "SHPNAME1" VA"
 "RCHAR2(30), "SHPNAME2" VARCHAR2(30), "SHPADDR1" VARCHAR2(30), "SHPADDR2" VA"
 "RCHAR2(30), "SHPCITY" VARCHAR2(15), "SHPST" VARCHAR2(2), "SHPZIP" VARCHAR2("
 "10), "CONTACT" VARCHAR2(20), "SHIPVIA" VARCHAR2(2), "COPIES1" NUMBER(3, 0),"
 " "COPIES2" NUMBER(3, 0), "COPIES3" NUMBER(3, 0), "COPIES4" NUMBER(3, 0), "C"
 "OPIES5" NUMBER(3, 0), "COPIES6" NUMBER(3, 0), "MINUTENUM1" NUMBER(6, 0), "M"
 "INUTENUM2" NUMBER(6, 0), "MINUTENUM3" NUMBER(6, 0), "MINUTENUM4" NUMBER(6, "
 "0), "MINUTENUM5" NUMBER(6, 0), "MINUTENUM6" NUMBER(6, 0), "WKCATDES1" VARCH"
 "AR2(30), "WKCATDES2" VARCHAR2(30), "WKCATDES3" VARCHAR2(30), "WKCATDES4" VA"
 "RCHAR2(30), "WKCATDES5" VARCHAR2(30), "WKCATDES6" VARCHAR2(30), "REM1" VARC"
 "HAR2(30), "REM2" VARCHAR2(30), "REM3" VARCHAR2(30), "REM4" VARCHAR2(30), "R"
 "EM5" VARCHAR2(30), "REM6" VARCHAR2(30), "REMARK1" VARCHAR2(220), "REMARK2" "
 "VARCHAR2(60), "REMARK3" VARCHAR2(60), "REMARK4" VARCHAR2(60), "REMARK5" VAR"
 "CHAR2(60), "REMARK6" VARCHAR2(60), "REMARK7" VARCHAR2(60), "REMARK8" VARCHA"
 "R2(60), "TRANSDATE" DATE, "SHPFAX" VARCHAR2(14))  PCTFREE 10 PCTUSED 40 INI"
 "TRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 460800 NEXT 34816 MINEXTENTS 1"
 " MAXEXTENTS 99 PCTINCREASE 10 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
 "AULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "UNIT_COST_GENERAL_RATE" ("CO" VARCHAR2(3), "UNIT_COST_RATE" N"
 "UMBER(7, 2))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE"
 "(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 99 PCTINCREASE 50 FREELISTS"
 " 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "UOMCONV" ("CO" VARCHAR2(3) NOT NULL ENABLE, "ITEM" VARCHAR2(2"
 "4) NOT NULL ENABLE, "CONVFCTR" NUMBER(10, 4), "UOM" VARCHAR2(4))  PCTFREE 1"
 "0 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144"
 " MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 B"
 "UFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "USERACCESS" ("CO" VARCHAR2(3) NOT NULL ENABLE, "USERID" VARCH"
 "AR2(20))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INI"
 "TIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 "
 "FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "USERCO" ("CO" VARCHAR2(3) NOT NULL ENABLE, "ALLOW_TEMP_VENDOR"
 "" VARCHAR2(1), "APINPUT_IN_GL" VARCHAR2(1), "BUDSUPERVISOR" VARCHAR2(1), "C"
 "HANGECO" VARCHAR2(1), "DEFAULT_DIV" NUMBER(3, 0), "GLINPUT_IN_PO" VARCHAR2("
 "1), "IC_PROC" VARCHAR2(1), "POSUPERVISOR" VARCHAR2(1), "SUPERVISOR" VARCHAR"
 "2(1), "USERACCESS" VARCHAR2(1), "USERID" VARCHAR2(20), "ALCIE_ADMINISTRATOR"
 "" VARCHAR2(1))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORA"
 "GE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELI"
 "STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "USER_PRINTER" ("COMPRESS_REPORT" VARCHAR2(1), "NUM_COPIES" NU"
 "MBER, "PRINTER_NAME" VARCHAR2(30), "REPORT_NAME" VARCHAR2(8), "USERNAME" VA"
 "RCHAR2(20))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE("
 "INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS"
 " 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "USER_PRINT_CONTROL" ("AG0" VARCHAR2(1), "AG1" VARCHAR2(1), "A"
 "G2" VARCHAR2(1), "AG3" VARCHAR2(1), "AG4" VARCHAR2(1), "AG5" VARCHAR2(1), ""
 "AG6" VARCHAR2(1), "AG7" VARCHAR2(1), "AG8" VARCHAR2(1), "AG9" VARCHAR2(1), "
 ""DEFAULT_PRINTER" VARCHAR2(30), "USERID" VARCHAR2(30))  PCTFREE 10 PCTUSED "
 "40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 6144 NEXT 6144 MINEXTENT"
 "S 1 MAXEXTENTS 121 PCTINCREASE 40 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL"
 " DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "USER_PROFILE" ("PRODUCT" VARCHAR2(30), "USERID" VARCHAR2(30),"
 " "PROFILE" VARCHAR2(240), "ATTRIBUTE" VARCHAR2(240), "NUMERIC_VALUE" NUMBER"
 "(15, 2), "CHAR_VALUE" VARCHAR2(240), "DATE_VALUE" DATE, "LONG_VALUE" LONG) "
 " PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 1024"
 "00 NEXT 51200 MINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 5 FREELISTS 1 FREELIST"
 " GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "ZONE" ("CO" VARCHAR2(3) NOT NULL ENABLE, "DES" VARCHAR2(15), "
 ""ZONE" VARCHAR2(4))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING "
 "STORAGE(INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 40 F"
 "REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USER_DATA'
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."USER_PRIVS"                           ("PRODUCT""
 ","USERID","PROFILE","ATTRIBUTE","NUMERIC_VALUE","CHAR_VALUE","DATE_VALUE",""
 "LONG_VALUE") AS "
 "select product, userid, profile, attribute,          numeric_value, char_va"
 "lue, date_value, long_value   from user_profile   where userid = user   wit"
 "h check option"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."SALES"                           ("REPID","CUSTI"
 "D","CUSTNAME","PRODID","PRODNAME","AMOUNT") AS "
 "SELECT REPID, ORD.CUSTID, CUSTOMER.NAME CUSTNAME, PRODUCT.PRODID, DESCRIP P"
 "RODNAME, SUM(ITEMTOT) AMOUNT FROM ORD, ITEM, CUSTOMER, PRODUCT WHERE ORD.OR"
 "DID = ITEM.ORDID AND ORD.CUSTID = CUSTOMER.CUSTID AND ITEM.PRODID = PRODUCT"
 ".PRODID GROUP BY REPID, ORD.CUSTID, NAME, PRODUCT.PRODID, DESCRIP"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."SPELL_NUMBER"                           ("INPUT_"
 "NUMBER","TH_TEXT","TH_SYM","ON_TEXT","DEC_TEXT") AS "
 "("
 "select i.numbervalue input_number,"
 "       t.numbertext Th_text,"
 "       decode((trunc(i.numbervalue/1000)),0,'','THOUSAND') Th_sym,"
 "       o.numbertext On_text,"
 "       'AND '||(i.numbervalue-floor(i.numbervalue))||'/100' Dec_text"
 "from   lookup t, lookup o, lookup i"
 "where  (trunc(i.numbervalue/1000) = t.numbervalue"
 "       and mod(i.numbervalue,1000) = o.numbervalue)"
 "or     (o.numbervalue = i.numbervalue"
 "       and t.numbervalue = -1)"
 ")"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."AR_SUM"                           ("TOT_INV","CO"
 "","CUSTOMER","APPLYTO") AS "
 "select sum(totalinvoice) tot_inv, co, customer, applyto from ardetail group"
 " by co, customer, applyto"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."ACCOUNT"                           ("ORDID","PRO"
 "DID","LIST_AMOUNT","ACTUAL_AMT") AS "
 "(select Item.Ordid Ordid, Item.Prodid Prodid, Qty*Stdprice List_Amount,"
 "Itemtot Actual_Amt from Price, Item where Price.Prodid = Item.Prodid)"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."TB_PRJNEW_01"                           ("PROJEC"
 "T","WC","HOURS","AMOUNT") AS "
 "SELECT PROJECT,WC,SUM(DECODE(TBTRX_TYPE,'L',NVL(HOURS,0),'G',NVL(HOURS,0)))"
 " HOURS,"
 "          SUM(DECODE(TBTRX_TYPE,'E',NVL(AMOUNT,0))) AMOUNT"
 "FROM   TBTRXINP"
 "GROUP BY PROJECT,WC"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."V_SURVEYOR_MAX"                           ("SURV"
 "EYOR","MINUTEDATE","MINUTENUM") AS "
 "select surveyor, max(minutedate) minutedate, max(minutenum) minutenum"
 "from lot"
 " group by surveyor"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."TBTRXINP_VIEW"                           ("WC",""
 "TBTRX_TYPE","POSTED","PROJECT","CO","TOT_HOURS") AS "
 "SELECT WC, TBTRX_TYPE, POSTED, PROJECT, CO,"
 "SUM(NVL(HOURS,0)) TOT_HOURS"
 "FROM TBTRXINP"
 "GROUP BY WC,TBTRX_TYPE,POSTED,PROJECT,CO"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "ALCIE"."V_NEW_INV"                           ("INVDTE",""
 "FTOTALINVOICE","PROJECT") AS "
 "SELECT A.INVDTE,A.FTOTALINVOICE, B.PROJECT                                 "
 "    "
 "FROM   ARDETAIL A, TBBILL B                                                "
 "    "
 "WHERE  B.CLIENT = A.CUSTOMER"
Import terminated successfully with warnings.
[oracle@Linux2005 OraHome]$
====
What do these warnings meed ?
When I query for selected tables I found nothing ?

ANy ideas ?

PT
0
Comment
Question by:ptreves
1 Comment
 
LVL 23

Accepted Solution

by:
seazodiac earned 1000 total points
ID: 12060402
Ptreves:

I think you really should post fewer posts, and instead focus on the open posts. If you got solutions already, close them.

I post the solution on the other forum....
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question