taking back up of DB- object procedure and reexecuting

Asked Jul 29 '16 at 14:07

Active Jul 29 '16 at 14:07

Viewed 30 times

how to take back up of a DB object and re execute the object.

now trying to do :taking back up using dbms_metadata and storing the definition in table as clob and using dynamic execution(execute immediate). issue: dynamic execution is not accepting definition more than 32k characters.

asked Jul 29 '16 at 14:07

guru raj

1

Use DBMS_SQL. There are overloads with CLOB. Or use this http://stackoverflow.com/questions/21689421/oracle-how-to-handle-32k-string-length-in-variables – Mottor Jul 29 '16 at 14:29
what object definition do you have that is more than 32k long? That's a big thing. – APC Aug 06 '16 at 05:50
procedures objects – guru raj Sep 06 '16 at 08:53

taking back up of DB- object procedure and reexecuting

0 Answers0