Re: Export

In article <Henry_okeeffe.30.000CC838_at_inmarsat.org> Henry O' Keeffe, Henry_okeeffe_at_inmarsat.org writes:
>About to export specified users ...
>User to be exported: (RETURN to quit) > P3QC
>About to export P3QC's objects ...
>. exporting snapshots
>. exporting snapshot logs
>. exporting job queues
>EXP-00008: ORACLE error 900 encountered
>ORA-00900: invalid SQL statement
>EXP-00000: Export terminated unsuccessfully
>
>Oracle support don't know the reason. They suggested that I run
 catproc.sql
>and catalog.sql again, after the import. It obviously didn't make a
>difference.
>
>Has anyone any ideas?

You might try re-running CATEXP.SQL. That script defines the views used by EXP. I'm surprised that Oracle didn't suggest that. They have told me to do that before.

Good luck.

Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis,