Re: Question: Export problem under 10G

"BD" <bobby_dread_at_hotmail.com> wrote in message news:1133204153.386516.149430_at_g14g2000cwa.googlegroups.com...
> Hi, all.
>
> I have a 10gR2 database (on W2003) which I imported in from an export
> file made in 8i on AIX.
>
> I created the db as per normal, and then imported all non-system
> schemas from the exported 8i database.
>
> I now want to export these same schemas, to bring the db over to
> another Windows server.
>
> The export process bombs every time, saying 'Table or View does not
> exist'. I tried running catexp.sql, suspecting that it was the export
> views that were the problem. Catexp.sql ran fine, but the error
> persists.
>
> I'd appreciate any wisdom that could be offered.
>
> Here is the session log:
>
> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
> - Production
> With the Partitioning, OLAP and Data Mining options
> Enter array fetch buffer size: 4096 >
>
> Export file: EXPDAT.DMP >
>
> (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > u
>
> Export grants (yes/no): yes >
>
> Export table data (yes/no): yes >
>
> Compress extents (yes/no): yes >
>
> Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
> set
> EXP-00056: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> EXP-00000: Export terminated unsuccessfully
>
> TACSUIT1 D:\Imports>
>
>
> *** that's all I see - it does not explicitly say which table or view
> it's choking on , so I am unclear how to proceed...
>
> Thanks!!
>
> BD
>

If you have support, you might register a TAR with Oracle - I had to install 2 patches to get export working errorfree on AIX 5.2 with Oracle 10.1.0.4.1.

Matthias Received on Mon Nov 28 2005 - 13:51:31 CST