Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> IMP, cannot import objects (Help!!!)
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))
""FROM cell_sched_receipt_tab"
" objversion"