Experimenting with downgrading oracle to SE2

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 25 Jul 2022 11:07:05 -0500
Message-ID: <CAJvnOJZsSZ76=iRnmM8=PFDnTzDc9LV2-kagymStwAGjsWctvg_at_mail.gmail.com>

I have been experimenting with a minimum time downgrade of oracle Enterprise edition to oracle standard edition 2. I am still in the initial testing phase, but I really cant figure out the issue. Here is what I am doing:

Oracle 19c on OEL7.9

Set deferred_segment_creation=false on both the source (EE) database and destination (SE2) database.

Created a dataguard standby of the source, synched it up. Converted the dataguard standby to a snapshot standby, shut down the snapshot standby, started it.

Set all the user data tablespaces to read only on snapshot standby Ran the expdp full transportable export while copying the tablespace files from snapshot standby.

Problem on the destination is this error:

ORA-39083: Object type TABLE:"MYOWNER"."MYTABLE" failed to create with error:
ORA-01647: tablespace 'MYTABLESPACE' is read-only, cannot allocate space in it

I understood that the tablespaces had to be in read only mode when I copied them, is that incorrect?

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Mon Jul 25 2022 - 18:07:05 CEST