[HPADM] Remove "N" lines of a file with "sed" ?

From: Abramson, Stuart (SAbramson_at_Wabtec.com)
Date: 12/11/03

  • Next message: Tom Stoddard: "[HPADM] Re: Mapping Samba Share to XP"
    To: "Hpux-Admin (hpux-admin@dutchworks.nl)" <hpux-admin@dutchworks.nl>
    Date: Thu, 11 Dec 2003 12:08:56 -0500
    
    

    Below are the first "N" lines of an Oracle database control file.

    I want to delete the first "N" lines, from the beginning of the file down to
    the 2nd "***" line, and copy the rest of the file to a new file.

    I have to do it in a batch job. I would normally do these kinds of things
    with sed, but I can't quite figure out how.

    How do I do that?

            Stuart
    -----------------------------------------------

    /u1001/app/oracle/admin/HOTB/udump/ora_4073_hotb.trc
    Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.4.0 - Production
    ORACLE_HOME = /u1001/app/oracle/product/8.1.7
    System name: HP-UX
    Node name: wcshps07
    Release: B.11.11
    Version: U
    Machine: 9000/800
    Instance name: HOTB
    Redo thread mounted by this instance: 1
    Oracle process number: 15
    Unix process pid: 4073, image: oracle@wcshps07 (TNS V1-V3)

    *** SESSION ID:(10.1971) 2003-12-11 12:00:18.278
    *** 2003-12-11 12:00:18.278
    STARTUP NOMOUNT
    CREATE CONTROLFILE REUSE DATABASE "HOTB" NORESETLOGS ARCHIVELOG
        MAXLOGFILES 16
        MAXLOGMEMBERS 2
        MAXDATAFILES 30
        MAXINSTANCES 1
    Stuart Abramson | Off: 412/825-1434 | Cell: 412/417-1567 | email:
    sabramson@wabtec.com

    ***** CONFIDENTIALITY NOTE *****
    The content contained in this e-mail transmission is legally privileged and confidential information intended only for the use of the individual or entity named herein. If the reader of this transmission is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this transmission is strictly prohibited.

    --
                 ---> Please post QUESTIONS and SUMMARIES only!! <---
            To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
           Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
     
     Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
                http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)
    

  • Next message: Tom Stoddard: "[HPADM] Re: Mapping Samba Share to XP"

    Relevant Pages

    • Re: Connecting to an Oracle database
      ... PL/SQL Release 2.3.4.0.0 - Production ... I now succeded to connect to the database in Delphi with the ADO ... > use it to connect to the database and immediately after you connect Oracle ... > conform to their programming paradigm. ...
      (borland.public.delphi.database.ado)
    • Re: Adding columns to SQL Server tables dynamically
      ... So would you recommend a production app to add columns through ado.net ... > fragmentation in Sql Server or Oracle. ... > nullable column and then updating each row. ...
      (microsoft.public.dotnet.framework.adonet)
    • Are there performancebenefits to reorganizing database-using export/import?
      ... I am using Oracle 9.2.0.5 on HP UNIX 11i. ... I have a production database using Oracle 9.2.0.5, ... time we had done full export of 8.1.7 database and then created 9.2. ... all objects from application schemas and do schema imports. ...
      (comp.databases.oracle.server)
    • Re: Migrating from 8i
      ... We are using Oracle 8i on the occasion of our professional application. ... Sorry, no, the Standard edition is not free for production use. ... nontransferable limited license to use ... and not for any other purpose. ...
      (comp.databases.oracle.server)
    • Re: possible nomination for oracle wtf
      ... Many years ago, Oracle 7.3.4, in fact, I was a contractor ... The tape from the night before was empty aswell. ... stuff like this to either almost run in production or really get ... It's not uncommon to see people go on vacation when a product goes live. ...
      (comp.databases.oracle.server)