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

So you already have a temp tablespace, and you just need to add a file to it. (aside: I should have made the join in that query a left join so it would have shown that.)

Just add a temp file:

alter tablespace temp add tempfile '<file name>' size <size>;

On Thu, Oct 6, 2016 at 2:42 PM, Murray Sobol <Murray.Sobol_at_openlink.com> wrote:

> Thanks Andy – good catch.
>
>
>
> I ran your query and got “no rows selected”.
>
>
>
> Somehow I managed to create this database without a TEMP file.
>
>
>
> However, when I try to create a TEMP tablespace with this command:
>
> CREATE TEMPORARY TABLESPACE temp TEMPFILE 'F:\Database\Oracle12c\Develop12c\temp01.dbf'
>
>
> SIZE 100M REUSE
>
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;
>
>
>
> I get this error:
>
> ERROR at line 1:
>
> ORA-01543: tablespace 'TEMP' already exists
>
>
>
> Murray
>
>
>
>
>
>
>
> *From:* Andy Wattenhofer [mailto:watt0012_at_umn.edu]
> *Sent:* October-06-16 3:12 PM
> *To:* Murray Sobol <Murray.Sobol_at_openlink.com>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* 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';
>
> Except as otherwise expressly agreed in a binding contract, copyright in
> this message and any attachments remains with OpenLink. It is confidential
> and may be legally privileged. If this message is not intended for you it
> must not be read, copied or used by you or disclosed to anyone else. Please
> advise the sender immediately if you have received this message in error.
> Although this message and any attachments are believed to be free of any
> virus or other defect that might affect any computer system into which it
> is received and opened, it is the responsibility of the recipient to ensure
> that it is virus free and no responsibility is accepted by OpenLink for any
> loss or damage in any way arising from its use.
>

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