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: How to duplicate data.

Re: How to duplicate data.

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 20:14:22 -0400
Message-ID: <6n9akn$dpg@bgtnsc01.worldnet.att.net>


Try using export/import.

Pete Cruz wrote:

> I have a production and development server running Oracle 7.3.3 on both.
>
> How can I duplicate data entered into production, into the development
> instance, this process can be run at night. I have tried running an SQL
> to copy the data. The problem is several tables have long (diary) fields
> and do not get copied.
>
> I have made a few attempts using the copy command but have not been
> successful.
>
> Thanks for any suggestions.
> --
>
> Pete Cruz
> petec_at_eden.com
Received on Mon Jun 29 1998 - 19:14:22 CDT

Original text of this message

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