Re: unloading data from 7 using 9i.

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