Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data transfer between two 8.1.6 databases
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 NewTechLawReceived on Wed Nov 08 2000 - 22:14:30 CST