Fw: Cross-platform database move

Only 1,000 tables? No problem for exp/imp. We refresh the 85,000 tables and 125,000 indexes (3rd party COTS app) of our Student Information System Dev database from Prod every Sunday via exp/imp. The exp files are about 25GB. Over time the refresh has been from Win2k to HP-UX, from HP-UX to Linux, and now from 64bit Linux to 32bit Linux. All DBs are 9.2.0.4. The cross-OS compatibility of exp/imp is wonderful.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

   The devil made me do it the first time,    The second time I done it on my own.

• Billy Joe Shaver, "Black Rose"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith Sent: Tuesday, August 16, 2005 1:50 PM
To: jkstill_at_gmail.com; Brandon.Allen_at_oneneck.com Cc: oracle-l_at_freelists.org
Subject: Re: Cross-platform database move

Unfortunately there are rougly 1000 tables (in multiple schemas).

Do you know if I can use exp from HP-UX and imp from Sun? (or must I do both
using the same OS)?

Thanks.

...

--
http://www.freelists.org/webpage/oracle-l