2 Replies Latest reply: Mar 9, 2011 5:36 AM by Pavan Kumar RSS

    How to backup a package ??

      How to take a backup of a package ??

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

      DB -->
        • 1. Re: How to backup a package ??
          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

            spool the source code to file.

            - Pavan Kumar N