Creating Table in Oracle

[Naveen Kumar Srivastava]

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

[amitpatel66]

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.

[BMantri]

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

[Naveen Kumar Srivastava]

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.

[Naveen Kumar Srivastava]

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.

[Naveen Kumar Srivastava]

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.