Re: Errors in importing the production dump to the test database

From: <zoaibs_at_my-dejanews.com>
Date: Thu, 31 Dec 1998 07:53:24 GMT
Message-ID: <76fahk$7fo$1@nnrp1.dejanews.com>

In article <756045$bjv$1_at_nnrp1.dejanews.com>, bm2208_at_my-dejanews.com wrote:
> HI All
> Can somebody help me out by clarifying these..
>
> 1.When i am importing to Oracle 8.0 on NT i am getting initial extent problem
> for some tables,indexes and some tables with prefix EVT, SMP &S%..(not sure
> what's the use of these tables and is there any way to avoid these in case of
> no use) though the data is not much
>
> 2.Is there any way to change the storage parameters while exporting from
> production database with larger extents to test database with smaller
> extents..
>
> Thanks in advance
> Madhukar Rao
> m-rao_at_mailcity.com
>

These EVT and SMP tables are all Performance Monitor tables; You can drop these tables or may choose not to export these tables at all; 2. While exporting, the parameter COMPRESS defines whether to compress the tabledata into one extent or not; The default value is Y, which means compress the table contents into one extent and modify the table definition into the exported dump to have the INITIAL equal to the size of the table data; Very helpfull indeed to have all the data as contigous chunk in one extent; So you may choose perform follwoing steps: 1. exp with COMPRESS=N 2. Imp but with ROWS=N; this will create all the tables structures; 3. Imp with ROWS=Y INDEXES=N

Cheers
exp

> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 31 1998 - 01:53:24 CST