Re: migration from access to oracle
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 02 Jun 2004 12:34:50 -0700
Message-ID: <1086204899.577997_at_yasure>
>>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1085095550.302721@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
Date: Wed, 02 Jun 2004 12:34:50 -0700
Message-ID: <1086204899.577997_at_yasure>
sonika wrote:
> sonika_sehrawat_at_yahoo.com (sonika) wrote in message news:<709618ea.0405240827.2c286938_at_posting.google.com>... >
>>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1085095550.302721@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
If it contains carriage returns the fields will need to be enclosed by double quotes or some other characters.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu [Quoted] (replace 'x' with a 'u' to reply)Received on Wed Jun 02 2004 - 21:34:50 CEST