Export- Import

From: Venu Sripada <venu.sripada_at_citicorp.com>
Date: 1997/01/09
Message-ID: <32D56B6C.3761@citicorp.com>#1/1

To Everyone: Please help

We have an overnight process where by :

1.Full export ( Oracle EXP )of production database is produced on production machine.

2.Export file is rcp-ed to development machine.
3.All application tables on development database are droped. 
4.All application tables are imported ( ORACLE IMP ) to development

database from production export file.
Thus, every day our developers have fresh data as of the end of previous business day.
The problem we run into is that some tables fail to import due to unavailability of large contigious extents. We try to create these tables after having droped them specifying storage parameters like ( initial and next sizes) . But problem occurs with another table.

Our environment is:
1. Production machine: Sun Solaris 2.4 ; Oracle rel. 7.1.6 2. Development machine: Sun OS 4.1.3; Oracle rel. 7.1.6

Is there better way to achive out goal of providing backup copy of prodn. data ( also the flexibility of refreshing individual tables)

thanks in advance

Venu
Citibank. Received on Thu Jan 09 1997 - 00:00:00 CST