Re: Prepare phase failed ORA-00904: "TABTYPE": invalid identifier

Posted by satish on Aug 23, 2023; 1:32pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Prepare-phase-failed-ORA-00904-TABTYPE-invalid-identifier-tp12029p12031.html

Hi erman,

Line 81: select tname into tablename from tab where tname ='ADX_PRE_AUTOCONFIG' and tabtype in ('TABLE', 'SYNONYM');
       


Table not existing in test environment ADX_PRE_AUTOCONFIG.
In prod,it is there.
Can we use export and import it from prod.How can we recreate it.pls suggest.

Thanks,
SG