This two days send application error found that table space is full, the check found that table in the table space when set wrong, now want to put the table in the table space change (table has a large amount of data), please replace table table space for the application and data what is the effect? Existing data before? The trouble, help solve,

CodePudding user response:

This depends on your business can't stop, can how long downtime, etc.,

CodePudding user response:

Migration of table table space for data without any influence, just on the table all the index will be failure, to rebuild, can in the slack period of business operation, the migration test before how long will it take to get the dimension table migration

CodePudding user response:

Look at your watch application structure, partition table (since the extended partition), to specify the tablespace, and the original data table space, new data is written directly to the new table space, if want to old table space partition transferred to the new table space, this is going to use the move statement, indexing requires to be rebuilt,

CodePudding user response:

Bosses using alter tablename move tablespacename this statement to change table in the table space is only after the data will be in the presence of a new table space or data may also be the presence of a new table space before? There is always this statement whether you need to stop don't let data writing? Would you please bosses to solve it?

CodePudding user response:

reference 4 floor qq_39776397 response:

bosses using alter tablename move tablespacename this statement to change table in the table space is only after the data is in the presence of a new table space or data may also be the presence of a new table space before? There is always this statement whether you need to stop don't let data writing? Would you please bosses to solve it?

this migration means changing tables belonging to a table space, the data must be in the new table space, and is sure there is no downtime, said the process must be locked not any operation, and it is easy to understand, if you don't lock the table which is how to determine the new data into the table space?

CodePudding user response:

2 l said outage is to stop your business read and write operations on the table

CodePudding user response:

Understand, thank you for your bosses

CodePudding user response:

Table space full of datafile, why must change table space?

CodePudding user response:

Best if you can stop, move or expdp impdp data migration to the new table space, if you don't stop, can only look to whether can clear the invalid data