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: Export- Import

Re: Export- Import

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/01/15
Message-ID: <32DD927F.5CE8@dt.com.hk>#1/1

Venu Sripada wrote:
>
> 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.
 

> 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.

You can re-create your development database with same tablepace name as in production database, and the same or more space allocated to each tablespace in the development. Thus Your import procedure will be bot interrupted with your import parameters such as:

    ignore=y commit=y
 are correctly set.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049
Received on Wed Jan 15 1997 - 00:00:00 CST

Original text of this message

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