DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: IMP-00032, IMP-00008 errors during import

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Question

    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,

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    It looks like you have a problem with the DBA_COMMENTS data dictionary entries. They used to be at the end of the dump file, or at lest after their objects.

    You might try a larger buffer (I use 1048576). But I think the problem is more likely a special symbol in the text confusing the import.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi jrpm,

    I checked in DBA_TAB_COMMENTS dict. table and those statements are found in that table in comments column but it surprises me becuase, I am doing import for only a particular user so why it shows errors related to objects of other schemas.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try increasing your buffer size. IT could be that your sqlstatements were not being able to be loaded into the buffer.

    One other thing is that make sure that your export does not contain any snapshots too...


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Yes, buffer increase has fixed the problem.

    Thanks guys.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width