Solved

Import Successfull with compilation warnings (???)

Posted on 2004-09-14
1
856 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
Comment Utility
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.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

743 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

17 Experts available now in Live!

Get 1:1 Help Now