simple question: I am going to create the table
I am trying to do the following in an Oracle stored procedure.
1 - rename MyTableName to TEMP_MyTableName
2 - create table MyTableName;
3 - Insert into MyTableName select * from TEMP_MyTableName;
4 - Drop table TEMP_MyTableName;
I am getting the following error for line 3
PL/SQL: ORA-00942: table or view does not exist
Since at the procedure creation time, TEMP_MyTableName does not exist.
Any way to go around this issue,
Thanks,
Hisham Awad