expdp %USERNAME%/easyeasy dumpfile=expdatlive.dnptransport_tablespaces=(USERS,TOOLS,INDX,PVDF_REFDATA,OEM_REPOSITORY,QHRS91_IDX,COMMS2002_REFDATA,HHMASTER_DATA,COMMS,PVDF_DEMOGS_IDX,COIN_STUDY_INDEX,PVDF_IDX,COMMS91_REFDATA,COMMS91,QC_VIEWING_IDX,COMMS2000,COMMS_IDX,QHRS2002,ESTAB_DATA,COMMS2001,ESTAB_IDX,PVDF_WORK_DATA,QC_INDEX,QHRS91_DATA,COMMS91_IDX,PM_CONTACTS_INDEX,HHMASTER_IDX,QC_VIEWING_DATA,PVDF_REFDATA_IDX,PVDF,QHRS91_REFDATA_IDX,QHRS91_REFDATA, PM_CONTACTS_DATA, UNDOTBS, SMALL_TABLES, COMMS2002, COMMS2003, PVDF_VIEW_IDX, PROGS2002,PROGS_IDX,PVDF_VIEWING_DATA, COMMS2004, QC_REPORTS_DATA, COMMS_IDX_2002, COIN_STUDY_DATA, PVDF_WEIGHTS_DATA, PVDF_WEIGHTS_INDEX, PVDF_WORK_INDEX,COMMS2005) transport_full_check=Y directory=my_dir logfile=my_dir_log rem copy h:\oradata\live\*.* V:\H\ Then copy all the data files Once you have done this you use rman to do the convert the datafiles On 25/03/2008, Howard Latham <howard.latham@xxxxxxxxx> wrote: > > You transport the whole lot then it doesnt matter about self containment. > I will try and post my my script ! - pretty horrific ! > > On 25/03/2008, Sandra Becker <sbecker6925@xxxxxxxxx> wrote: > > > > I did a little more research on transportable tablespaces. Only two of > > my tablespaces are self-contained and they hold very little data so I don't > > think this is a viable option. Also the idea of upgrading then migrating > > has been nixed and will not be considered going forward for various reasons, > > none of which make sense to me at this point. > > > > Sandy > > > > On Tue, Mar 25, 2008 at 6:19 AM, Howard Latham <howard.latham@xxxxxxxxx> > > wrote: > > > > > For our 700gig database I used transportable tablespaces / datapump > > > from Windows nt to redhat. > > > Worked well once I got the strategy right. > > > In my experience get a spare box for a few practices. > > > > > > > > > > > -- > Howard A. Latham > -- Howard A. Latham