Oracle common table transformation component area table?-CodePudding

Oracle11g environment: the user YY01 partition table TAB_INFO
User YY02 regular tables TAB_INFO
Excuse me what method can be regular tables of YY02 TAB_INFO into and partition table TAB_INFO YY01 users?
A friend made similar operation or have any recommendations?

CodePudding user response:

Reference: http://www.2cto.com/database/201511/448647.html

CodePudding user response:

1, this form in the YY2, transferred to YY1 the user, such as use CTAS methods;
2, and then use the alter table t exchange syntax, it is ok to

PS: pay attention to the table shall be the same structure

CodePudding user response:

reference 1st floor ghx287524027 response:

reference: http://www.2cto.com/database/201511/448647.html

Hello, thank you for your answer!
Before this I saw, I also operating overweight define the table method, successful transformation in the same database under the same user manual test, but because we need to realize automatic transform ordinary table partition table, and the partition table and regular tables respectively in the two databases, but two database environment is the same, namely user, tables, table structure for objects,
In the two tables in the database, using redefines table feel not achieve them, because my knowledge is not enough wide, at present our environment, there are ways to realize automatic conversion?

CodePudding user response:

Can consider to partition switching technology

CodePudding user response:

reference qq_35165999 reply: 3/f

Quote: refer to 1st floor ghx287524027 response:

Reference: http://www.2cto.com/database/201511/448647.html

Hello, thank you for your answer!
Before this I saw, I also operating overweight define the table method, successful transformation in the same database under the same user manual test, but because we need to realize automatic transform ordinary table partition table, and the partition table and regular tables respectively in the two databases, but two database environment is the same, namely user, tables, table structure for objects,
In the two tables in the database, using redefines table feel not achieve them, because my knowledge is not enough wide, at present our environment, there are ways to realize automatic conversion?

Online redefinition is the automatic conversion of the composition table, do not need to stop business,