|
Hi Vinesh
This is an Oracle error, nothing to do with FME and
there's nothing you can do about it except reduce the length of you table name
before translation is started
There is a way of avoiding this and that's to
create the oracle destination table before hand and then when doing the mapping
click on the "Import Feature Type Definitions" and then this will allow you to
map to that destination table.
If you don't want to do this then you're going to
have to reduce the length of the destination table name in work bench, this is
done by clicking on the 3 dot box in the top right hand side of the destination
type box, and modifying the Feature Type Name to be less than 30
characters.
This is what Oracle have in their manual about the
error
ORA-00972 identifier is too long
Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames. Action: Shorten the name to 30 characters or less. I suppose something could be built into FME so if you are loading Oracle tables and the destination feature type name is more than 30 characters then some sort of warning could appear but this already happens when the translation falls over (generally very quickly), maybe Safe would wish to comment here. For me I generally make sure the destination table is already created, only because I prefer to see the geometry column name as GEOMETRY and not GEOM, but sometimes I want FME to create the table, if this is the case I then check the table name is less than 30 characters and that's the only way around it. Mark
***************************************************
Mark Brighton CIS Business Solutions Bridgwater 724 4801 01278 484801 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 13 December 2005 12:41:53 >>> FME Workbench Users I am doing some translation from MapInfo TAB format to Oracle Spatial (10g) format tables. I am getting the Oracle error: "ORA-00972: identifier is too long" As I understand it, this means that the length of my source file is exceeding 30 characters. Is there any way of preserving the length of my source file, rather than having to drop the file name to shorter than 30 characters? Thanks. Vinesh _______________________________________________________________________ Leicestershire County Council - rated an 'excellent' council by the Audit Commission _______________________________________________________________________
This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000.
The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council.
Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment.
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. YAHOO! GROUPS LINKS
|
- [fme] Too long file name Vinesh Govind
- Re: [fme] Too long file name Mark Brighton
