By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,854 Members | 876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,854 IT Pros & Developers. It's quick & easy.

Creating Table in Oracle

P: 17
Hi to All

I want to create a table in oracle having name more than 16 character how i can?

I know that oracle support table namt upto 28 character by default it support 15 character but i don't know how to change size.

If any one know please reply me.

Thanks
Apr 17 '08 #1
Share this Question
Share on Google+
5 Replies


amitpatel66
Expert 100+
P: 2,367
Hi to All

I want to create a table in oracle having name more than 16 character how i can?

I know that oracle support table namt upto 28 character by default it support 15 character but i don't know how to change size.

If any one know please reply me.

Thanks
You can create a table with name of lengh 30 charcaters or less in 9i version. Which version of oracle you are using?

You can use CREATE STATEMENT to create a table.Try creating for length of 16 and post if it errors out.
Apr 17 '08 #2

P: 7
Hello,
SQL> create table testtesttesttesttesttesttest(name varchar2(10));

Table created.

There is no issue if you put the name of the identifier less than or equal to 30 character.

I am using the oracle version as
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production



Please specify your oracle version by

select * from v$version;


Regards,
BMantri
Apr 22 '08 #3

P: 17
You can create a table with name of lengh 30 charcaters or less in 9i version. Which version of oracle you are using?

You can use CREATE STATEMENT to create a table.Try creating for length of 16 and post if it errors out.

Thanks for reply

Actually i am doing R&D in oracle i dont know what i do but the table max length character is set to 15 Whenever i create the table it will truncated to 15 character . how i increase the max lenght.
Apr 25 '08 #4

P: 17
You can create a table with name of lengh 30 charcaters or less in 9i version. Which version of oracle you are using?

You can use CREATE STATEMENT to create a table.Try creating for length of 16 and post if it errors out.
I am doing R&D in oracle 10g .and i donot know what i do the default length of the table will set to 15 character when i create the table it will truncate to 15 character .
I want to know how to set default length of oracle table name.
Apr 25 '08 #5

P: 17
Hello,
SQL> create table testtesttesttesttesttesttest(name varchar2(10));

Table created.

There is no issue if you put the name of the identifier less than or equal to 30 character.

I am using the oracle version as
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production



Please specify your oracle version by

select * from v$version;


Regards,
BMantri



I am doing R&D in oracle 10g .and i donot know what i do the default length of the table will set to 15 character when i create the table it will truncate to 15 character .
I want to know how to set default length of oracle table name.
Apr 25 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.