Re: Export 8i (8859p1) to 9i (AL32UTF8)

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sat, 19 Jun 2004 14:07:50 +0200
Message-ID: <kva8d0ledd5t67s8sv1h8qp1o9258onvu5@4ax.com>

On Sat, 19 Jun 2004 10:35:00 +0200, "zeb" <spam_at_nowhere.com> wrote:

>. exporting cluster definitions
>. about to export PATENTDEV's tables via Conventional Path ...
>EXP-00008: ORACLE error 904 encountered
>ORA-00904: "SPOLICY": invalid identifier
>EXP-00000: Export terminated unsuccessfully
>
>
>How can do that ????
>Thanks in advance
>

You could of course have tried to find out what SPOLICY is in the source database.
Likely it has to do with Row Level Security. If your database uses RLS, you *must* connect as SYSDBA to get a correct export.

As usual trying to export a higher version export in a lower version database will fail miserably. As has been explained over and over and over again here.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jun 19 2004 - 07:07:50 CDT