expdp and impdp
Hello,
I am dealing with table of some project migration process from dbserver1 on operating system OS1 to dbserver2 on operating system OS2.
The main challenges of this migration proces are:
1. Tables should be migrated every day because of testing period and possible adapting the applications
2. Central Point of the migration is one table that has
1 BLOB column
1 CLOB column
and rest of n standard structured columns
3. BLOBs and CLOBS are of course non-updatable ( once inserted application provides protection from update or delete ).
4. Standard structured columns are regularly updated .
The challenge is to provide migration process which will
- transfer structured columns for all rows of the table everyday
I am dealing with table of some project migration process from dbserver1 on operating system OS1 to dbserver2 on operating system OS2.
The main challenges of this migration proces are:
1. Tables should be migrated every day because of testing period and possible adapting the applications
2. Central Point of the migration is one table that has
1 BLOB column
1 CLOB column
and rest of n standard structured columns
3. BLOBs and CLOBS are of course non-updatable ( once inserted application provides protection from update or delete ).
4. Standard structured columns are regularly updated .
The challenge is to provide migration process which will
- transfer structured columns for all rows of the table everyday
0