8.1.6 client tools bug (?)

Hello,

We use Oracle 8.1.6 enterprise on a Linux server. I used export 8.1.6 to export a database schema (exported as the user, not as the DBA). After i created a new user at the same database, i imported the dump file exported from the previous step. The problem is that all objects are imported successfully, except for 3 views. Because of this, 2 PL/SQL packages were invalid for the new user. I took the views source from the first use and i had to create the views manually using SQL*Plus. One of these views is a simple view, selecting from a table. The other two however, are views created by joins, unions, etc. You can get the picture if i mention the source size of each view, which is approximately 5KB! Anyway, after creating these 3 views, compilation of the PL/SQL packages that were invalid went fine.

My point is: Is this a 8.1.6 client tools bug? After searching Metalink, i didn't find any relevant documentation about this. The same procedure tested on a Oracle 8.1.7 on Solaris worked fine.

TIA,
Vasilis Received on Fri Apr 04 2003 - 14:31:20 CEST