Solved

Import Successfull with compilation warnings (???)

Posted on 2004-09-14
1
862 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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
JDeveloper 12c for 32 bit 4 67
Encryption Decryption in Oracle 12 102
Get the parent node - XMLTYPE 9 56
Problems using Provider=OraOLEDB.Oracle via VBScript/Classic ASP 5 44
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

932 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now