Porting database from Oracle7.0 to Oracle8i

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Vijay Singh

    Porting database from Oracle7.0 to Oracle8i

    Hi

    Does anybody know if Oracle provides any tool or script for porting database
    from Oracle7.0 to Oracle8.0. I know one can do it using Oracle*Export, but I
    am looking for a tool.

    Vijay


  • TC

    #2
    Re: Porting database from Oracle7.0 to Oracle8i

    7.0 to 7.3.4 to 8i

    //tc

    "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
    news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...[color=blue]
    > Hi
    >
    > Does anybody know if Oracle provides any tool or script for porting[/color]
    database[color=blue]
    > from Oracle7.0 to Oracle8.0. I know one can do it using Oracle*Export, but[/color]
    I[color=blue]
    > am looking for a tool.
    >
    > Vijay
    >
    >[/color]


    Comment

    • Vijay Singh

      #3
      Re: Porting database from Oracle7.0 to Oracle8i


      "TC" <donotuse@donot use.com> wrote in message
      news:nYe_a.9001 8$Vt6.28894@rwc rnsc52.ops.asp. att.net...[color=blue]
      > 7.0 to 7.3.4 to 8i
      >[/color]

      Ya 7.3.4 to 8i, Do you know of any script?

      [color=blue]
      > file://tc
      >
      > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
      > news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...[color=green]
      > > Hi
      > >
      > > Does anybody know if Oracle provides any tool or script for porting[/color]
      > database[color=green]
      > > from Oracle7.0 to Oracle8.0. I know one can do it using Oracle*Export,[/color][/color]
      but[color=blue]
      > I[color=green]
      > > am looking for a tool.
      > >
      > > Vijay
      > >
      > >[/color]
      >
      >[/color]


      Comment

      • TC

        #4
        Re: Porting database from Oracle7.0 to Oracle8i

        The primary script is u0703040.sql.

        But please read the documentation for proper steps.

        //tc


        "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
        news:_Gm_a.6470 $BB.4533@news-binary.blueyond er.co.uk...[color=blue]
        >
        > "TC" <donotuse@donot use.com> wrote in message
        > news:nYe_a.9001 8$Vt6.28894@rwc rnsc52.ops.asp. att.net...[color=green]
        > > 7.0 to 7.3.4 to 8i
        > >[/color]
        >
        > Ya 7.3.4 to 8i, Do you know of any script?
        >
        >[color=green]
        > > file://tc
        > >
        > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
        > > news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...[color=darkred]
        > > > Hi
        > > >
        > > > Does anybody know if Oracle provides any tool or script for porting[/color]
        > > database[color=darkred]
        > > > from Oracle7.0 to Oracle8.0. I know one can do it using Oracle*Export,[/color][/color]
        > but[color=green]
        > > I[color=darkred]
        > > > am looking for a tool.
        > > >
        > > > Vijay
        > > >
        > > >[/color]
        > >
        > >[/color]
        >
        >[/color]


        Comment

        • Ed prochak

          #5
          Re: Porting database from Oracle7.0 to Oracle8i

          "Vijay Singh" <vij_singh@hotm ail.com> wrote in message news:<_Gm_a.647 0$BB.4533@news-binary.blueyond er.co.uk>...[color=blue]
          > "TC" <donotuse@donot use.com> wrote in message
          > news:nYe_a.9001 8$Vt6.28894@rwc rnsc52.ops.asp. att.net...[color=green]
          > > 7.0 to 7.3.4 to 8i
          > >[/color]
          >
          > Ya 7.3.4 to 8i, Do you know of any script?
          >
          >[color=green]
          > > file://tc
          > >
          > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
          > > news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...[color=darkred]
          > > > Hi
          > > >
          > > > Does anybody know if Oracle provides any tool or script for porting[/color][/color]
          > database[color=green][color=darkred]
          > > > from Oracle7.0 to Oracle8.0. I know one can do it using Oracle*Export,[/color][/color]
          > but
          > I[color=green][color=darkred]
          > > > am looking for a tool.
          > > >
          > > > Vijay
          > > >
          > > >[/color]
          > >
          > >[/color][/color]

          Why do you not want to use Export/Import?

          Enquiring minds want to know.
          ed

          Comment

          • Vijay Singh

            #6
            Re: Porting database from Oracle7.0 to Oracle8i


            "Ed prochak" <ed.prochak@mag icinterface.com > wrote in message
            news:4b5394b2.0 308130432.4b718 121@posting.goo gle.com...[color=blue]
            > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message[/color]
            news:<_Gm_a.647 0$BB.4533@news-binary.blueyond er.co.uk>...[color=blue][color=green]
            > > "TC" <donotuse@donot use.com> wrote in message
            > > news:nYe_a.9001 8$Vt6.28894@rwc rnsc52.ops.asp. att.net...[color=darkred]
            > > > 7.0 to 7.3.4 to 8i
            > > >[/color]
            > >
            > > Ya 7.3.4 to 8i, Do you know of any script?
            > >
            > >[color=darkred]
            > > > file://tc
            > > >
            > > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
            > > > news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...
            > > > > Hi
            > > > >
            > > > > Does anybody know if Oracle provides any tool or script for porting[/color]
            > > database[color=darkred]
            > > > > from Oracle7.0 to Oracle8.0. I know one can do it using[/color][/color][/color]
            Oracle*Export,[color=blue][color=green]
            > > but
            > > I[color=darkred]
            > > > > am looking for a tool.
            > > > >
            > > > > Vijay
            > > > >
            > > > >
            > > >
            > > >[/color][/color]
            >
            > Why do you not want to use Export/Import?
            >[/color]
            The Oracle 8i is install in the other physical machine. Can you suggest
            better way?
            [color=blue]
            > Enquiring minds want to know.
            > ed[/color]


            Comment

            • sybrandb@yahoo.com

              #7
              Re: Porting database from Oracle7.0 to Oracle8i

              "Vijay Singh" <vij_singh@hotm ail.com> wrote in message news:<JRL_a.911 1$Ox6.7572@news-binary.blueyond er.co.uk>...[color=blue]
              > "Ed prochak" <ed.prochak@mag icinterface.com > wrote in message
              > news:4b5394b2.0 308130432.4b718 121@posting.goo gle.com...[color=green]
              > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message[/color]
              > news:<_Gm_a.647 0$BB.4533@news-binary.blueyond er.co.uk>...[color=green][color=darkred]
              > > > "TC" <donotuse@donot use.com> wrote in message
              > > > news:nYe_a.9001 8$Vt6.28894@rwc rnsc52.ops.asp. att.net...
              > > > > 7.0 to 7.3.4 to 8i
              > > > >
              > > >
              > > > Ya 7.3.4 to 8i, Do you know of any script?
              > > >
              > > >
              > > > > file://tc
              > > > >
              > > > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
              > > > > news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...
              > > > > > Hi
              > > > > >
              > > > > > Does anybody know if Oracle provides any tool or script for porting[/color][/color]
              > database[color=green][color=darkred]
              > > > > > from Oracle7.0 to Oracle8.0. I know one can do it using[/color][/color]
              > Oracle*Export,[color=green][color=darkred]
              > > > but
              > > > I
              > > > > > am looking for a tool.
              > > > > >
              > > > > > Vijay
              > > > > >
              > > > > >
              > > > >
              > > > >[/color]
              > >
              > > Why do you not want to use Export/Import?
              > >[/color]
              > The Oracle 8i is install in the other physical machine. Can you suggest
              > better way?
              >[color=green]
              > > Enquiring minds want to know.
              > > ed[/color][/color]


              You aren't serious, are you? You can copy or ftp binary the export to
              the other machine.
              Geez. If you really were an inquiring mind, you would have known this.
              But apparently you are completely clueless.

              Sybrand Bakker
              Senior Oracle DBA

              Comment

              • Vijay Singh

                #8
                Re: Porting database from Oracle7.0 to Oracle8i


                <sybrandb@yahoo .com> wrote in message
                news:a1d154f4.0 308150024.55805 206@posting.goo gle.com...[color=blue]
                > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message[/color]
                news:<JRL_a.911 1$Ox6.7572@news-binary.blueyond er.co.uk>...[color=blue][color=green]
                > > "Ed prochak" <ed.prochak@mag icinterface.com > wrote in message
                > > news:4b5394b2.0 308130432.4b718 121@posting.goo gle.com...[color=darkred]
                > > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message[/color]
                > > news:<_Gm_a.647 0$BB.4533@news-binary.blueyond er.co.uk>...[color=darkred]
                > > > > "TC" <donotuse@donot use.com> wrote in message
                > > > > news:nYe_a.9001 8$Vt6.28894@rwc rnsc52.ops.asp. att.net...
                > > > > > 7.0 to 7.3.4 to 8i
                > > > > >
                > > > >
                > > > > Ya 7.3.4 to 8i, Do you know of any script?
                > > > >
                > > > >
                > > > > > file://tc
                > > > > >
                > > > > > "Vijay Singh" <vij_singh@hotm ail.com> wrote in message
                > > > > > news:Wbb_a.166$ e27.136@news-binary.blueyond er.co.uk...
                > > > > > > Hi
                > > > > > >
                > > > > > > Does anybody know if Oracle provides any tool or script for[/color][/color][/color]
                porting[color=blue][color=green]
                > > database[color=darkred]
                > > > > > > from Oracle7.0 to Oracle8.0. I know one can do it using[/color]
                > > Oracle*Export,[color=darkred]
                > > > > but
                > > > > I
                > > > > > > am looking for a tool.
                > > > > > >
                > > > > > > Vijay
                > > > > > >
                > > > > > >
                > > > > >
                > > > > >
                > > >
                > > > Why do you not want to use Export/Import?
                > > >[/color]
                > > The Oracle 8i is install in the other physical machine. Can you suggest
                > > better way?
                > >[color=darkred]
                > > > Enquiring minds want to know.
                > > > ed[/color][/color]
                >
                >
                > You aren't serious, are you? You can copy or ftp binary the export to
                > the other machine.
                > Geez. If you really were an inquiring mind, you would have known this.
                > But apparently you are completely clueless.
                >
                > Sybrand Bakker
                > Senior Oracle DBA[/color]

                Sorry, I obiviously know to ftp across to other machine after exporting it
                from the source(Oracle 7.0 running on Dynix). What I want to know is, if
                there is a ready script which can create the file which will be compatible
                to Oracle 8i (running on Solaris).

                Also if I may say, it doesn't really says much about you being a senior
                oracle DBA, if you can't understand what some body is asking you. You must
                think too much about your self to be such a arrogant person. You are DBA not
                god, so come back to earth and say real things.





                Comment

                • Frank

                  #9
                  Re: Porting database from Oracle7.0 to Oracle8i

                  Vijay Singh wrote:
                  [color=blue]
                  > <sybrandb@yahoo .com> wrote in message
                  > news:a1d154f4.0 308150024.55805 206@posting.goo gle.com...
                  >[color=green]
                  >>"Vijay Singh" <vij_singh@hotm ail.com> wrote in message[/color]
                  >
                  > news:<JRL_a.911 1$Ox6.7572@news-binary.blueyond er.co.uk>...
                  >[color=green][color=darkred]
                  >>>"Ed prochak" <ed.prochak@mag icinterface.com > wrote in message
                  >>>news:4b5394b 2.0308130432.4b 718121@posting. google.com...
                  >>>
                  >>>>"Vijay Singh" <vij_singh@hotm ail.com> wrote in message
                  >>>
                  >>> news:<_Gm_a.647 0$BB.4533@news-binary.blueyond er.co.uk>...
                  >>>
                  >>>>>"TC" <donotuse@donot use.com> wrote in message
                  >>>>>news:nYe_a .90018$Vt6.2889 4@rwcrnsc52.ops .asp.att.net...
                  >>>>>
                  >>>>>>7.0 to 7.3.4 to 8i
                  >>>>>>
                  >>>>>
                  >>>>>Ya 7.3.4 to 8i, Do you know of any script?
                  >>>>>
                  >>>>>
                  >>>>>
                  >>>>>>file://tc
                  >>>>>>
                  >>>>>>"Vijay Singh" <vij_singh@hotm ail.com> wrote in message
                  >>>>>>news:Wbb_ a.166$e27.136@n ews-binary.blueyond er.co.uk...
                  >>>>>>
                  >>>>>>>Hi
                  >>>>>>>
                  >>>>>>>Does anybody know if Oracle provides any tool or script for[/color][/color]
                  >
                  > porting
                  >[color=green][color=darkred]
                  >>> database
                  >>>
                  >>>>>>>from Oracle7.0 to Oracle8.0. I know one can do it using
                  >>>
                  >>> Oracle*Export,
                  >>>
                  >>>>> but
                  >>>>> I
                  >>>>>
                  >>>>>>>am looking for a tool.
                  >>>>>>>
                  >>>>>>>Vijay
                  >>>>>>>
                  >>>>>>>
                  >>>>>>
                  >>>>>>
                  >>>>Why do you not want to use Export/Import?
                  >>>>
                  >>>
                  >>>The Oracle 8i is install in the other physical machine. Can you suggest
                  >>>better way?
                  >>>
                  >>>
                  >>>>Enquiring minds want to know.
                  >>>> ed[/color]
                  >>
                  >>
                  >>You aren't serious, are you? You can copy or ftp binary the export to
                  >>the other machine.
                  >>Geez. If you really were an inquiring mind, you would have known this.
                  >>But apparently you are completely clueless.
                  >>
                  >>Sybrand Bakker
                  >>Senior Oracle DBA[/color]
                  >
                  >
                  > Sorry, I obiviously know to ftp across to other machine after exporting it
                  > from the source(Oracle 7.0 running on Dynix). What I want to know is, if
                  > there is a ready script which can create the file which will be compatible
                  > to Oracle 8i (running on Solaris).
                  >
                  > Also if I may say, it doesn't really says much about you being a senior
                  > oracle DBA, if you can't understand what some body is asking you. You must
                  > think too much about your self to be such a arrogant person. You are DBA not
                  > god, so come back to earth and say real things.
                  >[/color]
                  OK, <god mode off>
                  How's reading the utilities manual?
                  Ever heard of the fact that export files are upward compatible, even
                  cross-platform?
                  And why would you need a script if the CLI command exp help=y
                  would provide you with all the information you need?
                  exp system/manager file=/tmp/full_exp.dmp log=/var/log/exp_full.log
                  compress=n full=y
                  ftp
                  imp (on the other machine, obviously!)
                  --
                  Regards, Frank van Bortel

                  Comment

                  • Vijay Singh

                    #10
                    Re: Porting database from Oracle7.0 to Oracle8i


                    "Frank" <fvanbortel@net scape.net> wrote in message
                    news:bhl6ge$dsk $1@news2.tilbu1 .nb.home.nl...[color=blue]
                    > Vijay Singh wrote:
                    >[color=green]
                    > > <sybrandb@yahoo .com> wrote in message
                    > > news:a1d154f4.0 308150024.55805 206@posting.goo gle.com...
                    > >[color=darkred]
                    > >>"Vijay Singh" <vij_singh@hotm ail.com> wrote in message[/color]
                    > >
                    > > news:<JRL_a.911 1$Ox6.7572@news-binary.blueyond er.co.uk>...
                    > >[color=darkred]
                    > >>>"Ed prochak" <ed.prochak@mag icinterface.com > wrote in message
                    > >>>news:4b5394b 2.0308130432.4b 718121@posting. google.com...
                    > >>>
                    > >>>>"Vijay Singh" <vij_singh@hotm ail.com> wrote in message
                    > >>>
                    > >>> news:<_Gm_a.647 0$BB.4533@news-binary.blueyond er.co.uk>...
                    > >>>
                    > >>>>>"TC" <donotuse@donot use.com> wrote in message
                    > >>>>>news:nYe_a .90018$Vt6.2889 4@rwcrnsc52.ops .asp.att.net...
                    > >>>>>
                    > >>>>>>7.0 to 7.3.4 to 8i
                    > >>>>>>
                    > >>>>>
                    > >>>>>Ya 7.3.4 to 8i, Do you know of any script?
                    > >>>>>
                    > >>>>>
                    > >>>>>
                    > >>>>>>file://tc
                    > >>>>>>
                    > >>>>>>"Vijay Singh" <vij_singh@hotm ail.com> wrote in message
                    > >>>>>>news:Wbb_ a.166$e27.136@n ews-binary.blueyond er.co.uk...
                    > >>>>>>
                    > >>>>>>>Hi
                    > >>>>>>>
                    > >>>>>>>Does anybody know if Oracle provides any tool or script for[/color]
                    > >
                    > > porting
                    > >[color=darkred]
                    > >>> database
                    > >>>
                    > >>>>>>>from Oracle7.0 to Oracle8.0. I know one can do it using
                    > >>>
                    > >>> Oracle*Export,
                    > >>>
                    > >>>>> but
                    > >>>>> I
                    > >>>>>
                    > >>>>>>>am looking for a tool.
                    > >>>>>>>
                    > >>>>>>>Vijay
                    > >>>>>>>
                    > >>>>>>>
                    > >>>>>>
                    > >>>>>>
                    > >>>>Why do you not want to use Export/Import?
                    > >>>>
                    > >>>
                    > >>>The Oracle 8i is install in the other physical machine. Can you suggest
                    > >>>better way?
                    > >>>
                    > >>>
                    > >>>>Enquiring minds want to know.
                    > >>>> ed
                    > >>
                    > >>
                    > >>You aren't serious, are you? You can copy or ftp binary the export to
                    > >>the other machine.
                    > >>Geez. If you really were an inquiring mind, you would have known this.
                    > >>But apparently you are completely clueless.
                    > >>
                    > >>Sybrand Bakker
                    > >>Senior Oracle DBA[/color]
                    > >
                    > >
                    > > Sorry, I obiviously know to ftp across to other machine after exporting[/color][/color]
                    it[color=blue][color=green]
                    > > from the source(Oracle 7.0 running on Dynix). What I want to know is, if
                    > > there is a ready script which can create the file which will be[/color][/color]
                    compatible[color=blue][color=green]
                    > > to Oracle 8i (running on Solaris).
                    > >
                    > > Also if I may say, it doesn't really says much about you being a senior
                    > > oracle DBA, if you can't understand what some body is asking you. You[/color][/color]
                    must[color=blue][color=green]
                    > > think too much about your self to be such a arrogant person. You are DBA[/color][/color]
                    not[color=blue][color=green]
                    > > god, so come back to earth and say real things.
                    > >[/color]
                    > OK, <god mode off>
                    > How's reading the utilities manual?
                    > Ever heard of the fact that export files are upward compatible, even
                    > cross-platform?
                    > And why would you need a script if the CLI command exp help=y
                    > would provide you with all the information you need?
                    > exp system/manager file=/tmp/full_exp.dmp log=/var/log/exp_full.log
                    > compress=n full=y
                    > ftp
                    > imp (on the other machine, obviously!)[/color]


                    Thanks Frank, thats what I was thinking to do in theory. As I am not a DBA I
                    was trying to find out if the there is a better way. And the reason I was
                    trying to find out for a better way because I have to give this solution to
                    some body who is not a DBA either. Well but thanks for confirming that our
                    theory was on the right track and thanks for being kind.
                    BTW On a lighter note, are you a DBA? If you are, then always be the way
                    you are now. Tell you, people like, DBAs like you, it is hard to find DBAs
                    like you. Every where I have worked, I met DBAs and Administrators who think
                    they are Gods, hence the god mode. LOL

                    Cheers Frank.
                    Vijay
                    [color=blue]
                    > --
                    > Regards, Frank van Bortel
                    >[/color]


                    Comment

                    • Frank

                      #11
                      Re: Porting database from Oracle7.0 to Oracle8i

                      Vijay Singh wrote:

                      <SNIP!>[color=blue]
                      > BTW On a lighter note, are you a DBA? If you are, then always be the way
                      > you are now. Tell you, people like, DBAs like you, it is hard to find DBAs
                      > like you. Every where I have worked, I met DBAs and Administrators who think
                      > they are Gods, hence the god mode. LOL[/color]

                      I'm not, but regarded as one by my peers.
                      When I witness some discussions going on on these ngs, I realize
                      over and over again I still have a lot to learn.
                      --
                      Regards, Frank van Bortel

                      Comment

                      Working...