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: Copy data from one database instance to another on the same server

Re: Copy data from one database instance to another on the same server

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 2 Nov 2006 08:27:30 -0800
Message-ID: <1162484850.422762.81270@h48g2000cwc.googlegroups.com> 





Depending on the size of the tables, you could also create a DB link in
your Dev database pointing to the schema in the production database,
and then ...


small tables > create table abc as select * from abc_at_myprod;    or
large tables + 10g > datapump with db link



just 2 more ideals
Received on Thu Nov 02 2006 - 10:27:30 CST












Original text of this message













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