|| at Apr 19, 2007 at 5:33 pm
It's a good article with obvious advantages. Issue at hand is that, in
addition to the db upgrade I'm also redesigning the
underlying tablespace structure for data archival purposes. The current
DW is a homegrown monster that started out with no budget and patchwork
equipment. It has basically been duct taped and bailing wired
together. Think of a "redneck mansion" 5 trailer houses with connecting
porches. I'm using this opportunity to rebuild the base, create the
tables as empty on the new structure, and then export/import the data.
Better, stronger, faster...
Greg Rahn wrote:
Have you considered upgrading to 10.2 and then using cross platform
-------- Original Message --------
Subject: Datapump vs. 9i
From: Rodd Holman
Date: 4/19/2007 9:54 AM
Yeah, I know It's not supported. Here's the scenario:
HPUX, 188.8.131.52, 2TB Warehouse
AIX5L (5300), 10.2.0.3 Size/function same.
Would like to try using expdp/impdp as method of moving data. Is it
possible to install the datapump scripts (dbmsdp.sql, catdph.sql,
catdpb.sql, etc.) into a 9i database for using the expdp from a
remote client? Has anyone tried it? My export area is mounted on
the AIX box so if I could use the 10g client to export it down and
then import it up locally would be my best scenario.
Ideas, thoughts, suggestions...