OraFAQ Forum: Server Administration » Shorten the name....

Home » RDBMS Server » Server Administration » Shorten the name....

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shorten the name.... [message #371327]

Wed, 04 October 2000 03:37

Samuel
Messages: 17
Registered: September 2000

Junior Member

Hi,
I have a problem.
I delared a PK with more of 30 characters but oracle gave me the error number 00972.
I must declare this primary key with more 30 chars, how can i do?
thanks

Report message to a moderator

Re: Shorten the name.... [message #371341 is a reply to message #371327]

Thu, 05 October 2000 06:29

Andreas Pollmeier
Messages: 7
Registered: February 2000

Junior Member

Hi!

The errormessage for ORA-00972
is "identifier is too long".

Identifiers (tablenames, indexnames, ...) with
more than 30 character are not allowed.

Andreas

Report message to a moderator

Re: Shorten the name.... [message #371342 is a reply to message #371327]

Thu, 05 October 2000 06:32

John R
Messages: 156
Registered: March 2000

Senior Member

I'm afraid that you can't do it.
The maximum length for a constraint name (or any object name) is 30 characters.

Sorry

Report message to a moderator

Previous Topic:	Patch for 816 ? or upgrate to 817 ?
Next Topic:	using package dbms_standard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:57:29 CST 2024