CODEWITHSUNDEEP
databaseoracle-databasems-accessdata-migration
AverageMarcus
AverageMarcus

Reputation: 903

Trouble using MS Access to migrate data between Oracle databases that contain blobs

Im currently trying to move data from three old database schemas into one new one. I have been doing this using MS Access's append query function.

Everything has gone pretty smoothly until I tried to move across data that contained Blobs. Oracle returns a 'ORA-01008: not all variables bound' error. I have tracked this down to an error in the blobs as it works fine if I remove those columns from the query.

Does anyone know why this happens or how to overcome it?

Upvotes: 0

Views: 263

Answers (1)

tsells
tsells

Reputation: 2771

Why don't you just do it on the server?

Without testing this (forgive the syntax errors)

While connected to the target schema

insert into tablename select from SourceSchemaName1.TableName;
insert into tablename select from SourceSchemaName2.TableName;
insert into tablename select from SourceSchemaName3.TableName;

http://psoug.org/reference/insert.html

Upvotes: 1

Related Questions