moving tables between schema
This is a discussion on moving tables between schema within the DB2 forums, part of the Database Server Software category; --> hi everyone..... Can anyone tell how to move tables between schemas.......... that is changing the schema name of the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:13 AM
| |||
| |||
 Re: moving tables between schema Gladiator wrote: > hi everyone..... > Can anyone tell how to move tables between > schemas.......... that is changing the schema name of the > table................ > > thanks in advance.... > Kamal Currently this is a seriously manual process (create new table and all related objects, move the data over) !!! But with V9 Viper you will have a command to move objects between schemas very easily. Phil      |
|
02-27-2008, 07:13 AM
| |||
| |||
| Re: moving tables between schema Philip Nelson wrote: > Gladiator wrote: > > > hi everyone..... > > Can anyone tell how to move tables between > > schemas.......... that is changing the schema name of the > > table................ > > > > thanks in advance.... > > Kamal > > Currently this is a seriously manual process (create new table and all > related objects, move the data over) !!! > > But with V9 Viper you will have a command to move objects between schemas > very easily. > > Phil Thanks a lot Philp........ |
|
02-27-2008, 07:13 AM
| |||
| |||
| Re: moving tables between schema You can use the Copy table feature in control center, but you have to do this for each table in the schema. Gladiator wrote: > Philip Nelson wrote: > > Gladiator wrote: > > > > > hi everyone..... > > > Can anyone tell how to move tables between > > > schemas.......... that is changing the schema name of the > > > table................ > > > > > > thanks in advance.... > > > Kamal > > > > Currently this is a seriously manual process (create new table and all > > related objects, move the data over) !!! > > > > But with V9 Viper you will have a command to move objects between schemas > > very easily. > > > > Phil > > > > Thanks a lot Philp........ |
|
02-27-2008, 07:14 AM
| ||||
| ||||
| Re: moving tables between schema I use db2move for this task. Use db2move to export your data. Then edit the db2move.lst file and replace the "source" schema name with the targe schema name. Then use db2move to import your data. Hope that helps.... -- Jayesh Gladiator wrote: > hi everyone..... > Can anyone tell how to move tables between > schemas.......... that is changing the schema name of the > table................ > > thanks in advance.... > Kamal |
Linear Mode
