Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I'm unable to run dbms_metadata.get_ddl against a job owned by SYS

2782699Dec 3 2014 — edited Dec 4 2014

I have a job that is owned by SYS that I would like to copy over from one oracle server to another (in a different data center location). What would be the best way to copy that job over? I tried running dbms_metadata.get_ddl but unable to because it is owned by SYS. Below is the output from the query.

SQL> select dbms_metadata.get_ddl('PROCOBJ','kill_hung_session') from dual;

ERROR:

ORA-31603: object "kill_hung_session" of type PROCOBJ not found in schema "SYS"

ORA-06512: at "SYS.DBMS_METADATA", line 5088

ORA-06512: at "SYS.DBMS_METADATA", line 7589

ORA-06512: at line 1

Thank you in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2015

Added on Dec 3 2014

#general-database-discussions

12 comments

5,133 views