Re: Strange Error importing a dmp file from Oracle11g to Oracle 12c

On Thu, Oct 6, 2016 at 2:09 PM, Andy Wattenhofer <watt0012_at_umn.edu> wrote:

> select t.tablespace_name, f.file_name
> from dba_tablespaces t, dba_temp_files f
> where t.tablespace_name=f.tablespace_name;
>

Sorry, the query should be

select t.tablespace_name, f.file_name
from dba_tablespaces t, dba_temp_files f where t.tablespace_name=f.tablespace_name   and t.contents='TEMPORARY';

--
http://www.freelists.org/webpage/oracle-l