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: Errors in importing the production dump to the test database

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

From: MotoX <noone_at_nowhere.com>
Date: Tue, 15 Dec 1998 20:32:20 GMT
Message-ID: <3678c72c.1313205@news.demon.co.uk>


You might want to re-export with COMPRESS=N, so you don't get such large initial extents when you try to import.

MotoX.

On Tue, 15 Dec 1998 15:44:06 GMT, 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
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 15 1998 - 14:32:20 CST

Original text of this message

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