how do i rename a table in pl/sql ?

[Advocate]

working on warehouse project

need to rename temporary table after data load

eg could be to partition name

pl/sql will not accept dbms.sql or execute immediate statements

i am obviously missing something ?

help !


regards, david - no such thing as problems - only solutions.

 

[sem]

I don't know what you're missing, but DBMS_SQL obviously allows execution of DDL statements. The only difference is that they're to be executed during parse time. BTW renaming tables from PL/SQL is quite ugly idea.

Regards, Dima

http://seminihin.narod.ru