Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unloading data from 7 using 9i.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:vjur62p60irb3cqrle073oeenn2ebk3pqi_at_4ax.com...
> On 19 May 2006 09:11:25 -0700, "Kevin" <kevinherring_at_lycos.co.uk>
> wrote:
>
>>ok the new server already has 9 on it, so i guess you mean the old one.
>>We cant do this as we shouldnt even have command line access to it, let
>>alone installing software on it.
>
> Take a screwdriver, open the old system, take the old disk out, and
> place them in the new server.
> Now migrate the database to the newer version.
> Other than that: dump the database to ascii files and load them on the
> new server using sql*loader.
> Other than that: print the entire content of the old database and have
> a bunch of (preferably female) datatypists type it in the new one.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Other than that: hire a Senior DBA to do it, but there is no guarantee when it will finish. Received on Fri May 19 2006 - 18:44:30 CDT