Brilliant, presuming you're allowed to change THOMAS. (Of course
decommissioning and recommissioning default null on THOMAS is also a change to
THOMAS. If we're splitting hairs I would say decommissioning and
recommissioning default NULL is not testing a relatively new feature.)
But if you are allowed to make that change upstream of your clone schema
testing of change, that would be a forward looking change that SHOULD eliminate
the problem.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Thomas Kellerer (Redacted sender "thomas.kellerer" for DMARC)
Sent: Tuesday, July 27, 2021 10:01 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: datapump import schema and default values taken from a sequence
Ah, that's a good idea. I can confirm that it works as expected.
Thanks for the suggestion.
Regards
Thomas
Jonathan Lewis schrieb am 27.07.2021 um 15:27:
--
Since you're on 18c has anyone suggested using an identity column - which
does exactly the same sort of "default on null sequence" approach, but does
it through a system generated sequence and doesn't reference a sequence name
in the dbms_metadata.get_ddl output, so will (presumably) create the correct
sequence on the import.
Regards
Jonathan Lewis
On Mon, 26 Jul 2021 at 11:03, Thomas Kellerer <dmarc-noreply@xxxxxxxxxxxxx
<mailto:dmarc-noreply@xxxxxxxxxxxxx>> wrote:
Hello,
we are using the DataPump API to clone schemas for testing purposes.
However, DataPump fails to import tables that use "DEFAULT ON NULL" based
on a sequence, as it does not remap the owner of the sequence reference in
the table's ddl.
Is there any way to tell DataPump to replace the reference to
"THOMAS"."MY_TABLE_ID_SEQ" with the target schema:
"ARTHUR"."MY_TABLE_ID_SEQ"?
Or is there any other way to clone a schema so that the above situation
would be resolved?
(In the long run, we might use PDBs instead of schemas, but for now this
is not an option).
We are using Oracle 18c.