Code:
execute immediate 'create table oradba.modmast as (select * from plmprod.modmast);
This should be an insert statement rather than a create statement. You already have the table as davey has mentioned above, why do you want to create it again ?