Shulou(Shulou.com)06/01 Report--

This article mainly explains "how tomcat cannot publish the program due to incomplete database table export", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "What to do if tomcat cannot publish the program due to incomplete database table export"!

[org.springframework.jdbc.support. SQLErorCodesFactory]-SQLErorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]

It is found that the database tables and programs are not related. Compared with the development library and the production library, it is found that the number of user tables is inconsistent. The development library has nearly 10 tables more than the production library.

Ask the person who inverted the warehouse, indicating that there is no error reported when exporting. A flash of inspiration, 11g's deferred_segment_creation attribute, after checking it out, this problem is solved after re-exporting and importing.

Inform all operators that after the stock transfer is completed

[oracle@vm51 ~]$ sqlplus Business User/Password

SQL> select count(*) from user_tables;

Check if the number of tables in the source and target libraries is the same

New feature in 11G, when the table has no data, do not allocate segments to save space

Solution:

Insert data into an empty table, and then rollback to generate a segment. Empty tables can be exported when exporting. Too much trouble.

2. Set the parameter deferred_segment_creation

alter system set deferred_segment_creation=false;

This parameter value defaults to TRUE, and when it is changed to FALSE, segment is assigned regardless of whether the table is empty or not.

Note that after this value is set, it has no effect on the previously imported empty tables, and cannot be exported. It can only affect the newly added tables.

If you want to export the previous empty table and enter the business user, use the following sentence to find the empty table under the user.

select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0

Export the query results and execute the exported statements.

At this point, I believe that we have a deeper understanding of "how tomcat cannot publish programs due to incomplete database table export", so we may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

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.