2 Replies Latest reply: Mar 8, 2011 11:36 PM by Pavan Kumar RSS

    How to backup a package ??

    840556
      How to take a backup of a package ??

      I do not use tools like sqldeveloper/toad ...

      DB --> 10.2.0.3.0
        • 1. Re: How to backup a package ??
          sb92075
          SQL> desc dba_source
           Name                            Null?    Type
           ----------------------------------------- -------- ----------------------------
           OWNER                                  VARCHAR2(30)
           NAME                                  VARCHAR2(30)
           TYPE                                  VARCHAR2(12)
           LINE                                  NUMBER
           TEXT                                  VARCHAR2(4000)
          select text from user_source where name = 'PROC_NAME' order by LINE;
          • 2. Re: How to backup a package ??
            Pavan Kumar
            Hi,

            spool the source code to file.

            - Pavan Kumar N