From: Vasileios Lourdas <Vasileios.Lourdas@eurodyn.com>
Newsgroups: comp.databases.oracle
Subject: 8.1.6 client tools bug (?)
Date: Fri, 04 Apr 2003 15:31:20 +0300
Organization: European Dynamics S.A.
Lines: 21
Message-ID: <3E8D7B18.F48722B@eurodyn.com>
NNTP-Posting-Host: 62.1.9.174
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-7
Content-Transfer-Encoding: 7bit
X-Trace: nic.grnet.gr 1049459486 17571 62.1.9.174 (4 Apr 2003 12:31:26 GMT)
X-Complaints-To: abuse@grnet.gr
NNTP-Posting-Date: Fri, 4 Apr 2003 12:31:26 +0000 (UTC)
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en


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