Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » invalid object
| invalid object [message #137532] |
Thu, 15 September 2005 08:05 |
roets
Messages: 1
Registered: September 2005
Location: Brussels
|
Junior Member |
|
|
During the import of a database, we were left with 45 additional invalid object, due to compilation warning during the import.
They are all belonging to FLOW_010500, version 1.5 and FLOW_010500, version 1.6 of html db. Version 1.6 is of this product is also installed.
the version 1.5 schema is left on the system as a downgrade feature, so most prob. not used anymore.
We are migrating from
Thru 64 Unix version 5.1B, oracle version 9.2.0.4.0 towards HPUX B.11.23 U ia64, oracle version 9.2.0.6.0 - 64bit Production
The customer wants exactly the same db's and is wondering from where those error come.
catalog, catproc, catpatch and utlrp did not fix it.
Any Idea ?
Chris
45 IMP-00041: Warning: object created with compilation warnings
FLOWS_010500 WWV_EXECUTE_IMMEDIATE
FLOWS_010500 WWV_FLOW_AUDIT
FLOWS_010500 WWV_FLOW_BUILDER
FLOWS_010500 WWV_FLOW_DATALOAD_XML
FLOWS_010500 WWV_FLOW_IMP_PARSER
FLOWS_010500 WWV_FLOW_LOAD_DATA
FLOWS_010500 WWV_FLOW_SVG
FLOWS_010500 WWV_FLOW_SW_UTIL
FLOWS_010500 WWV_FLOW_UPGRADE
FLOWS_010500 WWV_XML_UTIL
FLOWS_010500 WWV_XML_UTIL
FLOWS_010500 WWV_RENDER_REPORT3
FLOWS_010500 WWV_RENDER_CHART2
FLOWS_010500 WWV_RENDER_CALENDAR2
FLOWS_010500 WWV_FLOW_XLIFF
FLOWS_010500 WWV_FLOW_WIZARD_API
FLOWS_010500 WWV_FLOW_UTILITIES
FLOWS_010500 WWV_FLOW_TEMP
FLOWS_010500 WWV_FLOW_SW_API
FLOWS_010500 WWV_FLOW_QUERY
FLOWS_010500 WWV_FLOW_ITEM
FLOWS_010500 WWV_FLOW_DISP_PAGE_PLUGS
FLOWS_010500 WWV_FLOW_COLLECTION
FLOWS_010600 WWV_EXECUTE_IMMEDIATE
FLOWS_010600 WWV_FLOW_IMP_PARSER
FLOWS_010600 WWV_RENDER_REPORT3
FLOWS_010600 WWV_RENDER_CHART2
FLOWS_010600 WWV_RENDER_CALENDAR2
FLOWS_010600 WWV_FLOW_XLIFF
FLOWS_010600 WWV_FLOW_WIZARD_API
FLOWS_010600 WWV_FLOW_UTILITIES
FLOWS_010600 WWV_FLOW_UPGRADE
FLOWS_010600 WWV_FLOW_TEMP
FLOWS_010600 WWV_FLOW_SW_UTIL
FLOWS_010600 WWV_FLOW_SW_API
FLOWS_010600 WWV_FLOW_SVG
FLOWS_010600 WWV_FLOW_QUERY
FLOWS_010600 WWV_FLOW_SW_API
FLOWS_010600 WWV_FLOW_SVG
FLOWS_010600 WWV_FLOW_QUERY
FLOWS_010600 WWV_FLOW_LOAD_DATA
FLOWS_010600 WWV_FLOW_ITEM
FLOWS_010600 WWV_FLOW_FORM_CONTROL
FLOWS_010600 WWV_FLOW_AUDIT
FLOWS_010600 WWV_FLOW_CALENDAR3
FLOWS_010600 WWV_FLOW_COLLECTION
FLOWS_010600 WWV_FLOW_DISP_PAGE_PLUGS
FLOWS_010600 WWV_FLOW_BUILDER
45 rows selected.
here is an example :
(The rest are in attached file)
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "FLOWS_010500"."WWV_FLOW_FILES" ("ID","
""FLOW_ID","NAME","FILENAME","TITLE","MIME_TYPE","DOC_SIZE","DAD_CHARSET","C"
"REATED_BY","CREATED_ON","UPDATED_BY","UPDATED_ON","LAST_UPDATED","CONTENT_T"
"YPE","BLOB_CONTENT","LANGUAGE","DESCRIPTION","FILE_TYPE","FILE_CHARSET") AS"
" "
"select id, flow_id, name, filename, title, mime_type, doc_size, dad_charset"
","
" created_by, created_on, updated_by, updated_on, last_updated, cont"
"ent_type,"
" blob_content, language, description, file_type, file_charset"
" from wwv_flow_file_objects$"
" where security_group_id = wwv_flow.get_sgid"
|
|
|
|
Goto Forum:
Current Time: Tue Jan 07 17:14:32 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
