I am migrating from sybase 12.5.1 to oracle 10.g using .CSV files. One particular column has huge clob data with lot of xml content etc.That column was not migrated properly.When i see .CSV file it only has part like half of the column data like part of the XML content,not all cells present etc. I heard clob data has limitation of 4000 bytes only. is there is limitation on how much data we can migrate between sybase columns through csv into oracle database columns. Is there is a way i can increase clob data column size in oracle etc to hold entire data.Any ideas links resources greatly appreciated. thanks in advance.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I was trying to use bcp out option through dos prompt after logging in to sybase 10.5.0 database as
isql -Uxyz -xyz
password:xyz1
use database name
then
go
then giving command
bcp mydb..mytable out somefile.txt -Ssomeserver -Usomeuser -Psomepassword -c
It is not working for some reason.
It is saying incorrrect syntax at '.'.
Can someone please send me the exact syntax for this bcp to work or missing piece in this puzzle.Thanks in advance.
No, no. You need to look at theUtility Guide for command syntax.
Just like isql is a program, run from the DOS prompt:
isql -U... -P...
(then SQL commands)
bcp is a program, run from the DOS prompt:
bcp dbname..tablename out datafilename -U... -P... -T... -c
to get the value you need to use for the -T parameter, use isql and inspect the table
No, no. You need to look at theUtility Guide for command syntax.
Just like isql is a program, run from the DOS prompt:
isql -U... -P...
(then SQL commands)
bcp is a program, run from the DOS prompt:
bcp dbname..tablename out datafilename -U... -P... -T... -c
to get the value you need to use for the -T parameter, use isql and inspect the table
Business Accounts
Answer for Membership
by: IncisiveOnePosted on 2008-12-02 at 21:36:05ID: 23083483
We do not have clobs, blobs, boobs, etc in Sybase, we have text and image. You are not unloading clobs or bobs, you are unloading text or image. What you are loading into is (your choice) in Oracle.In technical work, it is important o be precise.
You have posted three questions about one and the same problem, but you are not listening. You need to unload the Sybase tables via bcp-out NOT any other facility, which has its limitations. You are getting stuckon these limitations. Sybase has no limitation when using the native utilities, drivers, etc.
Use bcp-out.
2 It has a DEFAULT of 32k for image and text columns.
3 find out the size of your text/image columns, do this for ALL text/image columns:
$ isql ...
> SELECT MAX(DATALENGTH(text_col) ) FROM table
now you have the max size of the column
4 for each table with a text/image column:
$ bcp -U -P -S -T<max_col_size_for_this_t
That will give you a csv file for each table containing the full text/image column.