Porting database from Oracle7.0 to Oracle8i

[Vijay Singh]

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]

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]

[Vijay Singh]

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]

[TC]

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]

[Ed prochak]

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

[Vijay Singh]

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]

[sybrandb@yahoo.com]

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

[Vijay Singh]

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.

[Frank]

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

[Vijay Singh]

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]

[Frank]

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