-
Max Number Character Allow On 9i
Hi all,
on 8i , the max number character on table and columns are 30 characters??? What about 9i ??? has it been changed??? or it's still the same ???
Thanks
-
this kind of question are answered perfectly in tahiti.oracle.com
RTFM
-
Pando,
always appreciate for all the help you have provided in this forum. I was pretty know the max is 30 characters but I have to prove this to my manager so that I need some documentation to support this.
I have look into metalink and tahiti.oracle.com but I didn't see any valid point to support this. Would you please let me know what should I look for ???
thanks
-
Here's the proof:
SQL> create table this_table_name_has_31_charactr (col1 number)
create table this_table_name_has_31_charactr (col1 number)
*
ERROR at line 1:
ORA-00972: identifier is too long
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
-
As I mentioned earlier. I did the same thing here. I guess what I am looking for here is the documentation.
-
tahiti.oracle.com
I found it in 3 minutes...
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|