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_at_freelists.org <mailto:dmarc-noreply_at_freelists.org>> 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.

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