Re: Strange Error importing a dmp file from Oracle11g to Oracle 12c
- From: Andy Wattenhofer <watt0012@xxxxxxx>
- To: Murray.Sobol@xxxxxxxxxxxx
- Date: Thu, 6 Oct 2016 14:11:40 -0500
On Thu, Oct 6, 2016 at 2:09 PM, Andy Wattenhofer <watt0012@xxxxxxx> 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';
Other related posts: