Uwe, If you're using your own DDL to create those tables, there's an easy way around that limitation -- just put your table names in double quotes. You can put pretty much anything in a table name that way. Stefan ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= 2010/11/4 Uwe Küchler <uwe@xxxxxxxxxxxx> > Hello Niall, > > you mean the hyphen character in the host name? I thought so, too and tried > to find some documentation or other pointers to support my thoughts - > especially when trying to argue with Ops. But so far I haven't found > anything on MOS that goes like "don't use hyphens in hostnames". > > The only trouble we have so far is our own admin tool (DB with APEX), that > cannot create tables using the host name when there's a hyphen in it (not > allowed for Oracle object names). > > > Best regards, > Uwe > > > > Am 03.11.2010 19:35, schrieb Niall Litchfield: > > The hyphen character may be problematic here. It certainly is for db links > and db domains. > > On 3 Nov 2010 16:05, "Uwe Küchler" <uwe@xxxxxxxxxxxx> wrote: > > Hi Dick, > > that idea is not too bad. > Finally, my Ops folks decided to rename the servers using a simple naming > scheme that constrains names to 8 characters. The nuisance is that with > prefix and suffix (when clustered) only 3 to 5 characters remain to > distinguish the server. > > BTW: Do you (or anyone here) know if this issue is solved in 11gR2? MOS > documents only say that the issue pertains to all releases up to 11.1, but > no document says if this got fixed in 11.2... > > And, last but not least, here's a small test case to show that this > problem isn't strictly academic. I used utl_inaddr to resolve the server's > IP address: > > $ uname -n > xx-myserver > > SQL> select sys.utl_inaddr.get_host_address() from dual; > select sys.utl_inaddr.get_host_address() from dual > * > ERROR in line 1: > ORA-29257: host xx-myser unknown > ORA-06512: at "SYS.UTL_INADDR", line 19 > ORA-06512: at "SYS.UTL_INADDR", line 40 > ORA-06512: at line 1 > > > > Have a nice day, > Uwe > > Am Di, 2.11.2010, 20:55, schrieb Goulet, Richard: > > > Uwe, > > > > Our host names are something like 'US-BOS-DB999.na.pxl.int' which > > obviously exceeds th... > > >