I see what is happening. the GUID columsn are really uniqueidentifier values.
the dbase driver doesnt recognize this and, since the test table is empty,
estimates varchar(8) as the most likely datatype. When I substitute
VarChar(50) for the GUID inthe create table statement, the destination table
builds correctly.
"Carl Henthorn" wrote:
Quote:
When I create a table in data pump, my source table has two guid columns that
are transformed into varchar(8) when the destination table is created. why is
this happening and how do I stop it?
thanks! this happens when I use dbase 4 and dbase 5 drivers. |