Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export- Import
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 3049Received on Wed Jan 15 1997 - 00:00:00 CST