ogr2ogr can not support the -append mode when import the normal dbf file to oracle

[tsingdong]

I use the shell:ogr2ogr -append -f OCI OCI:user/password@service C:\placename.dbf to import the placename dbf table into the Oracle,the first time it was success.but when i tried to import the other placename.dbf table of other data source.An error occured the system raise a ora-00955 exception. The org2ogr not support -append mode when import normal dbf file,any body can tell me?

tks!

[warmerdam]

Can you include the exact and complete error message produced by ogr2ogr?

Have you tried the -update switch to ogr2ogr indicating that an existing database should be opened instead of trying to create a new one?

[tsingdong]

ogr2ogr error when load dbf with -append mode

[tsingdong]

Replying to warmerdam:

Can you include the exact and complete error message produced by ogr2ogr?

Have you tried the -update switch to ogr2ogr indicating that an existing database should be opened instead of trying to create a new one?

I add a attachment file with the picture with the error message.

[warmerdam]

Reviewing the code, it appears likely that the PLACENAME table is not being treated as a layer when OGR opens the oracle database. In this situation an attempt will be made to create the table however the error messages indicates it already exists.

Does an ogrinfo on OCI:tsingdong/tsingdong@XE report the placename layer? If not, I wonder why not.

[tsingdong]

the ogrinfo result picture.

[tsingdong]

I added the ogrinfo result picture.

you're right the placename is not a ogr layer by the ogr2ogr load th e dbf file.It's the right result? it would changed in the feature or not?

tks!

[Even Rouault]

This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to ​https://github.com/OSGeo/gdal/issues if it is not already reported there.