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.
