Re: Export for Upgrade

Contrary to what one has said here, there is a way to FTP the export file to another server without consuming any local disk space on your unix server. Whether or not you can import it is another story. I do not know if the 8i import utility can read a 7.2 export file but it can't hurt to try. My guess would be it can but I have no 7.2 database to try it on.

1. Create a named pipe. mkfifo ftpexp.dmp
2. Run an ftp job in background similar to this. The "&" simply means "run in background" The -n means don't try to log in automatically.

ftp -n <<-! &
open remotehost
user username password <----- these are for remote host cd remote_destination_directory
bin
put "| cat ftpexp.dmp" ftpexp.dmp <--- The pipe symbol is important !

3. exp user/password file=ftpexp.dmp

When this completes, your export file should be transferred to the remote server. Try to read it with the imp utility over there.

Some unixes require the "| cat expdat.dmp" where others will let ftp treat it as a regular file. On AIX we must use the "cat" command. On yours you may not near that special quoted file name.

Let me know how you made out. If this does not work I have another trick you could try using just thje 7.2 exp/imp utilities.

--
Chuck



"Jonathan Bliss" <bliss_jonathan_at_hotmail.com> wrote in message
news:Padn9.298$YB1.50183_at_newsfep1-win.server.ntli.net...


> Could anyone help with the following, I have tried in metalink.

>

> An old 7.2.3 database has outgrown an old DEC, Digital Unix 3.1 box.

>

> There is an NT Server with Oracle 8.1.7.4.1 waiting to take the database.

>

> The Unix box is the last in the network and I don't do Unix.

>

> There is not enough room on the old box to take an export and say ftp it

> across. We are reluctant to make space by killing the database until it is

> up on the new box. The old tape backup is unlikely to be transferrable. We

> don't have any NFS software and there is a reluctance to implement it for

> this one off occasion.

>

> The oldest oracle client export anyone can find is 7.3.4 which gives

> EXP-00037 errors.

>

> Any thoughts as to how to move it across - assuming it will go.

>

> e.g. Is there a simple way of making the network visible or does anyone

know


> where I could download a copy of the 7.2 exp utility for a DOS/Windows

>

>