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

This article mainly explains "how to batch generate DDL script", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "how to batch generate DDL script" bar!

Get all the index scripts under the user to rebuild the index after data migration:

Set pagesize 0

Set long 90000

Set feedback off

Set echo off

Spool get_index_ddl.sql

SELECT to_char (DBMS_METADATA.GET_DDL ('INDEX',u.index_name)) | |' nologging'| | 'parallel 4' FROM USER_INDEXES u

Spool off

Get all the table scripts under the user:

Set pagesize 0

Set long 90000

Set feedback off

Set echo off

Spool get_index_ddl.sql

SELECT to_char (DBMS_METADATA.GET_DDL ('TABLE',u.table_name)) | |' nologging'| | 'parallel 4' FROM USER_TABLES u

Spool off

This method is only suitable for non-partitioned indexes, and if there are partitioned indexes, they should be handled separately.

Or use toad to export index creation statements directly

Thank you for reading, the above is the content of "how to generate DDL scripts in batches". After the study of this article, I believe you have a deeper understanding of how to generate DDL scripts in batches, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.