Hi,

I have got FULL export of oracle 805 database.

I am doing import in 817 database of a particular schema from this export dump.

Before, imort, I dropped the user with cascade and recreated the user.

My Import command is

imp system/manager@dev full=N ignore=Y constraints=Y buffer=100000 fromuser=X touser=Y file=abc.dmp log=abc.log

It imports all the tables successfully but at the end I am getting foll. messages.

IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'Lines subject to tax for the concurrent program Recurring Invoices (copy invoices)'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'Lines subject to tax for the concurrent program AutoInvoice'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view displays the current, baselined budget lines by PA period'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view displays the current, baselined budget lines by PA period'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View used to display drilldown paths to the user'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This a Business Intelligence System lookup view'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'Expenditure Item Info along with Denorm data in vertical fashion'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View that shows the organizations that can be used as expenditure organization in expenditure entry.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View for project-related requisitions distributions'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View for project-related uninvoiced purchase order distributions'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View for project related AP invoice distributions not yet in PA'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View of detail labor transactions for employee activity and utilization'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View of expenditure items for projects, which includes cost and revenue'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View to display the current PER_PEOPLE_F record for employees'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'For Bug # 1041297 view to be used for record group in PAXTRAPE Only'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view that displays details about the lowest level resource list members'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view displays details about a resource list and related resource list members'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View of the organizations that can be used as owning organizations of projects and tasks.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View for Revenue Audit by GL Account showing the Revenue Distribution Lines and the corresponding entries in Oracle General Ledger'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'View of the projects to which you can charge expenditures'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view displays the current, baselined budget lines by PA period'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view displays all the Resource List Members which have been defined for a Resource List'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'Project Status Inquiry Project Status Totals'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'R10SC Only - View of summary expensed, CIP, capitalizable, capitalized, and total project costs for capital projects'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'For View Projects and Tasks function in SST'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View for to-date numbers for the highest-level PA period totals or grand totals. This is a lower-level view that is referenced by PA_BIS_TOTALS_BY_PERIOD_V'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View for to-date numbers for the highest-level PA period totals or grand totals. This is a lower-level view that is referenced by PA_BIS_TOTALS_BY_PERIOD_V.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View for project-organization projects by PA period. This is also
a lower-level view that is referenced by PA_BIS_ORG_PRJ_BY_PERIOD_V.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View of project-organization projects by PA period. This is also a lower-level view that is referenced by PA_BIS_ORG_PRJ_BY_PERIOD_V.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View for category-class projects by PA period. This is also
a lower-level view that is referenced by PA_BIS_CLASS_PRJ_BY_PERIODS_V.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A Business Intelligence View for category-class projects by GL period. This is also
a lower-level view that is referenced by PA_BIS_CLASS_PRJ_BY_PERIODS_V.'
About to enable constraints...
Import terminated successfully with warnings.


Any Idea?

Thanks,