Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to duplicate data.
If you're planning to refresh every night, why don't consider creating
snapshots...(!!!)
Pete Cruz wrote in message ...
>
>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 Tue Jun 16 1998 - 20:21:24 CDT