FAQ
Original Message --------
Subject: Re: IDE for Oracle database
From:
Date: Tue, June 22, 2004 9:19 am
To:

use it on the laptop but can't count on it on the various unix servers;)

joe

original message below

Original Message -----
From:
Date: Tue, 22 Jun 2004 06:37:00 -0400 (EDT)
To:
Subject: Re: IDE for Oracle database

i was asked at my last assignment (so what developer tools you need),
my statement: command line on unix server and vi.

enough said :)

joe

joe, come over to the dark side and use vim.;-)

--

Bill "Shrek" Thater ORACLE DBA
shrek_at_consulant.com

"I'm going to work my ticket if I can..." -- Gilwell song

one ping to rule them all, one ping to find them,
one ping to bring them all, and in the mutex bind them.

--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
---------------------------------------------------------------- To
unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Search Discussions

  • DENNIS WILLIAMS at Jun 22, 2004 at 8:34 am
    Joe

    I'm with you. I received one of the best investments for my time from the
    couple of days I spent mastering vi. Every site and system I've worked on
    since then has had something "better" than vi. But you know these
    alternatives have always been different, requiring a learning curve. Many
    has been the times when the GUI-only people find their GUI won't work for
    some reason and have to come over and ask me to help out.

    Dennis Williams
    DBA

    Lifetouch, Inc.
    dwilliams_at_lifetouch.com

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of jtesta_at_dmc-it.com
    Sent: Tuesday, June 22, 2004 8:21 AM
    To: oracle-l_at_freelists.org
    Subject: [Fwd: Re: IDE for Oracle database]

    Original Message --------
    Subject: Re: IDE for Oracle database
    From:
    Date: Tue, June 22, 2004 9:19 am
    To:

    use it on the laptop but can't count on it on the various unix servers;)

    joe

    original message below

    Original Message -----
    From:
    Date: Tue, 22 Jun 2004 06:37:00 -0400 (EDT)
    To:
    Subject: Re: IDE for Oracle database

    i was asked at my last assignment (so what developer tools you need),
    my statement: command line on unix server and vi.

    enough said :)

    joe

    joe, come over to the dark side and use vim.;-)

    --

    Bill "Shrek" Thater ORACLE DBA
    shrek_at_consulant.com

    "I'm going to work my ticket if I can..." -- Gilwell song

    one ping to rule them all, one ping to find them,
    one ping to bring them all, and in the mutex bind them.

    --
    ___________________________________________________________
    Sign-up for Ads Free at Mail.com
    http://promo.mail.com/adsfreejump.htm


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ---------------------------------------------------------------- To
    unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Jun 22, 2004 at 8:37 am
    come on! I know the truth. You demanded sed, awk, grep, diff, od, and bp
    too.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of jtesta_at_dmc-it.com
    Sent: Tuesday, June 22, 2004 9:21 AM
    To: oracle-l_at_freelists.org
    Subject: [Fwd: Re: IDE for Oracle database]

    Original Message --------
    Subject: Re: IDE for Oracle database
    From:
    Date: Tue, June 22, 2004 9:19 am
    To:

    use it on the laptop but can't count on it on the various unix servers;)

    joe

    original message below

    Original Message -----
    From:
    Date: Tue, 22 Jun 2004 06:37:00 -0400 (EDT)
    To:
    Subject: Re: IDE for Oracle database

    i was asked at my last assignment (so what developer tools you need),
    my statement: command line on unix server and vi.

    enough said :)

    joe

    joe, come over to the dark side and use vim.;-)

    --

    Bill "Shrek" Thater ORACLE DBA
    shrek_at_consulant.com

    "I'm going to work my ticket if I can..." -- Gilwell song

    one ping to rule them all, one ping to find them,
    one ping to bring them all, and in the mutex bind them.

    --
    ___________________________________________________________
    Sign-up for Ads Free at Mail.com
    http://promo.mail.com/adsfreejump.htm


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ---------------------------------------------------------------- To
    unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jtesta_at_dmc-it.com at Jun 22, 2004 at 8:41 am
    ok i've been doing unix since '84, and dont remember bp at all and yes
    have used all of the others(and for you perl advocates, list owner and
    others, i'm still holding out learning it) :)

    joe

    original message below

    come on! I know the truth. You demanded sed, awk, grep, diff, od, and bp
    too.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of jtesta_at_dmc-it.com
    Sent: Tuesday, June 22, 2004 9:21 AM
    To: oracle-l_at_freelists.org
    Subject: [Fwd: Re: IDE for Oracle database]

    Original Message --------
    Subject: Re: IDE for Oracle database
    From:
    Date: Tue, June 22, 2004 9:19 am
    To:

    use it on the laptop but can't count on it on the various unix servers
    ;)

    joe

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Jun 22, 2004 at 11:01 am
    bp may have been specific to Dynix/PTX. I can't seem to find it anywhere
    else. I'm pretty sure I used it on to operate on various SUN boxes, but that
    may have been via NFS mount from a Sequent.

    Perhaps they renamed it? Veritas seems to have a bp command now that has
    nothing to do with binary patching.

    bp took a filename, an offset, and a patch string you could specify in
    ASCII, octal, or hex, and it was really convenient to use after OD showed
    you a problem you thought needed to be fixed, since it had similar notation
    to the arguments you needed to feed back to bp.

    Since it only exactly patched the address you indicated and did exactly what
    it was told to do, it was also nice when the headers and format anticipated
    by specific block editors were mucked up.

    Possibly "bed" now provides this functionality.

    Shows how long it has been since I've actually had to use bp. Primarily for
    Oracle, it was useful after a shutdown/startup restrict/shutdown normal/move
    to test system when the wrong online logs were kept and you didn't need any
    real deltas, just a correct header to process to make startup happy. Or if
    you had a crash during backup before there was a command to tell Oracle the
    files really weren't fuzzy and you were using the actual files from disk. We
    hardly need it anymore.

    Still, if someone knows what this has been renamed or whether it has really
    been relegated to the dustbin, I'd appreciate it. (And maybe that guy with
    the munged datafile from last week actually needs it.)

    mwf

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of jtesta_at_dmc-it.com
    Sent: Tuesday, June 22, 2004 9:34 AM
    To: oracle-l_at_freelists.org
    Subject: RE: [Fwd: Re: IDE for Oracle database]

    ok i've been doing unix since '84, and dont remember bp at all and yes
    have used all of the others(and for you perl advocates, list owner and
    others, i'm still holding out learning it) :)

    joe

    original message below

    come on! I know the truth. You demanded sed, awk, grep, diff, od, and bp
    too.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of jtesta_at_dmc-it.com
    Sent: Tuesday, June 22, 2004 9:21 AM
    To: oracle-l_at_freelists.org
    Subject: [Fwd: Re: IDE for Oracle database]

    Original Message --------
    Subject: Re: IDE for Oracle database
    From:
    Date: Tue, June 22, 2004 9:19 am
    To:

    use it on the laptop but can't count on it on the various unix servers
    ;)

    joe

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Thomas Pall at Jul 27, 2004 at 10:56 am
    I have the requirement for a ksh script which I suspect has been
    written and debugged by many of my fellow DBAs. If you have anything
    close which meets the specs, would you mind sharing me with it?

    The requirements are:

    Runs ksh
    Performs cold backup (database already shut down normal)
    Input parameters are
    a regular expression which defines the location of the database files
    target location
    the maximum number of threads
    Outputs are
    files copied and/or gzipped from source destination to target destination
    a log file containing the location/name of each file copied
    and/or gzipped
    some visibility into how the backup is proceeding
    The script picks up the source spec and target location of the
    backups. It spawns copy or gzip jobs up to maximum number of threads.
    When a copy and/or gzip completes, the file name/spec of the source
    file is appended to a log file that will be used for restore. The
    script sleeps then checks if the maximum number of threads/jobs
    specified in the third parameter passed to the script are still
    running. When needed, it kicks off more jobs/threads. It does this
    until all the source files are copied and or gzipped over to the
    target destination.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • Jared.Still_at_radisys.com at Jun 22, 2004 at 1:04 pm

    ok i've been doing unix since '84, and dont remember bp at all and yes
    have used all of the others(and for you perl advocates, list owner and
    others, i'm still holding out learning it) :)

    joe
    Please see http://www.infoworld.com/article/04/05/07/19FEtoptools_1.html

    Jared

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jtesta_at_dmc-it.com at Jun 23, 2004 at 4:00 am
    Some of us are holdouts :)

    joe

    original message below

    ok i've been doing unix since '84, and dont remember bp at all and yes
    have used all of the others(and for you perl advocates, list owner and
    others, i'm still holding out learning it) :)

    joe
    Please see http://www.infoworld.com/article/04/05/07/19FEtoptools_1.html

    Jared

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • Stephen.Lee_at_DTAG.Com at Jun 22, 2004 at 8:59 am

    -----Original Message-----
    (and for you perl advocates, list owner and
    others, i'm still holding out learning it) :)
    Long live ksh!

    Back in my Unix admin days I remember installing a GUI text editor for those
    who absolutely detested vi. I have since tried many times to remember what
    it was. For programming, it color coded the text according to the function
    of the text within the program. If one was clever and industrious, one
    could write custom add-on modules for it, and such modules were available on
    the internet. It might be interesting to see if there is a PL/SQL module
    for it.

    Once one gets used to vi (or its variants), one becomes forever attached to
    the speed at which things can be done. "Look folks, I can edit this text
    and at no time do my fingers ever leave my hands."

    Back to that GUI editor: What I thought was most impressive about it was
    that it was written using only X. Not Motif, not Athena. Just X.
    Oooooooh. Aaaaaaaah. We're not worthy! We're not worthy!

    If, based on my description, anyone can make a good guess about what the
    editor is, I would appreciate it.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jared.Still_at_radisys.com at Jun 22, 2004 at 1:03 pm

    oracle-l-bounce_at_freelists.org wrote on 06/22/2004 07:02:03 AM:
    -----Original Message-----
    ...
    If, based on my description, anyone can make a good guess about what the
    editor is, I would appreciate it.
    It was probably nedit.

    http://www.nedit.org/

    Jared

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Stephen.Lee_at_DTAG.Com at Jun 22, 2004 at 1:16 pm
    Thanks for the note. The name doesn't ring a bell, on the web page I
    noticed:

    "However, please notice that the NEdit GUI is still based on OSF Motif"

    which pretty much rules it out as a possibility. This editor was entirely X
    lib only. Which means the guy(s) had to code their own buttons, borders,
    text handling windows, etc. etc. which I think is just amazing. This gave
    the editor its own unique appearance. On top of all that, they designed a
    scripting language (I think) so that you could create your own custom
    modules that loaded when you started the editor.

    I hate it when I forget something like this. But at least now, maybe some
    more people out there can be annoyed wondering what the thing was called.
    -----Original Message-----
    It was probably nedit.
    http://www.nedit.org/

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Jun 22, 2004 at 1:18 pm
    wild guess -- mosaic?

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Stephen.Lee_at_DTAG.Com
    Sent: Tuesday, June 22, 2004 2:19 PM
    To: oracle-l_at_freelists.org
    Subject: RE: [Fwd: Re: IDE for Oracle database]

    Thanks for the note. The name doesn't ring a bell, on the web page I
    noticed:

    "However, please notice that the NEdit GUI is still based on OSF Motif"

    which pretty much rules it out as a possibility. This editor was entirely X
    lib only. Which means the guy(s) had to code their own buttons, borders,
    text handling windows, etc. etc. which I think is just amazing. This gave
    the editor its own unique appearance. On top of all that, they designed a
    scripting language (I think) so that you could create your own custom
    modules that loaded when you started the editor.

    I hate it when I forget something like this. But at least now, maybe some
    more people out there can be annoyed wondering what the thing was called.
    -----Original Message-----
    It was probably nedit.
    http://www.nedit.org/

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Stephen.Lee_at_DTAG.Com at Jun 22, 2004 at 3:12 pm
    XCORAL ***

    Mind you, I haven't looked at this in 10 years. But 10 years ago, I thought
    it was pretty good. Maybe now days it's lost some of its gee whiz appeal.
    You know, sort of like how fvwm2 was way cool 10-ish years ago.

    And if we keep working this thread long enough, maybe we will get an
    impressive string of 'RE's and '['s and 'Fwd's stacked up on the subject
    line. Go for a Guiness book record.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • GBA_DBA at Jul 2, 2004 at 4:38 pm
    How do you configure Vim to work with sql*plus on windows??

    Regards
    GBA

    -----Mensaje original-----
    De: oracle-l-bounce_at_freelists.org En
    nombre de jtesta_at_dmc-it.com
    Enviado el: Martes, 22 de Junio de 2004 08:21
    Para: oracle-l_at_freelists.org
    Asunto: [Fwd: Re: IDE for Oracle database]

    Original Message --------
    Subject: Re: IDE for Oracle database
    From:
    Date: Tue, June 22, 2004 9:19 am
    To:

    use it on the laptop but can't count on it on the various unix servers;)

    joe

    original message below

    Original Message -----
    From:
    Date: Tue, 22 Jun 2004 06:37:00 -0400 (EDT)
    To:
    Subject: Re: IDE for Oracle database

    i was asked at my last assignment (so what developer tools you need), my
    statement: command line on unix server and vi.

    enough said :)

    joe

    joe, come over to the dark side and use vim.;-)

    --

    Bill "Shrek" Thater ORACLE DBA
    shrek_at_consulant.com

    "I'm going to work my ticket if I can..." -- Gilwell song

    one ping to rule them all, one ping to find them, one ping to bring them
    all, and in the mutex bind them.

    --
    ___________________________________________________________
    Sign-up for Ads Free at Mail.com
    http://promo.mail.com/adsfreejump.htm


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ---------------------------------------------------------------- To
    unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Lyubomir Petrov at Jul 2, 2004 at 11:17 pm
    GBA,

    Install gvim for windows.
    Then in sql*plus:
    define _editor=
    You can put the command from 2) in the glogin.sql file
    (%ORACLE_HOME%\sqlplus\admin\glogin.sql), so you do not have to write
    this every time you start sql*plus.

    Regards,
    Lyubomir Petrov

    GBA_DBA wrote:
    How do you configure Vim to work with sql*plus on windows??

    Regards
    GBA
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • GBA_DBA at Jul 3, 2004 at 10:23 pm


    Notes in-line.

    Regards
    GBA

    -----Mensaje original-----
    De: oracle-l-bounce_at_freelists.org En
    nombre de Lyubomir Petrov
    Enviado el: Viernes, 02 de Julio de 2004 23:21
    Para: oracle-l_at_freelists.org
    Asunto: Re: [Fwd: Re: IDE for Oracle database]

    GBA,

    Install gvim for windows.
    Done.
    Then in sql*plus:
    define _editor=
    You can put the command from 2) in the glogin.sql file
    (%ORACLE_HOME%\sqlplus\admin\glogin.sql), so you do not have to write this
    every time you start sql*plus.
    Done.
    The only problem i have is when i finish a query i type :wq to get
    back to sql*plus
    if I do press / an then ENTER, sql*plus executes the first query i had
    in memory, not the one i modified. I have to type get afiedt.buf and
    then / + ENTER to execute
    the modified query. How can i do to make it work just like with
    notepad??

    Regards,
    Lyubomir Petrov

    GBA_DBA wrote:
    How do you configure Vim to work with sql*plus on windows??

    Regards
    GBA
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Lyubomir Petrov at Jul 4, 2004 at 3:49 am
    Hmmm, work fine for me...

    SQL> define _editor=C:\Vim\vim62\gvim.exe
    SQL> select 'AAA' from dual;

    'AA

    ---
    AAA

    SQL> ed
    Wrote file afiedt.buf

    1* select 'BBB' from dual
    SQL> /

    'BB
    ---
    BBB

    SQL>

    This was tested in both sqlplus and sqlplusw, Release 10.1.0.2.0 (Oracle
    Client installed on Windows XP Professional).

    Can you post more details about the client that you are using? Any
    details about the test?

    Regards,
    Lyubomir Petrov

    GBA_DBA wrote:
    Notes in-line.

    Regards
    GBA

    -----Mensaje original-----
    De: oracle-l-bounce_at_freelists.org En
    nombre de Lyubomir Petrov
    Enviado el: Viernes, 02 de Julio de 2004 23:21
    Para: oracle-l_at_freelists.org
    Asunto: Re: [Fwd: Re: IDE for Oracle database]

    GBA,

    1) Install gvim for windows.
    Done.
    2) Then in sql*plus:
    define _editor=
    3) You can put the command from 2) in the glogin.sql file
    (%ORACLE_HOME%\sqlplus\admin\glogin.sql), so you do not have to write this
    every time you start sql*plus.
    Done.
    The only problem i have is when i finish a query i type :wq to get
    back to sql*plus
    if I do press / an then ENTER, sql*plus executes the first query i had
    in memory, not the one i modified. I have to type get afiedt.buf and
    then / + ENTER to execute
    the modified query. How can i do to make it work just like with
    notepad??

    Regards,
    Lyubomir Petrov


    GBA_DBA wrote:


    How do you configure Vim to work with sql*plus on windows??

    Regards
    GBA




    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------



    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    .

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Lex de Haan at Jul 4, 2004 at 3:55 am
    you might try to add something like this:
    SQL> set editfile "/tmp/buffer.sql"

    this also solves the "problem" of all those afiedt.buf files in various
    places...

    Kind regards,
    Lex.

    visit my website at http://www.naturaljoin.nl

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Lyubomir Petrov
    Sent: Sunday, July 04, 2004 09:53
    To: oracle-l_at_freelists.org
    Subject: Re: [Fwd: Re: IDE for Oracle database]

    Hmmm, work fine for me...

    SQL> define _editor=C:\Vim\vim62\gvim.exe
    SQL> select 'AAA' from dual;

    'AA

    ---
    AAA

    SQL> ed
    Wrote file afiedt.buf

    1* select 'BBB' from dual
    SQL> /

    'BB
    ---
    BBB

    SQL>

    This was tested in both sqlplus and sqlplusw, Release 10.1.0.2.0 (Oracle
    Client installed on Windows XP Professional).

    Can you post more details about the client that you are using? Any
    details about the test?

    Regards,
    Lyubomir Petrov

    GBA_DBA wrote:
    Notes in-line.

    Regards
    GBA

    -----Mensaje original-----
    De: oracle-l-bounce_at_freelists.org En
    nombre de Lyubomir Petrov
    Enviado el: Viernes, 02 de Julio de 2004 23:21
    Para: oracle-l_at_freelists.org
    Asunto: Re: [Fwd: Re: IDE for Oracle database]

    GBA,

    1) Install gvim for windows.
    Done.
    2) Then in sql*plus:
    define _editor=
    3) You can put the command from 2) in the glogin.sql file
    (%ORACLE_HOME%\sqlplus\admin\glogin.sql), so you do not have to write this
    every time you start sql*plus.
    Done.
    The only problem i have is when i finish a query i type :wq to get
    back to sql*plus
    if I do press / an then ENTER, sql*plus executes the first query i had
    in memory, not the one i modified. I have to type get afiedt.buf and
    then / + ENTER to execute
    the modified query. How can i do to make it work just like with
    notepad??

    Regards,
    Lyubomir Petrov


    GBA_DBA wrote:


    How do you configure Vim to work with sql*plus on windows??

    Regards
    GBA




    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------



    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    .

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    -- Binary/unsupported file stripped by Ecartis --
    -- Type: text/x-vcard
    -- File: Lex de Haan.vcf

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • GBA_DBA at Jul 4, 2004 at 7:56 pm


    I'm working with Windows XP pro.

    SQL*Plus: Release 9.2.0.1.0 - Production on Dom Jul 4 19:48:26 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining
    options
    JServer Release 9.2.0.1.0 - Production

    galo_at_ORACLE9I> select 'AAA' from dual;

    'AA

    ---
    AAA

    galo_at_ORACLE9I> ed
    Wrote file afiedt.buf

    1* select 'AAA' from dual
    galo_at_ORACLE9I> /

    'AA
    ---
    AAA

    galo_at_ORACLE9I> get afiedt.buf
    1* select 'BBB' from dual
    galo_at_ORACLE9I> /

    'BB
    ---
    BBB

    galo_at_ORACLE9I>

    Regards
    GBA

    -----Mensaje original-----
    De: oracle-l-bounce_at_freelists.org En
    nombre de Lyubomir Petrov
    Enviado el: Domingo, 04 de Julio de 2004 03:53
    Para: oracle-l_at_freelists.org
    Asunto: Re: [Fwd: Re: IDE for Oracle database]

    Hmmm, work fine for me...

    SQL> define _editor=C:\Vim\vim62\gvim.exe select 'AAA' from dual;

    'AA
    ---
    AAA

    SQL> ed
    Wrote file afiedt.buf

    1* select 'BBB' from dual
    SQL> /

    'BB
    ---
    BBB

    SQL>

    This was tested in both sqlplus and sqlplusw, Release 10.1.0.2.0 (Oracle
    Client installed on Windows XP Professional).

    Can you post more details about the client that you are using? Any details
    about the test?

    Regards,
    Lyubomir Petrov

    GBA_DBA wrote:
    Notes in-line.

    Regards
    GBA

    -----Mensaje original-----
    De: oracle-l-bounce_at_freelists.org
    En nombre de Lyubomir Petrov
    Enviado el: Viernes, 02 de Julio de 2004 23:21
    Para: oracle-l_at_freelists.org
    Asunto: Re: [Fwd: Re: IDE for Oracle database]

    GBA,

    1) Install gvim for windows.
    Done.
    2) Then in sql*plus:
    define _editor=
    3) You can put the command from 2) in the glogin.sql file
    (%ORACLE_HOME%\sqlplus\admin\glogin.sql), so you do not have to write
    this every time you start sql*plus.
    Done.
    The only problem i have is when i finish a query i type :wq to
    get back to sql*plus if I do press / an then ENTER, sql*plus
    executes the first query i had in memory, not the one i
    modified. I have to type get afiedt.buf and then / + ENTER to execute
    the modified query. How can i do to make it work just like with
    notepad??

    Regards,
    Lyubomir Petrov


    GBA_DBA wrote:


    How do you configure Vim to work with sql*plus on windows??

    Regards
    GBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Lyubomir Petrov at Jul 5, 2004 at 3:13 am
    Hmmm, this is strange. I tried using Release 9.2.0.1.0 and it works fine
    for me...

    I tried to change the name of the file, played with file and folder
    attributes (read-only), but couldn't duplicate the behavior that you get.

    By the way, I'm using GVim 6.2. What version are you using?

    How are you logged in Windows? Administrator or normal user? What are
    the file and folder attributes? Where is the editfile created? Try to
    play around with all these...

    It's so easy to figure out things like this in Linux using strace. Does
    anybody know how to strace in Windows? :)

    Regards,
    Lyubomir Petrov

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • Jared Still at Jul 5, 2004 at 1:04 pm

    On Mon, 2004-07-05 at 01:16, Lyubomir Petrov wrote:
    It's so easy to figure out things like this in Linux using strace. Does
    anybody know how to strace in Windows? :)
    http://www.bindview.com/Support/RAZOR/Utilities/Windows/strace_readme.cfm

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Lyubomir Petrov at Jul 5, 2004 at 2:33 pm
    Thanks, Jared! This is one nice tool to have on Windows.

    Regards,
    Lyubomir Petrov

    Jared Still wrote:
    On Mon, 2004-07-05 at 01:16, Lyubomir Petrov wrote:

    It's so easy to figure out things like this in Linux using strace. Does
    anybody know how to strace in Windows? :)

    http://www.bindview.com/Support/RAZOR/Utilities/Windows/strace_readme.cfm



    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    .

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jared Still at Jul 5, 2004 at 8:24 pm
    Be sure to read all the notes on it.

    It *can* cause BSOD, though I've never seen it.

    It may not matter anyway, depending on the state
    of the system you run it on.

    Also, it must be on a local drive. A share
    won't do.

    Jared
    On Mon, 2004-07-05 at 12:36, Lyubomir Petrov wrote:
    Thanks, Jared! This is one nice tool to have on Windows.

    Regards,
    Lyubomir Petrov


    Jared Still wrote:
    On Mon, 2004-07-05 at 01:16, Lyubomir Petrov wrote:

    It's so easy to figure out things like this in Linux using strace. Does
    anybody know how to strace in Windows? :)

    http://www.bindview.com/Support/RAZOR/Utilities/Windows/strace_readme.cfm



    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    .


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Stephen.Lee_at_DTAG.Com at Jul 27, 2004 at 11:27 am
    If the list supports plain text attachments, then attached is a script I
    wrote to copy rman backup sets to tape via Networker (Legato). I think it
    has most of the components on your spec and would not be too difficult to
    modify for your purpose. The script has only a few comments, so it will
    require a significant knowledge of ksh scripting to understand it and modify
    it appropriately. Most of the modification will involve ripping out all the
    Networker stuff and replacing it with cp, tar, cpio, etc. commands.

    The command line contains the parent directory of directory structure that
    looks like

    /parent_dir

    /ORACLE_SID1
    files to backup
    /ORACLE_SID2
    files to backup

    So the command line looks like: tape_copy.ksh parent_dir1 parent_dir2 etc.

    The script looks for files to have names that match a particular pattern.

    The reason for allowing multiple parent_dirs is to allow the data file
    backups to go one place and the archived log backups to go to another place
    so that the archived logs can easily be copied to tape immediate after the
    rman backup finishes. On the box on which this run, it takes about 8.5
    hours, using 4 tape drives, to copy the data file backups to tape. So the
    archived logs get copied immediately, then the data file backups.

    The script checks to see if ORACLE_SID1 matches the name of a database on
    the box; if not, it assumes the directory is some ad hoc junk directory that
    should be skipped. There is no handy progress meter, however one can get an
    idea of where things are by checking the log files or by using the ps
    command.

    If the list doesn't support plain text attachments, then I guess this was a
    wasted post.

    If you do get the file OK and like it a lot, then just remember who wrote it
    if I ever need a job.

    Oh yeah, and the script is not guaranteed to be bug free.

    Binary/unsupported file stripped by Ecartis --
    Type: application/octet-stream
    File: tape_copy.ksh

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • David at Jul 27, 2004 at 11:35 am
    Taking into account all of the new features and functionalities and new
    approaches(LMT, index frag/rebuild debate, etc, etc, etc, what checks do
    you consider important to still be performed and on what frequency?

    I'll consolidate the responses and send back as I think a sort of all
    encompassing list would aid many and the ones available currently are
    outdated or incomplete.

    Cheers
    --
    ..
    David

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Stephen.Lee_at_DTAG.Com at Jul 27, 2004 at 11:38 am
    OK. The mail server can't recognize plain text files. Does anybody have
    any ideas on how to post it. It's kind of big for a cut and paste; and I
    think some of the formatting would get lost with the cut and paste
    operation.
    -----Original Message-----
    -- Binary/unsupported file stripped by Ecartis --
    -- Type: application/octet-stream
    -- File: tape_copy.ksh
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Niall Litchfield at Jul 28, 2004 at 6:46 am
    if ecartis works on file extensions try attaching tape_copy.txt - I
    know that plain text attachments have been sent successfully
    previously.

    Or if you have a web site send a link...

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Stephen.Lee_at_DTAG.Com at Jul 28, 2004 at 12:17 pm
    I added some needed comments to the script, and Tanel has posted it on his
    web site (Thanks).

    http://integrid.info/tape_copy.ksh

    Note that if you cut and paste, some formatting might be lost, or some TABs
    might be converted to SPACEs.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 22, '04 at 8:28a
activeJul 28, '04 at 12:17p
posts28
users12
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase