Re: ORA-01647 during TTS IMPDP from 11.2.0.4 64 bit Solaris SPARC to 12.1.0.2 64 bit RHEL

Did you do DBMS_TTS.TRANSPORT_SET_CHECK, with the constraints included, on the source side?

On 11/10/2018 3:59 PM, Sundar Mahadevan wrote:
> Hi All,
> Greetings. While performing a transportable tablespace of application
> tablespaces from 11.2.0.4 Enterprise Edition 64 bit Solaris SPARC 10
> 1/13 to 12.1.0.2 Enterprise Edition 64 bit RHEL 7.3, I hit the
> following error.
>
> ORA-39083: Object type TABLE:"ARGUS_APP"."CASE_PRODUCT" failed to
> create with error:
> ORA-01647: tablespace 'ARGUS_DATA_05' is read-only, cannot allocate
> space in it
> Failing sql is:
> CREATE TABLE "ARGUS_APP"."CASE_PRODUCT" ("CASE_ID" NUMBER NOT NULL
> ENABLE, "SEQ_NUM" NUMBER NOT NULL ENABLE, "PRODUCT_ID" NUMBER,
> "DRUG_TYPE" NUMBER, "PAT_EXPOSURE" NUMBER DEFAULT 0, "MANUFACTURER_ID"
> NUMBER, "PROTOCOL_FOLLOWED" NUMBER, "SYS_C00008_11082108:57:04$"
> NUMBER, "FIRST_SUS_PROD" NUMBER, "SELECTED_VIEW" NUMBER, "SORT_ID
> ORA-39083: Object type TABLE:"ARGUS_APP"."CASE_ASSESS" failed to
> create with error:
> ORA-01647: tablespace 'ARGUS_DATA_01' is read-only, cannot allocate
> space in it
>
> I get this error for 5 tables. 3 tables out of 5 that returned
> ORA-01647 during impdp were non empty tables. No partitions on any of
> the tables. 2 tables out of the 5 have clobs. Regardless
> of deferred_segment_creation set to TRUE or FALSE on the source
> database, I get the same error. I even manually allocated extent on
> the 5 failing tables as suggested in a blog post with no luck. Anyone
> faced this issue? Ticket has been created with support. Not much
> progress yet. Thanks for your time and assistance. Appreciate it.

-- 
Mladen Gogala Database Consultant Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l