Re: Data transfer between two 8.1.6 databases

Well, the documentation for 8.1.6 discusses it at the level of philosophical principle in the Oracle concepts manual (technet.oracle.com has it if you do a search for "TransportableTablespace" -find the section headed "Moving or Copying a Tablespace to Another Database), and the Administrator's Guide has all the specifics on how to do it (under the heading "Transporting Tablespaces Between Databases").

On my own website, the DBA Course slides has a chapter on Export and Import (Chapter 15 from memory) which touches on the Transportable Tablespace option, and there's equally a slide or two in the Backup and Recovery course slides.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"Gerald B. Rosenberg" <gbr_at_newtechlaw.com> wrote in message
news:MPG.1473c4857520d2709896c6_at_news.concentric.net...


> In article <3a07fedd_at_news.iprimus.com.au>, howardjr_at_www.com says...

> > Given that you are on 8.1.6, have you considered transportable

 tablespaces?


> >

> > Brilliant idea; you simply do an o/s copy of the relavant datafiles, and

> > 'plug them in' to the destination database by doing a quick import of

 the


> > tablespaces metadata, previously prepared by doing a tablespace-level

> > export.  transportable_tablespace=y and tablespaces=(xxx, yyy,...) are

 the


> > key parameters, on both sides of the equation.

> >

>


> Is there a discussion and procedures for doing this somewhere in the

> Oracle documentation?  Didn't see it (or recognize it) in the discussion

> of backup options.  Or is there a site or other source of information

> taht discusses this option.

>


> Thanks,

> Gerald

> --

> Gerald B. Rosenberg

> NewTechLaw