Oracle 7.3.3 to 8.0.5 Data Migration

From: Dimuth Samaranayaka <d.samaranayaka_at_mailbox.gu.edu.au>
Date: Wed, 04 Nov 1998 07:36:54 GMT
Message-ID: <71p06j$bcl$1@kraken.itc.gu.edu.au>

Hi all ,
Has anyone used the oracle 8.0.5 import utility. The problem that I am experiencing is that I am importing data from a schema within 7.3.3 version using export utility shipped with 7.3.3. When I try to perform the import of the dmp file into a schema on a 8.0.5 version using import utility shipped with 8.0.5 all is ok and now errors are reported

However, the question is that if any views are accessing tables within 8.0.5, if you do select count(*) from (view) oracle goes and accesses temporary space and comes up with saying not enough

The funny thing is that if you recreate the base table(s) using create table [table_name] as select * from [SCHEMA].[TABLE_NAME]@[db-link]

the view works fine...

Any idea's

Thanks
Dimuth Received on Wed Nov 04 1998 - 01:36:54 CST