ORA-01647 during TTS IMPDP from 11.2.0.4 64 bit Solaris SPARC to 12.1.0.2 64 bit RHEL
Date: Sat, 10 Nov 2018 12:59:28 -0800
Message-ID: <CADmQEr5Eej9dgtXSQ3A6JzXkio9fF7=jrhfwf2Dhb=YbUugt4A_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 10 2018 - 21:59:28 CET