Re: migration from access to oracle

From: sonika <sonika_sehrawat_at_yahoo.com>
Date: 24 May 2004 09:27:08 -0700
Message-ID: <709618ea.0405240827.2c286938_at_posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1085095550.302721_at_yasure>...
> sonika wrote:
>
> > Hey experts,
> >
> > Pls. help me here..i migrated successfully my database from access to
> > oracle..but in one of the access table..there is one memo field that
> > copied to oracle clob field..but my clob field is not containing full
> > material whatever is available in memo field..how can i copy my full
> > string from access memo field to oracle clob field.
> >
> > Thanks for your help.
> >
> > Appreciate any kind of help and suggestion.
> >
> > Thanks again..
> > sonika
>
> Not having a clue how you "migrated" I can only guess. And here's
> that guess.
>
> Your data contained carriage returns.
>
> Microsoft products are notorious for turning carriage returns into
> separate records during an export.
>
> What you are seeing is the string from the Access memo field prior
> to the first carriage return.
>
> Can you confirm this? And if this isn't the case we need to know a
> lot more about how you are stepping through moving the data. Tools,
> methodology, versions, etc.

Thanks Daniel,
But how i came to know that we used some carrige return in my access table.i know that if this 'Nonirrigated wheat field. Poorly and very poorly drained calcareous soil on sandy upland formed in moderately coarse to coarse textured deposits left by glacial melt water.' is in access and it show me only this 'Nonirrigated wheat field. Poorly and very poorly drained calcareous soil on san' one is oracle.And i am oracle 9i and microsoft access 98.
pls. suggest me something what should i do next.

Appreciate your help.

Thanks..sonika Received on Mon May 24 2004 - 18:27:08 CEST

Original text of this message