Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the method of Oracle 12c database expansion". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Prior to oracle 12c, the maximum field length for varchar2 and nvarchar2 data types was 4000. In version 12c, the maximum field length has been extended to 32767, or 32kb, and the parameter MAX_STRING_SIZE is the maximum length that controls the extended data type extended data type:

Standard: represents the length limit before 12c, that is, varchar2 and nvarchar2 4 are 4000 bytes,raw is 2000, and the system defaults to standard

Extended: represents the new feature of 12c 32k strings. The maximum length of varchar2, nvarchar2 and raw is 32767, namely 32kb.

By default, the database parameter max_string_size is standard, so you need to change the parameter value to extended. The specific steps for configuring the extended data type for the database are as follows:

1. Change the parameter MAX_STRING_SIZE to EXTENDED:

ALTER SYSTEM SET MAX_STRING_SIZE = EXTENDED SCOPE=SPFILE

two。 Close the database instance

Shutodnw immediate

PS: if it is RAC, you need to shut down all instances.

3. Start the database instance in upgrade mode:

Startup upgrade

4. Run the script:

SQL > @ $ORACLE_HOME/rdbms/admin/utl32k

5 > restart the database instance.

SQL > shu immediate; SQL > startup; "what is the method of Oracle 12c database extension" is introduced here, thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.