Creating another db from Unix to Linux (copying files)

[krw]

Afternoon all,

I want to take a copy of our production db 8.1.7.2 (on Unix) and re-create our development db 8.1.7.2 (on Linux). I've done this many times by shutting the db down copying the files recreating db etc.. but can this method be used from Unix to Linux??

Thanks in advance

[gandolf989]

While you can certainly try it. I would think that the file systems are different and therefore you would need to do an export/import. You can do an export and pipe it to a compress. Then ftp it over an import while piping it from the uncompress.

[krw]

I'm trying to avoid an export/import as it takes days to finish (approx 3 days)!

The db is around 20gb..

[krw]

Do I have any other options but export/import?

Help?

[davey23uk]

20Gb isnt that big, import / export should not be taking that long.

Could create your new db on the linux system, set up a db link and do the copy like that

[raghud]

Even transportable tablespaces doesn't work in your case, since OS is different. Any way you are telling it is going to be test box. So export/import with rows=n indexes=n and recreate indexes later. Then it won't take any time.