topic Re: Copy/Paste from a File GDB to Oracle in ArcGIS Pro Questions

Copy/Paste from a File GDB to Oracle

rbae — Mon, 15 Aug 2016 06:07:27 GMT

I'm doing a simple copy/paste of a feature dataset from a file geodatabase into an Oracle SDE database. The process appends the name of the feature dataset to all of the feature classes.

Is there a reason why this functionality was added? As soon as the combination of feature dataset + feature class exceeds 30 characters, the load of the data into Oracle fails.

Re: Copy/Paste from a File GDB to Oracle

DanPatterson_Retired — Mon, 15 Aug 2016 09:27:40 GMT

seem 30 is a popular limit with Oracle

Re: Copy/Paste from a File GDB to Oracle

rbae — Sun, 21 Aug 2016 00:00:20 GMT

The question was not regarding the limit in Oracle, but the fact that ArcGIS Pro appends the feature dataset name to the feature class, resulting in a name that exceeds the 30 character limit.

Re: Copy/Paste from a File GDB to Oracle

DanPatterson_Retired — Sun, 21 Aug 2016 02:36:13 GMT

Not sure, both map and pro are mute on the topic. Perhaps it is because duplicate feature class names need a modifier. I don't use that type of data storage so you would best contact tech support since it has been almost a week. I assume that copy and paste has been ruled out as the addition and that this is just common behaviour. The obvious advise that will be given to you is to shorten names to fit in the 30 char compliance range. I can't find any complaints on this limit, so perhaps the need for longer names is in limited demand. I couldn't even find anything on ArcGIS Ideas so good luck and report back if you get any info.

Re: Copy/Paste from a File GDB to Oracle

JoshuaBixby — Mon, 22 Aug 2016 12:51:14 GMT

Are you copying and pasting an item from within the feature dataset or the entire feature dataset? What is the behavior in ArcMap/ArcCatalog? Have you tried using any of the geoprocessing tools instead of copy and paste?

Re: Copy/Paste from a File GDB to Oracle

Anonymous User — Mon, 22 Aug 2016 14:24:02 GMT

Hello ,

You can use
import operation after making connection to your oracle DB with write permission.

Then use your FGDB data to import.

or directly copy data from FGDB and copy to oracle DB collection.

In data management tool also have tool which is use to copy data from one DB to another DB.

Thanks.