469,917 Members | 1,746 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

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
Jul 19 '05 #1
10 2390
TC
7.0 to 7.3.4 to 8i

//tc

"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:Wb***************@news-binary.blueyonder.co.uk...
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

Jul 19 '05 #2

"TC" <do******@donotuse.com> wrote in message
news:nY*******************@rwcrnsc52.ops.asp.att.n et...
7.0 to 7.3.4 to 8i

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

file://tc

"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:Wb***************@news-binary.blueyonder.co.uk...
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


Jul 19 '05 #3
TC
The primary script is u0703040.sql.

But please read the documentation for proper steps.

//tc
"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:_G****************@news-binary.blueyonder.co.uk...

"TC" <do******@donotuse.com> wrote in message
news:nY*******************@rwcrnsc52.ops.asp.att.n et...
7.0 to 7.3.4 to 8i


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

file://tc

"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:Wb***************@news-binary.blueyonder.co.uk...
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



Jul 19 '05 #4
"Vijay Singh" <vi*******@hotmail.com> wrote in message news:<_G****************@news-binary.blueyonder.co.uk>...
"TC" <do******@donotuse.com> wrote in message
news:nY*******************@rwcrnsc52.ops.asp.att.n et...
7.0 to 7.3.4 to 8i


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

file://tc

"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:Wb***************@news-binary.blueyonder.co.uk...
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



Why do you not want to use Export/Import?

Enquiring minds want to know.
ed
Jul 19 '05 #5

"Ed prochak" <ed********@magicinterface.com> wrote in message
news:4b**************************@posting.google.c om...
"Vijay Singh" <vi*******@hotmail.com> wrote in message news:<_G****************@news-binary.blueyonder.co.uk>...
"TC" <do******@donotuse.com> wrote in message
news:nY*******************@rwcrnsc52.ops.asp.att.n et...
7.0 to 7.3.4 to 8i


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

file://tc

"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:Wb***************@news-binary.blueyonder.co.uk...
> 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
>
>


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

Jul 19 '05 #6
"Vijay Singh" <vi*******@hotmail.com> wrote in message news:<JR*****************@news-binary.blueyonder.co.uk>...
"Ed prochak" <ed********@magicinterface.com> wrote in message
news:4b**************************@posting.google.c om...
"Vijay Singh" <vi*******@hotmail.com> wrote in message

news:<_G****************@news-binary.blueyonder.co.uk>...
"TC" <do******@donotuse.com> wrote in message
news:nY*******************@rwcrnsc52.ops.asp.att.n et...
> 7.0 to 7.3.4 to 8i
>

Ya 7.3.4 to 8i, Do you know of any script?
> file://tc
>
> "Vijay Singh" <vi*******@hotmail.com> wrote in message
> news:Wb***************@news-binary.blueyonder.co.uk...
> > 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
> >
> >
>
>


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
Jul 19 '05 #7

<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...
"Vijay Singh" <vi*******@hotmail.com> wrote in message

news:<JR*****************@news-binary.blueyonder.co.uk>...
"Ed prochak" <ed********@magicinterface.com> wrote in message
news:4b**************************@posting.google.c om...
"Vijay Singh" <vi*******@hotmail.com> wrote in message

news:<_G****************@news-binary.blueyonder.co.uk>...
> "TC" <do******@donotuse.com> wrote in message
> news:nY*******************@rwcrnsc52.ops.asp.att.n et...
> > 7.0 to 7.3.4 to 8i
> >
>
> Ya 7.3.4 to 8i, Do you know of any script?
>
>
> > file://tc
> >
> > "Vijay Singh" <vi*******@hotmail.com> wrote in message
> > news:Wb***************@news-binary.blueyonder.co.uk...
> > > 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
> > >
> > >
> >
> >

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


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.

Jul 19 '05 #8
Vijay Singh wrote:
<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...
"Vijay Singh" <vi*******@hotmail.com> wrote in message


news:<JR*****************@news-binary.blueyonder.co.uk>...
"Ed prochak" <ed********@magicinterface.com> wrote in message
news:4b**************************@posting.googl e.com...

"Vijay Singh" <vi*******@hotmail.com> wrote in message

news:<_G****************@news-binary.blueyonder.co.uk>...

>"TC" <do******@donotuse.com> wrote in message
>news:nY*******************@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" <vi*******@hotmail.com> wrote in message
>>news:Wb***************@news-binary.blueyonder.co.uk...
>>
>>>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
>>>
>>>
>>
>>
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

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.

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

Jul 19 '05 #9

"Frank" <fv********@netscape.net> wrote in message
news:bh**********@news2.tilbu1.nb.home.nl...
Vijay Singh wrote:
<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...
"Vijay Singh" <vi*******@hotmail.com> wrote in message
news:<JR*****************@news-binary.blueyonder.co.uk>...
"Ed prochak" <ed********@magicinterface.com> wrote in message
news:4b**************************@posting.googl e.com...

>"Vijay Singh" <vi*******@hotmail.com> wrote in message

news:<_G****************@news-binary.blueyonder.co.uk>...

>>"TC" <do******@donotuse.com> wrote in message
>>news:nY*******************@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" <vi*******@hotmail.com> wrote in message
>>>news:Wb***************@news-binary.blueyonder.co.uk...
>>>
>>>>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
>>>>
>>>>
>>>
>>>
>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

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.

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!)

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
--
Regards, Frank van Bortel

Jul 19 '05 #10
Vijay Singh wrote:

<SNIP!>
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


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

Jul 19 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by the_rev_dharma_roadkill | last post: by
1 post views Thread by Stephane VUILLIN | last post: by
4 posts views Thread by Chris Travers | last post: by
1 post views Thread by jagdeepkang2000 | last post: by
10 posts views Thread by Vijay Singh | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.