Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Data transfer between two 8.1.6 databases

Re: Data transfer between two 8.1.6 databases

From: Gerald B. Rosenberg <gbr_at_newtechlaw.com>
Date: 09 Nov 2000 04:14:30 GMT
Message-ID: <MPG.1473c4857520d2709896c6@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
Received on Wed Nov 08 2000 - 22:14:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US