Re: migration from access to oracle

sonika_sehrawat_at_yahoo.com (sonika) wrote in message news:<709618ea.0405240827.2c286938_at_posting.google.com>...
[Quoted] > 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

hey experts...

pls. suggest something ,i tried all my possible ways..pls. tell me how can i copy a long string that is in memo field of access to oracle. Appreciate any suggestion or help.

Thanks a lot..
sonika Received on Wed Jun 02 2004 - 19:15:40 CEST