Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> IMP, cannot import objects (Help!!!)

IMP, cannot import objects (Help!!!)

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 21 Aug 2001 01:55:12 -0700
Message-ID: <93f65984.0108210055.4c8083a4@posting.google.com>


dear all,

I cannot import all object belong to user "IFSAPP". Following is one example of the error codes. Is because they cannot find the table with "IFSAPP" schema?
how to solve this problem. Please help. I use imp sys/password full=y rows=n constraints=n indexes=n

Thanks in advance,
JK


. importing IFSAPP's objects into IFSAPP IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "IFSAPP"."CELL_SCHED_RECEIPT"
    (""
"CELL_SCHED_RECEIPT_ID","SCHEDULE_DATE","BUILD_SEQUENCE","QTY_SCHEDULED","QT"
"Y_COMPLETE","CONTRACT","PART_NO","MANUF_CELL","CELL_SCHED_STATUS","CELL_SCH"
"ED_STATUS_DB","OBJID","OBJVERSION") AS "
"SELECT cell_sched_receipt_id cell_sched_receipt_id,"
" schedule_date schedule_date,"
" build_sequence build_sequence,"
" qty_scheduled qty_scheduled,"
" qty_complete qty_complete,"
" contract contract,"
" part_no part_no,"
" manuf_cell manuf_cell,"
" substrb(Cell_Sched_Status_API.Decode(cell_sched_status),1,200)
cell_"
"sched_status,"
" cell_sched_status cell_sched_status_db,"
" rowid objid,"
" ltrim(lpad(to_char(rowversion,'YYYYMMDDHH24MISS'),2000))

      "

" objversion"
"FROM cell_sched_receipt_tab"
"WITH read only"
Received on Tue Aug 21 2001 - 03:55:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US