Cause
An attempt was made to create a sharded table AS SELECT from another table, which is not supported.
Action
Do not create any sharded table AS SELECT from other tables.
Oracle 26ai
ORA-03929
Error Message
CREATE TABLE...AS SELECT statement is not supported for sharded tables.