Company purchases the BPM SYSTEM at the time of deployment, software vendors didn't even think about after building the database directly using the SYSTEM table space, now with the development of the company, increase after developers very bad management, considering the application from the table space is separated, the design of application software provided no ER, how to separate the data table? Application of many tables are uncertain, there is a constraint, the index, import and export have failed several times! Can't, a great god to provide technical support,,, have intention to add WeChat: gt2390461568

CodePudding user response:

If an object is built in the system or sys and other users of the system, can't confirm application used by the object, then this separation will be very dangerous, there is a way to rough first distinguish: query dba_objects, view objects created fields, which apart from the system object,

But if the only table was built in the wrong table space, built in the SYSTEM tablespace, you can use a move action will be migrated to a new application exclusive table space, table, of course, a move after the need to rebuild these indexes on tables,

CodePudding user response:

This is not suitable for export import, can the table, the first sequence, modules, functions, processes, etc., generated script out
Under the new user synchronize the execution of the script, first get an empty library, and then do data migration

CodePudding user response:

New table space, and then migrate the data,

CodePudding user response:

This should be no big problem, in general, can consider to use logical method of data migration, of course, depending on the actual situation of your side, contact us if you need support

CodePudding user response:

reference 4 floor xifenfei response:

this should be the problem is not big, in general, can consider to use logical method of data migration, of course, depending on the actual situation of your side, contact us if you need to support

Finally, a great god long time no see, bubble.

CodePudding user response:

1, the establishment of the new table space, set up new users, the method of using the export import
2, use the statement by migration, table use move in tablespace, index using rebuild

 such as: select "alter table" | | table_name | | 'move in tablespace newtablespace; 'the from user_all_tables where tablespace_name=' SYSTEM 'and owner=' your users'; 
Select 'the alter index' | | index_name | | 'rebuild in tablespace newtablespace; 'the from user_indexes 
WHERE index_type='NORMAL' 
AND table_owner='your users';