Re: data migration question

From: Ilya Shambat <ishambat_at_aol.com>
Date: 31 May 2002 09:49:53 -0700
Message-ID: <d02408fc.0205310849.59ca03b5_at_posting.google.com>


Vissuyk_at_yahoo.com (Vissu) wrote in message news:<16b21687.0205301815.5f02c1c3_at_posting.google.com>...
> Hi All,
>
> I have to migrate data from an older instance to 9i. As part of this
> process, I am thinking of shrinking the sizes of some columns
> (currently allocated at 2K will be reduced to 128B).
>
> Can I use export/import mechanism import into 9i ?. I will make sure
> that the resized columns will accomodate existing data. Will this
> cause an problem during import ?. Will the import script notice that
> the column has been shrunk (although data fits) and gives an error ?
> What if I decide to drop a column in the new instance ?

I do not think that there will be any problems with this. Go ahead and do it. Received on Fri May 31 2002 - 18:49:53 CEST

Original text of this message